Lesson 1Detailed revenue drivers and segmentation: volume, pricing, product mix, geographic rollouts, TAM/SAM/SOM linkageThis part breaks down sales drivers like amount, price, and mix, and shows splitting by product, way to sell, and place, while tying big market chances to detailed sales plans and rollout times.
Modeling volume, price, and product mix impactsBuilding product and customer segment revenue bridgesGeographic rollout timing and ramp-up curvesTranslating TAM, SAM, SOM into revenue linesLesson 2CapEx, depreciation, and amortization: useful life assumptions, maintenance vs growth CapExThis part shows how to guess CapEx, sort keep-up from grow spending, and model wear-down using life length, leftover worth, and tax rules, keeping fixed things in line with money papers.
Separating maintenance and growth CapEx itemsBuilding fixed asset roll-forward schedulesChoosing useful lives and residual value policiesModeling depreciation and amortization for taxLesson 3Model design and layout: inputs, workings, outputs separation and version controlThis part covers model setup, stressing clear split of inputs, work, and results, steady looks, names, and version keeping that help team work, openness, and quick model fixes.
Separating inputs, workings, and outputs tabsStandardizing formats, labels, and time structureDocumentation and annotation within the modelVersion control and change tracking methodsLesson 4Working capital modelling: receivables, inventory, payables days and cyclical effectsThis part looks at guessing working capital parts like money owed in, stock, money owed out, using days and turn rates, and adds seasons, growth, and rule changes to cash and funding needs.
Modeling receivables using days sales outstandingInventory days, turns, and stock policy changesPayables days and supplier term assumptionsSeasonality and growth impacts on working capitalLesson 5Modeling operating items: forecasting margins, operating leverage, fixed vs variable costsThis part shows how to guess running items like sales-tied and fixed costs, edges, and leverage, and turn business drivers into detailed cost plans that match ahead money papers.
Classifying fixed, variable, and semi-variable costsBuilding driver-based operating cost schedulesForecasting gross and EBITDA margin evolutionAnalyzing operating leverage and break-evenLesson 6Debt, interest, and capital structure: modeling existing debt facilities, covenants, refinancing assumptionsThis part covers modeling old and new debt like pay-down, interest math, fees, and rules, and shows how to show re-funding, lump pays, and capital shifts in cash flow and balance.
Building detailed debt amortization schedulesCalculating cash and PIK interest and feesIncorporating covenants and headroom testsModeling refinancing and leverage scenariosLesson 7Constructing a cash flow statement from projected financials: operating cash flow, investing cash flow, financing cash flow and free cash flow computationThis part shows pulling cash flow paper from ahead income and balance data, splitting running, invest, and fund flows, and working out free cash for valuing, credit, and inside choices.
Deriving operating cash flow from projectionsModeling investing cash flows and CapEx timingModeling financing cash flows and distributionsComputing free cash flow to firm and equityLesson 8Model audit checks and error controls: balance check, circular reference handling, sensitivity flags, scenario togglesThis part builds steady model checks like balance match, cash match, and loop fixes, and adds error signs, sense tests, and what-if switches to keep model strong over time.
Balance sheet and cash flow consistency checksDetecting and managing circular referencesDesigning error flags and reasonableness testsScenario and sensitivity toggles in the modelLesson 9Forecast framework: top-down vs bottom-up revenue forecasting techniquesThis part weighs top-down and bottom-up sales guessing, showing when each fits, how to match them, and turn plans, market info, and sales lines into steady, time-based sales plans.
Designing a top-down market share revenue buildBuilding bottom-up revenue from sales pipeline dataReconciling top-down and bottom-up forecast gapsLinking strategic plans to revenue time series
