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

Deal analysis, start to finish

Read a deal in checklist order: current operations, price, debt, execution, exit—and returns dead last.

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.

Deal analysis should not begin with the IRR. Starting there is like reading the expected arrival time before checking whether the aircraft has fuel.

The useful order is property, price, debt, business plan, exit, returns. Each step clears the next one. Skip the sequence and a polished output gets to smuggle weak assumptions past you in first class.

The checklist has an order for a reason

StepQuestionPrimary source
1. Current operationsWhat does the property actually collect and spend?Rent roll, T-12
2. Purchase mathWhat price is being paid for the current income?Purchase price, current NOI
3. DebtHow much time and flexibility does the loan allow?Lender quote, term sheet
4. Business planWhat has to change after closing?Capex budget, rent comps, manager input
5. ExitWhat value is assumed later, and why?Exit cap sensitivity, sales comps

This is deal analysis in plain English: verify what the property does now, measure what you are paying for it, understand the loan clock, test the operational changes, and challenge the assumed sale. Returns are the receipt for those inputs.

If the deal needs you to read backward, it probably needs you not to notice something.

The 20-minute instrument check

Take a hypothetical 96-unit deal with a $14,400,000 purchase price and $820,000 of current NOI.

Going-in cap rate:

$820,000 / $14,400,000 = 5.69%

Now open the debt quote. If annual debt service is $690,000, current DSCR is:

$820,000 / $690,000 = 1.19x

That does not automatically kill the deal. It does tell you the current income does not leave much room above debt service. Add an aggressive renovation schedule, slower collections, or a cost overrun, and the margin starts looking less like a cushion and more like upholstery.

Inspect the quiet lines

The weak spots usually sit where the presentation lowers its voice:

  • A rent premium copied from the nicest comp instead of the closest one.
  • A tax line that ignores reassessment after sale.
  • Insurance carried forward without a current quote.
  • Payroll that promises better service with fewer people.
  • Exit value doing more work than operations.

For each item, write the source beside the assumption. “Market” is not a source. Neither is a broker saying, “We see it all the time.”

Build the one-page discrepancy log

Before reading the investment summary again, put the sponsor case beside your checked case:

LineBase caseYour checked caseDifference
Current NOI$820,000$790,000-$30,000
Stabilized NOI$1,050,000$970,000-$80,000
Annual debt service$690,000$715,000+$25,000
Exit cap5.50%6.00%+0.50%

You are not pretending your checked case can predict the future to the dollar. You are identifying which dials control the answer and whether the evidence supports their settings.

Returns are the final sign-off

Read the rent roll, T-12, purchase price, debt quote, capex plan, rent comps, manager input, sales comps, and exit sensitivity. Then open the return summary.

Ask three questions before signing off:

  • Which current number is least supported?
  • Which operational change requires the most execution?
  • Which debt or exit assumption gives the plan the least time to recover?

The checklist is not bureaucracy. It is how you stop a beautiful destination from distracting you from an unairworthy route.

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.