MGT 8813: Financial Modeling

Instructional Team

Jacqueline Garner
Jacqueline Garner
Creator, Instructor

Overview

This course is intended to prepare students to build financial models and make business decisions based on the understanding of finance theory and the utilization of analytical models. Therefore, two broad learning objectives exist or this course:

  • Finance-based learning objectives—Where students will be required to understand basic time value of money principles as well as finance theory such as portfolio optimization and firm valuation.
  • Excel/modeling based learning objectives—Where students will be required to learn/use Excel functions and tools. Many of these tools and functions will be used to build financial models.

Course Goals

Once completed, the student should have the following capabilities:

  • Create cash flow statements
  • Describe basic time value of money (TVM) and use Excel to solve any TVM problem
  • Build a basic firm valuation model, free cash flow to the firm
  • Build an equity valuation model, free cash flow to equity
  • Build an adjusted present value model, APV model
  • Compute a firm’s weighted average cost of capital
  • Build a comparable firm analysis and football field graph
  • Build basic VBA models
  • Construct a Black-Scholes option pricing model
  • Construct stock portfolio analysis

Sample Syllabus

Fall 2025 syllabus (PDF)

Note: Sample syllabi are provided for informational purposes only. For the most up-to-date information, consult the official course documentation.

Before Taking This Class...

Suggested Background Knowledge

It is recommended that students complete MGT 8803/6754 prior to taking this course.

Technical Requirements and Software

Students will need access to a computer with Microsoft Excel, Toolpak, and Solver (which are available to all Georgia Tech students).

Academic Integrity

All Georgia Tech students are expected to uphold the Georgia Tech Academic Honor Code. This course may impose additional academic integrity stipulations; consult the official course documentation for more information.