Real Estate Pro Forma Template

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.

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.