calculate all the sub sections for both the projects.

|( 2. Capital Budgeting Kogan.c Ltd. [25 marks] .nswer the below questions in your w d le and refer to your excel spreadsheet as a supporting ocument. Upload your excel spread et under \"Excel Submissions". All amounts are in $AUD. In order to satisfy the sharp increase in demand KGN is evaluating investing in a \"Mega Warehouse" project in Australia. KGN has already identified two existing warehouses. In order to mitigate the risk and assess the t for purpose of these facilities KGN asked "Axiom Ltd." to conduct a technical due diligence. "Axiom Ltd." is asking $100,000 as a xed 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 $1million 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 $2million 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 year 1-10. Both investment will be depreciated on a straight-line basis over ten years to 0 book value. KGN has estimated that the \"Mega Warehouses" can be sold at the end of year 10 respectively for $125 million (Project A) and $100 million (Project B). The tax rate is 30%. All cash ows are annual and are received at the end of the year. The weighted average cost of capital for both projects is 5%. a) Calculate the FCFs to each project (10 marks) b) What is the NPV for each project? (5 marks) 0) What is the Discounted Payback Period for each project? (2.5 marks) d) What is the IRR for each project? (2.5 marks) 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? Why? (2 marks) f) Suppose that KGN' management payback rule is 7.5 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