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 :)

[@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 :)

[@lifeasitis5150]

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

[@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.

[@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!

[@GoChaca]

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

[@VanessaGraulich]

happy it helped 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

[@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! :)

[@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 :)

[@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!

[@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!

[@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.

[@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

[@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

[@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!!!

[@augustinachukwuemeka9617]

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

[@VanessaGraulich]

very happy for that :)

[@terrymm6488]

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

[@lalkhanbuzdar4203]

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

[@VanessaGraulich]

nice :)

[@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

[@elainefrazier9686]

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

[@kateparker8546]

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 :)

[@DekalbNIU2013]

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

[@timothy2336]

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

[@VanessaGraulich]

YOu made my day :)

[@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 :)

[@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

[@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

[@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

[@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?

[@harrisonwines1562]

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

[@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

[@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 :)

[@sagarthakkar900]

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

[@laurenceesposito3393]

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

[@stoptellingmewhattowrite]

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

[@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

[@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.

[@masonhigham7402]

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

[@kadisyertovlog5689]

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

[@VanessaGraulich]

Very happy to hear that :) . VG

[@tiffanyng4255]

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

[@jenncharles619]

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

[@VanessaGraulich]

happy to hear that :)

[@01798aleem]

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

[@ryanbloom69]

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

[@spooler24]

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

[@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.

[@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)

[@cc6832]

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

[@cdmcoleman]

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

[@Veraplays]

:) happy for you

[@alelumelelu7766]

You have earned my subscription! Thank you

[@VanessaGraulich]

I have a new channel Thanks 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

[@ethanlynskey1574]

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

[@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

[@saadrahim9582]

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

[@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!!!!!

[@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

[@ratracerescuepodcast]

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

[@Jakeeiband]

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

[@silverjameshechanova5285]

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

[@juanvargas4875]

Thank you for the video!

[@bffpuspin7383]

Best video I have watched. Thank you very much.

[@katyaajao7021]

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

[@nayomiegh]

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

[@VanessaGraulich]

Naomi VG this is now my new channel

[@monicar2387]

Fantastic! Easiest instructions ever. Thanks!

[@adamharper1943]

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

[@VanessaGraulich]

You are welcome :)

[@rebecasuarez1931]

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

[@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!

[@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

[@sitimaisarah877]

i like the way u explained. really straight forward and easy to understand. thank you!!

[@diannereyes3680]

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

[@Veraplays]

de nada :) . Vanessa Graulich

[@leckmanj]

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

[@VanessaGraulich]

thanks :)

[@danieldiaz4665]

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

[@nikolajovanovski7481]

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

[@VanessaGraulich]

happy you like the video Vanessa Graulich

[@rainesilk9791]

Excellent explanation. Thank you so much!

[@sheilahatim3783]

Finally got this !!!! THANK YOU

[@VanessaGraulich]

Thank you for your kind message VG

[@titofishermoments]

This video saved me from a mental melt down☺ Thank you so much #liked#subscribed#keepupthegoodwork!

[@rickamday1]

Thank you. Very simple. Very accurate and well-instructed.

[@terrynash-ie9lz]

OUTSTANDING show. great job

[@oluwafemiabiodun-n7f]

Your work Is amazing

[@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

[@giannamadison7275]

Appreciate this video.... quick and easy! Thank you!

[@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

[@Bestmariofanever]

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

[@victormoreno803]

You are a genius !

[@VanessaGraulich]

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

[@wllymchng]

very clear and simple, thank you

[@lifeisgreat1460]

supper clear how you explain ,Thank you so much for uploading this video, How i wish I can learn more excel formula for my Lending business. I really need too,,,,More power

[@VanessaGraulich]

Happy you liked it. Vanessa Graulich :)

[@stanistanisiga7027]

Very easy. Love the video

[@KaiDraner1203]

Really helpful 🙌🙌🙌

[@ahmed6979]

Thank you so much for this video!! You saved my life on a last minute assignment!

[@Veraplays]

happy to hear that :)

[@oli27268]

You just saved my life with this video , thank youuuu 🤗😘😘😘

[@damilareolutola6755]

Thank you - this is quite helpful and efficient

[@VanessaGraulich]

happy it helped you :) (VG)

[@jenncharles619]

This is absolutely so helpful. Thank you!!!!!

[@nikhielgoordeen]

This was very very helpful. Great video and I love the positive energy ! Thank you

[@VanessaGraulich]

thanks :)

[@GG-rs5sm]

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

[@VanessaGraulich]

happy it helped you :)

[@harshkhosla5561]

Thnx so much u are far better than my teacher ,it was so easy and fun 🔥

[@VanessaGraulich]

Happy you liked it. Vanessa Graulich

[@TxBeautyQueen83]

259 thumbs down???????? HOW? This was very informative and well explained. thanks!

[@VanessaGraulich]

I love you for that :)

[@Denise-zv4qm]

Thank you, you make this so easy

[@TheAlexatorales]

Best video ever!!!! Thanks a lot 👏👏👏

[@abdelazizabdalla5800]

Thank you for this wonderful 5 minutes of learning, best explanation ever

[@VanessaGraulich]

YOu are welcome :)

[@zeeitechriver]

Thank you! This is very detailed and explained in an easy way. Especially the cell locking and copying tips.

[@VanessaGraulich]

happy you like it :)