Part 1 Corporate finance models: financial statement modelling; using financial statement models for valuation; the financial analysis of leasing; the financial analysis of leveraged leases. Part 2 Portfolio models: portfolio models - introduction; calculating the variance-covariance matrix; calculating efficient portfolios when there are not short sale restrictions; estimating Betas and the security market line; efficient portfolios without short sales. Part 3 Option pricing models: an introduction to Options; the binomial option-pricing model; the Longnormal distribution; the Black-Scholes model; portfolio insurance. Part 4 Bonds and duration: duration; immunization strategies; calculating default-adjusted expected bond returns; duration and the cheapest-to-deliver- problem for treasury bond futures contracts. Part 5 Technical considerations: generating random numbers; data table commands; matrices; the Gauss-Seidel method; Excel functions. Part 6 Introduction to Visual Basic for Applications: programming in Microsoft Excel; introduction to User-Defined functions in Visual-Basic for Applications.
Table of Contents
