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

Info icon This 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)
Image of page 1

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

View Full Document Right Arrow Icon
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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern