Prepare a schedule showing a horizontal analysis

Assignment Help Accounting Basics
Reference no: EM131567107

Q1 - Financial information for Kurzen Inc. is presented below.


December 31, 2017

December 31, 2016

Current assets

$122,000

$102,000

Plant assets (net)

394,800

333,500

Current liabilities

87,800

73,600

Long-term liabilities

128,500

87,600

Common stock, $1 par

166,400

110,000

Retained earnings

134,100

164,300

Prepare a schedule showing a horizontal analysis for 2017 using 2016 as the base year.

Q2 - Operating data for Navarro Corporation are presented below.


2017

2016

Net sales

$745,000

$600,500

Cost of goods sold

461,000

391,500

Selling expenses

124,500

68,000

Administrative expenses

60,000

56,000

Income tax expense

33,000

19,500

Net income

66,500

65,500

Prepare a schedule showing a vertical analysis for 2017 and 2016.

Q3 - 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,510,000


$339,400


Cost of goods sold

1,020,000


241,500


Operating expenses

300,000


78,700


Interest expense

8,800


2,700


Income tax expense

54,000


6,700


Current assets

324,000

$313,600

83,200

$78,900

Plant assets (net)

521,400

499,400

139,200

124,500

Current liabilities

65,600

75,800

35,800

29,200

Long-term liabilities

108,400

89,000

28,800

25,400

Common stock, $10 par

497,000

497,000

124,500

124,500

Retained earnings

174,400

151,200

33,300

24,300

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.

Q4 - 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,818,700

$1,749,800

Cost of goods sold

1,007,700

987,000

Gross profit

811,000

762,800

Selling and administrative expenses

518,400

480,200

Income from operations

292,600

282,600

Other expenses and losses



   Interest expense

17,600

14,300

Income before income taxes

275,000

268,300

Income tax expense

80,400

77,300

Net income

$ 194,600

$ 191,000

 

PAINTER TOOL COMPANY Balance Sheets December 31

Assets

2017

2016

Current assets



    Cash

$60,200

$64,200

    Short-term investments

69,600

49,900

    Accounts receivable (net)

117,400

101,300

    Inventory

123,800

114,800

      Total current assets

371,000

330,200

Plant assets (net)

598,400

516,800

Total assets

$969,400

$847,000

Liabilities and Stockholders' Equity



Current liabilities



    Accounts payable

$160,800

$145,500

    Income taxes payable

42,300

42,200

      Total current liabilities

203,100

187,700

Bonds payable

199,500

199,500

      Total liabilities

402,600

387,200

Stockholders' equity



    Common stock ($5 par)

277,700

295,300

    Retained earnings

289,100

164,500

      Total stockholders' equity

566,800

459,800

Total liabilities and stockholders' equity

$969,400

$847,000

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

(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: EM131567107

Questions Cloud

Advantages and disadvantages of hospital versus home : Discuss the relevant medical issues and the advantages and disadvantages of hospital versus home
Embrace the new idea of innovation : Suggests ways that the corporation can embrace the new idea of innovation. Clearly state necessary resources.
What are your opinions on the activitiesof npes : Let's chat about NPEs, sometimes referred to as patent trolls. What are they? What are your opinions on the activities/usefulness of NPEs
How would dualist perspectives go about studying the brain : When talking about monists or dualist, how would these perspectives go about studying the brain
Prepare a schedule showing a horizontal analysis : Financial information for Kurzen Inc. is presented below. Prepare a schedule showing a horizontal analysis for 2017 using 2016 as the base year
What is the total amount paid to the bank : A business borrows 500 000 euros from a bank at the beginning of one year, and is supposed to pay it off in 10 equal instalments at the end of each year.
Beliefs affect your workplace behavior : How does your values, attitudes and beliefs affect your workplace behavior? How do stereotypes and selective perceptions affect an individuals interaction?
Create a form using form tool based on the presenters table : Create a form using the Form tool based on the Presenters table. Change the title in the Form Header to Enter/Edit Presenters.
Research and discuss the prenatal development : the area of development to research and discuss Prenatal development

Reviews

Write a Review

Accounting Basics Questions & Answers

  What are the major types of subsequent events

What are the major types of subsequent events? Indicate how each of the following "subsequent events" would be reported.

  Mary lynn corporation has been operating for many years

mary lynn corporation has been operating for several years. selected data from the 20x1 and 20x2 financial statements

  Comparative advantage and absolute advantage

The minister has argued that raising the tax on alcohol is the most effective way to reduce alcohol abuse in our society. Do you agree or disagree?

  Determine the book value of the building

Passat Company owns a building that appears on its prior year-end balance sheet at its original $561,000 cost less $420,750 accumulated depreciation.

  On january 1 2008 desmet company purchased office equipment

on january 1 2008 desmet company purchased office equipment that cost 29000 cash. the equipment was delivered under

  Process from the data on the job cost sheets

Prepare the summary entries to record the assignment of costs to Work in Process from the data on the job cost sheets.

  Percent of the outstanding stock every year

Estimate the debt ratio each year for the next five years, assuming that the firm maintains it current payout ratio. Estimate the debt ratio each year for the next five years, assuming that the firm doubles its dividends and repurchases 5 percent of..

  The production manager of a large company reports the

the production manager of a large company reports the following data for the production of the companys single

  Recognized gain or loss on the distribution

(Assume that X Co. acquired the property distributed to D in a Sec. 351 transfer 6 months before adopting the plan of liquidation when the FMV of the property was $800 and X Co.'s basis was $2,800).

  Glam company makes two products from a joint input that

glam company makes two products from a joint input that have the following information product x 50000 units produced

  Compute the number of units transferred to finished goods

During April, the production department of a process manufacturing system completed a number of units of a product and transferred them to finished goods.

  Freeman company uses a predetermined overhead rate based on

freeman company uses a predetermined overhead rate based on direct labor-hours to apply manufacturing overhead to jobs.

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