Investment Analysis with Excel and VBA (Spring, 2012)
FIN 206f (1)
M, W 02:00 - 03:30 PM; Sachar, Int'l Hall, 116
Prerequisite: FIN 201a or FIN 205a. Meets for one-half semester and yields half-course credit.
Connects textbook finance with real-world business by providing a nuts-and-bolts guide to solving common models with spreadsheets and Visual Basic for Excel. It will cover three topics: portfolio optimization (including the Black- Litterman model), modeling the term structure of interest rates and pricing models for risky debt, and advanced computational techniques for options (including Monte Carlo methods). Usually offered every year.