How would I put the below details into an excel spreadsheet?
Year 1 - £350,000 target with a 30% margin, 100 clients
Year 2 - £700,000 target with a 27% margin, 250 clients
Year 3 - £1,000,000 target with a 25% margin, 300 clients
I am selling to private clients, brokers, retail and on-trade too and there needs to be consistent income month on month, with gradual build.
Ideally there needs to be a monthly split and repeat sales performance from each customer
Work off average private client price of £30 ex vat, average broker price £35 ex vat , average on-trade £13 ex vat, average retail of £17 ex vat.