Use the data provided in the attached excel spreadsheet

Reference no: EM131018306

2012 FINANCIAL DATA FOR SELECTED GROCERS
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

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 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.

Reference no: EM131018306

Questions Cloud

Bandstra coporation had a book balance in its cash account : At March 31, Bandstra Co. had a book balance in its cash account of $5,500. At the end of March the company determined that it had outstanding checks of $900, deposits in transit of $600, a bank service charge of $20, and an NSF check from a customer..

What are the biological and behavioral adaptations : What are the biological and behavioral adaptations that allowed for the increase of human brain size?How has our diet changed over the past 2 million years, and how do we know?

Determine the percent saturation of hemoglobin in tissue : Determine the percent saturation of hemoglobin in tissue at normal temperature and at 43 degree?

What is retained earnings where do retained earnings come : What are organizational Expenses? Give a few examples. What is retained earnings? Where do retained earnings come from. Is retained earnings the same thing as cash? What is cumulative preferred stock?

Use the data provided in the attached excel spreadsheet : Use the data provided in the attached Excel spreadsheet to conduct a thorough financial analysis.

Compute the cost of the units transferred to the next : Data concerning a recent period's activity in the Prep Department, the first processing department in a company that uses process costing, appear below:

Construct the cash flow statement for the year 2014 : Construct the cash flow statement for the year 2014

Ajax had average costs per unit of 10 when sales equaled : Ajax had average costs per unit of $10 when sales equaled 10,000 units and average costs per unit of $6.50 when sales equaled 24,000 units. Ajax had total costs of $50,000 when 5,000 units were sold. When sales equaled 12,000 units, total costs were ..

Assume that the company uses the weighted average method : Assume that the company uses the weighted-average method of accounting for units and costs. Determine the equivalent units for June for the first process.

User Account

All Pages