A deal desk calculator gives sales reps the ability to model a deal before they send a proposal — checking margin impact, discount limits, and approval requirements without involving finance every time. Here's how to build one in Excel that's fast to use and hard to misuse.
Your Pricing Inputs
Start with a simple inputs section at the top. The rep fills in: product name, list price, quantity, requested discount %, contract term (months), and payment terms. Everything else calculates from these inputs.
Discounted Price Calculation
Discounted unit price:
=B2*(1-B5)
Where B2 is list price and B5 is discount %. Total contract value:
=B7*(B3/12)*B4
Where B7 is annual price (monthly × 12), B3 is term in months, and B4 is quantity.
Margin Impact
Add your cost basis (COGS) for each product as a locked reference table. Pull the cost for the selected product with VLOOKUP and calculate gross margin:
=B7-VLOOKUP(B1, ProductCosts!A:B, 2, FALSE)
And gross margin %:
=GrossMargin/B7
Apply conditional formatting: red if margin falls below your floor (e.g., 60%), green if above target (e.g., 75%). This is the most important signal in the calculator — reps need to see immediately if the proposed discount is acceptable.
Discount Approval Logic
Add an Approval Required column that checks the discount level against your approval thresholds:
=IFS(B5<=0.1, "No approval needed", B5<=0.2, "Manager approval", B5<=0.3, "VP approval", TRUE, "Deal Desk review required")
This automatically surfaces the approval requirement based on the discount entered. Reps know before they submit what sign-offs they need.
The Easy Way: Using SheetXAI in Excel
Example 1: You want to build the calculator from your pricing structure.
"I have a product pricing table on Sheet 1 with list prices and COGS. Build a deal desk calculator where reps input product, quantity, discount %, and term, and it calculates discounted price, total contract value, gross margin, and required approval level based on our thresholds."
SheetXAI builds the calculator with all the input fields, calculations, margin analysis, and approval logic.
Example 2: Your pricing data lives in your CRM or CPQ tool.
"Pull product pricing and cost data from our CPQ system and build a deal desk calculator that reps can use to model discounts and check margin before submitting for approval."
SheetXAI connects to your pricing data and builds the calculator.
Try SheetXAI free and see what it builds for you.
Published May 2026. See also: How to Track Sales Commissions in Google Sheets, How to Build a Sales Forecast in Excel, and Google Sheets AI Guide.
