In: Finance
Fun With Finance is considering a new 3-year expansion project that requires an initial fixed asset investment of $1.458 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 $113,400. The project requires an initial investment in net working capital of $162,000. The project is estimated to generate $1,296,000 in annual sales, with costs of $518,400. The tax rate is 34 percent and the required return on the project is 10 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?
Time line | 0 | 1 | 2 | 3 | |
Cost of new machine | -1458000 | ||||
Initial working capital | -162000 | ||||
=Initial Investment outlay | -1620000 | ||||
Sales | 1296000 | 1296000 | 1296000 | ||
Profits | Sales-variable cost | 777600 | 777600 | 777600 | |
-Depreciation | Cost of equipment/no. of years | -486000 | -486000 | -486000 | |
=Pretax cash flows | 291600 | 291600 | 291600 | ||
-taxes | =(Pretax cash flows)*(1-tax) | 192456 | 192456 | 192456 | |
+Depreciation | 486000 | 486000 | 486000 | ||
=after tax operating cash flow | 678456 | 678456 | 678456 | ||
reversal of working capital | 162000 | ||||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 74844 | |||
+Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||
=Terminal year after tax cash flows | 236844 | ||||
Total Cash flow for the period | -1620000 | 678456 | 678456 | 915300 | |
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.1 | 1.21 | 1.331 |
Discounted CF= | Cashflow/discount factor | -1620000 | 616778.18 | 560707.438 | 687678.44 |
NPV= | Sum of discounted CF= | 245164.057 |