Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
3rd Edition
ISBN: 9781337788281
Author: James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher: Cengage Learning
bartleby

Videos

Textbook Question
Chapter 5, Problem 15P

Rate of Change Analyses and Ratios Analyses The following are Cohen Company’s comparative financial statements for 2020, 2019, and 2018:

Chapter 5, Problem 15P, Rate of Change Analyses and Ratios Analyses The following are Cohen Companys comparative financial , example  1

Chapter 5, Problem 15P, Rate of Change Analyses and Ratios Analyses The following are Cohen Companys comparative financial , example  2

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. 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. 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. 3. Next Level Based on your results, discuss the possible reasons for the decrease in the market price per share in 2020.

1.

Expert Solution
Check Mark
To determine

Prepare rate of change analyses for the income statements and balance sheets of Company C for 2019 and 2020 using the year to year approach.

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 2019 and 2020 using the year to year approach:

Intermediate Accounting: Reporting And Analysis, Chapter 5, Problem 15P , additional homework tip  1

Table (1)

Prepare rate of change analyses for the retained earnings of Company C for 2019 and 2020 using the year to year approach:

Intermediate Accounting: Reporting And Analysis, Chapter 5, Problem 15P , additional homework tip  2

Table (2)

Prepare rate of change analyses for the balance sheets of Company C for 2019 and 2020 using the year to year approach:

Intermediate Accounting: Reporting And Analysis, Chapter 5, Problem 15P , additional homework tip  3

Table (3)

2. (a)

Expert Solution
Check Mark
To determine

Compute current ratio for 2019 and 2020.

Explanation of Solution

Current ratio: Current ratio is one of the liquidity ratios, which measures the capacity of the company to meet its short-term obligations using its current assets. Current ratio is calculated by using the formula:

Current ratio=Current AssetsCurrent Liabilities

Compute current ratio for 2019 and 2020:

Ratios and Formula20202019

Current ratio:

Current AssetsCurrent Liabilities

=[(Cash+ Receivables + Inventories)Current liabilities]=($4,200+$7,600+$9,800)($12,000)=1.8:1 =[(Cash+ Receivables + Inventories)Current liabilities]=($4,000+$7,000+$9,000)($10,000)=2:1

Table (4)

2. (b)

Expert Solution
Check Mark
To determine

Compute inventory turnover for 2019 and 2020.

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:

Inventory turnover=Cost of goods soldAverage inventory

Compute inventory turnover for 2019 and 2020:

Ratios and Formula20202019

Inventory turnover:

Cost of goods soldAverage inventory

Average inventory:

(Ending Inventory)+(Beginning Inventory)2

=$61,100$9,400=6.5 times 

=[($9,000+$9,800)2]=$9,400

=$52,800$8,800=6 times 

=[($6,600+$9,000)2]=$8,800

Table (5)

2. (c)

Expert Solution
Check Mark
To determine

Compute receivable turnover for 2019 and 2020.

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.

Receivables turnover=Net credit salesAverage accounts receivables

Compute receivable turnover for 2019 and 2020:

Ratios and Formula20202019

Receivables turnover:

Net credit sales(Average accounts receivables)

Average accounts receivable:

(Ending Net Receivables)+(Beginning Net Receivables)2

=$102,200×.60$7,300=8.4 times

=[($7,000+$7,600)2]=$7,300

=$91,500×.65$6,600=9.01 times

=[($6,200+$7,000)2]=$6,600

Table (6)

2. (d)

Expert Solution
Check Mark
To determine

Compute net profit margin for 2019 and 2020.

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.

Net margin=Net incomeNet sales

Compute net profit margin for 2019 and 2020:

Ratios and Formula20202019

Net profit margin:

Net incomeNet sales

=($12,600$102,200×100)=12.33%=($11,800$91,500×100)=12.90%

Table (7)

2. (e)

Expert Solution
Check Mark
To determine

Compute earnings per share for 2019 and 2020.

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.

Earnings per share=Net earnings available for common stockAverage number of outstanding common shares

Compute earnings per share for 2019 and 2020:

Ratios and Formula20202019

Earnings per share:

Net incomePreferred dividend[Average common shares outstanding]

=($12,600$8,400$2×100)=$3=($11,800$7,600$2×100)=$3.11

Table (8)

2. (f)

Expert Solution
Check Mark
To determine

Compute return on total assets ratio for 2019 and 2020.

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:

Return on asset=(Net income +(Interest expense×After tax rate))Average total assets×100

Compute return on total assets for 2019 and 2020:

Ratios and Formula20202019

