In: Finance
Quad Enterprises 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 $2057308 in annual sales, with costs of $823420. If the tax rate is 32 percent and the required return on the project is 11 percent, what is the project's NPV? (Negative amount should be indicated by a minus sign. Do not round intermediate calculations and round your final answer to the nearest dollar amount. Omit the "$" sign and commas in your response. For example, $123,456.78 should be entered as 123457.)
| Time line | 0 | 1 | 2 | 3 | |
| Cost of new machine | -2940000 | ||||
| =Initial Investment outlay | -2940000 | ||||
| Sales | 2057308 | 2057308 | 2057308 | ||
| Profits | Sales-variable cost | 1233888 | 1233888 | 1233888 | |
| -Depreciation | Cost of equipment/no. of years | -980000 | -980000 | -980000 | |
| =Pretax cash flows | 253888 | 253888 | 253888 | ||
| -taxes | =(Pretax cash flows)*(1-tax) | 172643.84 | 172643.84 | 172643.84 | |
| +Depreciation | 980000 | 980000 | 980000 | ||
| =after tax operating cash flow | 1152643.84 | 1152643.84 | 1152643.84 | ||
| +Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||
| =Terminal year after tax cash flows | 0 | ||||
| Total Cash flow for the period | -2940000 | 1152643.84 | 1152643.84 | 1152643.84 | |
| Discount factor= | (1+discount rate)^corresponding period | 1 | 1.11 | 1.2321 | 1.367631 |
| Discounted CF= | Cashflow/discount factor | -2940000 | 1038417.874 | 935511.598 | 842803.242 |
| NPV= | Sum of discounted CF= | -123267 | |||