Annual Financial Report.xlsx

	B	D	F	H	I	J	K	N
1
2	ANNUAL FINANCIAL REPORT						2014	Select report year in Cell L2
3	YOUR COMPANY NAME							To edit data, select the Financial Data Input sheet
4
5	KEY METRICS	Click to change report Key Metrics
6
7	REVENUES	NET PROFIT	INTEREST	DEPRECIATION		OPERATING PROFIT
8	$180,584	$67,475	$3,789	$5,547		$73,426
9	0%	2%	14%	9%		-5%
10
11
12
13	ALL METRICS	Do not modify the information below. Click to enter Financial Data
14
15	METRIC	REPORT YEAR (2014)	PREVIOUS YEAR (2013)	% CHANGE	5 YEAR TREND
16	REVENUES	$180,583.88	$180,026.63	0%
17	OPERATING EXPENSES	$94,419.45	$80,883.33	17%
18	OPERATING PROFIT	$73,425.99	$77,317.83	-5%
19	DEPRECIATION	$5,546.88	$5,068.42	9%
20	INTEREST	$3,789.47	$3,338.30	14%
21	NET PROFIT	$67,474.85	$66,272.10	2%
22	TAX	$31,408.25	$29,424.53	7%
23	PROFIT AFTER TAX	$50,247.68	$42,438.20	18%
24	METRIC 1	$19.96	$16.78	19%
25	METRIC 2	$26.01	$21.84	19%
26	METRIC 3	$31.08	$26.39	18%
27	METRIC 4	$14.92	$14.59	2%
28	METRIC 5	$1.03	$1.00	3%
29	METRIC 6	$0.34	$0.30	13%
30					#N/A
31					#N/A
32					#N/A
33					#N/A
34					#N/A
35					#N/A
36					#N/A
37					#N/A
38					#N/A
39					#N/A
40					#N/A
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