Mortgage Calculator

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.

42 comments

  1. thanks for your class, was very helpful

    Reply
  2. A-mazing, Thank u for sharing.

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

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

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

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

    Reply
  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?

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

    Reply
  9. Thanks eric. very helpful

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

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

    Reply
  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?

    Reply
  13. Concise and clear. Thanks!

    Reply
  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

    Reply
  15. Thank you soooo much it was so clear

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

    Reply
  17. wowow really interesting stuff thanks a lot

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

    Reply
  19. thanks ,

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

    Reply
  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 !

    Reply
  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

    Reply
  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!

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

    Reply
  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!

    Reply
  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 🙂

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

    Reply
  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

    Reply
  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.

    Reply
  30. You've probably saved the youtubeverse thousands of hours already.

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

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

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

    Reply
  34. You are welcome

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

    Reply
  36. Great glad I could help

    Reply
  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.

    Reply
  38. You are most welcome

    Reply
  39. excellent.

    Reply
  40. Thank you! Are property taxes included in monthly payments (probably not)? Do property taxes tend to rise over the years, and by how much? Also, not sure about the concept of refinancing, does that occur when you pay sooner than the 15 or 30 yrs?

    Reply
  41. You saved my life…not literally but I had an assignment and could not figure out what I was doing wrong. I would not get a zero at the end of the payment plan. I got a $0.09. I redid all the steps acc. to ur video and voila!

    Reply
  42. This is a very clear explanation. Thank you kindly.

    Reply

Leave a Reply