Note: Read the attached files and instructions carefully and follow them appropriately. I need 100% original and accurate answer.

Instructions:

• 1.       Enter data into the Excel template. Run a few “sensitivity” analyses with varying fuel and discount rates to see how the fleet replacement decision changes. Remember that the net present value obtained is a total cost of operation. The spreadsheet computes the cost per available seat mile (CASM). The aircraft with the lowest net present value CASM is the best financial choice.
• 2.       Prepare a memorandum (not more than 2 pages) to Mr. Sheldon summarizing your analysis and making a recommendation. Remember that executive management will need to understand how the analysis was conducted. Explain your assumptions and methodology concisely. Insert (copy and paste) and reference Excel worksheets as appendices to support your fleet replacement recommendation. Use other tables and graphs as appropriate to support your recommendation.