Case: Airplane Leasing Analysis and before tax leasing payment determine the after tax 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 class. You may choose an airplane of your choice (747, 767, 777, 787) Assume 20 year depreciation period in your lease analysis. Make your assumptions about tax rate, required rate of return, insurance cost, maintenance and operating costs, and salvage value. You final report will be in a word document, not the excel file. You may copy and paste the excel file or take a photo shot and include it in the word file. 1. Description of your airplane Explanation of your assumption of the parameters such as tax rate, required rate of return, ... 3. 2. Explanation of your calculation of after tax leasing payment 4. your final calculation of before tax break even leasing payment. Case: Airplane Leasing Analysis and before tax leasing payment determine the after tax 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 class. You may choose an airplane of your choice (747, 767, 777, 787) Assume 20 year depreciation period in your lease analysis. Make your assumptions about tax rate, required rate of return, insurance cost, maintenance and operating costs, and salvage value. You final report will be in a word document, not the excel file. You may copy and paste the excel file or take a photo shot and include it in the word file. 1. Description of your airplane Explanation of your assumption of the parameters such as tax rate, required rate of return, ... 3. 2. Explanation of your calculation of after tax leasing payment 4. your final calculation of before tax break even leasing payment