You will need to build out a Quota Analysis in MS-Excel for a SaaS company using the following base data:

Ongoing Clients 75

Client Attrition Rate for MRR: 30%

Avg MRR from New Business per Rep $ 15,000

Average Deal Size (MRR) $ 12,000

% of SQLs that Close 16%

% MQLs that Become SQLs 9%

# of Reps on Team 5

Avg Growth Deals per Rep per Month 2

Avg MQL per Month 600

Avg MRR from Growth Deals per Rep $ 20,000

1. What is the NEW BUSINESS MRR Current Year $ per Rep?

2. If the goal of 20% increase in NEW Business is set, what is the NEW BUSINESS MRR Quota ($, not closed won deals) per Rep?

3. The company wants an increase of 50% in growth deals. What is the GROWTH DEAL Quota ($) for the existing sales team?

4. The ongoing MRR is forecast to remain stable. What is the ONGOING MRR Quota per rep?

5. What is the TOTAL Quota for the Team? (New Business + Growth Deals + Ongoing)?

AutoSave Sales Home Insert Draw Page Layout Formulas >> Tell me Share Com A % v Conditional Formatting Format as Table Cell Styles Clipboard Font Alignment Number Cells Editing Check for UP E F Office Update To keep up-to-date with security updates, fixes, and improv... A22 Ax & fx A B D 1 ongoing clients 75 2 client attrition rate for MRR 30% 3 Avg MRR from New Business per rep% 15,000 4 average deal size (MRR) $ 12.000 5 % of SQLs that close 6 % MQLs that become SQLS 9% 7 # of reps on team 5 5% 8 average growth deals per rep per month 2% 9 average MQL per month 600% 10 Average MRR from Growth Deals per Rep 20,000 11 12 New Business Total avg per rep 13 16%