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  |