1. Prepare a spreadsheet clearly showing the discounted cash ow for each year. The calculations must include the NPV, IRR and the Payback Period of the project. Scenario 8: Sensitivity analysis should be utilized, to fully justify your recommendations & decision. You should also demonstrate the WACC for the company, as well as each cost of capital/security, and the capital structure of the company. Spreadsheet presentation and functionality will also be graded (refer to the marking guide rubric). (8 marks) 2. Typed business report (approx. 2000 words) making a recommendation whether to accept or reject the project, in regards of the nancial analysis you have conducted above. Include ALL scenarios is the report. The executive summary must contain concise reasons for your recommendation and a summary of your nancial analysis. Your report must also contain a strong conclusion to justify your analysis of the project. All supporting sections of the report such as the contents page, reference list and appendices are in addition to the report. Students are advised to attach all relevant spreadsheets, charts and any other research or statistics etc. as appendices. (7 marks)