Compound Interest

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

This Excel Video Tutorial shows you how to calculate the present value of a security or investment which compounds interest at a rate more frequent than once per year. This is intra-year compounding.

You will learn how to change the present value function in Excel in order to account for compounding interest on a monthly basis, quarterly basis, and semi-annual basis. This is a great tutorial for anyone needing to learn about finance.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!