(3) Prepare ratio analyses (for 2019, 2018, and 2017) for both companies. You should include the following ratios in your computations:

Solvency

o Debt-to-equity

o Times interest earned

o Return on Financial leverage

Liquidity

o Current Ratio

o Quick Ratio

o Operating cash flow to current liabilities

o Working capital

Comment on the analytical results of the two companies based on your work in excel. In addition to contrasting the ratios between the companies, you should interpret the numbers and make suggestions as to why the ratio of one company might be higher/lower than the other

Kroger Balance Sheet

Kroger Income Statement

Walmart Balance Sheet

Walmart Income Statement

NOTE: 2016 BALANCE SHEET INFORMATION SHOULD BE USED ONLY FOR RATIOS As Reported Annual Balance Sheet Report Date 2019 2018 2017 Scale Thousands Thousands Thousands Cash & temporary cash investments 399,000 429,000 347,000 Store deposits in-transit 1,179,000 1,181,000 1,161,000 Receivables 1,706,000 1,589,000 1,637,000 Inventory 7,084,000 6,846,000 6,533,000 Assets held for sale 0 166,000 604,000 Prepaid & other current assets 522,000 592,000 835,000 Total current assets 10,890,000 10,803,000 11,117,000 Property, plant & equipment, net 21,871,000 21,635,000 21,071,000 Operating lease assets 6,814,000 0 0 Intangibles, net 1,066,000 1,258,000 1,100,000 Goodwill 3,076,000 3,087,000 2,925,000 Other assets 1,539,000 1,335,000 984,000 Total assets 45,256,000 38,118,000 37,197,000 2016 Thousands 322,000 910,000 1,649,000 6,561,000 0.00 898,000 10,340,000 21,016,000 0 1,153,000 3,031,000 965,000 36,505,000 Liabilities Current portion of long-term debt including obligations under fin Current portion of long-term debt including obligations under ca Current portion of operating lease liabilities Trade accounts payable Accrued salaries & wages Deferred income taxes Liabilities held for sale Other current liabilities Total current liabilities Noncurrent operating lease liabilities Long-term debt including obligations under finance leases Long-term debt including obligations under capital leases & fina Deferred income taxes Pension & postretirement benefit obligations Other long-term liabilities Total liabilities 1,965,000 0 597,000 6,349,000 1,168,000 0 0 4,164,000 14,243,000 6,505,000 12,111,000 0 1,466,000 608,000 1,750,000 36,683,000 0 3,157,000 0 6,059,000 1,227,000 0 51,000 3,780,000 14,274,000 0 0 12,072,000 1,562,000 494,000 1,881,000 30,283,000 0 3,560,000 0 5,858,000 1,099,000 0 259,000 3,421,000 14,197,000 0 0 12,029,000 1,568,000 792,000 1,706,000 30,292,000 0 2,252,000 0 5,818,000 1,234,000 251,000 0 3,305,000 12,860,000 0 0 11,825,000 1,927,000 1,524,000 1,659,000 29,795,000 Common shares Additional paid-in capital Accumulated other comprehensive income (loss) Retained earnings (accumulated deficit) Common shares in treasury, at cost Noncontrolling interests Total equity (deficit) 1,918,000 3,337,000 (640,000) 20,978,000 16,991,000 (29,000) 8,573,000 1,918,000 3,245,000 (346,000) 19,681,000 16,612,000 (51,000) 7,835,000 1,918,000 3,161,000 (471,000) 17,007,000 14,684,000 (26,000) 6,905,000 1,918,000 3,070,000 (715,000) 15,543,000 13,118,000 12,000 6,710,000 Additional Information Net cash flows from operating activities 4,664,000 4,164,000 3,413,000 4,272,000 Land Buildings & land improvements Equipment Leasehold improvements Construction-in-progress Leased property under capital leases & financing obligations Total property, plant & equipment Accumulated depreciation & amortization Property, plant & equipment, net 3,299,000 12,553,000 15,031,000 10,832,000 3,166,000 966,000 45,847,000 23,976,000 21,871,000 3,254,000 12,245,000 14,277,000 10,306,000 2,716,000 1,066,000 43,864,000 22,229,000 21,635,000 3,201,000 12,072,000 13,635,000 9,773,000 2,050,000 1,000,000 41,731,000 20,660,000 21,071,000 3,197,000 11,643,000 13,495,000 9,342,000 1,979,000 932,000 40,588,000 19,572,000 21,016,000 As Reported Annual Income Statement Report Date Scale Sales Cost of sales Gross Profit Operating, general & administrative Rent Depreciation & amortization Operating profit (loss) Interest expense Non-service component of company-sponsored pension plan costs Mark to market gain (loss) on Ocado International Holdings Limited & Ocado Group plc securitie Gain on sale of businesses Net earnings before income tax expense (benefit) Income tax expense (benefit) Net earnings after income tax expense (benefit) Net earnings (loss) attributable to noncontrolling interests Net earnings (loss) attributable to The Kroger Co. 2019 Thousands 122,286,000 95,294,000 26,992,000 21,208,000 884,000 2,649,000 2,251,000 603.000 0 157,000 176,000 1,981,000 469,000 1,512,000 147,000 1,659,000 2018 Thousands 121, 162,000 94,894,000 26,268,000 20,305,000 884,000 2,465,000 2,614,000 620,000 26.000 228,000 1,782,000 3,978,000 900,000 3,078,000 32,000 3,110,000 2017 Thousands 122,662,000 95,662,000 27,000,000 21,568,000 911,000 2,436,000 2,085,000 601.000 0 0 0 1,484,000 (405,000) 1,889,000 18,000 1,907,000 Additional Information Weighted average shares outstanding - basic Weighted average shares outstanding - diluted Year end shares outstanding 799,000 805,000 788,000 810,000 818,000 798,000 895,000 904,000 870,000 G H 2016 Thousands A B E F NOTE: 2016 BALANCE SHEET INFORMATION SHOULD BE USED ONLY FOR RATIOS As Reported Annual Balance Sheet Report Date 2019 2018 2017 Scale Thousands Thousands Thousands Assets Cash & cash equivalents 9,465,000 7,722,000 6,756,000 Receivables, net 6,284,000 6,283,000 5,614,000 Inventories 44,435,000 44,269,000 43,783,000 Prepaid expenses & other current assets 1,622,000 3,623,000 3,511,000 Total current assets 61,806,000 61,897,000 59,664,000 Property & equipment, net 105,208,000 104,317,000 107,675,000 Operating lease right-of-use assets 17,424,000 0 0 Finance lease right-of-use assets, net 4,417,000 0 Property under capital lease & financing obligations, 0 7,078,000 7,143,000 Goodwill 31,073,000 31,181,000 18,242,000 Other long-term assets 16,567,000 14,822,000 11,798,000 Total assets 236,495,000 219,295,000 204,522,000 6,867,000 5,835,000 43,046,000 1,941,000 57,689,000 107,710,000 0 0 6,468,000 17,037,000 9,921,000 198,825,000 Liabilities & Equity Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Operating lease obligations due within one year Finance lease obligations due within one year Capital lease & financing obligations due within one y Total current liabilities Long-term debt Long-term operating lease obligations Long-term finance lease obligations Long-term capital lease & financing obligations Deferred income taxes & other liabilities Total Liabilities 575,000 46,973,000 22,296,000 280,000 5,362,000 1,793,000 511,000 0 77,790,000 43,714,000 16,171,000 4,307,000 0 12,961,000 154,943,000 5,225,000 47,060,000 22,159,000 428,000 1,876,000 0 0 729,000 77,477,000 43,520,000 0 0 6,683,000 11,981,000 139,661,000 5,257,000 46,092,000 22,122,000 645,000 3,738,000 0 0 667,000 78,521,000 30,045,000 0 0 6,780,000 8,354,000 123,700,000 1,099,000 41,433,000 20,654,000 921,000 2,256,000 0 0 565,000 66,928,000 36,015,000 0 0 6,003,000 9,344,000 118,290,000 Common stock Capital in excess of par value Retained earnings (accumulated deficit) Accumulated other comprehensive income (loss) Noncontrolling interest Total equity 284,000 3,247,000 83,943,000 (12,805,000) 6,883,000 81,552,000 288,000 2,965,000 80,785,000 (11,542,000) 7,138,000 79,634,000 295,000 2,648,000 85,107,000 (10,181,000) 2,953,000 80,822,000 305,000 2,371,000 89,354,000 (14,232,000) 2,737,000 80,535,000 Additional Information Net cash flows from operating activities 25,255,000 27,753,000 28,337,000 31,530,000 Land Buildings & improvements Fixtures & equipment Transportation equipment Construction in progress Property & equipment, gross Less: accumulated depreciation Property & equipment, net 24,619,000 105,674,000 58,607,000 2,377,000 3,751,000 195,028,000 89,820,000 105,208,000 24,526,000 101,006,000 54,488,000 2,316,000 3,474,000 185,810,000 81,493,000 104,317,000 25,298,000 101,155,000 52,695,000 2,387,000 3,619,000 185,154,000 77,479,000 107,675,000 24,801,000 98,547,000 48,998,000 2,845,000 4,301,000 179,492,000 71,782,000 107,710,000 As Reported Annual Income Statement Report Date Scale Net sales Membership & other income Total revenues Cost of sales Gross Profit Operating, selling, general & administrative expenses Operating income (loss) Interest expense on debt Interest expense on finance, capital lease & financing obligatior Interest income Gain (loss) on extinguishment of debt Other gains & (losses) Income (loss) before income taxes Provision (benefit) for income taxes Income (loss) after income taxes Less consolidated net income attributable to noncontrolling inter Net Income 2019 Thousands 519,926,000 4,038,000 523,964,000 394,605,000 129,359,000 108,791,000 20,568,000 2,262,000 337,000 189,000 0 1,958,000 20,116,000 4,915,000 15,201,000 (320,000) 14,881,000 2018 Thousands 510,329,000 4,076,000 514,405,000 385,301,000 129,104,000 107,147,000 21,957,000 1,975,000 371,000 217,000 0 (8,368,000) 11,460,000 4,281,000 7,179,000 (509,000) 6,670,000 2017 Thousands 495,761,000 4,582,000 500,343,000 373,396,000 126,947,000 106,510,000 20,437,000 1,978,000 352,000 152,000 (3,136,000) 0 15,123,000 4,600,000 10,523,000 (661,000) 9,862,000 Additional Information Weighted average shares outstanding - basic Weighted average shares outstanding - diluted Year end shares outstanding 2,850,000 2,868,000 2,832,000 2,929,000 2,945,000 2,878,000 2,995,000 3,010,000 2,952,000 NOTE: 2016 BALANCE SHEET INFORMATION SHOULD BE USED ONLY FOR RATIOS As Reported Annual Balance Sheet Report Date 2019 2018 2017 Scale Thousands Thousands Thousands Cash & temporary cash investments 399,000 429,000 347,000 Store deposits in-transit 1,179,000 1,181,000 1,161,000 Receivables 1,706,000 1,589,000 1,637,000 Inventory 7,084,000 6,846,000 6,533,000 Assets held for sale 0 166,000 604,000 Prepaid & other current assets 522,000 592,000 835,000 Total current assets 10,890,000 10,803,000 11,117,000 Property, plant & equipment, net 21,871,000 21,635,000 21,071,000 Operating lease assets 6,814,000 0 0 Intangibles, net 1,066,000 1,258,000 1,100,000 Goodwill 3,076,000 3,087,000 2,925,000 Other assets 1,539,000 1,335,000 984,000 Total assets 45,256,000 38,118,000 37,197,000 2016 Thousands 322,000 910,000 1,649,000 6,561,000 0.00 898,000 10,340,000 21,016,000 0 1,153,000 3,031,000 965,000 36,505,000 Liabilities Current portion of long-term debt including obligations under fin Current portion of long-term debt including obligations under ca Current portion of operating lease liabilities Trade accounts payable Accrued salaries & wages Deferred income taxes Liabilities held for sale Other current liabilities Total current liabilities Noncurrent operating lease liabilities Long-term debt including obligations under finance leases Long-term debt including obligations under capital leases & fina Deferred income taxes Pension & postretirement benefit obligations Other long-term liabilities Total liabilities 1,965,000 0 597,000 6,349,000 1,168,000 0 0 4,164,000 14,243,000 6,505,000 12,111,000 0 1,466,000 608,000 1,750,000 36,683,000 0 3,157,000 0 6,059,000 1,227,000 0 51,000 3,780,000 14,274,000 0 0 12,072,000 1,562,000 494,000 1,881,000 30,283,000 0 3,560,000 0 5,858,000 1,099,000 0 259,000 3,421,000 14,197,000 0 0 12,029,000 1,568,000 792,000 1,706,000 30,292,000 0 2,252,000 0 5,818,000 1,234,000 251,000 0 3,305,000 12,860,000 0 0 11,825,000 1,927,000 1,524,000 1,659,000 29,795,000 Common shares Additional paid-in capital Accumulated other comprehensive income (loss) Retained earnings (accumulated deficit) Common shares in treasury, at cost Noncontrolling interests Total equity (deficit) 1,918,000 3,337,000 (640,000) 20,978,000 16,991,000 (29,000) 8,573,000 1,918,000 3,245,000 (346,000) 19,681,000 16,612,000 (51,000) 7,835,000 1,918,000 3,161,000 (471,000) 17,007,000 14,684,000 (26,000) 6,905,000 1,918,000 3,070,000 (715,000) 15,543,000 13,118,000 12,000 6,710,000 Additional Information Net cash flows from operating activities 4,664,000 4,164,000 3,413,000 4,272,000 Land Buildings & land improvements Equipment Leasehold improvements Construction-in-progress Leased property under capital leases & financing obligations Total property, plant & equipment Accumulated depreciation & amortization Property, plant & equipment, net 3,299,000 12,553,000 15,031,000 10,832,000 3,166,000 966,000 45,847,000 23,976,000 21,871,000 3,254,000 12,245,000 14,277,000 10,306,000 2,716,000 1,066,000 43,864,000 22,229,000 21,635,000 3,201,000 12,072,000 13,635,000 9,773,000 2,050,000 1,000,000 41,731,000 20,660,000 21,071,000 3,197,000 11,643,000 13,495,000 9,342,000 1,979,000 932,000 40,588,000 19,572,000 21,016,000 As Reported Annual Income Statement Report Date Scale Sales Cost of sales Gross Profit Operating, general & administrative Rent Depreciation & amortization Operating profit (loss) Interest expense Non-service component of company-sponsored pension plan costs Mark to market gain (loss) on Ocado International Holdings Limited & Ocado Group plc securitie Gain on sale of businesses Net earnings before income tax expense (benefit) Income tax expense (benefit) Net earnings after income tax expense (benefit) Net earnings (loss) attributable to noncontrolling interests Net earnings (loss) attributable to The Kroger Co. 2019 Thousands 122,286,000 95,294,000 26,992,000 21,208,000 884,000 2,649,000 2,251,000 603.000 0 157,000 176,000 1,981,000 469,000 1,512,000 147,000 1,659,000 2018 Thousands 121, 162,000 94,894,000 26,268,000 20,305,000 884,000 2,465,000 2,614,000 620,000 26.000 228,000 1,782,000 3,978,000 900,000 3,078,000 32,000 3,110,000 2017 Thousands 122,662,000 95,662,000 27,000,000 21,568,000 911,000 2,436,000 2,085,000 601.000 0 0 0 1,484,000 (405,000) 1,889,000 18,000 1,907,000 Additional Information Weighted average shares outstanding - basic Weighted average shares outstanding - diluted Year end shares outstanding 799,000 805,000 788,000 810,000 818,000 798,000 895,000 904,000 870,000 G H 2016 Thousands A B E F NOTE: 2016 BALANCE SHEET INFORMATION SHOULD BE USED ONLY FOR RATIOS As Reported Annual Balance Sheet Report Date 2019 2018 2017 Scale Thousands Thousands Thousands Assets Cash & cash equivalents 9,465,000 7,722,000 6,756,000 Receivables, net 6,284,000 6,283,000 5,614,000 Inventories 44,435,000 44,269,000 43,783,000 Prepaid expenses & other current assets 1,622,000 3,623,000 3,511,000 Total current assets 61,806,000 61,897,000 59,664,000 Property & equipment, net 105,208,000 104,317,000 107,675,000 Operating lease right-of-use assets 17,424,000 0 0 Finance lease right-of-use assets, net 4,417,000 0 Property under capital lease & financing obligations, 0 7,078,000 7,143,000 Goodwill 31,073,000 31,181,000 18,242,000 Other long-term assets 16,567,000 14,822,000 11,798,000 Total assets 236,495,000 219,295,000 204,522,000 6,867,000 5,835,000 43,046,000 1,941,000 57,689,000 107,710,000 0 0 6,468,000 17,037,000 9,921,000 198,825,000 Liabilities & Equity Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Operating lease obligations due within one year Finance lease obligations due within one year Capital lease & financing obligations due within one y Total current liabilities Long-term debt Long-term operating lease obligations Long-term finance lease obligations Long-term capital lease & financing obligations Deferred income taxes & other liabilities Total Liabilities 575,000 46,973,000 22,296,000 280,000 5,362,000 1,793,000 511,000 0 77,790,000 43,714,000 16,171,000 4,307,000 0 12,961,000 154,943,000 5,225,000 47,060,000 22,159,000 428,000 1,876,000 0 0 729,000 77,477,000 43,520,000 0 0 6,683,000 11,981,000 139,661,000 5,257,000 46,092,000 22,122,000 645,000 3,738,000 0 0 667,000 78,521,000 30,045,000 0 0 6,780,000 8,354,000 123,700,000 1,099,000 41,433,000 20,654,000 921,000 2,256,000 0 0 565,000 66,928,000 36,015,000 0 0 6,003,000 9,344,000 118,290,000 Common stock Capital in excess of par value Retained earnings (accumulated deficit) Accumulated other comprehensive income (loss) Noncontrolling interest Total equity 284,000 3,247,000 83,943,000 (12,805,000) 6,883,000 81,552,000 288,000 2,965,000 80,785,000 (11,542,000) 7,138,000 79,634,000 295,000 2,648,000 85,107,000 (10,181,000) 2,953,000 80,822,000 305,000 2,371,000 89,354,000 (14,232,000) 2,737,000 80,535,000 Additional Information Net cash flows from operating activities 25,255,000 27,753,000 28,337,000 31,530,000 Land Buildings & improvements Fixtures & equipment Transportation equipment Construction in progress Property & equipment, gross Less: accumulated depreciation Property & equipment, net 24,619,000 105,674,000 58,607,000 2,377,000 3,751,000 195,028,000 89,820,000 105,208,000 24,526,000 101,006,000 54,488,000 2,316,000 3,474,000 185,810,000 81,493,000 104,317,000 25,298,000 101,155,000 52,695,000 2,387,000 3,619,000 185,154,000 77,479,000 107,675,000 24,801,000 98,547,000 48,998,000 2,845,000 4,301,000 179,492,000 71,782,000 107,710,000 As Reported Annual Income Statement Report Date Scale Net sales Membership & other income Total revenues Cost of sales Gross Profit Operating, selling, general & administrative expenses Operating income (loss) Interest expense on debt Interest expense on finance, capital lease & financing obligatior Interest income Gain (loss) on extinguishment of debt Other gains & (losses) Income (loss) before income taxes Provision (benefit) for income taxes Income (loss) after income taxes Less consolidated net income attributable to noncontrolling inter Net Income 2019 Thousands 519,926,000 4,038,000 523,964,000 394,605,000 129,359,000 108,791,000 20,568,000 2,262,000 337,000 189,000 0 1,958,000 20,116,000 4,915,000 15,201,000 (320,000) 14,881,000 2018 Thousands 510,329,000 4,076,000 514,405,000 385,301,000 129,104,000 107,147,000 21,957,000 1,975,000 371,000 217,000 0 (8,368,000) 11,460,000 4,281,000 7,179,000 (509,000) 6,670,000 2017 Thousands 495,761,000 4,582,000 500,343,000 373,396,000 126,947,000 106,510,000 20,437,000 1,978,000 352,000 152,000 (3,136,000) 0 15,123,000 4,600,000 10,523,000 (661,000) 9,862,000 Additional Information Weighted average shares outstanding - basic Weighted average shares outstanding - diluted Year end shares outstanding 2,850,000 2,868,000 2,832,000 2,929,000 2,945,000 2,878,000 2,995,000 3,010,000 2,952,000