Question

A company currently uses a machine that was purchased 2 years ago. This machine is being depreciated on a straight-line basis and has 6 years of life remaining. Its current book value is $2,100 and it can be sold for S2,500 at this time. Thus, the annual Hepreciation expense is S2,100/6-S350 per year. If the old machine is not replaced, it could be sold for S500 at the end ofits useful life The company is offered a replacement machine which has a cost of S8,000, an estimated useful life of 6 years, and an estimated salvage value of S800. This machine falls into the MACRS 5-year class, so the applicable depreciation rates are: 20%, 32%, 19%, 12%. 11%, and 6%. The replacement machine would permit an output expansion, so sales would rise by S1,000 per year; even so, the machines much greater efficiency would cause operating expenses to decline by S1,500 per year. The new machine would require that inventories be increased by S2,000, but accounts payable would also increase by $500. The companys marginal tax rate is 40%, and its WACC is 15%. Should the company replace the old machine?

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

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

Home nert Page Layout Formulas Data Review View dd-Ins s Cut ta copy ▼ E AutoSum ー E ゴWrap Text в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard FU62 FT Alignment Number Cells Edting FU FV FW FX FY FZ GB GC GD GE GF 350 2100 2500 400 160 56 57 58 59 60 61 62 63 64 65 depreciation per year on old machine book value = sale price- gain on sale 2500-2100 tax on gain- note 40% of 400 ess add add cost of new machine sale value of old machine tax on sale of old machine working capital (2000-1500) 8000 2500 160 1500 7160 67 68 69 70 71 72 73 intial cash flow at year 0 7160 커 | IRRnpv , RATION PBP ARR . external rate . MIRR NpV IRR : REPLACEMENT S / HPR GMAM , EAC MACRS RATIOCASHBUDGET wacc . BOND EPS EBIT- REPLACEMENT, STat ▶ 06:01 06-01-2019Home nert Page Layout Formulas Data Review View dd-Ins s Cut aCopy E AutoSum ー E ゴWrap Text в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Sort &Find & 2 ClearFe Select Edting Format Painter Formatting, as Table w styles. ▼ ㆆ ▼ Clipboard FW88 FT Alignment Number FV FX FZ GB GC GD depreciation new machine rates old machine change in depreciation depreciation 70 note year depreciation ($) 72 73 74 75 76 A-B 20.00% 32.00% 19.00% 12.00% 11.00% 6.00% 1600 2560 1520 960 880 480 350 350 350 350 350 350 1250 2210 1170 610 530 130 4 78 79 80 6 TOTAL INCREASE IN EARNINGS 1000 +1500 2500 ncremental net cash flows yearEARNINGS(1-t) change in depreciation*(t) 82 83 84 85 86 87 1 2500*(1-0.4)1250 (0.4) 2 2500 (1-0.4)2210*(0.4) 3 2500* (1-0.4) 1170 (0.4) 4 2500*(1-0.4) 610 (0.4) 5 2500*(1-0.4) +530 (0.4) 6 2500*(1-0.4) 130*(0.4) . MIRR NpV IRR : REPLACEMENT S / HPR GMAM , EAC MACRS 2000 2384 1968 1744 1712 1552 커 | IRRnpv , RATION PBP ARR . external rate RATIOCASHBUDGET wacc . BOND EPS EBIT- REPLACEMENT, STat ▶ 06-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E ゴWrap Text aCopy в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Format Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard FY103 FW Alignment Number Cells Edting FX FY FZ GA GB GC GD GF GH GI 91 92 93 94 95 96 97 98 calculation of NPV cash floww 0 year pv factor @ 15% pv of cfat -7160.00 000.00 2384.00 1968.00 1744.00 1712.00 3232.00 0.8696 0.7561 0.6575 0.5718 0.4972 0.4323 7160 1739.13 1802.65 1293.99 997.14 851.17 1397.28 4 6 100 101 102 C 103 104 105 106 107 108 109 1552-500 1-0.4) 800 (1-0.4)+ 1500 (500 IS SALVAGE VALUE OF OLD MACHINE, IF SOLD AT THE END OF 6 YEARS) (800 is salvage of new machine, after tax salvage is 800* (1-0.40) as book value is zero) NPV 921.36 (1500 recovery of working capital) NPV IS POSITIVE, REPLACEMENT SHOULD BE DONE 커 | IRRnpv , RATION PBP ARR . external rate . MIRR NpV IRR REPLACEMENT S / HPR GMAM , EAC MACRS RATIOCASHBUDGET wacc : BOND CEPS EBIT- REPLACEMENT, STats | | |- 06-01-2019

