A 36-month model for projecting subscription revenue, costs, profit, and cash under three scenarios. Use it to plan hiring and spending, track cash needs, and compare financial outcomes when revenue assumptions change.
AssumptionsEnter the starting figures and monthly drivers for revenue, costs, and cash.
ARR forecastBuild monthly recurring revenue from new sales, customer expansion, and revenue lost to churn or contraction.
HeadcountList each role or group of similar roles, with department, pay, and employment dates.
Operating expensesEnter non-payroll costs by month and department.
Monthly P&LReview monthly revenue, delivery costs, gross profit, operating expenses, and operating income.
Cash runwayTrack cash receipts and payments to find the lowest cash balance and the month cash may run out.
ScenariosCompare Low, Base, and High outcomes while holding the hiring and spending plan constant.