Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help me calculate the ratios in the table. I have included pictures of the financial information required for each ratio in the table. These
Please help me calculate the ratios in the table. I have included pictures of the financial information required for each ratio in the table. These are three years of balance sheets, income statements, statement of cash flows and stock informations. I'm not sure if any of the answers in the table are correct, but the ones highlighted in tan have not been attempted.
Ratios Industry Average 2020 2019 2018 109.19 Current Ratio Debt/Equity Ratio Free Cash Flow (000) Earnings per Share Price / earnings ratio Return on Equity Net profit margin Stock Data Number of Shares Outstanding Closing Price Last Business Day in December 0.79 0.80 0.76 2.08 1.93 1.59 -$25,578,000 $16,174,000 -$97,514,000 96.08 $ 44.35 $ 56.43 2.50 5.01 2.67 20.22% 8.87% 12.67% 6.40% 4.72% 5.56% 1.63 13.00 12.40% 5.00% 131,425 240.01 125,688 222.41 123,091 150.43 Sheet 2018 Balance Sheet 2020 Income Statement 2019 income Statement 2018 Income Statement 2020 Cash Flow 2019 Cash Flow 2018 C 01/31/2020 USD Not Qualified Yes Thousands 9465000 6284000 44435000 1622000 61806000 24619000 105674000 58607000 2377000 3751000 195028000 89820000 105208000 17424000 4417000 Current Ratio Debt/Equity Ratio Free Cash Flow (000) Earnings per Share Price / earnings ratio Return on Equity Net profit margin Number of Shares Outstan Closing Price Last Business 31073000 16567000 6 As Reported Annual Balance Sheet 7 Report Date 8 Currency 9 Audit Status 10 Consolidated 11 Scale 12 Cash & cash equivalents 13 Receivables, net 14. Inventories 15 Prepaid expenses & other current assets 16 Total current assets 17 Land 18 Buildings & improvements 19 Fixtures & equipment 20 Transportation equipment 21 Construction in progress 22 Property & cquipment, ROSS 23 Less: accumulated depreciation 24 Property & equipment, net 25 Operating lease right-of-use assets 26 Finance lease right-of-use assets, net 27 Property under capital lease & financing obligations 28 Less: accumulated amortization 29 Property under capital lease & financing obligations, net 30 Goodwill 31 Other long-term assets 32 Other assets & deferred charges 33 Total assets 34 Short-term borrowings 35 Accounts payable 36 Accrued wages & benefits 37 Self-insurance 38 Accrued non-income taxes 39 Deferred gift card revenue 40 Other accrued liabilities 41 Accrued liabilities 42 Accrued income taxes 43 Long-term debt due within one year 44 Operating lease obligations due within one year 45 Finance an obligations due within one year 46 Capital Lease & financing obligations due within one year 47 Toual current liabilities 48 Unsecured debt 49 Other debt 50 Total long-term debe 51 Les amount due within one year 52 Long-term debt 53 Long-term operating less obligations 54 Long-term finance las obligations 55 Lorem capital case & financing obligasi 56 Deferred income taxes & libe 57 Common sock 58 Capital in excess of par vel 59 Retained earnings (accumulated defic 60 Currency translation & other 61 Net investmenthede 63 Cash flow bedies 64 Minimum pension 65 Accumulated other comprehensive income a 66 Tel Walmart shareholders 67 Noncontrollinger 68 Telequity 236495000 575000 46973000 6093000 4469000 3039000 1990000 6705000 22296000 280000 5362000 1793000 511000 77790000 49180000 - 104000 49076000 16171000 40 000 284000 8394.000 1517000 Exchange rate used is that of the Year End reported date 01/31/2020 USD Not Qualified Yes Thousands 519926000 4038000 523964000 394605000 108791000 20568000 2262000 337000 189000 -2410000 As Reported Annual Income Statement Report Date Currency Audit Status Consolidated Scale Net sales 3 Membership & other income 4 Total revenues 5 Cost of sales 6 Operating, selling, general & administrative expenses 17 Operating income (loss) 18 Interest expense on debt 19 Interest expense on finance, capital lease & financing obligation 20 Interest income 21 Interest income (expense), net 22 Gain (loss) on extinguishment of debt 23 Other gains & (losses) 24 Income (loss) before income taxes - United States (U.S.) 25 Income (loss) before income taxes - non-U.S. 26 Income (loss) before income taxes 27 Current U.S. federal income taxes provision (benefit) 28 Current U.S. state & local income taxes provision (benefit) 29 Current intemational income taxes provision (benefit) 30 Current provision (benefit) for income taxes 31 Deferred U.S. federal income taxes provision (benefit) 32 Deferred U.S. state & local income taxes provision (benefit) 33 Deferred intemational income taxes provision (benefit) 34 Deferred provision (benefit) for income taxes 35 Provision (benefit) for income taxes 36 Consolidated net income (loss) 37 Less consolidated net income attributable to noncontrolling inter 38 Consolidated net income attributable to Walmart 39 Weighted average shares outstanding - basic 40 Weighted average shares outstanding-diluted 41 Year and shares outstanding 42 Net income (loss) per share - basic 43 Net income (loss) per share-diluted 44 Dividends declared per common share 45 Total number of employees 46 Number of common stockholders 47 Foreign currency translation adjustments 48 1958000 17098000 3018000 20116000 2794000 587000 1205000 4586000 663000 35000 -369000 329000 4915000 15201000 -320000 14881000 2850000 2868000 2832000 5.22 5.19 2.12 2200000 217840 286000 01/31/2020 USD Not Qualified Yes Thousands 15201000 10987000 -1886000 15000 -1036000 320000 As Reported Annual Cash Flow Report Date Currency Audit Status o Consolidated 1 Scale 2 Consolidated net income (loss) 13 Depreciation & amortization 14 Unrealized losses & (gains) 15 Unrealized gain (loss) on investments 16 Losses & (gains) for disposal of business operations 17 Asda pension contribution 18 Deferred income taxes 19 Loss on extinguishment of debt 20 Other operating activities 21 Receivables, net 22 Inventories 23 Accounts payable 24 Accrued liabilities 25 Accrued income taxes 26 Net cash flows from operating activities 27 Payments for property & equipment 28 Proceeds from the disposal of property & equipment 29 Proceeds from disposal of certain operations 30 Payments for business acquisitions, net of cash acquired 31 Other investing activities 32 Net cash flows from investing activities 33 Net change in short-term borrowings 34 Proceeds from issuance of long-term debt 35 Repayments of long-term debt 36 Premiums paid to extinguish debt 37 Dividends paid 38 Purchase of company stock 39 Dividends paid to noncontrolling interest 40 Purchase of noncontrolling interest 41 Other financing activities 42 Net cash flows from financing activities 43 Effect of exchange rates on cash, cash equivalents, & restricted 44 Effect of exchange rate changes on cash & cash equivalents 45 Net Increase (decrease) in cash & cash equivalents 46 Cash & cash equivalents at beginning of year 47 Cash & cash equivalents at end of year 48 Net Increase (decrease) in cash, cash equivalents & restricted ca 49 Cash, cash equivalents & restricted cash at beginning of year 50 Cash, cash equivalents & restricted cash at end of year 51 Income taxes paid 52 Interest paid 53 1981000 154000 -300000 -274000 186000 -93000 25255000 -10705000 321000 833000 -56000 479000 -9128000 -4656000 5492000 -1907000 -6048000 -5717000 -555000 -908000 -14299000 -69000 1759000 7756000 9515000 3616000 2464000 01/31/2019 USD Not Available Yes Thousands 7722000 6283000 44269000 3623000 61897000 24526000 101006000 54488000 2316000 3474000 185810000 81493000 104317000 12760000 5682000 7078000 31181000 14822000 10 As Reported Annual Balance Sheet 11 Report Date 12 Currency 13 Audit Status 14 Consolidated 15 Scale 16 Cash & cash equivalents 17 Receivables, net 18 Inventories 19 Prepaid expenses & other current assets 20 Total current assets 21 Land 22 Buildings & improvements 23 Fixtures & equipment 24 Transportation equipment 25 Construction in progress 26 Property & equipment, gross 27 Less: accumulated depreciation 28 Property & equipment, net 29 Operating lease right-of-use assets 30 Finance lease right-of-use assets, net 31 Property under capital lease & financing obligations 32 Less: accumulated amortization 33 Property under capital lease & financing obligations, net 34 Goodwill 35 Other long-term assets 36 Other assets & dcferred charges 37 Total assets 38 Short-term borrowings 39 Accounts payable 40 Accrued wages & benefits 41 Self-insurance 42 Accrued non-income taxes 43 Deferred gift card revenue 44 Other accrued liabilities 45 Accrued liabilities 46 Accrued income taxes 47 Long-term debt due within one year 48 Operating lease obligations due within one year 49 Finance lease obligations due within one year 50 Capital las & financing obligations due within one year 51 Total current liabilities 52 Unsecured debt 53 Other debt 54 Total long-term debe 55 Les amounts due within one year 56 Long-term debe 57 Long-term operating less obligations 58 Long-term finance as obligations 59 Long-term capital lease & financing obligations 60 Deferred income taxes & other abilities 61 common stock 62 Capital in excess of per valor 63 Retained earnings (accumulated deficit) 64 Currency translation & other 65 Net investment hadees 66 Unrealued gain on available for sale scores 67 Cash flow hedges 68 Minimum on liability 69 Accumulated other comprehensive income 70 Total Walmart shareholder equity 71 Noncontrolling interest 72 To 219295000 5225000 47060000 6504000 3979000 2979000 1932000 6765000 22159000 428000 1876000 729000 77477000 45661000 -265000 45396000 1876000 43520000 6681000 ARCO 2965000 8078500 -12083001 - 140000 - 712000 - 11342000 72495000 7138000 Exchange rate used is that of the Year End reported date 01/31/2019 USD Not Available Yes Thousands 510329000 4076000 514405000 385301000 107147000 21957000 1975000 371000 217000 -2129000 8 9 10 As Reported Annual Income Statement 11 Report Date 12 Currency 13 Audit Status 14 Consolidated 15 Scale 16 Net sales 17 Membership & other income 18 Total revenues 19 Cost of sales 20 Operating, selling, general & administrative expenses 21 Operating income (loss) 22 Interest expense on debt 23 Interest expense on finance, capital lease & financing obligation 24 Interest income 25 Interest income (expense), net 26 Gain (loss) on extinguishment of debt 27 Other gains & (losses) 28 Income (loss) before income taxes - United States (U.S.) 29 Income (loss) before income taxes - non-U.S. 30 Income (loss) before income taxes 31 Current U.S. federal income taxes provision (benefit) 32 Current U.S. state & local income taxes provision (benefit) 33 Current intemational income taxes provision (benefit) 34 Current provision (benefit) for income taxes 35 Deferred U.S. federal income taxes provision (benefit) 36 Deferred U.S. state & local income taxes provision (benefit) 37 Deferred intemational income taxes provision (benefit) 38 Deferred provision (benefit) for income taxes 39 Provision (benefit) for income taxes 40 Consolidated net income (loss) 41 Loss consolidated net income attributable to noncontrolling inter 42 Consolidated net income attributable to Walmart 43 Weighted average shares outstanding basic 44 Weighted average shares outstanding-diluted 45 Year end shares outstanding 46 Net Income foss) per share - basic 47 Net Income foss) per share-diluted 48 Dividends declared per common share 49 Total number of employees 50 Number of common stockholders 51 Foreign currency translation adjustments 53 Reference 54 55 Mergent Online. (2020) Company -8368000 15875000 4415000 11460000 2763000 493000 1495000 4751000 361000 - 16000 -93000 470000 4281000 7179000 -509000 6670000 2929000 2945000 2878000 2.28 2.26 2.08 2200000 223968 -226000 52 B C O 01/31/2019 USD Not Available Yes Thousands 7179000 10678000 3516000 4850000 499000 9 10 As Reported Annual Cash Flow 11 Report Date 12 Currency 13 Audit Status 14 Consolidated 15 Scale 16 Consolidated net income (loss) 17 Depreciation & amortization 18 Unrealized losses & (gains) 19 Unrealized gain (loss) on investments 20 Losses & (gains) for disposal of business operations 21 Asda pension contribution 22 Deferred income taxes 23 Loss on extinguishment of debt 24 Other operating activities 25 Receivables, net 26 Inventories 27 Accounts payable 28 Accrued liabilities 29 Accrued income taxes 30 Net cash flows from operating activities 31 Payments for property & equipment 32 Proceeds from the disposal of property & equipment 33 Proceeds from disposal of certain operations 34 Payments for business acquisitions, net of cash acquired 35 Other investing activities 36 Net cash flows from investing activities 37 Net change in short-term borrowings 38 Proceeds from issuance of long-term debt 39 Repayments of long-term debt 40 Premiums paid to extinguish debt 41 Dividends paid 42 Purchase of company stock 43 Dividends paid to noncontrolling interest 44 Purchase of noncontrolling interest 45 Other financing activities 46 Net cash flows from financing activities 47 Effect of exchange rates on cash, cash equivalents, & restricted 48 Efect of exchange rate changes on cash & cash equivalents 49 Net Increase (decrease in cash & cash equivalents 50 Cash & cash equivalents at beginning of year 51 Cash & cash equivalents at end of year 52 Net Increase (decrease in cash, cash equivalents & restricted ca 53 Cash, cash equivalents & restricted cash at beginning of year 54 Cash, cash equivalents & restricted cash at end of year 56 Income taxes paid 56 Interest paid 1734000 -368000 -1311000 1831000 183000 40000 27753000 -10344000 519000 876000 -14656000 431000 -24036000 -53000 15872000 -3784000 -8102000 -7410000 -431000 -629000 -2537000 438000 742000 7014000 7756000 3982000 2348000 2020 Balance Sheet 2019 Balance Sheet Ready 2018 Balance Sheet D 10 As Reported Annual Balance Sheet 11 Report Date 12 Currency 13 Audit Status 14 Consolidated 15 Scale 16 Cash & cash equivalents 17 Receivables, net 18 Inventories 19 Prepaid expenses & other current assets 20 Total current assets 21 Land 22 Buildings & improvements 23 Fixtures & equipment 24 Transportation equipment 25 Construction in progress 26 Property & equipment, gross 27 Less: accumulated depreciation 28 Property & equipment, net 29 Operating lease right-of-use assets 30 Finance lease right-of-use assets, net 31 Property under capital lease & financing obligations 32 Loss: accumulated amortization 33 Property under capital lease & financing obligations, net 34 Goodwill 35 Other long-term assets 38 Other assets & deferred charges 37 Total assets 38 Short-term borrowings 30 Accounts payable 40 Accrued wages & benefits 41 Self-insurance 42 Accrued non-income taxes 43 Deferred gift card revenue 44 Other accrued liabilities 45 Accrued abilities 46 Accrued income taxes 47 Long-term debat due within one year 40 Operating lese bigations due within one year 49 Finance letions de wiin one year 50 Capital ose & Branding obligations due within one year 51 Total currentes 52 Unsecured 01/31/2018 USD Not Qualified Yes Thousands 6756000 5614000 43783000 3511000 59664000 25298000 101155000 52695000 2387000 3619000 185154000 77479000 107675000 12703000 5560000 7143000 18242000 11798000 201522000 5257000 46092000 6998000 3737000 3073000 2017000 6297000 22122000 645000 3738000 667000 78521000 33897000 - 114000 33783000 54 Tolong-lormel 55 Loss mounts one year 30045000 57 Longmorgon 50 Long-term facelor 51 Common stock 64 Currency 17200 122000 e Accumulador compreencome fol 1000 0 fx Number of common stockholders B 01/31/2018 USD Not Qualified Yes Thousands 495761000 4582000 500343000 373396000 106510000 20437000 1978000 352000 152000 -2178000 -3136000 As Reported Annual Income Statement Report Date Currency Audit Status Consolidated Scale 3 Net sales - Membership & other income B Total revenues 9 Cost of sales o Operating, selling, general & administrative expenses E1 Operating income (loss) 22 Interest expense on debt 23 Interest expense on finance, capital lease & financing obligation 24 Interest income 25 Interest income (expense), net 26 Gain (loss) on extinguishment of debt 27 Other gains & (losses) 28 Income (loss) before income taxes - United States (U.S.) 29 Income (loss) before income taxes - non-U.S. 30 Income (loss) before income taxes 31 Current U.S. federal income taxes provision (benefit) 32 Current U.S. state & local income taxes provision (benefit) 33 Current intemational income taxes provision (benefit) 34 Current provision (benefit) for income taxes 35 Deferred U.S. federal income taxes provision (benefit) 36 Deferred U.S. state & local income taxes provision (benefit) 37 Deferred intemational income taxes provision (benefit) 38 Deferred provision (benefit) for income taxes 39 Provision (benefit) for income taxes 40 Consolidated net income (loss) 41 Less consolidated net income attributable to noncontrolling inten 42 Consolidated net income attributable to Walmart 43 Weighted average shares outstanding - basic 44 Weighted average shares outstanding-diluted 45 Year end shares outstanding 46 Net Income (los) per share-basic 47 Net Income (loss) per share-diluted 48 Dividends declared per common share 49 Total number of employees 50 Number of common stockholders 51 Foreign currency translation adjustments 52 53 10722000 4401000 15123000 2998000 405000 1377000 4780000 -22000 -12000 -146000 -180000 4600000 10523000 -661000 9862000 2995000 3010000 2952000 3.29 3.28 2.04 2300000 229858 2540000 A B 01/31/2018 USD Not Qualified Yes Thousands 10523000 10529000 9 10 As Reported Annual Cash Flow 11 Report Date 12 Currency 13 Audit Status 14 Consolidated 15 Scale 16 Consolidated net income (loss) 17 Depreciation & amortization 18 Unrealized losses & (gains) 19 Unrealized gain (loss) on investments 20 Losses & (gains) for disposal of business operations 21 Asda pension contribution 22 Deferred income taxes 23 Loss on extinguishment of debt 24 Other operating activities 25 Receivables, net 26 Inventories 27 Accounts payable 28 Accrued liabilities 29 Accrued income taxes 30 Net cash flows from operating activities 31 Payments for property & equipment 32 Proceeds from the disposal of property & equipment 33 Proceeds from disposal of certain operations 34 Payments for business acquisitions, net of cash acquired 35 Other investing activities 36 Net cash flows from investing activities 37 Net change in short-term borrowings 38 Proceeds from issuance of long-term debt 39 Repayments of long-term debt 40 Premiums paid to extinguish debt 41 Dividends paid 42 Purchase of company stock 43 Dividends paid to noncontrolling interest 44 Purchase of noncontrolling interest 45 Other financing activities 46 Net cash flows from financing activities 47 Effect of exchange rates on cash, cash equivalents, & restricted 48 Effect of exchange rate changes on cash & cash equivalents 49 Net increase (decrease) in cash & cash equivalents 50 Cash & cash equivalents at beginning of year 51 Cash & cash equivalents at end of year 52 Net Increase (decrease) in cash, cash equivalents & restricted ca 53 Cash, cash equivalents & restricted cash at beginning of year 54 Cash, cash equivalents & restricted cash at end of year 55 Income taxes paid 56 Interest paid 57 -304000 3136000 1210000 -1074000 - 140000 4086000 928000 -557000 28337000 -10051000 378000 1046000 -375000 -58000 -9060000 4148000 7476000 -13061000 3059000 -6124000! -8296000 -690000 -8000 -261000 -19875000 487000 -111000 6867000 6756000 6179000 2450000 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started