Question: Problem 1 (See pages 57 64 and 75 - 78) CVS Stores Inc. reported the following ratios and assets: Debt to Assets = 60 percent

Problem 1 (See pages 57 64 and 75 - 78)

CVS Stores Inc. reported the following ratios and assets:

Debt to Assets = 60 percent

Total Assets= $325,000 Asset Turnover = 5x Fixed Asset Turnover = 12.037x Average Collection Period = 16.837 days

Current Ratio = 2

Quick Ratio = 1.1

Part A

Using the above listed ratios and data, compute the balance of the following accounts. Assume all sales are on credit and a 360-day year. Round to the nearest dollar. Please show your work:

a) Total liabilities

b) Sales

c) Fixed assets

d) Accounts receivable

e) Current assets

f) Current liabilities

g) Inventory

Part B

Complete the following balance sheet:

Cash

$

Current Liabilities

$

Accounts Receivable

$

Bonds Payable

$

Inventory

$

Total Liabilities

$

Total Current Assets

$

Stockholders equity

$

Fixed Assets

$

Total Assets

$325,000

Total Liabilities and Stockholders equity

$325,000

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Problem 2 (See pages 57 64 and 75 - 78)

Given the balance sheet and income statement for Diagnostics Corporation of America, compute the ratios that are also shown for the industry average. For each ratio, indicate whether Diagnostics Corporation of America is better or worse than the industry average. (SHOW YOUR WORK)

Diagnostics Corporation of America

Balance Sheet

Assets: Liabilities

Cash $15,000 Accounts Payable $21,000

Accts. Receivable 22,000 Notes Payable 20,000

Inventory 30,000 Accrued Expenses 5,000

Current Assets 67,000 Current Liabilities 46,000

Net Fixed Assets 73,000 Long-term Debt 30,000

Stockholders Equity 64,000

Total Assets $140,000 Total Liab and Stockholders Equity $140,000

Income Statement

Sales (80% credit) $120,000

Less: Cost of Goods Sold 45,000

Gross Profit 75,000

Selling and Administrative Expense 20,000

Rent expense (lease) 8,000

EBIT 47,000

Interest Expense 5,000

Earnings before taxes 42,000

Taxes (25%) 10,500

Net Income $ 31,500

Common share outstanding 15,000

EPS $ 2.10

Ratio

Diagnostics Corporation of America

Industry

Average

Better (B) or Worse (W)

Profit margin

17.5%

Return on assets

20.8%

Return on equity

35%

Receivable turnover

4.4x

Average collection period

68 days

Inventory turnover

3.5x

Fixed asset turnover

2.4x

Total asset turnover

0.76x

Current ratio

1.28

Quick ratio

0.85

Debt to total assets

0.45

Times interest earned

12.0x

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Problem 3 (See pages 57 64 and 75 - 78)

Orlando Imaging Center Corporation (OICC) had net income in 2016 of $90,000. Here are some of the financial ratios from the annual report.

Profit Margin 12%

Return on Assets 20%

Debt to Asset Ratio 55%

Using these ratios, calculate the following for OICC (SHOW YOUR WORK):

a) Sales

b) Total assets

c) Total asset turnover

d) Total debt

e) Stockholders' equity

f) Return on equity

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!