Prepare a vertical analysis of the income statement data

Assignment Help Accounting Basics
Reference no: EM132099367

Problem 1 - Comparative statement data for Farris Company and Ratzlaff Company, two competitors, appear below. All balance sheet data are as of December 31, 2017, and December 31, 2016.


Farris Company

Ratzlaff Company


2017

2016

2017

2016

Net sales

$1,570,000


$339,400


Cost of goods sold

1,080,000


241,100


Operating expenses

301,200


80,000


Interest expense

8,300


2,200


Income tax expense

54,300


6,400


Current assets

320,000

$314,200

82,300

$78,600

Plant assets (net)

521,700

500,000

139,200

124,500

Current liabilities

65,400

74,600

36,400

30,600

Long-term liabilities

108,400

89,800

29,200

25,400

Common stock, $10 par

498,000

498,000

117,000

117,000

Retained earnings

169,900

151,800

38,900

30,100

Prepare a vertical analysis of the 2017 income statement data for Farris Company and Ratzlaff Company in columnar form.

Compute the return on assets and the return on common stockholders' equity ratios for both companies.

Problem 2 - The comparative statements of Painter Tool Company are presented below.

PAINTER TOOL COMPANY Income Statement For the Years Ended December 31


2017

2016

Net sales

$1,815,700

$1,749,500

Cost of goods sold

1,011,000

981,000

Gross profit

804,700

768,500

Selling and administrative expenses

515,000

477,600

Income from operations

289,700

290,900

Other expenses and losses



Interest expense

19,000

14,300

Income before income taxes

270,700

276,600

Income tax expense

80,800

76,700

Net income

$ 189,900

$ 199,900

 

PAINTER TOOL COMPANY Balance Sheets December 31

Assets

2017

2016

Current assets



Cash

$60,900

$63,800

Short-term investments

68,900

51,000

Accounts receivable (net)

116,700

102,300

Inventory

123,800

115,700

Total current assets

370,300

332,800

Plant assets (net)

600,600

517,800

Total assets

$970,900

$850,600

Liabilities and Stockholders' Equity



Current liabilities



Accounts payable

$159,900

$144,200

Income taxes payable

44,000

42,600

Total current liabilities

203,900

186,800

Bonds payable

202,200

202,200

Total liabilities

406,100

389,000

Stockholders' equity



Common stock ($5 par)

279,200

297,100

Retained earnings

285,600

164,500

Total stockholders' equity

564,800

461,600

Total liabilities and stockholders' equity

$970,900

$850,600

All sales were on account.

Compute the following ratios for 2017. (Weighted-average common shares in 2017 were 58,400.)

(a) Earnings per share

(b) Return on common stockholders' equity

(c) Return on assets

(d) Current ratio

(e) Acid-test ratio

(f) Accounts receivable turnover

(g) Inventory turnover

(h) Times interest earned

(i) Asset turnover

(j) Debt to assets ratio

Reference no: EM132099367

Questions Cloud

How often are the challenges the authors discuss : How often are the challenges the authors discuss on page 195 and 196 actually issues? If you were to rewrite that section, what challenges would you include?
What is the impact of a complete rfi and rfp process : What is the impact of a well- defined and complete RFI and RFP process on identification and selection of a healthcare information system?
Er model - qrentals database system : ER model - QRentals database system - If a booking is cancelled, the relevant details of booking is still kept in the system but the corresponding rental
Review your strategic communications plan : Do your communications plan, written communication and presentation plan all align to meet the objectives of your goal? Explain how they align.
Prepare a vertical analysis of the income statement data : Prepare a vertical analysis of the 2017 income statement data for Farris Company and Ratzlaff Company in columnar form
Explain the concept of strategy : Explain the concept of "strategy" and the connection between strategic planning and competitive advantage.
Analyze the phases of group development : Evaluate dimensions of group participation, including leadership, task roles, maintenance roles, goal achievement, power, and diversity.
Determine the main accounting assumptions : Determine the main accounting assumptions underlying each currently used method (e.g., current rate method and temporal method).
Examine the effectiveness and performance of the sites : Examine the effectiveness and performance of the sites according to the eight basic factors.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Describe the auditor ethical situation you find

Describe the AUDITOR ethical situation you find. Keep in mind that many/most of these cases also have an ethical component related to the client's managers

  What is the present equivalent of a year-end series of

what is the present equivalent of a year-end series of receipts starting with a first-year base of 1 million and

  Problem regarding the local evening paper

Paul is looking for a second-hand car when he sees an advertisement in his local evening paper which reads:

  Bipolar differential amplifier

A bipolar differential amplifier having a simple pnp current-mirror load is found to have an input offset voltage of 2 mV. If the offset is attributable entirely to the finite β of the pnp transistors, what must βP be?

  Gain or loss recognizing on the sale

Patrice sells a parcel of land for $50,000 cash and the buyer assumes Patrice's liability of $7,000 on the land. Patrice's basis in the land is $40,000. What is the gain or loss she will recognize on the sale?

  The allocation of its gain or loss

1.Lasure, Ramirez, and Toney, who share income and loss in a 2:1:2 ratio, plan to liquidate their partnership. At liquidation, their balance sheet appears as follows.

  Required identify the shortcomings in the payroll

control activities in payroll processing as part of the audit of manor company you are assigned to review and test the

  Griffin corporation reports 400000 of taxable income for

griffin corporation reports 400000 of taxable income for the current year. the following additional information is

  Prepare the journal entry to record each semiannual

The current market rate is 8%. Prepare the journal entry to record each semiannual interest payment

  Calculate the average manufacturing cycle times per order

Calculate the average manufacturing cycle times per order (a) if DJ manufactures only Peterbilt and (b) if DJ manufactures both Peterbilt and Kenworth.

  What amount of intra-entity inventory profit must deferred

At year-end, only $24,000 of merchandise was still being held by Yale. What amount of intra-entity inventory profit must be deferred by Tower

  Measuring economic damages in wrongful discharge case

What are the commonly used components when measuring economic damages in a wrongful discharge case?

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