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 This Series 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
Duration : 0:10:36
Comments
About Author
ExcelIsFun April 28th
Dear bennyasif,
…
Dear bennyasif,
Cheers!!!
–ExcelIsFun
bennyasif April 28th
This is pretty good …
This is pretty good cheers
ExcelIsFun April 28th
Dear manixxxo,
…
Dear manixxxo,
EXCELlent!!!!
–ExcelIsFun
manixxxo April 28th
Gee, excelisfun, I …
Gee, excelisfun, I wish all teachers were as fun as you are!
CONGRATULATIONS! You make learning FUNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN! L0L
ExcelIsFun April 28th
Dear mindor100,
…
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
mindor100 April 28th
Question ? If I …
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.
Add Yours
YOU