Attached are the files to help with the report.
Review the scenarios 1 through 9. Assemble a report responding to the tasks you have been given by the Controller. Structure your report so it is clear which task you are addressing. Summarize the results of each task in the body of your report and refer to the detailed supporting calculations contained in your excel work sheet.
This is a comprehensive report to management it should be summarized with an executive summary, contain details on each scenario analysis with supporting calculations. Expectations would be 10-12 pages including cover page, executive summary and references. You should also include an Excel sheet or workbook with all detailed calculations with each problem clearly titled and references to any templates or material from other sources.