Question

In: Finance

how do I figure out the following ratios based on the consolidated financial data: 1.) Gross...

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

Solutions

Expert Solution


Related Solutions

I am supposed to map out the following and can't figure out how to do it!...
I am supposed to map out the following and can't figure out how to do it! Can somebody help? The experiment has to do with determining the simplest formula of potassium chlorate and to determine the original amount of potassium chlorate in a potassium chlorate-potassium chloride mixture by measuring the oxygen lost from decomposition. The chemical reaction is 2KClO3(s) ------> 2KCL(s) + 3 O2(g) I am supposed to map out 1. Mass of oxygen lost in the first part 2....
How do I use the data analysis in Excel to figure these questions out? Suppose a...
How do I use the data analysis in Excel to figure these questions out? Suppose a researcher gathered survey data from 19 employees and asked the employees to rate their job satisfaction on a scale from 0 to 100 (with 100 being perfectly satisfied). Suppose the following data represent the results of this survey. Assume that relationship with their supervisor is rated on a scale from 0 to 50 (0 represents a poor relationship and 50 represents an excellent relationship);...
How do I figure out on a ba ii plus calculator, how to figure how many...
How do I figure out on a ba ii plus calculator, how to figure how many years it would take ? to pay off a house by making an extra payment or changing the payment all else fixed? for example if I had a $210,000 house with a 30 year mortgage at 2.25% and my payment is $802.72. if I change my payment to let's say $ 1600, how many years would that take to pay off my loan? and...
How can I, do I or should I, perform a financial analysis using financial ratios to...
How can I, do I or should I, perform a financial analysis using financial ratios to evaluate the firm's liquidity, solvency, and profitability for two sequential years using Amazon as the company?
Using the financial data below calculate the following ratios: 1) Gross Profit Margin; 2) Net Profit...
Using the financial data below calculate the following ratios: 1) Gross Profit Margin; 2) Net Profit Margin; 3) Return on Assets; 4) Days Sales Outstanding; 5) Quick Ratio. For EACH of these five ratios do the following: 1) calculate the value and 2) interpret the value in about one sentence.  TO RECEIVE ANY CREDIT YOU MUST SHOW YOUR WORK, WITHIN THE PROVIDED WORK SPACE. FINAL ANSWERS ONLY WILL NOT CUT IT!         Balance Sheet         ASSETS                                                                                               LIABILITIES                     Cash: $1,160,000                                                                          Current Liabilities: $173,000 A/R: 335,000                                                                                 Non-current...
what are calculations that can be used to figure out replenishment of items? how do i...
what are calculations that can be used to figure out replenishment of items? how do i figure out how many weeks/days on hand i have/need. an example is if i ordered 1069 cases of a product and sold 728 in the last 7 days with the stores having 9 days of inventory and 7 days of inventory in a wherhouse. would 1069 cases be to much?
How do you figure out the net charge on amino acids at a specific pH? I...
How do you figure out the net charge on amino acids at a specific pH? I am very confused about this please help! My textbook is very vague.
I am trying to figure out how to properly execute a while loop and a do/while...
I am trying to figure out how to properly execute a while loop and a do/while loop in the same program using java. I am stuck at just writing the while loop. I made a condition but I can't figure out how to get it to loop if the condition is true?? Also I have to write a do/while loop in the same program. here are the details: This lab demonstrates the use of the While Loop and the Do...
Use MATLAB to figure out the following problem, if you do not know how to use...
Use MATLAB to figure out the following problem, if you do not know how to use MATLAB then please do not answer. Coding is required for the exercise. For f(x) = arctan(x), find its zeros by implimenting Newtons method and the Secant method in Matlab. (Hint: Use Newtons method to calculate x1 for Secant method) Comment all code please since I would like to learn how to do this correctly in MATLAB. Thank you.
Coding: Use MATLAB to figure out the following problem, if you do not know how to...
Coding: Use MATLAB to figure out the following problem, if you do not know how to use MATLAB then please do not answer. Coding is required for the exercise. For f(x) = arctan(x), find its zeros by implimenting Newtons method and the Secant method in Matlab. (Hint: Use Newtons method to calculate x1 for Secant method) Comment all code please since I would like to learn how to do this correctly in MATLAB. Thank you.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT