Extra Sales Gross Profit Calculator

Extra Sales Gross Profit Calculator

CURRENCY
Inputs
These map to the blue cells in the sheet.
Results
Calculated live using your exact sheet formulas.
Present Sales Ratio
D4 = C3 / 10
0%
New Sales Ratio
E9 = (C3 + C8) / 10
0%
Extra Sales from Quotes Submitted (Monthly)
D12 = (C11*E9) - (C11*D4)
0
Gross Profit (from Extra Sales Goal)
D9 = (C5 * C6) * C8
$0
Financial Results
Revenue, profit, and ROI summary.
Additional Gross Profit Monthly
C14 = (C5 * C6) * D12
$0
Annual Increase in Gross Profit
C17 = C14 * C15
$0
Additional Turnover
C18 = C5 * D12 * C15
$0
1st Year's Return on Investment
C22 = C17 - C20
$0
ROI Percentage
C23 = IF(C20=0,0,C22/C20)
0%
(0%)
-100% 0% 200%