In: Finance
Answer is: -$7,708
Particulars | Year 0 | Year 1 | Year 2 | Year 3 |
Annual Sales Revenues | - | 56,000 | 56,000 | 56,000 |
Less: Annual Operating costs | - | 30,000 | 30,000 | 30,000 |
Less: Depreciation | - | 23,333.10 | 23,333.10 | 23,333.10 |
Operating Income | - | 2,666.90 | 2,666.90 | 2,666.90 |
Less: Tax at 35% | - | 933.42 | 933.42 | 933.42 |
Income after tax | - | 1,733.49 | 1,733.49 | 1,733.49 |
Add back Depreciation | - | 23,333.10 | 23,333.10 | 23,333.10 |
Cash flow from operations | - | $25,067 | $25,067 | $25,067 |
Initial Investment | -$70,000 | - | - | - |
Investment in Net working Capital | -$10,000 | - | - | 10,000 |
After tax salvage value (1-Tax rate) | $0 | - | - | 3,250 |
Net Cash flow | -$80,000 | 25,067 | 25,067 | 38,317 |
Discount Factor | $1 | 0.90909 | 0.82645 | 0.75131 |
Discounted Cash flow | -$80,000 | $22,788 | $20,716 | $28,788 |
NPV = | -$7,708 |
Excel formulas:
Discount factor formula, if not using excel:
Where,
i = rate of return
n = number of periods