Introduction In commercial real estate (CRE), financial forecasting is the backbone of strategic...
Budget Bytes – Cash Flow Analysis Report
Monthly cash flow and monthly cash balance usually sit in separate reports. The Cash Flow Analysis report in Portfolios shows them side by side, calculates debt service coverage, and breaks costs down by cost center. Robert walks through running it and opening the Excel download.
The report shows monthly cash flow and monthly cash balance together, calculates your debt service coverage ratio, and breaks individual cost centers down in more detail inside the ZIP file.
If the numbers don’t show up in Excel
Depending on your Excel settings, the second tab may open empty. Click Enable Editing and the numbers fill in.
Find more short how-to videos on the Budget Bytes page.