In: Accounting
Net Present Value
Carsen Sorensen, controller of Thayn Company, just received the following data associated with production of a new product:
Expected annual revenues: $740,000
Projected product life cycle: five years
Equipment: $720,000 with a salvage value of $100,000 after five years
Expected increase in working capital: $100,000 (recoverable at the end of five years)
Annual cash operating expenses: estimated at $444,000
Required rate of return: 8 percent
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.
$_____?_____ not 497959
3. What if revenues were overestimated by $148,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 | -820000 | -820000 | 
| 1-4 | 148000 | ________? ________not 490191 | 
| 5 | 348000 | _________? ________not 236849 | 
| net present value | $_______?_______not -92960 | 
Year Cash Flow Present Value 0 $__________ $__________ 1-4 $___________ $__________ 5 $___________ $__________ Net present value_________________________$___________
| 
 1-  | 
 Year  | 
 0  | 
 1  | 
 2  | 
 3  | 
 4  | 
 5  | 
| 
 cost of machine  | 
 -720000  | 
||||||
| 
 investment in working capital  | 
 -100000  | 
||||||
| 
 expected annual revenue  | 
 740000  | 
 740000  | 
 740000  | 
 740000  | 
 740000  | 
||
| 
 less operating expense  | 
 444000  | 
 444000  | 
 444000  | 
 444000  | 
 444000  | 
||
| 
 operating profit  | 
 296000  | 
 296000  | 
 296000  | 
 296000  | 
 296000  | 
||
| 
 recovery of working capital  | 
 100000  | 
||||||
| 
 scrap value of equipment  | 
 100000  | 
||||||
| 
 net operating cash flow  | 
 -820000  | 
 296000  | 
 296000  | 
 296000  | 
 296000  | 
 496000  | 
|
| 
 present value of cash flow at 8% = cash flow/(1+r)^n r= 8%  | 
 -820000  | 
 253772.3  | 
 253772.3  | 
 234974.3  | 
 217568.8  | 
 337569.3  | 
|
| 
 2-  | 
 NPV = sum of present value of cash flow  | 
 477657  | 
|||||
| 
 3-  | 
 Year  | 
 0  | 
 1  | 
 2  | 
 3  | 
 4  | 
 5  | 
| 
 cost of machine  | 
 -720000  | 
||||||
| 
 investment in working capital  | 
 -100000  | 
||||||
| 
 expected annual revenue  | 
 592000  | 
 592000  | 
 592000  | 
 592000  | 
 592000  | 
||
| 
 less operating expense  | 
 444000  | 
 444000  | 
 444000  | 
 444000  | 
 444000  | 
||
| 
 operating profit  | 
 148000  | 
 148000  | 
 148000  | 
 148000  | 
 148000  | 
||
| 
 recovery of working capital  | 
 100000  | 
||||||
| 
 scrap value of equipment  | 
 100000  | 
||||||
| 
 net operating cash flow  | 
 -820000  | 
 148000  | 
 148000  | 
 148000  | 
 148000  | 
 348000  | 
|
| 
 present value of cash flow at 8% = cash flow/(1+r)^n r= 8%  | 
 -820000  | 
 126886.1  | 
 126886.1  | 
 117487.2  | 
 108784.4  | 
 236843  | 
|
| 
 NPV = sum of present value of cash flow  | 
 -103113  |