MANAGERIAL ACCOUNTING
MANAGERIAL ACCOUNTING
16th Edition
ISBN: 9781260936322
Author: Garrison
Publisher: MCG
bartleby

Videos

Question
Book Icon
Chapter 15, Problem 15P
To determine

Concept Introduction:

Ratios:

A ratio can be defined as a measure calculated to know the relation of two variable, that how they depend on each other. An increase in numerator and decrease in denominator will increase the ratio, on the other hand, a decrease in numerator and increase in denominator will decrease the ratio.

Times interest earned ratio:

It is the measure of a company’s ability to pay its debts obligations or interest obligations.

The formula of times interest earned ratio is −

Timesinterestearnedratio = Income before interest and taxesInterest expense

Debt to equity:

Debt to equity can be defined as a ratio that measures a company’s financial leverage. It is calculated by dividing total liabilities to total shareholder’s equity.

Debt to equity is calculated as under −

Debt to equity = Total liabilitiesTotal shareholders equity

Rate of Return on total assets:

Rate of Return on total assets can be defined as the ratio that measures a company’s earnings before interest and taxes (EBIT) against its total net assets or average total assets.

Rate of Return on total assets can be calculated as −

Rate of Return on Total Assets= Net IncomeAverage Total assets

Now, the average total assets are calculated as −

Average total assets=Beginning Total assets+Ending total assets2

Return on Common Stockholder’s Equity:

Return on Common Stockholder’s Equity is the rate of return earned by the Common Stockholders on their investment in the company. It is calculated with the help of following formula:

Return on Common Stockholder’s Equity = Net Income Average Common Stockholder’s Equity

Dividend yield:

Dividend yield can be defined as the measure in which the cash dividend is expressed as a percentage of the current market price. This is calculated in order to know the return earned or the yield generated by the share depending on their current market price.

Dividend yield is calculated as under −

Dividend Yield = Annual cash dividend per shareMarket value per share 

Requirement 1:

To compute:

  1. Times interest earned ratio
  2. Debt-to-equity ratio
  3. Gross margin percentage
  4. Return on total assets
  5. Return on equity
  6. Company’s financial leverage positive or negative

Expert Solution
Check Mark

Answer to Problem 15P

Solution:

The answers are −

Ratios This year Last year
a Times interest earned ratio 4.33 3.4
b Debt-to-equity ratio 0.78 0.63
c Gross margin percentage 20% 20.70%
d Return on total assets 5.25% 3.62%
e Return on equity 8.97% 5.57%
f Company's financial leverage 1.3 1.42

Explanation of Solution

The above answers can be explained as under −

a. Times interest earned ratio −

For this year −

Given:

  • Net Income income before interest and tax = $ 1,560,000
  • Interest Expense = $ 360,000

The times-interest-earned-ratio will be calculated as −

Timesinterestearnedratio = Income before interest and taxesInterest expenseTimesinterestearnedratio = $ 1,560,000$ 360,000Timesinterestearnedratio = 4.33

The times-interest-earned-ratio = 4.33

For last year −

Given:

  • Net Income income before interest and tax = $ 1,020,000
  • Interest Expense = $ 300,000

The times-interest-earned-ratio will be calculated as −

Timesinterestearnedratio = Income before interest and taxesInterest expenseTimesinterestearnedratio = $ 1,020,000$ 300,000Timesinterestearnedratio = 3.4

The times-interest-earned-ratio = 4.72

b. Debt-to-equity ratio −

For this year − Given,

Total liabilities = $ 7,500,000

Total equity = $ 9,600,000

Debt to equity = Total liabilitiesTotal shareholders equityDebt to equity = $ 7,500,000$ 9,600,000Debt to equity = 0.78125

Debt-to-equity ratio = 0.78

For last year − Given,

  • Total liabilities = $ 5,760,000
  • Total equity = $ 9,120,000

Debt to equity = Total liabilitiesTotal shareholders equityDebt to equity = $ 5,760,000$ 9,120,000Debt to equity = 0.6316

Debt-to-equity ratio = 0.63

Gross margin percentage −

For this year − Given

Sales = $ 15,750,000

Gross margin = $ 3,150,000

Gross margin percentage =  Gross Margin  Sales X 100Gross margin percentage =  $ 3,150,000 $ 15,750,000  X 100Gross margin percentage = 20 %

