How to build an Amortization table in EXCEL (Fast and easy) Less than 5 minutes

[@lespetitsrugby3638]

Out of all the amortization videos ...yours was the EASIEST and the FASTEST !!! TY and its no wonder youre a smart woman

[@VanessaGraulich]

thanks so much :). Math is just that beautiful :)

[@gvagirlsavaayla5043]

I learned more in your 4 minutes video than my entire 3 months of finance class.

[@VanessaGraulich]

thanks so much for that :) You are the best

[@HopeElayne]

So true. Took me 3 hours to decipher my instructors excel instructions and I understood this in 5 minutes 🙄

[@jc6800]

2023 can confirm. 🎉😢

[@jc6800]

Frfr I've been trying for 3 hours. 😀

[@mj-wf2bw]

My thoughts exactly!

[@najmaharife9866]

This is a lifesaver, forever owe my life to this video

[@VanessaGraulich]

glad it helped you :)

[@janamuniz3163]

This was great. I mean, really great. Halfway through my eyes crossed, but that's the magic of youtube, I can keep watching and pausing until I've got it. Thank you very much for posting this!

[@Veraplays]

thanks so much :)

[@GoChaca]

You just turned an hour of frustration into a few minutes of peace. thank you

[@VanessaGraulich]

happy it helped you :)

[@glorycarla4592]

Same here

[@marklama6435]

This year I need to teach this, and your video helped me get a grasp on it more than all the formulas. Once I understood the recursion relation, I could reverse engineer the math to derive the standard formula for monthly payment. I don't think I'll make my high schoolers do that, but I might assign them the task of building this spreadsheet! Thank you for a great video!

[@spreadsheets4life13]

kzbin.info/www/bejne/poK3e5V7m5t9kJI

[@elainefrazier9686]

Thank you sooooo much! and you made it soooooo easy; now I can use this format on any loan.

[@shamsaqlain6130]

You make over life so simple. I did it right now for my house mortgage and I am feeling so confident that I am able to do complicated stuff in easy way Thanks to you!

[@svmplycozy5238]

So simple. I spent close to an hour trying to figure this out until I found your video. In literally 5 minutes you have helped me figure it out!

[@Veraplays]

happy to hear that :) VG

[@lifeasitis5150]

Thank you, you made it EXACTLY how I like videos, straight to the point and easy to follow. You are AMAZING!

[@TheElkster]

I've watched a few videos that tried to explain how to calculate monthly interest payments over a certain period and this is BY FAR the most efficient and fun video I've seen!!! Thank you! :)

[@sagarthakkar900]

Definitely helped me with my CPA studies too. Nothing is a better visual representation than the quantitative format of everything simplified into excel

[@mattseifert7538]

This was extremely helpful. The fact that you could lay this out in less then five minutes made the whole experience that much greater. Outstanding job!! Thank you.

[@VanessaGraulich]

thanks so much

[@VanessaGraulich]

YOu made my day VG

[@aliciaaleyo1178]

You have literally saved me from getting a 0% in my assignment. I have been doing this question the whole day and I was unable to figure it out until I watched this video. I have never been so grateful. Thank you so much.

[@sharai2011]

I have been struggling with this for over a week. Watched your video once, and now I finally understand it! Thank you so much!

[@ramonapikeur]

Thank you very much. I finally GOT IT! After starring for hours at my screen not knowing what I previously did wrong in my calculations. AWESOME!!!

[@hannahcollins7739]

You're an absolute lifesaver! Teacher didn't give us proper instructions and left us floundering. Thank You!!

[@VanessaGraulich]

I am happy you were able to enjoy it :)

[@lalkhanbuzdar4203]

Thanks, Mam, I solved a task by helping with your video.

[@VanessaGraulich]

nice :)

[@jeanmichel5252]

Hi Vanessa, many thanks from an old timer. I'm nearly 75 and managed so well to work out my pension, Great job!!!

[@VanessaGraulich]

you got this I am an too.

[@dancingkate0]

Thank you!!! Not only helpful for class, but your voice and accent are fun to listen to - not the normal boring voice that puts me to sleep!

[@VanessaGraulich]

Thanks so much :)

[@slicecuts21]

I had a project using this method and I really wish I found this early on and not the last hour of the due time. Thank you so much for this tutorial! I learned a bit of excel basics from this and helped me get the project done on time.

[@VanessaGraulich]

Very happy to hear that :). You got this . VG

[@paulaleaym8215]

This is perfect! I had a request for an amortization schedule and did not know how to create in Excel. Thank you!

[@VanessaGraulich]

you are welcome :) , happy you enjoyed the video

[@kadisyertovlog5689]

Clear and easy..thank u for your video it helps me a lot.

[@VanessaGraulich]

Very happy to hear that :) . VG

[@stoptellingmewhattowrite]

Thanks Salma Hayek! I didn't know you do Excel classes on your free time from movies!

[@alelumelelu7766]

You have earned my subscription! Thank you

[@VanessaGraulich]

I have a new channel Thanks so much :)

[@DVGNBVG]

Thank you, I keep coming back to this video and using it every time I have to make an amort table!!! So easy when you explain it!

