Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Provide comparison information for each of the following items for the most recent fiscal year (Be sure that you are looking at annual and not

Provide comparison information for each of the following items for the most recent fiscal year (Be sure that you are looking at annual and not quarterly information.) Keep in mind that comparing dollar amounts for different size companies can be misleading. You will need to convert the items to common size before comparing the companies results. Review Vertical and Horizontal Analysis and Ratio Analysis. Courtesy All the numbers are taken from Yahoo Finance. Two Different companies listed - Company 1 & Company 2

Income Statement:

Total Revenues

Gross Profit

Net Income

Balance Sheet:

Total Assets or Total Liabilities & Stockholders Equity

Total Cash

Net Property, Plant, and Equipment

Statement of Cash Flows:

Operating Cash Flows

Investing Cash Flows

Financing Cash Flows

Total Cash does it match the Balance Sheet Cash amount?

Go to the Key Statistics area and find at least 5 of the following pieces of important information (clearly label for each company):

Profit Margin

Return on Assets

Return on Equity

Quarterly Earnings Growth

Debt-to-Equity Ratio

Company 1

Income Statement

All numbers in thousands

Revenue

1/31/2017

1/31/2016

1/31/2015

Total Revenue

485,873,000

482,130,000

485,651,000

Cost of Revenue

361,256,000

360,984,000

365,086,000

Gross Profit

124,617,000

121,146,000

120,565,000

Operating Expenses

Research Development

-

-

-

Selling General and Administrative

101,853,000

97,041,000

93,418,000

Non Recurring

-

-

-

Others

-

-

-

Total Operating Expenses

-

-

-

Operating Income or Loss

22,764,000

24,105,000

27,147,000

Income from Continuing Operations

Total Other Income/Expenses Net

100,000

81,000

113,000

Earnings Before Interest and Taxes

22,864,000

24,186,000

27,260,000

Interest Expense

2,367,000

2,548,000

2,461,000

Income Before Tax

20,497,000

21,638,000

24,799,000

Income Tax Expense

6,204,000

6,558,000

7,985,000

Minority Interest

2,737,000

3,065,000

4,543,000

Net Income From Continuing Ops

14,293,000

15,080,000

16,814,000

Non-recurring Events

Discontinued Operations

-

-

285,000

Extraordinary Items

-

-

-

Effect Of Accounting Changes

-

-

-

Other Items

-

-

-

Net Income

Net Income

13,643,000

14,694,000

16,363,000

Preferred Stock And Other Adjustments

-

-

-

Net Income Applicable To Common Shares

13,643,000

14,694,000

16,363,000

Balance Sheet

All numbers in thousands

Period Ending

1/31/2017

1/31/2016

1/31/2015

Current Assets

Cash And Cash Equivalents

6,867,000

8,705,000

9,135,000

Short Term Investments

-

-

-

Net Receivables

5,835,000

5,624,000

6,778,000

Inventory

43,046,000

44,469,000

45,141,000

Other Current Assets

1,941,000

1,441,000

2,224,000

Total Current Assets

57,689,000

60,239,000

63,278,000

Long Term Investments

-

-

-

Property Plant and Equipment

114,178,000

116,516,000

116,655,000

Goodwill

17,037,000

16,695,000

18,102,000

Intangible Assets

-

-

-

Accumulated Amortization

-

-

-

Other Assets

9,921,000

6,131,000

5,455,000

Deferred Long Term Asset Charges

-

-

90,021,000

85,777,000

Total Assets

198,825,000

199,581,000

203,490,000

Current Liabilities

Accounts Payable

63,008,000

58,615,000

58,583,000

Short/Current Long Term Debt

3,920,000

6,004,000

6,670,000

Other Current Liabilities

-

-

-

Total Current Liabilities

66,928,000

64,619,000

65,253,000

Long Term Debt

42,018,000

44,030,000

43,495,000

Other Liabilities

-

-

-

Deferred Long Term Liability Charges

9,344,000

7,321,000

8,805,000

Minority Interest

2,737,000

3,065,000

4,543,000

Negative Goodwill

-

-

-

Total Liabilities

121,027,000

119,035,000

122,096,000

Stockholders' Equity

Misc. Stocks Options Warrants

-

-

-

Redeemable Preferred Stock

-

-

-

Preferred Stock

-

-

-

Common Stock

305,000

317,000

323,000

Retained Earnings

89,354,000

Treasury Stock

-

-

-

Capital Surplus

2,371,000

1,805,000

2,462,000

Other Stockholder Equity

-14,232,000

-11,597,000

-7,168,000

Total Stockholder Equity

77,798,000

80,546,000

81,394,000

Net Tangible Assets

60,761,000

63,851,000

63,292,000

Cash Flow

All numbers in thousands

Period Ending

1/31/2017

1/31/2016

1/31/2015

Net Income

13,643,000

14,694,000

16,363,000

Operating Activities, Cash Flows Provided By or Used In

Depreciation

10,080,000

9,454,000

9,173,000

Adjustments To Net Income

967,000

738,000

-3,000

Changes In Accounts Receivables

-402,000

-19,000

-569,000

Changes In Liabilities

5,571,000

2,839,000

4,093,000

Changes In Inventories

1,021,000

-703,000

-1,229,000

Changes In Other Operating Activities

-

-

-

Total Cash Flow From Operating Activities

31,530,000

27,389,000

28,564,000

Investing Activities, Cash Flows Provided By or Used In

Capital Expenditures

-10,619,000

-11,477,000

-12,174,000

Investments

-4,364,000

-4,364,000

-4,364,000

Other Cash flows from Investing Activities

996,000

802,000

1,049,000

Total Cash Flows From Investing Activities

-13,987,000

-10,675,000

-11,125,000

Financing Activities, Cash Flows Provided By or Used In

Dividends Paid

-6,695,000

-7,013,000

-6,785,000

Sale Purchase of Stock

-8,388,000

-5,438,000

-2,859,000

Net Borrowings

-3,591,000

-3,158,000

-5,018,000

Other Cash Flows from Financing Activities

-255,000

-513,000

-409,000

Total Cash Flows From Financing Activities

-18,929,000

-16,122,000

-15,071,000

Effect Of Exchange Rate Changes

-452,000

-1,022,000

-514,000

Change In Cash and Cash Equivalents

-1,838,000

-430,000

1,854,000

Company 2

2. Income Statement

All numbers in thousands

Revenue

1/28/2017

1/30/2016

1/31/2015

Total Revenue

115,337,000

109,830,000

108,465,000

Cost of Revenue

89,502,000

85,496,000

85,512,000

Gross Profit

25,835,000

24,334,000

22,953,000

Operating Expenses

Research Development

-

-

-

Selling General and Administrative

20,059,000

18,669,000

17,868,000

Non Recurring

-

-

-

Others

2,340,000

2,089,000

1,948,000

Total Operating Expenses

-

-

-

Operating Income or Loss

3,436,000

3,576,000

3,137,000

Income from Continuing Operations

Total Other Income/Expenses Net

-

-

-

Earnings Before Interest and Taxes

3,436,000

3,576,000

3,137,000

Interest Expense

522,000

482,000

488,000

Income Before Tax

2,914,000

3,094,000

2,649,000

Income Tax Expense

957,000

1,045,000

902,000

Minority Interest

12,000

-22,000

30,000

Net Income From Continuing Ops

1,975,000

2,039,000

1,728,000

Non-recurring Events

Discontinued Operations

-

-

-

Extraordinary Items

-

-

-

Effect Of Accounting Changes

-

-

-

Other Items

-

-

-

Net Income

Net Income

1,975,000

2,039,000

1,728,000

Preferred Stock And Other Adjustments

-

-

-

Net Income Applicable To Common Shares

1,975,000

2,039,000

1,728,000

Balance Sheet

All numbers in thousands

Period Ending

1/28/2017

1/30/2016

1/31/2015

Current Assets

Cash And Cash Equivalents

322,000

277,000

268,000

Short Term Investments

-

-

-

Net Receivables

1,649,000

1,734,000

1,266,000

Inventory

6,561,000

6,168,000

5,688,000

Other Current Assets

1,808,000

1,713,000

1,689,000

Total Current Assets

10,340,000

9,892,000

8,911,000

Long Term Investments

-

-

-

Property Plant and Equipment

21,016,000

19,619,000

17,912,000

Goodwill

3,031,000

2,724,000

2,304,000

Intangible Assets

1,153,000

1,053,000

757,000

Accumulated Amortization

-

-

-

Other Assets

965,000

609,000

613,000

Deferred Long Term Asset Charges

-

-

-

Total Assets

36,505,000

33,897,000

30,497,000

Current Liabilities

Accounts Payable

7,303,000

7,375,000

6,630,000

Short/Current Long Term Debt

2,252,000

2,370,000

1,874,000

Other Current Liabilities

3,305,000

3,226,000

2,888,000

Total Current Liabilities

12,860,000

12,971,000

11,392,000

Long Term Debt

11,825,000

9,709,000

9,723,000

Other Liabilities

3,183,000

2,667,000

2,731,000

Deferred Long Term Liability Charges

1,927,000

1,752,000

1,209,000

Minority Interest

12,000

-22,000

30,000

Negative Goodwill

-

-

-

Total Liabilities

29,807,000

27,077,000

25,085,000

Stockholders' Equity

Misc. Stocks Options Warrants

-

-

-

Redeemable Preferred Stock

-

-

-

Preferred Stock

-

-

-

Common Stock

1,918,000

1,918,000

1,918,000

Retained Earnings

15,543,000

14,011,000

12,367,000

Treasury Stock

-13,118,000

-11,409,000

-10,809,000

Capital Surplus

3,070,000

2,980,000

2,748,000

Other Stockholder Equity

-715,000

-680,000

-812,000

Total Stockholder Equity

6,698,000

6,820,000

5,412,000

Net Tangible Assets

2,514,000

3,043,000

2,351,000

Cash Flow

All numbers in thousands

Period Ending

1/28/2017

1/30/2016

1/31/2015

Net Income

1,975,000

2,039,000

1,728,000

Operating Activities, Cash Flows Provided By or Used In

Depreciation

2,340,000

2,089,000

1,948,000

Adjustments To Net Income

453,000

713,000

539,000

Changes In Accounts Receivables

-110,000

-59,000

-141,000

Changes In Liabilities

159,000

351,000

316,000

Changes In Inventories

-382,000

-184,000

-147,000

Changes In Other Operating Activities

-145,000

-42,000

-47,000

Total Cash Flow From Operating Activities

4,272,000

4,917,000

4,215,000

Investing Activities, Cash Flows Provided By or Used In

Capital Expenditures

-3,699,000

-3,349,000

-2,831,000

Investments

-

-

-

Other Cash flows from Investing Activities

-176,000

-221,000

-229,000

Total Cash Flows From Investing Activities

-3,875,000

-3,570,000

-3,060,000

Financing Activities, Cash Flows Provided By or Used In

Dividends Paid

-429,000

-385,000

-338,000

Sale Purchase of Stock

-1,698,000

-609,000

-1,173,000

Net Borrowings

1,861,000

-349,000

226,000

Other Cash Flows from Financing Activities

-86,000

-92,000

-55,000

Total Cash Flows From Financing Activities

-352,000

-1,338,000

-1,288,000

Effect Of Exchange Rate Changes

-

-

-

Change In Cash and Cash Equivalents

45,000

9,000

-133,000

**** Make a recommendation of the company that you would most like to invest in. Provide a brief discussion of your reason for selecting the company that you have chosen. Refer to your analysis to support your decision.

***** Please help me solve this problem with a proper table format to fully understand the numbers & which according to you would be more beneficial company to be investing in? Thank You

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

Survey Of Accounting

Authors: Carl S. Warren

4th Edition

0538478144, 9780538478144

More Books

Students also viewed these Accounting questions

Question

Will formal performance reviews become obsolete? Why or why not?

Answered: 1 week ago