MBA 522
Download as PDF
Financial Modeling
Business
Marriott School of Business
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.