[@jakewaggoner4196]

This is great! You can also find websites online that do this for you once you put in that initial information! I'm not sure if they allow you to download it however!

[@Veraplays]

Thanks so much for your comment :) . Vanessa Graulich

[@yanaalhebri8125]

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.

[@Veraplays]

You made my day :) . Vanessa Graulich

[@lezaimsaiah4574]

Hi Vanessa, I followed this step by step and it was perfect! Very simple instruction for first timers :) Love it!

[@lilbrunetteshopgurl437]

Mine is not calculating the numbers, what am I missing?

[@nikolajovanovski7481]

Thank you very much, don't hate maths as a personality kings

[@VanessaGraulich]

happy you like the video Vanessa Graulich

[@Bestmariofanever]

Thank you so much for your help! This is helping me so much!!!

[@kwell2307]

You sound just like someone I work with but you made this super simple and actually learned something about Excel I didn’t know

[@terrymm6488]

So quick and easy. You're a great teacher! Thank you! 🙏

[@01798aleem]

Best knowledge got from ur video Just awesome @excellent teaching method

[@augustinachukwuemeka9617]

Viola!!! I just finished my assignment by watching this Video. Thank you so much!!!!!!

[@VanessaGraulich]

very happy for that :)

[@melissacampbell7723]

This is amazing! Super easy instruction and literally saved me hours of frustration! Thank you SO MUCH!

[@VanessaGraulich]

Happy Melissa :) you were able to finish sooner your assigment

[@pbrown4]

grazie mille! i've been banging my head about this all day trying to figure out how the calculation actually works (not just a formula) in reality! finally with your table it all makes sense now!

[@VanessaGraulich]

thanks so much :)

[@Jakeeiband]

Excellent video...very well explained. Thank you!

[@damilareolutola6755]

Thank you - this is quite helpful and efficient

[@VanessaGraulich]

happy it helped you :) (VG)

[@mllrshea11]

I don't usually comment but this saved me a lot of time and was easy to follow. Thank you

[@Veraplays]

thanks for your comment :)

[@DekalbNIU2013]

That was the most coherent and easy to follow broken English I have ever heard!!! Nice job, very helpful.

[@aby1thomas]

Excellent....I can't thank you enough....this has been best 5 mins I spent on the net so far. Very simple and superb explanation.

[@katyaajao7021]

THANK YOUUUUUUUU I was really about to do this manually omg. thank you!

[@laurenceesposito3393]

Still works for me without a hitch. Thanks so much for this. Easy, easy, easy.

[@dancostantino6102]

THANK YOU for getting straight to the point and making this super simple! Still relevant 7 years ago!

[@Veraplays]

Thanks so much for your kind words . VG

[@ryanbloom69]

You are a life saver! Super fast, super simple, thank you for the guide! 🙂

[@samuelwoods7110]

Great tutorial, especially liked the =PMT formula! I can't believe I've been using the massively complicated annuity formula like a chump all this time. Thanks for the time saving!

[@VanessaGraulich]

happy you like it :)

[@manoj.baishya]

@@VanessaGraulich Instant subscriber. the net interest payment made me really cry (and my decision: not to buy a house)

[@renellesquivel9122]

I spend 3 hours doing this, then I suddenly browse and found your video 😭. Thank you very much ✨

[@VanessaGraulich]

very happy to hear that VG

[@silverjameshechanova5285]

This video solved my problem in manually computing the amortization schedule.. Thank you very much

[@juanvargas4875]

Thank you for the video!

[@johnmwaura8921]

Very educative. Thank you

[@rainesilk9791]

Excellent explanation. Thank you so much!

[@Zparjsn]

That is the most beautiful explanation........not dumbed down enough and concise.. thank you Mam only 4:33 was a little dooDO but OK

[@VanessaGraulich]

Thanks so much for your feedback

[@nayomiegh]

Hi guys! Welcome to I Hate Math Group! you are a gem

[@VanessaGraulich]

Naomi VG this is now my new channel

[@ethanlynskey1574]

This just saved my butt for an exam. Thank you!

[@sadiehodge9308]

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!

[@diannereyes3680]

Casi me muero cuando veo los intereses 😂 wow! Súper agradecida ❤ thank you!!!

[@Veraplays]

de nada :) . Vanessa Graulich

[@masonhigham7402]

THANK YOU THANK YOU THANK YOU!!!! You have helped me so very much and saved my uni grade!!!!!!!!!

[@timothy2336]

Wow! Best teaching on creating amortization schedules in Excel that I have seen. Thank you! Thank you!

[@VanessaGraulich]

YOu made my day :)

[@sheilahatim3783]

Finally got this !!!! THANK YOU

[@VanessaGraulich]

Thank you for your kind message VG

[@GG-rs5sm]

Thank you so so much, this helped alot in making me understand my assignment.

[@VanessaGraulich]

happy it helped you :)

[@jenncharles619]

You have no idea how much this just helped me. Thank you!

[@VanessaGraulich]

happy to hear that :)

[@tiffanyng4255]

