In: Finance
Down Under Boomerang, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $2.94 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will be worthless. The project is estimated to generate $2,160,000 in annual sales, with costs of $855,000. The project requires an initial investment in net working capital of $380,000, and the fixed asset will have a market value of $250,000 at the end of the project. If the tax rate is 34 percent, what is the project’s Year 0 net cash flow? Year 1? Year 2? Year 3?
Year | 0 | 1 | 2 | 3 | |||
A | Fixed asset cost | (2,940,000) | |||||
B | Working capital | (380,000) | 380000 | ||||
Operating cash flow | |||||||
i | sales | 2,160,000 | 2,160,000 | 2,160,000 | |||
ii | Cost | 855000 | 855000 | 855000 | |||
iii | Depreciation =2940000/3 | 980000 | 980000 | 980000 | |||
iv=i-ii-iii | Profit before tax | 325,000 | 325,000 | 325,000 | |||
v=iv*34% | Tax @ 34% | 110,500 | 110,500 | 110,500 | |||
vi=iv-v | Profit after tax | 214,500 | 214,500 | 214,500 | |||
vii | Depreciation | 980000 | 980000 | 980000 | |||
C=viii=vi+vii | Operating cash flow | 1,194,500 | 1,194,500 | 1,194,500 | |||
D | Post tax salvage value =250000*(1-34%) | 165000 | |||||
E=A+B+C+D | Total cash flow | (3,320,000) | 1,194,500 | 1,194,500 | 1,739,500 | ||
therefore Answer - | |||||||
0 | (3,320,000) | ||||||
1 | 1,194,500 | ||||||
2 | 1,194,500 | ||||||
3 | 1,739,500 | ||||||
Computation of NPV | |||||||
year | Cash flow | PVIF @ 10% | present value | ||||
0 | (3,320,000) | 1.0000 | (3,320,000.00) | ||||
1 | 1,194,500 | 0.9091 | 1,085,909.09 | ||||
2 | 1,194,500 | 0.8264 | 987,190.08 | ||||
3 | 1,739,500 | 0.7513 | 1,306,912.10 | ||||
60,011.27 | |||||||
therefore NPV = | 60,011.27 | ||||||