Question

In: Economics

An airline is considering purchasing a new Boeing aircraft that is quoted at $35 million per...

An airline is considering purchasing a new Boeing aircraft that is quoted at
$35 million per unit. Boeing requires a 10% down payment paid at the time of delivery,
and the balance is to be paid over a 10-year period at an interest rate of 9% compounded
annually (see the hints below for better explanation). The actual payment schedule calls
for making only interest payments over the 10-year period, with the original principal
amount to be paid off at the end of the 10th year. The expected annual revenue is $40
million, while the annual operating and maintenance cost is $30 million. The aircraft is
expected to have a 15-year service life with a salvage value of 15% of the original
purchase price, and will be depreciated by the seven-year MACRS property
classification. The firm’s combined federal and state marginal tax rate is 38%. The
MARR is 18%.


(a.) Determine the cash flow of the entire project associated with the debt
financing. Use excel spreadsheet and present your calculation using the cash
flow table

- Assume all values are in today’s money (do not inflate).
- 10% down payment is paid at year 0 (10% of the $35M)
- 9% of the unpaid principal ($35M - $3.5M down payment) is paid every year
to Boeing from year 1 to year 10.
- Unpaid principal ($35M - $3.5M down payment) is paid as lump sum at year
10.

Solutions

Expert Solution

MARR = 18% , Tax = 38%, Interest on loan = 9%

Salvage value = 15% of original value

MACRS rate used

Year 1 2 3 4 5 6 7 8
Rate 0.1429 0.2449 0.1749 0.1249 0.0893 0.0892 0.0893 0.0446

using excel

Year Initial cost Loan payment Annual revenue Annual O&M cost Depreciation Salvage value Taxable Income Tax ATCF Discount factor Present value
0 -3500000 -3500000 1.00000 -3500000.00
1 -2835000 40000000 -30000000 5001500 2163500 822130 6342870 0.84746 5375313.56
2 -2835000 40000000 -30000000 8571500 -1406500 -534470 7699470 0.71818 5529639.47
3 -2835000 40000000 -30000000 6121500 1043500 396530 6768470 0.60863 4119499.80
4 -2835000 40000000 -30000000 4371500 2793500 1061530 6103470 0.51579 3148101.93
5 -2835000 40000000 -30000000 3125500 4039500 1535010 5629990 0.43711 2460920.52
6 -2835000 40000000 -30000000 3122000 4043000 1536340 5628660 0.37043 2085033.19
7 -2835000 40000000 -30000000 3125500 4039500 1535010 5629990 0.31393 1767394.80
8 -2835000 40000000 -30000000 1561000 5604000 2129520 5035480 0.26604 1339629.85
9 -2835000 40000000 -30000000 7165000 2722700 4442300 0.22546 1001543.50
10 -34335000 40000000 -30000000 -24335000 -9247300 -15087700 0.19106 -2882723.36
11 40000000 -30000000 10000000 3800000 6200000 0.16192 1003898.05
12 40000000 -30000000 10000000 3800000 6200000 0.13722 850761.06
13 40000000 -30000000 10000000 3800000 6200000 0.11629 720983.95
14 40000000 -30000000 10000000 3800000 6200000 0.09855 611003.34
15 40000000 -30000000 5250000 15250000 5795000 9455000 0.08352 789644.15
NPV 24,420,643.81

NPV = 24,420,644 is positive so project must be selected

Showing formula in excel

