OPEN EDUCATION RESOURCE · 17 VIDEOS · FREE
Financial modeling, taught the way it actually gets used.
A free 17-part video course from Dr. Albert Kamienski that walks you, line-by-line, through building a real Excel model. Assumptions, three statements, valuation, and sensitivity analysis.
17
video lessons
6h 42m
of teaching
4
downloadable workbooks
THE COURSE
Four modules. Seventeen videos. One real model.
MODULE 01
Foundations
What a model is, what it isn't, and the discipline of clean assumptions.
4 LESSONS1h 14m
MODULE 02
The Three Statements
Income statement, balance sheet, and cash flow, wired together properly.
5 LESSONS2h 02m
MODULE 03
Valuation
DCF mechanics, terminal value, and choosing a discount rate you can defend.
4 LESSONS1h 38m
MODULE 04
Sensitivity & Capstone
Data tables, scenario toggles, and a full LBO build from a blank sheet.
4 LESSONS1h 48m
WHAT YOU WILL BUILD
A working LBO model, one cell at a time.
By the end of the series you will have built a complete leveraged buyout model from a blank workbook. Every formula is shown on screen. Every assumption is explained out loud.
✓
Source-and-uses with funding flexibility✓
Three integrated statements with a circular plug✓
DCF and exit-multiple valuation side-by-side✓
Two-variable sensitivity tablesLBO_Model_Capstone.xlsx
FileHomeInsertFormulasData
fx=SUM(B2:B4)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Sources & Uses | ||||
| 2 | Sponsor Equity | $120.0 | $120.0 | $120.0 | $120.0 |
| 3 | Senior Debt | $280.0 | $280.0 | $280.0 | $280.0 |
| 4 | Mezzanine | $80.0 | $80.0 | $80.0 | $80.0 |
| 5 | Total Sources | $480.0 | $480.0 | $480.0 | $480.0 |
| 6 | Purchase Price | $450.0 | |||
| 7 | Fees & Exp | $30.0 | |||
| 8 | IRR | 24.3% |
FREELY AVAILABLE THROUGH
An OER funded in partnership with Illinois libraries
GRANT 2024
CARLI
Consortium of Academic and Research Libraries in Illinois
Open Educational Resources grant program supporting freely-licensed teaching materials.
STATE FUNDING
Illinois State Library
A Division of the Office of the Secretary of State
Coordinates statewide library services and funds educational outreach.
INSTITUTIONAL
North Park University
School of Business and Nonprofit Management
Faculty support and recording facilities provided by NPU's Chicago campus.