Question

Suppose Amazon is considering the purchase of computer servers and network infrastructure to expand its very...

Suppose Amazon is considering the purchase of computer servers and network infrastructure to expand its very successful businesses offering cloud-based computing. In total it will purchase 48.7 million in new equipment. The equipment will qualify for accelerated depreciation 20% can be expensed immediately followed by 32%, 19.2%, 11.52%, 11.52% and 5.76% over the next five years. However because of the firm's substantial. Amazon considers leasing the equipment instead suppose Amazon and the lessor face the same 7.8% borrowing rate, but the lessor has a 35% tax rate. For the purpose of this question, assume the equipment is worthless, after five years the lease term is five years and the lease qualifies as a true tax lease.

A. What is the lease rate for which the lessor will break even?

B. What is the gain to Amazon with the lease rate?

C. What is the source of the gain in this transaction?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

MARGINAL TAX RATE MISSING, BUT I DID SAME TYPE OF SUM EARLIER WITH 10% TAX. IF IT IS DIFFERENT, LET ME KNOW. WILL CHANGE ACCORDINGLY.

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Delete Format @ntosum.剑7 A ー E ゴWrap Text copy ▼ ,_a. ars- ..困Merge & Center, 函Merge & Center, 弼,8 Conditional Format-eCell conditional aFon nat, sCell- B 1 u. $, % , il Insert Delete Format Insert Sort &Find & 2 ClearFe Select = $ , % , ▼ ㆆ ▼ Clipboard Number C156 138 139 140 141 il12 143 144 145 146 147 BUY PURCHASE OF EQUIPMENT DEPRECIATION TAX SHIELD FREE CASH FLOW PV FACTOR @ 5.07% PV OF FCF 0 4 -48700000 409000 5454400 3272640 19635841963584 981792 45291000 5454400 3272640 1963584 1963584981792 0.7809 0.9517 0.9058 0.8205 45291000.00 5191205.86 2964427.07 1692829.77 1611144.73 766700.64-33064691.93 LEASE LEASE PAYMENT X (1-TAX RATE) X PVI FAD @5.07%, 5 YEARS : PV OFFCF LEASE PAYMENTX (1-0.35) x 4.5402 33064691.93 LEASE PAYMENT BREAKEVEN LEASE 11204078.41 11204078.41 149 a 150 151 NOTE DEPRECIATION COST 48700000 TAX SAVING AT 35% 5.76% 9740000 15584000 9350400561024056102402805120 981792 11.52% 409000 5454400 3272640 19635841963584 $4.5402 20% 32% 19.20% 11.52% 153 155 NOTE 1 156 4 H KE CA RATE = 7.8%(1-0.35)-5.07% NOTE 2 EXCEL ; PVIFAD @5.07%, 5 YEARS PV(5.07%,5-1,, 1) . PM UTILITY, SHARPE, beta bond cove ty DGM port future INDEX INTL CAP BUD LEASING PV, FV, ANNUITY DIR ght dean YELD bond porti i cap str WACC RESI ex 130% 31-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text ta copy. в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Sort &Find & 2 ClearFe Select Editing Format Painter Formatting, as Table w styles. ▼ ㆆ ▼ Clipboard Alignment Number Cells F176 Formula Bar 158 BUY 159 PURCHASE OF EQUIPMENT 160 161 DEPRECIATION TAX SHIELD (10%) 162 FREE CASH FLOW 163 PV FACTOR @ 7.02% 164 PV OF FCF 165 166 NET COST OF PURCHASE- 167 NET COST OF LEASING 168 NET GAIN 169 170 THE SOURCE OF GAIN IS DIFFERENCE IN TAX RATES 0 48700000 4 974000 1558400 47726000 1558400 0.9344 935040 935040 0.8731 561024 561024 0.8158 561024 561024 0.7623 280512 280512 0.7123 47726000.00 1456176.42 816394.93457705.99 427682.67 199814.37-44368225.63 -44368225.63 .44223954.03 (-11204078.41 X (1-0.10) X PVIFAD @7.02%, 5 YEARS) 144271.60 172 173 RATE= 7.8%*(1-0.10)-7.02% 174 175 176 4 H KE CAPM UTILITY, SH EXCEL : PVIFAD @7.02%, 5 YEARS = $4.3857 PV(5.07%,5,-1,1) beta bond c future INDEX INTL CAP BUD LEASING PV, FV, ANNUITYDIR cleanYIELD bond stru WACC RES1 ex di 福 130% 31-01-2019

