Mortgage Calculator

How to create an Amortization table in EXCEL (Speedy and effortless) Much less than 5 minutes





Hello Men,

This movie will clearly show you how to create an amortization table in excel is much less than 5 minutes
🙂

You should subscribe and view all our tutorials

www.i-despise-math.com

35 comments

  1. instead of my teacher actually teaching us she used this video 🙂

    Reply
  2. good job

    Reply
  3. Hi Venessa Graulich,

    I have a doubt, that how you got "$" symbol immediately after you wrote 100000 in C1 cell in excel and also decimal? Please help.

    Reply
  4. You re a life saver!!!

    Reply
  5. Thank you vanessa

    Reply
  6. Good, clear tutorial…and your beautiful accent makes it all so much less onerous.

    Reply
  7. What about when you wanna add more money to the principal how would u do it?!

    Reply
  8. Many many thanks

    Reply
  9. Go fuck yourself! All it did was copy row 2 all the way down.

    Reply
  10. How does it work that when you copy down, the table is rendered. I copied and dragged down, and nothing happened. Do I need to click something?

    Reply
  11. Great video, thanks! Really enjoyed listening to you!

    Reply
  12. This is amazing. Thanks for sharing.

    Reply
  13. Lady, you are a gift from the heavens. Thank you for basically doing my math project. You are the one who deserves this A, not me.

    Reply
  14. Thanks so much for putting this together! Explained things so well and made it simple and easy to understand!

    Reply
  15. Thanks alot for this tutorial! Save me lots of trouble for my assignment!

    Reply
  16. how would i set it up so that it will have an annual payment for 10 years? I want to keep it yearly and not multiple to have it monthly. (Ex. 12/31/16, 12/31/17…etc.) Does excel let you do it yearly?

    Reply
  17. hey that was really lovely and interesting. Thanks for sharing. Luv the presentation.

    Reply
  18. TQ SISTER

    Reply
  19. This is SO helpful. Thank you!

    Reply
  20. Thank u Vanessa. That was the simplest n easiest

    Reply
  21. This video saved me

    Reply
  22. Thank you, this was great and easy to follow, now I can keep track of my loans 🙂

    Reply
  23. What if its by years? do i still do 360 as periods or something else?

    Reply
  24. thanks for the video! it help my assignment a lot

    Reply
  25. this was really helpful for me… thanks a lot..

    Reply
  26. thank u so much..made my math project WAAYYY easier!

    Reply
  27. can you pls give me your number or other personal contact where i can msg to you and take some doubts

    Reply
  28. Is there a way to add extra principal payments in an amortization schedule?? I always pay extra and was wondering how to add that extra payment in. Thank you!!

    Reply
  29. Thank you very much. This video helped me fix the errors I was having while trying to lock my calculations and continue them down to the 360th payment.

    Reply
  30. You are awesome. You made it so easy. I was done with my assignment in 10 minutes.

    Reply
  31. Thank you. This was very helpful!

    Reply
  32. Thank you. Very simple. Very accurate and well-instructed.

    Reply
  33. Thank you so much! I used mine to calculate bi-weekly payments, but your instructions were so clear that I did it correctly on the first try!

    Reply
  34. Awesome stuff!

    Thanks for taking the time out and showing it on Excel. I usually work out loan repayments on a HP 12C … sadly you never get to see how the principle and interest decreases over time on a calculator.

    Therefore in Excel who can the remaining amount to pay at select periods (months).

    Thanks

    Reply
  35. screw liam campbell

    Reply

Leave a Reply