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

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

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

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

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

5. Excellent vid! Thank you so much!

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!

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

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

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?

10. You are welcome!

11. @ExcelIsFun thanks !!!!

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…

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…

14. Your question is not clear.

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

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)