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 |