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
|
|
|
|
|
|
|
|