PLAN60191 Chap.3 Discounted Cash Flow Valuation
Discounted Cash Flow Valuation
Discounted Cash Flow Valuation turns a property strategy into dated cash flows. Time zero contains purchase and acquisition costs. Holding-period rows forecast rent, vacancy, operating expenses, capital expenditure and net operating income. The terminal period combines ordinary operating cash with net sale proceeds. A sale at the end of a year generally capitalises the following year's NOI, so timing must be explicit.
NPV measures money value added at a target return, while IRR finds the rate that sets NPV to zero. The two measures should use one audited cash-flow row. Sensitivity analysis then tests rent, cost, discount-rate and exit-cap-rate assumptions, including compound downside rather than isolated changes. The chapter treats the spreadsheet as an auditable argument: forecast first, reconcile second, discount third and interpret last.
What this chapter covers
- 01
Cash-flow timeline
- 02
NOI forecasting
- 03
Terminal value
- 04
Discount rate
- 05
Net present value
- 06
IRR and sensitivity
Worked example · free
Value a five-year acquisition
- 2Add sale proceeds to Year 5 NOI to form a £5,651,117 final cash flow.
- 3Discount all five future cash flows at 9% to obtain present value of £4,818,802.
- 3NPV is £618,802 and IRR is approximately 12.5%, so the base case clears the target.
Key terms
- Terminal value
- The estimated sale value at the end of the forecast holding period.
- Net present value
- Discounted cash inflows less discounted cash outflows at the target return.
- Internal rate
- The discount rate at which the cash-flow series has zero net present value.
Discounted Cash Flow Valuation FAQ
Which NOI belongs in terminal value?
When sale occurs at the end of Year 5, the capitalised numerator commonly represents Year 6 forward NOI because the buyer is paying for income after acquisition. Check the convention in the model and do not automatically use the final holding-year NOI.
Why can NPV and IRR differ in rankings?
Mutually exclusive projects can differ in scale and cash-flow timing. IRR expresses a percentage break-even rate, while NPV measures money value added at the chosen opportunity cost. For a direct value decision between comparable-risk alternatives, NPV normally provides the clearer ranking.
What should sensitivity analysis stress?
Stress the variables that drive the decision, especially rent, vacancy, capital expenditure, discount rate and terminal cap rate. Combine plausible adverse changes because weaker income and higher exit yields can occur together. Report the point at which the recommendation changes.
Assessment move
Build every DCF from a timeline rather than from spreadsheet functions. Label time zero, operating years and sale date. Forecast gross income, vacancy, recurring expenses and capital expenditure in separate rows so the source of NOI change is visible. Use forward NOI for terminal value when the timing requires it, deduct sale costs and add the final operating cash once.
Print the complete cash-flow row used by NPV and IRR and reconcile it to the pro forma. Recompute one period by hand. Test that a higher discount rate lowers NPV and a higher terminal cap rate lowers sale value when income is unchanged. Create a two-variable sensitivity grid for NOI and exit cap rate, then describe the decision boundary instead of selecting the best cell.
Match nominal cash flows with a nominal rate and real cash flows with a real rate. Finish with a decision, the target return and the assumption most likely to reverse it. Create a lease-level bridge from passing rent to effective gross income, including expiry, review, downtime, incentives and bad debt where relevant. Convert that bridge into an annual pro forma and check each subtotal against a stated definition.
Maintain a separate capital schedule so recurring repairs, tenant improvements and major refurbishment are not hidden inside an unexplained growth rate. For terminal value, show the forward income period explicitly and reconcile sale proceeds before and after transaction costs. Run a formula audit that traces the NPV and IRR ranges, checks sign changes and confirms that no terminal value is counted twice.
Use scenario columns for leasing, operating cost and exit pricing, but change only assumptions that logically belong together. Pair the scenario table with a source log containing date, geography, asset type and limitation. In the written answer, explain why the selected discount rate and exit yield fit the cash-flow risk.
Close by identifying the valuation range, the investment threshold and the observable event that would trigger a revised recommendation. Save a clean control version of the model before changing scenarios. For each later case, record only the assumptions changed and reconcile the valuation movement to those changes.
Review formulas across rows and down columns for inconsistent references, and use an independent direct-capitalisation estimate as a reasonableness check rather than a substitute for the DCF.
Working through Discounted Cash Flow Valuation in PLAN60191? Sia is AskSia’s AI Finance tutor — ask any PLAN60191 Discounted Cash Flow Valuation question and get a clear, step-by-step explanation grounded in how PLAN60191 is taught and assessed. Read this chapter free, then take your hardest questions to Sia.