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 leasing it to Delta Air Lines. Your task is to determine the before-tax leasing payment.
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 the 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.)
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. If you have difficulty transporting your Excel calculation, than you may follow my example document to present your calculations.
1. Description of your airplane
2. Explanation of your assumption of the parameters such as tax rate, required rate of return, …
3. Explanation of your calculation of after tax leasing payment
4. your final calculation of before tax break even leasing payment.
Note: Follow the notes on Break Even Rent Example for reference
For this short paper activity, you will learn about the three delays model, which explains…
Topic : Hospital adult medical surgical collaboration area a. Current Menu Analysis (5 points/5%) Analyze…
As a sales manager, you will use statistical methods to support actionable business decisions for Pastas R Us,…
Read the business intelligence articles: Getting to Know the World of Business Intelligence Business intelligence…
The behaviors of a population can put it at risk for specific health conditions. Studies…