A multifamily proforma is the financial spine of an acquisition decision. It takes a rent roll, a trailing expense history, and a set of assumptions, then produces the numbers an investment committee actually argues about: projected cash flow and returns. Building one from scratch is less about spreadsheet skill than about sequencing. Get the module order right and the model stays auditable. Get it wrong and every assumption downstream inherits the error.
What a Multifamily Proforma Actually Does
A proforma is a projection, not a record. The trailing twelve months tell you what a property has done. The proforma tells you what it should do once your business plan is applied. That distinction matters because the gap between the two is the entire investment thesis. Most builds follow a predictable path: enter the deal data, load a rent roll and operating expenses, analyze the property as it stands, compare rent comps, then set proforma rents and let the model roll forward. That four step flow, described by IntellCRE, is the skeleton every proforma shares.
The 11 Modules of a Multifamily Proforma
Most institutional models break into the same eleven functional blocks. The names change between shops, but the logic does not.
1. Deal Assumptions and Timeline
The deal assumptions and timeline module is the control panel for a multifamily proforma. Purchase terms, closing costs, unit count, acquisition date, hold period, and the decision of whether the plan is a stabilized hold or a renovation and repositioning. IntellCRE's build sequence starts exactly here with basic deal data entry, and for good reason. Every downstream module pulls from these inputs, so a typo in the hold period contaminates ten other tabs.
2. Unit Mix and Rent Roll
The rent roll is the source of truth for in place income. Group units by type, capture current rents, occupancy status, lease start and end dates, concessions, and delinquencies. This module should be traceable back to the raw file the property manager provided. Uploading the rent roll and expenses early, as IntellCRE describes in step two, keeps the model tied to actual documents rather than someone's memory of them.
3. Proforma Rents and Rent Growth
In the proforma rents and rent growth module, you decide what each unit will earn. Market rents, loss to lease, renewal versus new lease spreads, and annual growth assumptions all live here. Comparing rent comps and setting proforma rents is a distinct step in the IntellCRE workflow, and it deserves its own module. If your growth assumption is buried inside a revenue formula, no reviewer can find it, and no one can stress test it.
4. Other Income
Parking, pet fees, laundry, storage, utility reimbursement, application and administrative fees, and any ancillary revenue lines. This module also carries vacancy and credit loss. Keep physical vacancy, economic vacancy, and concessions as separate line items so a reviewer can see whether a soft projection comes from occupancy or from discounting.
5. Operating Expenses
Payroll, repairs and maintenance, contract services, marketing, insurance, utilities, property taxes, and management fees. Split controllable from non controllable, and normalize the trailing expense detail rather than accepting it as given. HelloData's free proforma template, for example, is built around estimating rental property cash flows and underwriting operating expenses rather than simply echoing prior year spend.
6. Net Operating Income
Effective gross income minus operating expenses. Nothing else belongs here. NOI sits above debt service and above capital expenditure by definition, and most valuation benchmarks key off this single line. When a model's NOI quietly includes a capital item, the exit value assumption built on top of it becomes wrong by construction.
7. Capital Expenditures and Renovation Scope
Interior renovations, common area work, roof and mechanical replacements, and unit turnover costs. The Adventure in CRE renovation model is a useful reference point for scope structure: it underwrites renovation and repositioning of up to 100 units plus six global capital improvement projects, which is the level of granularity a value add plan needs before a lender will take it seriously.
8. Debt and Financing
Loan amount, loan to value, interest rate, amortization, term, interest only periods, lender reserves, and the coverage tests a lender will apply. This module converts property level NOI into levered cash flow, which is why it must sit between modules six and nine and never inside either of them.
9. Cash Flow and Distributions
Levered cash flow after debt service, reserve funding, and capital draws, then allocated among partners. If your structure includes a promote or waterfall, it belongs in its own sub tier here rather than scattered through the equity section. Distribution timing affects IRR as much as distribution size does.
10. Returns and Exit
Sale year, exit valuation assumption, disposition costs, and the return metrics that summarize the deal: IRR, equity multiple, and average cash on cash. A Simple Model publishes a free multifamily financial model for a 160 unit acquisition that bundles rent roll analysis, proforma, IRR, and an amortization schedule into one template, which is a good illustration of how tightly these outputs couple.
11. Sensitivities and Scenario Testing
The sensitivities and scenario testing module earns its keep in the investment committee. Vary exit assumptions, rent growth, renovation cost, and financing terms one at a time, then in pairs, and record where the deal breaks. A base case with no sensitivity table is an assertion, not an analysis. This is also where a well built model separates itself from a static template, because the inputs are already isolated.
How the Modules Depend on Each Other
The build order is not arbitrary. Data flows in one direction, and errors flow with it.
- Modules two and five define the property as it operates today.
- Modules three and four convert today's performance into a projection.
- Module six collapses income and expenses into NOI.
- Module eight applies the capital structure to that NOI.
- Modules nine, ten, and eleven translate cash flow into a decision.
In a linked multifamily proforma, you should never hard code a number that another module already calculates. Link the rent growth assumption to the proforma rent line. Link the management fee to effective gross income. When every output traces to a labeled input, reviewing the model takes an hour instead of a week.
How Long a Multifamily Proforma Build Should Take
Vendors in this space compete on speed, and their claims are worth reading with that context in mind. IntellCRE markets a four step build process aimed at producing a proforma in a very short window, and Tacticares describes its apartment deal analysis spreadsheet as capable of underwriting an investment in 15 to 20 minutes. Both figures assume the underlying rent roll and financial statements are already clean and structured. Roughly half of a real world build is data preparation, not modeling. If the rent roll arrives as an unstructured export from a property management system, budget accordingly and treat the modeling time as the smaller half of the job.
Templates and Shortcuts Worth Knowing
Free and low cost options exist for almost every part of this build. HelloData offers a free multifamily proforma template oriented around operating expense underwriting. A Simple Model offers a free multifamily acquisition model with rent roll analysis, IRR, and amortization built in. Adventures in CRE sells a proforma designed for multifamily renovation projects of varying size. A Simple Model, HelloData, and Adventures in CRE each approach the same eleven modules from a different starting point, so comparing two or three structures is a fast way to learn the conventions. Investor communities such as the r/realestateinvesting discussion on multi family proforma templates are also useful for seeing which structures other operators actually use.
Whichever route you take, verify the mechanics yourself before the model informs a real decision. Templates encode their authors' assumptions about vacancy, reserves, and expense recovery, and those assumptions may not match your market or your lender.
Frequently Asked Questions
What does proforma mean in real estate?
A proforma is a forward looking financial projection. In real estate, it shows the income and expenses a property is expected to produce under a specific business plan, rather than what it has historically produced. It is the standard tool used to test whether an acquisition price and strategy make sense before capital is committed.
Do I need a rent roll before I can build a proforma?
A multifamily proforma needs a rent roll. The rent roll establishes in place rents, unit mix, occupancy, and lease timing, which are the foundation for every revenue assumption. Loading the rent roll and expense history is step two in the IntellCRE build sequence, right after entering basic deal data. Building revenue projections without a rent roll produces a guess, not a model.
How many units can a renovation proforma handle?
The number of units a renovation proforma can handle depends on the model. The Adventures in CRE proforma for multifamily renovation underwrites renovation and repositioning of up to 100 units plus six global capital improvement projects. Larger portfolios often need a modified structure, but the underlying modules stay the same regardless of unit count.
Should capital expenditures sit above or below net operating income?
Capital expenditures belong below net operating income in a multifamily proforma. NOI is effective gross income minus operating expenses, before debt service and before capital items. Placing renovation costs or reserves above that line understates NOI and distorts any valuation assumption built on it. Keeping the split clean is one of the most common review findings in underwriting.
Where can I find a free multifamily proforma template?
HelloData publishes a free proforma template focused on cash flow and operating expense underwriting, and A Simple Model offers a free 160 unit acquisition model with rent roll analysis, proforma, IRR, and amortization. Both are reasonable starting points. Check the underlying assumptions in any free template before relying on its outputs.
Primary references
- Fannie Mae Multifamily Selling and Servicing Guide
Consult the lender's current requirements when reviewing property financials and underwriting inputs; a software output does not replace lender review.
- Freddie Mac Multifamily Guide and Forms
Use the published underwriting forms and guide chapters to check required documentation. Requirements vary by loan program.