Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The purpose of this assignment is to help students familiarize themselves with financial ratios. Although students need to be familiar with how the ratios are

The purpose of this assignment is to help students familiarize themselves with financial ratios. Although students need to be familiar with how the ratios are calculated, this is not the primary purpose of the assignment. Each student should be able to explain the significance of each ratio presented and how this information conveys economic and financial meaning to either an internal party (i.e. manager) or an external party (i.e. investor or regulator).

The company for analysis this year is Whole Foods Market (Stock Symbol: WFM). Normally, you would download the corporation's annual report to find their financial information. For your convenience, I have attached WFM's financials on the attached spreadsheet.

For the assignment, calculate the following ratios and answer the following questions:

1. Company Financial Ratios (For 2011, 2012, and 2013) (40% of total grade)

Profitability Ratios

Liquidity (Short-Term Solvency) Ratios

Debt Management (Long-Term Solvency) Ratios

Asset Management Ratios

Using a trend analysis, comment on the trends you see in WFM's ratios. Be sure to comment as to whether your findings indicate any particular strength or weakness in WFM's ability to fund its competitive manuervers.

2. Compare the most recent year (2013) of ratios of Whole Foods Market with the largest company within their respective industry, Kroger Foods, Inc. You can download Kroger's 2013 annual report by visiting http://ir.kroger.com/CorporateProfile and clicking on REPORTS & STATEMENTS. (20% of total grade)

3. Using 2013 information, identify five ratios that the student believes indicate financial strength within Whole Foods Market and provide an explanation of his/her position.

4. Using 2013 information, identify five ratios that the student believes indicate financial weakness within Whole Foods Market and provide an explanation of his/her position.

