Question

In: Advanced Math

Formulating Financial Statements from Raw Data Following is selected financial information from General Mills, Inc., for...

Formulating Financial Statements from Raw Data
Following is selected financial information from General Mills, Inc., for its fiscal year ended May 25, 2003 ($ millions):

Revenue $10,506
Cash from operating activities 1,631
Cash, beginning year 975
Stockholders' equity 4,475
Noncash assets 17,524
Cash from financing activities (885)
Cost of goods sold 6,109
Total expenses (other than cost of goods sold) 3,480
Cash, ending year 703
Total liabilities 13,752
Cash from investing activities (1,018)

Prepare the income statement, the balance sheet, and the statement of cash flows for General Mills for the fiscal year ended May 2003.

Hint: Enter negative numbers only for answers in the statement of cash flows (if applicable).

General Mills, Inc.

Income Statement ($ millions)

For Year Ended May 25, 2003

Revenue $0
Cash, ending year, total expenses, cost of goods sold, noncash assets 0
Gross Profit 0
Cash, ending year, total expenses, cost of goods sold, noncash assets 0
Net Income 0

General Mills, Inc.

Balance Sheet ($ millions)

May 25, 2003

assets Liabilities

cash $0 Total Liailities $0
cash, beginning year, non cash assets, stock holders equity, net income 0 cash, beginning year, non cash assets, stock holders equity, net income 0
Total assets $0 Total liabilities and equity $0

General Mills, Inc.

Statement of Cash Flows ($ millions)

For Year Ended May 25, 2003

Cash from operating activities $0
Non cash assets, net income, cash, beginning year, cash from investing activities 0
Cash from financing activities 0
Net change in cash 0
Non cash assets, net income, cash, beginning year, cash from investing activities 0
Cash, ending year $0

Does the negative amount for cash from financing activities concern us? Explain. (select)

A negative amount for cash from financing activities implies that the company is unable to pay its debts as they come due and should be interpreted negatively.

A negative amount for cash from financing activities is the result of additional borrowings. Because the additional funds are invested in earnings-generating assets, this should be viewed positively.

A negative amount for cash from financing activities implies that the market value of the company's long-term debt has declined and this change should be viewed negatively.

A negative amount for cash from financing activities reflects the reduction of long-term debt, which is a positive sign of the company’s ability to retire debt obligations.

