Formula for Investment Gain Part II

[bluemango]

Thank you guys in advance...
Mike gave me full resolutions but I have no idea how can I get through this..(ThankS Mike!)

On my sheet two values's missing on cell F1, G1 (but He figured out)
from his quote, =+G3-E3 would calculate F1, but I don't think it's gonna work since the value is missing from G3 What do you think?
so as from on G1 he quoted, =$F$1*(((((1+$D$1)^(A3+1))-1)/$D$1)-1)
but you know the other value is missing from F1 too
I'm getting a message which is about the misconfigurations of the formula and bad references after all.....

Any ideas?

Try this, copy the Formula's to the cell Below, and drag down to achieve Results.
NB:- Two Words to Remenber, Courtesy and New Thread. !!

[COLOR=royalblue][B]Column(A)  [/B][/COLOR] [COLOR=royalblue][B]Column(B)  [/B][/COLOR] [COLOR=royalblue][B]Column(C) [/B][/COLOR][COLOR=royalblue][B]Column(D) [/B][/COLOR][COLOR=royalblue][B]Column(E)     [/B][/COLOR][COLOR=royalblue][B]Column(F)        [/B][/COLOR] [COLOR=royalblue][B]Column(G)                              [/B][/COLOR]
Period -->  45          rate -->   0.08       Principle -->  1300                                                     
                                              =+A3*1300      =+G3-E3           =$F$1*(((((1+$D$1)^(A3+1))-1)/$D$1)-1) 
1           01/01/2008  -          $1,300     1300           104.000000000002  1404                                   
2           01/01/2009             $1,300     2600           320.320000000003  2920.32                                
3           01/01/2010             $1,300     3900           657.945600000005  4557.9456                              
4           01/01/2011             $1,300     5200           1126.581248       6326.58124800001                       
5           01/01/2012             $1,300     6500           1736.70774784001  8236.70774784001                       
6           01/01/2013             $1,300     7800           2499.64436766721  10299.6443676672                       
7           01/01/2014             $1,300     9100           3427.61591708059  12527.6159170806                       
8                                             10400          4533.82519044704  14933.825190447                        
9                                             11700          5832.5312056828   17532.5312056828                       
10                                            13000          7339.13370213742  20339.1337021374                       
11                                            14300          9070.26439830842  23370.2643983084                       
12                                            15600          11043.8855501731  26643.8855501731

Regards Mick

[/QUOTE]