Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

If the format is hard to understand, use this. I believe that data is same from another chegg problem. Please double check to confirm Following

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

If the format is hard to understand, use this. I believe that data is same from another chegg problem. Please double check to confirm

Following are the income statement and balance sheet of Whole Foods Market Inc.

WHOLE FOODS MARKET INC.
Consolidated Statement of Operations
Fiscal Years Ended (in millions) Sept 25, 2016 Sept 27, 2015
Sales $15,724 $15,389
Cost of goods sold and occupancy costs 10,313 9,973
Gross profit 5,411 5,416
Selling, general and administrative expenses 4,477 4,472
Pre-opening expenses 64 67
Relocation, store closures and lease termination costs 13 16
Operating income 857 861
Interest expense (41) -
Investment and other income 11 17
Income before income taxes 827 878
Provision for income taxes 320 342
Net Income $507 $536
WHOLE FOODS MARKET INC.
Consolidated Balance Sheet
(In millions) Sept 25, 2016 Sept 27, 2015
Assets
Current assets
Cash and cash equivalents $351 $237
Short-term investments-available-for-sale securities 379 155
Restricted cash 122 127
Accounts receivable 242 218
Merchandise inventories 517 500
Prepaid expenses and other current assets 167 108
Deferred income taxes 197 199
Total current assets 1,975 1,544
Property and equipment, net 3,442 3,163
Long-term investments--available-for-sale securities - 63
Goodwill 710 710
Intangible assets, net 74 79
Deferred income taxes 100 144
Other assets 40 38
Total assets $6,341 $5,741
Liabilities and shareholders' equity
Current liabilities
Current installments of long-term debt& capital lease obligations $3 $3
Accounts payable 307 295
Accrued payroll, bonus and other benefits due team members 407 436
Dividends payable 43 45
Other current liabilities 581 473
Total current liabilities 1,341 1,252
Long-term debt& capital lease obligations, less current installments 1,048 62
Deferred lease liabilities 640 587
Other long-term liabilities 88 71
Total liabilities 3,117 1,972
Shareholders' equity
Common stock, no par value, 1,200 shares authorized;377.0 and 377.1 shares issued; 318.3 and 348.9 share outstanding at 2016 and 2015, respectively 2,933 2,904
Common stock in treasury, at cost, 58.7 and 28.2 shares at 2016 and 2015, respectively (2,026) (1,124)
Accumulated other comprehensive income loss (32) (28)
Retained earnings 2,349 2,017
Total shareholders' equity 3,224 3,769
Total liabilities and shareholders' equity $6,341 $5,741

