Question
Attached is the Income Statement and BS for the last three years I have to write in my paper the following areas. Looking for help
Attached is the Income Statement and BS for the last three years I have to write in my paper the following areas. Looking for help on this data analysis.
Horizontal Analysis of Income Statement and Balance Sheet
Help on preparing a three-year, horizontal analysis of the income statement and balance sheet of your selected company.Discuss the importance and meaning of horizontal analysis.Discuss both the positive and negative trends presented in your company.
Ratio Analysis
Calculate the current ratio, quick ratio, cash to current liabilities ratio, over a two-year period.Discuss and interpret the ratios that you calculated.Discuss potential liquidity issues based on your calculations of the current and quick ratios.Are there any factors that could be erroneously influencing the results of the ratios?Discuss liquidity issues of competitive companies within the same industry.
Revenue Total Revenue Cost of Revenue Gross Profit Operating Expenses Research Development Selling General and Administrative Non Recurring Others Total Operating Expenses Operating Income or Loss Income from Continuing Operations Total Other Income/Expenses Net Earnings Before Interest and Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest Net Income From Continuing Ops Non-recurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income Net Income Preferred Stock And Other Adjustments Net Income Applicable To Common Shares 1/29/2017 94,595,000 62,282,000 32,313,000 17,132,000 1,754,000 13,427,000 36,000 13,463,000 972,000 12,491,000 4,534,000 7,957,000 7,957,000 - Cash Flow All numbers in thousands Period Ending Net Income Operating Activities, Cash Flows Provided By or Used In Depreciation Adjustments To Net Income Changes In Accounts Receivables Changes In Liabilities Changes In Inventories 7,957,000 1/29/2017 7,957,000 1,973,000 267,000 -138,000 654,000 -769,000 Changes In Other Operating Activities Total Cash Flow From Operating Activities Investing Activities, Cash Flows Provided By or Used In Capital Expenditures Investments Other Cash flows from Investing Activities Total Cash Flows From Investing Activities Financing Activities, Cash Flows Provided By or Used In Dividends Paid Sale Purchase of Stock Net Borrowings Other Cash Flows from Financing Activities Total Cash Flows From Financing Activities Effect Of Exchange Rate Changes Change In Cash and Cash Equivalents Balance Sheet All numbers in thousands Period Ending Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long Term Investments Property Plant and Equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities -161,000 9,783,000 -1,621,000 38,000 -1,583,000 -3,404,000 -6,662,000 2,274,000 -78,000 -7,870,000 -8,000 330,000 1/29/2017 2,538,000 2,029,000 12,549,000 608,000 17,724,000 21,914,000 2,093,000 1,235,000 42,966,000 11,212,000 1,252,000 1,669,000 14,133,000 Long Term Debt Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities Stockholders' Equity Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total Stockholder Equity Net Tangible Assets 22,349,000 1,855,000 296,000 38,633,000 88,000 35,519,000 -40,194,000 9,787,000 -867,000 4,333,000 2,240,000 1/31/2016 88,519,000 58,254,000 30,265,000 - 2/1/2015 83,176,000 54,787,000 28,389,000 - 16,801,000 - 16,280,000 - 1,690,000 - 1,640,000 - 11,774,000 10,469,000 166,000 11,940,000 919,000 11,021,000 4,012,000 337,000 10,806,000 830,000 9,976,000 3,631,000 - 7,009,000 - 6,345,000 - 7,009,000 - 6,345,000 - 7,009,000 6,345,000 1/31/2016 7,009,000 2/1/2015 6,345,000 1,863,000 100,000 -181,000 1,151,000 -546,000 1,786,000 -98,000 -81,000 558,000 -124,000 -23,000 9,373,000 -144,000 8,242,000 -1,503,000 144,000 -1,623,000 -2,982,000 -1,442,000 323,000 -152,000 -1,271,000 -3,031,000 -6,772,000 4,012,000 4,000 -5,787,000 -111,000 604,000 -2,530,000 -6,748,000 2,232,000 -25,000 -7,071,000 -106,000 -100,000 1/31/2016 2/1/2015 2,216,000 1,723,000 - 1,890,000 11,809,000 569,000 16,484,000 - 1,484,000 11,079,000 1,016,000 15,302,000 - 22,191,000 2,102,000 - 22,720,000 1,353,000 - 1,196,000 - 571,000 - 41,973,000 39,946,000 10,531,000 427,000 1,566,000 12,524,000 9,473,000 328,000 1,468,000 11,269,000 20,789,000 1,965,000 379,000 - 16,869,000 1,844,000 642,000 - 35,657,000 - 30,624,000 - 88,000 30,973,000 -33,194,000 9,347,000 -898,000 6,316,000 4,214,000 88,000 26,995,000 -26,194,000 8,885,000 -452,000 9,322,000 7,969,000 Annual Income Statement (values in 000's)Get Quarterly Data Period Ending: Trend Total Revenue 1/29/2017 $94,595,000 Cost of Revenue $62,282,000 Gross Profit $32,313,000 Operating Expenses Research and Development Sales, General and Admin. Non-Recurring Items Other Operating Items Operating Income Add'l income/expense items Earnings Before Interest and Tax Interest Expense Earnings Before Tax Income Tax $0 $17,132,000 $0 $1,754,000 $13,427,000 $36,000 $13,463,000 $972,000 $12,491,000 $4,534,000 Minority Interest $0 Equity Earnings/Loss Unconsolidated Subsidiary $0 Net Income-Cont. Operations $7,957,000 Net Income $7,957,000 Net Income Applicable to Common Shareholders $7,957,000 Read more: htp://www.nasdaq.com/symbol/hd/financials?query=income-statement#ixzz4jRGVdYIj 1/31/2016 2/1/2015 $88,519,000 $83,176,000 $58,254,000 $54,787,000 $30,265,000 $28,389,000 $0 $0 $16,801,000 $16,280,000 $0 $0 $1,690,000 $1,640,000 $11,774,000 $10,469,000 $166,000 $337,000 $11,940,000 $10,806,000 $919,000 $830,000 $11,021,000 $9,976,000 $4,012,000 $3,631,000 $0 $0 $0 $0 $7,009,000 $6,345,000 $7,009,000 $6,345,000 $7,009,000 $6,345,000 ment#ixzz4jRGVdYIj Annual Income Statement (values in 000's)Get Quarterly Data Period Ending: Current Assets Cash and Cash Equivalents Short-Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long-Term Assets Long-Term Investments Fixed Assets Goodwill Intangible Assets Other Assets Deferred Asset Charges Total Assets Current Liabilities Accounts Payable Short-Term Debt / Current Portion of Long-Term Debt Other Current Liabilities Total Current Liabilities Long-Term Debt Other Liabilities Deferred Liability Charges Misc. Stocks Minority Interest Total Liabilities Stock Holders Equity Common Stocks Capital Surplus Retained Earnings Treasury Stock Other Equity Total Equity Total Liabilities & Equity Read more: htp://www.nasdaq.com/symbol/hd/financials?query=balance-sheet#ixzz4jRGqTHcn Trend 1/29/2017 1/31/2016 2/1/2015 $2,538,000 $2,216,000 $1,723,000 $0 $0 $0 $2,029,000 $1,890,000 $1,484,000 $12,549,000 $11,809,000 $11,079,000 $608,000 $569,000 $1,016,000 $17,724,000 $16,484,000 $15,302,000 $0 $0 $0 $21,914,000 $22,191,000 $22,720,000 $2,093,000 $2,102,000 $1,353,000 $0 $0 $0 $1,235,000 $1,196,000 $571,000 $0 $0 $0 $42,966,000 $41,973,000 $39,946,000 $11,212,000 $10,531,000 $9,473,000 $1,252,000 $427,000 $328,000 $1,669,000 $1,566,000 $1,468,000 $14,133,000 $12,524,000 $11,269,000 $22,349,000 $20,789,000 $16,869,000 $1,855,000 $1,965,000 $1,844,000 $296,000 $379,000 $642,000 $0 $0 $0 $0 $0 $0 $38,633,000 $35,657,000 $30,624,000 $88,000 $88,000 $88,000 $9,787,000 $9,347,000 $8,885,000 $35,519,000 $30,973,000 $26,995,000 ($40,194,000) ($33,194,000) ($26,194,000) ($867,000) ($898,000) ($452,000) $4,333,000 $6,316,000 $9,322,000 $42,966,000 $41,973,000 $39,946,000Step 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