Tuesday 24 November 2009

Finance Basics 10 - Present Value Calculation With Intra Year Compounding of Interest in Excel

Title:
Finance Basics 10 - Present Value Calculation With Intra Year Compounding of Interest in Excel


Video:


Description:Visit 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 There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!

Published:
25/Nov/2009

No comments:

Post a Comment