Year Initial cost Loan payment Annual revenue Annual O&M cost Depreciation Salvage value Taxable Income Tax ATCF Discount factor Present value
0 =-35000000*0.1 =B3 =1/(1+0.18)^A3 =J3*K3
1 =-(35000000-3500000)*0.09 40000000 -30000000 =0.1429*35000000 =D4+E4-F4+C4+G4 =H4*0.38 =H4-I4+F4 =1/(1+0.18)^A4 =J4*K4
2 =-(35000000-3500000)*0.09 40000000 -30000000 =0.2449*35000000 =D5+E5-F5+C5+G5 =H5*0.38 =H5-I5+F5 =1/(1+0.18)^A5 =J5*K5
3 =-(35000000-3500000)*0.09 40000000 -30000000 =0.1749*35000000 =D6+E6-F6+C6+G6 =H6*0.38 =H6-I6+F6 =1/(1+0.18)^A6 =J6*K6
4 =-(35000000-3500000)*0.09 40000000 -30000000 =0.1249*35000000 =D7+E7-F7+C7+G7 =H7*0.38 =H7-I7+F7 =1/(1+0.18)^A7 =J7*K7
5 =-(35000000-3500000)*0.09 40000000 -30000000 =0.0893*35000000 =D8+E8-F8+C8+G8 =H8*0.38 =H8-I8+F8 =1/(1+0.18)^A8 =J8*K8
6 =-(35000000-3500000)*0.09 40000000 -30000000 =0.0892*35000000 =D9+E9-F9+C9+G9 =H9*0.38 =H9-I9+F9 =1/(1+0.18)^A9 =J9*K9
7 =-(35000000-3500000)*0.09 40000000 -30000000 =0.0893*35000000 =D10+E10-F10+C10+G10 =H10*0.38 =H10-I10+F10 =1/(1+0.18)^A10 =J10*K10
8 =-(35000000-3500000)*0.09 40000000 -30000000 =0.0446*35000000 =D11+E11-F11+C11+G11 =H11*0.38 =H11-I11+F11 =1/(1+0.18)^A11 =J11*K11
9 =-(35000000-3500000)*0.09 40000000 -30000000 =D12+E12-F12+C12+G12 =H12*0.38 =H12-I12+F12 =1/(1+0.18)^A12 =J12*K12
10 =-(35000000-3500000)*0.09+(-31500000) 40000000 -30000000 =D13+E13-F13+C13+G13 =H13*0.38 =H13-I13+F13 =1/(1+0.18)^A13 =J13*K13
11 40000000 -30000000 =D14+E14-F14+C14+G14 =H14*0.38 =H14-I14+F14 =1/(1+0.18)^A14 =J14*K14
12 40000000 -30000000 =D15+E15-F15+C15+G15 =H15*0.38 =H15-I15+F15 =1/(1+0.18)^A15 =J15*K15
13 40000000 -30000000 =D16+E16-F16+C16+G16 =H16*0.38 =H16-I16+F16 =1/(1+0.18)^A16 =J16*K16
14 40000000 -30000000 =D17+E17-F17+C17+G17 =H17*0.38 =H17-I17+F17 =1/(1+0.18)^A17 =J17*K17
15 40000000 -30000000 =0.15*35000000 =D18+E18-F18+C18+G18 =H18*0.38 =H18-I18+F18 =1/(1+0.18)^A18 =J18*K18
NPV =SUM(L3:L18)

Related Solutions

