The model is confessing. Read it that way.
Every spreadsheet has one or two numbers quietly carrying the sales pitch. Find them before they start carrying your money.
If one assumption saves the deal, it is not conservative. It is fragile. The useful move is not memorizing "The pro forma: reading the projection." It is knowing what you would verify next.
A pro forma is the sponsor’s projection of how the property might perform. It is not a promise, a prophecy, or evidence that the future signed off on the business plan.
It can still be useful. A flight plan is useful too. You just do not confuse the route drawn before departure with the miles actually flown.
In plain English, the pro forma turns assumptions about rent, vacancy, expenses, debt, renovations, and sale into year-by-year numbers. Your job is to separate the part supported by current documents from the part that requires execution or market cooperation.
Build the bridge from actual to projected
Start by putting historical operations beside year one. This table is hypothetical:
| Line | T-12 actual | Year-one pro forma | Question |
|---|---|---|---|
| Residential income | $910,000 | $980,000 | What leases support the jump? |
| Other income | $62,000 | $95,000 | Which fees are new or already collected? |
| Repairs | $118,000 | $82,000 | What changed besides ownership? |
| Insurance | $74,000 | $76,000 | Is there a current quote? |
| Taxes | $132,000 | $138,000 | Does this reflect reassessment? |
The difference between columns is where the business plan is hiding. Every material change needs a source, an explanation, a date, and a person responsible for making it happen.
If ownership changes and an expense line suddenly becomes well behaved, ask what operational change taught it manners.
Make the assumptions show their papers
A useful pro forma should disclose:
- Rent growth by year.
- Vacancy, credit loss, and concessions.
- Other income by source.
- Expense growth by line.
- Debt terms, including maturity and rate changes.
- Reserves and recurring capital needs.
- Exit cap rate and sale costs.
Then trace the starting points to the rent roll, T-12, current tax bill, insurance quote, lender terms, renovation budget, and relevant comps. A projection can be reasonable without being guaranteed. It cannot be examined if its machinery is hidden.
Price the claimed improvement
In this hypothetical, T-12 NOI is $560,000 and year-three NOI is projected at $760,000. The pro forma is therefore claiming $200,000 of improvement.
At a 6.0% cap rate, that improvement is worth:
$200,000 / 0.06 = $3,333,333
That is why the bridge matters. A $200,000 NOI assumption becomes a $3.3 million valuation assumption. If rent premiums, occupancy gains, or expense cuts do not show up as planned, the value does not owe the model an apology.
Ask which portion of the $200,000 comes from signed leases, which portion requires operational execution, and which portion depends on the market. Same total. Very different reliability.
Read the instrument colors
Color-code the pro forma:
| Color | Meaning |
|---|---|
| Green | Supported by current documents |
| Yellow | Reasonable but needs execution |
| Red | Aggressive, unsupported, or market-dependent |
Color is not a verdict. It is a workload assignment. Green gets verified, yellow gets an execution owner, and red gets a downside case.
If the return requires every red cell to cooperate, the model is not conservative. It is waiting for clearance from weather that has not formed yet.
Read across, then write the variance memo
Read horizontally across the years. Circle every jump in revenue, drop in expenses, debt change, reserve draw, and terminal assumption. Totals let assumptions travel as a group; year-to-year changes make them show identification.
Finish with a one-page memo listing the three largest projected changes, the source for each, the person responsible, and what the deal looks like if each arrives late or misses.
The pro forma gets to describe a possible route. It does not get to report the landing in advance.
PR Steinfurth Equity provides educational information only. Nothing on this website is an offer to sell or a solicitation of an offer to buy any security, nor investment, legal, or tax advice. Any securities offering is made only to qualified investors through official offering documents. Real estate investments involve risk, including possible loss of principal. Past performance is not indicative of future results.