How to build an Amortization table in EXCEL (Fast and easy) Less than 5 minutes
Vložit
- čas přidán 15. 02. 2014
- Hi Guys,
This video will show you how to build an amortization table in excel is less than 5 minutes
:)
Please subscribe and watch all our tutorials
www.i-hate-math.com
Out of all the amortization videos ...yours was the EASIEST and the FASTEST !!! TY and its no wonder youre a smart woman
thanks so much :). Math is just that beautiful :)
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!
happy to hear that :) VG
I learned more in your 4 minutes video than my entire 3 months of finance class.
thanks so much for that :)
You are the best
So true. Took me 3 hours to decipher my instructors excel instructions and I understood this in 5 minutes 🙄
2023 can confirm. 🎉😢
Frfr I've been trying for 3 hours. 😀
My thoughts exactly!
You just turned an hour of frustration into a few minutes of peace. thank you
happy it helped you :)
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.
Hi Vanessa, many thanks from an old timer. I'm nearly 75 and managed so well to work out my pension, Great job!!!
you got this I am an too.
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!
thanks so much :)
I spend 3 hours doing this, then I suddenly browse and found your video 😭. Thank you very much ✨
very happy to hear that VG
Definitely helped me with my CPA studies too. Nothing is a better visual representation than the quantitative format of everything simplified into excel
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! :)
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!
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!!!
This is a lifesaver, forever owe my life to this video
glad it helped you :)
THANK YOUUUUUUUU I was really about to do this manually omg. thank you!
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.
I have been struggling with this for over a week. Watched your video once, and now I finally understand it! Thank you so much!
Girl you taught me everything in 5 min which my professor was not able to in a full month
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!
czcams.com/video/pQTJbEf6JZ0/video.html
You are a life saver! Super fast, super simple, thank you for the guide! 🙂
You're an absolute lifesaver! Teacher didn't give us proper instructions and left us floundering. Thank You!!
I am happy you were able to enjoy it :)
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!
Thanks Salma Hayek! I didn't know you do Excel classes on your free time from movies!
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!
Thanks so much :)
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.
That was the most coherent and easy to follow broken English I have ever heard!!! Nice job, very helpful.
This is perfect! I had a request for an amortization schedule and did not know how to create in Excel. Thank you!
you are welcome :) , happy you enjoyed the video
Viola!!! I just finished my assignment by watching this Video. Thank you so much!!!!!!
very happy for that :)
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.
thanks so much
YOu made my day VG
this is the best example of how to build a mortgage calculator in Excel that I've seen 👍
thanks :)
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.
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.
Very happy to hear that :). You got this . VG
OMG! Helped complete our Finance Assignment! Now an I Hate Math Group Subscriber.
thanks for this video. you have a great accent!!!
I don't usually comment but this saved me a lot of time and was easy to follow. Thank you
thanks for your comment :)
I couldn’t help but cry at the end of the video....
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!
thanks so much :)
Hi guys! Welcome to I Hate Math Group! you are a gem
Naomi VG this is now my new channel
I want to thank you. I suck at excel and you were able to explain everything and my spreadsheet is correct. I am working on my paper but I will definitely save this for future reference and to share with my other group members.
Still works for me without a hitch. Thanks so much for this. Easy, easy, easy.
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.
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.
You made my day :) . Vanessa Graulich
Thank you! You helped me so much, forever in my heart!!! :)
Hi Vanessa, I followed this step by step and it was perfect! Very simple instruction for first timers :) Love it!
Mine is not calculating the numbers, what am I missing?
Thank you! I was struggling for an hour, you're very clear and direct. I am following you for sure, thanks again.
thanks so much
THANK YOU for getting straight to the point and making this super simple! Still relevant 7 years ago!
Thanks so much for your kind words . VG
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!
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!
Thanks so much for your comment :) . Vanessa Graulich
WONDERFUL explanation! Thank you.
This was very fast and well explained thank you.
thank u so much. Your cheery voice brightened up the depression I had facing Math:) And u made it so much easier !
Thank you, this was great and easy to follow, now I can keep track of my loans :)
AWESOME, thank you so much for posting this, very very easy to get this done quickly and correctly!!!!
THANKS A TON! I really appreciate it!
You sound just like someone I work with but you made this super simple and actually learned something about Excel I didn’t know
This video solved my problem in manually computing the amortization schedule..
Thank you very much
Thank you for the video!
Casi me muero cuando veo los intereses 😂 wow! Súper agradecida ❤ thank you!!!
de nada :) . Vanessa Graulich
Excellent tutorial!!!! I was always apprehensive of creating these schedules but now I have confidence. Keep bringing these tutorials!!!! Wonderful job!!!!
thanks so much for your feedback. :) Happy you enjoy the video
THANK YOU THANK YOU THANK YOU!!!! You have helped me so very much and saved my uni grade!!!!!!!!!
This just saved my butt for an exam. Thank you!
Hey thanks 1 million! It was really easy and you are a good teacher with a nice accent! Thank for putting the time , you made my day so much easier!
Sincerely
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!
happy you like it :)
@@VanessaGraulich Instant subscriber. the net interest payment made me really cry (and my decision: not to buy a house)
Wow! Best teaching on creating amortization schedules in Excel that I have seen. Thank you! Thank you!
YOu made my day :)
This is one of the best video explanations on CZcams!!! Thank you
This is amazing! Super easy instruction and literally saved me hours of frustration! Thank you SO MUCH!
Happy Melissa :) you were able to finish sooner your assigment
Thank you. Very simple. Very accurate and well-instructed.
Thank you, this really helped me quickly and effectively
259 thumbs down???????? HOW? This was very informative and well explained. thanks!
I love you for that :)
Thank you! My students will thank you as well.
thanks :) so much for that. Vanessa Graulich
Thanks, Mam, I solved a task by helping with your video.
nice :)
OUTSTANDING show. great job
thank you so much, you helped my assignment :)
Quick and easy. A great fast pace for those with excel experience!
This video is awesome... It was quick and easy... I absolutely love it. Thanks for sharing
Thank you so much for making this short and sweet with a result!
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
thanks so much :) . VG
Awesome stuff!
Thanks for taking the time out and showing it on Excel. I usually work out loan repayments on a HP 12C ... sadly you never get to see how the principle and interest decreases over time on a calculator.
Therefore in Excel who can the remaining amount to pay at select periods (months).
Thanks
Excellent example. I was able to create my own amortization schedule. To make it match a bank's amortization schedule, you will need to round the payment calculated and interest payments.
Best knowledge got from ur video
Just awesome @excellent teaching method
...so simple, quick, easy - thank you very much!
I feel smarter now analyzing the cost of money. The way I perceive investments, ROI, Cash and Cash Returns is entirely much different now than before when I would not know how interests are eating up my meagre resources. Today I can go up to a car dealer, house broker, credit card dealer, insurance dealer and break their proposals to the last dollar value and see how he is ripping me off with his slick talk. Thank you.
czcams.com/video/pQTJbEf6JZ0/video.html
Thank you for this easy to follow quick tutorial! It helped immensely!
Can't get any easier! Thank you soooo much!
You just saved me BIG time... Thank you!
Very Nice and Quick explanation..Gonna create my own when I buy my new car!
Best video I have watched. Thank you very much.
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!!!!!
OH MY GOD! You just saved me so much time with my finance project. THANK YOU!!
:) happy for you
This is GOLDD!! Thanks a bunch for sharing.. Not quite sure why anyone would dislike but umm... GREAT!!
That was great! Simple and easy to follow! Thank you so much!
You're amazing. Now, add a column for 'extra payments' per month in case someone wants to pay early.
Hell yeah, brother
Thanks so much for putting this together! Explained things so well and made it simple and easy to understand!
thanks so much for your feedback
This video saved me from a mental melt down☺ Thank you so much #liked#subscribed#keepupthegoodwork!
Thank you sooooo much! and you made it soooooo easy; now I can use this format on any loan.
You have no idea how much this just helped me. Thank you!
happy to hear that :)
Very nice video. I was picturing Sofia Vergara teaching me how to make amortization tables in excel.
I do sound like her, but do not have her other assets LOL
@@VanessaGraulich lol.. are you the person speaking in the video?
@@daviddunmer3889 same one :) , just older
Best one I have seen yet, thank you
Thanks much :) VG
Appreciate this video.... quick and easy! Thank you!
Thank you for such an amazing and easy-to-follow video!
Thanks a bunch. Much needed. Easy to remember as well.
Better than the course I have in a college spreadsheets lesson..
happy you enjoy it :)
Super easy and helpful!!! THANK YOU!