Reference no: EM133491091
Consider the following information.
In order to satisfy a sharp increase in demand, COL is evaluating investing in one of two "mega warehouse" projects in Australia (called Project A and Project B). COL has already identified two existing warehouses that might meet their needs. In order to mitigate risk and assess these facilities, COL asked Rachel Consulting Ltd to conduct technical due diligence. Rachel Consulting is asking $400,000 as a fixed fee for its consulting services.
Project A has an initial outlay of dollars $150 million and Project B has an initial outlay of $85 million. Project A will generate additional revenues of $45 million starting at the end of year 1 until the end of year 10. It will also incur additional working capital expenses of $1 million immediately, this working capital will be recovered at the end of the project.
Project B will generate additional revenues of $25 million starting at the end of year 1 until the end of year 10. It will also incur additional working capital expenses of $2 million immediately, this working capital will be recovered at the end of the project.
The operating costs of both projects will be 30% of the revenues from years 1 to 10. Both investment projects will be depreciated on a straight line basis over ten years to zero book value. COL has estimated that the mega warehouse can be sold at the end of year 10 respectively for $25 million (Project A) and $10 million (Project B). The tax rate is 30%. All cash flows are annual and are received at the end of the year. The weighted average cost of capital for both projects is 6%.
a) Calculate the FCFs for each project.
b) What is the NPV for each project?
c) What is the discounted payback period for each project?
d) What is the IRR for each project?
e) Assume that the risk of investing in these mega warehouses is higher than the overall risk of the company. What would happen to the discount rate and consequently NPV of the two projects if this was the case? Why?
f) Suppose that COL has a payback rule of 8 years. Based on your analysis in b), c) and d) which project should be chosen? Justify your answer with reference to theory. What other factor might affect the final decision?