Please assist me in solving this question using Excel. Problem 9-23 Cost-Cutting Proposals [LO 2]Tanaka Machine Shop is considering a four-year project to improve itsproduction efficiency. Buying a new machine press for $401,000 is estimatedto result in $147,000 in annual pretax cost savings. The press falls in theMACRS five-year class (MACRS schedule) and it will have a salvage value atthe end of the project of $48,000. The press also requires an initial investmentin spare parts inventory of $15,300, along with an additional $2,300 ininventory for each succeeding year of the project. The shop's tax rate is 23percent and its discount rate is 10 percent. Calculate the project's NPV.Note: Do not round intermediate calculations and round your answer to 2decimal places, e.g., 32.16.Net present value

Net present value refers to the balance of present value of cash flows compared with its initial…

Answered: Net present value

Business

Finance

Net present value

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Exercise 5 Dog Up! Franks is looking at a new sausage system with an installed cost of $445,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped for $53,000. The sausage system will save the firm $139,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $25,000. If the tax rate is 23 percent and the discount rate is 11 percent, what is the NPV of this project? Answer
P10-21 Cost-Cutting Proposals [LO2] Masters Machine Shop is considering four-year project improve its production efficiency. Buying a new machine press for $844,800 is estimated to result in $281,600 in annual pretax cost savings. The press falls in the MACRS five-year class (MACRS Table), and it will have a salvage value at the end of the project of $123,200. The press also requires an initial investment in spare parts inventory of $35,200, along with an additional $5,280 in inventory for each succeeding year of the project. If the shop's tax rate is 23 percent and its discount rate is 10 percent, what is the NPV for this project? Multiple Choice O O O O O $46,816.22 $49,127.86 $-51,728.78 $49,157.03 $44,475.41
Problem 9 A contractor is considering the following three alternatives: a. Purchase a new microcomputer system for $15,000. The system is expected to last 6 years with salvage value of $1,000. b. Lease a new microcomputer system for $3,000 per year, payable in advance. The system should last 6 years. c. Purchase a used microcomputer system for $8,200. It is expected to last 3 with no salvage value. Use a common-multiple-of-lives approach. If MARR of 8% is used, which alternative should be selected using a discounted present worth analysis? If the MARR is 12%, which alternate should be selected? years
Problem 9-16 Project Evaluation (LO2) Blooper Industries must replace its magnoosium purification system. Quick & Dirty Systems sells a relatively cheap purification system for $20 million. The system will last 4 years. Do-It-Right sells a sturdier but more expensive system for $21 million, it will last for 6 years. Both systems entail $2 million in operating costs; both will be depreciated straight-line to a final value of zero over their useful lives; neither will have any salvage value at the end of its life. The firm's tax rate is 30%, and the discount rate is 13%. a. What is the equivalent annual cost of investing in the cheap system? Note: Do not round intermediate calculations. Enter your answer as a positive value. Enter your answer in millions rounded to 2 decimal places. b. What is the equivalent annual cost of investing in the more expensive system? A Note: Do not round intermediate calculations. Enter your answer as a positive value. Enter your answer in millions rounded to…
Exercise 14-6 (Algo) Simple Rate of Return Method [LO14-6] The management of Ballard MicroBrew is considering the purchase of an automated bottling machine for $57,000. The machine would replace an old piece of equipment that costs $15,000 per year to operate. The new machine would cost $7,000 per year to operate. The old machine currently in use is fully depreciated and could be sold now for a salvage value of $24,000. The new machine would have a useful life of 10 years with no salvage value. Required: 1. What is the annual depreciation expense associated with the new bottling machine? 2. What is the annual incremental net operating income provided by the new bottling machine? 3. What is the amount of the initial investment associated with this project that should be used for calculating the simple rate of return? 4. What is the simple rate of return on the new bottling machine? (Round your answer to 1 decimal place i.e. 0.123 should be considered as 12.3%.)
Q. 3 The cost of a replacement packaging machine is $95,000. The machine is anticipated to reduce the packaging costs by $20 per parcel. The_purchasing company is expected to yield an output of 25,000 parcels per year. The salvage value of the machine is anticipated to be $23,000 at the end of 10 years. What is the present worth of the machine if the after-tax MARR is 10%, the CCA rate is 20%, and the tax rate is 40%?
21. Cost-Cutting Proposals [LO2] Tanaka Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $445,000 is estimated to result in $160,000 in annual pretax cost savings. The press falls in the MACRS five-year class, and it will have a salvage value at the end of the project of $40,000. The press also requires an initial investment in spare parts inventory of $20,000, along with an additional $2,800 in inventory for each succeeding year of the project. If the shop's tax rate is 22 percent and its discount rate is 9 percent, should the company buy and install the machine press?
QUESTION 7 You are considering starting a new factory producing small electric heaters. Each unit will sell at a price of $120. The production cost of each heater is $90. The fixed cost of production is $35000. This project has an economic life of 5 years. The project requires an investment of $125000 in plants and equipment. This equipment will be depreciated using a straight line depreciation method to a salvage value of zero. The required rate of return for the project is 12 percent. The marginal corporate tax rate is 21 percent. Based on these assumptions, calculate the number of units of production at the accounting (net profit) break-even point.
Question 17 Boyertown Industrial Tools is considering a 2-year project to improve its production efficiency. They have spent $25,000 over the previous year researching a new machine press. Buying the new machine press for $500,000 is estimated to result in $300,000 in annual pretax cost savings and will provide quarterly dividends of $2,500 to the shareholders. The press falls in the MACRS three-year class, and it will have a salvage value at the end of the project of $100,000. The press also requires an initial investment in spare parts inventory of $50,000, along with an additional $5,000 in inventory for each succeeding year of the project. If the tax rate is 35, what is the aftertax salvage value for the machine press? Property Class Year 3Year 5 year 7 year 1 33.33 20.00 14.29 2 44.45…
Project Evaluation [LO1] Dog Up! Franks is looking at a new sausage systemwith an installed cost of $460,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped for $55,000. The sausage system will save the firm $155,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $29,000. If the tax rate is 21 percent and the discount rate is 10 percent, what is the NPV of this project?
QUESTION 5 You are considering starting a new factory producing small electric heaters. Each unit will sell at a price of $55. The production cost of each heater is $35. You are expecting to sell 9000 units per year. This project has an economic life of 6 years. The project requires an investment of $700000 in plants and equipment. This equipment will be depreciated to zero salvage value based on 5-year MACRS schedule. The depreciation rates from year 1 to 6 are 20 % ,32 %, 19.2 %, 11.52 %, 11.52 %, and 5.76 percent, respectively. The required rate of return for the project is 12 percent, the working capital requirement is 10 percent of the next year's sales revenue. The company will sell its old equipment for $100,000. The old machine is fully depreciated. The marginal corporate tax rate is 20 percent. At the termination of the project, the plant and equipment will be sold for an estimated value of $50000. Based on these assumptions, estimate the net present value of the project.
QUESTION 6 You are considering starting a new factory producing small electric heaters. Each unit will sell at a price of $55. The production cost of each heater is $35. You are expecting to sell 9000 units per year. This project has an economic life of 6 years. The project requires an investment of $700000 in plants and equipment. This equipment will be depreciated to zero salvage value based on 5-year MACRS schedule. The depreciation rates from year 1 to 6 are 20 %,32 %, 19.2 %, 11.52 %, 11.52 %, and 5.76 percent, respectively. The required rate of return for the project is 12 percent, the working capital requirement is 10 percent of the next year's sales revenue. The company will sell its old equipment for $100,000. The old machine is fully depreciated. The marginal corporate tax rate is 20 percent. At the termination of the project, the plant and equipment will be sold for an estimated value of $50000. Based on these assumptions, estimate the internal rate of return for this…

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS