a.Compute the values of each of the ratios inExhibit 5.26for Walmart for 2015. Walmart had 3,162 million common shares outstanding at the end of fiscal 2015, and the market price per share was $66.36. For 2014, the comparable shares and price per share were 3,228 million and $84.98, and for 2013, they were 3,233 million and $74.68, respectively. For days accounts receivable outstanding, use total revenues in your calculations. Last eight ratios
This is what I have so far. I can not figure out how to find the Altmans Z ratio? I have attached the financial statements for Walmart.
Liabilities to assets ratio
117,553/203,490=0.577
0.58
Liabilities to shareholders equity ratio
117,553/81,394
1.44
Long term debt to long term capital ratio
43,495/43,495+81,394=43,495/124,889=0.348
0.35
Long term debt to shareholders equity ratio
44,030/80,546=0.546
0.55
Interest coverage ratio
17,099+2,461+7,985+736=28,281
28,281/2,461
11.49
Operating cash flow to average total liabilities
27,389/117,553+123,412=
27,389/0.5(120,482.5) =
27,389/120,482.5=0.227
0.23
Altman's Z Square
Probability of bankruptcy
0
C Solved: Calculating and Interpreti X My Home X Ebooks - Webreader.io X + X -> C A ebooks.cenreader.com/#!/reader/2cfafd29-4e87-4e76-94a7-acc4decod472/page/8e8a96a20d4f6287eafa0202de765194 Apps & School 4H School Bills Virtual Learning - L... Other bookmarks eTextbook: Financial Reporting, Financia... eTextbook: Financial Reporting, Financial Statement Analysis and Valuation ? Q TT Quick Tour Print Search Annotations Accessibility Bookmark ... Financial Statements an... 2014 2015 2016 Role of Financial Statement Analysis in an Efficie... Net Income $ 16,695 $ 17,099 $ 15,080 Add back depreciation and amortization expenses 8,870 9,173 9.454 The Association between Deferred income taxes (279 (503) (672) Earnings and Share Prices (Increase) Decrease in accounts receivable (566) (569) (19) (Increase) Decrease in inventories (1,667) (1,229) (703) Sources of Financial Statement Increase (Decrease) in accounts payable 531 2,678 2,008 Information Increase (Decrease) in income taxes payable (1,224) 166 (472 Increase (Decrease) in other current liabilities 103 1,249 1,303 Summary (Income) Loss from discontinued segments (144 (285) Other operating cash flows 938 785 1,410 Questions, Exercises, Problems, Net Cash Flow from Operating Activities $ 23,257 $ 28,564 $ 27,389 = and Cases Proceeds from sales of property, plant, and equipment 727 570 635 Property, plant, and equipment acquired (13,115) (12,174) (11,477) Integrative Case 1.1. Walmart Investments acquired Other investment transactions (138) 479 167 Net Cash Flow from Investing Activities $(12,526) $ (1 1,125) $(10,675) Case 1.2. Nike: Somewhere Increase (Decrease) in short-term borrowing 911 '6,288) 1,235 between a Swoosh and a S... Increase (Decrease) in long-term borrowing 2,104 1,270 (4,393) (6,683) (1,015) (4,112) Chapter 2. Asset and Liability Share repurchases-treasury stock Dividend payments (6,139) (6,185) (6,294) Valuation and Incom... Other financing activities (982) (2,853) (2,558) The Mixed Attribute Net Cash Flow from Financing Activities $(10,789) $ (15,071) $(16,122) Measurement Model Effects of exchange rate changes on cash (442) (514) (1,022) Net Change in Cash $ $ 1,854 $ (430) The Complementary Nature Cash and cash equivalents, beginning of year $ 7,781 $ 7,281 $ 9,135 and Relative Usefulness o.. Cash and cash equivalents, end of year $ 7,281 $ 9,135 $ 8,705 Asset and Liability Valuation and the Trade-Off be.. Source: Wal-Mart Stores, Inc. Forms 10-K for the three fiscal years ended January 31, 2014, 2015, and 2016. Relevance and Jump to Page 61 Go Required Type here to search O W 3:52 PM 9/11/2020C Solved: Calculating and Interpreti X My Home X Ebooks - Webreader.io X + X -> C A ebooks.cenreader.com/#!/reader/2cfafd29-4e87-4e76-94a7-acc4decod472/page/8e8a96a20d4f6287eafa0202de765194 Apps & School 4H School Bills Virtual Learning - L... Other bookmarks eTextbook: Financial E eTextbook: Financial Reporting, Financial Statement Analysis and Valuation Q TT Reporting, Financia... Quick Tour Print Search Annotations Accessibility Bookmark ... oct'caze LOCIssie Financial Statements an... Source: Wal-Mart Stores, Inc. Forms 10-K for the three fiscal years ended January 31, 2014, 2015, and 2016. Role of Financial Statement Analysis in an Efficie... The Association between Earnings and Share Prices Exhibit 1.20. Sources of Financial Statement Information Wal-Mart Stores, Inc. Income Statements for the Fiscal Years Ended January 31 (amounts in millions; allow for rounding) ( Integrative Case 1.1 Summary Questions, Exercises, Problems, 2014 2015 2016 = and Cases Revenues $ 476,294 $ 485,651 $ 482,130 Cost of goods sold 358,069 365,086 360,984 Integrative Case 1.1. Walmart Gross Profit $118,225 $ 120,565 $121,146 Selling, general, and administrative expenses 91,353 93,418 97,041 Case 1.2. Nike: Somewhere Operating Profit $ 26,872 $ 27,147 $ 24,105 between a Swoosh and a S... Interest income 119 113 81 Interest expense (2,335) (2,461) (2,548) Chapter 2. Asset and Liability Income before Tax $ 24,656 $ 24,799 $ 21,638 Valuation and Incom... Income tax expense 8,105 7,985 6,558 The Mixed Attribute Income (Loss) from discontinued operations 144 285 Measurement Model Net Income $ 16,695 $ 17,099 $ 15,080 Net income attributable to noncontrolling interests (673) (736) (386) The Complementary Nature Net Income Attributable to Common Shareholders $ 16,022 $ 16,363 $ 14,694 and Relative Usefulness o.. Other comprehensive income items (2,409) (4,172) (4,429) Comprehensive Income $ 13,613 $ 12,191 $ 10,265 Asset and Liability Valuation and the Trade-Off be.. Source: Wal-Mart Stores, Inc. Forms 10-K for the three fiscal years ended January 31, 2014, 2015, and 2016. Relevance and Jump to Page 61 Go Exhibit 1.21. Type here to search O w 3:52 PM 9/11/2020C Solved: Calculating and Interpret x My Home X Ebooks - Webreader.io X + X -> C a ebooks.cenreader.com/#!/reader/2cfafd29-4e87-4e76-94a7-acc4decod472/page/8e8a96a20d4f6287eafa0202de765194 Apps & School 4H School Bills Virtual Learning - L... Other bookmarks eTextbook: Financial E eTextbook: Financial Reporting, Financial Statement Analysis and Valuation ? Q TT Reporting, Financia... Quick Tour Print Search Annotations Accessibility Bookmark ... Integrative Case 1.1 Financial Statements an... Role of Financial Statement Analysis in an Efficie... 2014 2015 2016 The Association between Assets: Earnings and Share Prices Cash and cash equivalents $ 7,281 $ 9,135 $ 8,705 Accounts and notes receivable-net 6,677 6,778 5,624 Sources of Financial Statement Inventories 44,858 45,141 44,469 Information Prepaid expenses and other current assets 1,909 2,224 1,441 Current assets of discontinued segments 460 Summary Current Assets $ 61,185 $ 63,278 $ 60,239 Property, plant, and equipment-at cost 178,678 182,634 188,054 Accumulated depreciation (60,771) (65,979) (71,538 Questions, Exercises, Problems, Goodwill 19,510 18,102 16,695 and Cases Other assets 6,149 5,455 5,131 Total Assets $204,751 $203,490 $199,581 Integrative Case 1.1. Walmart Liabilities and Equities: Accounts payable $ 37,415 $ 38,410 $ 38,487 Case 1.2. Nike: Somewhere Current accrued expenses 18,793 19,152 19,607 between a Swoosh and a S... Notes payable and short-term debt 7,670 1,592 2,708 Current maturities of long-term debt 4,412 5.078 3,296 Chapter 2. Asset and Liability Income taxes payable 966 1,021 521 Valuation and Incom... Current liabilities of discontinued operations 89 The Mixed Attribute Current Liabilities $ 69,345 $ 65,253 $ 64,619 Measurement Model Long-term debt obligations 44,559 43,495 44,030 Deferred tax liabilities-noncurrent 8,017 8,805 7,321 The Complementary Nature Redeemable noncontrolling interest 1,491 and Relative Usefulness o.. Total Liabilities $123,412 $1 17,553 $115,970 Common stock + Additional paid-in capital 2,685 2,785 2,122 Asset and Liability Valuation Retained earnings 76,566 85,777 90,021 and the Trade-Off be.. Accum. other comprehensive income (loss) (2,996) (7,168) (11,597) Total Common Shareholders' Equity $ 76,255 $ 81,394 $ 80,546 Relevance and Noncontrolling interests 5,084 4,543 3,065 Total Equity $ 81,339 $ 85,937 $ 83,611 Jump to Page 61 Go Total Liabilities and Equities $204,751 $203,490 $199,581 Source: Wal-Mart Stores, Inc. Forms 10-K for the three fiscal years ended January 31, 2014, 2015, and 2016. Type here to search O 9 3:49 PM 9/11/2020