How to make a Loan Amortization Table with Extra Payments in Excel

Start a Print On Demand Etsy Store with Printful:

Looking to make money as a freelancer? Sign up and use Fiverr:

Standing Desk:

Book that changed my life:

Great book on business:

Royalty Free Music:

Learn how to create a loan amortization table with an added extra payments feature in Excel. Learn how much interest and principle you will pay each month on a loan. All you need to know is the loan amount, interest rate, and length of the loan. Excel will do all the calculations for you.

Learn how adding extra payments to your monthly loan payments will save you lots of money in the long run. Easy to follow and understand.

Disclaimer & Full Disclosure: We are a a participant in the Amazon Associates Program, So If you purchase something from our affiliate links will get a small commission with no extra cost to you. This makes it possible for us to keep producing VIDEOS!
°We NEVER collect, store, use, or have access to any data about you.

[amystenquist]

Oh my gosh. This was so great it let me teach my wife how we need to pay off my house payment. This was amazing and everyone really needs to watch this.

[scottdunn]

Took me a while to figure out how to lock formula values for dragging the cell contents (hint: select value in the formula bar, then hit F4), but this was very helpful. I hope creating this has been profitable for you. -Cheers.

[daniels]

Great video. My wife and I bought our first home, and now we have full transparency over our mortgage!! Thank you!!

[soebvadnagerwala]

Wow, thanks a lot. I am here after wasting 3 hours on internet. This exactly what I have been looking for. Have great time.

[victoriajackson]

Nevermind, I saw your suggestions in the comments. Thanks. This is so helpful

[Gasly]

I was thinking what went wrong with my model turning negative when having prepayments. Your explanation was right on point! Thanks for sharing!

[luisgarrido]

I was looking at some tutorial videos on how to create a Loan Amortization Table, and I found this is the best one! Thank you Calon

[jacobsanders]

Best amortization schedule video on YouTube that I’ve seen, watched so many. This was simple and easy thanks!

[ItsOkayToBeHappy]

This was super helpful! I followed along and made my own table with you using my own data. Compared it with a word template version & all the math checks out! Difference is this table is superior because I can add in varying extra payments whenever I want! This is an important tool for me. Thanks so much!

[mushrafaltaf]

This video was so good that I was expecting at least a million subscribers on this channel. This channel needs to be shared!

[fullcircle]

Thank you very much for posting this tutorial. I am always hesitant to download "free templates" and being moderately savvy with Excel, this allowed me to build my own and manipulate it accordingly. Very Helpful!!

[khalidisin]

i have gone through multiple videos no one teachs it so good and so simple, simply awesome. Good Job man, Thanks a lot for sharing.

[jeffiepike]

this is the most awesome thing I've ever seen. My life now complete. Thank you.

[aliciamaldonado]

Exactly what I was looking for. Thank you!! I hope you are still making videos like this, it was perfect. Wish you the best

[bcarpenter]

This was legit! I was looking for something like this and being able to keep track at home in an Excel spreadsheet. Appreciate you man

[BalamanikandanThangavelu]

very useful content, after spending lots of time in google and other articles finally I landed here and now I am clear with the concept and calculation. You explained it great, thanks much!

[sonya]

Thanks for this. I asked my car loan folks or I could pay off my loan quicker so that I don’t have a note when I do go for a house and they weren’t helpful but this is helpful!

[seluinitaufa]

Thank you so much for this video, really helped me plan around putting extra payments onto my current loan.

[robertlacasse]

Thank you very much for this fantastic video. You make it seem so easy and simple, now I just need to go step by step and make my own. I have seen other schedules like this without the extra payment and today I finally found yours and once I get started I can finally do what I have been thinking about for quite some time.

[jaredhicks]

I checked this against my mortgage calculator online and its matches!