Applied Finance

This course develops advanced skills for applying the core concepts of finance to the real world. Building on skills developed in the core finance, accounting and data analysis courses, this course provides an extensive opportunity to implement finance theory at a practical level, and to develop advanced analytical spreadsheet modeling expertise.

Upon completion of this course, you should have a deeper understanding of firm valuation techniques, bond pricing, portfolio selection and financial engineering. Along the way, you will also develop advanced experience with spreadsheet modeling. Spreadsheets are the primary modeling tool used by most finance professionals. By the end of this course, you should be able to build both simple and complex financial models using spreadsheets. The best way to build proficiency in modeling is to practice it. To this end, the course contains five individual spreadsheet assignments, as well as a group valuation project. The course will include extensive use of spreadsheet models in class.