Question

From the balance sheet and income statement information below calculate the following ratios:

A.Return on sales

B.Current ratio

C.Inventory turnover - if they are no beginning inventory or ending inventory figures then use the merchandise inventory figure

ABC INC.
Income Statement
Year Ended December 31, 2018
 
Net Sales Revenue
 
$20,941
 
Cost of Goods Sold
 
7,055
 
Gross Profit
 
13,886
 
Operating Expenses
 
7,065
 
Operating Income
 
6,821
 
Interest Expense
 
210
 
Income Before Taxes
 
6,611
 
Income Tax Expense
 
2,563
 
Net Income
 
$4,048
 
 
 
 
ABC INC.
Balance Sheet
December 31, 2018
 
Assets
 
Current Assets:
 
 
    Cash
 
$2,450
    Accounts Receivable
 
1,813
    Merchandise Inventory
 
1,324
    Prepaid Expenses
 
1,709
    Total Current Assets
 
7,296
Long-Term Assets
 
18,500
Total Assets
 
$25,796
 
Liabilities
Current Liabilities
 
$7,320
Long-Term Liabilities
 
4,798
Total Liabilities
 
12,028
 
Stockholders’ Equity
Common Stock
 
6,568
Retained Earnings
 
7,200
Total Stockholders’ Equity
 
13,768
Total Liabilities & Stockholders’ Equity
 
$25,796

Notes: 1.round up
2. your responses should be in the following formats
A. XX%
B. x.xx
C. x.xx​

Answer 1

a) Return on sales = 33%

b) Current ratio = 1.00

c) Inventory Turnover = 5.33 times

Step-by-step explanation:

Requirement A)

Return on sales - When a ratio measures the firm's efficiency to use its resources to transform the sales into operating profit, then the firm uses return on sales. It can be calculated by dividing the operating income (earnings before interest and tax) by net sales.

Given,

Net sales revenue = $20,941

Operating income = $6,821

Therefore, return on sales = $(6,821/20,941)*100 = 33% (Rounded up).

Requirement B)

Current Ratio = When a ratio measures the liquidity of the company, it is coined as the current ratio. Moreover, the ability of a company to pay its short-term debts with short-term assets. The ratio is calculated by dividing the current assets to its current liabilities. Current assets are cash, Accounts Receivable, Merchandise Inventory, Prepaid Expenses.

Given,

Total current assets = $7,296, Total current liabilities = $7,320

Therefore,

Current ratio = $(7,296/7,320) = 0.996 (since the responses should be up to 2 decimal places, the result will be 1.00)

Requirement C)

Inventory Turnover = Cost of Goods Sold/Average Inventory

When a ratio measures the firms ability to use the inventory efficiently with the help of its cost of goods sold, it is termed as inventory turnover ratio. It is calculated by dividing the cost of goods sold by the average inventory.

Given,

Cost of goods sold = $7,055

Merchandise Inventory (Average Inventory) = $1,324.

Since there are only ending merchandise inventory, it is assumed as average inventory.

Therefore,

Inventory Turnover ratio = $(7,055/1,324) = 5.33 times