Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Focus On Personal Finance

Authors: Jack R. Kapoor, Les R. Dlabay Professor, Robert J. Hughes, Melissa Hart

5th Edition

0077861744, 978-0077861742

More Books

Students also viewed these Finance questions

Question

please dont use chat gpt or other AI 7 0 6 .

Answered: 1 week ago

Question

Write a Python program to check an input number is prime or not.

Answered: 1 week ago