Hello need assistance with preparing 4 ratio analyses (for 2019, 2018, and 2017) for the following company using the financial statement information provided below.

1. Profitability ratios - Gross Profit margin, Profit margin, Return on assets, & Return on equity

2. Productivity : Inventory Turnover, Accounts Receivable Turnover, PPE Turnover, & Asset Turnover

3. Solvency : Debt-to-equity, Times interest earned, & Return on Financial leverage

4 . Liquidity : Current Ratio, Quick Ratio, Operating cash flow to current liabilities, & Working capital

NOTE: 2016 BALANCE SHEET INFORMATION TO BE USED ONLY FOR RATIOS

WALMART

As Reported Annual Balance Sheet

Report Date 2019 2018 2017 2016

Scale Thousands Thousands Thousands Thousands

Assets

Cash & cash equivalents 9,465,000 7,722,000 6,756,000 6,867,000

Receivables, net 6,284,000 6,283,000 5,614,000 5,835,000

Inventories 44,435,000 44,269,000 43,783,000 43,046,000

Prepaid expenses & other current assets 1,622,000 3,623,000 3,511,000 1,941,000

Total current assets 61,806,000 61,897,000 59,664,000 57,689,000

Property & equipment, net 105,208,000 104,317,000 107,675,000 107,710,000

Operating lease right-of-use assets 17,424,000 0 0 0

Finance lease right-of-use assets, net 4,417,000 0 0 0

Property under capital lease & financing obligations, net 0 7,078,000 7,143,000 6,468,000

Goodwill 31,073,000 31,181,000 18,242,000 17,037,000

Other long-term assets 16,567,000 14,822,000 11,798,000 9,921,000

Total assets 236,495,000 219,295,000 204,522,000 198,825,000

Liabilities & Equity

Short-term borrowings 575,000 5,225,000 5,257,000 1,099,000

Accounts payable 46,973,000 47,060,000 46,092,000 41,433,000

Accrued liabilities 22,296,000 22,159,000 22,122,000 20,654,000

Accrued income taxes 280,000 428,000 645,000 921,000

Long-term debt due within one year 5,362,000 1,876,000 3,738,000 2,256,000

Operating lease obligations due within one year 1,793,000 0 0 0

Finance lease obligations due within one year 511,000 0 0 0

Capital lease & financing obligations due within one year 0 729,000 667,000 565,000

Total current liabilities 77,790,000 77,477,000 78,521,000 66,928,000

Long-term debt 43,714,000 43,520,000 30,045,000 36,015,000

Long-term operating lease obligations 16,171,000 0 0 0

Long-term finance lease obligations 4,307,000 0 0 0

Long-term capital lease & financing obligations 0 6,683,000 6,780,000 6,003,000

Deferred income taxes & other liabilities 12,961,000 11,981,000 8,354,000 9,344,000

Total Liabilities 154,943,000 139,661,000 123,700,000 118,290,000

Common stock 284,000 288,000 295,000 305,000

Capital in excess of par value 3,247,000 2,965,000 2,648,000 2,371,000

Retained earnings (accumulated deficit) 83,943,000 80,785,000 85,107,000 89,354,000

Accumulated other comprehensive income (loss) (12,805,000) (11,542,000) (10,181,000) (14,232,000)

Noncontrolling interest 6,883,000 7,138,000 2,953,000 2,737,000

Total equity 81,552,000 79,634,000 80,822,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 24,619,000 24,526,000 25,298,000 24,801,000

Buildings & improvements 105,674,000 101,006,000 101,155,000 98,547,000

Fixtures & equipment 58,607,000 54,488,000 52,695,000 48,998,000

Transportation equipment 2,377,000 2,316,000 2,387,000 2,845,000

Construction in progress 3,751,000 3,474,000 3,619,000 4,301,000

Property & equipment, gross 195,028,000 185,810,000 185,154,000 179,492,000

Less: accumulated depreciation 89,820,000 81,493,000 77,479,000 71,782,000

Property & equipment, net 105,208,000 104,317,000 107,675,000 107,710,000

WALMART

As Reported Annual Income Statement

Report Date 2019 2018 2017

Scale Thousands Thousands Thousands

Net sales 519,926,000 510,329,000 495,761,000

Membership & other income 4,038,000 4,076,000 4,582,000

Total revenues 523,964,000 514,405,000 500,343,000

Cost of sales 394,605,000 385,301,000 373,396,000

Gross Profit 129,359,000 129,104,000 126,947,000

Operating, selling, general & administrative expenses 108,791,000 107,147,000 106,510,000

Operating income (loss) 20,568,000 21,957,000 20,437,000

Interest expense on debt 2,262,000 1,975,000 1,978,000

Interest expense on finance, capital lease & financing obligations 337,000 371,000 352,000

Interest income 189,000 217,000 152,000

Gain (loss) on extinguishment of debt 0 0 (3,136,000)

Other gains & (losses) 1,958,000 (8,368,000) 0

Income (loss) before income taxes 20,116,000 11,460,000 15,123,000

Provision (benefit) for income taxes 4,915,000 4,281,000 4,600,000

Income (loss) after income taxes 15,201,000 7,179,000 10,523,000

Less consolidated net income attributable to noncontrolling interest (320,000) (509,000) (661,000)

Net Income 14,881,000 6,670,000 9,862,000

Additional Information

Weighted average shares outstanding - basic 2,850,000 2,929,000 2,995,000

Weighted average shares outstanding - diluted 2,868,000 2,945,000 3,010,000

Year end shares outstanding 2,832,000 2,878,000 2,952,000