Appendix B Summary of Excel Programs
Accumulated value of a series of deposits:
| 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) |
Adding fractions:
| A1 | n1 |
| A2 | d1 |
| B1 | n2 |
| B2 | d2 |
| C1 | =SUM(A1*B2)+(A2*B1) |
| D1 | =SUM(A2*B2) |
After-tax return:
| A1 | O |
| B1 | T (in decimal form) |
| C1 | =SUM(1-B1)*A1 |
Amortization:
| A1 | C |
| B1 | M |
| C1 | =SUM(A1/B1) |
Annual compounding:
| 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 ... |
Get Math for Managers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
