1" PART OF THE PROJECT First, go to the following web site: https://finance.yahoo.com/ Type "Home Depot Inc" in the search box. Then click on "search". Select the ticker symbol "HD" from the menu of choices. (NOTE: The ticker symbol for Home Depot Inc is HD. The ticker symbol is a letter designation that is assigned to stocks and mutual funds traded on U.S. exchanges. You may use it to "get quotes" instead of typing in the whole company name) This will take you to a page of basic information about Home Depot Inc's stock. It will show you the current price and the volume of trading. From this menu, you will click on the following links to obtain the necessary information: Summary Profile Financials Historical Data Each of the above links will be discussed in the following pages. You will be asked to go to each of the linked pages and record information in the spaces provided. Summary The earnings per share of a company measures the amount of income earned for each share of stock, which is net income divided by shares of common stock outstanding. Earnings per share are abbreviated as "EPS". The earnings per share (EPS) for Home Depot Inc for the most recent year shown on this page are (Note: TTM = trailing twelve months (the past 12 months)_ The current price of Home Depot's Inc common stock is? on Date Profile (Record the Last Trade price and the date you looked at it) From the Profile Page, you can obtain a brief Business Description. There is also general contact information as well as links to several other items, such as the company web site. From this page, answer the following questions about Home Depot Inc: 1. What Industry is Home Depot Inc in?. 2. How many full-time employees work for Home Depot Inc? 3. Who is the Chief Executive Officer? 4. Who is the Chief Financial Officer? Historical Data From this page, you can obtain daily, weekly, and monthly prices for the company for a range of dates. You can also obtain information on dividends. Select/input "Time Period" as 7/28/2022-7/31/2022, "Show" as Historical Prices, and "Frequency" as Daily to capture the historical price at the end of last year. (If select/input date couldn't apply, simply scroll down to find "Jul 29, 2022") Look at the column listing the adjusted closing price (this price is adjusted for stock splits and stock dividends). What was the adjusted Closing price of the company for 7/29/2022? How much money would you have made or lost from the price change if you had purchased one share of Home Depot Inc stock on 7/29/2022 and sold it on the day you looked up the current price? Financials 2nd PART OF THE PROJECT From this page, you can view the recent quarterly or annual financial statements of the company. In order to compare Home Depot Inc to a close competitor, Lowe's Companies Inc, we will use data for the quarter ending 7/31/2022&7/29/2022, respectively. Open the 10-Q of Home Depot Inc and Lowe's Companies Inc (link provided at the beginning of this project) and click on income statement or balance sheet of Home Depot Inc as requested below. Home Depot Inc Income Statement - Consolidated Statements of Earnings: Page 2 on Q1 & Q2 reports. Consolidated Balance Sheets: Page 1 on Q1 & Q2 reports. Lowe's Companies Inc Income Statement - Consolidated Statements of Earnings: Page 1 on Q1 & Q2 reports. Consolidated Balance Sheets: Page 2 on Q1 & Q2 reports. Notice that all numbers are in millions of dollars in the following part of the project. Write them down on your worksheet just as they are. For example, if it says $7,000, just write $7,000 or $7,000 million as your final answer, do not write $7,000,000,000. Questions 1 through 16 pertain to Home Depot Inc: 1. From the quarterly Income Statement, what was the total revenue (net sales) for the quarter ending on 7/31/2022? 2. From the quarterly Income Statement, what was the total revenue (net sales) for the previous quarter ending on 5/1/2022? 4. *Use the 3 months ended value 3. Now use your answers of 1 and 2 to calculate the % growth in revenue for the quarter (subtract revenues for the quarter ending 5/1/2022 from revenues for the quarter ending 7/31/2022 and divide the result by the revenues for the quarter ending 5/1/2022. Then express the result as a percentage). Revenue Growth = From the quarterly Income Statement, what was Consolidated Net Income (net earnings) for the quarter ending on 7/31/2022? *Use the 3 months ended value 5. From the quarterly Income Statement, what was the Gross Profit for the quarter ending on 7/31/2022? "Gross Profit Net Sales - Cost of Sales 6. From the quarterly Income Statement, what was the Cost of Sales (cost of goods sold) for the quarter ending on 7/31/2022? 7. From the quarterly Balance Sheet, what was the value of inventory as of 7/31/2022? 8. From the quarterly Balance Sheet, what was the value of inventory as of 5/1/2022? 9. From the quarterly Balance Sheet, what was the total assets value as of 7/31/2022? 10. From the quarterly Balance Sheet, what was the total liabilities as of 7/31/2022? 11. From the quarterly Balance Sheet, what was the total current assets value as of 7/31/2022? 12. From the quarterly Balance Sheet, what was the total current liabilities value as of 7/31/2022? Use Quarterly data ending at 7/31/2022 to answer question 13 to 16. 13. The largest current asset category is: 14. The largest current liability category is: 15. The largest non-current asset category is: 16. The largest non-current liability category is: FINANCIAL RATIOS Use the information gathered from Home Depot Inc's Financials on the previous pages to calculate the following ratios for Home Depot Inc. Do not try to look these up on the website. Instead, you must make the calculation yourself. Inventory Turnover (Cost of Goods Sold / Average Inventory) Average Inventory (Beginning Inventory + Ending Inventory)/2 Gross profit % (as of 7/31/2022) (Gross Profit / Revenues) *100% Debt Ratio (Total Liabilities/Total Asset) Current Ratio (Current Asset/Current Liabilities) Compare Home Depot Inc to its close competitor Lowe's Companies Inc. Now open the income statement and balance sheet for Lowe's Companies Inc: Income Statement - Consolidated Statements of Earnings: Page 1 on Q1 & Q2 reports. Consolidated Balance Sheets: Page 2 on Q1 & Q2 reports. Look up the following income statement information: Total Quarter Total Revenues (7/29/2022) Total Quarter Revenues (4/29/2022) Quarter Gross Profit (7/29/2022) *Gross Profit Net Sales-Cost of Sales Look up the following Quarterly balance sheet information for Lowe's Companies Inc 7/29/2022: Total Assets Total Liabilities Current Assets Current Liabilities I Now use these 7 values (above) to calculate the following ratios for Lowe's Companies Inc in order to compare them to Home Depot Inc. (Use the same calculation methods as for Home Depot Inc) Revenue Growth Gross Profit % (as of 7/29/2022) Debt Ratio Current Ratio Based on a comparison of these two ratios between Home Depot and Lowe's which company seems to have better liquidity, which has better margin, which has better solvency, and which has better revenue growth? Enter the Company names below. Revenue Growth? Gross Profit? Solvency? (Debt Ratio, low is good) Liquidity? (Current Ratio, high is good) HORIZONTAL ANALYSIS Horizontal analysis is also known as trend analysis. By looking at recent trends, and also taking into disclosures and press releases from the company and outside the company, the financial markets often try to predict the future stock prices. In the next few steps, do a simple 3-year trend analysis. Go to Home Depot Inc and Lowe's Companies Inc 10-K for 2021 and open Consolidated Income Statements. (Click the link below and download the 2021 10-K) Home Depot Inc 10-K: (For the fiscal year ended January 30, 2022) https://www.sec.gov/ix?doc=/Archives/edgar/data/354950/000035495022000070/hd- 20220130.htm From the Table of Contents, select Item 8: Financial Statements and Supplementary Data. Then, click Consolidated Statements of Earnings (page 38). Lowe's Companies Inc 10-K: (For the fiscal year ended January 28, 2022) https://www.sec.gov/ix?doc=/Archives/edgar/data/60667/000006066722000038/low- 20220128.htm From the Table of Contents, select Item 8: Financial Statements and Supplementary Data. Then, click Consolidated Statements of Earnings (page 38). *Fiscal 2021 is the same as Fiscal year ended January 30, 2022. Home Depot's statement uses "Fiscal 2021", and Lowe's statement uses "Fiscal year ended January 2022"; these mean the same thing. Write down the Total Revenues Year Ended (Fiscal year) Fiscal 2021 Home Depot Inc Lowe's Companies Inc Fiscal 2020 Fiscal 2019 Write down the Operating Income. Year Ended (Fiscal year) Fiscal 2021 Fiscal 2020 Fiscal 2019 Home Depot Inc Lowe's Companies Inc Write down the Consolidated Net Income Year Ended (Fiscal year) Home Depot Inc Lowe's Companies Inc Fiscal 2021 Fiscal 2020 Fiscal 2019 Open an Excel Spreadsheet. Type the Revenues for Home Depot Inc and Lowe's Companies Inc in two separate columns. Title them as Home Depot Inc Revenues and Lowe's Companies Inc revenues respectively. Make a simple line chart for each. Title the line charts as Home Depot Inc and Lowe's Companies Inc revenues respectively. Next, type the Operating Income for Home Depot Inc and Lowe's Companies Inc in two separate columns. Title them as Home Depot Inc Operating Income and Lowe's Companies Inc Operating Income respectively. Make a simple line chart for each. Title the line charts as Home Depot Inc and Lowe's Companies Inc Operating Income respectively. Next, type the Net Income for Home Depot Inc and Lowe's Companies Inc in two separate columns. Title them as Home Depot Inc Net Income and Lowe's Companies Inc Net Income respectively. Make a simple line chart for each. Title them as Home Depot Inc and Lowe's Companies Inc Net Income respectively. Once all six-line charts are ready, write down a brief analysis on Home Depot Inc's revenue, operating income and net income trends. Next, write down a brief analysis on Lowe's Companies Inc's revenue, operating income and net income trends. Contrast the two. There is no one correct answer. We will be checking for plagiarism. Is there any indication that the current disruptions to global supply chain had an impact on the bottom-line of Home Depot or Lowe's? Substantiate your answer. Research this by using recent news discussion on the internet. Fill in your brief response in the worksheet, keep it ready and then type it in the blackboard assessment when you take it. Your answers will be checked for plagiarism