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.
$__________
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 | $__________ | $__________ | ||
| 1-4 | $___________ | $__________ | ||
| 5 | $___________ | $__________ |
Net present value_________________________$___________
| Req 1 | ||||||
| Year 0 | Year 1-4 | Year 5 | ||||
| Initial Invstment | -720000 | |||||
| Workin capital investment | -100000 | |||||
| Annual Revenue | 740000 | 740000 | ||||
| Annual Operating expense | -444000 | -444000 | ||||
| Salvage value of equipment | 100000 | |||||
| Working capital released | 100000 | |||||
| Cash flows | -820000 | 296000 | 496000 | |||
| Year | Cash flows | |||||
| YEar0 | -820000 | |||||
| Year 1-4 | 296000 | |||||
| Year 5 | 496000 | |||||
| Req 2: | ||||||
| Net present value | ||||||
| Year | Cash flows | PVF @ 8% | Present Value | |||
| YEar0 | -820000 | 1 | -820000 | |||
| Year 1-4 | 296000 | 3.3121 | 980381.6 | |||
| Year 5 | 496000 | 0.6806 | 337577.6 | |||
| Net present value | 497959 | |||||
| Req 3: | ||||||
| Revised Net present value (cash flows from Year1-5 will be reduced by $ 148000) | ||||||
| Year | Cash flows | PVF @ 8% | Present Value | |||
| YEar0 | -820000 | 1 | -820000 | |||
| Year 1-4 | 148000 | 3.3121 | 490190.8 | |||
| Year 5 | 348000 | 0.6806 | 236848.8 | |||
| Net present value | -92960 | |||||