How I can set up a table of savings?

I'm trying to figure out how to build a table to save $ 5,500 at 6.2% APR for a annum compounded monthly. I've tried several different methods: * The rate equilibrium time but I keep getting * different answers. I'm so frustrated by the time. Any help would be greatly appreciated!

By saving graphic, I assume you mean "what the final balance of" Y ", given the assumptions, after X months? "The formula is: Y = 5500 * (1 + periodicrate) ^ X (^ means exponent, and you should be sure to follow the order of operations). The periodic rate is 0.062/12 = 0.005167 (because you monthly compounding, taking the annual rate and divide by 12). So after three months, your final balance would be 5585.69 U.S. dollars [the result of 5500 * (1.005167) ^ 3], after 6 months, would be 5,672.72 USD [5500 * (1.005167) ^ 6]. Just substitute different numbers of months to find out what your final balance would be for the duration. You are supposed to get different answers using the different months. Examples of final balances after several months (from 3-36 are below) 3) 5585.691217 6) 5672.717522 9) 5761.099716 12) 5850.8589 24 24) 6224.1000 28 36) 6621.1511 26 course you end up with more money after a longer period of time. That is the nature of compound interest earned. Now if you were the previous data box on a graph, the numbers of left-hand column would be in the X-axis (3, 6, 9, 12, 24 …), and the dollar amounts would be the point Y.