На главнуюОбразованиеПохожее видеоЕще от: I Hate Math Group, Inc

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

Оценок: 2110 | Просмотров: 461440
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
Категория: Образование
Html code for embedding videos on your blog
Текстовые комментарии (232)
BMC (1 час назад)
You're a genius...thank you..
The Gamer (1 день назад)
what is mothly amortization guys? what is the other term? can you help me?
Steven Pooler (4 дня назад)
This is GOLDD!! Thanks a bunch for sharing.. Not quite sure why anyone would dislike but umm... GREAT!!
C I Den (13 дней назад)
Great video. Where can I make a supplemental payment towards the principle.
Ahmed Eidam (22 дня назад)
Thank you so much for this video!! You saved my life on a last minute assignment!
Karla Aileron (1 месяц назад)
sorry, I got lost half way there. Like Tripura said, not everyone is business or math savy, so next time PLEASE slow down. Otherwise it is a great video.
Carlos Ladrón de Guevara (1 месяц назад)
what i understand is that with amortization method you are paying three time the cost of the home.
Carlos Ladrón de Guevara (1 месяц назад)
I don’t understand why the principal is 100000 and when you add 13% interest the amount is 113000, then how the total payments is 3 times the money that you have to pay? I don’t understand
MD Vending (1 месяц назад)
Divide 13% which is .13 by 12 and you'll get the number
RelaxAndTroll (1 месяц назад)
What the fuck am i hearing, fuck me man i need to finish a project and i get this shit in my ears. Fuck
Trust Fund Loan Services (1 месяц назад)
Thanks to this great company, I finally smile again because the company offer me a loan of $90,000.00 us dollars and two of my friends have also received a loan without any difficulty with an interest rate of 2% per year. I advise you that you should no longer do business with wrong people, if you want a loan for a project or another need. I am making this announcement because New American Funding give this loan has helped me a lot. Through a friend of my, you can contact the company on this email address loanservicestrustfund@gmail.com Whatsapp Number: +1(845)7315252.
felice park (1 месяц назад)
Alang Lagyu (2 месяца назад)
Gajendrankarthick (2 месяца назад)
Thanks for this video
Alexis Pomerleau (2 месяца назад)
This was so helpful. I still hate math. Lol
MissRochelleRenee (2 месяца назад)
This is great! Thank you.
Farzeen1232 (2 месяца назад)
your voice actually gives me aids
Sindiso Mangozhe (2 месяца назад)
You are a life saver!! Thank you so much!
Nischol Suresh (2 месяца назад)
lol, the name of the channel
Blue Point (2 месяца назад)
You just saved me. Thank You
mr robot (3 месяца назад)
Hi does this table adjust automatically? like if you have a shorter or longer term than 360 periods?
Sophia Anca (3 месяца назад)
This is so great, thank you for uploading!
Ramona Pikeur (3 месяца назад)
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!!!
Timothy Graham (3 месяца назад)
This is wonderful. How can I tweak the math for a loan based on a fixed payment ($500) not a fixed term (360). Does someone know to make that change?
Ri2nonerok (3 месяца назад)
Thanks, do you have patreon?
Xam Seah (4 месяца назад)
the Italian accent is the best accent in the world
Rayah Hashim (4 месяца назад)
very amazing waoooooooooooooooooooooooooooooooooooooooooooooooooooooo
DAJOKER808 (4 месяца назад)
She used 365 because she used 5 cells already
Mark Lama (4 месяца назад)
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!
sliv5sliv (4 месяца назад)
I did this the exact same way and I got over a 1,000$ payment calculated so I have no idea what I did wrong here.
Claudia Milan (5 месяцев назад)
omg@@@ thank you so much that so fun and easy!!!!! xoxoxo
Russell Pizzuto (5 месяцев назад)
Sorry but doing all this is crazy... Excel has built in schedules already. Watch this one https://www.youtube.com/watch?reload=9&v=q919JA3RpfA
Tony Hingpit (5 месяцев назад)
vishal bhardwaj (5 месяцев назад)
was very helpful, thanks a ton dear
anna rubica (5 месяцев назад)
Feeling frustrated due to some unexpected expenses that can’t fit in your ongoing budget? yhen visit-https://shorttermcredits.com/merchant-cash-advance.php
sophia cris (5 месяцев назад)
Worried if you could charge with late fee or what if your late payment will report to the credit agencies? then visit- https://instantcreditloansus.com
Tham-Tham Socishe (5 месяцев назад)
Very helpful and easy to understand and follow. Thank you so much!!!!!!!
Orlando Medina (5 месяцев назад)
Can you add a column with extra monthly payment and show how calc will work if you send extra money to principal
C I Den (13 дней назад)
Did you ever get a reply to that question? I'm trying to so the same thing.
erin davitt (5 месяцев назад)
Way too fast
Christabel Ojuok (6 месяцев назад)
Very helpful and easy to understand.Thank you
yaqub farooqui (6 месяцев назад)
hello mam can u send me your this excel sheet email is developer@finheal.com
Belinda Sullivan (6 месяцев назад)
Oli 1 (6 месяцев назад)
You just saved my life with this video , thank youuuu 🤗😘😘😘
Ruslan Idyrov (6 месяцев назад)
Michael Henderson (6 месяцев назад)
Input a ten or 15 year mortgage and watch it calculate all the way to 360 months. Understand that one can modify the SS by copying down to the no. of months, but that should not have to be necessary! SORRY but you are NOT finished. Also speak slowly since you have a very heavy accent. Otherwise great job.
Giorgi Kikvadze (6 месяцев назад)
I love the way you pronounce "Balance" :)
Fz06 Ridah ACC (6 месяцев назад)
if i want to pay of my car faster and pay extra every month should i deduct in the principal?
Jason Long (6 месяцев назад)
This was surprisingly good
Nicky Velez (7 месяцев назад)
Excellent tutorial. Thank you!
Friedrich Chheng (7 месяцев назад)
Simple explanation and useful knowledge. Thanks.
Der Vang (7 месяцев назад)
OMG., thank you so much!!!this really helped me with my homework and make it easy to follow.
Josiah Horn (7 месяцев назад)
Shouldnt the first month be the purchase price minus the down payment? instead of the full loan
Laurence Esposito (7 месяцев назад)
Still works for me without a hitch. Thanks so much for this. Easy, easy, easy.
Harrison Wines (7 месяцев назад)
OMG! Helped complete our Finance Assignment! Now an I Hate Math Group Subscriber.
Kambinda Immanuel (7 месяцев назад)
Laurence Esposito (7 месяцев назад)
Well done! I would suggest re-doing and just slowing down and add terminology for dollar signs for freezing cell amounts for interest, etc. THANKS!!!!!
En Vivo (7 месяцев назад)
Great video, Thank you! Keep it up.
Saion Dutta Roy (8 месяцев назад)
ThePhatman777 (8 месяцев назад)
Thank you!
Patrick Oc (8 месяцев назад)
Jonathan Simpson (8 месяцев назад)
your speaker pops
Jonathan Simpson (8 месяцев назад)
Yay! I hate math, too!
Tricia Moore (9 месяцев назад)
I am trying to do the final step of copying the formula all the way down the columns- it is not changing the information; it merely copies the 2nd month all the way down. Help ...
Brandon Miller (9 месяцев назад)
Jump On My Wagon (9 месяцев назад)
Thank you! Simple and to the point. Thank you!
Tim of No Trades (10 месяцев назад)
Well done thank you!
Parul Samalia (10 месяцев назад)
Very informative Video, gave the exact details what I wanted, thank you.
Wasiu Ibrahim (10 месяцев назад)
Ur video has really shown us aw to build an amortization. Thank you, dear and power to ur beautiful elbow
Mason Higham (10 месяцев назад)
THANK YOU THANK YOU THANK YOU!!!! You have helped me so very much and saved my uni grade!!!!!!!!!
sokai0206 (10 месяцев назад)
I couldn’t help but cry at the end of the video....
Sagar Thakkar (11 месяцев назад)
Definitely helped me with my CPA studies too. Nothing is a better visual representation than the quantitative format of everything simplified into excel
Nick (1 год назад)
nice video
Boi? (1 год назад)
姚昊辉 (1 год назад)
i love you
Nadene Allan (1 год назад)
OmG i need to kiss you ! ♥ Subscribed .... especially love the don't cry about it comment LOL
Monika S (1 год назад)
Super easy and helpful!!! THANK YOU!
Suresh Bharadwaj (1 год назад)
Too fast. I did not pick much. Should slow down.
M B (8 месяцев назад)
If she slows down I have to shoot myself
Yumika Tyler (1 год назад)
sham saqlain (1 год назад)
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!
Manuel De Leon (1 год назад)
Awesome!  how do I do one of these using a daily rate? especially over a 5 y / 60 mo.
Gerard Bradley (1 год назад)
Is there a way to show what would happen if I increased the payment, lets say, about a year later? By the way, GREAT INSTRUCTIONAL VIDEO!!!
TrashBeatz (1 год назад)
THANK YOU!!!!!!!
Ricky Brown (1 год назад)
gotta love how you pay for the house 4 times over. biggest scam ever. wish i knew this before i purchased my first home
gabevans087 (1 год назад)
Thank you!!!! (:
NJ2MDdude (1 год назад)
Hello Vanessa, thanks for your succinct explanation. I have a question for you. What if the loan agreement stipulated that the payment of principal begins at the start of year 2, the 13th period?
Suraj Karande (1 год назад)
Thank you for explanation..:)
Prashant Nair (1 год назад)
Thanks so much.... It was very helpful and knowledgeble.
Aviann A. (1 год назад)
What if my interest sum is lower than my loan amount
Ricky Brown (1 год назад)
that means you had a low interest amount and/or small loan
Varinder Kumar (1 год назад)
fucking awesome!
aklepatzky (1 год назад)
Thanks bae!
manavgupta100 (1 год назад)
Thanks Vanessa. Exactly what I was looking for. Thanks a ton.
superplan89 (1 год назад)
How do u do it?? Does it come with all the highlighted green??
Q8Patriot (1 год назад)
THanks for your time
Kyle Lee (1 год назад)
it doesnt work when i highlight it and try to pull it down... it just ends up being all the same
Art Schmalbach (5 месяцев назад)
Highlight row for month 2 and drag to row 360. If dragging from month 1 it will be wonky.
Liz Lytle (1 год назад)
Thank you for this easy to follow quick tutorial! It helped immensely!
Yan Frandiyo (1 год назад)
Can I calculate the IRR of this investment?
imjspiddlin (1 год назад)
Monica R (1 год назад)
Fantastic! Easiest instructions ever. Thanks!
Tony Valentin (1 год назад)
What if you make extra payments every now and then. How do you put that in there??
Rodrigo Garcia (1 год назад)
Thank you very much. Now what if I do a Pre-Payment and the payment is applied to the principle and any remaining balance is re-amoritized. How do I calculate that?
Ganger (1 год назад)
Best video ever!!!! Thanks a lot 👏👏👏

Хотите оставить комментарий?

Присоединитесь к YouTube, или войдите, если вы уже зарегистрированы.