Excel Finance Trick #2: Simple & Compound Interest

See how to use the FV function. See the math formula for calculating Future Value and for calculating the effective interest rate. Also see long hand how compound interest is calculated. See that Excel only sees 15 significant digits in Excel. Learn that Excel 2007 has 100 Undo, whereas Excel 2003 only had 16. In ThisSeries learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!! The Excel Finance Tricks 1-17 will show an assortment of Excel Financing Tricks! Formula

Related posts:

  1. Excel Finance Trick #1: FV PV & Time Value Of Money
  2. How Does Compound Interest Work? [Infographic]
  3. A Path To Financial Freedom: Personal Finance Blogger Picks
  4. Personal Finance 101: How to Graduate From College Debt-Free
  5. Inner City Kids Learn Personal Finance

Tags: , , , , , , , , , , , ,

6 comments

  1. Question ? If I purchase a home that is 150,000 and the interest is 5.5 how is that calculated of a period of 30 years?
    PS I know nothing about amortization, interest and home buying.

  2. Dear mindor100,

    I am not sure what your question is, but I have two videos that show you an amortization table. Check these out:

    Excel Magic Trick #43: PMT & Amortization Table
    and
    Excel Finance Trick #17: Amortization Table w x Column

    –ExcelIsFun

  3. Gee, excelisfun, I wish all teachers were as fun as you are!

    CONGRATULATIONS! You make learning FUNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN! L0L

  4. Dear manixxxo,

    EXCELlent!!!!

    –ExcelIsFun

  5. This is pretty good cheers

  6. Dear bennyasif,

    Cheers!!!

    –ExcelIsFun

Leave a comment



close Variations of: 'excel finance trick 2 simple compound interest'