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%

Respuesta :

Solution:

General Mills, Inc., Income statement for year ended May 25, 2003

Particulars                                               Millions $

Revenue                                                $10,506

Less Cost of goods sold                       - 6,109

                                                            ----------------

Gross profit                                            4,397

                                                            ----------------

Less operating expenses                     - 3,480

                                                            -----------------

                                                                  917

                                                             -----------------

Balance sheet May 25, 2003

Assets             Million $            Liabilities                             Million $

Cash                  703                 Total Liabilities                      13,752

Non cash           17,524            Stockholders' equity              4,475

Total assets       18,227             Total Liabilities & equity       18,227

Statement for cash flows for year ended May 25, 2003

            Particulars                                                     Million $

    Cash from operating activities                                 1,631

    Cash from financing activities                                 - 885

    Cash from investing activities                                 - 1,018

                                                                                    --------------

   Net change in cash                                                      -272

                                                                                    ----------------

   Cash, beginning year                                                   975

                                                                                     -----------------

                                                                                           703

A negative amount for cash from financing activities reflects the reduction of long term debt

                   Profit margin = ( Net income / Revenue ) * 100

                                         = ( 917 / 10,506 ) * 100

                                         = 8.72%

                   Asset turnover = Revenue / total assets

                                             = 10,506 / 18, 227

                                             = 0.57

                  Return on assets =( Net income / Total assets ) * 100

                                                = ( 917 / 18, 227 ) *100

                                                = 5.03%

                  Return of equity = ( Net income / Total shareholder equity )*100

                                               = ( 917 / 4,475 ) *100

                                               = 20.49%

ACCESS MORE
ACCESS MORE
ACCESS MORE
ACCESS MORE