Pacing: 1 Hour | Every Other Day | 7 Weeks (24 Sessions) Goal: Institutional-grade corporate finance readiness for LDP execution.
Navigation without a mouse. Institutional color coding (Blue=Hardcode, Black=Formula, Green=Links). Setting up the grid.
Isolating assumptions. IF, AND, OR statements. Building nested logic without making it fragile.
Retiring VLOOKUP. Mastering INDEX/MATCH and XLOOKUP for dynamic data retrieval.
SUMIFS, COUNTIFS. Creating dynamic timeline headers using EOMONTH and EDATE (crucial for forecasting).
Price x Volume logic. Modeling a MedTech product (capital equipment + recurring consumables).
Fixed vs. Variable costs. Building headcount drivers and margin analysis.
Modeling Days Sales Outstanding (DSO), Inventory (DIO), and Payables (DPO). The reality of cash flow.
Flowing Revenue and OpEx into a clean P&L. Calculating EBITDA.
Beginning + Additions - Subtractions = Ending. Modeling the useful life of assets.
Modeling a revolver, term loans, and calculating interest expense.
Assembling Assets, Liabilities, and Equity. Setting up the balancing mechanism.
The bridge between P&L and Balance Sheet. Operating, Investing, and Financing flows.
Tying it all together. Handling the interest expense circular reference with a circuit breaker (toggle).
NPV, IRR, and XIRR. Understanding how timing changes investment decisions.
Calculating the hurdle rate for a corporate project or acquisition.
Calculating Unlevered Free Cash Flow (UFCF) and discounting it to present value.
Gordon Growth vs. Exit Multiple methods. Bridging Enterprise Value to Equity Value.
Building Base, Upside, and Downside cases using CHOOSE or INDEX functions.
1-way and 2-way data tables to show how changing assumptions (e.g., price and volume) impact IRR.
Building clean, executive-ready charts. Bridge/Waterfall charts for EBITDA.
CAC, LTV, and payback periods applied to a remote patient monitoring (RPM) model.
Trace precedents/dependents. Hunting down #REF! and #DIV/0! errors.
Building a single-pane-of-glass dashboard for decision makers (the "One-Page Summary" Rune in practice).
Building a mini-model from blank sheet to DCF in under 60 minutes. You driving.