Financial-Scenario-Analysis-Template-Example_Google-Sheets

	B	C	D	E	F	G	H	I	J	K	L	M
1

2	Example Financial Scenario Analysis Template				https://www.smartsheet.com/try-it?trp=11997&utm_source=template-google-sheet&utm_medium=content&utm_campaign=Sample+Financial+Scenario+Analysis-google-sheet-11997&lpa=Sample+Financial+Scenario+Analysis+google-sheet+11997
3	STAFFING COSTS						EXPENSES
4
5
6	MARGIN COMPARISON						COST / REVENUE ANALYSIS
7
8
9
10	DASHBOARD DATA
11	STAFFING COSTS			–––––– Place an X in Roles required in each Scenario. ––––––					STAFFING SALARY TOTALS
12	ROLE	DEPARTMENT	SALARY	Scenario 1	Scenario 2	Scenario 3	Scenario 4		Scenario 1	Scenario 2	Scenario 3	Scenario 4
13	Staff 1	Department 1	$86,000	X	X	X	X		$ 86,000	$ 86,000	$ 86,000	$ 86,000
14	Staff 2	Department 2	$110,000	X	X	X	X		$ 110,000	$ 110,000	$ 110,000	$ 110,000
15	Staff 3	Department 3	$59,000		X					$ 59,000
16	Staff 4	Department 4	$130,000	X			X		$ 130,000			$ 130,000
17	Staff 5	Department 5	$114,000		X	X				$ 114,000	$ 114,000
18	Staff 6	Department 6	$90,000		X		X			$ 90,000		$ 90,000
19	Staff 7	Department 7	$106,000		X					$ 106,000
20	Staff 8	Department 8	$79,000	X	X				$ 79,000	$ 79,000
21	Staff 9	Department 9	$103,000				X					$ 103,000
22	Staff 10	Department 10	$112,000		X	X				$ 112,000	$ 112,000
23	Staff 11	Department 11	$109,000				X					$ 109,000
24	Staff 12	Department 12	$106,000	X					$ 106,000
25	Staff 13	Department 13	$107,000		X	X	X			$ 107,000	$ 107,000	$ 107,000
26									TOTAL	TOTAL	TOTAL	TOTAL
27								STAFFING	$ 511,000	$ 863,000	$ 529,000	$ 735,000
28
29
30	EXPENSES			–––––– Enter a Percentage of Monthly Budget for each Scenario ––––––					EXPENSE TOTALS
31	EXPENSES	DEPARTMENT	MONTHLY BUDGET	Scenario 1	Scenario 2	Scenario 3	Scenario 4		Scenario 1	Scenario 2	Scenario 3	Scenario 4
32	Expense 1		$4,667	50%	100%	60%	100%		$ 2,334	$ 4,667	$ 2,800	$ 4,667
33	Expense 2		$6,683	100%	100%	87%	50%		$ 6,683	$ 6,683	$ 5,814	$ 3,342
34	Expense 3		$4,213	80%	100%	45%	50%		$ 3,370	$ 4,213	$ 1,896	$ 2,107
35	Expense 4		$1,969	12%	100%	40%	120%		$ 236	$ 1,969	$ 788	$ 2,363
36	Expense 5		$3,500	10%	100%	140%	50%		$ 350	$ 3,500	$ 4,900	$ 1,750
37	Expense 6		$5,655	75%	100%	95%	60%		$ 4,241	$ 5,655	$ 5,372	$ 3,393
38	Expense 7		$4,498	30%	100%	60%	100%		$ 1,349	$ 4,498	$ 2,699	$ 4,498
39	Expense 8		$3,978	30%	100%	60%	100%		$ 1,193	$ 3,978	$ 2,387	$ 3,978
40	Expense 9		$5,055	200%	100%	35%	100%		$ 10,110	$ 5,055	$ 1,769	$ 5,055
41	Expense 10		$1,954	20%	100%	60%	100%		$ 391	$ 1,954	$ 1,172	$ 1,954
42	Expense 11		$2,020	0%	100%	40%	100%		$ -	$ 2,020	$ 808	$ 2,020
43	Expense 12		$5,494	0%	100%	15%	100%		$ -	$ 5,494	$ 824	$ 5,494
44	Expense 13		$4,972	0%	100%	25%	100%		$ -	$ 4,972	$ 1,243	$ 4,972
45	Expense 14		$5,710	60%	100%	25%	100%		$ 3,426	$ 5,710	$ 1,428	$ 5,710
46	Expense 15		$5,322	30%	100%	20%	100%		$ 1,597	$ 5,322	$ 1,064	$ 5,322
47	Expense 16		$2,174	60%	100%	40%	100%		$ 1,304	$ 2,174	$ 870	$ 2,174
48	Expense 17		$4,313	50%	100%	50%	100%		$ 2,157	$ 4,313	$ 2,157	$ 4,313
49	Expense 18		$5,721	40%	100%	47%	100%		$ 2,288	$ 5,721	$ 2,689	$ 5,721
50	Expense 19		$5,655	30%	100%	120%	100%		$ 1,697	$ 5,655	$ 6,786	$ 5,655
51	Expense 20		$3,737	150%	100%	117%	100%		$ 5,606	$ 3,737	$ 4,372	$ 3,737
52									TOTAL	TOTAL	TOTAL	TOTAL
53								EXPENSES	$ 48,332	$ 87,290	$ 51,838	$ 78,224
54
55
56	REVENUE			–––––– Place an X to select Clients for each Scenario. ––––––					REVENUE TOTALS
57	CLIENTS		MONTHLY REVENUE	Scenario 1	Scenario 2	Scenario 3	Scenario 4		Scenario 1	Scenario 2	Scenario 3	Scenario 4
58	Client 1		$229,074	X	X	X			$ 229,074	$ 229,074	$ 229,074
59	Client 2		$50,693	X	X	X	X		$ 50,693	$ 50,693	$ 50,693	$ 50,693
60	Client 3		$53,827		X					$ 53,827
61	Client 4		$157,265	X			X		$ 157,265			$ 157,265
62	Client 5		$192,715	X	X	X			$ 192,715	$ 192,715	$ 192,715
63	Client 6		$94,113		X					$ 94,113
64	Client 7		$78,381		X	X				$ 78,381	$ 78,381
65	Client 8		$75,662	X	X				$ 75,662	$ 75,662
66	Client 9		$111,301			X	X				$ 111,301	$ 111,301
67	Client 10		$62,778		X	X				$ 62,778	$ 62,778
68	Client 11		$219,152	X			X		$ 219,152			$ 219,152
69	Client 12		$183,979	X	X				$ 183,979	$ 183,979
70	Client 13		$192,734	X	X	X	X		$ 192,734	$ 192,734	$ 192,734	$ 192,734
71									TOTAL	TOTAL	TOTAL	TOTAL
72								REVENUE	$ 1,301,274	$ 1,213,956	$ 917,676	$ 731,145
73		OVERALL
74		Scenario 1	Scenario 2	Scenario 3	Scenario 4			combined	$ 1,260,368	% of total
75	STAFFING COSTS	$ 511,000	$ 863,000	$ 529,000	$ 735,000			Scenario 1	$ 741,942	59%
76	EXPENSES	$ 48,332	$ 87,290	$ 51,838	$ 78,224			Scenario 2	$ 263,666	21%
77	TOTAL COST	$ 559,332	$ 950,290	$ 580,838	$ 813,224			Scenario 3	$ 336,838	27%
78	REVENUE	$ 1,301,274	$ 1,213,956	$ 917,676	$ 731,145			Scenario 4	$ (82,079)	-7%
79	MARGINS	$ 741,942	$ 263,666	$ 336,838	$ (82,079)
80
81	CLICK HERE TO CREATE IN SMARTSHEET
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100