Calculating activity and profitability ratios
• LO4–10
Financial statements for Askew Industries for 2018 are shown below (in thousands):
2018 Income Statement
Sales | $9,000 |
Cost of goods sold | (6,300) |
Gross profit | 2,700 |
Operating expenses | (2,000) |
Interest expense | (200) |
Tax expense | (200) |
Net income | $ 300 |
Comparative Balance Sheets
Dec. 31 | ||
2018 | 2017 | |
Assets | ||
Cash | $ 600 | $ 500 |
600 | 400 | |
Inventory | 800 | 600 |
Property, plant, and equipment (net) | 2,000 | 2,100 |
$4,000 | $3,600 | |
Liabilities and Shareholders’ Equity | ||
Current liabilities | $1,100 | $ 850 |
Bonds payable | 1,400 | 1,400 |
Paid-in capital | 600 | 600 |
900 | 750 | |
$4,000 | $3,600 |
Required:
Calculate the following ratios for 2018.
- 1. Inventory turnover ratio
- 2. Average days in inventory
- 3. Receivables turnover ratio
- 4. Average collection period
- 5. Asset turnover ratio
- 6. Profit margin on sales
- 7. Return on assets
- 8. Return on shareholders’ equity
- 9. Equity multiplier
- 10. Return on shareholders’ equity (using the DuPont framework)
(1)
Activity ratios:
It measures the capacity of a company to use its asset, liability and capital accounts to generate revenue in the form of cash.
Profitability ratios:
It measures the companies efficiency of operations and performance that generates profit
For the company
To calculate: Inventory turnover ratio of A Incorporation for the year 2018.
Explanation of Solution
Calculate the inventory turnover ratio of A Incorporation for the year 2018
Working note:
Explanation:
Inventory turnover ratio is used to determine the number of times inventory used (or) sold during the particular accounting period.
Hence, the inventory turnover ratio of A Incorporation is 9.0 Times for the year 2018.
(2)
To calculate: Average days in inventory of A Incorporation for the year 2018.
Explanation of Solution
Calculate the average days in inventory of A Incorporation for the year 2018
Working note:
On the Average A Incorporation takes 40 days to convert inventory into sales in the operation cycle.
Hence, the average days in inventory for A Incorporation for the year 2018 is 40.56 Days
(3)
To calculate: Receivables turnover ratio of A Incorporation for the year 2018
Explanation of Solution
Calculate the receivables turnover ratio of A Incorporation for the year ended 2018
Working note:
Receivables turnover ratio indicates how quickly a company is able to collect its accounts receivable.
Hence, the Receivables turnover ratio of A Incorporation is 18 Times for the year 2018
(4)
To calculate: Average collection period of A Incorporation for the year 2018
Explanation of Solution
Calculate the Average collection period of A Incorporation for the year 2018
Working note:
On the average it takes 20.28 days for A Incorporation to collect receivables from its customers.
Hence the, Average collection period of A Incorporation for the year 2018 is 20.28 Days for the year 2018.
(5)
To calculate: Asset turnover ratio of A Incorporation for the year 2018
Explanation of Solution
Calculate the Asset turnover ratio of A Incorporation for the year 2018
Working note:
1. Calculate the total assets:
Total assets turnover ratio indicates that A Incorporation has generated $2.37 in sales for every $1.00 of assets.
Hence, the Asset turnover ratio of A Incorporation is $2.37 for the year ended 2018.
(6)
To calculate: Profit margin on sales of A Incorporation for the year ended 2018
Explanation of Solution
Calculate the profit margin on sales of A Incorporation for the year ended 2018
Profit margin on sales of A Incorporation has Net income of $0.033 for every $1.00 of Total revenue earned.
Hence, the Profit margin on sales of A Incorporation is 3.33% for the year 2018
(7)
To calculate: Return on assets of A Incorporation for the year ended 2018.
Explanation of Solution
Calculate the Return on assets of A Incorporation for the year ended 2018
Working note:
Calculate the total assets
7.89% of profit is earned by A Incorporation in relation to its total assets for the year ended 2018.
Hence, the rate of return of A Incorporation is 7.89% for the year ended 2018.
(8)
To calculate: Return on shareholders’ equity of A Incorporation for the year ended 2018
Explanation of Solution
Calculate the return on shareholders’ equity of A Incorporation for the year ended 2018
Working notes:
1. Calculate the total shareholders’ equity at the beginning and total shareholders’ equity at the ending
Details |
year | year |
2018 | 2017 | |
Paid in capital | $600 | $600 |
Retained earning | $900 | $750 |
Total | $1,500 | $1,350 |
Table (1)
2. Calculate the total equity
Rate of return on shareholders’ equity reveals the profit that the company generates with the money shareholders’ have invested.
Hence, the rate of return of shareholders’ equity of A Incorporation for the year ended 2018 is 21.1%
(9)
To Calculate: Equity multiplier of A Incorporation for the year 2018
Explanation of Solution
Calculate the Equity multiplier of A Incorporation for the year 2018
Working note:
1. Calculate total assets
2. Calculate the total shareholders’ equity at the beginning and total shareholders’ equity at the ending
Details | year | year |
2018 | 2017 | |
Paid in capital | $600 | $600 |
Retained earning | $900 | $750 |
Total | $1,500 | $1,350 |
Table (2)
3. Calculate total shareholders’ equity
Equity multiplier is the financial leverage ratio that measures the total asset of the company to its total shareholders’ equity. If the ratio is higher than the company uses more of debt financing than equity.
Hence, the equity multiplier of A Incorporation is 2.67 for the year ended 2018.
(10)
To Calculate: Return on shareholders’ equity (using the DuPont framework) for the year
2018.
Explanation of Solution
Calculate the Return on shareholders’ equity (using the DuPont framework) for the
Year 2018
DuPont framework of measuring Return on shareholders’ equity states that
The company’s Return on equity can be measured by the product of three ratios namely;
1. Profit margin on sales
2. Asset turnover ratio
3. Equity multiplier
Hence, the Return on shareholders’ equity of A Incorporation for the year
2018 is 21.1%.
Want to see more full solutions like this?
Chapter 4 Solutions
SPICE ND LL INTERM ACCTG W/CONN+ AC
- E10.18 (LO 5), AN Suppose the following financial data were reported by 3M Company for 2021 and 2022 (dollars in millions). 3M CompanyBalance Sheets (partial) 2022 2021 Current assets Cash and cash equivalents $ 3,040 $1,849 Accounts receivable, net 3,250 3,195 Inventories 2,639 3,013 Other current assets 1,866 1,541 Total current assets $10,795 $9,598 Current liabilities $ 4,897 $5,839 Instructions Calculate the current ratio and working capital for 3M for 2021 and 2022. Suppose that at the end of 2022, 3M management used $300 million cash to pay off $300 million of accounts payable. How would its current ratio and working capital have changed?arrow_forwardE4.17 (LO 2, 3, 5) The following information was taken from the records of Roland Carlson Inc. for the year 2020: Income tax applicable to income from continuing operations $187,000, Income tax applicable to loss on discontinued operations $25,500Gain on sale of equipment $ 95,000 Cash dividends declared $ 150,000Loss on discontinued operations 75,000 Retained earnings January 1, 2020 600,000Administrative expenses 240,000 Cost of goods sold 850,000Rent revenue 40,000 Selling expenses 300,000Loss on write-down of inventory 60,000 Sales revenue 1,900,000 Shares outstanding during 2020 were 100,000. Prepare a multiple step income statement (including earnings per share) and a statement of…arrow_forwardCH11_HW_QA3_PIR Required 1: Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms of margin and turnover. (Round your intermediate calculations and final answer to 2 decimal places.) Margin not attempted % Turnover not attempted ROI not attempted % Required 2: Using Lean Production, the company is able to reduce the average level of inventory by $96,000. (The released funds are used to pay off short-term creditors.) (Round your intermediate calculations and final answers to 2 decimal places.) Effect Margin % Turnover ROI % Required 3: The company achieves a cost savings of $14,000 per year by using less costly materials. (Round your intermediate calculations and final answers to 2 decimal places.) Effect Margin % Turnover ROI % Required 4: The…arrow_forward
- CH11_HW_QA3_LA Required 1: Compute the company’s return on investment (ROI) for the period using the ROI formula stated in terms of margin and turnover. (Round your intermediate calculations and final answer to 2 decimal places.) Margin % Turnover ROI % Required 2: Using Lean Production, the company is able to reduce the average level of inventory by $95,000. (The released funds are used to pay off short-term creditors.) (Round your intermediate calculations and final answers to 2 decimal places.) Effect Margin % Turnover ROI % Required 3: The company achieves a cost savings of $14,000 per year by using less costly materials. (Round your intermediate calculations and final answers to 2 decimal places.) Effect Margin % Turnover ROI % Required 4: The company issues bonds and uses the proceeds to…arrow_forwardProblem 17-5A Comparative ratio analysis LO P3 Skip to question [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows. BarcoCompany KyanCompany BarcoCompany KyanCompany Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 897,200 Cash $ 19,000 $ 30,000 Cost of goods sold 594,100 642,500 Accounts receivable, net 34,400 57,400 Interest expense 8,100 18,000 Merchandise inventory 84,740 140,500 Income tax expense 14,800 24,769 Prepaid expenses 5,900 7,150 Net income 153,000 211,931 Plant assets, net 310,000 305,400 Basic earnings per share 4.50 5.41 Total assets $ 454,040 $ 540,450 Cash dividends per share 3.82 3.93 Liabilities and Equity…arrow_forwardProblem 17-5A Comparative ratio analysis LO P3 Skip to question [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows. BarcoCompany KyanCompany BarcoCompany KyanCompany Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 882,200 Cash $ 19,000 $ 37,000 Cost of goods sold 593,100 638,500 Accounts receivable, net 36,400 58,400 Interest expense 7,800 18,000 Merchandise inventory 84,440 130,500 Income tax expense 14,800 24,355 Prepaid expenses 5,500 7,150 Net income 154,300 201,345 Plant assets, net 370,000 312,400 Basic earnings per share 4.06 4.09 Total assets $ 515,340 $ 545,450 Cash dividends per share 3.78 3.94 Liabilities and Equity…arrow_forward
- Problem 17-5A Comparative ratio analysis LO P3 Skip to question [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows. BarcoCompany KyanCompany BarcoCompany KyanCompany Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 882,200 Cash $ 19,000 $ 37,000 Cost of goods sold 593,100 638,500 Accounts receivable, net 36,400 58,400 Interest expense 7,800 18,000 Merchandise inventory 84,440 130,500 Income tax expense 14,800 24,355 Prepaid expenses 5,500 7,150 Net income 154,300 201,345 Plant assets, net 370,000 312,400 Basic earnings per share 4.06 4.09 Total assets $ 515,340 $ 545,450 Cash dividends per share 3.78 3.94 Liabilities and Equity…arrow_forwardE18.17 (LO 3) (Sales with Returns) Refer to the revenue arrangement in E18.16. Assume that instead of selling the tool sets on credit, Steele sold them for cash. Below is the E18.16 On March 10, 2022, Steele Company sold to Barr Hardware 200 tool sets at a price of $50 each (cost $30 per set) with terms of n/60, f.o.b. shipping point. Steele allows Barr to return any unused tool sets within 60 days of purchase. Steele estimates that: (1) 10 sets will be returned, (2) the cost of recovering the products will be immaterial, and (3) the returned tools sets can be resold at a profit. On March 25, 2022, Barr returned six tool sets and received a credit to its account. Instructions 1. Prepare journal entries for Steele to record (1) the sale on March 10, 2022, (2) the return on March 25, 2022, and (3) any adjusting entries required on March 31, 2022 (when Steele prepares financial statements). Steele believes the original estimate of returns is correct.2. Indicate the income statement and…arrow_forwardQ.9 KARA Corporation's CFO uses this equation, which was developed by regressing inventories on sales over the past 5 years, to forecast inventory requirements: Inventories = P22.0 + 0.125(Sales). The company expects sales of P300 million during the current year, and it expects sales to grow by 25% next year. What is the inventory forecast for next year?arrow_forward
- Mf2. 12. Alpha company made sales of PKR 100 Mn in 2019 and expecting that company’s top line will increase by 10% in 2020. The management has controlled its overhead and operating expenses very well in the given year which will result in net margin of 15% . The company has 1 million outstanding shares and the management is expecting to pay 40% as cash dividend at the end of year. Based on the given data, calculate following: ● Net sales ● Net profit ● Earnings per share (EPS) ● Dividend per share 13. Refer Q12, P/E ratio is estimated to be 8 times for the year. Based on the provided data calculate the share price of the Alpha stock ?arrow_forwardProblem 19-4 Per-Share Ratios (LO3, CFA6) You are given the following information for Smashville, Inc. Cost of goods sold: $249,000 Investment income: $2,900 Net sales: $394,000 Operating expense: $92,000 Interest expense: $7,400 Dividends: $13,000 Tax rate: 21 % Current liabilities: $22,000 Cash: $21,000 Long-term debt: $9,000 Other assets: $37,000 Fixed assets: $139,000 Other liabilities: $5,000 Investments: $13,000 Operating assets: $49,000 During the year, Smashville, Inc., had 17,000 shares of stock outstanding and depreciation expense of $15,000. Calculate the book value per share, earnings per share, and cash flow per share. (Do not round intermediate calculations. Round your answers to 2 decimal places.)arrow_forwardNineteen measures of solvency and profitability The comparative financial statements of Stargel Inc. are as follows. The market price of Stargel Inc. common stock was 119.70 on December 31, 2016. Stargel Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 2016 and 2015 2016 2015 Retained earnings, January 1................ 5,375,000 4,545,000 Add net income for year......................... 900,000 925,000 Total..................................... 6,275,000 5,470,000 Deduct dividends: On preferred stock............................................. 45,000 45,000 On common stock.............................................. 50,000 50,000 Total........................................................ 95,0000 95,000 Retained earnings, December 3................................... 6,180,000 5,375,000 Stargel Inc. Comparative Income Statement For the Year Ended December 31, 2016 and 2015 2016 2015 Sales..................... 10,000,000 9,400,000 Cost of goods sold......... 5,350,000 4,950,000 Gross profit............... 4,650,000 4,450,000 Selling expenses.......... 2,000,000 1,080,000 Administrative expenses... 1,500.000 1,410,000 Total operating expenses 3,500,000 3,290,000 Income from operations ... 1,150,000 1,160,000 Other income............. 150,000 140,000 1,300,000 1,300,000 Other expense (interest). 170,000 150,000 Income before income tax 1,130,000 1,150,000 Income tax expense....... 230,000 225,000 Net income............... 900,000 925,000 Stargel Inc. Comparative Income Statement For the Year Ended December 31, 2016 and 2015 Dec.31, 2016 Dec. 31, 2015 Assets Current Assets: Cash.................................... 500,000 400,000 Marketable securities.................... 1,010,000 1,000,000 Accounts receivable (net)................. 740,000 510,000 Inventories.............................. 1,190000 950,000 Prepaid expenses........................ 250,000 229,000 Total current assets..................... 3,690,000 3,089,000 Long-term investments.................... 2,350,000 2,300,000 Property, plant and equipment (net)....... 3,740,000 3,366,000 Total assets............................... 9,780,000 8,755,000 Liabilities Current liabilities.......................... 900,000 880,000 Long-term liabilities: Mortgage note payable, 8.8%, due 2021... 200,000 0 Bonds payable, 9%, due 2017............. 1,500,000 1,500,000 Total long term liabilities............... 1,700,000 1,500,000 Total liabilities............................ 2,600,000 2,380,000 Stockholders' equity Preferred stock 0.90, 10 par.. 500,000 500,000 Common stock. 5 par..................... 500,000 500,000 Retained earnings......................... 6,180,000 5,375,000 Total stockholders' equity............... 7,180,000 6,375,000 Total liabilities and stockholders' equity..... 9,780,000 8,755,000 Instructions Determine the following measures for 2016, rounding to one decimal place, except per share amounts, which should be rounded to the nearest penny: 1. Working capital 2. Current ratio 3. Quick ratio 4. Accounts receivable turnover 5. Number of days salts in receivables 6. Inventory turnover 7. Number of days sales in inventory 8. Ratio of fixed assets to long-term liabilities 9. Ratio of liabilities to .stockholders' equity 10. Number of times interest charges are earned 11. Number of times preferred dividends are earned 12. Ratio of sales to assets 13. Rate earned on total assets 14. Rate earned on stockholders' equity 15. Rate earned on common stockholders' equity 16. Earnings per share on common stock 17. Price-earnings ratio 18. Dividends per share of common stock 19. Dividend yieldarrow_forward
- Financial & Managerial AccountingAccountingISBN:9781285866307Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning