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%.

Please use the following format:

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: