Comprehensive ratio analysis of two companies

Assignment Help Accounting Basics
Reference no: EM131128537

Comprehensive Ratio Analysis of two Companies

P4. Mel Filbert is considering an investment in the common stock of a chain of retail department stores. She has narrowed her choice to two retail companies, Single Cor- poration and Design Corporation, whose income statements and balance sheets follow.

Income Statements

2b: Single asset turnover: 2.5 times

Net sales	Single $12,560,000		Design $25,210,000 Costs and expenses:			 Cost of goods sold	$  6,142,000		$14,834,000 Selling expenses	4,822,600		7,108,200 Administrative expenses	986,000		2,434,000 Total costs and expenses	$11,950,600		$24,376,200 Income from operations	$	609,400		$	833,800 Interest expense	194,000		228,000 Income before income taxes	$	415,400		$	605,800 Income taxes expense	200,000		300,000 Net income	$	215,400		$	305,800 Earnings per share	$	4.31		$	10.19

3a: Single debt to equity ratio: 1.0 time

4b: Single cash flow to sales: 2.2%

5a: Single price/earnings ratio: 13.9 times

Cash	$	80,000		$    192,400 Marketable securities (at cost)	203,400		84,600 Accounts receivable (net)	552,800		985,400 Inventory	629,800		1,253,400 Prepaid expenses	54,400		114,000 Property, plant, and equipment (net)	2,913,600		6,552,000 Intangibles and other assets	553,200		144,800 Total assets	$4,987,200		$9,326,600  Balance Sheets Assets

Single Design

(Continued)

Copyright 2013 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.

Chapter Assignments 699

Liabilities and Stockholders' equity

1: Net income using FIFO and straight line: $190,800

1: Net income using LIFO and

double-declining-balance: $93,200

Accounts payable

$ 344,000


$ 572,600

Notes payable

150,000


400,000

Income taxes payable

50,200


73,400

Bonds payable

2,000,000


2,000,000

Common stock, $20 par value

1,000,000


600,000

Additional paid-in capital

609,800


3,568,600

Retained earnings

833,200


2,112,000

Total liabilities and stockholders' equity

$4,987,200


$9,326,600

During the year, Single paid a total of $50,000 in dividends. The market price per share of its stock is currently $60. In comparison, Design paid a total of $114,000 in dividends, and the current market price of its stock is $76 per share. Single had net cash flows from operations of $271,500 and net capital expenditures of $625,000. Design had net cash flows from operations of $492,500 and net capital expenditures of $1,050,000. Information for prior years is not readily available. Assume that all notes payable are current liabilities and all bonds payable are long-term liabilities and that there is no change in inventory.

ReQUIReD

Conduct a comprehensive ratio analysis for each company, using the available informa- tion. Compare the results. (Round to one decimal place, and consider changes of 0.1 or less to be indeterminate.)

1. Prepare an operating asset management analysis by calculating for each company the (a) current ratio, (b) quick ratio, (c) receivables turnover, (d) days' sales uncol- lected, (e) inventory turnover, (f) days' inventory on hand, (g) payables turnover,

(h) days' payable, and (i) financing period.

2. Prepare a profitability and total asset management analysis by calculating for each company the (a) profit margin, (b) asset turnover, and (c) return on assets.

3. Prepare a financial risk analysis by calculating for each company the (a) debt to equity ratio, (b) return on equity, and (c) interest coverage ratio.

4. Prepare a liquidity analysis by calculating for each company the (a) cash flow yield,

(b) cash flows to sales, (c) cash flows to assets, and (d) free cash flow.

5. Prepare an analysis of market strength by calculating for each company the (a) price/earnings (P/E) ratio and (b) dividend yield.

6. aCCoUntinG ConneCtion ? Compare the two companies by inserting the ratio calculations from 1 through 5 in a table with the following column headings: Ratio Name, Single, Design, and Company with More Favorable Ratio. Indicate in the last column which company had the more favorable ratio in each case.

7. BUSineSS appliCation ? How could the analysis be improved if information about these companies' prior years were available?

Reference no: EM131128537

Questions Cloud

Status of children-role of women-role of the aged-customs : Research what a person would need to know in order to visit your country successfully. In your search, look for topics such as family, status of children, role of women, role of the aged, customs, taboos, superstitions, values, language, body languag..
Allocating costs among products : Bryson Construction Company expects to build three new homes during a specific accounting period. The estimated direct materials and labor costs are as follows.
Explain the price as empirical appearance for value : Explain the he relation between value and price. Explain the price as empirical appearance for value. What is organic composition of capital (C/V)? Equal rate of profit? Why? Keyword: competition
Comprehensive ratio analysis of two companies : P4. Mel Filbert is considering an investment in the common stock of a chain of retail department stores. She has narrowed her choice to two retail companies, Single Cor- poration and Design Corporation, whose income statements and balance sheets ..
Creating report for the search comitee of new applicants : Brief Job description:You are the Human Resources Director of Recruitment for XYZ Enterprises. Your job consists of creating a report for the "search comitee" of new applicants for the building and grounds crew. The report must detail the strategy us..
What is the triple bottom line : What is the "triple bottom line"? Do you think this is a valid way to evaluate organizations (and why)? Based on your comments, give three specific recommendations of ways to evaluate an organization's success.
What makes prediction in social science so difficult : Social Scientists may explain the past pretty well, but they're not very good at predicting the future. We're good at predicting some things--for example, we can predict election results OK, with good polls. But wars? Economic recessions? Revoluti..
Administrative processing and transportation : Suppose the weekly demand for a popular tablet computer follows the normal distribution, N(1500, 200) in UK, N (2000, 250) in Germany, and N (1200, 200) in France. Amazon sources the tablet at $250 per unit, and the sourcing lead time is 2 weeks. Eac..

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd