How To Create an Amortization Table In Excel

Подписаться 8 млн

Просмотров 454 тыс.

50% 1

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:
• Excel Tutorial For Beg...
Top 30 Excel Tips & Shortcuts:
• Top 30 Excel 2016 Tips...
_________________________________________
How To Calculate The Total Hours Worked:
• How To Calculate The T...
How To Make a Time-Sheet In Excel:
• How To Make a Simple T...
How To Calculate Loan Payments In Excel:
• How To Calculate Loan ...
How To Create an Amortization Table:
• How To Create an Amort...
Excel - Business Account Ledger:
• Business Account Ledge...
______________________________________
Relative & Absolute Cell References:
• How To Use Relative & ...
Lock Cells and Protect Sheets In Excel:
• How To Lock Individual...
Excel Interactive Checklist:
• Interactive Checklist ...
Excel Pivot Tables:
• Intro to Pivot Tables,...
______________________________________
RU-vid Channel Growth Accelerator:
/ youtubechannelgrowthac...
Algebra For Beginners:
www.video-tutor.net/algebra-f...
Final Exams and Video Playlists:
www.video-tutor.net/
Full-Length Math & Science Videos:
/ collections

Опубликовано:

1 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 193

@TheOrganicChemistryTutor 5 месяцев назад

Final Exams and Video Playlists: www.video-tutor.net/

@sarahvincent6144 4 года назад

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

@cardinality1975 3 года назад

Truer words never been spoken lol. This guy is awesome!

@soumikkarmakar553 4 года назад

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

@michaeltherandomperson9652 4 года назад

Then North Korea greatest opponent is going to be this tutor nice.

@manavpatel4343 2 года назад

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

@caitlinhatch6485 2 года назад

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.

@forward989 Год назад

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 !

@bobosputnik 3 года назад

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

@SilkytheSamuraiNinja 9 месяцев назад

You have got to be one of the best teachers, not just on RU-vid, 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!!!

@helend6774 2 года назад

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.

@kiggins 10 месяцев назад

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

@johnnyentertainment-em8lo 8 месяцев назад

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!

@veedadixon3749 Год назад

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

@cortezcharles3605 3 года назад

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

@gennelhicks9793 2 года назад

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

@jimmycarlucci727 Год назад

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!

@jimmycarlucci727 Год назад

To clarify for those interested, add one more column below "mortgage payment" in D4. I titled this "additional payments"... next make the Ending Balance formula "=C7-F7-$D$4"... you will have to also modify the "Payment" formula to "=$D$3+$D$4"...hope this helps.

@tankberserkererer 4 года назад

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

@bnyx14 4 года назад

what are you talking about lmfao

@timothy8292 3 года назад

lmao, ever heard of leverage?

@mariahs1123 Год назад

This is awesome! Though, if you have an escrow account, you have to add that to your payment for each month, and I added a column for extra payment toward my principal. Thank you for making a baseline product for us all!

@theMitsos95 2 года назад

Dude you explained it so good. One of the best tutorial videos ive ever watched. Gongrats really. You have a gift

@yan_afrukh 4 года назад

This guy is a full living school

@Claybone12 4 года назад

Yes

@evettelewis3096 Год назад

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

@ezequielarce8079 5 месяцев назад

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

@amzarhalil8563 4 года назад

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

@AlphaDavid66 3 года назад

lets smoke a blunt with him

@bangtangirl4210 2 года назад

An ordinary human bean

@dudebro5423 2 года назад

Thank you for doing this video, it made understanding an assignment so much more clear!

@RebeccaWells-ds7ix 6 месяцев назад

Thank you for doing this video! Very well presented. Keep up the great work!

@harveyadams9745 2 года назад

This channel is complete😘 everything you need is here...

@JoseRomero-xd2rd 2 года назад

Great video. Each step is explained well and easy to follow along. Thank you

@monicahathaway 8 месяцев назад

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

@j.scottjackson5198 2 года назад

Enormously clear and very helpful. Thank you!

@2023Red 2 года назад

You did an excellent job in demonstrating the schedule. Thanks.

@user-sm1fh1iy4p 9 месяцев назад

THANK YOU SOOOOOO MUCH BUD. I knew the annuities concept. Fusing that and this. It's just paradise now.

@aliftasnim9353 3 года назад

bless you mate, I hope you live a happy life

@wolfemata1458 2 года назад

HA!!! I Appreciate this video & the awesome person or team who created it. I can now make an amortization for a vehicle & a mortgage.

@crispiii_ 2 года назад

This guy is a G, much respect for the video, super helpful 🤙🏽

@xochitldiaz695 Год назад

Really great tutorial, I’m about to make this amortization schedule 😊

@trishapaytas4330 Год назад

You literally saved me from this math assignment!!!!! I love you😩😩😩😩🕺🏾🕺🏾🕺🏾

@ADRiley1 2 года назад

DUUUUDE! THIS IS SO PERFECTLY SIMPLE AND TERRIFIC! thank you!!!

@JCWusmc Год назад

THIS was awesome. Thank you for making this video!

@GOGOSLIFE 11 месяцев назад

The only issue I see is that interest rates vary each time you renew your mortgage, so it could mean you're paying more, or less than the original amount. You made it absolutely clear to people who have never done any accounting or bookkeeping, how to use Excel. I love playing around with Excel. It's cool to see how you can play with numbers. I have sheets I've set up for my income taxes, and it makes everything so much easier. I guess you could call me a nerd, lol!

