Question
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:
- A qualitative assessment and narrative of the firms overall financial position
- Analysis of the firms industry and their competitive position within that industry.
- Detailed spreadsheet presentation of the WACC model
- Detailed discounted cash flow analysis
- 5-year analysis of the firms financial statements
(To include relevant ratio analysis).
- 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
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