In: Finance
Calculation of total finance needed: | |
Equipment cost | 40000000 |
Installation & set up costs | 5500000 |
Initial working capital(NWC 0) | 10000000 |
Total capital needed | 55500000 |
After-tax sale proceeds of land & bldg. | -1500000 |
Amt. that can be raised from new rights equity issue | -15000000 |
Balance to be raised thro'bonds | 39000000 |
Cost of equity , ke, as per CAPM= RFR+(Beta*Market risk premium) |
ie. RFR+(Beta*(Av. Mkt. return-RFR)) |
5%+(2.5*(10%-5%))= |
17.5% |
After-tax cost of bonds, kd =Before-tax yield*(1-Tax rate) |
ie.12%*(1-25%)= |
9% |
so, now the WACC=(Wt.d*kd)+(wt.e*ke) |
((39/(39+15))*9%)+((15/(39+15))*17.5%)= |
11.36% |
Year | 0 | 1 | 2 | 3 | 4 | 5 |
1.Equipment cost | -40000000 | |||||
2.Installation & set up costs | -5500000 | |||||
NWC reqd. | 10000000 | 15400000 | 16940000 | 18634000 | 20497400 | 0 |
3.Change in NWC | -10000000 | -5400000 | -1540000 | -1694000 | -1863400 | 20497400 |
4.After-tax salvage(2000000*(1-25%)) | 1500000 | |||||
Operating cash flows: | ||||||
5.Sales units p.a. | 400000 | 400000 | 400000 | 400000 | 400000 | |
6.Selling price/unit | 385 | 423.5 | 465.85 | 512.435 | 563.6785 | |
7.Total sales $(5*6) | 154000000 | 169400000 | 186340000 | 204974000 | 225471400 | |
8.Varible cost/unit | -157.5 | -165.375 | -173.64375 | -182.32594 | -191.44223 | |
9.Variable cost $(5*8) | -63000000 | -66150000 | -69457500 | -72930375 | -76576894 | |
10.Mktg. exp.(sales $ *5%) | -7700000 | -8470000 | -9317000 | -10248700 | -11273570 | |
11.OH costs | -6000000 | -6000000 | -6000000 | -6000000 | -6000000 | |
12.Depn.(45500000-2000000)/5 | -8700000 | -8700000 | -8700000 | -8700000 | -8700000 | |
13.EBIT(7-sum(9 to 12) | 68600000 | 80080000 | 92865500 | 107094925 | 122920936 | |
14.Tax at 25%(13*25%) | -17150000 | -20020000 | -23216375 | -26773731 | -30730234 | |
15.EAT (13+14) | 51450000 | 60060000 | 69649125 | 80321193.8 | 92190702.2 | |
16.Add back"depn.(Row 12) | 8700000 | 8700000 | 8700000 | 8700000 | 8700000 | |
17.Incremental Contribution loss-old vaccine(100-70)*10000 | -300000 | -300000 | -300000 | -300000 | -300000 | |
18.Operating cash flows(15=16+17) | 59850000 | 68460000 | 78049125 | 88721193.8 | 100590702 | |
19.Net annual FCFs(1+2+3+4+18) | -55500000 | 54450000 | 66920000 | 76355125 | 86857793.8 | 122588102 |
20.PV F at 11.36%(1/1.1136^Yr.n) | 1 | 0.89799 | 0.80638 | 0.72412 | 0.65025 | 0.58392 |
21.PV at 11.36%(19*20) | -55500000 | 48895474.1 | 53963174 | 55290501 | 56479638 | 71581733.3 |
22. NPV(sum of row 21) | 230710521 | |||||
PI=1+(NPV/Initial Investment) | ||||||
ie.1+(230710521/55500000)= | ||||||
5.16 | ||||||
b. Three (3) qualitative factors that the Management of CPC might have to consider: |
1.The suceess of the new vaccine , is treating the pandemic . |
2. the accuracy of the demand rate forecasted |
3. The advent or not of competitors' products for preventing /treating the current novel coona virus |
all the above will dictate CPC's decision to produce more or less of this type of vaccine. |
c.Circumstances when profitability index will be preferred to NPV as project evaluation techniques: |
1. When there are more than one opportunity available --with different levels of initial investments, we need to compare the net return to the initial investment required--that is we do, 1+ NPV/Initial investment) |
If the result is < 1, it is evident that NPV is negative--so the project may not be selected. |
If it is >1, then that which is greater will be selected, depending upon the level of investment, affordable at that point of time. |
d. Sunk costs are those costs that have already been incurred & nothing can be done now, to reverse that decision. They are past or historical costs, from which can only be evaluated. |
In the given case, |
Feasibility studies cost the company GH¢2,000,000 |
Test marketing expenses amounts to GH¢1,000,000 |
The research into the discovery of the vaccine costs GH¢5,000,000 |
are all sunk costs --though very necessary for the project--have all been incurred in the past. |
where as, |
Incremental Contribution lost due to loss of sales of old vaccine to the tune of 10000 units , ie.(100-70)*10000= 300000---- is a negative externality of the introdution of the new vaccine project , in that it cannibalises the sales revenue from the older vaccine & we consider the net revenues(ie. sales-costs), in the NPV calculations. |
Similarly,projects have opportunity costs like the revenue from rental income might have to be foregone, in giving space to operate this project.So, that rental income sacrificed for the sake of this project, is counted as cost of this project , for NPV calculations. |