Please show all work and formulas used for plane 787 and excel file. thumbs up if everything in shown

Case: Airplane Leasing Analysis--determine the after tax and before tax leasing payment You work as a financial analyst for RBC Your company is considering buying an airplane and then lease it to Delta Air Lines. Your task is to determine the before tax leasing payment You may follow the leasing example we discussed in the teaching notes You may choose an airplane of your choice (767, 777, 787) Assume 20 year depreciation period in your lease analysis using the depreciation table in the notes or straight line depreciation method Make your assumptions about tax rate, required rate of return, insurance cost, maintenance and operating costs, and salvage value (Please use Google Search to help you with the airplane price, expenses, maintenance cost, insurance cost and depreciation value