Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Home depot Horizontal and vertical analysis of the income statements for the past three years (all yearly balances set as a percentage of total revenues

Home depot

Horizontal and vertical analysis of the income statements for the past three years (all yearly balances set as a percentage of total revenues for that year)?

Horizontal and vertical analysis of the balance sheets for the past three years (all yearly balances set as a percentage of total assets for that year)?

Ratio analysis (eight ratios of your choosing) for the past three years PLUS a measurement for the creditworthiness of your firm as measured by Altmans Z-score?

Income Statement

All numbers in thousands

Revenue 1/29/2017 1/31/2016 2/1/2015
Total Revenue 94,595,000 88,519,000 83,176,000
Cost of Revenue 62,282,000 58,254,000 54,787,000
Gross Profit 32,313,000 30,265,000 28,389,000
Operating Expenses
Research Development - - -
Selling General and Administrative 17,132,000 16,801,000 16,280,000
Non Recurring - - -
Others 1,754,000 1,690,000 1,640,000
Total Operating Expenses - - -
Operating Income or Loss 13,427,000 11,774,000 10,469,000
Income from Continuing Operations
Total Other Income/Expenses Net 36,000 166,000 337,000
Earnings Before Interest and Taxes 13,463,000 11,940,000 10,806,000
Interest Expense 972,000 919,000 830,000
Income Before Tax 12,491,000 11,021,000 9,976,000
Income Tax Expense 4,534,000 4,012,000 3,631,000
Minority Interest - - -
Net Income From Continuing Ops 7,957,000 7,009,000 6,345,000
Non-recurring Events
Discontinued Operations - - -
Extraordinary Items - - -
Effect Of Accounting Changes - - -
Other Items - - -
Net Income
Net Income 7,957,000 7,009,000 6,345,000
Preferred Stock And Other Adjustments - - -
Net Income Applicable To Common Shares 7,957,000 7,009,000 6,345,000

Cash Flow

All numbers in thousands

Period Ending 1/29/2017 1/31/2016 2/1/2015
Net Income 7,957,000 7,009,000 6,345,000
Operating Activities, Cash Flows Provided By or Used In
Depreciation 1,973,000 1,863,000 1,786,000
Adjustments To Net Income 267,000 100,000 -98,000
Changes In Accounts Receivables -138,000 -181,000 -81,000
Changes In Liabilities 654,000 1,151,000 558,000
Changes In Inventories -769,000 -546,000 -124,000
Changes In Other Operating Activities -161,000 -23,000 -144,000
Total Cash Flow From Operating Activities 9,783,000 9,373,000 8,242,000
Investing Activities, Cash Flows Provided By or Used In
Capital Expenditures -1,621,000 -1,503,000 -1,442,000
Investments - 144,000 323,000
Other Cash flows from Investing Activities 38,000 -1,623,000 -152,000
Total Cash Flows From Investing Activities -1,583,000 -2,982,000 -1,271,000
Financing Activities, Cash Flows Provided By or Used In
Dividends Paid -3,404,000 -3,031,000 -2,530,000
Sale Purchase of Stock -6,662,000 -6,772,000 -6,748,000
Net Borrowings 2,274,000 4,012,000 2,232,000
Other Cash Flows from Financing Activities -78,000 4,000 -25,000
Total Cash Flows From Financing Activities -7,870,000 -5,787,000 -7,071,000
Effect Of Exchange Rate Changes -8,000 -111,000 -106,000
Change In Cash and Cash Equivalents 330,000 604,000 -100,000

Balance Sheet

All numbers in thousands

Period Ending 1/29/2017 1/31/2016 2/1/2015
Current Assets
Cash And Cash Equivalents 2,538,000 2,216,000 1,723,000
Short Term Investments - - -
Net Receivables 2,029,000 1,890,000 1,484,000
Inventory 12,549,000 11,809,000 11,079,000
Other Current Assets 608,000 569,000 1,016,000
Total Current Assets 17,724,000 16,484,000 15,302,000
Long Term Investments - - -
Property Plant and Equipment 21,914,000 22,191,000 22,720,000
Goodwill 2,093,000 2,102,000 1,353,000
Intangible Assets - - -
Accumulated Amortization - - -
Other Assets 1,235,000 1,196,000 571,000
Deferred Long Term Asset Charges - - -
Total Assets 42,966,000 41,973,000 39,946,000
Current Liabilities
Accounts Payable 11,212,000 10,531,000 9,473,000
Short/Current Long Term Debt 1,252,000 427,000 328,000
Other Current Liabilities 1,669,000 1,566,000 1,468,000
Total Current Liabilities 14,133,000 12,524,000 11,269,000
Long Term Debt 22,349,000 20,789,000 16,869,000
Other Liabilities 1,855,000 1,965,000 1,844,000
Deferred Long Term Liability Charges 296,000 379,000 642,000
Minority Interest - - -
Negative Goodwill - - -
Total Liabilities 38,633,000 35,657,000 30,624,000
Stockholders' Equity
Misc. Stocks Options Warrants - - -
Redeemable Preferred Stock - - -
Preferred Stock - - -
Common Stock 88,000 88,000 88,000
Retained Earnings 35,519,000 30,973,000 26,995,000
Treasury Stock -40,194,000 -33,194,000 -26,194,000
Capital Surplus 9,787,000 9,347,000 8,885,000
Other Stockholder Equity -867,000 -898,000 -452,000
Total Stockholder Equity 4,333,000 6,316,000 9,322,000
Net Tangible Assets 2,240,000 4,214,000 7,969,000

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_2

Step: 3

blur-text-image_3

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

Financial Accounting Text Only

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel

5th Edition

0006575404, 978-0006575405

More Books

Students also viewed these Accounting questions

Question

=+interactive online components, out-of-home messages, print ads,

Answered: 1 week ago

Question

=+Why does the brand want to advertise?

Answered: 1 week ago

Question

=+12. Did your concept illustrate the brand's personality?

Answered: 1 week ago