Library / Underwriting & Deal Analysis Wing 03 · Lesson 18 · ~3 min

The pro forma: reading the projection

A pro forma is a flight plan, not an arrival record. Trace every projected change to evidence, execution, or risk.

Check the assumption → Wing index →
Read with a pencil

Circle the assumption doing the most work. That is usually where the deal is asking for trust.

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:

LineT-12 actualYear-one pro formaQuestion
Residential income$910,000$980,000What leases support the jump?
Other income$62,000$95,000Which fees are new or already collected?
Repairs$118,000$82,000What changed besides ownership?
Insurance$74,000$76,000Is there a current quote?
Taxes$132,000$138,000Does 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:

ColorMeaning
GreenSupported by current documents
YellowReasonable but needs execution
RedAggressive, 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.

Math notes PRSE / GUIDE

Get better at finding the assumption doing too much work.

New underwriting checks, model notes, and the free guide when they are useful.

Educational only. Not an offer to invest. Email is optional for updates; public resources stay public.