Question

In: Accounting

Following is selected financial information from JM Smucker Co. for the year ended April 30, 2018...

Following is selected financial information from JM Smucker Co. for the year ended April 30, 2018 ($ millions).

Current assets, end of year $1,710.5 Long-term liabilities, end of year $7,013.9
Cash, end of year 211.9 Stockholders' equity, end of year 8,680.2
Cash from investing activities (305.4) Cash from operating activities 1,339.8
Cost of products sold 4,973.1 Total assets, beginning of year 17,203.7
Total liabilities, end of year 8,151.1 Revenue 8,092.8
Cash from financing activities* (1,006.1) Total expenses, other than cost of 1,647.3
Stockholders' equity, beginning of year 7,535.2 product sold
Dividends paid 385.3

* Cash from financing activities includes the effects of foreign exchange rate fluctuations.

a. Prepare the income statement for the year ended April 30, 2018.

Note: Do not use negative signs with any of your answers.

J M Smucker Co
Income Statement ($ millions)
For the year ended April 30, 2018
Revenues Answer
Cost of product sold Answer
Gross profit Answer
Expenses Answer
Net income Answer

b. Prepare the balance sheet as of April 30, 2018.

J M Smucker Co
Balance Sheet ($ millions)
April 30, 2018
Current assets Answer Current liabilities Answer
Long-term assets Answer Long-term liabilities Answer
Total liabilities Answer
- Stockholders' equity Answer
Total assets Answer Total liabilities and equity Answer


c. Prepare the statement of cash flows for the year ended April 30, 2018.
Note: Use a negative sign with your answer to indicate cash was used by activities and/or a decrease in cash.

J M Smucker Co
Statement of Cash Flow ($ millions)
For the year ended April 30, 2018
Cash from operating activities Answer
Cash from investing activities Answer
Cash from financing activities Answer
Net increase (decrease) in cash Answer
Cash, beginning of year Answer
Cash, end of year Answer

d. Compute ROA.
e. Compute profit margin (PM).
f. Compute asset turnover (AT).
g. Compute ROE.

Notes:
Round ROA, PM, and ROE to one decimal place (ex: 10.5%).
Round AT (asset turnover) to two decimal places (0.33).

ROA Answer
PM Answer
AT Answer
ROE Answer

Solutions

Expert Solution

1.

Income statement

Revenue $8,092.8
Less: Cost of products sold ($4,973.1)
Gross profit $3,119.7
Expenses ($1,647.3)
Net income $1,472.4

2.

Balance sheet

Current assets $1,710.5 Current liabilities $1,137.2
Long term Assets $15,062.9 Long term liabilities $7,013.9
Total Liabilities $8,151.1
Stockholders equity $8,622.3
Total Assets $16.773.4 Total Liabilities and stockholders equity $16,773.4

Stockholders equity

Stockholders equity, beginning $7,535.2
Add: Net income $1,472.4
Less: Dividends ($385.3)
Stockholders equity, Ending $8,622.3

Total assets= Total Liabilities and stockholders equity

Current assets+ Long-term assets =$16.773.4

Long term assets =$16,773.4-$1,710.5

Long-term assets =$15,062.9

3. Statement of cash flows

Cash flow from operating activities $1,339.8
Cash flow from Investing activities ($305.4)
Cash flow from Financing activities ($1,006.1)
Net increase in cash $28.3
Cash, beginning $183.6
Cash , Ending $211.9

4.

ROA = Net income/ Average total assets

=$1,472.4/($16,773.4+$17,203.7)/2

=$1,472.4/$16,988.55

ROA =8.67%

Profit margin = Net income/ Sales

=$1,472.4/$8,092.8

=18.19%

Assets turnover = Sales/ Average total assets

=$8,092.8/$16,988.55

=0.47

Return on equity = Net income/ Average stockholders equity

=$1,472.4/($7,535.2+$8,622.3)/2

=$1,472.4/$8,078.75

=18.22%


Related Solutions

