Property Cash Flow

Note: To be able to edit other categories in the cash flow table, be sure to set your Expense Source to Manual.

Creating a New Cash Flow Scenario (Document Upload)

Creating a new Cash Flow scenario through the Document Upload Center allows you to skip many of the above steps. Simply open the Doc Upload Center modal at the bottom of the Deal Page and upload a Collateral P&L using the blue “Upload” button. 

Blooma will then parse the appropriate information from your document, and you will receive a notification when your P&L data has been entered and your cash flow scenario has been created. Documents must be uploaded one at a time and you can edit and view your data in the Cash Flow Section. 

Note: Cash Flow start and end dates are required upon creation, if an uploaded document doesn't have any dates that can be parsed, the system will use date of upload.

Duplicating a Cash Flow

Once you’ve created a scenario, either manually or by uploading documents, you can duplicate any of the scenarios you’ve created! Navigate to the Property Cash Flow section and click “Add New Cash Flow” where you will be given the option to create a new Cash Flow, or to duplicate an already existing scenario. Once it’s been duplicated you can edit as if it were a brand new scenario.

Edit Cash Flow

In both scenarios for creating cash flows, once the P&L is uploaded users have the ability to change the cash flow data to their preference. Navigate to the Cash Flow section and click “Edit” to edit your expenses manually using the dropdown menu in the Description column. Edit the line item’s category, description, and amount to reflect your data accurately. From the edit page you can also set cash flow as primary, select cash flow type, select time period, and select sources for revenue, vacancy, etc. 

Note: In order to edit the Cash Flow section, expenses must be set to 'Manual' in the 'Edit Cash Flow' section. 

Select Rent Roll as Income Source for Cash Flow Scenario

When creating and adjusting cash flow scenarios in the Cash Flow section, select data from any Rent Roll within the Deal to populate the income of any cash flow scenario. Open the Deal and go to Cash Flow Section. Select the scenario and click “Edit” to view the revenue drop-down selections under “Select Source for Income” in the Cash Flow section. From here click “Selected Rent Roll” which will open a dropdown where you can select which rent roll's data you would like to bring in. 

Auto-Standardized Line Items

Once an underwriting scenario has been created, users can organize their cash flow line items to their company’s standard. To do so, navigate to the relevant Cash Flow tab and click “Edit". Blooma will automatically standardize your line items to your company's standard upon creation, any unstandardized values can be left as-is or standardized for future placement. So if a description is not part of the existing database, select from the picklist values to choose one of the standard descriptions. Over time, your selections will be added to your database for future use. View and edit the suggestions and click ‘Save’ when you’re satisfied with the results. Note: Blooma will combine line items with identical descriptions and display the aggregated sum.

Clicking the “+” sign on a standardized row expands vertically to show previously-hidden child rows that display the original line item descriptions (in the description column) along with the value, unit of measure, and annual values. Users can then click the “-” sign on the top-level standardized description row to collapse the child rows.

Compare and Edit Cash Flow Scenarios

To compare Cash Flow data simply navigate to the Deal Page and click “Cash Flow”. From there, if you have more than one scenario, you can click “Compare” to see multiple scenarios side by side. It may be helpful to fully standardize the Cash Flows prior to comparing. The compare view will be much more organized if the un-standardized line items are the same across different scenarios. 

Once you click compare, you’ll have to choose which scenarios you would like to compare, and how to display the amounts from the drop down menus at the top of the modal. You can compare any assortment of scenarios that have been created within your Deal! Note: Select the cash flows in the order you want them to appear.

“Compare Between” Dropdown:

• Select and manage which cashflows to compare
• Shows live count (e.g. “Selected (3)”)
• Primary cashflow is labeled “(primary)”

“Display Amounts As” Dropdown:

• Allows you to choose how values are displayed:
  • Gross Amount (default)
  • Amount Per SF
  • Amount Per Unit

Edit Values Directly:

• Clicking the pencil icon next to a scenario will allow you to make changes to any editable fields directly within the Compare view
• All standardized rows auto-expand when editing

 

 

View and Edit Discounted Cash Flow

View and edit DCF models for each cashflow present in your Deal. Navigate to the Cash Flow Section and click the three dot menu, then click “View DCF” to open. From there you can click “Edit DCF Model” to alter the Discount Rate as well as the Revenue and Expense Growth Rate for each year.

 

 

Create Combined Cash Flows and T-12's

Create Trailing 12s and other cash flow scenarios within the Blooma Cash Flow section. When you have two or more cash flows present, click “Create Combined Cash Flow”. This will open a modal where you can select which cash flows you would like to combine, subtract, or annualize (multiply). Here you can create custom cash flows as well as assign Cash Flow name, type, start and end date, as well as cap rate. Once you click “Save” your combined Cash Flow will be available in the Cash Flow Section alongside any other statements you have uploaded.

 

 

Add Comments on Cash Flows

Add comments to any cash flow during your analysis. Navigate to the Cash Flow Section and click the icon shown below under the scenario you would like to add a comment to. Add comments to add context about the sources of data for the cash flow, assumptions made in the scenario, or the use of the cash flow in underwriting analysis. Once you’ve added your comment, click “Save” to confirm your comment saves.

 

Archive a Cash Flow

To archive a cash flow scenario, go to the Cash Flow Section, click the three dots next to a scenario, and select Archive. The cash flow will move to the Archived section.

Note: Cloning an archived scenario does not archive the new copy.