Excel Ch. 6, 9

Excel Ch. 6, 9 - o Growing perpetuity: PMT/ (Int. RATE...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Ch. 6: Excel PV of an annuity: o How much should you be willing to pay for the annuity at the beginning? o =-PV (rate, nper, pmt) FV of an annuity: o How much would the annuity be worth after you had received all of the cash flows? I.e. at the end o =-FV (rate, nper, pmt) Solving for PMT amount: o =PMT (rate, nper, -pv, fv) o PV: Treat as initial lump sum to be invested Make negative Solving for NPER, RATE: o =NPER (same as before) o =RATE (same as before) o FV: “I want to have $x left over from my PV” Perpetuities: o Annuity that goes on forever o No such thing as FV of a perpetuity o =PMT/ RATE (both per period)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the 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

Page1 / 2

Excel Ch. 6, 9 - o Growing perpetuity: PMT/ (Int. RATE...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online