Use excel and show steps clearly please 11- A profitable company making earthmoving equipment is considering an investment of $150,000 on equipment that will have a 5-year useful life23 and a $50,000 salvage value. Use a spreadsheet to compute the 60% bonus depreciation with MACRS depreciation schedule. Show the totaldepreciation taken (-sum()) as well as the PW of the depreciation charges discounted at 10%.X C: COMPOUND INTEREST TABLESIX D: FUNDAMENTALS OF ENGINEERINGM DRACTICE PROBLEMS- Page@W#3E626657$4R11- The XYZ Block Company purchased a new office computer and other depreciable computer hardwa27 computer is declared obsolete and is donated to the local community college. Using an interest rate of tE deductions. Assume that no salvage value was initially declared and that the machine was expected to las%5F5TF66YF7&76PrtScnU8·Home

Present worth refers to the current value of an asset present at some future date. It defines the…

Answered: 11- A profitable company making…

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)

22nd Edition

ISBN:9781305666160

Author:James A. Heintz, Robert W. Parry

Publisher:James A. Heintz, Robert W. Parry

Chapter18: Accounting For Long-term Assets

Section: Chapter Questions

Problem 3CE

See similar textbooks

Similar questions

REPLACEMENT ANALYSIS The Dauten 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 not replaced, it can be sold for 500 at the end of its useful life. Dauten is offered a replacement machine which has a cost of 8,000, an estimated useful life of 6 years, and an estimated salvage value of 800. 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 1,000 per year; even so, the new machine's much greater efficiency would cause operating expenses to decline by 1,500 per year. The new machine would require that inventories be increased by 2,000, but accounts payable would simultaneously increase by 500. Dauten's marginal federal-plus-state tax rate is 40%, and its WACC is 11%. Should it replace the old machine?
REPLACEMENT ANALYSIS St. Johns River Shipyards is considering the replacement of an 8-year-old riveting machine with a new one that will increase earnings before depreciation from 24,000 to 46,000 per year. The new machine will cost 80,000; and it will have an estimated life of 8 years and no salvage value. The new machine will be depreciated over its 5-year MACRS recovery period, so the applicable depreciation rates are 20%, 32%, 19%, 12%, 11%, and 6%. The applicable corporate tax rate is 40%, and the firm's WACC is 10%. The old machine has been fully depreciated and has no salvage value. Should the old riveting machine be replaced by the new one? Explain your answer.
REPLACEMENT ANALYSIS The Dauten 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 the end of its useful life. Dauten is offered a replacement machine which has a cost of 8,000, an estimated useful life of 6 years, and an estimated salvage value of 800. 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 1,000 per year; even so, the new machines much greater efficiency would cause operating expenses to decline by 1,500 per year. The new machine would require that inventories be increased by 2,000, but accounts payable would simultaneously increase by 500. Dautens marginal federal-plus-state tax rate is 40%, and its WACC is 15%. Should it replace the old machine?

Recommended textbooks for you

College Accounting, Chapters 1-27 (New in Account…

Accounting

ISBN:

9781305666160

Author:

James A. Heintz, Robert W. Parry

Publisher:

Cengage Learning

Fundamentals of Financial Management, Concise Edi…

Finance

ISBN:

9781305635937

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

College Accounting, Chapters 1-27 (New in Account…

Accounting

ISBN:

9781305666160

Author:

James A. Heintz, Robert W. Parry

Publisher:

Cengage Learning

Fundamentals of Financial Management, Concise Edi…

Finance

ISBN:

9781305635937

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

EBK CFIN

Finance

ISBN:

9781337671743

Author:

BESLEY

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781285867977

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Fundamentals of Financial Management, Concise Edi…

Finance

ISBN:

9781285065137

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS