Question
For your project, you will prepare a Horizontal and a Vertical Analysis of both The Home Depot's and Lowe's Balance Sheet and Statement of Earnings
For your project, you will prepare a Horizontal and a Vertical Analysis of both The Home Depot's and Lowe's Balance Sheet and Statement of Earnings (Income Statement) in a condensed format. If you prefer, you don't have to do a condensed format but you can list every item on the Balance Sheet and Income Statements for Lowe's and Home Depot and prepare your analysis that way. Your choice to do a condensed or a long format. . Also, you will do the ratios from page 816 except for the following: Do not do - Working Capital, Number of Times Interest Charges are Earned, Number of Times Preferred Dividends are Earned, Rate Earned on Common Stockholders Equity, Dividends per Share and Dividend Yield. For the Earnings per Share (EPS) on Common Stock, use the Basic EPS right from the company's Statement of Earnings (Income Statement). For the Price-Earnings (P/E) Ratio you will have to look up the ending stock price on the date of the company's financial statements. You can easily get the stock price for a particular day from Yahoo Finance. You will do these ratios for both the 2015 and 2014 fiscal year end numbers from the 2014 annual reports for The Home Depot and Lowe's. You should be using the #s from the consolidated Balance Sheet for Home Depot found on page 32 of the annual report for 2014 and the #s from the Consolidated Statement of Earnings found on page 33 of the Home Depot's 2014 annual report. The columns you need to analyze for the Home Depot are the 02/01/15 and 02/02/14 ones. For Lowe's you will use the #s from the consolidated Balance Sheet found on page 35 of the 2014 annual report and the #s from the consolidated Statement of Earnings from page 34 of the 2014 annual report. The columns of numbers you will use for Lowe's will be the 01/30/2015 and 01/31/2014 ones. If either company does not have a particular category on a financial statement then put a dash (-) to indicate there are no numbers to analyze in that category. NOTE: For the ratios that require averages, you will need to obtain the previous years Balance Sheet to use the particular number needed for the average. You can do an online search for the balance sheet from the 2013 annual reports for both companies.
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