In: Finance
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment of $3.186 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 $247,800. The project requires an initial investment in net working capital of $354,000. The project is estimated to generate $2,832,000 in annual sales, with costs of $1,132,800. The tax rate is 22 percent and the required return on the project is 17 percent.
What is the NPV?
Calculation of Cash flows | ||||
Year 0 | Year 1 | Year 2 | Year 3 | |
Initial Investment | (3,186,000) | |||
Investment in Working capital | (354,000) | |||
Annual sales | 2,832,000 | 2,832,000 | 2,832,000 | |
Costs | 1,132,800 | 1,132,800 | 1,132,800 | |
Depreciation | 1,062,000 | 1,062,000 | 1,062,000 | |
Income before tax | 637,200 | 637,200 | 637,200 | |
Less: Tax | 140,184 | 140,184 | 140,184 | |
Net Income | 497,016 | 497,016 | 497,016 | |
Add: Depreciation | 1,062,000 | 1,062,000 | 1,062,000 | |
Recovery of working capital | 354,000 | |||
After tax salvage value | 193,284 | |||
Cash flow | (3,540,000) | 1,559,016 | 1,559,016 | 2,106,300 |
PVF | 1 | 0.854700855 | 0.730513551 | 0.624370556 |
PV of cash flows | (3,540,000) | 1,332,492 | 1,138,882 | 1,315,112 |
NPV | 246,486.32 |