Question

In: Accounting

Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and...

Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet
Following are the income statements and balance sheets of General Mills, Inc.

Income Statement,
Fiscal Years Ended ($ millions)
May 29, 2011 May 30, 2010
Net Sales $ 14,880.2 $ 14,635.6
Cost of sales 8,926.7 8,835.4
Selling, general and administrative expenses 3,192.0 3,162.7
Divestitures (gain), net (17.4) --
Restructuring, impairment, and other exit costs 4.4 31.4
Operating income 2,774.5 2,606.1
Interest, net 346.3 401.6
Earnings before income tax expense and equity in income of affiliates 2,428.2 2,204.5
Income tax expense 721.1 771.2
After-tax earnings from joint ventures 96.4 101.7
Net earnings including noncontrolling interests 1,803.5 1,535.0
Net earnings attributable to noncontrolling interests 5.2 4.5
Net earnings attributable to General Mills $ 1,798.3 $ 1,530.5
Balance Sheet
($ millions)
May 29, 2011 May 30, 2010
Assets
Cash and cash equivalents $ 619.6 $ 673.2
Receivables 1,162.3 1,041.6
Inventories 1,609.3 1,344.0
Deferred income taxes 27.3 42.7
Prepaid expenses and other current assets 483.5 378.5
Total current assets 3,902.0 3,480.0
Land, buildings and equipment 3,345.9 3,127.7
Goodwill 6,750.8 6,592.8
Other intangible assets 3,813.3 3,715.0
Other assets 862.5 763.4
Total assets $ 18,674.5 $ 17,678.9
Liabilities and Equity
Accounts payable $ 995.1 $ 849.5
Current portion of long-term debt 1,031.3 107.3
Notes payable 311.3 1,050.1
Other current liabilities 1,321.5 1,762.2
Total current liabilities 3,659.2 3,769.1
Long-term debt 5,542.5 5,268.5
Deferred income taxes 1,127.4 874.6
Other liabilities 1,733.2 2,118.7
Total liabilities 12,062.3 12,030.9
Stockholders' equity
Common stock, 754.6 shares issued, $0.10 par value 75.5 75.5
Additional paid-in capital 1,319.8 1,307.1
Retained earnings 9,191.3 8,122.4
Common stock in treasury, at cost, shares of 109.8 and 98.1 (3,210.3) (2,615.2)
Accumulated other comprehensive loss (1,010.8) (1,486.9)
Total shareholders' equity 6,365.5 5,402.9
Noncontrolling interests 246.7 245.1
Total equity 6,612.2 5,648.0
Total Liabilities and Equity $ 18,674.5 $ 17,678.9


Forecast General Mill's fiscal 2012 income statement using the following relations (assume "no change" for accounts not listed).

Net sales growth 6.0%
Cost of sales/Net sales 60.0%
Selling, general and administrative expenses/Net sales 21.5%
Divestitures (gain), net $--
Restructuring, impairment, and other exit costs $--
Interest, net $346.3
Income tax expense/Pretax income 29.7%
After-tax earnings from joint ventures $96.4
Net earnings attributable to noncontrolling interests/Net earnings before attribution 0.5%
  • Round all answers to one decimal place.

  • Do not use negative signs with your answers.

Income Statement, Fiscal Years Ended ($ millions) 2012
Estimated
Net sales Answer
Cost of goods sold Answer
Selling, general and administrative expenses Answer
Divestitures (gain), net Answer
Restructuring, impairment, and other exit costs Answer
Operating income Answer
Interest expense Answer
Earnings before income tax expense and equity in income of affiliates Answer
Income tax expense Answer
Equity in income of affiliates Answer
Net earnings including noncontrolling interests Answer
Net earnings attributable to noncontrolling interests Answer
Net earnings attributable to General Mills Answer


Forecast General Mill's fiscal 2012 balance sheet using the following relations (assume"no change" for accounts not listed). Assume that all capital expenditures are purchases of land, building and equipment, net. ($ millions).

