Excel Ch. 5

Excel Ch. 5 - o FV Just like PV enter as a negative number...

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

View Full Document Right Arrow Icon
Ch. 5: Excel FV of a lump sum: o =FV (rate, nper, pmt, -pv, type) o Rate: Rate per period I.e. annual rate of 10% compounded semiannually equals rate of 5% per period o Nper: Number of periods I.e. a 5 year time span compounded semiannually would be 10 periods o Pmt: Relevant for annuities o PV: Enter as a negative (cash outflow) o Type: Relevant for some annuities Enter 0 if payments are made at end of period Enter 1 if payments made at beginning of period (annuity due) PV of a lump sum: o =PV (rate, nper, pmt, -fv, type)
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 FV: Just like PV, enter as a negative number • Solving for nper: o =NPER (rate, pmt, -pv, fv, type) o PV/ FV: Make one negative and one positive o “Double your money”: #s don’t matter Just make FV 2x PV • Solving for rate: o =RATE (nper, pmt, pv, fv, type, guess) o Guess: Ignore • Weird stuff: o What portion of a monthly payment (say, the payment to period 101) goes towards the principle, and what portion goes toward interest? IPMT PPMT...
View Full Document

This note was uploaded on 06/11/2011 for the course BUSI 408 taught by Professor Croce during the Spring '08 term at UNC.

Page1 / 2

Excel Ch. 5 - o FV Just like PV enter as a negative number...

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