No. of Recommendations: 1

Here's how to set up an excel spreadsheet to do the calculation. It won't be 100% precise because it just takes into account the month the deposit was made, not the day in the month, but it should be to within a few pennies.

If you want, I can explain what the formulas mean, but your prior posts made it seem that you were just looking for a how-to, and not the reason behind it.

Open a blank Excel sheet.

In cell A1, put in your annual interest rate.
In cell B1, type in "Annual Rate"
In cell A2, type in =(1+$A$1)^(1/12)-1
In cell B2, type in "Monthly Rate"

In Cell A4, type in "Date"
In Cell B4, type in "Deposit"
In Cell C4, type in "Balance"

In A5, A6, A7 etc type in the months (Oct 2005, Nov 2005, Dec 2005 down to the end of your time frame)
In B5, put in "0"
In C5, put in your starting balance
In B6, B7, B8 etc, type in the dollar amount you are adding each month.
In C6, type in the formula =C5*(1+$A$2)+B6
Highlight the cells C6, C7, C8, down to the end of your timeline.
Press "Control + D". This will copy your formula down to the bottom.

By looking at the "Balance" column, you should be able to predict what your balance is in any given month.

Print the post  


UGC Disclosure Notice Regarding Credit Card Posts
Community board discussions about credit cards are not provided or commissioned by banks who may have advertising relationships with The Motley Fool. Responses have not been reviewed, approved or otherwise endorsed by the bank advertiser. It is not the bank advertiser's responsibility to ensure all posts and/or questions are answered.
TMF Credit Center
The Motley Fool Credit Center arms you with real tools and simple messages, that will help you in every credit situation.
What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.