BREAKEVEN ANALYSIS TEMPLATE.xlsx

	B	C	D	E	G	H	I	J
1	FinanceByEmma financebyemma@gmail.com
2	BREAKEVEN ANALYSIS
3	Complete non-shaded fields, only.						PERIOD	COVERED
4	PRODUCT NAME	VALUE	REPRESENTED AS	TOTAL	COMPANY NAME	DATE COMPLETED	START DATE	END DATE
5		SELLING PRICE	P	0.000		00/00/00	00/00/00	00/00/00
6		BREAK-EVEN UNITS	X	0
7		BREAK-EVEN SALES	S	0.000
8	VARIABLE COSTS				FIXED COSTS			IN BHD
9	VARIABLE COSTS (per Unit)		BHD		RENT			-
10	Costs of Goods Sold		0.000	per unit	Item 2			-
11	Labor		0.000	per unit	Item 3			-
12	Overhead		0.000	per unit	Item 4			-
13	Other		0.000	per unit	Item 5			-
14	Other		0.000	per unit	Item 6			-
15	Other		0.000	per unit	Item 7			-
16		TOTAL	0.000		Item 8			-
17	VARIABLE COSTS (per Percentage)		%		Item 9			-
18	Commissions		0.0%	per unit	Item 10			-
19	Other		0.0%	per unit	Item 11			-
20	Other		0.0%	per unit	Item 12			-
21	Other		0.0%	per unit	Item 13			-
22		TOTAL	0.0%				TOTAL FIXED COSTS (TFC)	-
23
24	VARIABLE COSTS OVERVIEW				BREAK-EVEN POINT
25	VALUE	REPRESENTED AS	FORMULA	TOTAL	VALUE	REPRESENTED AS	FORMULA	TOTAL
26	TOTAL VARIABLE COST (per Unit)	V		-	BREAK-EVEN UNITS	X	TFC / (P – V)	0
27	CONTRIBUTION MARGIN (per Unit)	CM	P – V	-	BREAK-EVEN SALES	S	X * P = TFC / CMR	-
28	CONTRIBUTION MARGIN RATIO	CMR	1 – V / P = CM / P	0.0%
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
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