I have switched this class to be fully in-person. You can continue to attend remotely if you prefer to do so. Please read this important note about in-person classes by clicking here.

Overview

Fall 2020:

MBA ACCT-GB-3304 Specializations:

Various management disciplines teach you how to analyze and forecast parts of a business. Building on this foundation, this course will help you weave your forecasts into coherent spreadsheet-based pro-forma financials. Modeling financial statements provides a reality check on the forecasts, enables “what if” analysis, provides an integrated view of the business, and is a key step in valuation and credit risk analysis.

The course is indispensable to careers in investment banking, private equity, buy-side or sell-side research, credit research, corporate finance, valuation, project finance, and due diligence advisory. First-year and second-year students can both take this course. The course gives a significant competitive edge during interviews, internships, and jobs.

Help and Office

Prerequisites

Administrative Issues

Materials and Course Design

Almaris Assignments

Exams and Grading

Important computer tips for the final

Schedule

Module Topic
1

Deriving cash flows, enterprise or unlevered cash flows

2

Building blocks of models; Linking cash flow forecasts to value

3

Designing models, Customers; Suppliers, employees, and other expenses

4

Multiperiod models: Long-term accruals and deferrals

5

Excel tools for scenario analysis; Capacity: PP&E and depreciation

6

Modeling taxes

7

Modeling financing

8

Time value of money and bonds

9

Integrative analysis

10

Which cash flows should one discount

11

Prioritizing assumptions in models; sensitivity analysis