Modeling Financial Statements: ACCT-GB.3304


Disclaimers Prerequisites Bio Overview Help Materials Assignments Grading Schedule


Contrary to the official calendar, there will be class on Monday, October 9. [There is no good reason not to have a class that day.] Therefore, the last class will be December 11. The last class will have the final exam.


Fall: Monday evening

Winter: None [This is different from prior years.]

Spring: M-W morning, M-W afternoon, W evening

Summer: None


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 and projecting comprehensive 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.


The course will start from conceptual examples that illustrate the key intuition and explain linkages between financial statements. It will then build on these examples to forecast the financial statements of real companies.


This course is highly relevant to if you are pursuing any career that requires you to understand or build models. Examples of such careers are investment banking, private equity, buy-side or sell-side research, credit research, corporate finance, and valuation. First year and second year students can both take this course. Those who took it in their first year have told me that this course gave them a significant competitive edge during their interviews and summer internships.



Help and Office

Materials and Course Design

Almaris Assignments

Exams and Grading

Important computer tips for the final



Module Topic
  • Deriving cash flows, enterprise or unlevered cash flows
  • Building blocks of models; Linking cash flow forecasts to value
  • Designing models, Customers; Suppliers, employees, and other expenses
  • Multiperiod models: Long-term accruals and deferrals
  • Excel tools for scenario analysis; Capacity: PP&E and depreciation
  • Modeling taxes
  • Modeling financing, Time value of money and bonds
  • Integrative analysis
  • Which cash flows should one discount, Integrated models, Prioritizing assumptions in models; sensitivity analysis
  • Adjusting models for capitalized leases
  • Mergers and acquisitions