An airline is considering purchasing a new Boeing aircraft that is quoted at $35 million per...
An airline is considering purchasing a new Boeing aircraft that is quoted at $35 million per unit. Boeing requires a 10% down payment paid at the time of delivery, and the balance is to be paid over a 10-year period at an interest rate of 9% compounded annually (see the hints below for better explanation). The actual payment schedule calls for making only interest payments over the 10-year period, with the original principal amount to be paid off at the...
An airline is considering purchasing a new Boeing aircraft that is quoted at $35 million per...
An airline is considering purchasing a new Boeing aircraft that is quoted at $35 million per unit. Boeing requires a 10% down payment paid at the time of delivery, and the balance is to be paid over a 10-year period at an interest rate of 9% compounded annually (see the hints below for better explanation). The actual payment schedule calls for making only interest payments over the 10-year period, with the original principal amount to be paid off at the...
An airline owns an aging fleet of Boeing 737 jet airplanes. It is considering a major...
An airline owns an aging fleet of Boeing 737 jet airplanes. It is considering a major purchase of up to 17 new Boeing model 787 and 767 jets. The decision must take into account numerous cost and capability factors, including the following: (1) the airline can finance up to $1.6 billion in purchases; (2) each Boeing 787 will cost $80 million, and each Boeing 767 will cost $110 million; (3) at least one-third of the planes purchased should be the...
Dodson Inc. is considering purchasing some new processing equipment. The carbon steel alternative has been quoted...
Dodson Inc. is considering purchasing some new processing equipment. The carbon steel alternative has been quoted at $40,000 initially. It would have an eight-year life with residual salvage of $2,000. The operating costs would be $3,000 per year with a major overhaul at the end of the third and sixth years of $4,000. A more corrosion-resistant alternative to stainless steel is offered at $60,000 with a life of 12 years, an operating expense of $1,500 per year, and no major...
On Jan. 1, 2019 Spitfire Airlines buys a new Boeing 737 aircraft for $ 50,500,000. It...
On Jan. 1, 2019 Spitfire Airlines buys a new Boeing 737 aircraft for $ 50,500,000. It is expected to last 15 years and fly 50,000 hours. At the end of its useful life, Spitfire expects to sell the aircraft for $2,700,000. In 2019 the aircraft flies for 3,750 hours. a. What is the 2019 depreciation, assuming straight line depreciation is used?   $____________________________ b. What is the 2019 depreciation, assuming units of production depreciation is used? $_______________________ c. Suppose that straight...
As a financial manager, you are considering purchasing a new machine that will cost $1 million....
As a financial manager, you are considering purchasing a new machine that will cost $1 million. It can be depreciated on a straight-line basis for five years to a zero salvage value. You expect revenues from the machine to be $700,000 each year and expenses are expected to be 50% of revenue. If the company is taxed at a rate of 34% and the appropriate discount rate for a project of this level of risk is 15%, will the company...
Your firm is considering a project that would require purchasing $7.9 million worth of new equipment....
Your firm is considering a project that would require purchasing $7.9 million worth of new equipment. Determine the present value of the depreciation tax shield associated with this equipment if the? firm's tax rate is 33%?, the appropriate cost of capital is 8 %?, and the equipment can be? depreciated: Please round all answers to 4 decimals. a.? Straight-line over a? ten-year period, with the first deduction starting in one year. b.? Straight-line over a? five-year period, with the first...
Suppose Proctor? & Gamble? (P&G) is considering purchasing $14 million in new manufacturing equipment. If it...
Suppose Proctor? & Gamble? (P&G) is considering purchasing $14 million in new manufacturing equipment. If it purchases the? equipment, it will depreciate it for tax purposes on a? straight-line basis over five? years, after which the equipment will be worthless. It will also be responsible for maintenance expenses of $1.00 million per? year, paid in each of years 1 through 5. It can also lease the equipment under a true tax lease for $3.4 million per year for the five?...
Your firm is considering a project that would require purchasing $7.3 million worth of new equipment....
Your firm is considering a project that would require purchasing $7.3 million worth of new equipment. Determine the present value of the depreciation tax shield associated with this equipment if the firm's tax rate is 33%, the appropriate cost of capital is 7%, and the equipment can be depreciated: a. Straight-line over a ten-year period, with the first deduction starting in one year. b. Straight-line over a five-year period, with the first deduction starting in one year. c. Using MACRS...
Your firm is considering a project that would require purchasing $7.5 million worth of new equipment....
Your firm is considering a project that would require purchasing $7.5 million worth of new equipment. Determine the present value of the depreciation tax shield associated with this equipment if the​ firm's tax rate is 20% using the alternative depreciation methods below. Note that because the depreciation tax shield is essentially a riskless cash flow​ (assuming the​ firm's tax rate remains​ constant), the appropriate cost of capital to evaluate the benefit from accelerated depreciation is the​ risk-free rate; assume this...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT