Reference no: EM133106457

Question - Answer the below questions in your word file and refer to your excel spreadsheet as a supporting document. Upload your excel spreadsheet under "Excel Submissions". All amounts are in $AUD. In order to increase its market penetration and boost profitability, Woolworths Group (WOW) is evaluating investing in a new "Automated Grocery Store" (AGS). WOW has already identified a facility that could be ideal for this new format of convenience store. In order to mitigate the risk and assess the fit for purpose of the facility WOW asked "Axium Consulting Ltd." to conduct a technical due diligence. "Axium Consulting Ltd." is asking $350,000 as a fixed fee for its consulting services. The AGS will have a size of 3,000 square meters (sqm) and will require an initial investment of $80 million. As part of the initial investment, WOW will also have to invest additional $40 million in state of the art AI Robotics Technologies. It is believed that the AGS will be able to generate 10% more revenues compared to a traditional convenience store. The average annual sales per sqm of a traditional convenience store is $15,000. The AGS will generate revenue starting at the end of year 1 until the end of year 10. It will also incur additional working capital expenses of $5million immediately, this working capital will be recovered at the end of the project. It is believed that the AGS will reduce the revenues of a close grocery store that the company also own. The total impact on the annual revenues of this store is expected to be a reduction of $5 million. The management team is forecasting that operating costs will be only 15% of the incremental revenues from year 1-10. The initial investment will be depreciated on a straight-line basis over ten years to 0 book value. WOW has estimated that the AGS can be sold at the end of year 10 for $10 million. 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 is 10%.

Required -

a) Calculate the FCFs for this project.

b) What is the NPV for the project?

c) What is the Discounted Payback Period?

d) What is the IRR?

e) Assume that the risk of investing in the AGS is higher than the overall risk of the company, what would happen to the discount rate and consequently NPV of the project? Why?

f) Suppose that WOW' management discounted payback rule is 5 years. Based on your analysis in b), c) and d) should the company undertake this project? Justify your answer with reference to theory. What other factor might affect the final decision?