Lesson 1Detailed revenue drivers and segmentation: volume, pricing, product mix, geographic rollouts, TAM/SAM/SOM linkageThis bit breaks down revenue drivers like volume, price, and mix, and shows segmenting by product, channel, and area, linking TAM, SAM, SOM to detailed revenue plans and rollout times in the model.
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 amortisation: useful life assumptions, maintenance vs growth CapExThis part explains forecasting CapEx, sorting maintenance from growth spend, and modelling depreciation and amortisation with useful life, leftover value, and tax rules, keeping fixed assets in line with statements.
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 covers model build, stressing clear split of inputs, calculations, and results, steady formatting, labels, and version control for teamwork, openness, and quick updates.
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 focuses on predicting working capital bits like receivables, stock, payables using days and turnover rates, folding in seasons, growth, and policy shifts into cash flow 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 5Modelling operating items: forecasting margins, operating leverage, fixed vs variable costsThis explains forecasting operating items, revenue-tied and fixed costs, margins, leverage, turning business drivers into detailed cost plans that match projected statements.
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: modelling existing debt facilities, covenants, refinancing assumptionsThis covers modelling current and new debt, payoffs, interest calcs, fees, covenants, showing refinancing, lump sums, structure changes in cash flow and balance sheet.
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 shows pulling cash flow statement from projected income and balance data, splitting operating, investing, financing flows, calculating free cash for valuation, credit, decisions.
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 builds steady model checks like balance matching, cash reconciliation, loops, with error flags, sense tests, scenario switches to keep model solid 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 compares top-down and bottom-up revenue forecasts, when each fits, matching them, turning plans, market data, sales into structured, time-based revenue schedules.
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
