The directors of AAP company limited has decided to limit investment funds to $1
ID: 2806105 • Letter: T
Question
The directors of AAP company limited has decided to limit investment funds to $10 million for the next year and is preparing its capital budget. The company is considering five projects, as follows:
Initial investment Net present value
Project A $2,500,000 $1,000,000
Project B $2,200,000 $1,550,000
Project C $2,600,000 $1,350,000
Project D $1,900,000 $1,500,000
Project E $5,000,000 To be calculated
All five projects have a project life of four years. Projects A, B, C and D are divisible, and Projects B and D are mutually exclusive. All net present values are in nominal, after-tax terms.
Project E
This is a strategically important project which the Board of AAP Co have decided must be undertaken in order for the company to remain competitive, regardless of its financial acceptability. Information relating to the future cash flows of this project is as follows:
Year 1 2 3 4
Sales volume (units) 12,000 13,000 10,000 10,000
Selling price ($/unit) 450 475 500 570
Variable cost ($/unit) 260 280 295 320
Fixed costs ($000) 750 750 750 750
These forecasts are before taking account of selling price inflation of 5•0% per year, variable cost inflation of 6•0% per year and fixed cost inflation of 3•5% per year. The fixed costs are incremental fixed costs which are associated with Project E. At the end of four years, machinery from the project will be sold for scrap with a value of $400,000.
AAP Co has a nominal after-tax cost of capital of 13% per year.
Required:
e) Evaluate the financial acceptability of project E using:
i. a nominal terms net present value approach
ii. an internal rate of returns approach
f) Calculate the maximum net present value which can be obtained from investing the fund of $10 million, assuming here that the nominal after-tax NPV of Project E is zero.
Explanation / Answer
e) i) NPV Approach -
Initial Investment = $ 5000000
Yearwise cash flows can be calculated as follows-
Year
1
2
3
4
Sales Volume
12000
13000
10000
10000
Selling Price(Inflation Adjusted)
450.00
498.75
551.25
659.85
Variable Cost(Inflation Adjusted)
260.00
296.80
331.46
381.13
Fixed Cost(Inflation Adjusted)
750.00
776.25
803.42
831.54
Sales Value(volume x Price)
5400000.00
6483750.00
5512500.00
6598462.50
Total Variable Cost(v. c x volume)
3120000.00
3858400.00
3314620.00
3811251.20
Contribution
2280000.00
2625350.00
2197880.00
2787211.30
Less : FC
750000.00
776250.00
803418.75
831538.41
Net Benefit
1530000.00
1849100.00
1394461.25
1955672.89
Salvage Value $ 400000 in fourth year , discounted @ 13%, we get $ 245327.49
So, Net Present Value = Sum of Discounted Cash Flows + Salvage Value -initial Investment
$ 5213308.73 - $ 5000000 = $ 213308.73
ii) IRR Approach-
Net Cash Flows
1530000.00
1849100.00
1394461.25
1955672.89
Discounted @ 13%
1353982.30
1448116.53
966431.60
1199450.81
Discounted @ 15%
1330434.78
1398185.26
916880.91
1118162.32
Sum of Cash Flows discounted @ 15%
$ 4763663.27 + Salvage Value discounted @ 15% ($ 228701.30) = $ 4992364.57
IRR = 15% - (5000000 - 4992364.57)/( 5213308.73 - 4992364.57) x 2% =15 - 0.07 = 14.93%
f) NPV per rupee of investment -
Project A - (1000000/2500000) = 0.40 Rank - 4
Project B - (1550000/2200000) = 0.70 Rank - 2
Project C - (1350000/2600000) = 0.52 Rank - 3
Project D - (15000000/1900000) = 0.79 Rank -1
Investing as per rank above, - Project D (1.9 Mn) + Project C (2.6 Mn) + Project A (2.5 Mn)
NPV will be 1 + 1.35 + 1.5 = $ 3.85 Mn
Investing in project A, B & C - NPV will be - 1 + 1.55 + 1.35 = $ 3.90 Mn
Therefore, Max NPV will be $ 3.90 Mn
Year
1
2
3
4
Sales Volume
12000
13000
10000
10000
Selling Price(Inflation Adjusted)
450.00
498.75
551.25
659.85
Variable Cost(Inflation Adjusted)
260.00
296.80
331.46
381.13
Fixed Cost(Inflation Adjusted)
750.00
776.25
803.42
831.54
Sales Value(volume x Price)
5400000.00
6483750.00
5512500.00
6598462.50
Total Variable Cost(v. c x volume)
3120000.00
3858400.00
3314620.00
3811251.20
Contribution
2280000.00
2625350.00
2197880.00
2787211.30
Less : FC
750000.00
776250.00
803418.75
831538.41
Net Benefit
1530000.00
1849100.00
1394461.25
1955672.89
Discounted @ 13% 1353982.30 1448116.53 966431.60 1199450.81