IC-Marketing-Executive-Dashboard-Template_Google-Sheets

	B	D	E	F	G	H	I	J	K	L	M	N	O	P
1

2	MARKETING EXECUTIVE DASHBOARD TEMPLATE							https://www.smartsheet.com/try-it?trp=11718&utm_source=template-google-sheet&utm_medium=content&utm_campaign=Marketing+Executive+Dashboard-google-sheet-11718&lpa=Marketing+Executive+Dashboard+google-sheet+11718
3	User to enter information in the data tables below, completing non-shaded cells only. Dashboard data and charts will automatically populate.
4	GROSS PROFIT MARGIN		OPEX RATIO			EBIT MARGIN			NET PROFIT MARGIN
5	–		–			–			–
6
7	INCOME STATEMENT		REVENUE
8	Revenue	$ -
9	COGS	$ -
10
11
12	GROSS PROFIT	$ -
13	OPERATING EXPENSES	$ -
14	Sales	$ -
15	Marketing	$ -
16	IT	$ -	OPERATING EXPENSES
17	General & Admin	$ -
18	OTHER INCOME	$ -
19	OTHER EXPENSES	$ -
20
21
22	GROSS INCOME	$ -
23	Interest & Tax	$ -
24
25
26	NET PROFIT	$ -
27
28
29	DATA TABLES
30	REMINDER: Enter information in the data tables below, completing non-shaded cells only. Dashboard data and charts will automatically populate.
31	REVENUE AND OTHER INCOME
32		JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	YTD
33	REVENUE													$ -
34	OTHER INCOME													$ -
35
36	COGS AND OTHER EXPENSES
37		JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	YTD
38	COGS													$ -
39	OTHER EXPENSES													$ -
40
41	INTEREST & TAX
42		JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	YTD
43	INTEREST													$ -
44	TAX													$ -
45
46	OPERATING EXPENSES
47		JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	YTD
48	Sales													$ -
49	Marketing													$ -
50	IT													$ -
51	General & Admin													$ -
52		$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
53
54	CLICK HERE TO CREATE IN SMARTSHEET
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