Following is selected financial information from Cisco Systems Inc. for the year ended July 30, 2016...
Following is selected financial information from Cisco Systems Inc. for the year ended July 30, 2016 ($ millions). Cash,endingyear ................ $ 7,631                              Totalliabilities.................. $ 58,067 Cash from operating activities . . . . . . . 13,570               Cash from financing activities . . . . . (4,699) Sales........................... 49,247                                             Noncashassets ................ 114,021 Stockholders’equity .............. 63,585                             Cashfrominvestingactivities...... (8,117) Costofgoodssold................ 18,287                                  Netincome.................... 10,739 Totalexpenses(otherthancostof                                       Cash,beginningyear............ 6,877 goodssold)..................20,221 f Prepare the income statement, balance sheet and the statement of cash flows for Cisco System for the fiscal year ended...
The following selected information for sana co . for year ended 31/12/2018 in euro Sales 520000...
The following selected information for sana co . for year ended 31/12/2018 in euro Sales 520000 Beginning inventory 100000 Purchases 350000 Fright on Purchases 16000 Purchases return 35000 Salaries 44000 50% selling Fright out 3000 Sales discount 2000 Advertising expenses 2200 50% selling Traveling expenses 8000 50% selling Tele 600 Rent expenses 4300 1300$ selling Retained earning 255000 Supplies expenses 5300 Selling Dividend 25000 Bonds 1200000 Interest expenses 1700 Depreciation expenses 6700 50% selling Bad debit expenses 1000 Insurance expenses...
The Matson Company had the following financial information for the year ended April 30 Salaries Expense                         &n
The Matson Company had the following financial information for the year ended April 30 Salaries Expense                                                                              $123,800 Common Stock                                                                                    72,000 Allowance for Doubtful Accounts                                                7,000 Bad Debts Expense                                                                            15,800 Supplies                                                                                                 14,500 Interest Revenue                                                                                 4,600 Accumulated Depreciation                                                           38,000 Sales                                                                                                  500,000 Dividends                                                                                          12,000 Interest Receivable (short term)                                                3,300 Beginning Retained Earnings                                                       28,800 Advertising Expense                                                                       79,000 Accounts Payable                                                                             142,000 Cash Flow from Investing Activities                                          105,000 Notes Receivable (short-term)                                                   17,000...
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’...
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The...
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The company tells you that Income from Continuing Operations PRE Taxes is $ 300,000. However, this amount was computed before the company considered these items: (i.e. none of the items listed below are factored into the $300,000) Restructuring Costs incurred in 2018 were $25,000 When recording depreciation expense for the previous year (2017), they mistakenly recorded depreciation twice for the same asset. The amount of...
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The...
The following information relates to Husk Corn Co. for the year ended December 31, 2018: The company tells you that Income from Continuing Operations PRE Taxes is $ 300,000. However, this amount was computed before the company considered these items: (i.e. none of the items listed below are factored into the $300,000) Restructuring Costs incurred in 2018 were $25,000 When recording depreciation expense for the previous year (2017), they mistakenly recorded depreciation twice for the same asset. The amount of...
The following selected information is available for Jones & Co. Ltd., for the year ended 31 December 20X8:
The following selected information is available for Jones & Co. Ltd., for the year ended 31 December 20X8: Other Information:1. Equipment with an original cost of $100,000 was sold for cash.2. Other equipment was bought for cash.3. There is no income tax expense.4. Cash dividends were paid during the year as well as a $50,000 stock dividend that reduced retained earnings and increased common shares. Required:Present, in good form, the operating, investing, and financing section of the SCF for the...
S Selected information from the comparative financial statements of ZZ Tire Company for the year ended...
S Selected information from the comparative financial statements of ZZ Tire Company for the year ended December 31, appears below: 2014 2013 Accounts receivable (net) $    180,000 $200,000 Inventory 140,000 160,000 Total assets 1,200,000 800,000 Current liabilities 140,000 110,000 Long-term debt 400,000 300,000 Net credit sales 1,330,000 700,000 Cost of goods sold 900,000 530,000 Interest expense 50,000 25,000 Income tax expense 60,000 29,000 Net income 150,000 85,000 There is no preferred stock and the tax rate is 30%. Required: Calculate each...
Selected information from the comparative financial statements of Emley Company for the year ended December 31,...
Selected information from the comparative financial statements of Emley Company for the year ended December 31,                                                                                    2017 2016 Accounts receivable (net)                                 $180,000 $200,000 Inventory                                                                    140,000                 160,000 Total assets                                                             1,200,000                 800,000 Current liabilities                                                       140,000                 110,000 Long-term debt                                                          400,000                 300,000 Net credit sales                                                       1,330,000                 700,000 Cost of goods sold                                                     900,000                 530,000 Interest expense                                                           50,000                   25,000 Income tax expense                                                     60,000                   29,000 Net income                                                                 150,000                   85,000 Compute each of the following ratios and interpret the results: Inventory turnover Times interest earned The...
The financial statements of Pouchie Co. included the following information for the year ended December 31,...
The financial statements of Pouchie Co. included the following information for the year ended December 31, 2016 (amountsin millions Depreciation and amortization expense $260 Cash dividends declared and paid 343 Purchase of equipment 818 Net income 396 Beginning cash balance 128 Proceeds of common stock issued 171 Proceeds from sale of building (at book value) 215 Accounts receivable increase 16 Ending cash balance 92 Inventory decrease 45 Accounts payable increase 54 Required: Complete the following statement of cash flows, using...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT