Discounted Cash Flow Valuations and Net Present Value
DatDude
WorksheetinRWJ_Corp_12e_PPT_Ch05-IRRExample.xls
Sheet1
| Year | 0 | 1 | 2 | 3 |
| Cash Flows | -165000 | 63120 | 70800 | 91080 |
| Required Return | 0.12 |
| NPV—Incorrect | $11,274.48 |
| NPV—Correct | $12,627.41 |
| IRR | 16% | 16.13% |
| | Default Format |