Table of Contents
Type: Coursework | Subject: Finance | Level: Masters | Word Count: ~3,500 words
This model coursework was produced by an Essays UK specialist as reference material for learning purposes only. For support in this field, see our accounting and finance writers.
Overview: This Masters-level finance coursework appraises a hypothetical 25 MW onshore wind investment using discounted cash flow techniques. It derives a cost of capital, builds a twenty-year cash flow model, and applies net present value, internal rate of return, payback and profitability index, before stress-testing the decision through sensitivity and scenario analysis. All figures are illustrative and intended to demonstrate method, not to report real project data.
Capital investment decisions are among the most consequential choices a firm makes, because they commit large and largely irreversible sums in exchange for cash flows that will not fully materialise for many years. This is especially true in the renewable energy sector, where projects are heavily front-loaded: almost the entire cost is incurred before a single unit of electricity is generated, and returns then accrue slowly across two decades or more. The discipline of investment appraisal exists to impose structure on such decisions, translating uncertain future benefits into a single present-day measure of value against which managers can act (Brealey, Myers and Allen, 2020).
This coursework examines the appraisal of a proposed onshore wind farm by a fictional UK generator, referred to throughout as Caledonia Renewables plc. The purpose is not to recommend the specific investment in isolation but to demonstrate how a Masters-level analyst would construct and defend an appraisal, selecting appropriate techniques, justifying each assumption, and interpreting the results with due regard for their limitations. The analysis proceeds from sector context and the proposal, through methodology and the derivation of a discount rate, to the base-case cash flows, the headline appraisal measures, and finally sensitivity and scenario testing before a reasoned recommendation. Throughout, the figures are plausible but illustrative, chosen to exercise the techniques rather than to describe any actual development.
Renewable generation projects present a distinctive appraisal profile. They are extremely capital-intensive, with the majority of lifetime expenditure falling in the construction phase, yet their operating costs are modest and their fuel cost is effectively zero. The economic value of such a project is therefore governed by three variables above all: the capital cost per unit of capacity, the volume of electricity produced across the asset’s life, and the price at which it is sold. Small movements in any of these can tip a project from value-creating to value-destroying, which is why appraisal must be accompanied by explicit risk analysis.
The UK policy environment shapes each of these variables. Support mechanisms such as the Contract for Difference scheme provide revenue certainty by guaranteeing a strike price for a defined period, insulating developers from wholesale market volatility; where output is sold on a merchant basis instead, revenue is exposed to a power price that has been both cyclical and, at times, extremely volatile. The appraisal below assumes a blended selling price reflecting a mixture of contracted and merchant exposure, and the sensitivity analysis demonstrates how dependent the conclusion is on it. An appraisal is only as credible as the assumptions that feed it, and a competent analyst makes those assumptions transparent and contestable.
A final point concerns the time horizon. Onshore wind assets are modelled over a twenty- to twenty-five-year life, after which they are repowered or decommissioned. A long horizon magnifies the influence of the discount rate, because later cash flows are heavily reduced in present value terms, a theme that recurs below.
Caledonia Renewables plc is evaluating a 25 MW onshore wind farm on a well-exposed site in central Scotland. The headline parameters, all illustrative, are summarised below.
The management question is simple to state and harder to answer: does committing £30 million today create value for shareholders, and how confident can the board be given the uncertainties involved? The remainder of this coursework addresses that question.
The appraisal relies principally on discounted cash flow (DCF) techniques, which recognise that money has a time value: a pound received in ten years is worth less than a pound today, because the latter can be invested to earn a return in the interim. DCF methods convert the project’s forecast cash flows into comparable present-day values using a discount rate that reflects the opportunity cost of the capital employed (Watson and Head, 2019). Two DCF measures form the core of the analysis, with two further measures addressing liquidity and efficiency.
Net present value is the sum of all project cash flows, each discounted back to the present at the firm’s cost of capital, with the initial outlay treated as a negative flow. A positive NPV indicates that the project is expected to generate returns in excess of the cost of the capital tied up in it, and therefore to increase shareholder wealth; a negative NPV indicates the opposite. The decision rule is to accept projects with a positive NPV and, where projects are mutually exclusive, to prefer the one with the higher NPV. NPV is widely regarded as theoretically superior because it measures value in absolute monetary terms, assumes reinvestment at the cost of capital, and can accommodate changing discount rates and non-conventional cash flow patterns (Pike, Neale and Linsley, 2018).
The internal rate of return is the discount rate at which a project’s NPV equals zero. It expresses the return as a percentage, which many managers find intuitive, and the decision rule is to accept a project whose IRR exceeds the cost of capital. IRR is popular in practice, used at least as widely as NPV among finance executives (Graham and Harvey, 2001). It nevertheless carries well-documented shortcomings: it assumes interim cash flows are reinvested at the IRR itself, which may be unrealistic; it can produce multiple values where cash flows change sign more than once; and it can rank mutually exclusive projects incorrectly because it ignores scale. These limitations are examined in the discussion.
Two supplementary measures complete the toolkit. The payback period measures the time taken for cumulative inflows to recover the initial outlay; the discounted variant performs the same calculation using discounted flows, respecting the time value of money. Payback is a crude measure of risk and liquidity rather than of value, because it ignores cash flows beyond the payback point, but it remains informative for capital-constrained firms. The profitability index expresses the present value of future cash flows as a ratio of the initial outlay; a value above one is equivalent to a positive NPV, and it is useful for ranking projects when capital is rationed (Atrill and McLaney, 2019).
The appropriate discount rate for an equity-and-debt-financed company is its weighted average cost of capital (WACC), which blends the required returns of each source of finance in proportion to their market-value weights. The cost of equity is estimated using the capital asset pricing model, which adds a risk-adjusted premium to the risk-free rate; the cost of debt is the borrowing yield, reduced for the tax deductibility of interest. The components adopted for Caledonia Renewables, illustrative but grounded in typical UK parameters, are set out below.
| Component | Inputs | Value |
|---|---|---|
| Cost of equity (CAPM) | Risk-free rate 4.0% + beta 1.08 × equity risk premium 6.0% | 10.5% |
| Cost of debt (after tax) | Pre-tax 5.7% × (1 − 0.25 tax) | 4.3% |
| Equity weight | Market value of equity / total capital | 60% |
| Debt weight | Market value of debt / total capital | 40% |
| Weighted average cost of capital | (0.60 × 10.5%) + (0.40 × 4.3%) | 8.0% |
The resulting WACC of 8.0 per cent is adopted as the base-case discount rate and as the hurdle rate against which the IRR is judged. One subtlety should be acknowledged: a firm’s WACC reflects the average risk of its existing business, whereas a specific project may be more or less risky, so a project-specific rate derived from the betas of comparable developers would be more defensible. The analysis proceeds with the firm’s WACC for transparency but varies the discount rate explicitly in the sensitivity section.
The annual operating cash flow is derived from revenue, operating costs, depreciation and tax. Although depreciation is a non-cash charge, it is relevant because it reduces taxable profit and therefore the cash tax paid; it is deducted to reach taxable profit and then added back to reach cash flow. The model assumes straight-line depreciation and capital allowances over the twenty-year life, a simplification noted later as a limitation, and applies corporation tax at the main rate of 25 per cent. The resulting steady-state cash flow for a representative year is shown below.
| Line item | Amount (£) |
|---|---|
| Revenue (83,200 MWh × £75) | 6,200,000 |
| Operating costs | (1,700,000) |
| Earnings before interest, tax, depreciation | 4,500,000 |
| Depreciation / capital allowance | (1,500,000) |
| Taxable profit | 3,000,000 |
| Corporation tax at 25% | (750,000) |
| Profit after tax | 2,250,000 |
| Add back depreciation | 1,500,000 |
| Net operating cash flow | 3,750,000 |
For modelling purposes the net operating cash flow of £3.75 million is treated as constant across the twenty years, holding revenue, output and costs flat in nominal terms. Two non-recurring items are layered onto this annuity: the mid-life refurbishment of £3.5 million in Year 10 and the net decommissioning cost of £1.0 million in Year 20. The full profile is therefore a £30 million outflow at Year 0, a £3.75 million inflow in each of Years 1 to 20, and the two additional outflows in Years 10 and 20.
Discounting the cash flows at the 8.0 per cent WACC produces the present values set out below. The twenty-year inflow is valued as an annuity using the present value annuity factor at 8 per cent, which is 9.818, while the two lumpy outflows are discounted using the single-sum discount factors for Years 10 and 20.
| Cash flow | Nominal (£) | Discount factor | Present value (£) |
|---|---|---|---|
| Year 0 capital outlay | (30,000,000) | 1.000 | (30,000,000) |
| Years 1–20 operating flows | 3,750,000 p.a. | 9.818 (annuity) | 36,817,900 |
| Year 10 refurbishment | (3,500,000) | 0.463 | (1,621,200) |
| Year 20 net decommissioning | (1,000,000) | 0.215 | (214,600) |
| Net present value | +4,982,100 |
The base-case NPV is positive at approximately £4.98 million. On the NPV decision rule the project should be accepted: it returns the full 8.0 per cent cost of capital and adds roughly £5 million of value on top. Because NPV is additive and expressed in money terms, it can be read directly as the forecast increase in the firm’s value, subject to the reliability of the assumptions.
The IRR is the discount rate at which the NPV collapses to zero. Because the cash flow pattern is close to conventional, a single IRR exists and is readily found by interpolation. At a 10 per cent rate the NPV is still slightly positive at around £0.43 million, while at 11 per cent it turns negative at around −£1.49 million; interpolation places the IRR at approximately 10.2 per cent. Because this comfortably exceeds the 8.0 per cent hurdle, the IRR criterion also supports acceptance. The gap of roughly 2.2 percentage points is the project’s margin of safety in return terms: the discount rate would have to rise by that much before the investment ceased to be worthwhile.
The simple payback period is exactly 8.0 years, since the £30 million outlay is recovered by uniform £3.75 million annual inflows. The discounted payback period is longer at approximately 14.6 years, reflecting how heavily later cash flows are discounted. Both fall comfortably within the twenty-year life, but the discounted figure underlines that the project is a long-duration commitment whose value is realised slowly. The profitability index, calculated as the present value of future cash flows (£34.98 million) divided by the initial outlay (£30 million), is 1.17, confirming that each pound invested is expected to generate £1.17 of discounted return. The complete set of results is summarised below.
| Measure | Result | Decision rule | Verdict |
|---|---|---|---|
| Net present value | +£4.98m | Accept if > 0 | Accept |
| Internal rate of return | 10.2% | Accept if > 8.0% WACC | Accept |
| Profitability index | 1.17 | Accept if > 1.0 | Accept |
| Simple payback | 8.0 years | Accept if < target | Accept |
| Discounted payback | 14.6 years | Accept if < life (20) | Accept |
All five measures point the same way, which is reassuring but not sufficient on its own. They are not independent: NPV, IRR and the profitability index all draw on the same forecast cash flows, so an error in those forecasts would contaminate every measure at once. The value of the analysis therefore depends less on the criteria agreeing than on whether the inputs behind them are robust, the question the next section addresses.
A single-point NPV conceals the uncertainty that pervades a twenty-year forecast. Sensitivity and scenario analysis expose it by asking how far the inputs can move before the decision changes, and what happens under consistent combinations of adverse or favourable assumptions. This is where a competent appraisal distinguishes itself from a mechanical calculation.
One-way sensitivity analysis varies a single input while holding the others constant, identifying the break-even value at which NPV reaches zero. The results reveal where the project is most exposed.
The ranking is instructive. The decision hinges most tightly on revenue, the variable over which management has least control and which is most affected by external power prices and weather-driven output. This should shape the firm’s risk management: securing more output under a fixed-price contract would materially reduce the probability of a value-destroying outcome.
Whereas one-way analysis moves variables in isolation, scenario analysis combines them into coherent narratives. Three are modelled: a base case; an optimistic case with the blended price 10 per cent higher; and a pessimistic case with the price 15 per cent lower, capital expenditure 10 per cent higher and operating costs 10 per cent higher, a plausible cluster of adverse outcomes.
| Scenario | Key assumptions | NPV (£) | IRR |
|---|---|---|---|
| Optimistic | Price +10% (£82.5/MWh) | +9,548,000 | ~12.4% |
| Base | As modelled above | +4,982,000 | ~10.2% |
| Pessimistic | Price −15%, capex +10%, opex +10% | −5,750,000 | < 8% |
The scenario spread is wide, swinging from roughly +£9.5 million to −£5.8 million, which confirms that the base-case recommendation is contingent rather than secure. The pessimistic case turns the project value-destroying, with an IRR below the hurdle rate, and it is not implausible: power price weakness, construction overrun and cost inflation are correlated risks that can arrive together. The analysis therefore supports not unconditional acceptance but acceptance conditional on measures that curtail the downside, chiefly revenue certainty and capital cost control.
In this appraisal NPV and IRR agree, but it is worth articulating why NPV should be treated as the primary criterion where the two might diverge. IRR expresses return as a percentage and so discards information about scale: a small project with a high percentage return may add less absolute value than a large one with a more modest return, which matters greatly for a firm choosing between mutually exclusive projects or allocating a fixed budget. IRR also embeds an optimistic reinvestment assumption, implicitly crediting interim cash flows with the project’s own return rather than the cost of capital at which they can realistically be redeployed; where this is unwarranted, the modified internal rate of return corrects it by discounting at the WACC (Arnold and Lewis, 2019). Finally, IRR can break down where cash flows change sign more than once, producing multiple rates or none. For the present project, whose flows turn negative only briefly in Years 10 and 20, the sign changes do not generate multiple IRRs, so the single value is reliable; but the analyst should check this condition rather than assume it. NPV is robust across all these situations, which is why it is the default criterion in theory even though IRR remains more popular in practice.
Several simplifications qualify the results and would be refined in a full investment case. First, the cash flows are held flat in nominal terms, whereas revenue, costs and output would vary year to year; a genuine model would separate real and inflationary movements and treat generation as a distribution rather than a point estimate. Second, the tax treatment is simplified to straight-line allowances, whereas the UK regime applies specific capital allowance rules whose timing would alter the present value of the tax shield. Third, the project is appraised at the firm’s WACC, which may not reflect its specific risk; a project-level rate derived from the asset betas of comparable developers would be more defensible. Fourth, the model treats the WACC as capturing all financing effects, whereas the project finance arrangements common in the sector could change the risk borne by equity. None of these limitations invalidates the method, but each is a reminder that an appraisal is a model of reality, not reality itself, and should be held with appropriate humility.
A purely financial appraisal, however rigorous, is a necessary but not sufficient basis for a strategic decision. Several factors sit outside the NPV calculation yet bear directly on it. The project carries embedded real options – the flexibility to repower the site, to expand if the grid connection permits, or to abandon if conditions deteriorate – each of which has value that a static DCF understates (Dixit and Pindyck, 1994; Trigeorgis, 1996). There are strategic considerations too, including the firm’s wish to grow its renewable portfolio ahead of tightening carbon regulation, and stakeholder benefits that are real but difficult to monetise. Conversely, there are non-financial risks, from planning and community opposition to grid curtailment, that could impair the forecast cash flows in ways the model does not capture. A mature board treats the financial appraisal as the spine of the decision while weighing these qualitative factors around it, rather than letting a single NPV figure settle the matter alone (HM Treasury, 2022).
On the evidence of the appraisal, the project should proceed, but conditionally. The base case is clearly value-creating, with a positive NPV of approximately £4.98 million, an IRR of 10.2 per cent against an 8.0 per cent hurdle, and a profitability index of 1.17. However, the analysis shows this conclusion is fragile with respect to revenue, and that a realistic combination of adverse outcomes would destroy value. The recommendation is therefore to approve the investment subject to three safeguards.
With these conditions attached, the investment is consistent with shareholder value creation and the firm’s strategic direction. Without them, the board would be justified in deferring the decision pending improved contractual terms.
This coursework has demonstrated the full cycle of a Masters-level investment appraisal, from establishing context and defining the proposal to deriving a discount rate, building cash flows, computing the decision measures and stress-testing them. The headline conclusion is that the proposed 25 MW onshore wind farm creates value under base-case assumptions, with every measure supporting acceptance. The more important conclusion is methodological: the credibility of an appraisal rests not on the apparent precision of its headline NPV but on the transparency of its assumptions and the rigour of its risk analysis. NPV should be the primary criterion on theoretical grounds, with IRR, payback and the profitability index offering complementary perspectives on return, liquidity and efficiency. Above all, investment appraisal is a framework for disciplined judgement rather than a substitute for it: the numbers inform the decision, but a competent analyst reads them critically, acknowledges their limits, and weighs the qualitative and strategic considerations that a spreadsheet cannot contain.
You May Also Like
All work is written by human writers. 100% AI free, guaranteed.
100% money back guarantee if you find plagiarism in our work.
COMPANY DETAILS