Gross margin percentage = 20 %

For last year − Given

  • Sales = $ 12,480,000
  • Gross margin = $ 2,580,000

Gross margin percentage =  Gross Margin  Sales X 100Gross margin percentage =  $ 2,580,000 $ 12,480,000  X 100Gross margin percentage = 20.67 %

Gross margin percentage = 20.67 %

Return on total assets −

For this year − Given,

  • Net Income = $ 840,000
  • Beginning total assets = $ 14,880,000
  • Ending total assets = $ 17,100,000

Average total assets=Beginning Total assets+Ending total assets2

Average total assets=$14,880,000+$17,100,0002Average total assets=$15,990,000

Rate of Return on Total Assets= Net IncomeAverage Total assets

= $840,000$15,990,000= 5.25%

For last year − Given,

  • Net Income = $ 504,000
  • Beginning total assets = $ 12,960,000
  • Ending total assets = $ 14,880,000

Average total assets=Beginning Total assets+Ending total assets2

Average total assets=$12,960,000+$14,880,0002Average total assets=$13,920,000

Rate of Return on Total Assets= Net IncomeAverage Total assets

= $504,000$13,920,000= 3.62%

Return on equity −

For this year − Given,

  • Net Income = $ 840,000
  • Beginning Stockholder’s equity = $ 9,120,000
  • Ending stockholder’s equity = $ 9,600,000

Now, average stockholder’s equity −

Average stockholders equity=Beginning stockholders equity+Ending stockholders equity2

Average  Stockholders equity=$9,600,000+$9,120,0002Average Stockholders equity=$9,360,000

Return on Common Stockholder’s Equity = Net Income Average Common Stockholder’s EquityReturn on Common Stockholder’s Equity = $ 840,000$9,360,000  Return on Common Stockholder’s Equity = 8.97%

For last year − Given,

  • Net Income = $ 504,000
  • Beginning Stockholder’s equity = $ 9,048,000
  • Ending stockholder’s equity $ 9,120,000

Now, average stockholder’s equity −

Average stockholders equity=Beginning stockholders equity+Ending stockholders equity2

Average  Stockholders equity=$ 9,048,000+$ 9,120,0002Average Stockholders equity=$ 9,084,000

Return on Common Stockholder’s Equity = Net Income Average Common Stockholder’s EquityReturn on Common Stockholder’s Equity = $ 504,000$9,048,000  Return on Common Stockholder’s Equity = 5.57%

Financial leverage of the company −

For this year − Given,

  • Earnings before interest and taxes = $ 1,560,000
  • Earnings after interest before tax = $ 1,200,000

Financial leverage =  Earnings before interest and taxes  Earnings after interest before taxes Financial leverage =  $ 1,560,000  $ 1,200,000 Financial leverage = 1.3

The financial leverage is positive here.

For last years − Given,

  • Earnings before interest and taxes = $ 1,020,000
  • Earnings after interest before tax = $ 720,000

Financial leverage =  Earnings before interest and taxes  Earnings after interest before taxes Financial leverage =  $ 1,020,000  $ 720,000 Financial leverage = 1.42

The financial leverage is positive here.

Conclusion

Thus, all the required ratios have been calculated.

To determine

Requirement 2

To compute the following ratios for this year and the last year −

  1. Earnings per share
  2. Dividend yield ratio
  3. Dividend pay-out ratio
  4. Price-earnings ratio
  5. Book value per share

Expert Solution
Check Mark

Answer to Problem 15P

Solution:

Ratios This year Last year
a Earnings per share 8.4 5.04
b Dividend yield ratio 5% 6.30%
c Dividend pay-out ratio 42.86% 50%
d Price-earnings ratio 8.57 7.94
e Book value per share $96 $91.2

Explanation of Solution

Earnings per share −

For this year − Given,

  • Net income available for common stock = $ 840,000
  • Weighted average number of common stock = 100,000 shares (i.e. $ 7,800,000$ 78 par value )

EPS=NetIncomeWeightedAverageCommonStockEPS=$840,000100,000sharesEPS=$8.40

For last year − Given,

  • Net income available for common stock = $ 504,000
  • Weighted average number of common stock = 100,000 shares (i.e. $ 7,800,000$ 78 par value )

