Ratio Calculation On each data tab, use formulas to calculate the following financial indicators for each year of data:
o Current ratio
o Debt/equity ratio
o Free cash flow
o Earnings per share
o Price/earnings ratio
o Return on equity
0 Net Profit Margin
*Sorry photos loaded funny*
*
2371000 89354000 -14362000 1435000 1805000 90021000 - 11690000 1022000 2462000 85777000 -6355000 -315000 -336000 Capital in excess of par value Retained earnings (accumulated deficit) Currency translation & other Net investment hedges Unrealized gain on available-for-sale securities Cash flow hedges Derivative instruments Minimum pension liability Accumulated other comprehensive income (loss) Total Walmart shareholders' equity Noncontrolling interest Nonredeemable noncontrolling interest Total equity -990000 -14232000 77798000 -593000 -11597000 80546000 - 134000 -679000 -7168000 81394000 2737000 80535000 3065000 83611000 4543000 85937000 6468000 17037000 6345000 16695000 2375000 18102000 9921000 198825000 1099000 41433000 6105000 3922000 6131000 199581000 2708000 38487000 5814000 3414000 5671000 203706000 1592000 38410000 4954000 3306000 2592000 2816000 2544000 7811000 20654000 921000 2256000 7835000 19607000 521000 2745000 8300000 19152000 1021000 4810000 Property under capital lease & financing obligations, net 5 Goodwill Other long-term assets Other assets & deferred charges 3 Total assets Short-term borrowings Accounts payable Accrued wages & benefits 2 Self-insurance B Accrued taxes Accrued non-income taxes 5 Deferred gift card revenue Other accrued liabilities Accrued liabilities B 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 year Current liabilities of discontinued operation Total current liabilities 5 Unsecured debt Other debt Total long-term debt 3 Less: amounts due within one year Long-term debt Long-term operating lease obligations 1 Long-term finance lease obligations Long-term capital lease & financing obligations Deferred income taxes & other liabilities Redeemable noncontrolling interest Common stock 565000 551000 287000 66928000 38132000 139000 38271000 2256000 36015000 64619000 40776000 183000 40959000 2745000 38214000 65272000 45443000 453000 45896000 4810000 41086000 6003000 9344000 5816000 7321000 2606000 8805000 305000 317000 323000 Walmart Inc (NYS: WMT) Exchange rate used is that of the Year End reported date As Reported Annual Balance Sheet Report Date Currency Audit Status 01/31/2017 USD Not Qualified Yes Thousands 6867000 5835000 43046000 1941000 01/31/2016 USD Not Qualified Yes Thousands 8705000 5624000 44469000 144 1000 01/31/2015 USD Not Qualified Yes Thousands 9135000 6778000 45141000 2224000 Consolidated Scale Cash & cash equivalents Receivables, net Inventories Prepaid expenses & other current assets Current assets of discontinued operations Total current assets Land Buildings & improvements Fixtures & equipment Transportation equipment Construction in progress Property & equipment, gross Less: accumulated depreciation Property & equipment, net Operating lease right-of-use assets Finance lease right-of-use assets, net Property under capital lease & financing obligations Less: accumulated amortization 57689000 24801000 98547000 48998000 2845000 4301000 179492000 71782000 107710000 60239000 25624000 96845000 47033000 2917000 4539000 176958000 66787000 110171000 63278000 26261000 97496000 45044000 2807000 5787000 177395000 63115000 114280000 11637000 5169000 11096000 4751000 5239000 2864000
