Multi-Unit Pro Forma
A multi-unit pro forma is your roadmap to evaluating the financial potential of a multi-unit property. Here’s a quick guide:
Input Key Details: Enter property info like unit mix, rent per unit, purchase price, financing terms, and estimated costs for construction or renovation.
Estimate Revenue: Calculate gross rental income and any additional income streams (parking, storage, etc.).
Calculate Expenses: Input operating costs—property management, maintenance, utilities, and a vacancy allowance.
Determine NOI: Subtract expenses from revenue to get your Net Operating Income (NOI).
Factor in Debt Service: Subtract mortgage payments from NOI to find your cash flow after financing.
Assess Profitability: Use metrics like Cap Rate, Cash-on-Cash Return, and IRR to gauge the investment's potential.
Run Scenarios: Adjust variables to see how changes affect profitability, and include exit strategies to forecast returns.
Regularly Update: Keep your pro forma current with real numbers to ensure accurate financial insights.
A well-crafted pro forma helps you make informed investment decisions, optimizing your multi-unit property’s profitability.
Description
Analyze 2 to 5 unit multifamily deals. NOI, cap rate, cash-on-cash return, and debt coverage. Built for BRRRR and buy-and-hold strategy.
Includes integrated rent roll to track all tenants, leases, rents, and payment history in one clean sheet. Essential for any landlord managing two or more units.
How to Use:
How to use it:
- All blue gold are input fields — enter your numbers here
- All other cells are protected formulas — do not attempt to edit them
- Work from top to bottom for the most accurate results
Using in Microsoft Excel: Open the file and start entering your numbers in the yellow input cells. Save a copy to your computer before editing so you always have a clean original.
Using in Google Sheets:
- Go to drive.google.com
- Click New → File Upload → select this file
- Once uploaded, right click the file → Open With → Google Sheets
- Go to File → Make a Copy — work from the copy, not the original
- Your original stays clean and reusable for every new deal
This template is reusable: Every time you analyze a new deal, go back to your saved original and make a fresh copy. Your numbers never carry over — every analysis starts clean.
Questions? Book a strategy session at kellsellsfl.com
