Annual Compound Interest Caculating Projected Earnings

Aug 2016
2
0
Dayton
I am trying to generate a formula that accurately projects annual earnings on a retirement fund with the following details:

Beginning Balance: x
Period Contribution: y
Annual Contributions: 26
Years: 5
Annual Interest: 4% (compounded monthly)

*You can not earn interest on contributions during the current month.

I want to know how long it will take to accumulate $100,000 based on x beginning balance and y contributions by having a formula, but I cannot figure it out :(.

Below indicates the number of contributions per month for 2017-2021

Earn.jpg

THANK YOU
 
Aug 2016
2
0
Dayton
Thank you,

would I be able to access the actual file so I can view the formulas you used?

I guess, I am trying to figure out the formula for calculating the interest.