333-403 Numerical Techniques in Finance

Students may not gain credit for both 333-403 Numerical Techniques in Finance and 306-468 Numerical Techniques in Finance.

333-301 Investments.

Topics include the use of Microsoft Excel at an advanced level, including the use of inbuilt functions and data modelling tools such as Goalseek and Solver; programming in Microsoft Visual Basic for Applications, including the writing of functions and subroutines, interface design and output generation; computer accuracy, stability and convergence; interpolation and approximation procedures; methods of numerical search, Monte Carlo methods; numerical integration techniques; and solution methods for systems of equations. Applications include models of the term structure of interest rates, option pricing, valuation of bond options, implied option volatility, the dynamics of portfolio insurance programmes, portfolio simulation, portfolio optimisation, the composition of stock plus warrant packages of known value, determination of internal rates of return, and capital budgeting.

A 3-hour end-of-semester examination (50%) and computer oriented assignments (50%).