Sheet 1: e-Commerce Sales Forecast

	
	
	
	
	
	
	

		


		
E-COMMERCE SALES FORECAST TEMPLATE
		


		


		


		

 
		
		


	
	

		


		
* User to complete non-shaded cells, only.
		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
MARKETING
		
 YEAR 1 
		
 YEAR 2 
		
 YEAR 3 
		
 YEAR 4 
		
 YEAR 5 
		


		


	
	

		


		


		
MARKETING BUDGET
		
 $18,000.00 
		
 $25,000.00 
		
 $45,000.00 
		
 $63,000.00 
		
 $85,000.00 
		


		


	
	

		


		


		
AVG COST PER CLICK
		
 $0.37 
		
 $0.37 
		
 $0.38 
		
 $0.38 
		
 $0.38 
		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
VISITS
		


		


		


		


		


		


		


	
	

		


		


		
PAID
		
48,649
		
67,568
		
118,421
		
165,789
		
223,684
		


		


	
	

		


		


		
ORGANIC
		
850,000
		
920,000
		
1,100,000
		
1,500,000
		
1,950,000
		


		


	
	

		


		


		
TOTAL VISITS
		
898,649
		
987,568
		
1,218,421
		
1,665,789
		
2,173,684
		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
SALES
		


		


		


		


		


		


		


	
	

		


		


		
CONVERSION RATE %
		
1.50%
		
1.75%
		
2.25%
		
2.75%
		
4.00%
		


		


	
	

		


		


		
TOTAL SALES
		
 $13,479.73 
		
 $17,282.43 
		
 $27,414.47 
		
 $45,809.21 
		
 $86,947.37 
		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
REVENUE
		


		


		


		


		


		


		


	
	

		


		


		
AVG BASKET VALUE $
		
 $30.00 
		
 $35.00 
		
 $40.00 
		
 $40.00 
		
 $40.00 
		


		


	
	

		


		


		
TOTAL SALES
		
 $404,391.89 
		
 $604,885.14 
		
 $1,096,578.95 
		
 $1,832,368.42 
		
 $3,477,894.74 
		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
OTHER REVENUE
		


		


		


		


		


		


		


	
	

		


		


		
Revenue Source 1
		
 $11,000.00 
		
 $15,000.00 
		
 $20,000.00 
		
 $25,000.00 
		
 $35,000.00 
		


		


	
	

		


		


		
Revenue Source 2
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


		


	
	

		


		


		
Revenue Source 3
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


		


	
	

		


		


		
Revenue Source 4
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


		


	
	

		


		


		
Revenue Source 5
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


		


	
	

		


		


		
OTHER REVENUE TOTAL
		
 $11,000.00 
		
 $15,000.00 
		
 $20,000.00 
		
 $25,000.00 
		
 $35,000.00 
		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
TOTAL REVENUE per YEAR
		
 $415,391.89 
		
 $619,885.14 
		
 $1,116,578.95 
		
 $1,857,368.42 
		
 $3,512,894.74 
		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		


		
CLICK HERE TO CREATE IN SMARTSHEET
		


	



Sheet 2: BLANK e-Commerce Sales Forecast

	
	
	
	
	
	

		


		
E-COMMERCE SALES FORECAST TEMPLATE
		


		


		


		


		


		


		


	
	

		


		
* User to complete non-shaded cells, only.
		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		
MARKETING
		
 YEAR 1 
		
 YEAR 2 
		
 YEAR 3 
		
 YEAR 4 
		
 YEAR 5 
		


	
	

		


		


		
MARKETING BUDGET
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		


		
AVG COST PER CLICK
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		
VISITS
		


		


		


		


		


		


	
	

		


		


		
PAID
		
-
		
-
		
-
		
-
		
-
		


	
	

		


		


		
ORGANIC
		
0
		
0
		
0
		
0
		
0
		


	
	

		


		


		
TOTAL VISITS
		
0
		
0
		
0
		
0
		
0
		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		
SALES
		


		


		


		


		


		


	
	

		


		


		
CONVERSION RATE %
		
0.00%
		
0.00%
		
0.00%
		
0.00%
		
0.00%
		


	
	

		


		


		
TOTAL SALES
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		
REVENUE
		


		


		


		


		


		


	
	

		


		


		
AVG BASKET VALUE $
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		


		
TOTAL SALES
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		
OTHER REVENUE
		


		


		


		


		


		


	
	

		


		


		
Revenue Source 1
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		


		
Revenue Source 2
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		


		
Revenue Source 3
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		


		
Revenue Source 4
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		


		
Revenue Source 5
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		


		
OTHER REVENUE TOTAL
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		
TOTAL REVENUE per YEAR
		
 $-   
		
 $-   
		
 $-   
		
 $-   
		
 $-