In: Finance
Net Present Value and Discounted Payback Period
Using the amount of capital expenditures incurred in 2018 -1976.4 (which will consider to be an initial investment outflow), assume the company will generate operating cash inflows of $205 million the first year, $385 million the second year, $478 million the third year, $599 million the fourth year, $625 million the fifth year, and $100 million the year six.
a.) What is the NPV using the company’s WACC of 3.56 and what is the IRR?
b.) Did the company make a good investment decision using the NPV criteria?
c.) If the company had a discounted payback period policy of four years, did it make a sound investment decision (use the company’s calculated WACC)?
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -
Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.