below is an example of what i need it to look like

below are the instructions and qhat can be left out of the ratio analysis excel

1. Find the 2019 annual balance sheets and income statements for Home Depot and Lowe's (which were published on Feb-2020). For your convenience, all related financial statements are posted. 2. Construct the ratio table such as fx Home Depot Inc. 10.- Home Depot Inc. A B C D E 2 3 Consolidated Balance Sheet: Assets 4 US$ in millions 6 31-Jan-20 31-Jan-19 in 00 7 $ 9 10 1,778 1,936 13,925 890 18,529 22,375 11 12 2,133 $ 2,106 14,531 1,040 19,810 22,770 5,595 2,254 807 31,426 51,236 $ 13 14 15 16 2,252 847 25,474 44,003 17 18 $ 19 20 $ 21 22 23 24 Assets: Cash and cash equivalents Receivables, net Merchandise inventories Other current assets Total current assets Net property and equipment Operating lease right-of-use assets Goodwill Other assets Total fixed assets Total assets Liabilities: Payables and accrued expenses Current debt and capital obligations Current deferred liabilities Current liablities Other current liabilities Total current liabilities Long term debt and capital obligations Non current deferred liabilities Other non current liabilities Total non current liabilties Total liabilities Stockholder's Equity: Capital stock Additional paid in capital Retained earnings Treasury stock Gains losses not affecting Total stockholder's equity 25 12,618 $ 3,641 2,116 18,375 5,453 23,828 33,736 706 1,535 35,977 54,352 $ 12,539 2,395 1,782 16,716 5,060 21,776 26,807 491 1,867 29,165 45,881 26 27 28 29 30 $ 31 32 $ 89 33 34 89 $ 11,001 51,729 (65,196) (739) (3,116) $ 35 10,578 46,423 (58,196) (772) (1,878) 36 37 $ 38 39 40 41 A fx Lowe's Cos. Inc. A B C O Lowe's Cos. Inc. Qlowe's Cos. Inc. 1 2 3 Consolidated Balance Sheet: Assets 4 5 US$ in millions 6 31-Jan-20 31-Jan-19 7 8 $ 716 $ 9 160 13,179 511 218 12,561 10 11 12 13 14 938 14,228 18,432 15 16 17 256 1,263 15,318 18,669 3,891 372 216 303 702 24,153 $ 39,471 18 294 303 19 20 995 21 22 20,280 $ 34,508 23 24 Assets: Cash and cash equivalents Short-term investments Merchandise inventory, net Accounts receivable Deferred income taxes, net Other current assets Current assets Property, less accumulated depreciation Operating lease right-of-use assets Long-term investments Deferred income taxes, net Goodwill Other assets Noncurrent assets Total assets Liabilities: Payables and accrued expenses Current provisions Pension and other Current debt and captial Current deferred liabilities Other current liabilities Total current liabilities Long-term debt and capital Non current deferred liabilities Other non current liabilities Total long-term liabilities Total liabilities Stockholder's Equity: Capital stock Additional paid in capital Retained earnings Gains losses not affecting Total stockholder's equity $ $ 9,135 194 25 26 662 27 28 8,557 194 684 3,039 1,219 1,489 15,182 20,711 894 29 30 31 32 1,832 1,299 1,375 14,497 14,391 827 1,149 16,367 $ 30,864 33 712 34 22,317 $ 37,499 35 36 37 $ 381 $ 401 38 39 40 1,727 (136) 1,972 3,452 (209) 3,644 41 $ $ 42 43 44 45 A B C D E F G 1 Home Depot Inc. Consolidated Income Statement 2 3 4 US$ in millions 5 12 months anded 6 7 Fah2.2020 110,225 (72,653) 37,572 (19,740) (1,989) an 29_2012 100,904 (66,548) 34,356 (17,864) (1,811) Jan 292017 94,595 (62,282) 32,313 (17,132) (1,754) Jan 21_2016 88,519 (58,254) 30,265 (16,801) (1,690) Feb 1 2015 83,176 (54,222) 28,954 (16,834) (1,651) 8 9 10 11 12 Net sales Cost of sales Gross profit Selling, general and administrative Depreciation and amortization Impairment loss Operating expenses Operating income Interest and investment income Interest expense Other Interest and other, net Earnings before provision for income taxes Provision for income taxes Net earnings Seb2_2019 108,203 (71,043) 37,160 (19,513) (1,870) (247) (21,630) 15,530 93 (1,051) (16) (974) 14,556 (3,435) 11,121 (18,485) 10,469 13 (21,729) 15,843 73 (1,201) (19,675) 14,681 74 (1,057) (18,886) 13,427 36 (972) (18,491) 11,774 166 (919) 14 337 15 (830) 16 17 18 (1,128) 14,715 (3,473) 11,242 (983) 13,698 (5,068) 8,630 (936) 12,491 (4,534) 7,957 (753) 11,021 (4,012) 7,009 (493) 9,976 (3,631) 6,345 19 20 A B D E F G 1 Lowe's Cos. Inc. Consolidated Income Statement 2 US$ in millions 12 months andad. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Jan 21 2020 72,148 (49,205) 22,943 (15,367) (1,262) (16,629) 6,314 (718) 27 (691) Sab 2. 2018 68,619 (45,210) 23,409 (15,376) (1,447) (16,823) 6,586 Net sales Cost of sales Gross margin Selling, general and administrative Depreciation and amortization Expenses Operating income Interest expense, net of amount capitalized Interest income Interest, net Loss on extinguishment of debt Pre-tax earnings Income tax provision Net earnings Sab 1 2019 71,309 (48,401) 22,908 (17,413) (1,477) (18,890) 4,018 (652) 28 (624) Fah2_2017 65,017 (42,553) 22,464 (15,129) (1,489) (16,618) 5,846 (657) 12 (645) lan 29 2016 59,074 (38,504) 20,570 (14,105) (1,494) (15,599) 4,971 (556) 4 (552) lan 20 2015 56,223 (36,665) 19,558 (13,272) (1,494) (14,766) 4,792 (522) 6 (516) (649) 16 (633) (464) 5,489 (2,042) 3,447 17 18 5,623 (1,342) 4,281 3,394 (1,080) 2,314 5,201 (2,108) 3,093 4,419 (1,873) 2,546 4,276 (1,578) 2,698 19 fx A B D E 1 Dow Chemical Exxon Mobil 2 3 4 Profitability Ratios Return on assets (ROA) Return on capital (ROC) Return on equity (ROE) Operating profit margin 0.75% 1.12% 5.65% 9.09% 10.50% 8.31% 5 1.46% 2.34% 6 7 8 9 0.72 0.82 10 11 Efficiency Ratios Asset Turnover Fixed-asset turnover Receivables turnover Average collection period (days) Inventory turnover Days in inventory 0.78 1.12 6.96 98.68 6.85 53.31 11.09 39.4 12 13 14 10.77 33.9 15 16 17 18 Leverage Ratios Long-term debt ratio Long-term debt-equity ratio Total debt ratio Times interest earned 23.05% 29.96% 47.79% 2.10 13.46% 15.55% 46.17% 32.07 19 20 21 22 23 Liquidity Ratios Net working capital to assets Current ratio Quick ratio Cash ratio -0.03 0.82 24 0.12 1.91 1.26 0.51 25 0.52 0.05 26 27 28 Description Four financial statements for two companies. Home-Depot-BA-1.xlsx HomeDepot-Income-Statement.xlsx Loew's-Income-Statement.xlsx Lowes-BA.xlsx . *** **** Use only the 2019 information (which available on February, 2020). You don need the 2018 information even wher need the average. Just use the 2019 numbers. If you can't find any specific accounts, consider it as zero or N.A. (not availab Thef 2. Construct the ratio table such as Table 4-7 on p.106. (You may exclude the following ratios; Market value added, Market to book ratio, EVA, Payout ratio, and Sustainable growth.) 1. Find the 2019 annual balance sheets and income statements for Home Depot and Lowe's (which were published on Feb-2020). For your convenience, all related financial statements are posted. 2. Construct the ratio table such as fx Home Depot Inc. 10.- Home Depot Inc. A B C D E 2 3 Consolidated Balance Sheet: Assets 4 US$ in millions 6 31-Jan-20 31-Jan-19 in 00 7 $ 9 10 1,778 1,936 13,925 890 18,529 22,375 11 12 2,133 $ 2,106 14,531 1,040 19,810 22,770 5,595 2,254 807 31,426 51,236 $ 13 14 15 16 2,252 847 25,474 44,003 17 18 $ 19 20 $ 21 22 23 24 Assets: Cash and cash equivalents Receivables, net Merchandise inventories Other current assets Total current assets Net property and equipment Operating lease right-of-use assets Goodwill Other assets Total fixed assets Total assets Liabilities: Payables and accrued expenses Current debt and capital obligations Current deferred liabilities Current liablities Other current liabilities Total current liabilities Long term debt and capital obligations Non current deferred liabilities Other non current liabilities Total non current liabilties Total liabilities Stockholder's Equity: Capital stock Additional paid in capital Retained earnings Treasury stock Gains losses not affecting Total stockholder's equity 25 12,618 $ 3,641 2,116 18,375 5,453 23,828 33,736 706 1,535 35,977 54,352 $ 12,539 2,395 1,782 16,716 5,060 21,776 26,807 491 1,867 29,165 45,881 26 27 28 29 30 $ 31 32 $ 89 33 34 89 $ 11,001 51,729 (65,196) (739) (3,116) $ 35 10,578 46,423 (58,196) (772) (1,878) 36 37 $ 38 39 40 41 A fx Lowe's Cos. Inc. A B C O Lowe's Cos. Inc. Qlowe's Cos. Inc. 1 2 3 Consolidated Balance Sheet: Assets 4 5 US$ in millions 6 31-Jan-20 31-Jan-19 7 8 $ 716 $ 9 160 13,179 511 218 12,561 10 11 12 13 14 938 14,228 18,432 15 16 17 256 1,263 15,318 18,669 3,891 372 216 303 702 24,153 $ 39,471 18 294 303 19 20 995 21 22 20,280 $ 34,508 23 24 Assets: Cash and cash equivalents Short-term investments Merchandise inventory, net Accounts receivable Deferred income taxes, net Other current assets Current assets Property, less accumulated depreciation Operating lease right-of-use assets Long-term investments Deferred income taxes, net Goodwill Other assets Noncurrent assets Total assets Liabilities: Payables and accrued expenses Current provisions Pension and other Current debt and captial Current deferred liabilities Other current liabilities Total current liabilities Long-term debt and capital Non current deferred liabilities Other non current liabilities Total long-term liabilities Total liabilities Stockholder's Equity: Capital stock Additional paid in capital Retained earnings Gains losses not affecting Total stockholder's equity $ $ 9,135 194 25 26 662 27 28 8,557 194 684 3,039 1,219 1,489 15,182 20,711 894 29 30 31 32 1,832 1,299 1,375 14,497 14,391 827 1,149 16,367 $ 30,864 33 712 34 22,317 $ 37,499 35 36 37 $ 381 $ 401 38 39 40 1,727 (136) 1,972 3,452 (209) 3,644 41 $ $ 42 43 44 45 A B C D E F G 1 Home Depot Inc. Consolidated Income Statement 2 3 4 US$ in millions 5 12 months anded 6 7 Fah2.2020 110,225 (72,653) 37,572 (19,740) (1,989) an 29_2012 100,904 (66,548) 34,356 (17,864) (1,811) Jan 292017 94,595 (62,282) 32,313 (17,132) (1,754) Jan 21_2016 88,519 (58,254) 30,265 (16,801) (1,690) Feb 1 2015 83,176 (54,222) 28,954 (16,834) (1,651) 8 9 10 11 12 Net sales Cost of sales Gross profit Selling, general and administrative Depreciation and amortization Impairment loss Operating expenses Operating income Interest and investment income Interest expense Other Interest and other, net Earnings before provision for income taxes Provision for income taxes Net earnings Seb2_2019 108,203 (71,043) 37,160 (19,513) (1,870) (247) (21,630) 15,530 93 (1,051) (16) (974) 14,556 (3,435) 11,121 (18,485) 10,469 13 (21,729) 15,843 73 (1,201) (19,675) 14,681 74 (1,057) (18,886) 13,427 36 (972) (18,491) 11,774 166 (919) 14 337 15 (830) 16 17 18 (1,128) 14,715 (3,473) 11,242 (983) 13,698 (5,068) 8,630 (936) 12,491 (4,534) 7,957 (753) 11,021 (4,012) 7,009 (493) 9,976 (3,631) 6,345 19 20 A B D E F G 1 Lowe's Cos. Inc. Consolidated Income Statement 2 US$ in millions 12 months andad. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Jan 21 2020 72,148 (49,205) 22,943 (15,367) (1,262) (16,629) 6,314 (718) 27 (691) Sab 2. 2018 68,619 (45,210) 23,409 (15,376) (1,447) (16,823) 6,586 Net sales Cost of sales Gross margin Selling, general and administrative Depreciation and amortization Expenses Operating income Interest expense, net of amount capitalized Interest income Interest, net Loss on extinguishment of debt Pre-tax earnings Income tax provision Net earnings Sab 1 2019 71,309 (48,401) 22,908 (17,413) (1,477) (18,890) 4,018 (652) 28 (624) Fah2_2017 65,017 (42,553) 22,464 (15,129) (1,489) (16,618) 5,846 (657) 12 (645) lan 29 2016 59,074 (38,504) 20,570 (14,105) (1,494) (15,599) 4,971 (556) 4 (552) lan 20 2015 56,223 (36,665) 19,558 (13,272) (1,494) (14,766) 4,792 (522) 6 (516) (649) 16 (633) (464) 5,489 (2,042) 3,447 17 18 5,623 (1,342) 4,281 3,394 (1,080) 2,314 5,201 (2,108) 3,093 4,419 (1,873) 2,546 4,276 (1,578) 2,698 19 fx A B D E 1 Dow Chemical Exxon Mobil 2 3 4 Profitability Ratios Return on assets (ROA) Return on capital (ROC) Return on equity (ROE) Operating profit margin 0.75% 1.12% 5.65% 9.09% 10.50% 8.31% 5 1.46% 2.34% 6 7 8 9 0.72 0.82 10 11 Efficiency Ratios Asset Turnover Fixed-asset turnover Receivables turnover Average collection period (days) Inventory turnover Days in inventory 0.78 1.12 6.96 98.68 6.85 53.31 11.09 39.4 12 13 14 10.77 33.9 15 16 17 18 Leverage Ratios Long-term debt ratio Long-term debt-equity ratio Total debt ratio Times interest earned 23.05% 29.96% 47.79% 2.10 13.46% 15.55% 46.17% 32.07 19 20 21 22 23 Liquidity Ratios Net working capital to assets Current ratio Quick ratio Cash ratio -0.03 0.82 24 0.12 1.91 1.26 0.51 25 0.52 0.05 26 27 28 Description Four financial statements for two companies. Home-Depot-BA-1.xlsx HomeDepot-Income-Statement.xlsx Loew's-Income-Statement.xlsx Lowes-BA.xlsx . *** **** Use only the 2019 information (which available on February, 2020). You don need the 2018 information even wher need the average. Just use the 2019 numbers. If you can't find any specific accounts, consider it as zero or N.A. (not availab Thef 2. Construct the ratio table such as Table 4-7 on p.106. (You may exclude the following ratios; Market value added, Market to book ratio, EVA, Payout ratio, and Sustainable growth.)