All parts are under one question and therefore can be answered in full per your policy. 4. Analysis of a replacement project At times firms will need to decide if they want to continue to use their current equipment or replace the equipment with newer equipment. The company will need to do replacement analysis to determine which option is the best financial decision for the company. Price Co. is considering replacing an existing piece of equipment. The project involves the following: • The new equipment will have a cost of $600,000, and it is eligible for 100% bonus depreciation so it will be fully depreciated at t = 0. • The old machine was purchased before the new tax law, so it is being depreciated on a straight-line basis. It has a book value of $200,000 (at year 0) and four more years of depreciation left ($50,000 per year). • The new equipment will have a salvage value of $0 at the end of the project's life (year 6). The old machine has a current salvage value (at year 0) of $300,000. • Replacing the old machine will require an investment in net operating working capital (NOWC) of $50,000 that will be recovered at the end of the project's life (year 6). • The new machine is more efficient, so the firm’s incremental earnings before interest and taxes (EBIT) will increase by a total of $500,000 in each of the next six years (years 1–6). Hint: This value represents the difference between the revenues and operating costs (including depreciation expense) generated using the new equipment and that earned using the old equipment. • The project's cost of capital is 13%. • The company's annual tax rate is 25%. A. Complete the following table and compute the incremental cash flows associated with the replacement of the old equipment with the new equipment. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Initial investment EBIT – Taxes – Δ Depreciation × T + Salvage value – Tax on salvage – NOWC + Recapture of NOWC Total free cash flow B. The net present value (NPV) of this replacement project is: $1,260,916 $1,513,099 $1,071,779 $1,450,053
All parts are under one question and therefore can be answered in full per your policy. 4. Analysis of a replacement project At times firms will need to decide if they want to continue to use their current equipment or replace the equipment with newer equipment. The company will need to do replacement analysis to determine which option is the best financial decision for the company. Price Co. is considering replacing an existing piece of equipment. The project involves the following: • The new equipment will have a cost of $600,000, and it is eligible for 100% bonus depreciation so it will be fully depreciated at t = 0. • The old machine was purchased before the new tax law, so it is being depreciated on a straight-line basis. It has a book value of $200,000 (at year 0) and four more years of depreciation left ($50,000 per year). • The new equipment will have a salvage value of $0 at the end of the project's life (year 6). The old machine has a current salvage value (at year 0) of $300,000. • Replacing the old machine will require an investment in net operating working capital (NOWC) of $50,000 that will be recovered at the end of the project's life (year 6). • The new machine is more efficient, so the firm’s incremental earnings before interest and taxes (EBIT) will increase by a total of $500,000 in each of the next six years (years 1–6). Hint: This value represents the difference between the revenues and operating costs (including depreciation expense) generated using the new equipment and that earned using the old equipment. • The project's cost of capital is 13%. • The company's annual tax rate is 25%. A. Complete the following table and compute the incremental cash flows associated with the replacement of the old equipment with the new equipment. Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Initial investment EBIT – Taxes – Δ Depreciation × T + Salvage value – Tax on salvage – NOWC + Recapture of NOWC Total free cash flow B. The net present value (NPV) of this replacement project is: $1,260,916 $1,513,099 $1,071,779 $1,450,053
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter26: Capital Budgeting (capbud)
Section: Chapter Questions
Problem 5R
Related questions
Question
All parts are under one question and therefore can be answered in full per your policy.
4. Analysis of a replacement project
At times firms will need to decide if they want to continue to use their current equipment or replace the equipment with newer equipment. The company will need to do replacement analysis to determine which option is the best financial decision for the company.
Price Co. is considering replacing an existing piece of equipment. The project involves the following:
• | The new equipment will have a cost of $600,000, and it is eligible for 100% bonus |
• | The old machine was purchased before the new tax law, so it is being depreciated on a straight-line basis. It has a book value of $200,000 (at year 0) and four more years of depreciation left ($50,000 per year). |
• | The new equipment will have a salvage value of $0 at the end of the project's life (year 6). The old machine has a current salvage value (at year 0) of $300,000. |
• | Replacing the old machine will require an investment in net operating working capital (NOWC) of $50,000 that will be recovered at the end of the project's life (year 6). |
• | The new machine is more efficient, so the firm’s incremental earnings before interest and taxes (EBIT) will increase by a total of $500,000 in each of the next six years (years 1–6). Hint: This value represents the difference between the revenues and operating costs (including depreciation expense) generated using the new equipment and that earned using the old equipment. |
• | The project's cost of capital is 13%. |
• | The company's annual tax rate is 25%. |
A. Complete the following table and compute the incremental cash flows associated with the replacement of the old equipment with the new equipment.
|
Year 0
|
Year 1
|
Year 2
|
Year 3
|
Year 4
|
Year 5
|
Year 6
|
---|---|---|---|---|---|---|---|
Initial investment | |||||||
EBIT | |||||||
– Taxes | |||||||
– Δ Depreciation × T | |||||||
+ Salvage value | |||||||
– Tax on salvage | |||||||
– NOWC | |||||||
+ Recapture of NOWC | |||||||
Total |
B. The net present value (NPV) of this replacement project is:
$1,260,916
$1,513,099
$1,071,779
$1,450,053
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College