1.
Prepare rate of change analyses for the income statements and balance sheets of Company C for 2016 and 2017 using the year to year approach.
1.
Explanation of Solution
Balance Sheet: Balance Sheet is one of the financial statements which summarize the assets, the liabilities, and the Shareholder’s equity of a company at a given date. It is also known as the statement of financial status of the business.
Income statement: The financial statement which reports revenues and expenses from business operations and the result of those operations as net income or net loss for a particular time period is referred to as income statement.
Prepare rate of change analyses for the income statements of Company C for 2016 and 2017 using the year to year approach:
Table (1)
Prepare rate of change analyses for the retained earnings of Company C for 2016 and 2017 using the year to year approach:
Table (2)
Prepare rate of change analyses for the balance sheets of Company C for 2016 and 2017 using the year to year approach:
Table (3)
2. (a)
Compute
2. (a)
Explanation of Solution
Current ratio: Current ratio is one of the
Compute current ratio for 2016 and 2017:
Ratios and Formula | 2017 | 2016 |
Current ratio: |
Table (4)
2. (b)
Compute inventory turnover for 2016 and 2017.
2. (b)
Explanation of Solution
Inventory Turnover Ratio: This ratio is a financial metric used by a company to quantify the number of times inventory is used or sold during the accounting period. It is calculated by using the formula:
Compute inventory turnover for 2016 and 2017:
Ratios and Formula | 2017 | 2016 |
Inventory turnover: Average inventory: |
|
|
Table (5)
2. (c)
Compute receivable turnover for 2016 and 2017.
2. (c)
Explanation of Solution
Receivables turnover ratio: Receivables turnover ratio is mainly used to evaluate the collection process efficiency. It helps the company to know the number of times the accounts receivable is collected in a particular time period. This ratio is determined by dividing credit sales and average accounts receivables.
Compute receivable turnover for 2016 and 2017:
Ratios and Formula | 2017 | 2016 |
Receivables turnover: Average accounts receivable: |
|
|
Table (6)
2. (d)
Compute net profit margin for 2016 and 2017.
2. (d)
Explanation of Solution
Net profit margin: It is one of the profitability ratios. Profit margin ratio is used to measure the percentage of net income that is being generated per dollar of revenue or sales.
Compute net profit margin for 2016 and 2017:
Ratios and Formula | 2017 | 2016 |
Net profit margin: |
Table (7)
2. (e)
Compute earnings per share for 2016 and 2017.
2. (e)
Explanation of Solution
Earnings per Share: Earnings per share help to measure the profitability of a company. Earnings per share are the amount of profit that is allocated to each share of outstanding stock.
Compute earnings per share for 2016 and 2017:
Ratios and Formula | 2017 | 2016 |
Earnings per share: |
Table (8)
2. (f)
Compute return on total assets ratio for 2016 and 2017.
2. (f)
Explanation of Solution
Return on total assets: Return on investments (assets) is the financial ratio which determines the amount of net income earned by the business with the use of total assets owned by it. It indicates the magnitude of the company’s earnings with relative to its total assets. Return on investment is calculated as follows:
Compute return on total assets for 2016 and 2017:
Ratios and Formula | 2017 | 2016 |
Return on total assets: Average total assets: |
|
|
Table (9)
Working note: 1 Determine the after tax rate:
Ratios and Formula | 2017 | 2016 |
After tax rate: |
Table (10)
2. (g)
Compute return on common
2. (g)
Explanation of Solution
Return on common stockholders’ equity ratio: It is a profitability ratio that measures the profit generating ability of the company from the invested money of the shareholders. The formula to calculate the return on equity is as follows:
Compute return on common stockholders’ equity for 2016 and 2017:
Ratios and Formula | 2017 | 2016 |
Return on common stockholders’ equity: Average stockholders’ equity: |
|
|
Table (11)
2. (h)
Compute debt to assets for 2016 and 2017.
2. (h)
Explanation of Solution
Debt to assets ratio: The debt to asset ratio shows the relationship between total asset and the total liability of the company. Debt ratio reflects the financial strategy of the company. It is used to measure the percentage of company’s assets that are financed by long term debts. Debt to assets ratio is calculated by using the formula:
Compute debt to assets for 2016 and 2017:
Ratios and Formula | 2017 | 2016 |
Debt to assets ratio: |
Table (12)
3.
Explain the possible reasons for the decrease in the market price per share in 2017.
3.
Explanation of Solution
The probable reason for the decrease in the market price per share in 2017:
- The current ratio, receivable turnover ratio, net profit margin ratio, return on total assets, return on shareholders’ equity and earnings per share ratio in year 2017 are less than the result provided in the year of 2016.
- The financial condition of the company is not as strong as it was in 2016 because earnings per share of Company C have decreased from $3.11(2016) to $3 (2017) and the debt to assets ratio has also decreased from 37.9% (2016) to $29.8% (2017).
Want to see more full solutions like this?
Chapter 5 Solutions
Intermediate Accounting: Reporting and Analysis
- Rate of Change Analyses and Ratios Analyses The following are Cohen Companys comparative financial statements for 2020, 2019, and 2018: Additional information: Credit sales were 65% of net sales in 2019 and 60% in 2020. At the beginning of 2020, 400 shares of common stock were issued, the first sale of stock in several years. Cohen is concerned. Although it increased the dividends paid per share by 5% in 2020 and its 2020 net income is higher than 2019 net income, the market price of its common stock dropped from 22 per share at the beginning of 2020 to 21 per share at year-end. Required: 1. For 2019 and 2020, prepare rate of change analyses for the income statements and balance sheets of Cohen using a year-to-year approach. 2. For 2019 and 2020, compute the following ratios; (a) current, (b) inventory turnover, (c) receivables turnover, (d) net profit margin, (e) earnings per share, (f) return on total assets, (g) return on shareholders equity, and (h) debt-to-assets. 3. Next Level Based on your results, discuss the possible reasons for the decrease in the market price per share in 2020.arrow_forwardPlease find below Financial Statement extracts of Nestle from year 2017 and 2018. Based on this information please answer following question from a perspective of Financial Analyst (justify your answers with data as well the reason for choosing your ratios for your analysis) .The company’s total assets at year-end 2016 were CHF 131,900 million. What reasonable conclusions an analyst might make about the companies efficiency, Companies solvency, Liquidity and Profitability? In millions of CHF Notes 2018 2017 * Sales 3 91,439 89,590 Cost of goods sold (46,070) (45,571) Trading operating profit 3 13,789 13,277 Operating profit 13,752 10,156 Profit before taxes, associates and joint ventures 12,991 9,460 Taxes 13 (3,439) (2,773) Profit for the year 10,468 7,511 Notes 2018 2017 * Assets Current assets Cash and cash equivalents 12/16…arrow_forwardQualls Corporation reported 2017 earnings per share of $7.21. In 2018, Qualls reported earnings per share as follows. On income from continuing operations $6.40 On discontinued operations 1.88 On net income $8.28 Is the increase in earnings per share from $7.21 to $8.28 afavourable trend?arrow_forward
- Suppose the following financial information is available for Walgreen Company. (in millions) 2017 2016 Average common stockholders' equity $12,880.0 $11,580.0 Dividends declared for common stockholders 490 410 Dividends declared for preferred stockholders Net income 1,840 2,140 Calculate the payout ratio and return on common stockholders' equity for 2017 and 2016. (Round answers to 1 decimal place, e.g. 12.5%.) 2017 2016arrow_forwardQualls Corporation reported 2017 earnings per share of $7.21. In 2018, Qualls reported earnings per share as follows. On income from continuing operations On discontinued operations On net income $6.40 1.88 $8.28 Is the increase in earnings per share from $7.21 to $8.28 a favorable trend?arrow_forwardPlease find below Financial Statement extracts of Nestle from year 2017 and 2018. Based on this information please answer following question from a perspective of Financial Analyst (justify your answers with data as well the reason for choosing your ratios for your analysis) .The company's total assets at year-end 2016 were 131,900 million. What reasonable conclusions an analyst might make about the companies efficiency, Companies solvency, Liquidity and Profitability? 2018 2017 * Sales 91,439 89,590 Profit for the year 10,468 7,511 Assets 2018 2017 * Total current assets 41,003 31,884 Total assets 137,015 133,210 Total liabilities and equity 137,015 133,210arrow_forward
- Calculate the P/R for (WMT) as of November 14, 2017, when the company's stock price closed at $91.09.2 The company's profit for the fiscal year ending January 31, 2017, was US$13.64 billion, and its number of shares outstanding was 3.1 billion.arrow_forwardFrom the French Instrument Corporation second-quarter report ended 2018, do a vertical analysis for the second quarter of 2018. (Input all answers as positive values except other (income) which should be indicated by a minus sign. Round your answers to the nearest hundredth percent.) FRENCH INSTRUMENT CORPORATION AND SUBSIDIARIES Consolidated Statements of Operation (Unaudited) (In thousands of dollars, except share data) Second Quarter 2018 2017 Percent of net Net sales $6,644 $6,888 Cost of sales 4,080 4,453 Gross margin 2,564 2,435 Expenses: Selling, general and administrative 1,836 1,774 Product development 166 156 Interest expense 89 114 Other (income), net (181) (108) Total expenses 1,910 1,936 Income before income taxes 654 499 Provision for income taxes 256 200 Net income $398 $299 Net income per common share* $0.05 $0.03 Weighted average number of common shares and equivalents 6,673,673…arrow_forwardRequirement: Use the 2015 data for Prince Company. Assume a stock price of $28 per share. Compute the ratios. Prince Company paid $7,000 out in dividends for the year. Show how you can figure out that the company paid $7,000 out in dividends for the year. 2015 2014 Income Statement Sales revenue 190,000 167,000 Cost of goods sold 112,000 100,000 Gross profit 78,000 67,000 Operating expenses and interest expenses 56,000 53,000 Pretax income 22,000 14,000 Income tax 8,000 4,000 Net income 14,000 10,000 Balance Sheet Cash 4,000 7,000 Accounts receivable (net) 14,000 18,000 Inventory 40,000 34,000 Operational assets (net) 45,000 38,000 Total assets 103,000 97,000 Current liabilities (no interest) 16,000 17,000 Long-term liabilities (10% interest) 45,000 45,000 Common stock (par $5) 30,000…arrow_forward
- Profitability ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 2017, 20Y6, and 20Y5: December 31 20Y7 December 31 20Y6 December 31 20Y5 Total assets $307,000 $277,000 $247,000 Notes payable (8% interest) 100,000 100,000 100,000 Common stock 40,000 40,000 40,000 Preferred 6% stock, $100 par (no change during year) Retained earnings 20,000 109,920 20,000 80,240 20,000 60,000 The 20Y7 net income was $30,880, and the 2016 net income was $21,440. No dividends on common stock were declared between 2015 and 2017. Preferred dividends were declared and paid in full in 2016 and 2017. a. Determine the return on total assets, the return on stockholders' equity, and the return on common stockholders' equity for the years 2016 and 2017. When required, round your answers to one decimal place. 20Y7 20Y6 Return on total assets Return on stockholders' equity Return on common stockholders' equity % % % % % % b. The profitability ratios indicate…arrow_forwardThe following amounts were taken from the financial statements of Blue Spruce Corp.: 2017 2016 Total assets $821000 $1017000 Net sales 744000 656000 Gross profit 366000 321000 Net income 111000 118000 Weighted average number of 97500 97500 common shares outstanding Market price of common stock $49 $46 The profit margin ratio for 2017 is 14%. 18%. 16%. 15%.arrow_forwardPrepare a horizontal analysis of the income statement data for Georgia Development Corporation using 2016 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -12.1% or (55,000), (12.1%). Round percentages to 1 decimal place, e.g. 12.1%.) GEORGIA DEVELOPMENT CORPORATION Condensed Income Statements Increase or (Decrease) During 2017 December 31, 2017 December 31, 2016 Amount Percentage Net sales $600,000 $500,000 %24 Cost of goods sold 414,000 350,000 Gross profit 186,000 150,000 Operating expenses 150,000 120,000 % Net income $36,000 $30,000 % SHOW SOLUTION SHOW ANSWER LINK TO TEXTarrow_forward
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning