more-arw search

Q&A Forum

Does anyone have an MS Excel formula for calculating sales organization commissions for proforma forecasting?

I'm in the process of "evolving" a 5-year proforma model that projects sales commissions as a percentage of the sales organization's base compensation, for a telecom software development company, starting with the EVP of Sales/Marketing, International Regional Directors of Sales/Marketing, Business Development Managers, Sales Engineers/Solution Architects and, finally, the sales personnel working directly and through channels. 

Thanks in advance.


Tom Scott
Title: Principal Consultant
Company: Jerts Consulting & Services
(Principal Consultant, Jerts Consulting & Services) |

Is there some complexity in the commission schedule that you need to build into the formula? Thresholds, aggregate targets, fixed dollar commissions?

I've built tools to calculate fees based some pretty hairy fee schedules, but need more detail on what you need to accomplish in order to help you out.

Perhaps you could provide an example.

Robert Morgan
Title: Managing Director
Company: Paradigm Strategies, LLC
(Managing Director, Paradigm Strategies, LLC) |

Keep it simple as your Pro Forma is also your Company's best judgment. Use the historical % of sales commissions to sales; it could not be more simple than that and probably just as accurate. Robert Morgan {CEO Morgan, Maxwell & Hannah Inc. Consultants for 36 years and author of "Crisis Management Cookbook or how to Keep From Cooking your Goose"}.

Scott Love
Title: CPA
Company: SDL Private Advisors LLC
(CPA, SDL Private Advisors LLC) |

Try this blog. This guy is an Excel master and if you search his blog, I'm sure you'll find what you are looking for. Many examples, dashboards, etc.

Products and Companies

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email [email protected] to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.