In: Finance
Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.56 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life and is estimated to have a market value of $207277 at the end of the project. The project is estimated to generate $2061404 in annual sales, with costs of $815049. The project requires an initial investment in net working capital of $369999. If the tax rate is 38 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 | -2560000 | ||||
Initial working capital | -369999 | ||||
=Initial Investment outlay | -2929999 | ||||
Sales | 2061404 | 2061404 | 2061404 | ||
Profits | Sales-variable cost | 1246355 | 1246355 | 1246355 | |
-Depreciation | Cost of equipment/no. of years | -853333.333 | -853333.33 | -853333.33 | |
=Pretax cash flows | 393021.6667 | 393021.667 | 393021.667 | ||
-taxes | =(Pretax cash flows)*(1-tax) | 243673.4333 | 243673.433 | 243673.433 | |
+Depreciation | 853333.3333 | 853333.333 | 853333.333 | ||
=after tax operating cash flow | 1097006.767 | 1097006.77 | 1097006.77 | ||
reversal of working capital | 369999 | ||||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 128511.74 | |||
+Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||
=Terminal year after tax cash flows | 498510.74 | ||||
Total Cash flow for the period | -2929999 | 1097006.767 | 1097006.77 | 1595517.51 | |
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.11 | 1.2321 | 1.367631 |
Discounted CF= | Cashflow/discount factor | -2929999 | 988294.3844 | 890355.301 | 1166628.65 |
NPV= | Sum of discounted CF= | 115279 |