E11-28. Analyze, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market Inc. WHOLE FOODS MARKET INC. Consolidated Statements of Operations Fiscal Years Ended (in millions) Sept 25, 2016 Sept 27, 2015 ....................DIO, TVIU,VOJ Sales.. .... $15,724 $15,389 Cost of goods sold and occupancy costs ....... .... 10,313 9,973 Gross profit ............................. ...5,411 5,416 Selling, general and administrative expenses........ ....4,477 4,472 Pre-opening expenses ....... ..... 64 67 Relocation, store closures, and lease termination costs......... 13 Operating income ........... .. 857 861 Interest expense.... ....(41) Investment and other income. ....... .... 11 Income before income taxes...... .827 878 Provision for income taxes........ ... 320 Net income ..................... $ 507 $ 536 ........... 342 WHOLE FOODS MARKET INC. Consolidated Statements of Operations September 25, 2016 September 27, 2015 In millions 199 3,163 ........40 Assets Current assets Cash and cash equivalents......... .....$ 351 $ 237 Short-term investments available-for-sale securities.. ....... 379 155 Restricted cash. ............... .. ........ 122 127 Accounts receivable .......... ...... 242 218 Merchandise inventories........... ........517 500 Prepaid expenses and other current assets ................... 167 108 Deferred income taxes.... . ................ 197 Total current assets ........ ........1,975 1,544 Property and equipment, net of accumulated depreciation and amortization........ 3,442 Long-term investmentsavailable-for-sale securities ... 63 T ES............. Goodwill........ ....................... 710 710 Intangible assets, net of accumulated amortization..... .....7479 Deferred income taxes......... ........ 100 144 Other assets ....... Total assets. ......... $6,341 $5,741 Liabilities and Shareholders' Equity Current liabilities Current instaliments of long-term debt and capital lease obligations ........ .................. $3 Accounts payable ......... ........ 307 295 Accrued payroll, bonus, and other benefits due team members....... ....... 407 Dividends payable ........ ............................43 45 Other current liabilities............. ........... 581 Total current liabilities...... ....... 1,341 1,252 Long-term capital lease obligations, less current installments. . . . . . 1,048 62 Deferred lease liabilities... ...............640 587 Other long-term liabilities ...................................88 Total liabilities. ....3,117 1,972 Shareholders' equity Common stock, no par value, 1,200 shares authorized: 377.0 and 377.1 shares issued: 318.3 and 348.9 shares outstanding at 2016 and 2015, respectively. ..... ... 2,933 2,904 Common stock in treasury, at cost, 58.7 and 28.2 shares at 2016 and 2015, respectively. ......... .... (2,026) (1,124) Accumulated other comprehensive loss... . (32) (28) Retained earnings ......... .2,349 Total shareholders' equity........ 3,224 3,769 Total liabilities and shareholders' equity......... $6,341 $5,741 $3 436 2,017 Required a.Forecast the 2017 income statement for Whole Foods using the following forecast assumptions, which are expressed as a percentage of sales unless otherwise noted ($ in millions). Sales growth. .......... Cost of goods sold and occupancy costs.. Selling, general and administrative expenses............ Pre-opening expenses ....... Relocation, store closure and lease termination costs...... Interest expense......... Investment and other income..... Provision for income taxes as a percentage of pretax income. ......1% .65.6% 28.5% 0.4% ..... $0 .. No change No change . 37% b.Forecast the 2017 balance sheet for Whole Foods using the following forecast assumptions ($ in millions). . . Accounts receivable/Sales....................... Merchandise inventories/Sales ............................ Prepaid expenses and other current assets/Sales....... Deferred income taxes (current assets)/Sales. ... Deferred income taxes (noncurrent assets)/Sales.... Accounts payable/Sales........ Accrued payroll, bonus and other benefits due team members/Sale: Other current liabilities/Sales ....... Depreciation expense as a percentage of PPE, net, at start of the yea CAPEX and development of new properties (all PPE) as a percentage of Sales. Amortization of intangible assets.. Dividends payable as a percentage of dividends. Long-term debt repayment due in 2017... . Long-term debt repayment due in 2018.... Increase in treasury stock in 2017... Dividends as percentage of net income... ............. 1.8% .....3.3% .... 1.1% .... 1.3% ....0.6% ..... 2.0% .... 2.6% ..3.7% .... 15.0% ....5.0% ..... $6 . 25.0% .... $3 .... $65 $200 .... 30.0% . . . Assume no change for goodwill, other assets, deferred lease liabilities, other long-term liabilities, common stock, and AOCL. c. What does the forecasted adjustment to balance the accounting equation from part a reveal to us about the forecasted cash balance and related financing needs of the company? E11-28. Analyze, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market Inc. WHOLE FOODS MARKET INC. Consolidated Statements of Operations Fiscal Years Ended (in millions) Sept 25, 2016 Sept 27, 2015 ....................DIO, TVIU,VOJ Sales.. .... $15,724 $15,389 Cost of goods sold and occupancy costs ....... .... 10,313 9,973 Gross profit ............................. ...5,411 5,416 Selling, general and administrative expenses........ ....4,477 4,472 Pre-opening expenses ....... ..... 64 67 Relocation, store closures, and lease termination costs......... 13 Operating income ........... .. 857 861 Interest expense.... ....(41) Investment and other income. ....... .... 11 Income before income taxes...... .827 878 Provision for income taxes........ ... 320 Net income ..................... $ 507 $ 536 ........... 342 WHOLE FOODS MARKET INC. Consolidated Statements of Operations September 25, 2016 September 27, 2015 In millions 199 3,163 ........40 Assets Current assets Cash and cash equivalents......... .....$ 351 $ 237 Short-term investments available-for-sale securities.. ....... 379 155 Restricted cash. ............... .. ........ 122 127 Accounts receivable .......... ...... 242 218 Merchandise inventories........... ........517 500 Prepaid expenses and other current assets ................... 167 108 Deferred income taxes.... . ................ 197 Total current assets ........ ........1,975 1,544 Property and equipment, net of accumulated depreciation and amortization........ 3,442 Long-term investmentsavailable-for-sale securities ... 63 T ES............. Goodwill........ ....................... 710 710 Intangible assets, net of accumulated amortization..... .....7479 Deferred income taxes......... ........ 100 144 Other assets ....... Total assets. ......... $6,341 $5,741 Liabilities and Shareholders' Equity Current liabilities Current instaliments of long-term debt and capital lease obligations ........ .................. $3 Accounts payable ......... ........ 307 295 Accrued payroll, bonus, and other benefits due team members....... ....... 407 Dividends payable ........ ............................43 45 Other current liabilities............. ........... 581 Total current liabilities...... ....... 1,341 1,252 Long-term capital lease obligations, less current installments. . . . . . 1,048 62 Deferred lease liabilities... ...............640 587 Other long-term liabilities ...................................88 Total liabilities. ....3,117 1,972 Shareholders' equity Common stock, no par value, 1,200 shares authorized: 377.0 and 377.1 shares issued: 318.3 and 348.9 shares outstanding at 2016 and 2015, respectively. ..... ... 2,933 2,904 Common stock in treasury, at cost, 58.7 and 28.2 shares at 2016 and 2015, respectively. ......... .... (2,026) (1,124) Accumulated other comprehensive loss... . (32) (28) Retained earnings ......... .2,349 Total shareholders' equity........ 3,224 3,769 Total liabilities and shareholders' equity......... $6,341 $5,741 $3 436 2,017 Required a.Forecast the 2017 income statement for Whole Foods using the following forecast assumptions, which are expressed as a percentage of sales unless otherwise noted ($ in millions). Sales growth. .......... Cost of goods sold and occupancy costs.. Selling, general and administrative expenses............ Pre-opening expenses ....... Relocation, store closure and lease termination costs...... Interest expense......... Investment and other income..... Provision for income taxes as a percentage of pretax income. ......1% .65.6% 28.5% 0.4% ..... $0 .. No change No change . 37% b.Forecast the 2017 balance sheet for Whole Foods using the following forecast assumptions ($ in millions). . . Accounts receivable/Sales....................... Merchandise inventories/Sales ............................ Prepaid expenses and other current assets/Sales....... Deferred income taxes (current assets)/Sales. ... Deferred income taxes (noncurrent assets)/Sales.... Accounts payable/Sales........ Accrued payroll, bonus and other benefits due team members/Sale: Other current liabilities/Sales ....... Depreciation expense as a percentage of PPE, net, at start of the yea CAPEX and development of new properties (all PPE) as a percentage of Sales. Amortization of intangible assets.. Dividends payable as a percentage of dividends. Long-term debt repayment due in 2017... . Long-term debt repayment due in 2018.... Increase in treasury stock in 2017... Dividends as percentage of net income... ............. 1.8% .....3.3% .... 1.1% .... 1.3% ....0.6% ..... 2.0% .... 2.6% ..3.7% .... 15.0% ....5.0% ..... $6 . 25.0% .... $3 .... $65 $200 .... 30.0% . . . Assume no change for goodwill, other assets, deferred lease liabilities, other long-term liabilities, common stock, and AOCL. c. What does the forecasted adjustment to balance the accounting equation from part a reveal to us about the forecasted cash balance and related financing needs of the company

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

Energy Audit Of Building Systems An Engineering Approach

Authors: Moncef Krarti

3rd Edition

0367820463, 978-0367820466

More Books

Students also viewed these Accounting questions

Question

Explain the steps involved in training programmes.

Answered: 1 week ago

Question

What are the need and importance of training ?

Answered: 1 week ago

Question

9. Describe the characteristics of power.

Answered: 1 week ago

Question

3. Identify and describe nine cultural value orientations.

Answered: 1 week ago