I don't normally comment on YT videos...but when they are this helpful a thankyou is definitely deserved. So thankyou. Just one comment if you reference another similar video might be worth adding a link as it is quite hard to navigate to find the mentioned video given how many you have :) thanks again
Thank you so much for the video. I'm just curious to know how bank bond calculators seem to be able to show the number of years & months the loan will be reduced by if extra monthly payments are made. Is it possible to build that into the Ms Excel calculations like you've in the video? 🤔
Suppose , customer don't know how much money he paid. He knows only the loan amount he took first and the current balance of the loan and also the interest rate and the duration of the loan. is it possible to find out the amount he paid ? Example- He took 100 dollar. and current balance is 40 dollar. Interest rate 9%. Time 12 months. How can i estimate the amount he paid ? Is it possible ?
Try asking Excel questions at the best Excel question site around: mrexcel[dot]com/forum It is easier to post Excel solutions at this site (UA-cam Comments don't allow us to do much)
Wow!! Thank you for the creatively said compliment: "You Transfer information like a well trained karate instructor". That is one of the coolest things anyone has every said about the videos ; )
If the borrower is not keeping up with scheduled payments and cumulative interest keeps mounting how to accommodate that while calculating ending balance.
I need some help if you’re willing to share your expertise. I created a very basic table for overtime expenditures with a beginning balance. As data gets entered, I was able to create a “remaining balance” column. I would like to then create a dashboard that reflects only the remaining balance as of the last entry record, without showing the previous balances. Please let me know if you have trouble understanding my question. Any help is appreciated. Thank you!
What if you wanted to pay it bi-weekly and you got paid 26 times within the calendar year? What is the formula for changing the amount of payments bi-weekly?
Thank you for this video and especially the link. It is exactly what I want for the purpose of accelerating payments on my car loan and other debt. It gives me a very good budget tool.
Would you post an edited video on how to adjust the interest/balance calculation when the time period between the loan date and the first payment is either less than or greater than a month?
@ExcelIsFun because sir i noticed that when you are typing the formulas. instead of D1 but D$1 and i dont get it.....i dont know how to make formula in excel but happily i am the one who got the highest score among my classmates in ammortizations. haha. but i am still a first year commerce student.it is still basic...
Thanks! This video was very helpful. To add on, how do you update the "years" and "total periods" cells when you made extra payments so that I don't have to scroll down to see the new mature date? Thanks in advance!
Thank you for all your videos. How can I create an amortization schedule to compare pay off times and interest savings by making payments on a bi weekly basis rather than monthly basis?
I don't normally comment on YT videos...but when they are this helpful a thankyou is definitely deserved. So thankyou. Just one comment if you reference another similar video might be worth adding a link as it is quite hard to navigate to find the mentioned video given how many you have :) thanks again
Thank you so much for the video.
I'm just curious to know how bank bond calculators seem to be able to show the number of years & months the loan will be reduced by if extra monthly payments are made.
Is it possible to build that into the Ms Excel calculations like you've in the video? 🤔
Suppose , customer don't know how much money he paid. He knows only the loan amount he took first and the current balance of the loan and also the interest rate and the duration of the loan. is it possible to find out the amount he paid ? Example- He took 100 dollar. and current balance is 40 dollar. Interest rate 9%. Time 12 months. How can i estimate the amount he paid ? Is it possible ?
Try asking Excel questions at the best Excel question site around:
mrexcel[dot]com/forum
It is easier to post Excel solutions at this site (UA-cam Comments don't allow us to do much)
If you wnat to learn more about cell references, search for "Excel Mixed Cell References" and you will see i have many videos on this topic...
Not sure why I am getting error when I am literally doing everything you are doing lol. First line is good but once I copy to the rest, it dies
You are the man! Thanks for the tutorial. Excellent knowledge, will save folks lots of time calculating and saving!
Your question is not clear.
I don't get what the Ctrl-SHFT-Tilda did
Are you still helping people ? Sept, 2019
Hello do you have a version of this where you address recasting the mortgage, rather than reduce the length of the loan? Thanks in advance...
You are welcome!!
Is it too late to download the excel sheet?
You are welcome!
Sir is it applicable to personal loan??
Love It!!! Better than Netflix!!!
Yet another set of cool kind words!!! Thanks!
Thank you so much. How do you clean up the months(period)on from 130(A143) going down and be able to show them IF you had less extra payments?
Thanks!
why bank charge interest rather then amortization table interest with quarterly basis
You Transfer information like a well trained karate instructor!!! Ous Sensei!!! Thank You!!! Humble Bow.
Wow!! Thank you for the creatively said compliment: "You Transfer information like a well trained karate instructor". That is one of the coolest things anyone has every said about the videos ; )
Amazing. Thank you!!
If the borrower is not keeping up with scheduled payments and cumulative interest keeps mounting how to accommodate that while calculating ending balance.
This is exactly what I was looking for!! Thank you so much for explaining it so clearly!
What is the link below the video? Its just a bunch if random names.
I need some help if you’re willing to share your expertise.
I created a very basic table for overtime expenditures with a beginning balance. As data gets entered, I was able to create a “remaining balance” column. I would like to then create a dashboard that reflects only the remaining balance as of the last entry record, without showing the previous balances. Please let me know if you have trouble understanding my question. Any help is appreciated. Thank you!
Is there a formula to add a late payment with escrow and insurance that can affect the end of the loan term?
What if you wanted to pay it bi-weekly and you got paid 26 times within the calendar year? What is the formula for changing the amount of payments bi-weekly?
Thank you for this video and especially the link. It is exactly what I want for the purpose of accelerating payments on my car loan and other debt. It gives me a very good budget tool.
Thank you thank you. I have been going back and forth about refinancing to 15 years .
Would you post an edited video on how to adjust the interest/balance calculation when the time period between the loan date and the first payment is either less than or greater than a month?
Could you please share your video to make this table with simple fix rate and pay off date?
Thanks bud ❤️ exactly what I was looking for.
thank you !!!!
Thanks for your helpful videos. Are you for hire to help with a special project?
@ExcelIsFun because sir i noticed that when you are typing the formulas. instead of D1 but D$1
and i dont get it.....i dont know how to make formula in excel
but happily i am the one who got the highest score among my classmates in ammortizations. haha. but i am still a first year commerce student.it is still basic...
Thanks! This video was very helpful. To add on, how do you update the "years" and "total periods" cells when you made extra payments so that I don't have to scroll down to see the new mature date? Thanks in advance!
Exactly what I was trying to do. Thank you!
How to calculate tenure 30 years, every 5 years difference rate?
Just found this. Beautiful. a regular rembrandt. nicely done.
Fantastic video!!! i've been looking for something like this for a while!!
Excellent... Thank u so much..🍫💐
Thank you for all your videos.
How can I create an amortization schedule to compare pay off times and interest savings by making payments on a bi weekly basis rather than monthly basis?
Thank you very much for your efforts.
Extra payment.
Exactly what I wanted.
Hi your video is very good but the link not work, thanks
It seems to be working now.
Do you have a video on how to create this table on our own step by step?
Very helpful lesson. I'm using the file too. Thank you.
Where do I find the page to download the excel spreadsheet?
Wow this helps me a lots. Thank you so much for uploading these videos.
Thank you! Fun and informative
I'm having trouble finding the link to this workbook on your site. Can you help?
Try this people.highline.edu/mgirvin/UA-camExcelIsFun/EMT514-515.xls
Thank you so much! This will definitely help me to pay off my mortgage a lot sooner.
Thank you--awesome format and great tricks!!
Thank you very much! This really helped me plan my home loan payment.
Awesome video! Really helpful.
Saved video until I need it lol
Thanks dude! I am just bad at math, not very bad with excel. This showed me everything i needed to know!!!
Can you just email this formatted table and let me pay you for your skills?
sebern2 I do this type of work for a living. My prices are extremely reasonable email me at vbartkut@yahoo.com
Excellent vid! Thank you so much!
In 2020, Still helpful
I appreciate your info. Thank you.
IS THAT A DOLLAR SIGN?? PLEASE TELL ME
HOW DO I DOWNLOAD
Thank you very much!
@ExcelIsFun thanks !!!!