In: Finance
Kolby’s Korndogs is looking at a new sausage system with an installed cost of $720,000. The asset qualifies for 100 percent bonus depreciation and can be scrapped for $98,000 at the end of the project’s 5-year life. The sausage system will save the firm $209,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $61,000. If the tax rate is 23 percent and the discount rate is 9 percent, what is the NPV of this project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) I got 99,251.21 but I got it wrong, so I am trying to figure out on where I went wrong into solving the problem. |
Calculation of NPV of the Project | ||||||
Particulars | 0 | 1 | 2 | 3 | 4 | 5 |
Initial Investment | ||||||
Cost of new Sausge system | -720000 | |||||
Investment in working capital | -61000 | |||||
Net Investment (A) | -781000 | |||||
Operating Cash Flows | ||||||
Saving in Pretax Operating Costs (B) | 209000 | 209000 | 209000 | 209000 | 209000 | |
Less: Depreciation (C ) (Year 1: $720000 * 100%) |
720000 | 0 | 0 | 0 | 0 | |
Profit Before Tax (D = B-C) | -511000 | 209000 | 209000 | 209000 | 209000 | |
Less: Tax @23% (E = D*23%) | -117530 | 48070 | 48070 | 48070 | 48070 | |
Profit After Tax (F = D-E) | -393470 | 160930 | 160930 | 160930 | 160930 | |
Add back Depreciation (G = C) | 720000 | 0 | 0 | 0 | 0 | |
Net Operating Cash Flows (H = F+G) | 326530 | 160930 | 160930 | 160930 | 160930 | |
Terminal Value | ||||||
Scrap value (I) | 98000 | |||||
Less: Tax @23% (J = I*23%) | 22540 | |||||
After tax scrap value (K = I-J) | 75460 | |||||
Recovery of Working Capital (L) | 61000 | |||||
Net Terminal Value (M = K+L) | 136460 | |||||
Total Cash Flows (N = A+H+M) | -781000 | 326530 | 160930 | 160930 | 160930 | 297390 |
Discount Factor @9% (O) 1/(1+9%)^n n = 0,1,2,3,4,5 |
1 | 0.917431 | 0.84168 | 0.772183 | 0.708425 | 0.649931 |
Discounted Cash Flows (P = N*O) | -781000 | 299568.8 | 135451.6 | 124267.5 | 114006.9 | 193283.1 |
NPV of the Project | 85577.82 |
Therefore, NPV of the Project is $85,577.82