This course will combine practical and up-to-date investment theory with modeling applications. Understanding beautiful theory, without the ability to apply it, is essentially useless. Conversely, creating state-of-the-art spreadsheets that apply incorrect theory is a waste of time. Here, we try to explicitly combine theory and application. The course will be divided into 6 modules, or topics. The first day of each module will be a lecture on an investment topic. Also provided is a team modeling project on the topic. The second day of each module will be a lab. The lab day will begin with modeling concepts (tips) designed to help you use Excel to implement the module's investment topic. After the tips are provided, the remainder of the lab day is devoted to teams working on their modeling project and allowing for Q&A. On the third day of each module will be presentations and wrap-up.
3 units · GSB Letter Graded
This course will combine practical and up-to-date investment theory with modeling applications. Understanding beautiful theory, without the ability to apply it, is essentially useless. Conversely, creating state-of-the-art spreadsheets that apply incorrect theory is a waste of time. Here, we try to explicitly combine theory and application. The course will be divided into 6 modules, or topics. The first day of each module will be a lecture on an investment topic. Also provided is a team modeling project on the topic. The second day of each module will be a lab. The lab day will begin with modeling concepts (tips) designed to help you use Excel to implement the module's investment topic. After the tips are provided, the remainder of the lab day is devoted to teams working on their modeling project and allowing for Q&A. On the third day of each module will be presentations and wrap-up.
Offered in Spring 2026 at Stanford University.