I would like a sales spreadsheet which is quite complex.
We sell marketing packages which cost businesses £199 per month.
We are forecasting 30 sales per month with the sales man getting 100% commission on the first months payment and £30 per month retention.
We forecast to churn 5% of total customers per month.
The commission retention goes to £10 after 12 months of each customer cycle.
I would like a 3 year plan showing P/L based on the numbers given.