Receivables/Net sales 7.8%
Inventories/Net sales 10.8%
Deferred income tax/Net sales 0.2%
Prepaid expenses and other current assets/Net sales 3.2%
Other intangible assets $0 amortization
Other Assets/Net sales 5.8%
Accounts payable/Net sales 6.7%
Other current liabilities/Net sales 8.9%
Current portion of long-term debt $733.6
Deferred income taxes/Net sales 7.6%
Other liabilities/Net sales 11.6%
Noncontrolling interests *
Capital expenditures/Net sales 4.4%
Depreciation/Prior year net PPE 20.7%
Dividends/Net income 40.6%
Current maturities of long-term debt in fiscal 2013 $733.6
*increase by net income attributable to noncontrolling interests and assume no dividends
  • Round answers to one decimal place.

  • Do not negative signs with your answers.

Balance Sheet
($ millions)
2012
Estimated
Assets
Cash and cash equivalents Answer
Receivables Answer
Inventories Answer
Deferred income taxes Answer
Prepaid expenses and other Answer
Total current assets Answer
Land, buildings, and equipment Answer
Goodwill Answer
Other intangible assets Answer
Other assets Answer
Total assets Answer
Liabilities and equity
Accounts payable Answer
Current portion of long-term debt Answer
Notes payable Answer
Other current liabilities Answer
Total current liabilities Answer
Total long-term debt Answer
Deferred income taxes Answer
Other liabilities Answer
Total liabilities Answer
Stockholders equity
Common stock Answer
Additional paid-in capital Answer
Retained earnings Answer
Common stock in treasury Answer
Accumulated other comprehensive loss Answer
Total shareholders' equity Answer
Noncontrolling interests Answer
Total equity Answer
Total liabilities and Equity Answer

PreviousSave AnswersNext

Solutions

Expert Solution

Income Statement,
Fiscal Years Ended ($ millions) 2012
Net Sales $ 14,880.2*1.06 $ 15773.01
Cost of sales 15773.01*60% $ 9463.80
Selling, general and administrative expenses 15773.01*21.5% $          3,391.19
Divestitures (gain), net $             (17.40)
Restructuring, impairment, and other exit costs $                4.40
Operating income $          2931.02
Interest, net $            346.30
Earnings before income tax expense and equity in income of affiliates $ 2584.72
Income tax expense 29.7% $ 767.66
After-tax earnings from joint ventures $              96.40
Net earnings including noncontrolling interests $ 1720.66
Net earnings attributable to noncontrolling interests 0.5% $ 8.60
Net earnings attributable to General Mills $ 1712.06
Balance Sheet
($ millions)
2012
Estimated
Assets
Cash & Cash Equivalents 1380.77
Receivables =$15773.01*7.8% 1230.29
Inventories =$ 15773.01*10.8% 1703.48
Deferred income taxes =$ 15773.01*0.2% 31.54
prepaid expenses and others currents assets =$15773.01*3.2% 504.73
Total Current Assets 4850.81
land, building and equipment 3,345.9
Goodwill 6,750.8
other intangible assets 3,813.3
Other assets =$15773.01*5.8% 914.83
Total Assets 19675.64
Liabilities and Equity
Accounts Payable =$15773.01*6.7% 1056.79
Current portion of long term debts 733.6
Notes Payable 311.3
Other Current liabilities =$15773.01*8.9% 1403.79
Total Current liabilities 3505.48
Total long-term debt =5542.5-733.6 4808.9
Deferred income taxes =$15773.01*7.6% 1198.74
Other liabilities =$15773.01*11.6% 1829.66
Total liabilities 11342.78
Stockholder's Equity
Common Stock 75.5
Additional paid-in Capital 1319.8
Retained Earning =9191.3+ 1712.06 10903.36
Common Stock in treasury (3210.3)
Accumulated other comprehensive loss (1010.8)
Total Shareholder's equity 8077.56
Non-controlling interests =246.7+8.6 255.3
Total Equity 8332.86
Total liabilities and Equity 19675.64

