# Excel 2007-2010 Amortization Tables (Financial loan Amounts You Spend Every Month).mov

This video deomonstrates Microsoft Excel’s potential to easliy create an amortization desk based mostly on a common mortgage. I use a residence mortgage to create the desk and reiterate its worth by raising the payment to see how quite a few years a eradicated from the backend of the mortgage.

2. A-mazing, Thank u for sharing.

3. This demo is quite useful. However, spelling mistake has been found that principle will be changed to principal.

4. Truly straight forward, helped me a lot. Thank you.

5. Can someone help? everytime I put my rate I I get the #value even when my percentage has been formatted correctly.

6. Thanks, video helped me on an Accounting project.

7. At 1:40 you say if you're making 2 payments a year you divide it by 6. Is that an error, wouldn't it be 2 since there are 2 payments?

8. Thank you so much!!!!! This was sooooooo helpful!!!

10. shouldn't you be using the EAR not the APR???

11. I am telling you that your explanation is HEAVEN SENT……!

12. I can't get my Excel to auto fill.  I checked the settings, and it is set to auto fill.  What am I doing wrong?

13. Concise and clear. Thanks!

14. (Yearly interest rate)/12 only provides a rough estimation of the monthly rate. To convert from yearly interest rate, y, to monthly interest rate, m, solve
y = (1+m)^12 -1 or m = (y+1)^(1/12)-1

15. Thank you soooo much it was so clear

16. Thank you so much, sir, this video helped me prepare for my competition.

17. wowow really interesting stuff thanks a lot

18. Very clear and concise. Tutorial is well paced as well.

19. thanks ,

20. Needed to do an Excel assignment for one of my Finance courses and this helped tremendously. Thanks so much. God bless.

21. Thank you so much for this video, it gave me the perfect clear understanding about how banks are charging us when we take our loans.

Great Job !

22. hello the interest rate for a month is not divided /12, you should use this formula
Monthly rate = (1 + annual rate)(1/12) – 1, please correct

23. Seriously, I cannot even begin to explain how grateful I am that you decided to make this video. My teacher didn't explain this 1/10 as well as you did! I thought I was dead in the water but thanks to you, I can now turn in my assignment tomorrow and thoroughly understand how to do this!

24. what school do you go to? just did the same thing haha.

25. Thanks for this video!!! You have made Chapter 2 in my Excel book a lil easier! I wasn't getting it, but only one look at your video, and I got it down pat!

26. Hi Eric, This video is great; I went through all the directions step by step twice and the same thing happened each time. I got to the part of filling in the cells and the formulas showed the changes however the numbers stayed the same as the first line all the way to 60 months. What did not change was the interest did not go down and subsequently none of the other numbers changed. Yet … the formula show the cell change for the beginning balance. Help! What did I do wrong? Thanks 🙂

27. thanks a lot…………………………….

28. how do you get the numbers down the side in the month column without typing them all out? im trying to get 1-360 so obviously i cannot individually type them out or ill be there forever

29. Thanks for the comment. I have been asked when you might use this and that is simple. Just last week I started to get quotes to refi my own home. I used it to compare the offers I have and the fees I will be charged. I ended up saving just under \$100,000 with a refi. That is worth while.

31. This is awesome!! U demonstrated somethin complicated in a simple way.. million thanks..

32. Thanks for the video. I'm taking a finance class right now and you explained it better than my professor.

33. what if the amount of times you pay the loan in a year is not listed in the problem?

34. You are welcome

35. High definition is the best. Especially when doing software demos

36. Great glad I could help

37. Property taxes, PMI, etc. are normally not part of the actually loan but are managed in an escrow account so that the bank is sure that costs for insurance, property taxes, etc. are paid so that liens are not brought for on the property. These taxes will vary even year to year.

38. You are most welcome