Skip to Main Content
Math for Managers
book

Math for Managers

by Michael C. Thomsett
November 2018
Intermediate to advanced content levelIntermediate to advanced
286 pages
6h 47m
English
De Gruyter
Content preview from Math for Managers

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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Financial Mathematics

Financial Mathematics

Giuseppe Campolieti, Roman N. Makarov
How to Overcome a Power Deficit

How to Overcome a Power Deficit

Cyril Bouquet, Jean-Louis Barsoux

Publisher Resources

ISBN: 9781547400652