Negative operating cash flow, strong estimated XIRR: is the property working?

A strong estimated extended internal rate of return (XIRR) can coexist with negative operating cash flow when an assumed net sale receipt supplies much of the investment's return. That does not fund the interim shortfalls or establish that the exit will happen as modelled.

Review two things separately: can you support the property's dated cash needs, and is the assumed full investment return robust to less favourable outcomes? You need both views before deciding whether to keep supplying cash.

Keep the operating and investment schedules separate

Our separate hypothetical CAD exit scenario starts with CAD 150,000 on January 1, 2020. Annual operating shortfalls require CAD 5,000 top-ups. The owner assumes a sale on January 1, 2025 for CAD 900,000, with CAD 45,000 sale costs and CAD 350,000 loan payout.

The final owner cash entry is CAD 500,000 after the last CAD 5,000 top-up. Earlier entries are the initial contribution and four CAD 5,000 top-ups. The fifth top-up is already netted into the final receipt; do not deduct it again.

Total owner contributions including that last top-up are CAD 175,000. The sale receipt before the final top-up is CAD 505,000, so full net cash is positive CAD 330,000. This is negative operating cash with a positive assumed exit, not an exclusively negative lifetime cash-flow series.

XIRR gives about 25.29%, estimated and pre-tax. Microsoft's documentation defines a dated calculation, not a promise of yearly cash income. The scenario excludes income tax, break fees and other exit charges; a real decision must add those that apply.

Ask what has to go right

Identify the evidence behind sale price, achievable income, debt payout and costs. A future gross value is not owner proceeds. A buyer, lender or tax bill may change the amount and timing; the spreadsheet's terminal line is only an assumption until settlement.

The delayed case holds sale price, 5% selling costs and loan payout fixed as teaching assumptions; it adds one operating top-up. It is not an amortization or market forecast. Its full net cash falls to CAD 325,000, and money returns later. The severe case has negative full net cash of CAD 69,000, unlike the base case.

These are sensitivity tests, not assigned probabilities or healthy-return ranges. A downside test is more useful when you can explain why that combination of price, income, costs and timing deserves examination.

Nominal break-even is a different boundary

With a 5% sale cost, CAD 350,000 payout and CAD 175,000 total contributions, a sale of about CAD 552,632 would return the owner's contributed cash in nominal terms:

$$S = \frac{350{,}000+175{,}000}{0.95}$$

Here, $S$ is gross sale price in CAD; 0.95 is the fraction left after the assumed selling cost. This ignores income tax, other charges and the value of time. Returning the same nominal cash after years is not achieving an owner-selected investment hurdle or protecting purchasing power.

Build the funding plan beside the return model

Use actual cash flow and a dated shortfall forecast. Identify accessible cash, known projects and external commitments. An undrawn loan or a possible future refinance is not the same as available cash.

Review cash needs monthly and after material changes. Refresh the full exit model annually or when credible new evidence arrives; those are suggested cadences. If funding or exit assumptions no longer support the plan, compare keeping and selling from today. A historical contribution is already committed; supplying the next one needs its own forward case.

Sources

• Microsoft, XIRR function, dated-flow calculation, checked October 1, 2026. All sale, cost, top-up and timing scenarios are hypothetical and independently recalculated; no realized return or market forecast is asserted.