MBA 522
Download as PDF
Financial Modeling
Course Description
Use spreadsheets to value businesses and structure deals, including mergers and acquisitions, leverage buyouts, private equity, and venture capital; retrieve and interpret financial data; build discounted cash flow, market comparable, and precedent transaction valuation models.
When Taught
Winter
Min
3
Fixed/Max
3
Fixed
3
Fixed
0
Title
Valuation
Learning Outcome
Utilize various model types in an Excel-based financial model in order to value public companies.
Title
Data
Learning Outcome
Translate publicly available company data into a working, dynamic financial model in Excel.
Title
Scenario Analysis
Learning Outcome
Analyze impacts of different model scenarios and justify assumptions that drive a financial model.
Title
Advanced Excel
Learning Outcome
Demonstrate advanced use of Microsoft Excel, including extensive use of keyboard shortcuts, complex functions, and forecasting tools.
