ACC201 WEEK 5 P9-23 BERNARD COMPANY SOLUTION IN EXCEL

Click here for solution

acc201 week 5
P9-23 Use the financial statements for Bernard Company from Problem 9-22 to calculate the following ratios for 2012 and 2011:

a. Working capital

b. Current ratio

c. Quick ratio

d. Receivables turnover (beginning receivables at January 1, 2011, were $47,000.)

e. Average days to collect accounts receivable

f. Inventory turnover (beginning inventory at January 1, 2011, was $140,000.)

g. Number of days to sell inventory

h. Debt to assets ratio

i. Debt to equity ratio

j. Number of times interest was earned

k. Plant assets to long-term debt

l. Net margin

m. Turnover of assets

n. Return on investment

o. Return on equity

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
click here for solution