Write a 3-4 pg. Case project Report for the under listed case? Case: Airplane Leasing Analysisdetermine the after-tax and before-tax leasing paymentcaseoutlineairplaneleasingbreakeve

Write a Case project Report for the under listed case

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

,

To help you understand how to perform Airplane Leasing Break Even payment analysis, I am providing the following example for your reference. For your case, you will have to choose other models.

1) Buying cost of Boeing 747-8 airplane

2) Maintenance cost

Assume the plane will be used 500 hours per year and 50 trips per year (you may work harder by assuming a higher number) Google Search “Boeing 747 maintenance cost”, I got the following

Google “Boeing 747-8 insurance cost”

3) Depreciation (assume 20 year schedule)

4) Salvage value

Assume 10% of the initial value after 25 years of services

Apply Method 2 discussed in the chapter note: After Cash Flow Method to calculate the cost: Calculate the PV of each of the following four items: Buying, Expenses and Costs, Depreciation Tax Shield, and salvage 1)      Buying of the equipment: -357 million 2） Maint.,Ins, and Selling cost will add to the cost: Using the number found from Google search: Operating Cost=Operating cost per hour*Hours per year=$24,000*500=12000000 Insurance cost=Insurance per trip*number of trip per year=$2175*50=108750

Total Cost=12108750

Please note this cost is incurred in the beginning of each period T= 0 1 2 … 24 25

Costs (million) 12.10875 12.10875 12.10875 … 12.10875 0

After Tax Cost 9.48 9.48 9.48 … 9.48 0 Note: after tax cost is calculated as 12,108,75000*(1-T)= 12,108,75000*(1-.21)=9.48 (million)

Now calculate PV: PV(r=7%,PMT=9.48,n=25,BEGing)=-119.28 Million

3)      The depreciation tax saving will reduce the cost: Depreciation base: $357 million

Assume 7% cost of capital

PV=2.811/1.07+5.413/1.07^2+5.008/1.07^3+4.633/1.07^4+4.281+…

PV=2.62745 +4.72778 +4.08802 +3.5346 +3.05214

+2.64266+2.28302+1.97222+1.81873+1.69975+1.58855+1.48463+1.38750+1.29673+1.21190+1.13261+1.05852+0.98927+0.92455+0.86407+0.40377=40.788 million

Note: For simplicity, you may use straight line depreciation method as follows:

Suppose the airplane costs $357 million

Depreciation base: 357, for 20 years, Dep per year=357/20=17.850

Tax Shield per year=Dep*T=17.85*21%=3.749

Now calculate PV of Dep Tax Shield=PV(r=7%,n=20,PMT=3.749)=$39.71 million

4) Salvage Value will reduce the total cost

10% of the purchase price=$35.7 million

After tax Cash Flow=$35.7*(1-T)=35.7*(1-.21)=28.203 million

PV=28.203/1.07^25= 5.1964

Now put all these costs together:

Total PV of Cost=-357-119.28+40.788+5.1964=430.2956 million

How much do you have to charge the rent per year to cover the total cost of 430.2956?

Find Break even Rent

Using a financial calculator, PMT(PV=-430.2956, r=7%,n=25, beginning Yr)=34.5083 million

How much do I have to receive per year before tax so that I will have the above rent after tax?

X—before tax leasing charge

Tax at 21% — .21X

After tax X-.21X=X(1-.21)

After Tax leasing payment =34.5083

X= After Tax leasing payment/(1-T)=34.5083/(1-.21)

X=34.5083/.79=43.6814 million

The answer: You have to charge $43.6814 million before tax

Verify the numbers: Before tax rent: 43.6814

Tax (at 21%) -9.1731

After Tax Rent: 34.5083

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.