Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, Please help thank you Ratio Analysis of Comparative Financial Statements A comparative income statement and balance sheet of Miller Electronics Corporation for the last
Hello,
Please help thank you
Ratio Analysis of Comparative Financial Statements
A comparative income statement and balance sheet of Miller Electronics Corporation for the last two years are shown.
Miller Electronics Corporation Comparative Income Statement For Years Ended December 31, 20-2 and 20-1 | ||||
---|---|---|---|---|
20-2 | 20-1 | |||
Net Sales (all on account) | $654,730 | $420,830 | ||
Cost of goods sold | 383,660 | 250,940 | ||
Gross profit | $271,070 | $169,890 | ||
Administrative expenses | $64,730 | $42,624 | ||
Selling expenses | 66,759 | 44,236 | ||
Total operating expenses | $131,489 | $86,860 | ||
Operating income | $139,581 | $83,030 | ||
Interest expense | 1,289 | 1,208 | ||
Income before income taxes | $138,292 | $81,822 | ||
Income tax expense | 30,476 | 13,899 | ||
Net income | $107,816 | $67,923 |
Miller Electronics Corporation Comparative Balance Sheet December 31, 20-2 and 20-1 | ||||
---|---|---|---|---|
20-2 | 20-1 | |||
Assets | ||||
Current assets: | ||||
Cash | $43,727 | $22,837 | ||
Receivables (net) | 72,045 | 46,890 | ||
Merchandise inventory | 90,314 | 49,804 | ||
Supplies and prepayments | 3,885 | 1,155 | ||
Total current assets | $209,971 | $120,686 | ||
Property, plant, and equipment: | ||||
Office equipment (net) | $11,716 | $8,120 | ||
Factory equipment (net) | 105,191 | 70,990 | ||
Total property, plant, and equipment | 116,907 | $79,110 | ||
Total assets | $326,878 | $199,796 | ||
Liabilities | ||||
Current liabilities | ||||
Notes payable | $10,090 | $5,890 | ||
Accounts payable | 42,990 | 30,489 | ||
Accrued and withheld payroll taxes | 6,143 | 5,253 | ||
Total current liabilities | $59,223 | $41,632 | ||
Stockholders' Equity | ||||
Common stock ($10 par) | $100,000 | $84,000 | ||
Retained earnings | 167,655 | 74,164 | ||
Total stockholders' equity | $267,655 | $158,164 | ||
Total liabilities and stockholders' equity | $326,878 | $199,796 |
Required:
Calculate the following ratios and amounts for 20-1 and 20-2. Round all calculations to two decimal places.
(a) | Return on assets (Total assets on January 1, 20-1, were $169,526.) |
(b) | Return on common stockholders' equity (Total common stockholders' equity on January 1, 20-1, was $106,574.) |
(c) | Earnings per share of common stock (The average numbers of shares outstanding were 8,400 shares in 20-1 and 9,200 in 20-2.) |
(d) | Book value per share of common stock |
(e) | Quick ratio |
(f) | Current ratio |
(g) | Working capital |
(h) | Receivables turnover and average collection period (Net receivables on January 1, 20-1, were $39,390.) |
(i) | Merchandise inventory turnover and average number of days to sell inventory (Merchandise inventory on January 1, 20-1, was $48,234.) |
(j) | Debt-to-equity ratio |
(k) | Asset turnover (Assets on January 1, 20-1, were $169,526.) |
(l) | Times interest earned ratio |
(m) | Profit margin ratio |
(n) | Assets-to-equity ratio |
(o) | Price-earnings ratio (The market price of the common stock was $100.00 and $85.00 on December 31, 20-2 and 20-1, respectively.) |
a. Return on assets: | |
20-2 | fill in the blank 1 % |
20-1 | fill in the blank 2 % |
b. Return on common stockholders' equity: | |
20-2 | fill in the blank 3 % |
20-1 | fill in the blank 4 % |
c. Earnings per share of common stock: | |
20-2 | $fill in the blank 5 |
20-1 | $fill in the blank 6 |
d. Book value per share of common stock: | |
20-2 | $fill in the blank 7 |
20-1 | $fill in the blank 8 |
e. Quick ratio: | |
20-2 | fill in the blank 9 to 1 |
20-1 | fill in the blank 10 to 1 |
f. Current ratio: | |
20-2 | fill in the blank 11 to 1 |
20-1 | fill in the blank 12 to 1 |
g. Working capital: | |
20-2 | $fill in the blank 13 |
20-1 | $fill in the blank 14 |
h. Receivables turnover: | |
20-2 | fill in the blank 15 to 1 |
20-1 | fill in the blank 16 to 1 |
Average collection period: | |
20-2 | fill in the blank 17 days |
20-1 | fill in the blank 18 days |
i. Merchandise inventory turnover: | |
20-2 | fill in the blank 19 to 1 |
20-1 | fill in the blank 20 to 1 |
Average number of days to sell inventory: | |
20-2 | fill in the blank 21 days |
20-1 | fill in the blank 22 days |
j. Debt-to-equity ratio: | |
20-2 | fill in the blank 23 to 1 |
20-1 | fill in the blank 24 to 1 |
k. Asset turnover: | |
20-2 | fill in the blank 25 to 1 |
20-1 | fill in the blank 26 to 1 |
l. Times interest earned ratio: | |
20-2 | fill in the blank 27 times |
20-1 | fill in the blank 28 times |
m. Profit margin ratio: | |
20-2 | fill in the blank 29 % |
20-1 | fill in the blank 30 % |
n. Assets-to-equity ratio: | |
20-2 | fill in the blank 31 to 1 |
20-1 | fill in the blank 32 to 1 |
o. Price-earnings ratio: | |
20-2 | fill in the blank 33 |
20-1 | fill in the blank 34 |
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