Application of sensitivity analysis Swift has a cost of capital of 12 per cent and

Question

Application of sensitivity analysis

Swift has a cost of capital of 12 per cent and plans to invest £7m in a machine with a life of four years. The units produced will have a selling price of £9.20 each and will cost £6 each to make. It is expected that 800,000 units will be sold each year. By how much will each variable have to change to make the NPV zero? What are the key variables for the project?

Accepted Answer

The relative change in each project variable needed to make the NPV zero can be calculated as:

[latex]\cfrac{ ext { NPV }}{ ext { Present value of cash flows linked to project variable }}[/latex]

Calculating the net present value of the project:

[latex]\begin{array}{lc} & £ \ ext { Present value of sales revenue }=9.20 imes 800,000 imes 3.037= & 22,352,320 \ ext { Present value of variable costs }=6.00 imes 800,000 imes 3.037= & \underline{14,577,600} \ ext { Present value of contribution } & \underline{7,774,720} \ ext { Initial investment } & \underline{7,000,000} \ ext { Net present value } & \underline{774,720}\end{array}[/latex]

We can now calculate the relative change needed in each variable to make the NPV zero.

Initial investment
The NPV becomes zero if the initial investment increases by an absolute amount equal to the NPV (£774,720), which is a relative increase of 11.1 per cent:

[latex]100 imes(774,720 / 7,000,000)=11.1 \%[/latex]

Sales price
The relative decrease in sales revenue or selling price per unit that makes the NPV zero is the ratio of the NPV to the present value of sales revenue:
[latex]100 imes(774,720 / 22,352,320)=3.5 \%[/latex]
This is an absolute decrease of £9.20 × 0.035 = 32 pence, so the selling price that makes the NPV zero is 9.20 - 0.32 = £8.88.
Variable cost
Since a decrease of 32 pence in selling price makes the NPV zero, an increase of 32 pence or 5.3 per cent in variable cost will have the same effect. Confirming this:
[latex]100 imes(774,720 / 14,577,600)=5.3 \%[/latex]
Sales volume
The relative decrease in sales volume that makes the NPV zero is the ratio of the NPV to the present value of contribution:
[latex]100 imes(774,720 / 7,774,720)=10.0 \%[/latex]
This is an absolute decrease of 800,000 × 0.1 = 80,000 units, so the sales volume that makes the NPV zero is 800,000 - 80,000 = 720,000 units.

Project discount rate
What is the cumulative present value factor that makes the NPV zero? We have:

[latex]((9.20-6.00) imes 800,000 imes C P V F)-7,000,000=0[/latex]

and so:

[latex]C P V F=7,000,000 /((9.20-6.00) imes 800,000)=2.734[/latex]

Using the table of cumulative present value factors on page 483, and looking along the row of values for a life of four years (as project life remains constant), we find that 2.734 corresponds to a discount rate of almost exactly 17 per cent, an increase in the discount rate of 5 per cent in absolute terms or 41.7 per cent in relative terms (100 × 5/12). Note that this is the method for finding the internal rate of return of an investment project that was described in Section 6.4.
Our sensitivity analysis is summarised in Table 7.4. The project is most sensitive to changes in selling price and variable cost per unit and so these are the key project variables.

Question 7.E.X.4.1: Application of sensitivity analysis Swift has a cost of ca...

Related Answered Questions

What is the relevance of the efficient market hypothesis for the financial manager? ...

Verified Answer:

Explain the meaning of economic value added. How can EVA help financial managers to create value for shareholders? ...

Verified Answer:

What are the potential problems associated with using ratio analysis to analyse the financial health and performance of companies? ...

Verified Answer:

Describe benchmarks that can be used when assessing financial performance. ...

Verified Answer:

Which of the following statements about capital market efficiency is not correct? (a) If a stock market is weak form efficient, chartists cannot make abnormal returns. (b) If a stock market is strong form efficient, only people with insider information can make abnormal returns. ...

Verified Answer:

Why is it difficult to test for strong form efficiency? ...

Verified Answer:

Describe the factors influencing the relative proportions of internal and external finance ...

Verified Answer: