The method you are are using is for amortized debt (home loan, car loan, etc). You can't accurately use this for credit card debt that compounds the interest into the principal balance daily.
Great spreadsheet and all calculations work for me. How would you include fees not included in current balance. For example, if someone has $200 automatic payments every six months to PayPal, monthly/bimonthly streaming fees, or annual credit card fees?
@@BarbHendersonconsulting No, your calculator shows me the pay off for each individual bill. Or at least I can read it. That's what I've been looking for so I can automate my bill pay. Your calculator is the best one I've found. Others, only show the debt free date, which isn't what I need
Hi Barb, well done on your calculator. I have another question, although similar not the same. I am behind on my property taxes by a couple of years. I want to catch up and can devote $1,000 monthly to this effort. For simplicity and near truth years past 2022 $7,500, plus interest at 12% from December 2022, 2023 at $8,000 plus interest from December 2023, and 2024 at $8,500 plus interest at 12% from December 2024, and so forth going forward. When would I catch up with annual due date? Perhaps $1,000 monthly is not sufficient, each year has to be fully paid by 36 months after each annual due date of April 30.
What about the debt avalanche? Is there a way to set up a payment schedule for the most efficient way to pay off debt with a certain amount paying every month. For example if the loan amounts and interest rates vary greatly. In order to same the most money in the long run. Is there a way to calculate a payment schedule based on saving the most money while paying off debt?
I am trying to use this to calculate my student loans but I am getting an error, not sure why. For example, one loan has an interest rate of 3.4%. The payment is $5.60 a month and the principal is 2,943.46. Is the error because I am dividing the rate by 12, when I shouldn't be? or because the payment is so low?
Is there a formula to determine how much you need to pay if you want to pay on a certain date? For example, if I want everything paid by October 2021, is there a formula to show how much you need to pay to reach that goal?
Hi. What do you mean when you say the interest is F4? I'm familiar with the key but when I hit shift/F4 it doesn't match your results. What am I missing with the F4 bit?
The F4 key absolutely references a cell. The alternate to this is placing $ around your value in the formula. $A$2, When you click on the A2 in your formula and click the F4 key, it should do this automatically
Thank you so much for watching my video. If you have any suggestions for future topics please leave them in the comments below.
This was excellent! Stayed up late and now have a definitive plan for conquering our debt! :)
You got this!
Thank you do much for creating and uploading this helpful informative video. Appreciate your time and pace of the video. X
You are so welcome!
The method you are are using is for amortized debt (home loan, car loan, etc). You can't accurately use this for credit card debt that compounds the interest into the principal balance daily.
the accountant that I created this for originally never had a problem with the calculations
Thanks Barb, very well done :)
This is just what I was looking for, thank you.
Glad I could help!
Great spreadsheet and all calculations work for me. How would you include fees not included in current balance. For example, if someone has $200 automatic payments every six months to PayPal, monthly/bimonthly streaming fees, or annual credit card fees?
you would need to create an extra column for fees coming off through out the year
@@BarbHendersonconsulting Thank you
Wow! I've been searching for this formula... Thanks soooo much for this video.... new subscriber here... :)
Glad it was helpful!
this is exactly what I needed. Thank you so much! very much appreciate!!
Glad it was helpful!
Great information. Lots of calculators online, but none show the actual pay off dates, just the final pay off date.
Thanks, the final pay off date is the best I can do
@@BarbHendersonconsulting No, your calculator shows me the pay off for each individual bill. Or at least I can read it. That's what I've been looking for so I can automate my bill pay. Your calculator is the best one I've found. Others, only show the debt free date, which isn't what I need
Thank you
You're welcome
Thank you.
Welcome!
Hi Barb, well done on your calculator. I have another question, although similar not the same. I am behind on my property taxes by a couple of years. I want to catch up and can devote $1,000 monthly to this effort. For simplicity and near truth years past 2022 $7,500, plus interest at 12% from December 2022, 2023 at $8,000 plus interest from December 2023, and 2024 at $8,500 plus interest at 12% from December 2024, and so forth going forward. When would I catch up with annual due date? Perhaps $1,000 monthly is not sufficient, each year has to be fully paid by 36 months after each annual due date of April 30.
You can download a copy from my free templates on my templates page www.easyexcelanswers.com/templates.html and then plug the numbers in a see.
What about the debt avalanche? Is there a way to set up a payment schedule for the most efficient way to pay off debt with a certain amount paying every month. For example if the loan amounts and interest rates vary greatly. In order to same the most money in the long run. Is there a way to calculate a payment schedule based on saving the most money while paying off debt?
I have not worked on that either
What do you mean when you say your going to F for the interest rate?
The F column is where your are calculating interest for the send credit card.
I am trying to use this to calculate my student loans but I am getting an error, not sure why. For example, one loan has an interest rate of 3.4%. The payment is $5.60 a month and the principal is 2,943.46. Is the error because I am dividing the rate by 12, when I shouldn't be? or because the payment is so low?
use the future value FV with 0 as the future value
Is there a formula to determine how much you need to pay if you want to pay on a certain date? For example, if I want everything paid by October 2021, is there a formula to show how much you need to pay to reach that goal?
I do not know of a formula off hand that would do that
Hi. What do you mean when you say the interest is F4? I'm familiar with the key but when I hit shift/F4 it doesn't match your results. What am I missing with the F4 bit?
The F4 key absolutely references a cell. The alternate to this is placing $ around your value in the formula. $A$2, When you click on the A2 in your formula and click the F4 key, it should do this automatically
Is there a way to calculate to figure out how to pay the least amount in interest?
I have not worked on that
Are you able to create a template that I can download? Please.
if you email me at easyexcelanswers@gmail.com, I will send you a copy