This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Calculation Variables
Average Transaction Value
Gross Sales Projected (Needed) For Period
Lead Flow Projections
Response Rate %
Quantity
Step 1 - Lead Generation - Execute Marketing Campaign (enter your typical response rate for the channel/media.
If you don't know, see the Response Rate by Media Chart)
Enter Conversion Rates %
Step 2 - Conversion Rate of Leads to Opportunities
Step 3 - Conversion Rate of Opportunities to Qualified Opportunities
Step 4 - Conversion Rate of Qualified Opportunities to Closes
Required (Sales / Closes to Achieve Revenue Goal
Reset
Print