This paper concentrates on the primary theme of Prepare a memorandum of not more than two pages (not including appendices of which there may be several) to Mr. Taylor summarizing your analysis and making a recommendation. in which you have to explain and evaluate its intricate aspects in detail. In addition to this, this paper has been reviewed and purchased by most of the students hence; it has been rated 4.8 points on the scale of 5 points. Besides, the price of this paper starts from £ 50. For more details and full access to the paper, please refer to the site.
Enter data into the Excel template. Ensure that the spreadsheet is fully complete; there should be no empty cells. As you will see, this decision is critically dependent on your projection for future fuel costs and the discount rate employed. Run a few “sensitivity” analyses with at least three estimates of future fuel prices and three discount rates to see how the fleet replacement decision changes. Remember that the net present value obtained is a 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. Include your sensitivity analysis with your memorandum. A 3-by-3 table with 9 combinations of fuel prices in columns and discount rates in rows is one way to the present the statistics. Include your rationale for the fuel price estimates and discount rates used in this sensitivity analysis.
Prepare a memorandum of not more than two pages (not including appendices of which there may be several) to Mr. Taylor summarizing your analysis and making a recommendation. Remember that Mr. Taylor and his staff will need to understand how the analysis was conducted. Explain your assumptions and methodology concisely