Offering 1 to 4

These sheets include all calculations regarding revenue, churn, retention, upgrade, payments and cost of sales for the corresponding offering (1 to 4).

The single most important input on each of these four sheets is the number of new customers per each month (see screenshot). All other values, including churned customers, upgraded customers, existing customers at the end of each period, etc. are automatically calculated based on the specific assumptions you made on the "Inputs" sheet.

Note: In case you are planning (one-time) sales of physical products or services, the description (unit) of this row would be pieces, liters, kg, or person-days sold per period (= month) rather than new customers.

There are two more (optional) input sections on this sheet:

1. In addition to the assumptions made on the "Inputs" sheet, it is possible to manually enter two additional revenue positions (and more rows can easily be inserted if needed). You can either fill in absolute values (= direct input), insert formulas or link in other auxiliary calculations or sheets.

Note: This revenue is cash-effective in the same month. Assumptions for (optional) input/output tax calculation is the same as defined on the "Inputs" sheet for the corresponding offering. It is possible to overwrite these cells on the "Offering 1-4" sheets to fill in individual values.

2.  In the cost of sales section it is also possible to manually enter two additional cost of sales positions (and more rows can easily be inserted if needed). Enter any description in column C and fill in absolute values or formulas for each month (column J to BU).