1.Using the Microsoft Excel file provided, prepare HTL's master budgets. Do not hard-code numbers into the spreadsheet. All the calculations should be done by linking data from the input box. [Marks 40]

2.Conduct a sensitivity analysis, decreasing sales by 2%, 5%, and 10% for September through January. New sales levels are provided in (Excel sheet 2). Adjust the financing and cash needs at these new sales levels. [Marks 10]

I only need the first two questions to be completed and I would appreciate if you can send it back as an Excel file or a link.

Case Study PDF: https://drive.google.com/file/d/1Fd0uzENlGoZQf-E1nRttIUETEso3mPVN/view?usp=drive_link

Excel Sheet: https://docs.google.com/spreadsheets/d/1mU2vtZJrZ20BTvx0rbASD_veOJBT4eTQicWnibb4hqA/edit?usp=sharing