View the Google Sheet companion template.

Generate a detailed forecast of orders, installed based and GAAP revenue for a subscription business model.

Inputs include unit sales by SKU, pricing changes and upgrade & attrition assumptions for each cohort. All input data and result data are stored in your spreadsheet for privacy. Results are presented in a dashboard format using pivot tables for easy manipulation.

Each forecast is assigned a scenario and multiple scenarios can be saved and compared also using pivot tables.

Installation of this model to your Google Sheet takes about 5 minutes. Configuring the companion spreadsheet with your SKU, pricing and assumption data can take an hour.

We are actively developing this model. If you have enhancement recommendations, please contact us in the Slack help channel.