Refer to the following financial statements of Quaker Oats Company. Income Statement Balance Sheet continue Using Quakers

Refer to the following financial statements of Quaker Oats Company.

Income Statement

Balance Sheet continue

Using Quaker’s financial statements and the analysis guidance from the chapter, prepare a fore-casted statement of cash flows for Year 12 using the following information:
Selected Forecast Data ($ millions)Year 12
Sources of cash
Assets retirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 20
Uses of cash
Repayment of long-term debt. . . . . . . . . . . . . . . . . . . . . . 45
Capital expenditures—property, plant, and equipment. 300
Cash dividends on capital stock. . . . . . . . . . . . . . . . . . . . 135
Other cash expenditures. . . . . . . . . . . . . . . . . . . . . . . . . . 30
Revenue forecast . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6,000

Additional assumptions for your forecasting task include:
1. Income from continuing operations in Year 12 is expected to equal the average percentage of income from continuing operations to sales for the three-year period ending June 30, Year 11.
2. The depreciation and amortization forecast for Year 12 uses the average percentage relation of depreciation and amortization to income from continuing operations for the period Year 9 through Year 11. The average is computed at 82.33%.
3. Forecasts of deferred income taxes (noncurrent portion) and other items in Year 12 reflect the past three years’ relation of deferred taxes (noncurrent) and other items to total income from continuing operations of 22.9%.
4. Provisions for restructuring charges are predicted to be zero for Year 12.
5. Days’ sales in receivables is expected to be 42 for Year 12.
6. Days’ sales in inventory of 55 and a ratio of cost of sales to sales of 0.51 are forecasted for Year 12.
7. Changes in other current assets are predicted to be equal to the average increase/decrease over the period Year 9 through Year 11 of $25.6.
8. Days’ purchases in accounts payable of 45 is forecasted for Year 12, and purchases are expected to increase in Year 12 by 12% over Year 11 purchases of $2,807.20.
9. Change in other current liabilities is predicted to be equal to the average increase/decrease over the period Year 9 through Year 11 of $24.5.
10. There are no expected discontinued operations.
11. Decreases in short-term debt are predicted at $40 million each year.
12. No cash inflows are expected from issuance of debt for spin-off and no cash effects from purchases or issuances of common and preferred stock.
13. Predicted year-end cash needs are equal to a level measured by the ratio of cash to revenues prevailing in Year 11.
14. Additions to long-term debt in Year 12 are equal to the amount needed to meet the desired year-end cashbalance.

Transcribed Image Text:

Year ended lune 30 ($ millions except per share data) Year 11 Year 10 Year 9 $5,4912 $5,030.6 2,685.9 2,344.7 1,844.1 101.8 Net sales $4,879.4 Cost of goods sold Gross profit Selling, general, and administrative expenses Interest expense-net of $9.0, $11.0, and $12.4 interest income Other expense-net.. 2,651.5 .. 2,121.2 86.2 2,655.3 2,224.1 1,779.0 149.6 382.4 153.5 228.9 59.9) 169.0 Income from continuing operations before income taxes Provision for income taxes 411.5 Income from continuing operations Income (loss) from discontinued operations-net of tax .. (30.0) 235.8 Net income.. 205.8 203.0 Net income available for common 201.5 164.5 203.0 Per common share 3.05 2.93 S1.88 68 $ 2.65 215 2.56 $1.56 140 1.20 79,307 Income from continuing operations . Net income Dividends declared Average number of common shares outstanding (in thousands) 75,904 76,537 BALANCE SHEET Year 11 Year 9 June 30 ($ millions) Assets Current assets Year 10 Cash and cash equivalents Short-term investments, at cost which approximates market Receivables-net of allowances .. .-.. Inventories $30.2 $17.7 21.0 594.4 326.0 691.1 629.9 324.1 110.7 Finished goods 309.1 473.9 107.0 252.2 1481.3 ...422.3 114.5 479.1 Other current assets.. Net current assets of discontinued operations . Total current assets 328.5 1,519.9 26.4 1,456.9 497.3 959.6 .. 1,258.1 Other receivables and investments. . ,9146 681.9 1,232.7 1,745.6 591.5 1,154.1 Properties-net Year 11 Year 10 June 30 (S millions) Assets Intangible assets, net of amortization Net noncurrent assets of discontinued operations.··· Total assets Year 9 466.7 160.5 484.7 135.3 446.2 -- .. . . $3,016.1 $3,326.1 $3,125.9 Liabilities and Equity Current liabilities 80.6 343.2 32.3 354.0 102.2 30.0 333.8 Current portion of long-term debt. . Trade accounts payable.. Accrued payrolls, pensions, and bonuses Accrued advertising and merchandising Income taxes payable . .. . 32.9 350.9 .. 116.3 105.7 45.1 29.6 ..1658 926.9 g2.6 36.3 67.1 164.9 824.1 766.8 89.5 308.4 Other accrued liabilities 173.8 Total current liabilities. … 1,138.5 Long-term debt Deferred income taxes Preferred stock, no par value, authorized 1,750,000 shares: 701.2 115.5 366.7 740.3 100.3 327.7 issued 1,282,051 of $5.46 cumulative convertible shares in Year 9 (liquidating preference $78 per share).. 100.0 100.0 (98.2) Deferred compensation Treasury preferred stock, at cost, 10,089 shares at lune 30, Year 11 (100.0) Common shareholders' equity Common stock, $5 par value, authorized 200,000,000 shares; issued 83,989.396 shares Additional paid-in capital Reinvested earnings Cumulative exchange adjustment .i . . Deferred compensation Treasury common stock, at cost, 7,660,675 shares; 8,402,871 420.0 12.9 1,164.7 (29.3) (164.1) 420.0 18.1 1,106.2 (56.6) (165.8) 420.0 1,0475 (52.9) 8,402,871 (168 (352.8) (386.7) 1,017.5 shares, and 5,221,981 shares, respectively (184.8) 1,137.1 $3,326. $3,125.9 Total liabilities and common shareholders' equity .$3,016.1