A small business forecast

A subscription business month by month: customers, revenue, the cost of serving them, salaries as the team grows, rent, marketing, and the cash left in the bank. Change the assumptions and the whole spreadsheet recomputes; click any number or role to see the calculation behind it.

Loading the data app. Its results and Why buttons work once it has computed.

With these assumptions the business ends the forecast with in the bank. Cash , and the lowest it gets is .

Customers and revenue

linked
linked
linked
linked
linked
linked

Cash, team and costs

linked
linked
linked
linked
linked
linked

Month by month

Forecast

Click any number, role, month or hire in a table to see where it comes from.

Cash over the forecast
—
  • Casha projection from Cash at month end

Hiring plan

Hires

Your views