In: Finance
how do I figure out the following ratios based on the consolidated financial data:
1.) Gross Profit Margin 2.) Operating Profit Margin 3.) Return on Equity 4.) Earnings Per Share 5.) Current Ratio 6.) Total debt-to-assets ratio 7.) Debt-to-equity ratio 8.) CAGR % 9.) Bakery-café sales 10.) Total Revenues 11.) Total bakery-café expenses 12.) Net income to shareholders
selected Consolidated Financial Data for Panera Bread, 2011–2015 | |||||
(in thousands, except for per-share amounts) |
|||||
2015 | 2014 | 2013 | 2012 | 2011 | |
Revenues: |
|||||
Bakery-café sales |
2,358,794 |
$2,230,370 |
$2,108,908 |
$1,879,280 |
$1,592,951 |
Franchise royalties and fees |
138,563 |
123,686 |
112,641 |
102,076 |
92,793 |
Fresh dough and other product sales |
|||||
to franchisees |
184,223 |
175,139 |
163,453 |
148,701 |
136,288 |
Total revenues |
2,681,580 |
2,529,195 |
2,385,002 |
2,130,057 |
1,822,032 |
Bakery-café expenses: |
|||||
Food and paper products |
715,502 |
669,860 |
625,622 |
552,580 |
470,398 |
Labor |
754,646 |
685,576 |
625,457 |
559,446 |
484,014 |
Occupancy |
169,998 |
159,794 |
148,816 |
130,793 |
115,290 |
Other operating expenses |
334,635 |
314,879 |
295,539 |
256,029 |
216,237 |
Total bakery-café expenses |
1,974,781 |
1,830,109 |
1,695,434 |
1,498,848 |
1,285,939 |
Fresh dough and other product cost of sales |
|||||
to franchisees |
160,706 |
152,267 |
142,160 |
131,006 |
116,267 |
Depreciation and amortization |
135,398 |
124,109 |
106,523 |
90,939 |
79,899 |
General and administrative expenses |
142,904 |
138,060 |
123,335 |
117,932 |
113,083 |
Pre-opening expenses |
9,089 |
8,707 |
7,794 |
8,462 |
6,585 |
Total costs and expenses |
2,439,986 |
2,253,252 |
2,075,246 |
1,847,187 |
1,601,773 |
Operating profit |
241,594 |
275,943 |
309,756 |
282,870 |
220,259 |
Interest expense |
3,830 |
1,824 |
1,053 |
1,082 |
822 |
Other (income) expense, net |
1,192 |
-3,175 |
-4,017 |
-1,208 |
-466 |
Income taxes |
87,247 |
98,001 |
116,551 |
109,548 |
83,951 |
Less net income (loss) attributable to |
|||||
non-controlling interest |
-17 |
— |
— |
— |
— |
Net income to shareholders |
149,325 |
179,293 |
196,169 |
173,448 |
135,952 |
Earnings per share |
|||||
Basic |
$5.81 |
$6.67 |
$6.85 |
$5.94 |
$4.59 |
Diluted |
5.79 |
6.64 |
6.81 |
5.89 |
4.55 |
Weighted average shares outstanding |
|||||
Basic |
25,685 |
26,881 |
28,629 |
29,217 |
29,601 |
Diluted |
25,788 |
26,999 |
28,794 |
29,455 |
29,903 |
Balance Sheet Data |
|||||
Cash and cash equivalents |
241,886 |
196,493 |
125,245 |
297,141 |
222,640 |
Current assets |
502,789 |
406,166 |
302,716 |
478,842 |
353,119 |
Total assets |
1,475,318 |
1,390,686 |
1,180,862 |
1,268,163 |
1,027,322 |
Current liabilities |
399,443 |
352,712 |
303,325 |
277,540 |
238,334 |
Total liabilities |
974,037 |
654,502 |
480,970 | 446,244 | 372,246 |
Stockholders’ equity |
497,300 |
736,184 |
699,892 |
821,919 |
655,076 |
Cash Flow Data |
|||||
Net cash provided by operating activities |
318,045 |
335,079 |
348,417 |
289,456 |
236,889 |
Net cash used in investing activities |
-165,415 |
-211,317 |
-188,307 |
-195,741 |
-152,194 |
Net cash (used in) provided by financing activities |
-107,237 |
-52,514 |
-332,006 |
-19,214 |
-91,354 |
Net (decrease) increase in cash and cash equivalents |
45,393 |
71,248 |
-171,896 |
74,501 |
-6,659 |