In: Accounting
Net Present Value
Carsen Sorensen, controller of Thayn Company, just received the following data associated with production of a new product:
The present value tables provided in Exhibit 19B.1 and Exhibit 19B.2 must be used to solve the following problems.
Required:
1. Estimate the annual cash flows for the new product. Enter cash outflows as negative amounts and cash inflows as positive amounts.
| Year | Cash Flow | 
| 0 | $ | 
| 1–4 | $ | 
| 5 | $ | 
2. Using the estimated annual cash flows,
calculate the NPV.
$
3. What if revenues were overestimated by $152,000? Redo the NPV analysis, correcting for this error. Assume the operating expenses remain the same. Enter cash outflows as negative amounts and cash inflows as positive amounts.
| Year | Cash Flow | Present Value | 
| 0 | $ | $ | 
| 1–4 | ||
| 5 | ||
| Net present value | $ | 
1.
| Year | Cash Flow | |
| 0 | $ -8,80,000 | =-780000 (Equipment) -100000 (Working Capital) | 
| 1–4 | $ 3,04,000 | =(760000 (Revenue) -456000 (CAsh Expenses)) x 4 years | 
| 5 | $ 5,04,000 | =304000+100000 (Salvage Value)+100000 (Working Capital) | 
2.
| Year | Cash Flow | PV factor @8% | PV | 
| 0 | $ -8,80,000 | 1 | $ -8,80,000 | 
| 1–4 | $ 3,04,000 | 3.312 | $ 10,06,848 | 
| 5 | $ 5,04,000 | 0.6806 | $ 3,43,022 | 
| NPV | $ 4,69,870 | 
3.
| Year | Cash Flow | PV factor @8% | PV | 
| 0 | $ -8,80,000 | 1 | $ -8,80,000 | 
| 1–4 | $ 1,52,000 | 3.312 | $ 5,03,424 | 
| 5 | $ 3,52,000 | 0.6806 | $ 2,39,571 | 
| NPV | $ -1,37,005 | 
Annual Cash Flow = $304000 - $152000 = $152000