Add a comment
Know the answer?
Add Answer to:
A company currently uses a machine that was purchased 2 years ago. This machine is being...
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
  • Please show in Excel The Rapport Company currently uses a machine that was purchased 4 years...

    Please show in Excel The Rapport Company currently uses a machine that was purchased 4 years ago. This machine is being depreciated on a straight-line basis, and it has 5 years of remaining life. Its current book value is $5,000, and it can be sold for $6,500 at this time. Thus, the annual depreciation expense is $5000/5 = $1000 per year. If the old machine is not replaced, it can be sold for $500 at the end of its useful...

  • The Dauten Toy Corporation uses an injection molding machine that was purchased prior to the new...

    The Dauten Toy Corporation uses an injection molding machine that was purchased prior to the new tax legislation. This machine is being depreciated on a straight-line basis, and it has 6 years of remaining life. Its current book value is $2,100, and it can be sold for $2,600 at this time. Thus, the annual depreciation expense is $2,100/6 = $350 per year. If the old machine is not replaced, it can be sold for $500 at the end of its...

  • How do I find the cash flows??? The Taylor Toy Corporation currently uses an injection-molding machine...

    How do I find the cash flows??? The Taylor Toy Corporation currently uses an injection-molding machine that was purchased 2 years ago. This machine is being depreciated on a straight-line basis, and it has 6 years of remaining life. Its current book value is $2,100, and it can be sold for $2,500 at this time. Thus, the annual depreciation expense is $$2,100/6 = $350 per year. If the old machine is not replaced, it can be sold for $500 at...

  • 3. CK Company uses the machine for cleaning the furniture. The current machine has purchased since...

    3. CK Company uses the machine for cleaning the furniture. The current machine has purchased since the three years ago. The initial cost is $300,000. The machine has the useful life 5 years since the date of purchases. The residual value is $50,000. The Current machine can generate the cash revenue per year is $100,000 and cash operating costs is $60,000 per year. If the company continues to keep or use the current machine, it will have the repairing expense...

  • mong the decisions) 3. CK Company uses the machine for cleaning paling te old ars ago....

    mong the decisions) 3. CK Company uses the machine for cleaning paling te old ars ago. The initial cost is $300,000. uses the machine for cleaning the furniture. The current machine has purchased since the three years ago. The initial cost is The machine has the useful life 5 years since the date o has the useful life 5 years since the date of purchases. The residual value is $50,000. The Current machine can generate the cash revenue per ye...

  • Apple is considering a replacement machine that has a cost of $25,000.  The new machine will permit...

    Apple is considering a replacement machine that has a cost of $25,000.  The new machine will permit output expansion, so annual revenues are estimated at $5,000 during its operating period.  The new machine's greater efficiency is expected to reduce operating expenses by $3,000 per year.  This machine has an estimated useful life of 5 years and will be depreciated using a straight-line basis.  The machine will cause a change in working capital of $3,000 per year. California's marginal tax rate is 40% and its...

  • 20. Problem 12.20 (Replacement Analysis) eBook The Darlington Equipment Company purchased a machine 5 years ago...

    20. Problem 12.20 (Replacement Analysis) eBook The Darlington Equipment Company purchased a machine 5 years ago at a cost of $90,000. The machine had an expected life of 10 years at the time of purchase, and it is being depreciated by the straight-line method by $9,000 per year. If the machine is not replaced, it can be sold for $15,000 at the end of its useful life. A new machine can be purchased for $180,000, including installation costs. During its...

  • 6. Award: 8.00 points A machine purchased three years ago for $305,000 has a current book...

    6. Award: 8.00 points A machine purchased three years ago for $305,000 has a current book value using straight-line depreciation of $182,000; its operating expenses are $39,000 per year. A replacement machine would cost $229,000, have a useful life of nine years, and would require $12,000 per year in operating expenses. It has an expected salvage value of $65,000 after nine years. The current disposal value of the old machine is $77,000; if it is kept 9 more years, its...

  • A Corporation is considering replacing the metal cutting machine (cutter) it currently uses to cut metal...

    A Corporation is considering replacing the metal cutting machine (cutter) it currently uses to cut metal to make fences. The metal cutter has 6 years of remaining life. If kept, the metal cutter will have depreciation expenses of $800 for five years and $700 for the sixth year. Its current book value is $5,000 and it can be sold on eBay for $6,500 at this time. If the old metal cutter is not replaced it can be sold for $1,000...

  • The Darlington Equipment Company purchased a machine 5 years ago at a cost of $100,000. The...

    The Darlington Equipment Company purchased a machine 5 years ago at a cost of $100,000. The machine had an expected life of 10 years at the time of purchase, and it is being depreciated by the straight-line method by $10,000 per year. If the machine is not replaced, it can be sold for $10,000 at the end of its useful life. A new machine can be purchased for $160,000, including installation costs. During its 5-year life, it will reduce cash...

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