Financial Modeling and Valuation

2 Credits.

The objective of this course is to introduce students to the current practices in financial modeling and valuation using Excel. Students will learn how to manipulate financial data and how to perform financial analyses using various analytical tools. Using the skills, students will learn how to forecast financial statements and build interactive valuation models for firms. By the end of the course, students will complete an equity research paper. One important aspect of this course is also to introduce students to portfolio modeling, efficient frontiers, and portfolio choice subject to constraints.