Net Cash Flow Report

Company Profile

Owner and Operator of Commercial and Multifamily Portfolios (more than 8,000 leases)

Business Challenge

The management team wanted to keep a close eye on Net Cash Flow for each property and groups of properties. Manually compiling the Net Cash Flow for almost 100 properties was too labor-intensive and rigid.

Solution

Metric-X automated the calculation and display of the Net Cash Flow report.

With filters provided, the report could be quickly displayed for any property and for any time period.

The report data is refreshed weekly, and the report is displayed on a web page that authorized users can log in to and view.

Components of Net Cash Flow

1. Total Income
2. Total Expense
3. Net Bad Debt
4. NOI
5. Replacements
6. Non-Operating Income
7. One-Time Expenses
8. Total Corporate Expenses
9. Mortgage
10. Escrow Replacements
11. Investor Distributions
12. Net Cash Flow

Benefits

Automating the calculations and displaying them in an interactive format provided the following benefits:

• Management team can view up-to-date information and take corrective action faster
• Finance team’s time is freed up from having to manually compile the report and maintain 50+ spreadsheets
• Ratios can be computed and benchmarking performed
• The data can be visualized as charts showing trends, peaks and valleys
• Properties can be rolled up into groups with only a few clicks
• The data is more secure and controlled because it flows directly from the property management system into the SQL database (no intermediate Excel files!)

Tools

1. Tableau
2. SQL 
3. RentViewer API Connectors
4. Rent Manager Property Management System