Finance Basics 2 - Compound Interest in Excel



Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. This Excel Video Tutorial shows you how to calculate the future value of an investment with compounded interest. You will learn how to do this by hand in Excel and also how to use the mathematical formula for compounding interest in Excel. This two methods will equip you with the skills necessary to compute compound interest payments and total value for any given period of time and all within Excel. 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!

Comments

  1. Thanks for your helpful videos! Just one remark, at 4:50 you say that Excel don't provide a function for calculating compound interest. However, you can use the FV function for that. For example, FV(0.05, 3, 0, -100). In this case it is important to put 0 for pmt parameter (since you don't have additional payments in this case, just a present value).
  2. These videos are so helpful! I'm in a corporate finance class for my MBA, and you're helping me make sense of my homework. Thanks! :)
  3. or just use =FVSCHEDULE
  4. Hi, I'm trying to use your formula for a financial spreadsheet but how do I account for regular reinvested income?
  5. =3200*(1+0.4)^10 ?
  6. what if its SEMI ANNUALLY FOR 5 YEARS??? this is where i get confused.. is it
    =3200*(1+4%)^10 ??
  7. Thanks alot for this video. If i was to do a daily interest ( lets say for 90 days) would i just let N=90?
  8. thanks man...needed that...now i understand...
  9. Thank you so much for posting. Good presentation, good delivery and very thoughtful. Shokran!
  10. ohh yes i love this sexy shit awwwwwww yeah


Additional Information:

Visibility: 57936

Duration: 5m 48s

Rating: 85