How much will your revenue drop bc of tariffs?.xlsx

	A	D	E
1
2
3
4
5
6	Instructions
7	Click File > Make a Copy
8	Follow the steps!
9
10	How much will your revenue drop because of the tariffs?
11
12	Step 1 - Rank your Company on the following categories:
13
14	Category	Select Your Ranking	Ranking Explanation
15	Your Brand Strength	Basic Recognition	Minimal brand awareness. People might recognize the name when prompted, but have no strong associations or loyalty. Heavy reliance on direct sales and marketing for each transaction.
16	Your Target Customer Household Income Level	Between $52k - $106k	[no explanation needed]
17	The availability of similar options	Many Close Substitutes	Multiple alternatives that serve the same purpose with minimal differences. Easy switching with very low costs. (e.g., basic office supplies, standard cleaning products, common electronics accessories)
18	How addictive or habit forming is your product	Minimally Habit Forming	Occasional repeat purchases based purely on satisfaction with previous experiences. No psychological attachment. (e.g., household cleaning products, basic clothing items, office supplies)
19	Whether your products are necessities or luxuries	Enhanced Necessity	Basic needs met in a premium way. These items serve necessary functions but go well beyond basic requirements. (e.g., luxury versions of basic items like premium organic food, high-end smartphones, designer clothing)
20	Your products durability, or non-durability	Minimal Durability	Products lasting weeks to months. Frequent replacement is expected. Low price sensitivity due to constant need and relatively low per-unit cost. (e.g., groceries with longer shelf life, personal care items, basic office supplies)
21	How easy it is for customers to find out competitor pricing	High Price Visibility	Prices readily available with minimal effort through quick online search or price comparison tools. Some minor effort needed to ensure comparing identical offerings. (e.g., consumer electronics, insurance quotes, hotels)
22	How seasonal your sales are	Minimal Seasonality	Very slight seasonal fluctuations that barely affect business operations. Nearly consistent demand throughout the year with small predictable variations. (e.g., grocery stores, gas stations, basic healthcare services)
23
24
25	For every 1% increase in your price
26	You should expect your demand to drop by	1.27%
27
28
29	Step 2 - How much will your prices change because of the tariffs?
30
31	What is your current Cost of Goods Sold?	20%	<- input your COGS as a percentage of revenue here
32	Tariffs will increase our product costs by	10%
33	How much of this increase will you pass to your customers?	50%	<- 100% means you'll pass the full tariff cost to your customers
34	This would be equivalent to a price increase of	5%
35
36	Your demand could drop by as much as	1.59%
37	And your gross margin could drop by as much as	0.95%
38
39	Step 3 - Reforecast your P&L
40
41	In your forecast, reduce your revenue by	1.59%
42	and reduce your gross margin by	0.95%
43
44	What effect will that have on your profitability and cash flow?
45
46	Want us to do this for you?
47	Click here to book a meeting
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100