I'm trying to project a yearly future value of a retirement account that has quarterly statements
This is what I have so far.
The formula I was using is =SUM(Ending Balanace+Yearly Deposits)*Goal Percentage
Since I'm not an Excel guru, I thought the real gurus could help with a better method
Not sure how to edit the first post but that didn't turn out like I had planned. Hopefully this looks better
This is what I have so far.
The formula I was using is =SUM(Ending Balanace+Yearly Deposits)*Goal Percentage
Since I'm not an Excel guru, I thought the real gurus could help with a better method
Not sure how to edit the first post but that didn't turn out like I had planned. Hopefully this looks better
Beginning Balance | Deposits | Withdrawl | Investment Results | Ending Balance | Total Vested Balance | Year End Goal @ 7% | Year End Goal @ 6% | Year End Goal @ 8% | |
31-Dec-19 | $ 1,489.48 | $ 840.00 | $ - | $ 61.45 | $ 2,390.93 | $ 2,390.93 | $ 2,597.96 | $ 2,569.44 | $ 2,626.56 |
31-Mar-20 | $ 2,390.93 | $ 720.00 | $ - | $ (552.14) | $ 2,558.79 | ||||
30-Jun-20 | $ 2,558.79 | $ 840.00 | $ - | $ 460.51 | $ 3,859.30 | ||||
30-Sep-20 | $ 3,859.30 | $ 720.00 | $ - | $ 259.61 | $ 4,838.91 | ||||
31-Dec-20 | $ - | $ - | $ - | $ - | $ - | $ 6,287.54 | $ 6,198.55 | $ 6,377.19 | |
31-Dec-21 | $ - | $ - | $ - | $ - | $ - | $ 10,235.40 | $ 10,045.41 | $ 10,427.88 | |
31-Dec-22 | $ - | $ - | $ - | $ - | $ - | $ 14,459.61 | $ 14,123.08 | $ 14,802.62 | |
31-Dec-23 | $ - | $ - | $ - | $ - | $ - | $ 18,979.51 | $ 18,445.41 | $ 19,527.34 | |
31-Dec-24 | $ - | $ - | $ - | $ - | $ - | $ 23,815.80 | $ 23,027.08 | $ 24,630.04 |
Last edited by a moderator: