Main Profile

At A Glance

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

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!
Length: 09:13

Contact

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

Want more info about Finance Basics 10 - Present Value Calculation With Intra Year Compounding of Interest in Excel? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question