Forum Discussion
Solved
Calculating a YTD Balance based on end date?
Not sure if this is possible - but wanted to ask. Need to calculate a "Year-to-date" balance of a savings account while using the TODAY() function as the start date (so it dynamically changes). ...
Apologies, I figured out what I was actually looking for can be done using the PMT() function. Thanks for the suggestions though!
I am not sure how you expect the first December balance to be 384.61. That would be a smaller payment than the prior month, and if payments continued to get smaller, you'd not get to the goal of $5,000. So maybe you're doing something else.
When I adjusted remaining balance downward and the monthly division downward as well, the result was a consistent 208.33 monthly. See the attached.
So help me understand what I'm missing in your explanation.