Please include the excel formula Your firm is contemplating the purchase of a new $535,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $30,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 $60,000 (this is a one-time reduction). If the tax rate is 24 percent, what is the IRR for this project? Input area: Initial investment $535,000 Pretax salvage value $30,000 Cost savings per year $165,000 Working capital reduction $60,000 Tax rate 24% Project and asset life 5 Output area: Aftertax salvage value Sell equipment Taxes Aftertax cash flow Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Costs Depreciation EBT Taxes Net income OCF Capital spending Net working capital Total cash flow IRR
Please include the excel formula Your firm is contemplating the purchase of a new $535,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $30,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 $60,000 (this is a one-time reduction). If the tax rate is 24 percent, what is the IRR for this project? Input area: Initial investment $535,000 Pretax salvage value $30,000 Cost savings per year $165,000 Working capital reduction $60,000 Tax rate 24% Project and asset life 5 Output area: Aftertax salvage value Sell equipment Taxes Aftertax cash flow Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Costs Depreciation EBT Taxes Net income OCF Capital spending Net working capital Total cash flow IRR
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
Related questions
Question
Please include the excel formula
| Your firm is contemplating the purchase of a new $535,000 computer-based order entry system. The system will be |
| Input area: | |
| Initial investment | $535,000 |
| Pretax salvage value | $30,000 |
| Cost savings per year | $165,000 |
| Working capital reduction | $60,000 |
| Tax rate | 24% |
| Project and asset life | 5 |
| Output area: | ||||||
| Aftertax salvage value | ||||||
| Sell equipment | ||||||
| Taxes | ||||||
| Aftertax cash flow | ||||||
| Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Costs | ||||||
| Depreciation | ||||||
| EBT | ||||||
| Taxes | ||||||
| Net income | ||||||
| OCF | ||||||
| Capital spending | ||||||
| Net working capital | ||||||
| Total cash flow | ||||||
| IRR |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
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