Manage Loans with an Amortization Table in Excel – Part 1

Pin It

Create a mortgage (loan) payment calculator with an amortization table (payment schedule) for detailed payment information.

12 Comments For This Post

  1. 1381381 Says:

    thumbs up – good explanation!

  2. pbirmingham1988 Says:

    I love you

  3. aleciadanielle20 Says:

    This was very helpful appreciate it!

  4. WuTang011 Says:

    You are my hero when it comes to my late night home work! Thanks so much for posting this video up.

  5. UncleTaxi1 Says:


    use the goal seek function under the “What if analysis”

  6. makeuptherapy101 Says:

    If I was interested in getting a loan and I didn’t want to make a payment that high. Let’s just say I wanted to pay about 700 per month. how can I determine how much my down payment would have to be.

  7. kimballfamilybudget Says:

    Well done. I am a fellow educator and was curious how you got your audio to be so good. What type of mike or audio capture set up do you use?

  8. joeyhcmc Says:

    It’s not perfect…9:50 Beginning and ending balances are negative since you have extra payment of 100*360 = 36,000…Interest is also negative.

  9. roses999us Says:

    very clear, thanks!

  10. wuttinup Says:

    THANK YOU!!!

  11. jimbob0005 Says:

    This was absolutely amazing. This video kept me from sitting through an hour class in just 10 minutes. Thank you so much for the videos…I’ve watched more than one!!!

  12. Vajaia Says:

    Thank you soooooooooooooooooooo muchhhhhhhhhhhhhhhhhhh. You are amazing. I just survived writing the whole amortization table by hand.

Leave a Reply