Saudi Property IRR: Calculate and Interpret Cash Flows

Internal rate of return, or IRR, summarises the timing and amount of an investment's cash flows as a percentage. For a Saudi property model, it is the rate that makes the present value of all modelled receipts equal all modelled payments. It can help compare scenarios, but it does not establish a property's market value, guarantee an outcome or show whether the owner can meet each bill before an eventual sale.

This article explains how to calculate property IRR without hiding assumptions behind a percentage. Every SAR amount and rate is fictional teaching arithmetic, describing no actual property, city average or recommended return. The photographs provide Saudi building context; they depict none of the imaginary investments.

Understand the percentage before using it

An IRR calculation starts with cash paid and received over time. It solves for a rate rather than asking you to choose one first. Our discounted cash-flow explanation approaches the same timeline from another direction: select a comparison rate, then calculate net present value, or NPV. Keeping these questions separate makes a model easier to interpret.

CFA Institute's 2026 capital-allocation reading treats IRR and NPV as project evaluation tools subject to assumptions. In this article, the percentage describes the specified cash stream. It does not judge whether the rent assumptions are credible or whether the proposed exit price has supporting evidence. An accurate calculation can still describe an unrealistic plan.

A rental yield describes a defined income amount relative to a defined property cost or value. IRR adds subsequent cash movements and their timing, including an assumed disposal. A model with little operating cash but a large assumed sale receipt might display an appealing IRR. That structure creates a different funding problem from one with substantial regular receipts. Read the underlying timeline before comparing the headline percentages.

Also distinguish a forecast from a completed result. Before a sale, the exit proceeds in a projected IRR remain an assumption. Replacing that assumption with an estimated current value does not turn it into money already received. Label a projection as a projection, and identify which rows are documented transactions, contracted amounts or unsupported estimates. That simple distinction prevents a precise-looking percentage from being mistaken for realised performance.

Build a cash ledger with a consistent viewpoint

Use one row for each date or regular period. Show payments with a minus sign and receipts with a plus sign from the chosen investor's perspective. For an unfinanced property model, year zero might include the acquisition and all specified initial outlays. Later rows contain net operating cash, further capital payments and eventual net disposal proceeds. Keep a supporting schedule explaining how each net amount was assembled.

An equity model after borrowing needs a different ledger. It records the owner's equity contribution, cash remaining after financing payments, further equity injections and disposal cash after the financing settlement. Do not put a loan-funded acquisition into a model as if the owner paid the entire price, then also deduct financing repayments without explaining that viewpoint. Comparing a financed equity IRR with an unfinanced property IRR obscures what each percentage measures.

Record cash movements only once. If a repair is already deducted from net operating cash, do not enter it again. Distinguish a transfer to the owner's own reserve from expenditure outside the investment. Explain when that reserve is spent and where any unused balance goes.

Verify amounts, dates and scope. Lease income may differ from collected cash; gross sale estimates differ from net proceeds. Verify applicable Saudi tax and transaction treatment for the actual case. This article supplies no universal rate or eligibility assumption. Keep unresolved costs visible.

Follow an original five-year SAR example

Imagine an unfinanced investment requiring SAR 1,000,000 at the start. It provides SAR 70,000 net operating cash at each year end for five years. A sale at the end of year five provides another SAR 1,000,000 net of every disposal outflow assumed in this fictional case. The annual operating amounts already reflect the imaginary costs specified by the exercise. No additional growth or borrowing is included.

The annual IRR is 7%. To check it, discount each later receipt by 1.07 raised to its year number, add those present values and subtract SAR 1,000,000. The result is zero apart from numerical rounding. All cash movements are equally spaced annual periods in this simplified example. The calculation therefore produces a rate per year, rather than a rate per month or another interval.

At a separate illustrative comparison rate of 8%, the same timeline has NPV of approximately minus SAR 39,927. The model's 7% IRR and negative NPV at 8% are consistent: the cash stream falls short of that chosen 8% comparison standard. Neither percentage is a recommendation for Saudi property. Retain the cash rows so a reader can change the comparison assumption and reproduce the result without relying on a quoted output.

Use actual dates when periods are irregular

Real cash flows seldom follow a perfectly neat year-end sequence. A deposit, completion payment, rent collection and sale settlement may occur on different dates. Microsoft's IRR documentation specifies regular intervals for that function. A monthly series consequently produces a monthly rate. Annualise such a rate through compounding: one plus the monthly rate raised to twelve, minus one. Multiplying by twelve is only an approximation.

For irregular dates, Microsoft's XIRR documentation describes a dated calculation using a 365-day year. Keep one matching date for each cash amount. Store dates as valid spreadsheet dates, not ambiguous text. Check the model's day-count convention when comparing outputs from different tools; a result based on actual days may differ slightly from an annual-period illustration, especially across leap years.

In a spreadsheet, place the example's six annual cash flows in B2:B7 and calculate =IRR(B2:B7). For a dated ledger with dates in A2:A7, use =XIRR(B2:B7,A2:A7). Some spreadsheet language settings use a semicolon separator. The function name alone cannot rescue a wrong range: confirm that the initial payment, final proceeds and any intervening payments are included. A reference that stops one row early can change the result substantially.

Use numeric zero for an empty regular period, because the IRR function ignores blank cells. Preserve chronological order and period labels. Retain each movement's date in a dated ledger; if grouping receipts, document that simplification and compare it with the detailed calculation.

