Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the given financial statements of Home depot to prepare a comprehensive financial analysis of this firm. The analysis to be included: A qualitative assessment

Use the given financial statements of Home depot to prepare a comprehensive financial analysis of this firm.

The analysis to be included:

  1. A qualitative assessment and narrative of the firms overall financial position
  2. Analysis of the firms industry and their competitive position within that industry.
  3. Detailed spreadsheet presentation of the WACC model
  4. Detailed discounted cash flow analysis
  5. 5-year analysis of the firms financial statements

(To include relevant ratio analysis).

  1. Recommendation (buy/sell, long- or short-term) and rationale.

    Cash Flow

    All numbers in thousands

    Period Ending

    2/3/2019

    1/28/2018

    1/29/2017

    1/31/2016

    Net Income

    11,121,000

    8,630,000

    7,957,000

    7,009,000

    Operating Activities, Cash Flows Provided By or Used In

    Depreciation

    2,152,000

    2,062,000

    1,973,000

    1,863,000

    Adjustments To Net Income

    426,000

    693,000

    271,000

    100,000

    Changes In Accounts Receivables

    33,000

    139,000

    -138,000

    -181,000

    Changes In Liabilities

    849,000

    572,000

    428,000

    1,012,000

    Changes In Inventories

    -1,244,000

    -84,000

    -769,000

    -546,000

    Changes In Other Operating Activities

    -257,000

    -10,000

    -48,000

    -38,000

    Total Cash Flow From Operating Activities

    13,038,000

    12,031,000

    9,783,000

    9,373,000

    Investing Activities, Cash Flows Provided By or Used In

    Capital Expenditures

    -2,442,000

    -1,897,000

    -1,621,000

    -1,503,000

    Investments

    -

    -

    -

    144,000

    Other Cash flows from Investing Activities

    14,000

    -4,000

    -4,000

    -4,000

    Total Cash Flows From Investing Activities

    -2,416,000

    -2,228,000

    -1,583,000

    -2,982,000

    Financing Activities, Cash Flows Provided By or Used In

    Dividends Paid

    -4,704,000

    -4,212,000

    -3,404,000

    -3,031,000

    Sale Purchase of Stock

    -

    -

    -

    -

    Net Borrowings

    2,037,000

    3,298,000

    2,274,000

    4,012,000

    Other Cash Flows from Financing Activities

    -26,000

    -211,000

    -78,000

    4,000

    Total Cash Flows From Financing Activities

    -12,420,000

    -8,870,000

    -7,870,000

    -5,787,000

    Effect Of Exchange Rate Changes

    -19,000

    124,000

    -8,000

    -111,000

    Change In Cash and Cash Equivalents

    -1,817,000

    1,057,000

    322,000

    493,000

Income Statement

Revenue

2/3/2019

1/28/2018

1/29/2017

1/31/2016

Total Revenue

108,203,000

100,904,000

94,595,000

88,519,000

Cost of Revenue

71,043,000

66,548,000

62,282,000

58,254,000

Gross Profit

37,160,000

34,356,000

32,313,000

30,265,000

Operating Expenses

Research Development

-

-

-

-

Selling General and Administrative

19,513,000

17,694,000

17,132,000

16,801,000

Non Recurring

-

-

-

-

Others

-

-

-

-

Total Operating Expenses

92,426,000

86,053,000

81,168,000

76,745,000

Operating Income or Loss

15,777,000

14,851,000

13,427,000

11,774,000

Income from Continuing Operations

Total Other Income/Expenses Net

-1,221,000

-1,153,000

-936,000

-753,000

Earnings Before Interest and Taxes

15,777,000

14,851,000

13,427,000

11,774,000

Interest Expense

-1,051,000

-1,057,000

-972,000

-919,000

Income Before Tax

14,556,000

13,698,000

12,491,000

11,021,000

Income Tax Expense

3,435,000

5,068,000

4,534,000

4,012,000

Minority Interest

-

-

-

-

Net Income From Continuing Ops

11,121,000

8,630,000

7,957,000

7,009,000

Non-recurring Events

Discontinued Operations

-

-

-

-

Extraordinary Items

-

-

-

-

Effect Of Accounting Changes

-

-

-

-

Other Items

-

-

-

-

Net Income

Net Income

11,121,000

8,630,000

7,957,000

7,009,000

Preferred Stock And Other Adjustments

-

-

-

-

Net Income Applicable To Common Shares

11,121,000

8,630,000

7,957,000

7,009,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

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

Forecasting Principles And Practice

Authors: Rob J Hyndman, George Athanasopoulos

3rd Edition

0987507133, 978-0987507136

More Books

Students also viewed these Finance questions

Question

2. List and describe the four types of DSS intermediaries.

Answered: 1 week ago