Investment Analysis with Excel & VBA (Fall, 2012)

  Course Number: FIN 206f
Call Number: 10998
Instructor(s): Raviv, Alon
Time(s): M,W 11:00 - 12:30 PM; Lemberg, 55
Description: 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.
Documents:
Syllabus
Course Quick Links
Find Schedules, Descriptions and Module Dates.
Course Evaluations