Tips & Tricks for Excel-Based Financial Modeling, Volume I

Index

Amortization, 41

Analysis tab, 19

AND function, 117–119

Annual equivalent value, 55–56

As of Date, 39

AutoFill Formulas, 110–111

AutoFill Sequences, 109–110

AVERAGEIF function, 75–77

AVERAGEIFS function, 75–77

Calculation, 17

Capital expenditure (CAPEX), 40

Capital investment, 42–44

Cash inflow, 40

Cash outflow, 40

Cell, 4

CELL function, 83–85

Changes tab, 22–24

CHOOSE function, 134–136

CIT. See Corporate income tax

Color coding, 36–37

Columns, 4

Comments tab, 20–22

CONCATENATE function, 97–99

Connections tab, 18

Control keys, 31–32

Corporate income tax (CIT), 42

COUNTIF function, 77–79

COUNTIFS function, 77–79

Cumulative discounted net cash flow, 42

Cumulative net cash flow, 42

Currency signs or units, 37

Data evaluation

CHOOSE function, ...