Add a comment
Know the answer?
Add Answer to:
Suppose Amazon is considering the purchase of computer servers and network infrastructure to expand its very...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Suppse Netflix is considering the purchase of a computer servers and network infrastructure to facilitate its...

    Suppse Netflix is considering the purchase of a computer servers and network infrastructure to facilitate its move into video on demand services. In total, it will purchase $48.1 million in new equipment. This equipment will qualify for accelerated depreciation: 20% can be expensed immediately, followed by 32%, 19.2%, 11.52%, 11.52%, and 5.76% over the next 5 years. However, because of the firms substantial loss carryforwards, Netflix estimates ita marginal tax rate to be 10% over the next 5 years, so...

  • Rearden Metal is considering the purchase of a new blast furnace costing a total of $5...

    Rearden Metal is considering the purchase of a new blast furnace costing a total of $5 million dollars. This furnace will qualify for accelerated depreciation: 20% can be expense immediately, followed by 32%, 19.2%, 11.52%, 11.52% and 5.76% over the next five years. However, because of Rearden's substantial tax loss carry forwards, Rearden estimates its marginal tax rate to be only 10% over the next five years. Since Rearden will get very little tax benefit from the depreciation expense, they...

  • Suppose Clorox can lease a new computer data processing system for 971,000 per year for five...

    Suppose Clorox can lease a new computer data processing system for 971,000 per year for five years. Alternately it can purchase the system for 4.22 million. Assume Clorox has a borrowing cost of 6.7% and a tax rate of 35% and the system will be obsolete at the end of two years. A. If Clorox will depreciate the computer equipment on a straight line basis over the next five years, and if the lease qualifies a true tax lease qualifies...

  • Suppose Proctor? & Gamble? (P&G) is considering purchasing $15 million in new manufacturing equipment. If it...

    Suppose Proctor? & Gamble? (P&G) is considering purchasing $15 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 ?$4.1 million per year for the five? years,...

  • Suppose Procter and Gamble​ (P&G) is considering purchasing $20 million in new manufacturing equipment. If it...

    Suppose Procter and Gamble​ (P&G) is considering purchasing $20 million in new manufacturing equipment. If it purchases the​ equipment, it will depreciate it on a​ straight-line basis over the five​ years, after which the equipment will be worthless. It will also be responsible for maintenance expenses of $1.25 million per year.​ Alternatively, it can lease the equipment for  $4.6 million per year for the five​ years, in which case the lessor will provide necessary maintenance. Assume​ P&G?s tax rate is...

  • Suppose Procter and Gamble​ (P&G) is considering purchasing $ 13 million in new manufacturing equipment. If...

    Suppose Procter and Gamble​ (P&G) is considering purchasing $ 13 million in new manufacturing equipment. If it purchases the​ equipment, it will depreciate it on a​ straight-line basis over the five​ years, after which the equipment will be worthless. It will also be responsible for maintenance expenses of $ 0.50 million per year.​ Alternatively, it can lease the equipment for  $ 3.0 million per year for the five​ years, in which case the lessor will provide necessary maintenance. Assume​ P&G?s...

  • School [2] Financial Lease (20 points) Your firm is considering leasing dedicated servers for cloud computing...

    School [2] Financial Lease (20 points) Your firm is considering leasing dedicated servers for cloud computing payments of $50,000 each with the first payment occurring immediately. The equi $240,000 to buy and would be straight-line depreciated to zero salvage value can borrow at 9% and the tax rate is 35%. Calculate the PV of leasing and the P alternatively, the "lease PV". Questions: ual pment would cost The firm V of buying or, The lease calls for six ann in...

  • Principal Components is considering whether to lease or purchase some specialized equipment. The capital budgeting analysis...

    Principal Components is considering whether to lease or purchase some specialized equipment. The capital budgeting analysis indicating the equipment should be secured already has not been completed. The equipment has a five-year economic and tax life, and the company uses a straight-line depreciation method. The equipment costs $1,000,000 if purchased or it can be leased for five-years at $280,000 per year. The first lease payment is payable in advance. The equipment’s salvage value is estimated to be $100,000. Revenue is...

  • A construction company is considering whether to lease or buy equipment for its new 4-year projec...

    please answer them all and mark the answers . thanks A construction company is considering whether to lease or buy equipment for its new 4-year project. If they buy the equipment, it will have an initial investment cost of $630,000 with annual costs of $42.000. At the end of the 4 years the equipment can be sold for an estimated $378,000. For tax purposes, the company will use MACRS-ADS depreciation on the equipment. If they decide to lease, it will...

  • Questions #2 to #4 use the following setup. Markov Manufacturing recently spent $15 million to purchase...

    Questions #2 to #4 use the following setup. Markov Manufacturing recently spent $15 million to purchase some equipment used in the manufacture of disk drives. The firm expects that this equipment will have a useful life of five years, and it will be worthless afterwards. Assume the marginal corporate tax rate is 35%. If the company plans to use straight-line depreciation, what is the annual depreciation tax shield? Question 3 1 pts Rather than straight-line deprcciation, suppose Markov will use...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT