Lesson 1Detailed revenue drivers and segmentation: volume, pricing, product mix, geographic rollouts, TAM/SAM/SOM linkageDis part explain revenue drivers like volume, price, and mix fine-fine, and show how to divide by product, channel, and place, while connect TAM, SAM, SOM to detailed revenue plans and rollout time in de 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 amortization: useful life assumptions, maintenance vs growth CapExDis part show how to predict CapEx, separate maintenance from growth spending, and model depreciation and amortization using useful life, leftover value, and tax rules, make sure fixed asset schedules match financial statements proper.
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 controlDis part talk about model build, stress clear separate of inputs, calculations, and outputs, same formatting, labeling, and version control wey help team work, clear see, and easy update model.
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 effectsDis part focus on predict working capital parts like receivables, inventory, payables using days and turnover ratios, and put in season changes, growth, policy shift into cash flow and funding need.
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 costsDis part explain how to predict operating items like revenue-link and fixed costs, margins, operating leverage, and turn business drivers to detailed cost plans wey match project financial 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: modeling existing debt facilities, covenants, refinancing assumptionsDis part cover model old and new debt, include pay down, interest calc, fees, covenants, and show how to put refinancing, bullet pay, capital structure change in cash flow statement 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 computationDis part show how to get cash flow statement from project income statement and balance sheet data, separate operating, investing, financing flow, and calc free cash flow for valuation, credit, inside decision.
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 togglesDis part build system model checks like balance sheet balance, cash flow match, circular handle, and bring error flags, sense tests, scenario switch 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 techniquesDis part compare top-down and bottom-up revenue forecast, show when each good, how to match dem, and turn strategy plan, market data, sales pipe to structure time-base revenue 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
