Calculating a YTD Balance based on end date?

[des378]

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).



Ex:

Total Goal Amt: 5000

End Date: Dec 2026

Total # of Months till completion: 24 (*calculated using TODAY() function + the end date, so dynamically changes - e.g next month it will be 23 months to completion, then 22, and so on)



Displayed as "one value" that changes each month (breakdown shown as an example):

YTD Balance (this month): 208.33

YTD Balance (Dec 2024, next month): 384.61

and so on...



Thanks in advance!

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Calculating a YTD Balance based on end date?
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem. However, as you have been told about this before, any further instances of cross-post links not being provided may result in your posting privileges being restricted. If you are not sure why this is an issue then you probably did not take note of the bold text above that was also in the linked post from earlier.

 

[des378]

Apologies for the crosspost - forgot to post link as I was looking for quick solution. Thanks for all the replies. Solved my own problem - figured out I can achieve what I need using the PMT() function.