EPS=NetIncomeWeightedAverageCommonStockEPS=$504,000100,000sharesEPS=$5.04

Dividend yield ratio −

For this year − Given,

Annual cash dividend per share = $ 3.60 (i.e. $ 360,000100,000 shares )

  • Market price per share = $ 72 per share

Dividend Yield = Annual cash dividend per shareMarket value per shareDividend Yield =  $ 3.60 per share$ 72 per shareDividend Yield =5% 

For last year − Given,

Annual cash dividend per share = $ 2.52 (i.e. $ 252,000100,000 shares )

  • Market price per share = $ 40 per share

Dividend Yield = Annual cash dividend per shareMarket value per shareDividend Yield =  $ 2.52 per share$ 40 per shareDividend Yield =6.30% 

Dividend pay-out ratio −

For this year − Given,

Earnings per share = $ 8.40

Dividends paid per share = $ 3.60 (i.e. $ 360,000100,000 shares  ) Dividend payout ratio =  Dividends per share  Earnings per share  X 100Dividend payout ratio =  $ 3.60 $ 8.40   X 100Dividend payout ratio = 42.86%

For last year − Given,

  • Earnings per share = $ 5.04
  • Dividends paid per share = $ 2.52 (i.e. $ 252,000100,000 shares )
  • Dividend payout ratio =  Dividends per share  Earnings per share  X 100Dividend payout ratio =  $ 2.52 $ 5.04   X 100Dividend payout ratio = 50%

    Price-earnings ratio −

    For this year −

    Given,

    • Market price per share = $ 72
    • Earnings per share = $ 8.4

    Priceearnings ratio =  Market price per share  Earnings per share Priceearnings ratio =  $ 72 $ 8.40 Priceearnings ratio = 8.57

    For last year −

    Given,

    • Market price per share = $ 40
    • Earnings per share = $ 5.04

    Priceearnings ratio =  Market price per share  Earnings per share Priceearnings ratio =  $ 40 $ 5.04 Priceearnings ratio = 7.94

    Book value per share −

    For this year − Given

    • Total Shareholder’s Equity = $ 9,600,000
    • Common stock outstanding = 100,000

    BookValuepershare=Totalshareholder'sequityCommonStockOutststanding

    BookValuepershare=9,600,000   100,000BookValuepershare=$96

    Yes, it can be said that the stock is at bargain price, as the market price is less than its book value per share.

    For last year − Given

    • Total Shareholder’s Equity = $ 9,120,000
    • Common stock outstanding = 100,000

    BookValuepershare=Totalshareholder'sequityCommonStockOutststanding

    BookValuepershare=9,120,000   100,000BookValuepershare=$91.2

    Yes, it can be said that the stock is at bargain price, as the market price is less than its book value per share.

    Conclusion

    Thus, all the ratios have been calculated.

    To determine

    Requirement 3

    To compute:

    The following ratios for last year and this year −

    1. Working capital
    2. Current ratio
    3. Acid-test ratio
    4. Average collection period
    5. Average sale period
    6. Operating cycle
    7. Total asset turnover

    Expert Solution
    Check Mark

    Answer to Problem 15P

    Solution:

    Ratios This year Last year
    a Working capital 39,00,000 31,80,000
    b Current Ratio 2 2.15
    c Acid-test ratio 0.94 1.22
    d Average collection period 52.14 49.13
    e Average sale period 91.25 79.69
    f Operating cycle 143.39 128.82
    g Total asset turnover 0.99 0.9

    Explanation of Solution

    The ratios are calculated as under −

    Working Capital

    For this year −

    • Current assets = $ 7,800,000
    • Current Liabilities = $ 3,900,000

    Working Capital = Current assets  Current liabilitiesWorking Capital = $ 7,800,000  $ 3,900,000Working Capital = $ 3,900,000

    For last year −

    • Current assets = $ 5,940,000
    • Current Liabilities = $ 2,760,000

    Working Capital = Current assets  Current liabilitiesWorking Capital = $ 5,940,000  $ 2,760,000Working Capital = $ 3,180,000

    Current Ratio −

    For this year −

    • Current assets = $ 7,800,000
    • Current Liabilities = $ 3,900,000

    Current Ratio =  Current assets Current liabilities  Current Ratio =  $ 7,800,000 $ 3,900,000  Current Ratio = 2 

    For last year −

    • Current assets = $ 5,940,000
    • Current Liabilities = $ 2,760,000

    Current Ratio =  Current assets Current liabilities  Current Ratio =  $ 5,940,000 $ 2,760,000  Current Ratio = 2.15 

    Acid test ratio −

    For this year − Given,

    • Cash = $ 960,000
    • Marketable securities = $ 0
    • Accounts receivables, net = $ 2,700,000
    • Current liabilities = 3,900,000

    Acid  test ratio =  Quick assets  Current liabilitiesAcid  test ratio =  Cash + Marketable securities + Accounts receivables, net Current liabilities Acid  test ratio =  $ 960,000 + 0 + $ 2,700,000   $ 3,900,000Acid  test ratio = 0.94

    For last year − Given,

    • Cash = $ 1,260,000
    • Marketable securities = $ 300,000
    • Accounts receivables, net = $ 1,800,000
    • Current liabilities = 2,760,000

    Acid  test ratio =  Quick assets  Current liabilitiesAcid  test ratio =  Cash + Marketable securities + Accounts receivables, net Current liabilities Acid  test ratio =  $1,260,000 + $ 300,000 + $ 1,800,000   $ 2,760,000Acid  test ratio = 1.22

    Average collection period −

    For this year − Given,

  • Sales on account = $ 15,750,000
  • Accounts receivables, beginning = $ 1,800,000
  • Accounts receivables, ending = $ 2,700,000
  • Average accounts receivables =  Accounts receivables, beginning + Accounts receivables, ending2 Average accounts receivables =  $ 1,800,000 + $ 2,700,0002 Average accounts receivables = $ 2,250,000Accounts receivables turnover =  Sales Average accounts receivables  Accounts receivables turnover =  $ 15,750,000 $ 2,250,000  Accounts receivables turnover = 7Average collection period =  365 days Accounts receivables turnover  = 365days7Average collection period = 52.14 or 53 days

    For last year − Given,

    • Sales on account = $ 12,480,000
    • Accounts receivables, beginning = $ 1,560,000
    • Accounts receivables, ending = $ 1,800,000

    Average accounts receivables =  Accounts receivables, beginning + Accounts receivables, ending2 Average accounts receivables =  $ 1,560,000 + $ 1,800,0002 Average accounts receivables = $ 1,680,000Accounts receivables turnover =  Sales Average accounts receivables  Accounts receivables turnover =  $ 12,480,000 $ 1,680,000  Accounts receivables turnover = 7.43Average collection period =  365 days Accounts receivables turnover  = 365days 7.43Average collection period = 49.13 or 50 days

    Average sale period −

    For this period − Given,

    • Cost of goods sold = $ 12,600,000
    • Inventory, Beginning = $ 2,400,000
    • Inventory, Ending = $ 3,900,000

    Average inventory =  Inventory, Beginning + Inventory, Ending2 Average inventory =  $ 2,400,000 + $ 3,900,000 2Average inventory = $ 3,150,000Inventory turnover =  Cost of goods sold Average inventory  Inventory turnover =  $ 12,600,000 $ 3,150,000  Inventory turnover = 4Average sale period =  365 days   Inventory turnover =  365 days4 Average sale period = 91.25 days or 93 days

    For last period − Given,

    • Cost of goods sold = $ 9,900,000
    • Inventory, Beginning = $ 1,920,000
    • Inventory, Ending = $ 2,400,000

    Average inventory =  Inventory, Beginning + Inventory, Ending2 Average inventory =   $ 1,920,000 + $ 2,400,000 2Average inventory = $ 2,160,000Inventory turnover =  Cost of goods sold Average inventory  Inventory turnover =  $ 9,900,000 $ 2,160,000  Inventory turnover = 4.58Average sale period =  365 days   Inventory turnover =  365 days 4.58 Average sale period = 79.69 days or 80 days

    Operating cycle −

    For this year − Given,

    • Average sale period = 52.14 days
    • Average collection period = 91.25 days

    Operating cycle = Average sale period + Average collection periodOperating cycle = 52.14 days + 91.25 daysOperating cycle = 143.39 days

    For last year − Given,

    • Average sale period = 49.13 days
    • Average collection period = 79.64 days

    Operating cycle = Average sale period + Average collection periodOperating cycle = 49.13 days + 79.64 daysOperating cycle = 128.77 days

    Total assets turnover −

    For this year − Given,

    • Sales = $ 15,750,000
    • Average total assets = $ 15,990,000

    Total assets turnover =  Sales  Average total asset Total assets turnover =  $ 15,750,000 $ 15,990,000  Total assets turnover = 0.99

    For last year − Given,

    • Sales = $ 12,480,000
    • Average total assets = $ 13,920,000

    Total assets turnover =  Sales  Average total asset Total assets turnover =  $ 12,480,000 $ 13,920,000  Total assets turnover = 0.90

    Conclusion

    Thus, all the ratios have been calculated.

    To determine

    Requirement 4

    To prepare:

    A brief memo that summarizes how Lydex is performing relative to its competitors.

    Expert Solution
    Check Mark

    Answer to Problem 15P

    Solution:

    The performance of Lydex can be explained as −

    • The Lydex Company is doing fine in terms of current ratio and acid-test ratio but for sales period and collection period, it is far behind the industry averages.
    • The return on total assets is also less when compared with the industry averages.
    • Debt-to-equity ratio was appropriate till last year, but this year it deteriorated.
    • The times-interest-earned ratio is also low as compared to industry averages.
    • Similarly, the price-earnings ratio is low when compared with industry’s price earnings ratio.
    • Overall, the performance of the company is not up to to the mark as it should be as per the industry.

    Explanation of Solution

    The above answer can be explained as under −

    The table is prepared to compare the ratios of the company for this year and last year −

    Ratios This year Last year Industry
    Current Ratio 2 2.15 2.3
    Acid-test ratio 0.94 1.22 1.2
    Average collection period 52.14 49.13 30 days
    Average sale period 91.25 79.69 60 days
    Return on total assets 5.25% 3.62% 9.50%
    Debt-to-equity ratio 0.78 0.63 0.65
    Times interest earned ratio 4.33 3.4 5.7
    Price-earnings ratio 8.57 7.94 10

    Further it can be explained as −

    1. The Lydex Company is doing fine in terms of current ratio as the current ratio of the industry is 2 and for both the years, it was near 2. The acid-test ratio was approprice foe the last year but it decreased this year.
    • For the sales period, the average period is 30 days, while it is 52.14 days for this year and 49.13 days for last year. The collection period is very long for the company. The company should change its policies for the collections of accounts receivables.
    • Similarly, for the sales period, it is far behind the industry averages.
    • The return on total assets is also less when compared with the industry averages. The industry is earning more on total assets, while the company is again behind the industry averages. But from the last year to this year, it improved.
    • Debt-to-equity ratio was appropriate till last year, but this year it deteriorated.
    • The times-interest-earned ratio is also low as compared to industry averages. The industry is earning more to cover its interest obligations, when compared with the company.
    • Similarly, the price-earnings ratio is low when compared with industry’s price-earnings ratio. The industry’s price-earnings ratio is 10, while for company it is low, but for this year it improved.
    Conclusion

    Thus, the brief memo for the performance of the company has been prepared.

    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!
    Knowledge Booster
    Background pattern image
    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.
    Recommended textbooks for you
    Text book image
    FINANCIAL ACCOUNTING
    Accounting
    ISBN:9781259964947
    Author:Libby
    Publisher:MCG
    Text book image
    Accounting
    Accounting
    ISBN:9781337272094
    Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
    Publisher:Cengage Learning,
    Text book image
    Accounting Information Systems
    Accounting
    ISBN:9781337619202
    Author:Hall, James A.
    Publisher:Cengage Learning,
    Text book image
    Horngren's Cost Accounting: A Managerial Emphasis...
    Accounting
    ISBN:9780134475585
    Author:Srikant M. Datar, Madhav V. Rajan
    Publisher:PEARSON
    Text book image
    Intermediate Accounting
    Accounting
    ISBN:9781259722660
    Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
    Publisher:McGraw-Hill Education
    Text book image
    Financial and Managerial Accounting
    Accounting
    ISBN:9781259726705
    Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
    Publisher:McGraw-Hill Education
    Elements of cost | Direct and Indirect: Material, Labor, & Expenses; Author: Educationleaves;https://www.youtube.com/watch?v=UFBaj6AHjHQ;License: Standard youtube license