In: Finance
Summer Tyme, Inc., is considering a new 3-year expansion project that requires an initial fixed asset investment of $5.9 million. The fixed asset falls into the 3-year MACRS class (MACRS Table) and will have a market value of $462,000 after 3 years. The project requires an initial investment in net working capital of $660,000. The project is estimated to generate $5,280,000 in annual sales, with costs of $2,112,000. The tax rate is 34 percent and the required return on the project is 15 percent. (Do not round your intermediate calculations.) 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?
| Note 1 | ||||||
| Computation of MARC depreciation | 1 | 2 | 3 | |||
| Depreciation rate | 33.33% | 44.45% | 14.81% | |||
| Depreciation amount | 1,966,470 | 2,622,550 | 873,790 | |||
| Note 2 | ||||||
| Computation of post tax salvage value | ||||||
| Sales price of asset = | 462,000 | |||||
| book value = | 437,190 | |||||
| Gain on sales | 24,810 | |||||
| Tax on gain | 8,435 | |||||
| Post tax salvage value= | 453,565 | |||||
| sales - cost = | ||||||
| 5,280,000-2,112,000. | 3168000 | |||||
| year | 0 | 1 | 2 | 3 | ||
| Initial investment | (5,900,000) | |||||
| Working capital | (660,000) | 660,000 | ||||
| Operating cash flow | ||||||
| Sales- cost | 3,168,000 | 3,168,000 | 3,168,000 | |||
| depreciation | 1,966,470.00 | 2,622,550.00 | 873,790.00 | |||
| Profit before tax | 1,201,530.00 | 545,450.00 | 2,294,210.00 | |||
| Tax @ 34% | 408,520.20 | 185,453.00 | 780,031.40 | |||
| Net income | 793,009.80 | 359,997.00 | 1,514,178.60 | |||
| Operating cash flow | 2,759,479.80 | 2,982,547.00 | 2,387,968.60 | |||
| Post tax salvage value | ||||||
| Note -2 | 453,565 | |||||
| Net cash flow | (6,560,000.00) | 2,759,479.80 | 2,982,547.00 | 3,501,533.20 | ||
| PVIF @ 15% | 1 | 0.869565217 | 0.756143667 | 0.657516232 | ||
| Present value | (6,560,000.00) | 2,399,547.65 | 2,255,234.03 | 2,302,314.92 | 397,096.60 | |
| ans a) | Year 0 Cash flow | (6,560,000.00) | ||||
| ans b) | Year 1 Cash flow | 2,759,479.80 | ||||
| ans c) | Year 2 Cash flow | 2,982,547.00 | ||||
| ans d) | Year 3 Cash flow | 3,501,533.20 | ||||
| ans e) | NPV= | 397,096.60 |