In: Finance
A company is buying a new system. It would cost $600,000 today.
Depreciate straight line to $0 over 2 years, and hauled away for
nothing, so the after-tax cash flow would be $0 in year 2.
The system is expected to reduce costs by 400,000 in year 1 and
400,000 in year 2.
If the tax rate is 30% and the cost of capital is 10% what is the
NPV of the system?
| Year 0 | Year 1 | Year 2 | |
| Savings in cost | - | 400,000 | 400,000 | 
| Less: Depreciation | - | 300,000 | 300,000 | 
| Profit before tax | - | 100,000 | 100,000 | 
| Tax at 30% | - | 30,000 | 30,000 | 
| Profit after tax | - | 70,000 | 70,000 | 
| Add back depreciation | - | 300,000 | 300,000 | 
| Cash flow after tax | - | 370,000 | 370,000 | 
| Initial Investment | (600,000) | - | - | 
| Total Cash flow | (600,000) | 370,000 | 370,000 | 
| Discount Factor at 10% | 1 | 0.909091 | 0.826446 | 
| Disconted Cash flow | (600,000) | 336,363.64 | 305,785.12 | 
| NPV = | 42,148.76 | 
NPV = Sum of discounted cash inflow - cash outflow
We add back depreciation because it is a non cash expense.
Straight line depreciation = Cost of asset / Useful life
Excel formulas:

Discount Factor formula without excel:

Where,
i = rate of return
n = number of periods