Discounted Cash Flow Valuations and Net Present Value

profileDatDude
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

Sheet2

Sheet3