The University of Manchester · FACULTY OF FINANCE

PLAN60191 Chap.3 Discounted Cash Flow Valuation

- one subject, every graph, every model, every mark
6 Chapters4-page Bible
Our own words - no uploaded lecturer files
Updated for this semester
Chapter 3 of 10 · PLAN60191

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.

In this chapter

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

Q [8 marks]. A property costs £4.20 million. Five annual NOI figures are £330,000, £346,500, £363,825, £382,016 and £401,117, followed by £5.25 million net sale proceeds. Use 9%. The mark allocation is a revision aid and is not a University marking scheme.
The timeline places the £4.20 million purchase against the worked acquisition cash flows and combines £401,117 Year 5 NOI with £5.25 million net sale proceeds bThe timeline places the £4.20 million purchase against the worked acquisition cash flows and combines £401,117 Year 5 NOI with £5.25 million net sale proceeds before discounting. -£4.20m£330k£347k£364k£382k£5.65moperating NOINOI plus exit
The timeline places the £4.20 million purchase against the worked acquisition cash flows and combines £401,117 Year 5 NOI with £5.25 million net sale proceeds before discounting.
  • 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.
Base-case NPV is £618,802 and IRR is about 12.5%. The marks shown are original practice weighting.
Sia tip — Put final-year NOI and net sale proceeds in the same period without counting either twice.
Glossary

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.
FAQ

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.

Study strategy

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.

A+Everything unlocked
Unlocks this Bible + all 41 of your subjects at The University of Manchester, plus 1,000+ more Bibles across the AskSia library.
Sia - your PLAN60191 tutor, unlimited, worked the way the exam marks it
The full 4-page Bible + practice bank with worked solutions
Chrome extension - sync your LMS so Sia knows your deadlines
Bilingual EN / Chinese on every Bible and every Sia answer
$0.99 Trial
30-day money-back · cancel in one tap · how it works