Question

we will focus our attention on the Vertical Analysis of the Balance Sheet for the year ended 2018

Go to Morningstar.com . At the top of the page, in the middle where you see the magnifying glass where it reads Stock, Fund, ETF Quotes, Reports, Articles, Videos, start to enter "Home D" in the box. As you start to type the company name a list of potential selections will pop up. Keep typing until you see " HD Home Depot XNYS" and then click on it (it should be highlighted in blue). Be careful, if you enter the entire name and hit enter, you will get an error. Once you select the company name or symbol (HD for Home Depot), scroll down until you locate a tab called Financials", then click on "All Financials Data button, and select at the top the statement that you would like to view Finally, click on the "$" button to view the financials as normally presented in dollars. Then, you can use the data provided to answer the following questions Finally, click on the "%" button to view the financials using vertical analysis Then, you can use the data provided to answer the following questions. For a video explanation, please view https:/www youtube.com/watch?v 75fd08SS8sM Then, answer the following questions related to Home Depot. Once you have entered the information for the Home Depot, you'll have to repeat the above steps to answer the questions for Lowe's Companies as well. The stock symbol is LOW. Remember to enter LOW in the Quotes area or just start typing LOWE, don't enter the entire name and hit enter or you will get an error. There is also a button just above the Performance tab that you can use to print the page if you prefer. Another option is to print off this assignment and complete it on paper before returning to enter your answers Let's begin by viewing the Balance Sheet of the Home Depot. Remember, under vertical analysis, Total Assets will be et equal to 100% and then every component of the Balance Sheet will be shown as a percentage of Total Assets. Then locate the same information for Lowe's. Please complete the following chart (when answering the problems, please omit the % sign and enter 2 decimal places) We will focus our atfention on the Vertical Analssise of the Balance Sheet for the year ended January 2018 e We will focus our attention on the Vertical Analysis of the Balance Sheet for the year ended Balance Sheet Vertical Analysis Home Depot Lowes Total Cash Total Inventories Total Current Assets Property, Plant & Equipment Total Current Liabilities Total Non-curent Liabilties Total Stockholder's Equity

Answer 1

Please give positive ratings so I can keep answering. Thanks!

USD Million	Home Depot	Home Depot	Lowes	Lowes
Total Assets	44,529.00	100.00%	35,291.00	100.00%
Total Cash	3,595.00	8.07%	690.00	1.96%
Total Inventories	12,748.00	28.63%	11,393.00	32.28%
Total Current Assets	18,933.00	42.52%	12,772.00	36.19%
Property, Plant & Equipment	22,075.00	49.57%	19,721.00	55.88%
Total Current Liabilities	16,194.00	36.37%	12,096.00	34.28%
Total Non Current Liabilities	26,881.00	60.37%	17,322.00	49.08%
Total Stock holders equity	1,454.00	3.27%	5,873.00	16.64%