The table given below shows how, on average, the market value of a Boeing 737 has...

70.2K

Verified Solution

Question

Finance

The table given below shows how, on average, the market value ofa Boeing 737 has varied with its age and the cash flow needed ineach year to provide a 11% return. (For example, if you bought a737 for $19.89 million at the start of year 1 and sold it a yearlater, your total profit would be 18.09 + 3.99 – 19.89 = $2.19million, 11% of the purchase cost.)

Assume airlines write off their aircraft straight-line over 15years to a salvage value equal to 25% of the original cost.

Start of YearMarket ValueCash Flow
119.89
218.093.99
316.993.09
415.882.98
515.092.54
614.192.56
713.562.19
812.782.27
912.251.94
1011.562.04
1111.111.72
1210.491.84
1310.111.53
149.541.68
159.211.38
168.691.53

a. Calculate economic depreciation, bookdepreciation, economic return, and book return for each year of theplane’s life. (Leave no cells blank - be certain to enter"0" wherever required. Do not round intermediate calculations.Enter your answers in millions except for percentage values. Roundyour percentage answers to 1 decimal place and other answers to 2decimal places.)

Start of Year
12345678
Economic depreciation
Book depreciation
Economic return (%)
Book return (%)
Start of Year
910111213141516
Economic depreciation
Book depreciation
Economic return (%)
Book return (%)

b-1. Suppose an airline invested in a fixednumber of Boeing 737s each year. Calculate the steady-state bookrate of return. (Do not round intermediate calculations.Enter your answer as a percent rounded to 2 decimalplaces.)

Steady-state book rate of return            %  

b-2. Would steady-state book return overstateor understate true return?

Understates
Overstates

Answer & Explanation Solved by verified expert
4.2 Ratings (537 Votes)
Part 1 The tables are completed as below Start of the Year 1 2 3 4 5 6 7 8 Economic Depreciation 180 110 111 079 090 063 078 Book Depreciation 100 100 100 100 100 100 100 Economic Return 110 110 110 110 110 110 110 Book Return 150 111 111 91 98 80 91 Start of the Year 9 10 11 12 13 14 15 16 Economic Depreciation 141 135 127 122 115 111 105 101 Book Depreciation 094 104 072 084 053 068 038 053 Economic    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

The table given below shows how, on average, the market value ofa Boeing 737 has varied with its age and the cash flow needed ineach year to provide a 11% return. (For example, if you bought a737 for $19.89 million at the start of year 1 and sold it a yearlater, your total profit would be 18.09 + 3.99 – 19.89 = $2.19million, 11% of the purchase cost.)Assume airlines write off their aircraft straight-line over 15years to a salvage value equal to 25% of the original cost.Start of YearMarket ValueCash Flow119.89218.093.99316.993.09415.882.98515.092.54614.192.56713.562.19812.782.27912.251.941011.562.041111.111.721210.491.841310.111.53149.541.68159.211.38168.691.53a. Calculate economic depreciation, bookdepreciation, economic return, and book return for each year of theplane’s life. (Leave no cells blank - be certain to enter"0" wherever required. Do not round intermediate calculations.Enter your answers in millions except for percentage values. Roundyour percentage answers to 1 decimal place and other answers to 2decimal places.)Start of Year12345678Economic depreciationBook depreciationEconomic return (%)Book return (%)Start of Year910111213141516Economic depreciationBook depreciationEconomic return (%)Book return (%)b-1. Suppose an airline invested in a fixednumber of Boeing 737s each year. Calculate the steady-state bookrate of return. (Do not round intermediate calculations.Enter your answer as a percent rounded to 2 decimalplaces.)Steady-state book rate of return            %  b-2. Would steady-state book return overstateor understate true return?UnderstatesOverstates

Other questions asked by students