thank u so much. Your cheery voice brightened up the depression I had facing Math:) And u made it so much easier !

[@rebecasuarez1931]

Thank you so much for making this short and sweet with a result!

[@jrvismanos9309]

In the middle of my online Real Estate class, and still trying to take it in how much money these lenders are making when the loan is paid off. Thank you for teaching us how to simplify this formula.

[@laxur1312]

Thank you! My students will thank you as well.

[@Veraplays]

thanks :) so much for that. Vanessa Graulich

[@ricardofogel671]

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.

[@Denise-zv4qm]

Thank you, you make this so easy

[@Kirpn10]

Girl you taught me everything in 5 min which my professor was not able to in a full month

[@KaiDraner1203]

Really helpful 🙌🙌🙌

[@poisiion]

I was exactly looking for this video. You explained it so accurately. Straight to the point no wasting time. Thank you. Liked & Sub'd your channel

[@Veraplays]

thanks so much :) . VG

[@juanosorno8153]

Great Video. I have always wanted to be able to do this table in Excel and, with your video, I easily did it. Thank you!!!!!

[@terrynash-ie9lz]

OUTSTANDING show. great job

[@StopForeclosureMortgage]

Ebrahime, yes, school is designed to take your money, it's a business. I took a class, paid a lot of money. they promised I would know how to build a website when the class was done. I didn't. You know what they told me? "you have to take the advanced class", that means more money for them and a waist of my time. I hired a college student for 10 bucks an hr. I learned more in the first three hrs with her than I did in the class. Three weeks later, I had all the basics and an understanding to build. I am an autodidact for the most part but we have teachers even so, just not in a classroom.

[@wllymchng]

very clear and simple, thank you

[@cdmcoleman]

OH MY GOD! You just saved me so much time with my finance project. THANK YOU!!

[@Veraplays]

:) happy for you

[@cc6832]

This is one of the best video explanations on KZbin!!! Thank you

[@lydiagarza7839]

This is GREAT, so helpful. Quick question I need to create this amortization for a mortgage personal loan, how do create it by adding any annual property tax? Appreciate your help

[@oluwafemiabiodun-n7f]

Your work Is amazing

[@danieldiaz4665]

Very Nice and Quick explanation..Gonna create my own when I buy my new car!

[@harrisonwines1562]

OMG! Helped complete our Finance Assignment! Now an I Hate Math Group Subscriber.

[@bobhyde547]

Big help and very quick. Thanks

[@ratracerescuepodcast]

That was terriic !! Thank you. Super easy to follow along. You just saved me a hundred hours of work :)

[@jasonmartin7137]

Great explanation! Many thanks.

[@VanessaGraulich]

You are welcome :)

[@leckmanj]

this is the best example of how to build a mortgage calculator in Excel that I've seen 👍

[@VanessaGraulich]

thanks :)

[@adamharper1943]

I can't "like" this video enough times! Thank you soooooo much!!

[@VanessaGraulich]

You are welcome :)

[@JayGarces]

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

[@VanessaGraulich]

thanks so much for your feedback

[@1hvzqz]

Excellent presentation thank you

[@VanessaGraulich]

thanks so much :)

[@bubthork1]

This helped me out. Thanks!

[@VanessaGraulich]

thanks :)

[@victormoreno803]

You are a genius !

[@VanessaGraulich]

Maybe I am just an amortization lover. Thanks for watching :) VG

[@amusaazeez4410]

Thanks for the lecture I so much enjoy it than others , from Nigeria Can you create prepaid expenses amortization schedule table like did for loan 12 month

[@VanessaGraulich]

ok, I now have a new channel and I will do it :)

[@HAMID___]

You made it sound so much easier than my teacher. Thanks a lot

[@amirawest9853]

Thank you! I was struggling for an hour, you're very clear and direct. I am following you for sure, thanks again.

[@Veraplays]

thanks so much

[@StopForeclosureMortgage]

you are a great teacher!

[@monicar2387]

Fantastic! Easiest instructions ever. Thanks!

[@stephenroberts2526]

Great tutorial to show how amortization tables work. But that interest rate really hurts!

[@VanessaGraulich]

lol, thanks for watching it :). Interest rates are now to the roof, hopefully never this high

[@saadrahim9582]

Dear Vanessa, A very good video for a beginner. Thank you very much. I really appreciate. Thanks once again!

[@spooler24]

This is GOLDD!! Thanks a bunch for sharing.. Not quite sure why anyone would dislike but umm... GREAT!!

[@aaronbanks3673]

Awesome video. Thank you for making it!

[@VanessaGraulich]

Thanks so much for watching

[@esan0715]

Amazing video. Millón de gracias

[@VanessaGraulich]

de nada :)

[@lasha4585]

Thank you so mcuh for this, it was very helpful and easy to follow! You have a new subscriber here! :-)))

[@dekass7965]

Not sure if you still do videos! but just know that you are the best and God's sent. amazing video and big fan! any video on quarterly amort table and let say changes in payments occur, like getting extra debt on top of the current facility. thanks a lot, been of great help

[@VanessaGraulich]

thanks for your feedback. I have a new channel now :)