Gross Profit Calculations per Order     % Sales   6-Month Summary
1) Advertised unit price of initial offer       Media Budget 
               
Price % of Buyers
Sales
2) 1st Upsell      Media Efficiency Ratio
3) 2nd Upsell
Profit
4) 3rd Upsell
Investment
5) Add shipping & handling         ROI
             
Total avg. revenue per sale (total order value)          
Less costs:
               
6) Maximum media cost allowed     1-Month Summary
Media $
Order product costs:           Sales
               
7) Cost of initial product offer     Media Efficiency Ratio
               
8) Cost of bonus/premium included with offer   Profit
               
9) Cost of 1st upsell offer       Investment
               
10) Cost of 2nd upsell offer       ROI
               
11) Cost of 3rd upsell offer          
Other costs:
%
12) Credit card merchant account (%)
13) Cost of ship/handle/fulfillment
14) 800 number service
15) Bad debt (%)
16) Returns (%)
17) Royalties (%)
18) Overhead, tapes, etc.
Gross Profit per Order          
6 Month Projections
           
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 6 Month Total
19) Media budget for
      campaign
20) Orders
21) Gross revenue
22) Cost of goods
23) Other order processing
      costs
24) TV production and
      taping costs
25) Changes to TV
      commercial
Total costs
Net Profit
               
26) Working capital needed  
27) Starting cash 0  
Investments In
28) Income in  
29) Less all costs paid out  
30) Ending cash  
1st Month Projections
           
Week 1 Week 2 Week 3 Week 4 Week 5 Total Month
31) Media budget for
      campaign 		 
32) Units sold (Initial offer)  
33) Units sold (1st Up-sell)  
34) Units sold (2nd Up-sell)  
35) Units sold (3rd Up-sell)  
36) Units purchased
      (Initial offer) 		 
37) Units purchased
      (1st Up-sell) 		 
38) Units purchased
      (2nd Up-sell) 		 
39) Units purchased
      (3rd Up-sell) 		 
40) Units on hand (EOW)
      (Initial offer) 		 
41) Units on hand (EOW)
      (1st Up-sell) 		 
42) Units on hand (EOW)
      (2nd Up-sell) 		 
43) Units on hand (EOW)
      (3rd Up-sell) 		 
44) Gross revenue  
45) Cost of goods  
46) Other order processing costs  
47) TV production and
      taping costs 		 
48) Changes to TV
      commercial 		 
Total costs  
Net Profit  
49) Working capital needed  
50) Starting cash    
51) Investments In  
52) Income in  
53) Less all costs paid out  
54) Ending cash