Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the following. Using the data below, evaluate Paneras financial position. Financial Analysis: Panera Bread Part 1: Financial Ratios Exhibit 1 in the Panera case

Calculate the following. Using the data below, evaluate Paneras financial position.

image text in transcribed

Financial Analysis: Panera Bread

Part 1: Financial Ratios

Exhibit 1 in the Panera case provides information on Paneras financial data for the years 2011 through 2015. Calculate the following operating and financial ratios for the years 2011 to 2015. All calculations should be rounded to one decimal (e.g., 12.7%).

Financial ratios

2015

2014

2013

2012

2011

Total bakery caf expenses as a % of total revenues

General and administrative expenses as a % of total revenues

Operating profit as % of a total revenue (operating profit margin)

Net income as a % of total revenue (net profit margin)

Net income as a % of stockholders equity (ROE)

Part 2: Annual Growth Activity

Using available data in the case (exhibit 1), calculate the requested annual growth percentages. Round all numbers to the nearest hundredth.

All growth rates can be calculated using the following equation: [Year (x) value Year (x-1) value] / Year (x-1) value.

For example, if Total revenue for 2014 is 5,000 and Total revenue for 2013 is 4,000, the annual growth rate from 2013 to 2014 would be calculated as: [5000 4000] / 4000 = .25. This translates to 25.0% growth.

2014-2015

2011-2012

Net income

Net cash provided by operating activities

EPS (diluted)

Franchise royalties and fees

EXHIBITI Selected Consolidated Financial Data for Panera Bread, 2011-2015 (in thousands, except for per-share amounts) 2015 2014 2013 2012 2011 Income Statement Data $2,358,794 $2,230,370 $2,108,908 $1,879,280 $1,592,951 138,563 123,686 112,641 102,076 92,793 175,139 184.223 2,681,580 163,453 2,529,195 2,385,002 148,701 2,130,057 136,288 1.822.032 715,502 754.646 169,998 334,635 1,974,781 669,860 685,576 159,794 314,879 1,830,109 625,622 625,457 148,816 295,539 1,695,434 552,580 559,446 130,793 256,029 1,498,848 470,398 484,014 115,290 216,237 1.285,939 Revenues: Bakery-caf sales Franchise royalties and fees Fresh dough and other product sales to franchisees Total revenues Bakery-caf expenses: Food and paper products Labor Occupancy Other operating expenses Total bakery-caf expenses Fresh dough and other product cost of sales to franchisees Depreciation and amortization General and administrative expenses Pre-opening expenses Total costs and expenses Operating profit Interest expense Other (income) expense, net Income taxes Less net income (loss) attributable to non-controlling interest Net income to shareholders Earnings per share Basic 160,706 152,267 142,160 131.006 135.398 124,109 106,523 90.939 142,904 138,060 123,335 117,932 9,089 8,707 7,794 8,462 2,439,986 2,253,252 2,075,246 1,847,187 241.594 275,943 309,756 282,870 3,830 1,824 1,053 1,082 1,192 (3,175) (4,017) (1,208) 87,247 98,001 116,551 109,548 116,267 79,899 113.083 6,585 1.601.773 220,259 822 (466) 83,951 (17) $ 149,325 $ 179,293 196,169 $ 173,448 $ 135,952 $5.81 $6.67 $6.85 $5.94 $4.59 5.79 6.64 6.81 5.89 4.55 Diluted Weighted average shares outstanding Basic Diluted 25,685 25.788 26,881 26,999 28,629 28,794 29,217 29,455 29,601 29.903 Balance Sheet Data Cash and cash equivalents Current assets Total assets Current liabilities Total liabilities Stockholders' equity $ 241,886 $ 196,493 $ 125,245 $ 297,141 $ 222,640 502,789 406,166 302,716 478,842 353,119 1,475,318 1,390,686 1,180,862 1,268,163 1,027,322 399,443 352,712 303,325 277,540 238,334 974,037 654,502 480,970 446,244 372,246 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 16,659) Sources: 2015 10-K report, pp. 43-46; 2014 10-K report, pp. 41-43: 2013 10-K report, pp. 41-43, 2011 10-K report, pp. 41-43

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting An IFRS Perspective In Romania

Authors: Adriana Dutescu

1st Edition

3030294870, 978-3030294878

More Books

Students also viewed these Accounting questions

Question

What is Aufbau's rule explain with example?

Answered: 1 week ago

Question

Write Hund's rule?

Answered: 1 week ago