Financial Modeling

The objective of this course is to teach students the fundamentals and practice of building financial models by using Microsoft Excel. Students become familiar with the built-in functions of Excel and learn how to use them in financial model building with a hands-on approach. The topics covered in the course include financial statement modeling, cost of capital, capital budgeting modeling, leasing, valuation analysis, portfolio modeling, capital-asset pricing models, option-pricing models, real options modeling, bonds, and term structure modeling.