Principal, P Annual Rate, r Compounding Periods per Year, n Interest Rate per Compounding Period, i  
$989.98 0.04 12 Text Box: Quantities in blue are used to initialize the accumulated amount table
0.003333333
 
         
Compounding Period, k Date Interest Added Accumulated Amount  
0 1-Jan-08 $0.00 $989.98  
1 1-Feb-08 $3.30 $993.28  
2 1-Mar-08 $3.31 $996.59  
3 1-Apr-08 $3.32 $999.91  
4 1-May-08 $3.33 $1,003.25  
5 1-Jun-08 $3.34 $1,006.59  
6 1-Jul-08 $3.36 $1,009.95  
7 1-Aug-08 $3.37 $1,013.31  
8 1-Sep-08 $3.38 $1,016.69  
9 1-Oct-08 $3.39 $1,020.08  
10 1-Nov-08 $3.40 $1,023.48  
11 1-Dec-08 $3.41 $1,026.89  
12 1-Jan-09 $3.42 $1,030.31  
13 1-Feb-09 $3.43 $1,033.75  
14 1-Mar-09 $3.45 $1,037.19  
15 1-Apr-09 $3.46 $1,040.65  
16 1-May-09 $3.47 $1,044.12  
17 1-Jun-09 $3.48 $1,047.60  
18 1-Jul-09 $3.49 $1,051.09  
19 1-Aug-09 $3.50 $1,054.60  
20 1-Sep-09 $3.52 $1,058.11  
21 1-Oct-09 $3.53 $1,061.64  
22 1-Nov-09 $3.54 $1,065.18  
23 1-Dec-09 $3.55 $1,068.73  
24 1-Jan-10 $3.56 $1,072.29  
Text Box: Blue Boxes are given information
Text Box: Light blue is calculated using a formula Text Box: Yellow is initialization row
Text Box: Green is formula row--copy and paste this row to get the table.
Text Box: This table replaces the compound interest formula:

A = P(1+i)^k, where i=r/n and k is the number of compounding periods
   = $989.98*(1+0.04/12)^(24)
   = $1072.29