Also be prepared to answer analytics questions using the ratio above like comparing the ration in 2019,2018 and 2017
Baca XXIKODE - 0 X Comments Share S # E Conditional format as Cell Formatting Table Styles Styles ES Insert Delete format Ideas -99 * Sensitivity Clear Sort & Find & Filter Select sabing Cele deas Sentity AutoSave C H2 S - F SA Project Spring 2020.xlsx - Fuel Proiect Sorino2020xlsxFxral Search File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot X Out Calibri 11 AA == Wrap Text Custom Paste to Copy 3 Format Painter tak BIUR A E Merge: Center $ % Cipboard For Alignment Number F19 - X fx -2,08*F18 A B 45 LIABILITIES AND EQUITY Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Obligations under capital leases due within one year Total current liabilities $ $ $ $ $ 5225,00 $ 17 060,00 $ 22 159,00 $ 428,00 $ 1876,00 $ 729,00 $ 77 477,00 $ 5 257,00 $ 1 099,00 $ 2708,00 $ 1592,00 16 092,00 $ 41 133,00 $ 38 187,00 $ 38 110,00 22 122,00 $ 20 654,00 $ 19 607,00 $ 19 152,00 645,00 $ 921,00 S 521,00 $ 1021,00 3/38,00 $ 2 256,00 S 2745,00 $ 4810,00 667,00 $ 565,00 S 551,00 $ 287,00 78 521,00 $ 66 928,00 $ 64 619,00 $ 65 272,00 Long term debt Long term obligations under capital leases Deferred income taxes and other Total Long-term liabilities $ $ $ $ 43 520,00 $ 6683,00 $ 11 981,00 $ 62 184,00 $ 30045,00 $ 6780,00 $ 8 354,00 $ 45 179,00 $ 36015,00 $ 38 214,00 $ 41 086,00 6003,00 $ 5816,00 $ 2606,00 9344,00 $ 7321,00 $ 8 805,00 51 362,00 $ 51 351,00 $ 52 497,00 63 Equity: Common stock Paid-in Capital in excess of par value Retained earnings & Accumulated other comprehensive income (loss) Total Walmart shareholders' equity Nonredeemable noncontrolling interest Total equity $ $ $ $ $ $ 288,00 $ 295,00 $ 305,00 $ 317,00 $ 323,00 2 965,00 $ 2 618,00 $ 2 371,00 $ 1805,00 $ 2162,00 69 243,00 $ 71926,00 $ 75 122,00 $ 78 124,00 $ 78 609,00 72 496,00 $ 77 869,00 $ 77 798,00 $ 80 546,00 $ 81 394,00 7 138,00 $ 2953,00 $ 2737,00 S 3065,00 S 4543,00 79 634,00 $ 80 822,00 $ 80 535,00 $ 83 611,00 $ 85 937,00 Total liabilities and equity $ 219 295,00 $ 204 522,00 $ 198 825,00 $ 199 581,00 $ 203 706,00 Problem 1 - - 113 - 0 X Comments Baca XXIKODE Share AutoSum 47 4 Sort & Find & Ideas Clear Filter Select sabing Insert Delete Format Sensitivity Cels deas Sentity AutoSave C H 2 S FSA Project Spring2020.xlsx Furel Scanch File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot X Out Calibri 11 AA == Wrap Text Custom Paste to Copy BIU - A 0 Mergear Center - Format Painter 6 000 Conditional format as Cell * Formatting Table Styles Cipboard Font Alignment Styles F19 x Box -2,08*F18 Required: 1 Using information in all the chapters in the textbook especially chapter 12, fill-in the formulas for the following ratios. 2 Calculate the ratios for Wal-Mart in 2019, 2018, and 2017 Fiscal years as provided in the table bellow. 3 To prepare for the test, analyze the results (be able to explain what the numbers mean and compare between the two years) for various Liquidity, Profitability, Debt, Asset Management, and Stockholders' Reward ratios. 4 Take the Walmart FSA Project Test on the day as stated in the course schedule. Fiscal Year Ended Jan 31 2019 2018 2017 Formula Fiscal Year Ended Jan 31 Analysis Ratio 1 Example Sample ratio x/y - 1,50| 2,20 2,20 Liquidity Net Working Capital Current ralio Quick ratio Profitability Gross Profit percentage Net Income percentage Debt Analysis Debt Ratio Interest Coverage Ratia Problem - - 115 - 0 X Comments AutoSave C H2 File Home Insert X Out Paste copy Format Painter Cipboard F19 x S Draw Calibri BIU - F SA Project Spring 2020.xlsx - Fuel Proiect Sorino2020xlsxFxral Search Page Layout Formulas Data Review View Help Power Pivot 11 AA == Wrap Text Custom A - Merger An Center $ For Alignment -2,08*F18 Baca XXIKODE Share AutoSum 47 4 Sort & Find & Ideas Clear Filter Select sabing % -99 Insert Delete format Sensitivity Conditional Format as Cell Formatting Table Styles Styles Cels deas Sentity Box 94 Debt Analysis Debt Ratio Interest Coverage Ratio Asset Management Analysis Inventory Turnover 99 Days-Sales-in-Inventory Accounts Receivable Turnover Receivable Collection Period Return on Assets 108 Total Asset Turnover 109 110 111 Fixed Asset Turnover Stockholder's Reward Analysis Earnings Per Share 112 113 114 Dividends Per Share 115 116 117 Dividends Payout Ratio 118 119 Return on Equity Problem - - E -- 113 - 0 X Comments Baca XXIKODE Share Autobum 27 O 4 Sort & Find & Ideas Clear Filter Select Insert Delete Format Sensitivity AutoSave C H2 S - F SA Project Spring 2020.xlsx - Fuel Proiect Sorino2020xlsxFxral Search File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot X Out Calibri 11 AA == Wrap Text Custom Paste to Copy BIU A Format Painter 0 Merger Center 6 000 * Cipboard Font Alignment Number F19 x x -2,08*F18 1 Wal-Mart Stores, Inc. Consolidated Statements of Income 3 Source: 10K-Edgar Database, SEC (modified) Conditional format as Cell Formatting Table Styles Styles Cele sabing deas Sentity F G H $ 7 Fiscal Years Ended January 31, 2019 2018 2017 2016 2015 514 405,00 $ 500 343,00 $ 485 873,00 $ 482 130,00 $ 485 651,00 385 301,00 $ 373 396,00 $ 361 256,00 S 360 984,00 $ 365 086,00 129 104,00 $ 126 947,00 $ 124 617,00 $ 121 146,00 $ 120 565,00 107 147,00 $ 106 510,00 S 101 853,00 S 97041,00 S 93 418,00 21 957,00 $ 20 437,00 $ 22 764,00 $ 24 105,00 $ 27 147,00 $ $ $ 10 (Amounts in millions) Sales Revenues (can also be used as Total Credit Sales if the later is unknown) Cost of sales or Cost of Goods Sold (COGS) Gross Profit Operating, selling, general and administrative (SG&A) expenses Operating Income Non operating Income/Cxpenses: Net Interest expenses Other income/loss Income from continuing operations before income taxes Income taxes Consolidated Net Income $ $ $ $ 8368,00 $ 11 460,00 $ 4281,00 $ 7179,00 $ 2 178,00 $ 3136,00 $ 15 123,00 $ 4600,00 $ 10 523,00 $ 2267,00 S - 20 497,00 $ 6204,00 $ 14 293,00 $ 2 467,00 S - S 21 638,00 $ 6558,00 $ 15 080,00 $ 2 348,00 370,50 25 169,50 8070,50 17 099,00 15 3 Weighted average common shares outstanding (basic) Cash Dividends declared 2 929,00 6092,32 $ 2 995,00 6 109,80 3 101,00 6202,00 $ $ $ 207,00 6285,72 $ 3230,00 6202,00 Wal-Mart Stores, Inc. Consolidated Balance Sheets Source: 10K - Edgar Database, SEC (modified) As of January 31, 2019 2019 2018 2017 2016 2015 ASSETS Current assets: Problem * -- - 0 X Comments Baca XXIKODE Share Autobum 27 O 4 Sort & Find & Ideas Clear Filter Select Insert Delete Format Sensitivity AutoSave C H2 S - F SA Project Spring 2020.xlsx - Fuel Proiect Sorino2020xlsxFxral Search File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot X Out Calibri 11 AA == Wrap Text Custom Paste to Copy BIU A Format Painter 0 Merger Center 6 000 * Cipboard For Alignment Number F19 x x -2,08*F18 AB Wal-Mart Stores, Inc. 22 Consolidated Balance Sheets Source: 10K-Edgar Database, SEC (modified) Conditional format as Cell Formatting Table Styles Styles Celle sabing deas Sentity 21 2019 2018 As of January 31, 2017 2016 2015 ASSETS Current assets: Cash and cash equivalents Accounts Receivables, Net Inventories Prepaid expenses and other expenses Total current assets $ $ 7722,00 $ 6283,00 $ 44 269,00 $ 3623,00 $ 61 897,00 $ 6 756,00 $ 6867,00 $ 8 705,00 $ 9 135,00 5614,00 $ 5835,00 S 5624,00 $ 6778,00 43 783,00 $ 43 046,00 S 44 469,00 $ 45 141,00 3511,00 $ 1941,00 S 1441,00 S 2 224,00 59 664,00 $ 57 689,00 $ 60 239,00 $ 63 278,00 $ $ 34 35 $ $ $ 185 810,00 $ 185 154,00 $ 179 492,00 $ 176 958,00 $ 177 395,00 (81 493,00) $ (77 479,00) $ (71 782,00) $ (66 787,00) $ (63 115,00) 104 317,00 $ 107 675,00 $ 107 710,00 $ 110 171,00 $ 114 280,00 36 37 38 Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net Property under capital leases: Property under capital leases Less accumulated amortization Property under capital leases, net $ $ $ 12 760,00 $ (5682,00) $ 7078,00 $ 12 703,00 $ 11 637,00 $ 11 096,00 $ (5560,00) $ (5169,00) $ (4751,00) $ 7 143,00 $ 6468,00 $ 6 345,00 $ 5239,00 (2 864,00) 2 375,00 10 $ Goodwill Other assets and deferred charges Total assets 31 181,00 $ 18 242,00 $ 17037,00 $ 16 695,00 14 822,00 $ 11 798,00 $ 9 921,00 S 6 131,00 219 295,00 $ 204 522,00 $ 198 825,00 $ 199 581,00 $ 18 102,00 $ 56/1,00 $ 203 706,00 $ 46 LIABILITIES AND EQUITY Problem 1 -- + -- 113
