In: Finance
You have been asked to analyze whether Proxima Inc, a computer manufacturer, should invest in producing new software.
• Proxima will have to invest $ 5 million if it wants to commercially develop the software, and this investment will be depreciated straight line over four years to a salvage value of zero at the end of the 4th year.
• Based upon a market study, Proxima concludes that it can generate revenues of $6 million every year for the next 4 years; operating expenses (other than depreciation) are expected to be 60% of revenues each year.
• Proxima has an unlevered beta of 0.90 but the unlevered beta for computer software companies is 1.50. The market value of equity for Proxima is $ 80 million and the market value of debt is $ 20 million. Proxima plans to maintain this debt to capital ratio for this project. The cost of debt for Proxima is 7%.
• The riskless rate is 5% and the market risk premium is 4%. The tax rate is 21%.
What is the net present value of this project? Should Proxima Inc. invest in producing new software?
we have to first compute Weighted average cost of capital | ||||||||
Compute of required rate of equity based on CAPM | ||||||||
Required rate = risk free rate + Market premium * beta | ||||||||
=(5%+4%*1.5) | ||||||||
11.00% | ||||||||
Post tax cost of debt = | =7%*(1-21%) | |||||||
5.530% | ||||||||
Computation of WACC = | =(20/100)*5.530%+(80/100)*11% | |||||||
Computation of WACC = | 9.906% | |||||||
Computatio of annual operating cash flow | ||||||||
i | Revenue | 6,000,000 | ||||||
ii | Cost @ 60% | 3,600,000 | ||||||
iii | Annual depreciation | =500000/4 | 1,250,000 | |||||
iv=i-ii-iii | Profit before tax | 1,150,000 | ||||||
v=iv*21% | Tax @ 21% | 241,500 | ||||||
vi=iv-v | Profit after tax | 908,500 | ||||||
vii=vi+iii | Annual cash flow | 2,158,500 | ||||||
Computation of present value | ||||||||
year | Initial investment | Annual cash flow | Total cash flow | PVIF @ 9.906% | present value | |||
0 | -5000000 | - | (5,000,000) | 1.0000 | (5,000,000) | |||
1 | 2,158,500 | 2,158,500 | 0.9099 | 1,963,951 | ||||
2 | 2,158,500 | 2,158,500 | 0.8279 | 1,786,937 | ||||
3 | 2,158,500 | 2,158,500 | 0.7532 | 1,625,878 | ||||
4 | 2,158,500 | 2,158,500 | 0.6854 | 1,479,335 | ||||
1,856,100 | ||||||||
Therefore present value= | 1,856,100 | |||||||
Since NPV is positive therefore project should be accepted |