Related Solutions

Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and...
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of Best Buy Co., Inc. Income Statement, Fiscal Years Ended ($ millions) Feb. 26, 2011 Feb. 27, 2010 Revenue $ 50,272 $ 49,694 Cost of goods sold 37,611 37,534 Restructuring charges - cost of goods sold 24 -- Gross profit 12,637 12,160 Selling, general and administrative expenses 10,325 9,873 Restructuring charges 198 52 Goodwill and tradename impairment -- -- Operating income 2,114...
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and...
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of Best Buy Co., Inc. Income Statement, Fiscal Years Ended ($ millions) Feb. 26, 2011 Feb. 27, 2010 Revenue $ 50,272 $ 49,694 Cost of goods sold 37,611 37,534 Restructuring charges - cost of goods sold 24 -- Gross profit 12,637 12,160 Selling, general and administrative expenses 10,325 9,873 Restructuring charges 198 52 Goodwill and tradename impairment -- -- Operating income 2,114...
Question text Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income...
Question text Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of Macy's, Inc. Consolidated Statement of Income Fiscal Years Ended ($ millions) February 2, 2013 January 28, 2012 January 29, 2011 Net sales $ 27,686 $ 26,405 $ 25,003 Cost of goods sold 16,538 15,738 14,824 Gross margin 11,148 10,667 10,179 Selling, general and administrative expenses 8,482 8,281 8,260 Impairments, store closing costs and (gain) on sale of leases 5...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Following are the financial statements...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Following are the financial statements of Nike, Inc. Consolidated Statements of Income Year ended May 31 In Millions 2011 2010 Revenues $ 20,862 $ 19,014 Cost of sales 11,354 10,214 Gross profit 9,508 8,800 Demand creation expense 2,448 2,356 Operating overhead expense 4,245 3,970 Total selling and administrative expense 6,693 6,326 Interest expense (income), net 4 6 Other (income) (33) (49) Income before income taxes 2,844 2,517 Income taxes...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Following are the financial statements...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Following are the financial statements of Nike, Inc. Consolidated Statements of Income Year ended May 31 In Millions 2011 2010 Revenues $ 20,862 $ 19,014 Cost of sales 11,354 10,214 Gross profit 9,508 8,800 Demand creation expense 2,448 2,356 Operating overhead expense 4,245 3,970 Total selling and administrative expense 6,693 6,326 Interest expense (income), net 4 6 Other (income) (33) (49) Income before income taxes 2,844 2,517 Income taxes...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance...
Analyzing, 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 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...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance...
Analyzing, 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 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...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Assume the following are the...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Assume the following are the financial statements of Nike, Inc. Consolidated Statements of Income Year ended May 31 In Millions 2011 2010 Revenues $ 21,862 $ 20,014 Cost of sales 11,354 10,214 Gross profit 10,508 9,800 Demand creation expense 3,248 2,356 Operating overhead expense 4,345 3,970 Total selling and administrative expense 7,593 6,326 Interest expense (income), net 4 6 Other (income) (33) (49) Income before income taxes 2,944 3,517...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Assume the following are the...
Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows Assume the following are the financial statements of Nike, Inc. Consolidated Statements of Income Year ended May 31 In Millions 2011 2010 Revenues $ 21,862 $ 19,014 Cost of sales 11,354 10,214 Gross profit 10,508 8,800 Demand creation expense 2,948 2,356 Operating overhead expense 4,845 3,970 Total selling and administrative expense 7,793 6,326 Interest expense (income), net 4 6 Other (income) (33) (49) Income before income taxes 2,744 2,517...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below:...
FORECASTING FINANCIAL STATEMENTS - Company A reported an income statement and balance sheet as shown below: Company A Income Statement For the Years Ended 2017 Sales 550.00 Cost of sales 275.00 Gross profit 275.00 SG&A 55.00 Depreciation 60.00 Interest 14.47 Pretax income 145.53 Tax 43.66 Net income 101.87 Company A Balance Sheet As of 2017 Cash 60.00 Accounts receivable 5.00 Inventory 8.00 Total current assets 73.00 PP&E - gross 600.00 Accumulated depreciation 200.00 PP&E - net 400.00 Total assets 473.00...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT