Real estate schedules · in 2 models

Property returns

Unlevered and levered IRR, multiple, cash-on-cash, exit cap sensitivity.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: property returns.Updated 30 September 2026

Part of real estate models, with the models, labs and guides around it.

What it does

The hold as two cash flow series. Unlevered: the purchase and closing costs out, cash flow before debt service in, and the net sale proceeds at the end, priced on forward NOI at the exit cap rate. Levered: the same with the loan in at closing and debt service and the balloon out. IRR and multiple on each, cash-on-cash by year, and a sensitivity that re-prices the sale at five exit cap rates in live formulas.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Property acquisition model
  • Assumptions, rows 6–10: Year, Hold period, Hold period used, Owned during the year…
  • Assumptions, rows 33–34: Exit cap rate, Selling costs, % of sale price
  • Returns, rows 6–9: Forward NOI at sale, Gross sale price, Sale price net of selling costs, Going-in cap rate
  • Returns, rows 12–17: Purchase and closing costs, Cash flow before debt service, Net sale proceeds, Unlevered cash flow…
  • Returns, rows 20–26: Loan proceeds, net of origination fee, Debt service and balloon, Levered cash flow, Equity invested…
  • Returns, rows 29–37: Exit cap rate increment, Exit cap rate, Levered cash flow at exit cap rate, Levered cash flow at exit cap rate…
Hotel underwriting model
  • Assumptions, rows 6–10: Year, Hold period, Hold period used, Owned during the year…
  • Assumptions, rows 75–79: Exit cap rate, base, Exit cap rate, upside, Exit cap rate, downside, Exit cap rate, selected scenario…
  • Returns, rows 6–11: Forward NOI at sale, Gross sale price, Sale price net of selling costs, Gross sale price per key…
  • Returns, rows 14–19: Purchase, closing costs and PIP, NOI while owned, Net sale proceeds, Unlevered cash flow…
  • Returns, rows 22–29: Loan proceeds, net of the origination fee, Debt service and repayments, Levered cash flow, Equity invested…
  • Sensitivity, rows 5–8: Stabilised occupancy increment, Exit cap rate increment, ADR increment, first stabilised year, Senior interest rate increment
  • Sensitivity, rows 11–16: Exit cap rate, Levered IRR, Levered IRR, Levered IRR…
  • Sensitivity, rows 53–98: Year, Occupancy at row 1, GOP at row 1, NOI at row 1…

What a reviewer looks for

  • Selling on trailing NOI.
  • An IRR quoted without the exit cap it depends on.
  • Cash-on-cash computed on price rather than on equity.

Learn it, then build it

Vocabulary: Cash-on-Cash Return, Equity Multiple, IRR.

Other real estate schedules