Financial Accounting
Financial Accounting
3rd Edition
ISBN: 9780078025549
Author: J. David Spiceland, Wayne M Thomas, Don Herrmann
Publisher: McGraw-Hill Education
bartleby

Videos

Question
Book Icon
Chapter 12, Problem 12.6AP

1.

To determine

To Calculate: The given risk ratios for Company VGS for 2015 & 2016.

1.

Expert Solution
Check Mark

Answer to Problem 12.6AP

The given risk ratios for Company VGS for 2015:

  1. a. Receivables turnover ratio – 38.33 times
  2. b. Inventory turnover ratio – 15.07 times
  3. c. Current ratio3.99:1
  4. d. Debt to equity ratio – 72.94%

The given risk ratios for Company VGS for 2016:

  1. a. Receivables turnover ratio – 39.33 times
  2. b. Inventory turnover ratio – 19.52 times
  3. c. Current ratio – 2.47:1
  4. d. Debt to equity ratio – 145.87%

Explanation of Solution

Risk Ratios: Risk ratios are the metrics used to evaluate the liquidity, capabilities, profitability, and overall performance of a company. The following are the ratios that evaluate the risk of a company:

  1. a. 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 sales return. It is calculated by using the following formula:

    Receivables turnover ratio = Net Credit salesAverage Accounts Receivables×100

Calculate the receivables turnover ratio for Company VGS for 2015:

Receivables turnover ratio = Net Credit salesAverage Accounts Receivables=$3,086,000$80,500 (1)=38.33 times

Determine the amount of average account receivables.

Average account receivables =(Opening account receivables)+(Closing account receivables)2=$70,000+$91,0002=$1,740,2002=$80,500 (1)

Calculate the receivables turnover ratio for Company VGS for 2016:

Receivables turnover ratio = Net Credit salesAverage Accounts Receivables=$3,560,000$90,500 (2)=39.33 times

Determine the amount of average account receivables.

Average account receivables =(Opening account receivables)+(Closing account receivables)2=$91,000+$90,0002=$181,0002=$90,500 (2)

  1. b. 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.

    Formula: Inventory turnover ratio=Cost of Goods SoldAverage Inventory

Calculate the inventory turnover ratio for Company VGS for 2015:

Inventory turnover ratio=Cost of Goods SoldAverage Inventory=$1,960,000$130,000 (3)=15.07 times

Determine the amount of average inventory.

Average inventory =Opening inventory+Closing inventory2=$145,000+$115,0002=$260,0002=$130,000 (3)

Calculate the inventory turnover ratio for Company VGS for 2016:

Inventory turnover ratio=Cost of Goods SoldAverage Inventory=$2,490,000$127,500 (4)=19.52 times

Determine the amount of average inventory.

Average inventory =Opening inventory+Closing inventory2=$115,000+$140,0002=$255,0002=$127,500 (4)

  1. c. Current ratio: Current ratio is used to determine the relationship between current assets and current liabilities. The ideal current ratio is 2:1.

    Formula:

    Current ratio = Current AssetsCurrent Liabilities

Calculate the current ratio for Company VGS for 2015:

Current ratio = Current AssetsCurrent Liabilities=$415,000$104,000=3.99:1

Calculate the current ratio for Company VGS for 2016:

Current ratio = Current AssetsCurrent Liabilities=$461,000$186,000=2.47:1

  1. d. Debt to equity Ratio: Debt to equity ratio is used by the company to determine how well the company is able to survive the losses without damaging the creditors’ interest. It is determined by dividing total debt and total equity. 

Formula:

Debt to Equity Ratio=Total Liabilities Stockholder's Equity

Calculate the debt to equity ratio for Company VGS for 2015:

Debt to Equity Ratio=Total Liabilities Stockholder's Equity=$399,000$547,000=72.94%

Calculate the debt to equity ratio for Company VGS for 2016:

Debt to Equity Ratio=Total Liabilities Stockholder's Equity=$636,000$436,000=145.87%