(c) Using the statements prepared for part a. compute the following ratios (for this part only, use the year-end balance instead of the average for assets and stockholders' equity):

Round answers to two decimal places (example for percentage answers: 0.12345 = 12.35%).

(i) Profit margin
Answer%
(ii) Asset turnover
Answer
(iii) Return on assets
Answer%
(iv) Return on equity
Answer%

Solutions

Expert Solution


Related Solutions

Formulating Financial Statements from Raw Data Following is selected financial information from General Mills, Inc., for...
Formulating Financial Statements from Raw Data Following is selected financial information from General Mills, Inc., for its fiscal year ended May 29, 2016 ($ millions): *Cash from financing activites includes the effects of foreign exhange rate fluctuations. Revenue $16,563.1 Cost of goods sold $10,733.6 Cash from operating activities 2,629.8 Cash, ending year 763.7 Cash, beginning year 334.2 Total liabilities 16,405.2 Stockholders' equity 5,307.1 Cash from investing activities 93.4 Noncash assets 20,948.6 Total expenses (other than cost of goods sold) 4,092.7...
Formulating Financial Statements from Raw Data Following is selected financial information from General Mills, Inc., for...
Formulating Financial Statements from Raw Data Following is selected financial information from General Mills, Inc., for its fiscal year ended May 29, 2011 ($ millions): Revenue $ 14,880.2 Cash from operating activities 1,526.8 Cash, beginning year 673.2 Stockholders' equity 6,612.2 Noncash assets 18,054.9 Cash from financing activities* (865.3) Cost of goods sold 8,926.7 Total expenses (other than cost of goods sold) 4,155.2 Cash, ending year 619.6 Total liabilities 12,062.3 Cash from investing activities (715.1) *Cash from financing activities includes the...
Formulating Financial Statements from Raw Data Assume the following is selected financial information from General Mills,...
Formulating Financial Statements from Raw Data Assume the following is selected financial information from General Mills, Inc., for its fiscal year ended May 25, 2014 ($ millions): Cash and Cash Equivalents $867.3 Net Cash from Operations 2,541.0 Sales 17,909.6 Stockholders' Equity 7,005.4 Cost of Goods Sold 11,539.8 Net Cash from Financing (1,824.1) Total Liabilities 16,140.3 Other Expenses, including income taxes 4,508.5 Noncash Assets 22,278.4 Net Cash from Investing (561.8) Net Income 1,861.3 Effect of exchange rate changes on cash (29.2)...
Formulating Financial Statements from Raw Data Following is selected financial information from Cisco Systems, Inc., for...
Formulating Financial Statements from Raw Data Following is selected financial information from Cisco Systems, Inc., for its fiscal year ended July 30, 2016 ($ millions). Cash, ending year $7,631    Total liabilities $58,067 Cash from operating activities 13,570    Cash from financing activities (4,699) Sales 49,247    Noncash assets 114,021 Stockholders' equity 63,585    Cash from investing activities (8,117) Cost of goods sold 18,287    Net income 10,739 Total expense (other than cost of goods sold) 20,221    Cash, beginning...
Following is selected financial information from General mills, Inc., for its fiscal yeah ended May 27,...
Following is selected financial information from General mills, Inc., for its fiscal yeah ended May 27, 2018($millions): Cash and cash equivalents...$ 399 Nat cash from operations...2,841 Sales...15,740.4 Stockholders' equity...6,492.4 costs of good sold...10,312.9 net cash from financing...5,445.5 total liabilities...24,131.6 other expenses, including income tax...3,264.5 noncash assest...30,225 net cash from investing...(8,685.4) net income...2,163.0 effect of exchange rate changes on cash...31.8 cash, beginning year...766.1 a. prepare income statement, balance sheet, and statement of cash flows for General Mills, Inc. b. What portion...
Selected financial information from General Mills as of May 29, 2016 follows. $ millions Debit Credit...
Selected financial information from General Mills as of May 29, 2016 follows. $ millions Debit Credit Net sales $16,689.6 Cost of sales $10,758.9 Selling, general, & administrative expense & other 3,098.4 Interest expense, net 329.1 Income tax expense 780.5 Retained earnings 12,041.4 Assume the company has not yet closed any accounts to retained earnings. Prepare journal entries to close the temporary accounts above. Set up the needed T-accounts, and post the closing entries. After these entries are posted, what is...
The following is selected raw data financial information from AFI Corp. for its fiscal year ended...
The following is selected raw data financial information from AFI Corp. for its fiscal year ended January 29, 2011 ($ millions): Revenue                                                           $ 3,469 Cash from operating activities                             392 Cash, beginning of year                                         670                                                     Noncash assets                                                    2,122 Cash from financing activities                            (143) Cost of goods sold                                               1,257 Total expenses (other than COGS)                   2,062 Total liabilities                                                      1,057 Cash from investing activities                              (93) How much cash does the company have at the end of the year ? What is the total stockholders’...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y720Y620Y5 Total assets$221,000 $199,000 $177,000 Notes payable (8% interest)70,000 70,000 70,000 Common stock28,000 28,000 28,000 Preferred 5% stock, $100 par14,000 14,000 14,000 (no change during year)       Retained earnings70,600 53,100 42,000 The 20Y7 net income was $18,200, and the 20Y6 net income was $11,800. No dividends on common stock were declared between 20Y5 and 20Y7. Preferred dividends...
The following selected data were taken from the financial statements of Vidahill Inc. for December 31,...
The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y7 20Y6 20Y5 Total assets $268,000 $241,000 $214,000 Notes payable (8% interest) 90,000 90,000 90,000 Common stock 36,000 36,000 36,000 Preferred 3% stock, $100 par 18,000 18,000 18,000 (no change during year) Retained earnings 100,665 69,485 54,000 The 20Y7 net income was $31,720, and the 20Y6 net income was $16,025. No dividends on common stock were declared between...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...
Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 20Y7, 20Y6, and 20Y5: December 31 20Y7 20Y6 20Y5 Total assets $320,000 $288,000 $256,000 Notes payable (8% interest) 110,000 110,000 110,000 Common stock 44,000 44,000 44,000 Preferred 6% stock, $100 par 22,000 22,000 22,000 (no change during year) Retained earnings 117,200 80,880 66,000 The 20Y7 net income was $37,640, and the 20Y6 net income was $16,200. No dividends on common stock were...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT