Lesson 1Profit and Cash Flow Simple Ways: Easy Monthly Gross Profit Lines and Running Profit; Basic Cash Flow Things (Delayed Income, Collection Delay)Build simple but helpful monthly profit and cash views, including gross profit, running profit, and basic cash flow drivers like collection delay, delayed income, and payment times for big cost groups.
Modeling revenue, COGS, and gross marginEstimating operating expenses and EBITDACollections lag and accounts receivable logicDeferred revenue and prepayment handlingCash timing for payroll and vendor paymentsLesson 2Case and Feeling Setup: Setting Up Case Switches, Data Tables, and One-Click Changes for Other IdeasLook at good ways to test other ideas using case switches, driver cells, and data tables, allowing one-click check of bad, normal, and good cases without breaking the main model ways.
Defining base, downside, and upside casesBuilding scenario selector and driver cellsUsing Excel and Sheets data tables safelyDesigning one-click assumption switchoversTracking and documenting scenario changesLesson 3Customer Flow and Group Modeling: Simple Group Setup, Keeping Curves, Group-Based Income vs Total WaysUnderstand how to model customer moves over time using groups, from getting to leaving and growth, and compare group-based income plans with easier total ways for different business types.
Mapping customer lifecycle and key statesSetting up monthly acquisition cohortsDesigning and applying retention curvesModeling expansion, downgrades, and churnComparing cohort vs aggregate revenueLesson 4Picking the Sheet Tool and File Ways: Google Sheets vs Excel Online, Naming and Folder SetupChoose between Google Sheets and Excel Online for working together, speed, and links, then set clear file naming, versions, and folder setups that keep your 12-month plan in order and checkable.
Comparing Google Sheets and Excel OnlineCollaboration, permissions, and access controlPerformance limits and add-in integrationsFile naming and versioning standardsFolder structure for models and exportsLesson 5Model Strength and Use Again: Using Named Areas, Set Input Table, Split of Inputs/Calcs/OutputsUse best ways for modeling that make your plan strong and usable again, including named areas, set input tables, same formulas, and strict split of inputs, counts, and report outputs.
Using named ranges and structured referencesSeparating inputs, calculations, and outputsColor-coding and labeling modeling conventionsError checks, alerts, and reasonableness testsPreparing the model for reuse and handoffLesson 6Income Counts: Link Between New MRR, Growth, Leaving; Monthly MRR Forward Formulas and ARR ChangeLearn to link new sales, growth, and leaving into a monthly MRR forward, change MRR to ARR, and match income with customer numbers, making sure formulas are clear, testable, and easy to check.
Defining MRR, ARR, and related metricsLinking new, expansion, and churned MRRBuilding monthly MRR roll-forward schedulesConverting MRR to ARR and revenue linesReconciling revenue with customer countsLesson 7Book Setup: Suggested Tabs (Ideas, Input Board, Monthly Income Plan, Customer Flow/Groups, Cost Plan, P&L Summary, Feeling Cases, Check and Logs)Design a clean book layout with special tabs for ideas, inputs, income, customers, costs, P&L, and cases, making sure flows are the same, easy to move, and split between counts and showing.
Standard tab list and naming conventionsAssumptions and input dashboard structureMonthly revenue and customer flow schedulesCost schedules and P&L summary layoutScenario, audit, and log worksheet designLesson 8Main Inputs and Cases: Defining and Setting Key Ideas (Starting MRR, New MRR Growth, Leaving, ARPA, Price Levels, Season Changes)Define and set the main business drivers for your plan, including starting MRR, new sales, leaving, price levels, ARPA, and season changes, and learn how to set them for easy updates and case use.
Identifying essential revenue driver inputsCapturing starting MRR and opening balancesModeling new MRR growth and sales capacityRepresenting churn, downgrades, and reactivationHandling ARPA, pricing tiers, and seasonalityLesson 9Cost Modeling: Modeling Salaries, Hosting, Marketing, and Tools by Month; Mapping Hires and Rise; Changing Costs Tied to Use or IncomeLearn how to turn people plans, seller deals, and marketing plans into a monthly cost model, including fixed and changing costs, hiring rises, and use-based costs that grow with income or work.
Classifying fixed vs variable operating costsModeling salary, benefits, and payroll taxesPlanning hiring dates, ramps, and backfillsScheduling marketing, software, and hosting spendLinking variable costs to usage or revenue
