A multifamily pro forma template that starts with the unit mix
A useful multifamily pro forma template is not a single “rent” cell with a growth rate attached. It starts with the unit mix, because eight one-bedrooms and four two-bedrooms do not turn over, vacate or wear out like a stacked hotel of identical rooms. Square footage, count, rent, vacancy and rent growth belong on the same row for each type.
Build income from the units, then add the other lines
Once the types are in, other income — parking, laundry, storage, pet fees — should sit beside the rents, not be buried in a rounded “miscellaneous” that never gets checked. Vacancy is a property assumption, but it is easier to defend when you can see it against each unit type rather than against a blended average that hides a problem floor.
Expenses need a basis, not just an annual total. Property taxes and insurance are usually a fixed amount. Management is often a percentage of collections. Some utilities and contracts are clearer per unit or per square foot. A template that forces everything into one column makes a tidy first year and a sloppy tenth year.
Let capital work arrive in the year it arrives
The line that most often breaks a pretty spreadsheet is capital expenditure. A flat percentage of rent looks professional and is almost never how a roof, a boiler plant or a parking lot actually fail. A 10-year pro forma should accept a year-by-year capital plan, or at least a level reserve that was derived from that plan, so a heavy year shows up in cash flow instead of being smoothed into a footnote.
Returns then follow from the numbers you actually type: net operating income, cap rate, cash-on-cash, break-even occupancy, and longer-horizon measures such as IRR and equity multiple. If the purchase uses financing, the annual debt service should be the figure from your own documents, not a payment the sheet invents.
How MultiFamilyBooks is set up
The guided Inputs tab in MultiFamilyBooks is built in that order: unit mix, other income, expenses with a basis for each, a 123-component capital plan, and only then the 10-year pro forma and a waterfall of where rent goes. The same file can keep the books after you close. This is planning math, not investment advice; have a qualified professional review any acquisition.
This article is for education. MultiFamilyBooks is a tool to make your numbers easier. It isn't tax, legal or investment advice, so have a CPA review your numbers before you file or buy.