Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

a. Working capital b. Current Ratio c. Quick Ratio d. Accounts receivable turnov

ID: 2347414 • Letter: A

Question

a. Working capital

b. Current Ratio

c. Quick Ratio

d. Accounts receivable turnover (beginning receivables at 01/01/2011, was $47,000)

e. Average number of days to collect accounts receivable

f. Inventory turnover (beginning inventory at 01/01/2011, was $140,000)

g. Average number of days to sell inventory

h. Debt to asset ratio

i. Debt to equity ratio

j. Times interest earned

k. Plant assets to long-term debt

l. Net margin

m. Asset turnover

n. Return on investment (ROI)

o. Return on Equity (ROE)

p. Earnings per share

q. Book value per share of common stock

r. Price-earnings ratio (market price per share, 2011, $11.75; 2012, $12.50)

s. Dividend yield on common stock

Ratio Analysis
Bernard Company Balance Sheets
Assets 2012 2011
current Assets
Cash $16,000 $12,000
marketable Secr. 20,000 6,000
acct. rec. (net) 54,000 46,000
inventories 135,000 143,000
prepaid items 25,000 10,000
Total current *** 250,000 217,000
investments 27,000 20,000
plant (net) 270,000 255,000
land 29,000 24,000
Total assets $576,000 $516,000
liabilities
current liabilities
notes payable $17,000 $6,000
accounts Payable 113,800 100,000
salarys 21,000 15,000
total liabilities 151,800 121,000
noncurrent liab.
bonds payable 100,000 100,00
other 32,000 27,000
total noncurrent 132,000 127,000
total liabilities 283,800 248,000
stockholders equity
preferred stock, par value 80,000 80,000
$10, 4% cumulative, non-
participating 8,000 shares authorized:
10,000 shares issued 80,000 80,000
retained earnings 132,200 108,000
total stockholders eq 292,200 268,000
total liabilities and
stockholders equity $576,000 $516,000
Bernards Company statements of income and retained earnings for the years ended December 31

Explanation / Answer

a. Working capital = Current asset- Current Liabilities for 2012, 250,000-151,800 = $98200 for 2011, 217000-121000 = $96000 b. Current Ratio = CA/CL for 2012, 250,000/151,800 = 1.65 for 2011, 217000/121000 = 1.79 c. Quick Ratio (CA-inventories)/CL for 2012, (250,000- 135,000)/151,800 = .758 for 2011, (217000- 143000)/121000 = .6116 d. Accounts receivable turnover = Net Credit sales/ average accounts receivables for 2012, 54000/[(54,000+46,000 )/2]= 1.08 for 2011, 46000/[(47000+46000)/2]= .989 (beginning receivables at 01/01/2011, was $47,000) e.Average number of days to collect accounts receivable = Accounts Receivable/365 for 2012, 54,000/365= 148 days for2011, 46000/365= 126 days f. Inventory turnover = cost of good sold/ average inventory cost of good sold= purchase+opening stk- closing stk. for 2012= 113,800-135,000+143,000 =$121800 for 2011= 100000- 143000+140000= $97000 Inventory turnover for 2012, 121800/[(135000+143,000)/2]= .88 for 2011, 97000/[(143000+140000)/2)= 1.24 (beginning inventory at 01/01/2011, was $140,000) g. Average number of days to sell inventory = Average Inventory /365 for 2012, [(135000+143,000)/2]/365 for 2011, [(143000+140000)/2)/365 h. Debt to asset ratio = Total debt/total asset i. Debt to equity ratio = total debt/networth

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Chat Now And Get Quote