The fiscal year end stock prices for 2007 through fiscal year


Question Description:

25

The fiscal year end stock prices for 2007 through fiscal year 2012 for both Lowe’s and Home Depot have been provided in the excel workbook in the Dropbox material. These prices were used in calculating the market test ratios (price/earnings and dividend yield) for both companies; using these prices answer the following questions. What has been happening to the market price of Lowe’s stock in the five years from 2005 through 2009 compared to Home Depot’s stock prices in terms of general overall trend? Which stock has performed better in the market and why? ATTACHMENT PREVIEW Download attachment Lowe’s Companies Data Sheets Summer 2013.xls Lowe’s Companies, Inc. Consolidated Balance Sheets (In millions) The year 2012 is fiscal year ended February 1, 2013 so be careful when reading the annual report to use 2012 as the most recent year. 2012 2011 2010 2009 2008 Assets Current assets Cash and cash equivalents Short-term investments Merchandise Inventory – net Deferred income taxes – net Other current assets Total current assets Property, less accumulated depreciation Long-term investments Other assets Total assets 2007 $541 125 8,600 217 301 9,784 $1,014 286 8,355 183 234 10,072 $652 471 8,321 193 330 9,967 $632 425 8,249 208 218 9,732 $245 416 8,209 105 215 9,190 $281 249 7,611 247 298 8,686 21,477 271 1,134 $32,666 21,970 504 1,013 $33,559 22,089 1,008 635 $33,699 22,499 277 497 $33,005 22,722 253 460 $32,625 21,361 509 313 $30,869 $47 4,657 670 824 1,510 7,708 $592 4,352 613 801 1,533 7,891 $36 4,351 667 707 1,358 7,119 $552 4,287 577 683 1,256 7,355 $987 34 4,109 434 674 1,322 7,560 $1,064 40 3,713 424 671 717 1,122 7,751 9,030 455 715 901 18,809 7,035 531 704 865 17,026 6,537 467 631 833 15,587 4,528 598 549 906 13,936 5,039 599 1,372 14,570 5,576 670 774 14,771 555 26 13,224 52 13,857 $32,666 621 14 15,852 46 16,533 $33,559 677 11 17,371 53 18,112 $33,699 729 735 6 277 18,307 17,049 27 (6) 19,069 18,055 $33,005 $32,625 729 16 15,345 8 16,098 $30,869 1,110 1,241 1,354 Liabilities and shareholders’ equity Current liabilities Short-term borrowings Current maturities of long-term debt Accounts payable Accrued compensation and employee benefits Self-insurance liabilities Deferred revenue Other current liabilities Total current liabilities Long-term debt Deferred income taxes – net Deferred revenue-extended protection plans Other long-term liabiliities Total liabilities Shareholders’ equity Preferred stock – $5 par value, none issued Common stock – $.50 par value Capital in excess of par value Retained earnings Accumulated other comprehensive income Total shareholders’ equity Total liabilities and shareholders’ equity Shares issued and outstanding FYE 1,459 1,470 1,458 Lowe’s Companies, Inc. Vertical Consolidated Balance Sheets (In millions) The year 2012 is fiscal year ended February 1, 2013 so be careful when reading the annual report to use 2012 as the most recent year. 2012 Percentage 2011 Percentage 2010 Percentage Assets Current assets Cash and cash equivalents Short-term investments Merchandise Inventory – net Deferred income taxes – net Other current assets Total current assets Property, less accumulated depreciation Long-term investments Other assets Total assets 2009 $541 125 8,600 217 301 9,784 1.7% 0.4% 26.3% 0.7% 0.9% 30.0% $1,014 286 8,355 183 234 10,072 3.0% 0.9% 24.9% 0.5% 0.7% 30.0% $652 471 8,321 193 330 9,967 1.9% 1.4% 24.7% 0.6% 1.0% 29.6% $632 425 8,249 208 218 9,732 21,477 271 1,134 $32,666 65.7% 0.8% 3.5% 100.0% 21,970 504 1,013 $33,559 65.5% 1.5% 3.0% 100.0% 22,089 1,008 635 $33,699 65.5% 3.0% 1.9% 100.0% $47 4,657 670 824 1,510 7,708 $592 4,352 613 801 1,533 7,891 0.0% 1.8% 13.0% 1.8% 0.0% 2.4% 4.6% 23.5% $36 4,351 667 707 1,358 7,119 9,030 455 715 901 18,809 0.0% 0.1% 14.3% 2.1% 0.0% 2.5% 4.6% 23.6% 0.0% 27.6% 1.4% 2.2% 2.8% 57.6% 7,035 531 704 865 17,026 21.0% 1.6% 2.1% 2.6% 50.7% 555 26 13,224 52 13,857 $32,666 0.0% 1.7% 0.1% 40.5% 0.2% 42.4% 100.0% 621 14 15,852 46 16,533 $33,559 0.0% 1….

Answer

25