This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: o Growing perpetuity: PMT/ (Int. RATE Growth Rate) o Declining perpetuity: Same as above, but make growth rate negative PV of uneven cash flows: o =NPV (rate, range of flows) o Leave out period 0 FV of uneven cash flows: o =FV (rate, $(per)5 (per)1, 0, cash flow for per. 1) for period one o Do this for all 5 periods o Sum the FVs together o *OR, =FV (rate, 5, 0, NPV (rate, range of cash flows)) NPV: o =NPV (rate, range of cash flows at per. 1) cash flow at per. 0 IRR: o =IRR (range of cash flows at per. 0, guess)...
View Full
Document
 Spring '08
 Croce
 Annuity, Corporate Finance

Click to edit the document details