Reference no: EM132605536

My Company is evaluating the replacement of a machine. It was originally purchased ten years ago at a cost of $60,000 and has been depreciated to a book value of $0. If my company replaces the machine, it will be able to bid on larger projects that require the capabilities of the new machine. The new machine will cost the firm $100,000, which will be depreciated over 5 years according to the following depreciation rates: 30% in year 1, 25% in each of years 2 and 3, and 10% in each of years 4 and 5. The new machine qualifies for an immediate 3% investment tax credit. My Company anticipates that at the end of the machine's eight year economic life it will be sold for $5,000. My Company estimates that its existing machine can be sold today for $7,000. If my Company does not replace the machine, it anticipates being able to use the existing machine for ten more years at which time its salvage value would be zero. Without the purchase of the new machine, my Company expects to generate revenue of $200,000 per year.

• The firm's use of its existing machine is expected to generate operating expenses of $170,000 per year. If the new machine is purchased, my Company expects the firm's annual revenues and operating costs to increase to $250,000 and $190,000 respectively. To support the sales increase, a working capital investment of $5,000 is necessary. My Company's marginal tax rate is 30%. If EBT is negative in any year, assume that the firm has positive EBT values in other divisions and that the EBT loss can be applied to those. This would result in a tax savings in each year when EBT is negative for this project. To finance this project, My Company will raise 30% of the capital from debt and 70% of the capital from equity; its after-tax cost of debt is 8% and the cost of equity is 18%.This results in a cost of capital of 15%.

Question 1: Calculate the NPV for this project.

Question 2: Calculate the IRR for this project using Excel