Preparing excel spreadsheets to perform various tasks in a way that is efficient, i.e. allows for spreadsheet to be reused in the future with minimal additional work Requirement: You are required to submit ONE excel spreadsheet answering the requirements of the three parts detailed below. You can (and I recommend you do) use as many tabs as you want but only one spreadsheet will be marked. Marks will be equally split between the “quality” of the formulations developed, i.e. could they be reused with minimum additional work and the answers arrived at. Part 1 – Ratio Analysis Part 2 – Time Value of Money Calculations Required: i. Calculate the amount accumulated by in three years’ time and the maximum amount of the mortgage to be taken out. ii. Calculate the monthly mortgage payment, assuming this maximum amount is borrowed (rounded to £’000s) and assuming the conditions above. Part 3 – Investment Appraisal Required: Using the four methods discussed in class, assess this investment opportunity and make a recommendation of whether the company should go ahead with it or not.