Sam O.

asked • 02/18/21

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.


1 Expert Answer


Marc D. answered • 03/08/21

5 (1)

Engaging and patient Master of Applied Mathematics.

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.


Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.