Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started