In: Accounting
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 |
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%