@MikeAyye 3 года назад

you just saved me on my finance project, for that sir, i shall give you a like and a subscribe!!

@GODulMarie Год назад

Thank you and I hope everyone tells you how much you helped them.

@malondahutson9997 2 года назад

This is a GREAT video. Really helped me. Thanks for doing a great job.

@ardoppa Год назад

The explanations in detail are highly appreciated. Thank sir...

@cj-6268 Год назад

this is amazing! don't normally comment on videos but this helped me alot! i also added an over payment cell at the top to mine. 👍

@cartermefford3324 4 месяца назад

god bless you sir. my TA explained how to do this in a way that nobody could understand. youtube teachers win once again

@addiszoom6584 2 года назад

Explain simply and clearly. Thank you

@aylarogers1021 9 месяцев назад

Fantastic, thank you so much! Very clear directions.

@floydmusicandnature8538 2 месяца назад

Thank you so much. it helps me a lot about loan and financial literacy

@lifeisball1170 3 года назад

Best out there, for literally everything . No B.S

@practicallythu 11 месяцев назад

Super helpful and easy to follow along. Thank you!

@amengetagetachew4623 2 года назад

tnx men, u should get the teaching version Oscar, much appreciated

@Sulieti_Vaomotou Месяц назад

really appreciated.... so simple and sweet... u help us a lot ....thanks for the sharing...🙏🙏

@sophiacruz2673 2 года назад

YOU'RE A LIFE SAVEEEERRR. THANK YOU SOOO MUCH FOR THIS🤗🤗

@sheanacooley3075 2 года назад

Such a life saver. Thank you, thank you, thank you ☺️

@leonidaskesaris4206 6 месяцев назад

This explained the amortization schedule better than my accursed 200 dollar textbook. Thank you

@susanandersen9691 2 года назад

This was a great tutorial - thank you so much!

@miguelcruz-er6uz Год назад

GREAT TUTOR ,JUST FINISHED MIND

@sondraluxe1227 9 месяцев назад

Thanks- you made this so easy to understand!

@bossmanettv6503 Год назад

You are a legend for this, literally helped me with my homeworks

@susanblock3961 2 года назад

Thanks it was exactly what i was looking for. Very easy to understand and follow. I have a question. What if I get a payment dedicated to reducing the principal? How does that fit in to this equation? Thanks!

@offiongokon6901 8 месяцев назад

I really want to say thank you for this. It helped me a great deal. I have liked and subscribed. Simple and enjoyable to follow through.

@bizmane Год назад

Great video, very helpful. Thanks!

@user-ek1lx4kv7m Год назад

Excellent in everyway. Thank you.

@nickfaraone3823 Год назад

Thank you for posting. Very well done.

@glenfernandes5248 2 года назад

This was very helpful, thank you!

@aliso-pv7ll 4 года назад

JG, Thanks for this informative important video. Would consider making a video adding to this information, but an additional payment is made later in the month to lower the principal. How is interest and balance calculated?

@dracosapple2584 2 года назад

You saved my life, my father will hear about this!

@akashchaudhuri1403 Месяц назад

very helpful, thank you!!👏

@cheesewagonchic Месяц назад

You are the BEST!!!

@gautamdhillon7675 9 месяцев назад

This was so helpful - thank you!

@foxtrot4597 2 года назад

Excellent!!! Great teacher!!!!

@AprilYChang 9 месяцев назад

Excellent presentation, thanks!

@derrickmutugi2010 3 года назад

YOU ARE LITERALLY THE GOAT

@armedforcepestcontroloffic3161 3 года назад

Very helpful, thank you!

@rebrown 2 года назад

This was incredibly helpful and easy to follow! Thank you!!

@user-vl5ql4un9f Год назад

Clear, easy to follow.

@subhibhashanee8884 7 месяцев назад

Very well explained 👍🏾

@kayvonmansouri 3 месяца назад

super helpful thank you

@Auntie-echo 4 месяца назад

THANK YOU!

@tracyworden3688 2 года назад

So so so good! Thanks so much!!!

@Cris-hk4cn 2 года назад

Exceptional presentation!!!!

@lot2many 3 года назад

Thanks for this man.

@Productivitysheets Год назад

Really helpful, thank you!

@dtjones928 2 месяца назад

Excellent video: unhurried, patient voice, good explanations, and thorough. Now that you have helped me create a basic amortization schedule, can you direct me to instructions for additional principal payments as well as a bi-weekly schedule?

@ldeskins1 2 года назад

Thanks ….. very helpful!

@jarrotbell9757 5 месяцев назад

Thank you!

@maz1368 9 месяцев назад

Awesome video Helped so much👏

@wifinancials 10 месяцев назад

nice video- best one yet

@rocklobster2929 3 года назад

Super helpful bro!

@SOIL_Incorporated 2 года назад

Well done! Thanks!

@MichaelSalguero 2 года назад

Congrats on being the first google result when I search, "how to make an amortization schedule in excel" Let's say that again for the great algorithm in the sky: "how to make an amortization schedule in excel" One one more time for good measure and SEO: "how to make an amortization schedule in excel" Good job

@guyfromgantz7976 4 года назад

So 360 months/30 years to pay off a mortgage of 300k at a monthly payment of 1,600 ish, and by doing this table you can keep track of your own mortgage, cool thx for the info 👍