Question

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 $9,000,000, and it will be depreciated on a straight-line basis over a period of six years (years 1-6). • The old machine is also 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 working capital (NWC) of $30,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 $700,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 40%.
PLEASE NOTE- there is also a Year 6 column that is not reflected in my screen shots (they were cut off). Please take Year 6 into account when providing guidance. Thank you

Answer 1

Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 0 -9000000 700000 280000 580000 700000 280000 580000 700000 280000 580000 700000 280000 580000 700000 280000 600000 700000 280000 600000 Initial Investment EBIT - Taxes + A Depreciation XT + Salvage Value - Tax on Salvage -NWC + Recapture of NWC Total Free Cash Flow 300000 40000 30000 30000 1050000 | -8770000 1000000 1000000 1000000 1000000 1020000 New Depreciation = Initial Investment / Useful Life New Depreciation = $9,000,000 / 6 = $1,500,000 Year 1 - Year 4: A Depreciation XT = (New Depreciation - Old Depreciation) x Tax Rate A Depreciation XT = ($1,500,000 - $50,000) x 40% = $580,000 Year 5 - Year 6: A Depreciation XT = (New Depreciation - Old Depreciation) x Tax Rate A Depreciation XT = ($1,500,000 - $0) x 40% = $ 600,000 Taxon Salvage = Tax Rate * (Salvage Value - Book Value) Taxon Salvage = 40% *($300,000 - $200,000) = $40,000 Required Rate of Return = 13% NPV = $8,770,000+ $1,000,000/1.13 + $1,000,000/1.13^2 + $1,000,000/1.13^3 + $1,000,000/1.13^4 + $1,020,000/1.1345 + $1,050,000/1.1346 NPV = $4,737,579 The net present value (NPV) of this replacement project is $4,737,579