In: Finance
Summer Tyme, Inc., is considering a new 3-year expansion project that requires an initial fixed asset investment of $3.726 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $289,800. The project requires an initial investment in net working capital of $414,000. The project is estimated to generate $3,312,000 in annual sales, with costs of $1,324,800. The tax rate is 30 percent and the required return on the project is 17 percent. Required:
(a) What is the project's year 0 net cash flow?
(b) What is the project's year 1 net cash flow?
(c) What is the project's year 2 net cash flow?
(d) What is the project's year 3 net cash flow?
(e) What is the NPV?
(a) | Project's year 0 net cash flow | $ -41,40,000 | |||||||
Working: | |||||||||
Investment in Fixed Asset | $ 37,26,000 | ||||||||
Investment in net working capital | $ 4,14,000 | ||||||||
Year 0 cash flow | $ 41,40,000 | ||||||||
(b) | Project's year 1 net cash flow | $ 17,63,640 | |||||||
Working: | |||||||||
Straight line depreciation | = | (Cost -salvage value)/Useful Life | |||||||
= | (3726000-0)/3 | ||||||||
= | $ 12,42,000 | ||||||||
Annual Sales | 33,12,000 | ||||||||
Cost of sales | -13,24,800 | ||||||||
Depreciation | -12,42,000 | ||||||||
Profit before tax | 7,45,200 | ||||||||
Tax | -2,23,560 | ||||||||
Net Income | 5,21,640 | ||||||||
Depreciation | 12,42,000 | ||||||||
Cash flow | 17,63,640 | ||||||||
(c) | Project's year 2 net cash flow | $ 17,63,640 | |||||||
(d) | Project's year 3 net cash flow | $ 23,80,500 | |||||||
Working: | |||||||||
After tax sale proceeds of asset | = | 289800*(1-0.30) | |||||||
= | 2,02,860 | ||||||||
After tax sale proceeds of asset | 2,02,860 | ||||||||
Release of net working capital | 4,14,000 | ||||||||
Operating cash flow | 17,63,640 | ||||||||
Total Cash flow | 23,80,500 | ||||||||
(e) | NPV | $ 1,42,061.64 | |||||||
Working: | |||||||||
Year | Cash flow | Discount factor | Present Value | ||||||
0 | $ -41,40,000 | 1.0000 | $ -41,40,000.00 | ||||||
1 | 17,63,640 | 0.8547 | 15,07,384.62 | ||||||
2 | 17,63,640 | 0.7305 | 12,88,362.92 | ||||||
3 | 23,80,500 | 0.6244 | 14,86,314.11 | ||||||
NPV | 1,42,061.64 | ||||||||