November 2018
Intermediate to advanced
286 pages
6h 47m
English
| A1 | Deposits |
| B1 | =SUM(1+Rate) |
| C1 | =B1 |
| B2 | =B1 |
| C2 | =SUM(C1*B2) |
Copy B and C, row 3 Paste to subsequent B and C rows
| D36 | =SUM(C36-1)/(C1-1) |
| E36 | =SUM(D36*A1) |
| A1 | n1 |
| A2 | d1 |
| B1 | n2 |
| B2 | d2 |
| C1 | =SUM(A1*B2)+(A2*B1) |
| D1 | =SUM(A2*B2) |
| A1 | O |
| B1 | T (in decimal form) |
| C1 | =SUM(1-B1)*A1 |
| A1 | C |
| B1 | M |
| C1 | =SUM(A1/B1) |
| A1 | Annual interest rate plus 1 | =SUM(i+1) |
| B1 | Principal amount | |
| C1 | Accumulated amount | = SUM(A1*B1) |
| A2 | =A1 | |
| B2 | =C1 |
To perform this Excel calculation, do the following:
| 3. | Copy C1 |
| 4. | Paste to C2 |
| 5. | Copy A2, B2, and C2 |
| 6. | Paste to rows 3, columns 1, 2, and 3 |
| 7. | Repeat paste for ... |