How To Create an Amortization Table In Excel

This finance video tutorial explains how to create an amortization table in excel. This schedule shows the beginning balance, monthly payment, monthly interest, and ending balance of a mortgage with a specified principal, loan term, and annual interest rate.

Excel Tutorial For Beginners:

Top 30 Excel Tips & Shortcuts:

_________________________________________
How To Calculate The Total Hours Worked:

How To Make a Time-Sheet In Excel:

How To Calculate Loan Payments In Excel:

How To Create an Amortization Table:

Excel - Business Account Ledger:

______________________________________
Relative & Absolute Cell References:

Lock Cells and Protect Sheets In Excel:

Excel Interactive Checklist:

Excel Pivot Tables:

______________________________________
YouTube Channel Growth Accelerator:

Algebra For Beginners:

Final Exams and Video Playlists:

Full-Length Math & Science Videos:

[sarahvincent]

You got me through calc and physics and now you are about to help me figure out how to pay these student loans, best YouTube channel ever!

[manavpatel]

This dude absoltely knows what he's talking about. Clear step by step directions, along with explanations. Would not have been able to complete my project without him. Thank you so much

[soumikkarmakar]

Please make a video on How to make Nuclear bomb at home.

[caitlinhatch]

I don't generally comment on videos, but this was so clear, so easy to follow and so helpful I had to comment. Thanks for taking the time to do this. Using the PPMT and IPMT values was driving me crazy. And I needed refreshing about keeping some cells constant! Huge help and much appreciated.

[forward]

This is one of the best instructional videos I’ve ever seen. I feel like some kind of Excel wizard but I just followed along with the video — the Tutor tells you what formula to type and cell numbers to input! Genius level teaching. Thank you so much !

[johnnyentertainment-emlo]

I have a personal loan and never stood how and why I should be paying $37, 000 for a $25, 000 loan. I never understood how people knew that a 13.74% interest rate was too high than a 6% interest rate. Well this table and obviously your video have helped me understand how illeterate I was. My university education was nothing but non-sense! Thank you and well-done!

[SilkytheSamuraiNinja]

You have got to be one of the best teachers, not just on YouTube, but also in person. Your tutorials have helped me in so many subjects - quantitative methods, statistics, algebra, calculus, and now Excel!! You're earned my like and subscribe. Thank you and keep up the great work!!!

[tankberserkererer]

Wow, just shows how interest really adds up when the principal is high. Best to bring that principal down as fast as possible.

[helend]

Wish I knew you because I'd give you a big hug for this post. I was asked to create one for a loan my husband took from a friend for his donut shop. Mind you, I'm a former chemist who now does the books for him and had NO IDEA where to start. I worked along side your video and not only is it done, I understand it, which is even better. Huge huge thanks.

[jimmycarlucci]

Nice video, it really helped me. I used this template and added an "additional payments" column as well, which I noticed others did in the comments. I think most people interested in this kind of information are also interested in how beneficial some additional payments can be, even if they are small. Thanks again!

[kiggins]

From an excel novice, thank you for the clarity and conciseness of this very helpful instructional video. Well done!

[veedadixon]

I haven't used excel in a while and this was really a big help, keeping my cells constant. Thanks for the tutorial.

[amzarhalil]

I always wondering who are you. You’re so kind, everything you teach really help me out from any curiosity. Thanks a lot for your videos. Btw, it’s a pleasure if I can know you 😁.

[blakeyuckert]

If the rate per annum is 5%, then the monthly rate is not 5%/12. Interest that accrues on an annual basis does not equal interest that accrues on a monthly basis, because there is more time for the monthly accrued interest to compound.

[gennelhicks]

I must say a big thank you, you just made my life easier with calculating my loan interest and repayment...lots of luv from🇬🇾🤗

[ezequielarce]

Hands down, first time doing this and I managed it. Thanks you

[bobosputnik]

I'm impressed and thankful. Explained clearly and simply. Well done!

[evettelewis]

I learned how to do this by hand in math class a looong time ago but this video is awesome and super easy to follow! Thanks

[monicahathaway]

Amazing!! So easy to follow !!! I did it for my mortgage, car payment, etc! and even included a line for 'extra' payments. Thank you!!!

[cortezcharles]

This is the best Video on the internet it is slow enough to follow along and simple, You did a GREAT Job!