Index

add-in 47

American option 221, 233

annuity 57, 75

annuity loan 59, 69

application event 377

arbitrage 197

argument 357

arithmetic operator 292

array 382

array as parameter 392

array element 382

array formula 21, 247

assertion 343

asset 121

assignment statement 275

autofill 11

AVERAGE 80, 128

backstage view 4

bear spread 236

beta 107, 125, 130

binary search 399

BINOM.INV 244

BINOMDIST 229

binomial distribution 45, 243

binomial model 226, 251

Black-Sholes model 231

bond 166

breakpoint 342

bull spread 225

butterfly 237

call option 221

call-by-reference 360

call-by-value 357

capital gain 140

capital market line 99, 104

capitalization rate 149

CAPM 107, 125, 201

cash flow 64, 133, 150

cash flow matching 182

central limit theorem 231

chart

Get Financial Modelling and Asset Valuation with Excel now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.