How to Create a Real Estate Pro Forma
A real estate pro forma is your financial blueprint for any investment property. Learn how to build one from scratch — from income and expense projections to exit modeling — with templates and worked examples.
What Is a Real Estate Pro Forma?
A pro forma (from the Latin "as a matter of form") is a forward-looking financial model that projects the performance of an investment property over a defined holding period — typically 5 or 10 years. It's the financial blueprint every serious real estate investor builds before committing to a deal.
Unlike a simple cap rate calculation, a pro forma accounts for time: rent growth, expense increases, financing amortization, value appreciation, and the eventual sale. It answers the question: what will this investment actually return over my holding period?
Use our Cash Flow Calculator alongside this guide for immediate calculations.
The Core Components of a Pro Forma
Every complete real estate pro forma contains these sections:
- Acquisition Summary: Purchase price, closing costs, down payment, loan terms
- Year 1 Income & Expenses: Detailed first-year operating projection
- Annual Growth Assumptions: Rent growth rate, expense growth rate
- Multi-Year Cash Flow Summary: Year-by-year NOI, debt service, and cash flow
- Equity and Value Appreciation: Property value growth, loan paydown
- Exit Analysis: Sale proceeds, total return on investment
Section 1: Acquisition Summary
Purchase Economics
Start with the complete cost of acquisition — not just the purchase price. Closing costs on a standard residential investment purchase run 2–5% of purchase price and include:
- Lender origination fees and points
- Title insurance (owner's and lender's)
- Appraisal
- Inspection costs
- Transfer taxes (varies dramatically by state)
- Recording fees
- Attorney fees (required in some states)
- Prepaid items (property tax escrow, insurance escrow, prepaid interest)
A $300,000 purchase at 25% down requires: $75,000 down payment + ~$9,000–$15,000 closing costs = $84,000–$90,000 total cash to close. Your pro forma must use the total cash invested, not just the down payment, for accurate return calculations.
Loan Terms
Document your financing precisely: loan amount, interest rate, amortization period, and any balloon payment date. For investment properties, common loan structures include:
30-year fixed conventional: Predictable payments, fully amortizing. Best for long-term holds.
DSCR loans: Underwritten on property income, not borrower income. Slightly higher rates (typically 6.5–8% in 2025–2026) but accessible for investors with complex income.
5/1 or 7/1 ARM: Lower initial rate with adjustment risk. Suitable for investors who plan to sell or refinance within the fixed period.
Use the annual debt service number in every year of your pro forma. For a $225,000 loan at 7.5% on a 30-year term, annual debt service is approximately $18,889.
Section 2: Year 1 Income & Expense Projections
Income Line Items
Gross Potential Rent (GPR): Multiply unit count × monthly rent × 12. For a duplex with each unit at $1,200/month: $1,200 × 2 × 12 = $28,800.
Vacancy & Credit Loss: Subtract 5–8% from GPR. Conservative proformas use 8% in Year 1 to account for stabilization.
Other Income: Late fees, laundry, storage, parking. Document each source separately. These are real but should be modeled conservatively.
Effective Gross Income (EGI) = GPR − Vacancy + Other Income
Expense Line Items
List every expense as a separate line item. Avoid lumping expenses together — it hides assumptions and makes errors harder to spot. Standard line items:
- Property taxes (from county assessor)
- Insurance (landlord policy quote)
- Property management fee (% of collected rent)
- Leasing/turnover costs (amortized annually)
- Routine maintenance
- Capital expenditure reserves
- Utilities (landlord-paid)
- Lawn/snow
- Pest control
- Professional fees (accounting, legal)
- Miscellaneous/other
Net Operating Income (NOI) = EGI − Total Operating Expenses
Pre-Tax Cash Flow = NOI − Annual Debt Service
Section 3: Growth Assumptions
The pro forma's value lies in modeling how the deal evolves over time. Your growth assumptions drive everything.
Rent Growth Rate
Historical long-term rent growth in the US averages 2–3% annually. Conservative pro formas use 2% annual rent growth. Markets with strong demand drivers (tech job growth, housing supply constraints) may warrant 3–4%. Entering 5%+ rent growth is aggressive and should be scenario-tested, not used as a base case.
Expense Growth Rate
Expenses typically grow at 2–3% annually, tracking inflation. Property taxes may grow faster in rapidly appreciating markets — check local historical data. Insurance premiums in coastal or disaster-prone areas are growing faster than general inflation in 2024–2026.
A conservative assumption is that expenses grow slightly faster than rents. Modeling expenses at 3% growth and rents at 2% gives you a stress-tested view of long-term cash flow.
Vacancy Over Time
Year 1 vacancy may be higher as you stabilize the property. Years 2–10 typically use a stabilized rate (5–7% for well-managed properties in strong rental markets).
Section 4: The Multi-Year Cash Flow Model
Once you have Year 1 and your growth assumptions, building Years 2–10 is straightforward. Each year, rents grow by your assumed rate, expenses grow by their rate, and debt service stays constant (for fixed-rate financing).
Track four key metrics for each year:
- NOI: Shows operating performance growth (or degradation) over time
- Pre-Tax Cash Flow: Your actual spendable income after debt service
- Loan Balance: Declining each year as principal is paid down
- Equity: Value appreciation + principal paydown = growing wealth
Property Value and Appreciation
Model property value using two approaches:
Direct capitalization: Value = NOI ÷ Exit Cap Rate. If your NOI grows from $18,000 to $22,000 over 10 years and exit cap rates remain at 7%, value grows from $257,000 to $314,000.
Price appreciation: Apply an annual appreciation rate (typically 2–4% nationally, higher in growth markets) to the purchase price. This is simpler but less grounded in property income fundamentals.
Use both methods and compare. If they diverge significantly, investigate why.
Section 5: Exit Analysis
The exit is where a long-term hold pays off. Model a sale at your target hold period (typically year 5 or 10).
Gross Sale Proceeds = Projected Property Value at Exit
Net Sale Proceeds = Gross Sale Proceeds − Selling Costs (typically 6–8% for agent fees, transfer taxes, and closing costs)
Equity Captured = Net Sale Proceeds − Remaining Loan Balance
Total Return = Cumulative Pre-Tax Cash Flow over hold period + Equity Captured
Total Cash Invested = Down Payment + Closing Costs at acquisition
Equity Multiple = Total Return ÷ Total Cash Invested
A well-structured 10-year hold in a growing market often produces an equity multiple of 2.5–4x. This is the compounding power of real estate: cash flow + appreciation + loan paydown, all working simultaneously.
Pro Forma Red Flags to Watch For
When reviewing pro formas from sellers or brokers, watch for these warning signs:
- No vacancy assumption: Every pro forma should account for vacancy. A proforma showing 100% occupancy is fiction.
- No management expense: Even if self-managed, include it. Buyers should underwrite for professional management.
- Aggressive rent growth (5%+): Fine in a base + bull case scenario, but should not be the base case.
- No CapEx reserve: A common omission. Every physical asset requires capital investment over time.
- Stale rent comparables: Make sure rent assumptions reflect current market data, not 2–3 year old data.
Tools That Speed Up Pro Forma Creation
Our Cash Flow Calculator handles the Year 1 analysis instantly. For full multi-year pro forma modeling, purpose-built tools like DealCheck, Analyzerei, and RealData are worth exploring — check our Software Directory for comparisons.
Related guides: Complete Rental Property Analysis Guide | How to Calculate Cap Rate