Whole Foods Market, Inc. (NMS: WFM)
Exchange rate used is that of the Year End reported date
As Reported Annual Balance Sheet
Report Date 09/29/2013 09/30/2012 09/25/2011 09/26/2010
Currency USD USD USD USD
Audit Status Not Qualified Not Qualified Not Qualified Not Qualified
Consolidated Yes Yes Yes Yes
Cash & cash equivalents 290000000 89016000 212004000 131996000
Short-term investments - available-for-sale securities 733000000 1131213000 442320000 329738000
Restricted cash 111000000 102873000 91956000 86802000
Accounts receivable 188000000 196503000 175310000 133346000
Merchandise inventories 414000000 374269000 336799000 323487000
Prepaid expenses & other current assets 93000000 76511000 73579000 54686000
Deferred income taxes 151000000 132246000 121176000 101464000
Total current assets 1980000000 2102631000 1453144000 1161519000
Land 77000000 76592000 48928000 48928000
Buildings & leasehold improvements 2427000000 2219763000 1958612000 1863259000
Capitalized real estate leases 33000000 24876000 24262000 24874000
Fixtures & equipment 1706000000 1674089000 1398778000 1240303000
Construction in progress & equipment not yet in service 269000000 53328000 188844000 120845000
Gross property & equipment 4512000000 4048648000 3619424000 3298209000
Less accumulated depreciation & amortization 2084000000 1855965000 1622212000 1412079000
Property & equipment, net of accumulated depreciation and amortization 2428000000 2192683000 1997212000 1886130000
Long-term investments - available-for-sale securities 302000000 221426000 52815000 96146000
Goodwill 679000000 662938000 662938000 665224000
Intangible assets, net of accumulated amortization 65000000 62399000 67234000 69064000
Deferred income taxes 72000000 42834000 50148000 99156000
Other assets 12000000 9305000 8584000 9301000
Total assets 5538000000 5294216000 4292075000 3986540000
Current installments of long-term debt & capital lease obligations - 1012000 466000 410000
Current installments of capital lease obligations 1000000 - - -
Accounts payable 247000000 247089000 236913000 213212000
Accrued payroll, bonus & other benefits due team members 367000000 307164000 281587000 244427000
Dividends payable 37000000 25959000 17827000 -
Other current liabilities 436000000 395964000 342568000 289823000
Total current liabilities 1088000000 977188000 879361000 747872000
Obligations under capital lease agreements for equipment - - 17905000 18299000
Cash flow hedge instrument - - - 399000
Term loan - - - 490000000
Total long-term debt - - - 508698000
Total long-term debt & capital lease obligations - - 17905000 -
Less: current installments - - 466000 410000
Long-term debt & capital lease obligations, less current installments 26000000 23110000 17439000 508288000
Deferred lease liabilities 500000000 440822000 353776000 294291000
Other long-term liabilities 46000000 50627000 50194000 62831000
Total liabilities 1660000000 1491747000 1300770000 1613282000
Common stock 2765000000 2592369000 2120972000 1773897000
Common stock in treasury, at cost 153000000 28599000 - -
Accumulated other comprehensive income (loss) 1000000 5266000 -164000 791000
Retained earnings (accumulated deficit) 1265000000 1233433000 870497000 598570000
Total shareholders' equity 3878000000 3802469000 2991305000 2373258000
As Reported Annual Income Statement
Report Date 09/29/2013 09/30/2012 09/25/2011 09/26/2010
Currency USD USD USD USD
Audit Status Not Qualified Not Qualified Not Qualified Not Qualified
Consolidated Yes Yes Yes Yes
Sales 12917000000 11698828000 10107787000 9005794000
Cost of goods sold & occupancy costs 8288000000 7543054000 6571238000 5870393000
Gross profit 4629000000 4155774000 3536549000 3135401000
Direct store expenses 3285000000 2983419000 2628811000 2375716000
General & administrative expenses 397000000 372065000 310920000 272449000
Pre-opening expenses 52000000 46899000 40852000 38044000
Relocation, store closure & lease termination cost 12000000 9885000 8346000 11217000
Operating income 883000000 743506000 547620000 437975000
Interest expense - 354000 3882000 33048000
Investment & other income 11000000 8892000 7974000 6854000
Income before income taxes 894000000 752044000 551712000 411781000
Current federal income taxes 321000000 233598000 144840000 151349000
Current state income taxes 73000000 53725000 38807000 40730000
Current foreign income taxes 3000000 4541000 5092000 4172000
Total current income taxes 397000000 291864000 188739000 196251000
Deferred federal income taxes (benefit) -44000000 863000 21130000 -23695000
Deferred state income taxes (benefit) -10000000 -6225000 -334000 -6572000
Deferred foreign income taxes (benefit) - -31000 -435000 -36000
Total deferred income taxes (benefit) -54000000 -5393000 20361000 -30303000
Provision for income taxes 343000000 286471000 209100000 165948000
Net income (loss) 551000000 465573000 342612000 245833000
Preferred stock dividends - - - 5478000
Income available to common shareholders 551000000 465573000 342612000 240355000
Weighted average shares outstanding - basic 371200000 364802000 350442000 332488000
Weighted average shares outstanding - diluted 374500000 368888000 354558000 343420000
Year end shares outstanding 372400000 370874000 357772000 344066000
Net income (loss) per share - basic 1.48 1.275 0.98 0.725
Net income (loss) per share - diluted 1.47 1.26 0.965 0.715
Dividends declared per common share 1.4 0.28 0.2 -
Number of full time employees 56700 53100 48200 45300
Number of part time employees 18500 16400 13300 10700
Number of temporary employees 3200 3200 2700 2300
Total number of employees 78400 72700 64200 58300
Number of common stockholders 1384 1453 1512 1547
As Reported Annual Retained Earnings
Report Date 09/29/2013 09/30/2012 09/25/2011 09/26/2010
Currency USD USD USD USD
Audit Status Not Qualified Not Qualified Not Qualified Not Qualified
Consolidated Yes Yes Yes Yes
Previous retained earnings (accumulated deficit) 1233000000 870497000 598570000 358215000
Redeemable preferred stock dividends - - - 5478000
Dividends 519000000 102637000 70447000 -
Other acquisitions - - 238000 -
Retained earnings (accumulated deficit) 1265000000 1233433000 870497000 598570000
As Reported Annual Cash Flow
Report Date 09/29/2013 09/30/2012 09/25/2011 09/26/2010
Currency USD USD USD USD
Audit Status Not Qualified Not Qualified Not Qualified Not Qualified
Consolidated Yes Yes Yes Yes
Net income (loss) 551000000 465573000 342612000 245833000
Depreciation & amortization 339000000 311550000 287109000 275589000
Loss (gain) on disposition of fixed assets - 2223000 2228000 -170000
Impairment of long-lived assets - - 1317000 2237000
Share-based payment expense 57000000 42288000 27259000 22894000
LIFO expense (benefit) 2000000 100000 10250000 -7670000
Deferred income tax expense (benefit) -51000000 -8039000 19540000 -33534000
Excess tax benefit related to exercise of team member stock options -37000000 -50349000 -22741000 -2982000
Accretion of premium/discount on marketable securities 31000000 15710000 - -
Deferred lease liabilities 51000000 77044000 53381000 39636000
Other net income adjustments 9000000 -1695000 5713000 -2371000
Accounts receivable 9000000 -29879000 -35422000 -28447000
Merchandise inventories -42000000 -37075000 -23267000 -3048000
Prepaid expenses & other current assets -17000000 -1779000 -18987000 -1640000
Accounts payable - 9606000 23768000 23454000
Accrued payroll, bonus & other benefits due team member 60000000 25285000 37204000 36133000
Other current liabilities 51000000 94918000 53831000 20030000
Other long-term liabilities -4000000 4234000 -8950000 -659000
Net cash flows from operating activities 1009000000 919715000 754845000 585285000
Development costs of new locations -339000000 -261710000 -203457000 -171379000
Other property & equipment expenditures -198000000 -194539000 -161507000 -85414000
Purchase of intangible assets - - - -
Purchase of available-for-sale securities -1252000000 -3009503000 -1228920000 -1072243000
Sale of available-for-sale securities - - 1155795000 646594000
Sales & maturities of available-for-sale securities 1534000000 2138221000 - -
Decrease (increase) in restricted cash -8000000 -10917000 -5154000 -15779000
Acquisition of intangible assets - - -5157000 -
Payment for purchase of acquired entities, net of cash acquired -22000000 - -1972000 -14470000
Other investing activities -4000000 -2901000 -352000 -2715000
Net cash flows from investing activities -289000000 -1341349000 -450724000 -715406000
Common stock dividends paid -508000000 -94505000 -52620000 -
Preferred stock dividends paid - - - -8500000
Issuance of common stock 81000000 370226000 296719000 46962000
Purchase of treasury stock -125000000 -28599000 - -
Excess tax benefit related to exercise of team member stock options 37000000 50349000 22741000 2982000
Payments on long-term debt & capital lease obligations -2000000 -305000 -490394000 -210350000
Net cash flows from financing activities -517000000 297166000 -223554000 -168906000
Effect of exchange rate changes on cash & cash equivalents -2000000 1480000 -559000 893000
Net change in cash & cash equivalents 201000000 -122988000 80008000 -298134000
Cash & cash equivalents at beginning of year 89000000 212004000 131996000 430130000
Cash & cash equivalents at end of year 290000000 89016000 212004000 131996000
Interest paid 2000000 2839000 15837000 39156000
Federal & state income taxes paid 378000000 201771000 192485000 193044000

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

Step: 3

blur-text-image

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

GAO Yellow Book Government Auditing Standar

Authors: Comptroller General United States Government

2011edition

1479245577, 978-1479245574

More Books

Students also viewed these Accounting questions