In: Finance
A) Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $3.01 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 $2062531 in annual sales, with costs of $819158. If the tax rate is 33 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.)
B)Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.6 million. The fixed asset will be depreciated straight-line over its three-year tax life, and the fixed asset will have a market value of $240861 at the end of the project. The project is estimated to generate $2030711 in annual sales, with costs of $868168. The project requires an initial investment in net working capital of $364334. If the tax rate is 34 percent and the required return on the project is 9 percent, what is the project's Year 0 net cash flow? (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.)
C)
Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.67 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 $297260 at the end of the project. The project is estimated to generate $2043001 in annual sales, with costs of $843186. The project requires an initial investment in net working capital of $374861. If the tax rate is 35 percent and the required return on the project is 12 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.)
A
Time line | 0 | 1 | 2 | 3 | |
Cost of new machine | -3010000 | ||||
=Initial Investment outlay | -3010000 | ||||
Sales | 2062531 | 2062531 | 2062531 | ||
Profits | Sales-variable cost | 1243373 | 1243373 | 1243373 | |
-Depreciation | Cost of equipment/no. of years | -1003333 | -1003333.3 | -1003333 | |
=Pretax cash flows | 240039.67 | 240039.667 | 240039.67 | ||
-taxes | =(Pretax cash flows)*(1-tax) | 160826.58 | 160826.577 | 160826.58 | |
+Depreciation | 1003333.3 | 1003333.33 | 1003333.3 | ||
=after tax operating cash flow | 1164159.9 | 1164159.91 | 1164159.9 | ||
+Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||
=Terminal year after tax cash flows | 0 | ||||
Total Cash flow for the period | -3010000 | 1164159.9 | 1164159.91 | 1164159.9 | |
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.11 | 1.2321 | 1.367631 |
Discounted CF= | Cashflow/discount factor | -3010000 | 1048792.7 | 944858.299 | 851223.69 |
NPV= | Sum of discounted CF= | -165125 |
B
Time line | 0 | |
Cost of new machine | -2600000 | |
Initial working capital | -364334 | |
=Initial Investment outlay | -2964334 |
C
Time line | 0 | 1 | 2 | 3 | |
Cost of new machine | -2670000 | ||||
Initial working capital | -374861 | ||||
=Initial Investment outlay | -3044861 | ||||
Sales | 2043001 | 2043001 | 2043001 | ||
Profits | Sales-variable cost | 1199815 | 1199815 | 1199815 | |
-Depreciation | Cost of equipment/no. of years | -890000 | -890000 | -890000 | |
=Pretax cash flows | 309815 | 309815 | 309815 | ||
-taxes | =(Pretax cash flows)*(1-tax) | 201379.75 | 201379.75 | 201379.75 | |
+Depreciation | 890000 | 890000 | 890000 | ||
=after tax operating cash flow | 1091379.8 | 1091379.75 | 1091379.8 | ||
reversal of working capital | 374861 | ||||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 193219 | |||
+Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||
=Terminal year after tax cash flows | 568080 | ||||
Total Cash flow for the period | -3044861 | 1091379.8 | 1091379.75 | 1659459.8 | |
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.12 | 1.2544 | 1.404928 |
Discounted CF= | Cashflow/discount factor | -3044861 | 974446.21 | 870041.255 | 1181170.7 |
NPV= | Sum of discounted CF= | -19203 |