Mortgage Calculator

Excel Magic Trick 515: Amortization Desk Pay out Off Early & Issues Shoot Formulation Generation





See how to build an amortization desk that will update when you pay out excess principal so that personal loan is compensated off early. See how to make variations to a template, get into difficulty, then difficulty shoot your way out of it so that you can correct the template. See how to Issues Shoot Formulation Generation.

19 comments

  1. You Transfer information like a well trained karate instructor!!! Ous Sensei!!! Thank You!!! Humble Bow.

    Reply
  2. Love It!!! Better than Netflix!!!

    Reply
  3. I'm having trouble finding the link to this workbook on your site. Can you help?

    Reply
  4. Can you just email this formatted table and let me pay you for your skills?

    Reply
  5. Excellent vid! Thank you so much!

    Reply
  6. Thanks! This video was very helpful.  To add on, how do you update the "years" and "total periods" cells when you made extra payments so that I don't have to scroll down to see the new mature date? Thanks in advance!

    Reply
  7. Thank you so much! This will definitely help me to pay off my mortgage a lot sooner.

    Reply
  8. Thanks dude! I am just bad at math, not very bad with excel. This showed me everything i needed to know!!!

    Reply
  9. Thank you for all your videos.

    How can I create an amortization schedule to compare pay off times and interest savings by making payments on a bi weekly basis rather than monthly basis?

    Reply
  10. You are welcome!

    Reply
  11. @ExcelIsFun thanks !!!!

    Reply
  12. If you wnat to learn more about cell references, search for "Excel Mixed Cell References" and you will see i have many videos on this topic…

    Reply
  13. @ExcelIsFun because sir i noticed that when you are typing the formulas. instead of D1 but D$1
    and i dont get it…..i dont know how to make formula in excel
    but happily i am the one who got the highest score among my classmates in ammortizations. haha. but i am still a first year commerce student.it is still basic…

    Reply
  14. Your question is not clear.

    Reply
  15. IS THAT A DOLLAR SIGN?? PLEASE TELL ME

    Reply
  16. Try asking Excel questions at the best Excel question site around:

    mrexcel[dot]com/forum

    It is easier to post Excel solutions at this site (YouTube Comments don't allow us to do much)

    Reply
  17. You are welcome!!

    Reply
  18. Thank you very much!

    Reply
  19. Thanks!

    Reply

Leave a Reply