need help calculation a compound interest spreadsheet for commissions

[canoli]

Hello,

This is my first time posting here so hopefully somebody here can help. I have a spreadsheet tracking all of deposits made in a certain acct through a 2 year period. I am trying to make a spreadsheet to show what the compounded interest will be for a specific deposit at a certain month after the deposit. So to help explain i have the spreadsheat below. the period is the month number from 1-12 starting, year 2 will be 13-24 etc. The current month is the amount of months from themonth day this started so january 1 2014 and 22 months later is october 2015. I have over 300 deposits through the 22 month period since this started and i would like to be able to pull down from the first compounded amount through the entire list to get the compunded interest for each amount with the different total months it was in the account. On another page i have a simple compound interest calculator that i would like it to fill the values in and populate back under the compounded amount section.

the main objective is to be able to see the exact value of each deposit at a given point in time while taking in consideration that each deposit was in a different month and so there for will have a different compounded interest time. So anywhere from 22 months to just 1 month interest.

Does this make sense? Can this be done?
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Current month[/TD]
[TD]22[/TD]
[/TR]
[TR]
[TD]Amount[/TD]
[TD]Period[/TD]
[TD]Compounded Amount[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]500[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]150[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2500[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]125[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Formula on page 2 doing the calculations
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]Initial Investment[/TD]
[TD]500[/TD]
[TD]Amount on page 1[/TD]
[/TR]
[TR]
[TD]Annual Interest Rate[/TD]
[TD]0.12[/TD]
[TD](Fixed) 12%[/TD]
[/TR]
[TR]
[TD]No of compounding periods[/TD]
[TD]12[/TD]
[TD](Fixed) for compounded monthly[/TD]
[/TR]
[TR]
[TD]No of Months[/TD]
[TD]22[/TD]
[TD]= (current month) - (Period) + 1[/TD]
[/TR]
[TR]
[TD]Balance[/TD]
[TD][/TD]
[TD]=Initial Investment * (1 + Annual Interest Rate /No of compounding periods) ^ (No of Months)[/TD]
[/TR]
</tbody>[/TABLE]


Thanks,
Canoli