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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started