Question: Use the data provided in the attached Excel spreadsheet to conduct a thorough financial analysis. You must use common-sized statements and ratios and your analysis

Use the data provided in the attached Excel spreadsheet to conduct a thorough financial analysis. You must use common-sized statements and ratios and your analysis must be both longitudinal and cross-sectional. Additionally, you should give compound annual growth rates for key categories (such as revenue, but you must decide which others will contribute to your understanding of the company). Use tables to display your results, but include a narrative to explain what your tables reveal.

SELECTED FINANCIAL DATA FOR WHOLE FOODS (Longitudinal)
Data are in $Millions
INCOME STATEMENT 2012 2011 2010 2009 2008
Sales 11698 10108 9006 8032 7954
Cost of Goods sold 7543 6571 5870 5277 5247
Gross profit 4155 3537 3136 2755 2707
Direct store expenses 2983 2629 2377 2147 2109
General & administration expenses 372 311 272 244 270
Pre-opening expenses 47 41 38 49 56
Relocation/termination/lease termination 10 8 11 31 37
Operating Income 743 548 438 284 236
Interest Expense 0.354 4 33 37 36
Investment and other income 9 8 7 3 7
Income before taxes 752 552 412 251 207
Provision for taxes 286 209 166 104 92
Net income 466 343 246 147 115
BALANCE SHEET 2012 2011 2010
Current Assets:
Cash and cash equivalents 89 212 132
Short-term investments 1131 442 330
Restricted cash 103 92 87
Accounts receivable 197 175 133
Merchandise inventories 374 337 324
Prepaid expenses and other current assets 77 74 55
Deferred income taxes 132 121 101
Total current assets 2103 1453 1162
Property and equipment, net 2193 1997 1886
Long-term investments 221 53 96
Goodwill 663 663 665
Intangible assets, net 62 67 69
Deferred income taxes 43 50 99
Other assets 9 9 9
Total Assets 5294 4292 3986
Current liabilities:
Current installments of capital leases 1 0.5 0.4
Accounts payable 247 237 213
Accrued payroll 307 282 244
Dividends payable 26 18
Other current liabilities 396 343 290
Total current liabilities 977 879 748
Long-term capital leases 23 17 508
Deferred lease liabilities 441 354 294
Other long-term liabilities 51 50 63
Total liabilities 1492 1301 1613
Retained earnings 1233 870 599
Total shareholder's equity 3802 2991 2373
Total liabilities and shareholder's equity 5294 4292

3986
2012 FINANCIAL DATA FOR SELECTED GROCERS (Cross Sectional)
Data are in $Millions
INCOME STATEMENT Whole Foods Safeway Publix Kroger
Sales 11698 44207 27707 96751
Cost of Goods sold 7543 32487 19911 76858
Gross profit 4155 11720 7796 19893
Direct store expenses 2983 2280
General & administration expenses 372 10616 5631 14849
Pre-opening expenses 47
Relocation/termination/lease termination 10
Operating Income 743 1104 2165 2764
Interest Expense/Income 0.354 304 88 462
Investment and other income 9 28 49
Income before taxes 752 828 2302 2302
Provision for taxes 286 262 750 794
Net income 466 566 1552 1508
BALANCE SHEET
Current Assets:
Cash and cash equivalents 89 352 337 1193
Short-term investments 1131 797
Restricted cash 103
Accounts receivable 197 909 519 1051
Merchandise inventories 374 2562 1409 5146
Prepaid expenses and other current assets 77 345 29 569
Deferred income taxes 132 58
Total current assets 2103 4168 3149 7959
Property and equipment, net 2193 9225 4691 14875
Long-term investments 221 192 4236
Goodwill 663 472 1234
Intangible assets, net 62
Deferred income taxes 43
Other assets 9 601 203 584
Total Assets 5294 14658 12279 24652
Current liabilities:
Current installments of capital leases 1 36 2734
Accounts payable 247 3125 1307 4524
Accrued payroll 307 461 109 977
Deferred taxes 46 284
Dividends payable 26
Other current liabilities 396 938 804 2538
Total current liabilities 977 4606 2220 11057
Long-term capital leases 23 412 6145
Long-term Debt 4832 153 1145
Deferred Taxes 179 327 800
Deferred retirement benefits 915 330 1291
Deferred lease liabilities 441
Other long-term liabilities 51 782 118
Total liabilities 1492 11726 3148 20438
Retained earnings 1233 7610 6641
Total shareholder's equity 3802 2932 9131 4214
Total liabilities and shareholder's equity 5294 14658 12279 24652

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Simulate the Role of a Credit Analyst Task: Develop a written report. Choose two publicly traded companies within the same industry and conduct a thorough financial analysis to determine which is a...

Q:

Simulate the Role of a Credit Analyst Task: Develop a written report. Choose two publicly traded companies within the same industry and conduct a thorough financial analysis to determine which is a...

Q:

Imagine a financial analyst tasked with evaluating two leading companies within the same industrysuch as Coca-Cola and Pepsi. The goal is to conduct a thorough financial analysis and compare their...

Q:

I attached information regarding this project, i also attached the financials and also a sample of what i need. the chosen industry isSunCoke Energy Partners LP (NYS: SXCP). This is a 15 to 20 pages...

Q:

The Sherwin-Williams Company Income Statement All numbers in thousands Revenue 12/31/2015 12/31/2014 12/31/2013 Total Revenue 11,339,304 11,129,533 10,185,532 Cost of Revenue 5,780,078 5,965,049...

Q:

You're a healthcare administration fellow at the prestigious Stanford Healthcare. You have been rotating through the various departments over the past nine months and now you have the honor of...

Q:

need help solving for operating metrics: a. medicare revenue percentage b. all-payer case mix index c. labor hours per visit RIVER COMMUNITY HOSPITAL is a 210-bed, not-for-profit, acute care hospital...

Q:

1 / 4 91% + IO Enter all the information on your clients from the client data sheets into a blank Excel spreadsheet a. In that single Excel file, create 1) a data worksheet, 2) one worksheet for the...

Q:

Can you please help me with the homework attached ? I can use some of my tutor credits to pay for the services. Thanks! This Portfolio Project has two parts: Calculations due this week and a 4- to...

Q:

please complete the following for: STARBUCKS CORPORATION Analyzing Your Publicly Held Corporation (Note: Do not remove the questions from these pages. Just type your answers in beside or below the...

Q:

Joyce Kieffers regular hourly wage rate is $15, and she receives a wage of 112 times the regular hourly rate for work in excess of 40 hours. During a March weekly pay period Joyce worked 42 hours....

Q:

All of the following employees hold line positions in Facebook except Ovice president of production Ovice president of finance Ovice president of sales Omanager of the web design

Q:

Rose sells firecrackers for $ 5 . 2 7 per packet. If Rose s fixed costs are $ 6 9 , 0 0 0 , and she seeks a target profit of $ 9 4 , 0 0 0 on 7 9 , 0 0 0 packets sold, what does she need her variable...

Q:

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

Q:

Understanding Group Leadership Culture and Group Leadership

Q:

Have you ever misunderstood another member of a group you were involved in because of cultural differences? If so, how did you and the other person deal with the misunderstanding?

Q:

4. The telephone game, passing a message from person to person, is fun simply because of the inevitable message distortion that gets revealed at the end. Can you think of a time when a message was...