Lesson 1Detailed revenue drivers and segmentation: volume, pricing, product mix, geographic rollouts, TAM/SAM/SOM linkageDis part detail revenue drivers like volume, price, an mix, an show how fi segment by product, channel, geography, linking TAM, SAM, SOM to revenue schedules an rollout timing in di 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 explain how fi forecast CapEx, split maintenance vs growth spending, an model depreciation an amortization using useful life, residual value, tax rules, keeping fixed assets consistent wid 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 controlDis part tackle model setup, stressing clear split of inputs, workings, outputs, consistent format, labeling, an version control fi collaboration, clearness, an easy 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 effectsDis part focus pon forecasting working capital like receivables, inventory, payables using days an turnover, adding seasonality, growth, policy changes to cash flow an funding.
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 fi forecast operating items, revenue-linked an fixed costs, margins, operating leverage, turning business drivers into cost schedules weh 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: modeling existing debt facilities, covenants, refinancing assumptionsDis part cover modeling existing an new debt, amortization, interest, fees, covenants, showing refinancing, bullet repayments, capital changes in cash flow an 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 fi build cash flow statement from projected income an balance sheet, splitting operating, investing, financing flows, computing free cash flow fi valuation an 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 togglesDis part build systematic model checks like balance sheet balancing, cash flow reconcile, circularity handling, error flags, tests, scenario toggles fi 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 techniquesDis part compare top-down an bottom-up revenue forecasting, when each good, how fi reconcile, turn strategic plans, market data, sales into structured 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
