ProfitMetrics Profit Forecasting Calculator - (MAKE A COPY).xlsx

	B	C	D	E	F
1		How to Use the Profit Forecasting Calculator:
2		1. Input Data: Enter your numbers from the last month or average from the past 3-6 months for seasonal businesses.
3		2. Adjust Percentages: Change the increase/decrease % for a metrics
4	Visit ProfitMetrics.io	3. Analyze Results: See how changes affect your contribution margin and net profit.
5		4. Find Key Drivers: Use the results to focus on areas that will have the biggest impact on profitability.
6
7	Data Input Table Fill in your ecommerce data below and change the index to predict future change
8	Variable order costs	Your current data	Change (index 100)	Insert decline %	Insert Increase %
9	Total monthly website visitors	84000	100
10	Conversion rate (%)	2.1	100
11	Avg. order value (revenue ex vat)	51	100
12	Total monthly ad apend	11800	100
13	Average product margin (%) ([(Sales Price - Cost of Goods) / Sales Price] x 100)	50	100
14	Average shipping cost per order (DHL, UPS, etc.)	4.8	100
15	Average payment fee per order (%) (PayPal, Credit Card, etc.)	1.2	100
16	Average extra costs per order (Packaging, Labels, Handling)	1	100
17	Total monthly fixed costs (Rent, Salaries, Software, Admin, etc.)	19000	100
18	Return Rate (Number of orders returned in %)	3.0%	100
19
20
21	Calculation Table NB! Do not edit this table - data will be calculated based on input table
22	Name	Currenct performance	Projected performance	Difference	Difference %
23	Visitors	84,000.0	84,000.0
24	Number of orders	1,764.0	1,764.0
25	Conversion rate	2.1	2.1
26	Avg. order value	51.0	51.0
27	Revenue	87,265.1	87,265.1
28	Revenue lost on return rate	2,698.9	2,698.9
29	Product cost	43,632.5	43,632.5
30	Shipping	8,467.2	8,467.2
31	Payment fee	1,047.2	1,047.2
32	Extra cost	1,764.0	1,764.0
33
34	Gross profit	32,354.2	32,354.2
35
36	Ad spend	11,800.0	11,800.0
37
38	Contribution Margin	20,554.2	20,554.2
39
40	Net profit	1,554.2	1,554.2
41
42
43
44	Accumulation Table - Contribution Margin NB! Do not edit this table - data will be calculated based on the contribution margin (profit after ad spend)
45	Period	Current performance	Projected performance	Difference	Difference %
46	0	0	0	0
47	1	20,554.2	20,554.2	0.0
48	2	41,108.3	41,108.3	0.0
49	3	61,662.5	61,662.5	0.0
50	4	82,216.6	82,216.6	0.0
51	5	102,770.8	102,770.8	0.0
52	6	123,325.0	123,325.0	0.0
53	7	143,879.1	143,879.1	0.0
54	8	164,433.3	164,433.3	0.0
55	9	184,987.4	184,987.4	0.0
56	10	205,541.6	205,541.6	0.0
57	11	226,095.7	226,095.7	0.0
58	12	246,649.9	246,649.9	0.0
59
60
61
62	Accumulation Table - Net Profit NB! Do not edit this table - data will be calculated based on the net profit
63	Period	Current performance	Projected performance	Difference	Difference %
64	0	0.0	0.0	0.0
65	1	1,554.2	1,554.2	0.0
66	2	3,108.3	3,108.3	0.0
67	3	4,662.5	4,662.5	0.0
68	4	6,216.6	6,216.6	0.0
69	5	7,770.8	7,770.8	0.0
70	6	9,325.0	9,325.0	0.0
71	7	10,879.1	10,879.1	0.0
72	8	12,433.3	12,433.3	0.0
73	9	13,987.4	13,987.4	0.0
74	10	15,541.6	15,541.6	0.0
75	11	17,095.7	17,095.7	0.0
76	12	18,649.9	18,649.9	0.0
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100