Extra Sales Gross Profit Calculator

CURRENCY

Inputs

These map to the blue cells in the sheet.

Sales from 10 Quotes

Excel: C3

Average Sale Value

Excel: C5

NZ$

Gross Profit Margin

Excel: C6 (enter as %)

Example: 30 = 30%

Extra Sales Goal From 10 Quotes

Excel: C8

Average Number of Quotes Monthly

Excel: C11

Selling Months (Year)

Excel: C15

Estimated Investment to Achieve Results

Excel: C20

NZ$

Results

Calculated live using your exact sheet formulas.

Present Sales Ratio

D4 = C3 / 10

New Sales Ratio

E9 = (C3 + C8) / 10

Gross Profit (from Extra Sales Goal from 10 Quotes)

D9 = (C5 * C6) * C8

Extra Sales from Quotes Submitted (Monthly)

D12 = (C11*E9) - (C11*D4)

Financial Results

Revenue, profit, and ROI summary.

Additional Gross Profit Monthly

C14 = (C5 * C6) * D12

Annual Increase in Gross Profit

C17 = C14 * C15

Additional Turnover

C18 = C5 * D12 * C15

1st Year's Return on Investment

C22 = C17 - C20

ROI Percentage

C23 = IF(C20=0,0,C22/C20)

(0%)

-100% 0% 200%

Let's Take This One Step Futher

Apart from increasing Sales Success Ratios, the Selling System has also significantly increased the Average Sale Value and the Gross Profit Margin for many clients. Small Changes = Massive Results

Below place a realistic percentage to increase your Average Sale Value and Gross Profit.

Growth Inputs

Adjust the two percentages to see the additional opportunity.

Increase Average Sale Value by

Increase Gross Profit Margin by

Projected Financial Results

Updated live using the percentages you enter.

Annual Increase in Gross Profit

C36 = (C5*C33+C5)*(C6*C34+C6)*D12*C15

Additional Turnover

C37 = (C5*C33+C5)*D12*C15

1st Years Return on Investment

C39 = C36-C20

As a Percentage

C40 = IF(C20=0,0,C39/C20)

Before vs After

See the financial impact of your Average Sale Value and Gross Profit Margin increases.

Annual Increase in Gross Profit

Before$0

After$0

Additional Turnover

Before$0

After$0

1st Year Return on Investment

Before$0

After$0