carliw1309
New Member
- Joined
- May 17, 2023
- Messages
- 1
- Office Version
- 2019
- Platform
- MacOS
I am trying to figure out an equation to help me figure out:
If I want to invest $22k a year, and so far I have invested $6k, I know how much I need to invest per month to get me to $22k BUT I want to have an equation that figures out PER MONTH what I need to invest once that amount invested has changed.
So for instance, I have 7 months left in the year, I need to invest $2285 each month to meet my goal. But if next month, I put in $3k, now my monthly goal is ($22k-$9k)/6 months = $2166
Sorry, it's the only way I can explain it because I don't know the terminology.
But if it's possible, I would like it to auto populate the months remaining. I don't know if this is possible.
Thanks!!!!
If I want to invest $22k a year, and so far I have invested $6k, I know how much I need to invest per month to get me to $22k BUT I want to have an equation that figures out PER MONTH what I need to invest once that amount invested has changed.
So for instance, I have 7 months left in the year, I need to invest $2285 each month to meet my goal. But if next month, I put in $3k, now my monthly goal is ($22k-$9k)/6 months = $2166
Sorry, it's the only way I can explain it because I don't know the terminology.
But if it's possible, I would like it to auto populate the months remaining. I don't know if this is possible.
Thanks!!!!