Question
The ABC Corporation is going to invest in a new piece of equipment which will cost $275,000 and falls into 5-year MACRS property. It costs
The ABC Corporation is going to invest in a new piece of equipment which will cost $275,000 and falls into 5-year MACRS property. It costs $20,000 for delivery and installation. The company spends $10,000 for the Research and Development related to this project at the initial year, and need to pay $20,000 the rent for the factory which the equipment will be installed every year. Because the company has another project to do in the same factory, it will rent the factory regardless of the installation of the new equipment. It is expected to increase revenues in the first year of operations by $130,000. Revenues are expected to grow 10% each year for the life of the project, which is 4 years. A new project will affect the firms existing projects. If the company installs the new equipment, the revenue of its existing projects decreases by $20,000 every year. Operating costs (excluding depreciation) are expected to $50,000 at year 1 and are expected to grow 15% each year for the life of the project. Initial net working capital needs are $10,000 and will be $5,000 each year during the entire period of the project (from year 1 to year 4). NWC is recovered each year. The firm believes it can sell the equipment in year 4 for $12,000. The marginal tax rate is 34% and the firms cost of capital is 7%. Use the provided Excel template on Moodle and decide based on both NPV and IRR rules.
1. Operating Cash Flow | |||||
Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | |
Sales | |||||
- Cost | |||||
- Depreciation | |||||
= EBT | |||||
- Tax | |||||
= NI | |||||
OCF = NI + Depreciation | |||||
Depreciation Worksheet | |||||
Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | |
Cost of equipment (basis) | |||||
x Depreciation Rate | |||||
Depreciation | |||||
Accumulated Dep (AD) | |||||
Book Value = Basis - AD | |||||
2. Change in Net Working Capital | |||||
Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | |
Annual need | |||||
Annual recovery | |||||
Last year recovery | |||||
Change in NWC | |||||
3. Net Capital Spending | |||||
Initial investment | |||||
Estimate selling price | |||||
- BV when selling | |||||
Ordinary gain (loss) | |||||
Tax on gain (tax reduction) | |||||
Estimate selling price | |||||
- Tax (tax reduction) | |||||
After-tax salvage | |||||
4. Total Cash Flow | |||||
Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | |
1. OCF | |||||
2. Change in NWC | |||||
3. CAPEX | |||||
Total CF | |||||
I | NPV | ||||
IRR | |||||
Decision: | |||||
Reason: |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started