Question

In: Finance

Alt's is contemplating the purchase of a new $218,000 computer-based order entry system. The system will...

Alt's is contemplating the purchase of a new $218,000 computer-based order entry system. The system will be depreciated straight-line to zero over the system's five-year life. The system will be worth $20,000 at the end of five years. The company will save $73,500 before taxes per year and will reduce working capital by $15,800 at the beginning of the project. The net working capital will return to its original level when the project ends. The tax rate is 21 percent. What is the internal rate of return for this project?

1) What is the depreciation each year? 2) What is the amount of OCF each year? 3) What is the total cash inflow/outflow each year? 4) What is the IRR for this project?

Expert Solution

1]

depreciation each year = cost of system / depreciable life

depreciation each year = $218,000 / 5 = $43,600

2]

Operating cash flow (OCF) each year = income after tax + depreciation

Operating cash flow (OCF) each year = $67,221

3]

Total cash flows are calculated as below

In year 5, the working capital investment is restored to its original level.

profit on sale of system at end of year 5 = sale price - book value

book value is zero as the system is fully depreciated

after-tax salvage value = salvage value - tax on profit on sale of system

4]

IRR is calculated using IRR function in Excel

IRR is 19.74%

jeff jeffy answered 1 year ago

Your firm is contemplating the purchase of a new $595,000 computer-based order entry system. The system...

Your firm is contemplating the purchase of a new $595,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $63,000 at the end of that time. You will save $225,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $78,000 (this is a one-time reduction). If the tax rate is 23 percent, what is the IRR for this project? (Do...

Your firm is contemplating the purchase of a new $630,000 computer-based order entry system. The system...

Your firm is contemplating the purchase of a new $630,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $70,000 at the end of that time. You will save $260,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $85,000 (this is a one-time reduction). If the tax rate is 25 percent, what is the IRR for this project? (Do...

Your firm is contemplating the purchase of a new $518,000 computer-based order entry system. The system...

Your firm is contemplating the purchase of a new $518,000 computer-based order entry system. The system will be depreciated straight-line to zero over its 5-year life. It will be worth $50,400 at the end of that time. You will be able to reduce working capital by $70,000 (this is a one-time reduction). The tax rate is 24 percent and your required return on the project is 23 percent and your pretax cost savings are $164,550 per year. What is the...

Your firm is contemplating the purchase of a new $585,000 computer-based order entry system. The system...

Your firm is contemplating the purchase of a new $585,000 computer-based order entry system. The system will be depreciated straight-line to zero over its 5-year life. It will be worth $73,000 at the end of that time. You will save $180,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $88,000 (this is a one-time reduction). If the tax rate is 22 percent, what is the IRR for this project? NPV...

Your firm is contemplating the purchase of a new $605,000 computer-based order entry system. The system...

Your firm is contemplating the purchase of a new $605,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $65,000 at the end of that time. You will save $235,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $80,000 (this is a one-time reduction). If the tax rate is 25 percent, what is the IRR for this project?

Your firm is contemplating the purchase of a new $592,000 computer-based order entry system. The system...

Your firm is contemplating the purchase of a new $592,000 computer-based order entry system. The system will be depreciated straight-line to zero over its 5-year life. It will be worth $57,600 at the end of that time. You will be able to reduce working capital by $80,000 (this is a one-time reduction). The tax rate is 34 percent and your required return on the project is 23 percent and your pretax cost savings are $201,400 per year. Requirement 1: What...

Your firm is contemplating the purchase of a new $684,500 computer-based order entry system. The system...

Your firm is contemplating the purchase of a new $684,500 computer-based order entry system. The system will be depreciated straight-line to zero over its 5-year life. It will be worth $66,600 at the end of that time. You will be able to reduce working capital by $92,500 (this is a one-time reduction). The tax rate is 21 percent and your required return on the project is 21 percent and your pretax cost savings are $203,750 per year. At what level...

Your firm is contemplating the purchase of a new $490,000 computer-based order entry system. The system...

Your firm is contemplating the purchase of a new $490,000 computer-based order entry system. The system will be depreciated straight-line to zero over its 7-year life. It will be worth $49,000 at the end of that time. You will be able to reduce working capital by $34,000 at the beginning of the project. Working capital will revert back to normal at the end of the project. Assume the tax rate is 24 percent. a. What is the aftertax salvage value...

Your firm is contemplating the purchase of a new $530,000 computer-based order entry system. The system...

Your firm is contemplating the purchase of a new $530,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $50,000 at the end of that time. You will save $186,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $85,000 (this is a one time reduction). If the tax rate is 35%, what is the IRR for the project?

Your firm is contemplating the purchase of a new $1,344,000 computer-based order entry system. The system...

Your firm is contemplating the purchase of a new $1,344,000 computer-based order entry system. The system will be depreciated straight-line to zero over its 5-year life. It will be worth $120,000 at the end of that time. You will save $528,000 before taxes per year in order processing costs and you will be able to reduce working capital by $177,994 (this is a one-time reduction). Required : If the tax rate is 30 percent, what is the IRR for this...