Real Estate IRR: Build Levered Cash Flows and Check Exit Assumptions

Build a property IRR schedule with acquisition costs, debt service and sale proceeds. Check exit-cap sensitivity and correctly annualize a short property hold.

A property IRR uses the amounts invested and received over the holding period. Levered IRR includes financing cash flows; unlevered IRR evaluates the property before financing. Label which version you are calculating and distinguish forecast amounts from realized transactions.

The IRR & XIRR calculator analyzes the cash-flow schedule you provide. It does not build a mortgage amortization schedule, forecast rent or select an exit valuation. This guide explains how to assemble those inputs and avoid mixing incompatible assumptions.

Separate property cash flows from equity cash flows#

NOI is a useful starting point, but it is not automatically the entire unlevered cash flow. Capital expenditures and other cash needs may sit outside NOI and still belong in the investment schedule. Likewise, subtracting the mortgage from NOI without accounting for later repairs or additional equity can overstate the investor's distributions.

Financing can increase or decrease equity returns depending on the borrowing terms and property performance. A numerical IRR alone does not measure the additional risk of the debt obligation. Compare like-for-like cash flows before treating two quoted percentages as comparable.

Build the acquisition row from the actual equity required#

For a hypothetical $500,000 purchase with a 25% down payment, $9,000 in acquisition costs paid by the investor, and $16,000 of immediate repairs:

Down payment = 500000 * 25% = 125000
Initial equity cash flow = -(125000 + 9000 + 16000) = -150000

Those costs are stated amounts for this example, not market estimates. If repairs occur months after closing, record the payments on those dates in XIRR rather than automatically moving them all to time zero. Keep escrow deposits, later refunds and lender-funded items consistent with what the investor actually pays and receives.

The verified IRR property examples provide complete cash-purchase and financed schedules, including the amortization and sale assumptions. Their downloadable CSVs can be imported directly into the workspace.

Keep negative operating periods and zero-payment periods#

A levered schedule can include later negative rows when repairs, vacancy or debt service require more equity. It is not necessarily one negative investment followed exclusively by inflows.

A simplified annual construction is:

Property operating receipts
- operating expenses paid
- capital expenditures and other project cash needs
- scheduled debt principal and interest
+ new loan proceeds, if any
- refinancing costs or other financing charges, if any
= net equity cash flow for the period

Do not subtract a noncash depreciation charge as though it were cash paid. If you model after-tax cash flows, calculate the cash taxes separately and label that basis. For a period without any net payment, keep an explicit zero row in an annual schedule so later payments retain their timing.

Refinancing proceeds are money received, but they also create or replace a debt obligation. Include the borrowing terms, subsequent payments and eventual payoff; an isolated refinancing inflow can make a return calculation misleading.

Reconcile the sale row with the debt balance on that date#

Net sale proceeds to equity = sale receipts
                             - selling costs
                             - debt payoff
                             - applicable financing charges

Final-period equity flow = operating equity flow for that period
                           + net sale proceeds

Use the loan balance after the payments assumed to have occurred by the sale date. Avoid deducting principal twice: scheduled principal belongs in the earlier payment rows, while the remaining balance is paid at exit. Include the final operating distribution only once if a supplied sale figure already contains it.

A terminal receipt can materially affect IRR. Its importance depends on the entire schedule; a fixed percentage of "the IRR attributable to sale" is not available from the sale amount alone.

Exit-cap sensitivity changes the sale price before it changes IRR#

If you estimate sale value from a capitalized NOI, state whether that NOI is trailing or forward looking. These are different assumptions and may produce different values even with the same exit cap rate.

For a hypothetical $55,000 NOI on the chosen valuation basis:

The one-percentage-point increase from 5.5% to 6.5% reduces the modeled gross sale value by $153,846.15, holding NOI constant. You cannot translate that into a fixed IRR change without the acquisition outflow, intervening cash flows, hold length, selling costs and debt payoff.

To run the sensitivity, calculate each sale price, deduct the corresponding costs and payoff, replace the terminal amount, and recalculate the complete schedule. The workspace can pin one analysis as a baseline for comparison. Also test NOI, vacancy, repairs, financing and timing; a chosen exit-cap scenario does not validate the rest of the forecast.

Correct annualization for a short hold#

Assume just two cash flows: one investment and one receipt worth 1.30 times that investment. There are no interim contributions, distributions or additional costs.

If the hold is exactly 0.75 years:
Annual IRR = 1.30^(1/0.75) - 1 = 41.88107480%

If the hold is exactly 5 years:
Annual IRR = 1.30^(1/5) - 1 = 5.38739521%

Both cases have a 1.30x equity multiple and a 30% total gain. Their annualized rates differ because the holding periods differ. Multiplying 30% by 12/9 gives 40%, a simple annualized gain; it is not the compounded IRR.

The 0.75-year example treats nine months as exactly three quarters of a year. A real nine-calendar-month interval does not always contain the same number of days. For actual property dates, Excel XIRR and the calculator's dated mode use elapsed days divided by 365, so the exact result can differ from 41.88%.

A high short-hold annualized rate does not imply the deal can be repeated throughout the year. Time searching for another property, transaction costs, available capital and the next deal's outcome remain separate considerations.

IRR does not establish a reinvestment outcome or a market benchmark#

IRR is a zero-NPV rate of the supplied schedule. The equation does not explicitly place annual rental distributions into new investments. To describe their final accumulated wealth, specify whether those distributions are spent, held as cash or reinvested at another rate.

MIRR uses explicit finance and reinvestment rates over a specified horizon. It may be lower or higher than IRR depending on those assumptions. It is not automatically a more conservative or more accurate projection. See the verified Excel MIRR example for a calculation that shows each step.

Likewise, there is no universal percentage that makes a property attractive. Comparing return claims requires the same leverage, costs, holding period, forecast basis and risk assumptions. If you use a market benchmark, identify its source, period and comparable property group instead of treating an unsourced target range as observed performance.