Return on total assets:

[(Net income + (Interest expense×After tax rate))Average total assets×100]

Average total assets:

(Ending total assets)+(Beginning total assets)2

=[($12,600+($3,000×.7))$136,495×100]=[($12,600+$2,100)$136,495×100]=10.8%

=($132,000 +$140,990)2=$136,495

=[($11,800+($4,000×.7))$129,000×100]=[($11,800+$2,800)$129,000×100]=11.3%

=($126,000 +$132,000)2=$129,000

Table (9)

Working note: 1 Determine the after tax rate:

Ratios and Formula20202019

After tax rate:

[1( Income tax amount Income before tax)]

=[1($5,400$18,000)]=1.30=0.7=[1($5,057$16,857)]=1.30=0.7

Table (10)

2. (g)

Expert Solution
Check Mark
To determine

Compute return on common stockholders’ equity for 2019 and 2020.

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:

Return on common stockholders' equity}= Net incomeAverage stockholders' equity×100

Compute return on common stockholders’ equity for 2019 and 2020:

Ratios and Formula20202019

Return on common stockholders’ equity:

Net income [Average stockholders' equity]

Average stockholders’ equity:

(Ending stockholders' equity)+(Beginning stockholders' equity)2

=($12,600$90,495×100)=13.9%

=[($98,990+$82,000)2]=$90,495

=($11,800$78,000×100)=15.1%

=[($82,000+$74,000)2]=$78,000

Table (11)

2. (h)

Expert Solution
Check Mark
To determine

Compute debt to assets for 2019 and 2020.

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:

Debt-to-assets ratio=Total LiabilitiesTotal Assets 

Compute debt to assets for 2019 and 2020:

Ratios and Formula20202019

 Debt to assets ratio:

Total liabilities Total assets

=$12,000+$30,000$140,990×100=29.8%=$10,000+$40,000$132,000×100=37.9%

Table (12)

3.

Expert Solution
Check Mark
To determine

Explain the possible reasons for the decrease in the market price per share in 2020.

Explanation of Solution

The probable reason for the decrease in the market price per share in 2020:

  • 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 2020 are less than the result provided in the year of 2019.
  • The financial condition of the company is not as strong as it was in 2019 because earnings per share of Company C have decreased from $3.11(2019) to $3 (2020) and the debt to assets ratio has also decreased from 37.9% (2019) to $29.8% (2020).

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Chapter 5 Solutions

Intermediate Accounting: Reporting And Analysis

Ch. 5 - Prob. 11GICh. 5 - Define gains and losses. Give examples of three...Ch. 5 - Prob. 13GICh. 5 - What items are included in a companys income from...Ch. 5 - How are unusual or infrequent gains or losses...Ch. 5 - What is interperiod tax allocation?Ch. 5 - Prob. 17GICh. 5 - Prob. 18GICh. 5 - Prob. 19GICh. 5 - Prob. 20GICh. 5 - Prob. 21GICh. 5 - Prob. 22GICh. 5 - Prob. 23GICh. 5 - Prob. 24GICh. 5 - Prob. 25GICh. 5 - Prob. 26GICh. 5 - Prob. 27GICh. 5 - Prob. 28GICh. 5 - Prob. 29GICh. 5 - Prob. 30GICh. 5 - What is the rate of return on common equity? What...Ch. 5 - Prob. 32GICh. 5 - Prob. 33GICh. 5 - Which of the following is expensed under the...Ch. 5 - The following information is available for Cooke...Ch. 5 - The following information is available for Wagner...Ch. 5 - Prob. 4MCCh. 5 - A loss from the sale of a component of a business...Ch. 5 - In a statement of cash flows, receipts from sales...Ch. 5 - Brandt Corporation had sales revenue of 500,000...Ch. 5 - Refer to RE5-1. Prepare a single-step income...Ch. 5 - Shaquille Corporation began the current year with...Ch. 5 - Dorno Corporation incurred expenses during the...Ch. 5 - Niler Corporation reported the following after-tax...Ch. 5 - Jordan Corporation reported retained earnings of...Ch. 5 - Prob. 7RECh. 5 - Prob. 8RECh. 5 - Amelias Bookstore reported net income of 62,000...Ch. 5 - Prob. 10RECh. 5 - Prob. 1ECh. 5 - Cost of Goods Sold and Income Statement Schuch...Ch. 5 - Income Statement Calculation OConnor Companys...Ch. 5 - Results of Discontinued Operations On November 30,...Ch. 5 - Multiple-Step and Single-Step In coin Statements...Ch. 5 - Prob. 6ECh. 5 - Multiple-Step and Single-Step Income Statements,...Ch. 5 - Cost of Goods Sold, Income Statement. and...Ch. 5 - Net Cash Flow from Operating Activities The...Ch. 5 - Prob. 10ECh. 5 - Statement of Cash Flows The following items...Ch. 5 - Statement of Cash Flows The following are several...Ch. 5 - Classifications Where would each of the following...Ch. 5 - Rate of Change nalyses eiher Company presents the...Ch. 5 - Prob. 15ECh. 5 - Prob. 16ECh. 5 - Income Statement and Retained Earnings Huff...Ch. 5 - Prob. 18ECh. 5 - Interim Reporting (Appendix 5.1) Miller Company...Ch. 5 - Prob. 1PCh. 5 - Prob. 2PCh. 5 - Income Statement, Lower Portion Cunningham Company...Ch. 5 - Financial Statement Violations of U.S. GAAP The...Ch. 5 - Misclassiflcations Rox Corporations multiple-step...Ch. 5 - Misclassifications Olson Companys bookkeeper...Ch. 5 - Complex Income Statement The following items were...Ch. 5 - Prob. 8PCh. 5 - Financial Statement Deficiencies The following is...Ch. 5 - Comprehensive: Balance Sheet from Statement of...Ch. 5 - Net Income and Comprehensive Income At the...Ch. 5 - Statement of Cash Flows A list of Fischer Companys...Ch. 5 - Statement of Cash Flows The following are Mueller...Ch. 5 - Prob. 14PCh. 5 - Rate of Change Analyses and Ratios Analyses The...Ch. 5 - Comprehensive: Income Statement and Retained...Ch. 5 - Comprehensive: Income Statement and Supporting...Ch. 5 - Prob. 18PCh. 5 - Prob. 19PCh. 5 - Prob. 20PCh. 5 - Prob. 1CCh. 5 - Prob. 2CCh. 5 - Prob. 3CCh. 5 - Prob. 4CCh. 5 - Nonrecurring Items Lynn Company sells a component...Ch. 5 - Prob. 6CCh. 5 - Accrual Accounting GAAP requires the use of...Ch. 5 - Ethics and Sale of Operating Component It is the...Ch. 5 - Analyzing Starbuckss Income Statement and Cash...Ch. 5 - Prob. 11C
Knowledge Booster
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • Ratio Analysis Consider the following information taken from the stockholders equity section: How do you interpret the companys payout and profitability performance? Required: 1. Calculate the following for 2020. (Note. Round answers to two decimal places.) 2. CONCEPTUAL CONNECTION Assume 2019 ratios were: and the current year industry averages are: How do you interpret the companys payout and profitability performance?
    DIVIDENDS Brooks Sporting Inc. is prepared to report the following 2019 income statement (shown in thousands of dollars). Prior to reporting this income statement, the company wants to determine its annual dividend. The company has 320,000 shares of common stock outstanding, and its stock trades at 37 per share. a. The company had a 25% dividend payout ratio in 2018. If Brooks wants to maintain this payout ratio in 2019, what will be its per-share dividend in 2019? b. If the company maintains this 25% payout ratio, what will be the current dividend yield on the companys stock? c. The company reported net income of 1.35 million in 2018. Assume that the number of shares outstanding has remained constant. What was the companys per-share dividend in 2018? d. As an alternative to maintaining the same dividend payout ratio. Brooks is considering maintaining the same per-share dividend in 2019 that it paid in 2018. If it chooses this policy, what will be the companys dividend payout ratio in 2019? e. Assume that the company is interested in dramatically expanding its operations and that this expansion will require significant amounts of capital. The company would like to avoid transactions costs involved in issuing new equity. Given this scenario, would it make more sense for the company to maintain a constant dividend payout ratio or to maintain the same per-share dividend? Explain.
    The Jimenez Corporation’s forecasted 2020 financial statements follow, along with some industry average ratios. Calculate Jimenez’s 2020 forecasted ratios, compare them with the industry average data, and comment briefly on Jimenez’s projected strengths and weaknesses. Jimenez Corporation: Forecasted Balance Sheet as of December 31, 2020 Jimenez Corporation: Forecasted Income Statement for 2020 Jimenez Corporation: Per Share Data for 2020 Notes: aIndustry average ratios have been stable for the past 4 years. bBased on year-end balance sheet figures. cCalculation is based on a 365-day year.
  • ALTERNATIVE DIVIDEND POLICIES In 2018, Keenan Company paid dividends totaling 3,600,000 on net income of 10.8 million. Note that 2018 was a normal year and that for the past 10 years, earnings have grown at a constant rate of 10%. However, in 2019, earnings are expected to jump to 14.4 million and the firm expects to have profitable investment opportunities of 8.4 million. It is predicted that Keenan will not be able to maintain the 2019 level of earnings growth because the high 2019 earnings level is attributable to an exceptionally profitable new product line introduced that year. After 2019, the company will return to its previous 10% growth rate. Keenans target capital structure is 40% debt and 60% equity. a. Calculate Keenans total dividends for 2019 assuming that it follows each of the following policies: 1. Its 2019 dividend payment is set to force dividends to grow at the long-run growth rate in earnings. 2. It continues the 2018 dividend payout ratio. 3. It uses a pure residual dividend policy (40% of the 8.4 million investment is financed with debt and 60% with common equity). 4. It employs a regular-dividend-plus-extras policy, with the regular dividend being based on the long-run growth rate and the extra dividend being set according to the residual dividend policy. b. Which of the preceding policies would you recommend? Restrict your choices to the ones listed but justify your answer. c. Assume that investors expect Keenan to pay total dividends of 9,000,000 in 2019 and to have the dividend grow at 10% after 2019. The stocks total market value is 180 million. What is the companys cost of equity? d. What is Keenans long-run average return on equity? [Hint: g = Retention rate ROE = (1.0 Payout rate)(ROE)] e. Does a 2019 dividend of 9,000,000 seem reasonable in view of your answers to parts c and d? If not, should the dividend be higher or lower? Explain your answer.
    Balance Sheet Calculations Cornerstone Development Companys balance sheet information at the end of 2019 and 2020 is provided in random order, as follows: Additional information: At the end of 2019, (a) the amount of long-term liabilities is twice the amount of current liabilities and (b) there are 2,900 shares of common stock outstanding. During 2020, the company (a) issued 100 shares of common stock for 25 per share, (b) earned net income of 20,600, and (c) paid dividends of 1 per share on the common stock outstanding at year-end. Required: Next Level Fill in the blanks lettered (a) through (p). All of the necessary information is provided. (Hint: It is not necessary to calculate your answers in alphabetical order.)
    Juroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: 1. Calculate the return on sales. (Note: Round the percent to two decimal places.) 2. CONCEPTUAL CONNECTION Briefly explain the meaning of the return on sales ratio, and comment on whether Juroes return on sales ratio appears appropriate.
    Recommended textbooks for you
  • Intermediate Accounting: Reporting And Analysis
    Accounting
    ISBN:9781337788281
    Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
    Publisher:Cengage Learning
    Cornerstones of Financial Accounting
    Accounting
    ISBN:9781337690881
    Author:Jay Rich, Jeff Jones
    Publisher:Cengage Learning
    Financial Accounting
    Accounting
    ISBN:9781337272124
    Author:Carl Warren, James M. Reeve, Jonathan Duchac
    Publisher:Cengage Learning
  • Intermediate Financial Management (MindTap Course...
    Finance
    ISBN:9781337395083
    Author:Eugene F. Brigham, Phillip R. Daves
    Publisher:Cengage Learning
    Financial Accounting: The Impact on Decision Make...
    Accounting
    ISBN:9781305654174
    Author:Gary A. Porter, Curtis L. Norton
    Publisher:Cengage Learning
    Financial Management: Theory & Practice
    Finance
    ISBN:9781337909730
    Author:Brigham
    Publisher:Cengage
  • Intermediate Accounting: Reporting And Analysis
    Accounting
    ISBN:9781337788281
    Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
    Publisher:Cengage Learning
    Cornerstones of Financial Accounting
    Accounting
    ISBN:9781337690881
    Author:Jay Rich, Jeff Jones
    Publisher:Cengage Learning
    Financial Accounting
    Accounting
    ISBN:9781337272124
    Author:Carl Warren, James M. Reeve, Jonathan Duchac
    Publisher:Cengage Learning
    Intermediate Financial Management (MindTap Course...
    Finance
    ISBN:9781337395083
    Author:Eugene F. Brigham, Phillip R. Daves
    Publisher:Cengage Learning
    Financial Accounting: The Impact on Decision Make...
    Accounting
    ISBN:9781305654174
    Author:Gary A. Porter, Curtis L. Norton
    Publisher:Cengage Learning
    Financial Management: Theory & Practice
    Finance
    ISBN:9781337909730
    Author:Brigham
    Publisher:Cengage
    Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License