2.

To determine

To Calculate: The given profitability ratios for Company VGS for 2015 & 2016.

2.

Expert Solution
Check Mark

Answer to Problem 12.6AP

The given profitability ratios for Company VGS for 2015 are:

  1. a. Gross Profit ratio – 36.48%
  2. b. Return on Assets ratio – 15.97%
  3. c. Profit margin – 4.5%
  4. d. Assets turnover ratio – 3.54 times

The given profitability ratios for Company VGS for 2016 are:

  1. a. Gross Profit ratio – 30.05%
  2. b. Return on Assets ratio – 3.27%
  3. c. Profit margin – 0.9%
  4. d. Assets turnover ratio – 3.52 times

Explanation of Solution

Profitability ratios: In general, financial ratios are used to evaluate capabilities, profitability, and overall performance of a company. The following are the ratios that evaluate the profitability of a company:

  1. a. Gross Profit ratio: Gross profit ratio is the financial ratio that shows the relationship between the gross profit and net sales. Gross profit is the difference between the total revenues and cost of goods sold. It is calculated by using the following formula:

    Gross Profit ratio = Gross ProfitNet Sales×100

    Calculate the gross profit ratio for Company VGS for 2015:

    Gross Profit ratio = Gross ProfitNet Sales×100=$1,126,000$3,086,000×100=36.48%

Calculate the gross profit ratio for Company VGS for 2016:

Gross Profit ratio = Gross ProfitNet Sales×100=$1,070,000$3,560,000×100=30.05%

  1. b. Return on asset ratio: Rate of return on total assets measures the profit generated from the use of total assets.

Formula:

Return on assets ratio=Net IncomeAverage total assets

Calculate the return on asset ratio for Company VGS for 2015:

Return on assets ratio=Net IncomeAverage total assets×100=$139,000$870,100 (5)×100=15.97%

Determine the amount of average total assets.

Average total assets =(Opening total assets)+(Closing total assets)2=$794,200+$946,0002=$1,740,2002=$870,100 (5)

Calculate the return on asset ratio for Company VGS for 2016:

Return on assets ratio=Net IncomeAverage total assets×100=$33,000$1,009,000(6)×100=3.27%

Determine the amount of average total assets.

Average total assets =(Opening total assets)+(Closing total assets)2=$946,000+$1,072,0002=$1,740,2002=$1,009,000 (6)

  1. c. Profit margin: Profit margin ratio is used to determine the percentage of net income that is being generated per dollar of revenue or sales.

    Formula: Profit Margin=Net incomeNet revenue

    Calculate the profit margin ratio for Company VGS for 2015:

    Profit Margin ratio=Net incomeNet revenue= $139,000$3,086,000=4.5%

    Calculate the profit margin ratio for Company VGS for 2016:

    Profit Margin ratio=Net incomeNet revenue= $33,000$3,560,000=0.9%

  2. d. Assets turnover ratio: Asset turnover ratio is used to determine the asset’s efficiency towards sales.

    Formula: Asset turnover =NetrevenueAverage total assets

    Calculate the assets turnover ratio for Company VGS for 2015:

    Asset turnover =Net revenueAverage total assets=$3,086,000$870,100 (5)=3.54 times

    Calculate the assets turnover ratio for Company VGS for 2016:

    Asset turnover =Net revenueAverage total assets=$3,560,000$1,009,000 (6)=3.52 times

3.

To determine

whether overall risk and profitability ratios are improved from 2015 to 2016.

3.

Expert Solution
Check Mark

Explanation of Solution

The risk ratios are mixed where it has been increased and decreased from 2015 to 2016. The receivables and inventory turnover ratios are improved in 2016, while current ratio and debt to equity ratio indicate greater risk in 2016.

Profitability decreased as indicated by the lower gross profit ratio and return on assets in 2016. It appears that the lower return on assets in 2016 is due to lower profit margins rather than to a decrease in asset turnover.

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 12 Solutions

Financial Accounting

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
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License