Real Estate Pro Forma Template

Start with the Deal Assumptions sheet. Enter the purchase price, your anticipated down payment, and loan terms (rate, amortization period, any interest-only months). Then fill in your projected gross monthly rent, your vacancy assumption (a standard residential vacancy rate is 5–8%), and your estimated annual operating expenses. The model is pre-loaded with typical real estate expense categories, so most users keep the structure and just adjust the numbers to match their specific property. This first pass takes about 20 minutes if you have a rent survey and tax bill in front of you.

Once the assumptions are in, flip to the Income & Expense Projections and Cash Flow Analysis sheets to review the outputs. Check that Year 1 NOI looks reasonable relative to the purchase price — if your going-in cap rate on the Returns Summary is wildly off from comparable properties in the market, go back and revisit your expense assumptions or rent estimate. Use the scenario feature by saving a copy and running a stress test: what happens if vacancy runs at 10% instead of 5%? What if rents grow at 2% instead of 3%? This is where the model earns its value — not in the base case, but in the downside.

The Returns Summary sheet is what you'll use when presenting to lenders, partners, or passive investors. Print or export it as a PDF, or drop it into a deal memo. Lenders will want to see the DSCR above 1.25; equity partners will focus on cash-on-cash and IRR. If you're doing a BRRRR-style deal with a refinance, you can model the refi by adjusting the loan terms partway through the hold — the debt service sheet handles multiple loan configurations. Come back to update the model as you get actual operating data, which turns it from a pre-purchase analysis into an ongoing asset management tool.

Real estate deals get made or passed on pro formas. A lender won't approve a loan without seeing projected NOI and DSCR. A private equity partner won't write a check without seeing IRR and an equity multiple. And an experienced investor won't close without stress-testing the downside scenarios. The pro forma is the document that ties together all the moving parts of a deal — purchase price, financing, operating projections, and exit — into a single model that tells you whether the numbers work before you're committed.

A well-built real estate pro forma separates real analysis from wishful thinking. The biggest mistake first-time investors make is underestimating expenses. Industry benchmarks put total operating expenses for a stabilized rental property at 35–50% of gross potential rent, depending on property type and location — a figure most pro formas built on napkins dramatically undercount. The model should include property taxes (look up the actual assessed value and mill rate), insurance, management fees (typically 8–10% of collected rents for residential, 3–6% for commercial), maintenance reserves ($100–200 per unit per year minimum), and capital expense reserves ($150–300 per unit per year for older properties). Get those right, and the NOI number is defensible.

The ongoing workflow is just as important as the initial underwriting. After acquisition, update your actual rent rolls, tax bills, and expense receipts into the model each year. Track whether your actual DSCR is staying above your lender's required coverage ratio. Compare your actual cap rate to your going-in assumption. If expenses are running higher than projected, the model shows you exactly which categories are the culprit and by how much — giving you specific targets to address rather than a vague sense that the deal underperforms. Investors who treat the pro forma as a living document, not a one-time analysis, catch problems before they become refinancing crises.