Revenue & MRR
Monthly revenue and closing recurring revenue
BrightPath Software · 40 employees · USD
Monthly revenue and closing recurring revenue
Closing cash balance across actuals and forecast
Adjust monthly growth and churn to model the next 12 months.
October 2027 ending MRR
Both sliders use opening MRR. Gross growth adds new subscriptions and expansion. Churn removes recurring revenue. Each month’s closing MRR becomes the next month’s opening MRR.
Subscription revenue uses the average of opening and closing MRR. Monthly revenue also includes implementation services. The forecast holds services at their August–October 2026 average and headcount at 40.
Historical operating costs include $11,000 per employee per month, $48,000 in fixed overhead, and variable costs equal to 9.5% of revenue. The forecast increases combined staffing and fixed overhead costs by 0.6% each month. Variable costs continue at 9.5% of revenue.
Net burn equals operating costs less revenue. Cash collection and payment occur in the same month. Closing cash equals opening cash less net burn. January 2025 opens with $5.30M cash and $148,000 MRR. Negative projected cash indicates a funding gap. Calculations round monthly amounts to whole dollars.
Bear and bull shift base growth by ±2 percentage points and churn by ∓0.8 points, with a floor of zero.
| Scenario | Gross growth / mo | Churn / mo | 12-month revenue | Ending MRR | Ending cash |
|---|
Month-end balances and operating metrics in USD.
| Month | Revenue | Closing MRR | MRR churn | Net burn | Closing cash | Headcount |
|---|