Test timing, repairs and exit proceeds separately

Now change only when the fictional receipts arrive. Instead of receiving SAR 70,000 annually and SAR 1,000,000 at the end, suppose every receipt arrives together as SAR 1,350,000 at the end of year five. The total money received remains identical. The IRR becomes approximately 6.186% per year. At the illustrative 8% comparison rate, NPV becomes approximately minus SAR 81,213. Deferring receipts changes their present value.

This comparison isolates timing; it makes no claim that unpaid rent will be collected later. An actual delayed payment may also change the probability or amount of collection. Use the rental payment timing guide to examine those practical cash dates, then build a separate scenario if both timing and recoverability change. Combining several changes without naming them makes it difficult to explain the output.

Return to the original annual example and add a further SAR 40,000 repair payment at the end of year three. That year's net cash becomes SAR 30,000. IRR falls to approximately 6.203%, and NPV at 8% becomes approximately minus SAR 71,680. This payment is additional to the fictional operating costs already deducted. The capital repairs cash-flow guide helps organise the supporting cost schedule.

Finally, keep annual operating cash at SAR 70,000 but reduce net sale proceeds to SAR 900,000. The final row becomes SAR 970,000 and IRR falls to approximately 5.197%. NPV at 8% becomes approximately minus SAR 107,985. These are independent teaching scenarios, calculated before rounding. None forecasts a repair bill or selling price. A combined stress case can be useful afterwards, provided every changed input is labelled.

Read IRR beside value and available cash

A higher percentage does not necessarily mean a larger monetary contribution. Consider two further fictional one-year investments. One costs SAR 100,000 and returns SAR 120,000 after a year, producing 20% IRR. Another costs SAR 1,000,000 and returns SAR 1,150,000 after a year, producing 15% IRR. At an illustrative 8% comparison rate, their NPVs are approximately SAR 11,111 and SAR 64,815 respectively. Their scale differs substantially.

The larger case is not automatically suitable. Capital available, concentration, uncertainty and how remaining money is deployed matter. Keep NPV, total contribution, timing and investment size beside IRR. Explain which decision the comparison serves instead of declaring a winner from one column.

Liquidity also requires its own view. A forecast IRR can include an attractive final sale yet leave the owner short of money before a repair or financing payment. Add a cumulative cash balance and identify the deepest funding requirement. In a financed case, include the actual provider's settlement basis. Our debt-service coverage explanation examines operating cash relative to financing obligations; it answers a different question from lifetime IRR.

Do not silently assume that intermediate receipts are reinvested at the displayed IRR. The cash-flow percentage by itself does not document what the investor does with distributed money. If a comparison includes reinvestment, set out its separate rate, dates and costs. An ending-wealth calculation based on those additional assumptions may help, but it should remain distinguishable from the original property ledger and its own IRR.

Investigate unusual results and multiple solutions

A spreadsheet error is a prompt to inspect the cash flows, not an instruction to replace the result with zero. Confirm the signs, date types, range lengths and timing. A model containing only payments or only receipts lacks the ordinary investment pattern needed for this calculation. Review whether the sale proceeds were omitted or whether a cost was entered with the wrong sign. Keep any correction traceable to its supporting record.

Some cash patterns can have more than one IRR. An original mathematical illustration uses three annual movements: minus SAR 100,000, plus SAR 230,000, then minus SAR 132,000. It is deliberately an arithmetic example, not a typical property forecast. Discounting those rows at either 10% or 20% gives zero NPV. Both percentages solve the same equation, so quoting whichever a spreadsheet first returns would conceal the ambiguity.

The final negative movement is important in that example because cash changes from payment to receipt and back to payment. A late major outlay can create a similar reason to inspect a real ledger more closely, although a sign change does not automatically mean multiple valid solutions exist. Check the NPV at several explained rates and inspect the shape of the comparison. If a single IRR cannot describe the ledger clearly, report that limitation.

Separate numerical precision from evidential confidence. Many decimal places cannot strengthen a weak exit estimate. Round the public result sensibly while retaining precise working figures. Explain where uncertainty enters and which assumption controls the conclusion.

Prepare a reviewable IRR summary

Place the percentage beside an assumptions ledger. State currency, investor viewpoint, dates and whether the result is forecast or realised. Explain initial outlay, operating cash and net proceeds. Record omissions so readers can determine whether proposals use the same scope.

Add a short sensitivity section showing which single changes affect the result most. Keep the original case alongside the altered cash rows, rather than saving only a new percentage. Identify the evidence required to replace each assumption: documented receipts, a cost quotation, financing terms or a supported disposal estimate. Set a review trigger when material evidence changes. The property exit liquidity guide provides next-reading questions about the assumed sale date.

In its investor-awareness material, the Saudi Capital Market Authority's Thameen platform warns about unrealistic guaranteed-return claims and highlights investment risk. Here that supports a limited point: a projected IRR is not a guarantee. The securities-awareness source does not establish a licensing rule for every direct property transaction, and this article does not transfer its product-specific requirements to an individual home.

Conclude with the finding under the stated cash-flow assumptions, its funding requirement and timing or exit sensitivity. Retain the ledger, evidence dates and unanswered questions together. The next review can improve the inputs while preserving a clear meaning for the measurement.