Compound Interest-Excel

[rachelm]

Suppose $200 is deposited at the end of each month into an account paying an annual interest rate of 6% compounded monthly.

Make a table through the end of the 10th year, with columns for: Month, Deposit, ending balance for this deposit after
10 years (EB), and Interest earned by this deposit after 10 years (I).


I need help getting started please.

 

[Denis]

What are you after?
The formula that gives the future value?
Or how to calculate each month's ending balance so you can print 120 month-end balances?

Month    Deposit     Interest            Balance
0                                            .00
1        200.00           .00             200.00
2        200.00          1.00             401.00

Do you understand that?