In: Finance
Your firm is contemplating the purchase of a new $570,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $58,000 at the end of that time. You will save $270,000 before taxes per year in order processing costs, and you will be able to reduce working capital by $73,000 (this is a one-time reduction). If the tax rate is 35 percent, what is the IRR for this project?
Tax rate | 35% | ||||||
Calculation of annual depreciation | |||||||
Depreciation | Year-1 | Year-2 | Year-3 | Year-4 | Year-5 | Total | |
Cost (270000+54000) | $ 570,000 | $ 570,000 | $ 570,000 | $ 570,000 | $ 570,000 | ||
Dep Rate | 20.00% | 20.00% | 20.00% | 20.00% | 20.00% | ||
Depreciation | Cost * Dep rate | $ 114,000 | $ 114,000 | $ 114,000 | $ 114,000 | $ 114,000 | $ 570,000 |
Calculation of after-tax salvage value | |||||||
Cost of machine | $ 570,000 | ||||||
Depreciation | $ 570,000 | ||||||
WDV | Cost less accumulated depreciation | $ - | |||||
Sale price | $ 58,000 | ||||||
Profit/(Loss) | Sale price less WDV | $ 58,000 | |||||
Tax | Profit/(Loss)*tax rate | $ 20,300 | |||||
Sale price after-tax | Sale price less tax | $ 37,700 | |||||
Calculation of annual operating cash flow | |||||||
Year-1 | Year-2 | Year-3 | Year-4 | Year-5 | |||
Cost saving | $ 270,000 | $ 270,000 | $ 270,000 | $ 270,000 | $ 270,000 | ||
Less: Depreciation | $ 114,000 | $ 114,000 | $ 114,000 | $ 114,000 | $ 114,000 | ||
Profit before tax (PBT) | $ 156,000 | $ 156,000 | $ 156,000 | $ 156,000 | $ 156,000 | ||
Tax@35% | PBT*Tax rate | $ 54,600 | $ 54,600 | $ 54,600 | $ 54,600 | $ 54,600 | |
Profit After Tax (PAT) | PBT - Tax | $ 101,400 | $ 101,400 | $ 101,400 | $ 101,400 | $ 101,400 | |
Add Depreciation | PAT + Dep | $ 114,000 | $ 114,000 | $ 114,000 | $ 114,000 | $ 114,000 | |
Cash Profit after-tax | $ 215,400 | $ 215,400 | $ 215,400 | $ 215,400 | $ 215,400 | ||
Calculation of annual cash flow | |||||||
Year | Capital | Working capital | Operating cash | Annual Cash flow | |||
0 | $ (570,000) | $ 73,000 | $ (497,000) | ||||
1 | $ 215,400 | $ 215,400 | |||||
2 | $ 215,400 | $ 215,400 | |||||
3 | $ 215,400 | $ 215,400 | |||||
4 | $ 215,400 | $ 215,400 | |||||
5 | $ 37,700 | $ (73,000) | $ 215,400 | $ 180,100 | |||
Calculation of IRR | |||||||
31.00% | 32.00% | ||||||
Year | Total cash flow | PV factor @ 31% | Present values | PV factor @ 32% | Present values | ||
0 | $ (497,000) | 1.000 | $ (497,000) | 1.000 | $ (497,000) | ||
1 | $ 215,400 | 0.763 | $ 164,427 | 0.758 | $ 163,182 | ||
2 | $ 215,400 | 0.583 | $ 125,517 | 0.574 | $ 123,623 | ||
3 | $ 215,400 | 0.445 | $ 95,815 | 0.435 | $ 93,653 | ||
4 | $ 215,400 | 0.340 | $ 73,141 | 0.329 | $ 70,950 | ||
5 | $ 180,100 | 0.259 | $ 46,683 | 0.250 | $ 44,941 | ||
$ 8,583 | $ (651) | ||||||
IRR | =Lower rate + Difference in rates*(NPV at lower rate)/(Lower rate NPV-Higher rate NPV) | ||||||
IRR | '=31%+ (32%-31%)*(8583.04/(8583.04-(-651.37) | ||||||
Related SolutionsYour firm is contemplating the purchase of a new $570,000 computer-based order entry system. The system...
Your firm is contemplating the purchase of a new $570,000
computer-based order entry system. The system will be depreciated
straight-line to zero over its five-year life. It will be worth
$86,000 at the end of that time. You will save $175,000 before
taxes per year in order processing costs, and you will be able to
reduce working capital by $111,000 (this is a one-time reduction).
If the tax rate is 22 percent, what is the IRR for this project?
(Do...
Your firm is contemplating the purchase of a new $475,000 computer based order entry system will...Your firm is contemplating the purchase of a new
$475,000 computer based order entry system will be depreciated
straight line to zero over its 6 year life . It will be worth $60
,000 at the end of that time . You will save $165,000 before taxes
per year in order processing costs, and you will be able to reduce
working capital by $45,000 at the beginning of the project. Working
capital will revert back to normal at the end...
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|