Working with Excel

Index

A

ABS function, 51

Absolute value, 51

Amortization schedule

building, 124–126, 125t

updating with tax savings, 126–128, 127t

Arithmetic mean, 33–34

AVERAGE function, 33–34

B

Binomials, expanding, 5f

Bivariate quantitative variable, 92

Breakeven analysis, 99–103

Breakeven point, 101

C

Capital investment decision model, 113–118, 114t, 115t

Column chart

qualitative variable, 80–81, 80f

quantitative variable, 85–86, 85f

Combination

COMBIN function, 51–52

equation, 51

Compound interest

future value, 23–24

future value of ordinary annuity, 27–28. See FV

present value, 25–26

present value of ordinary annuity, 29–30. See PV

Cost model

average cost, 101–102, 102t, 102f

fixed vs. variable, 98–100, 99t, 99f, 100t, 101, 105, 106f

COUNT function, ...