ACC 2010 Pro 3 Fall 2019-1 - Excel Aurtenbos D File Home X Cut E Insert View Comments Page Layout Formulas Calibri -1 ** BI O A rent Data Review ===> 3 Hep Tel me what you want to do Wup Tat Caracal - 07 Marge & Carrier - $ % - % ) 548 Condronal format Formatting Table Copy Normal Check Cell Bad E xploratory... Good put Neutral Linked Cell Share Dutalum - 47 0 Sort & Find & F -Select- Cakulation Nute Insert Delete commet - 3 Format Panter C C D G H I J K L M N O P Q R S T U V PROJECT INFORMATION You have been given financial statements for Amazon and Walmart (Income Statemeet, Balzece Steet and Statement of Cash Flowy). For des rect, you will use the information in those statements to compute the rates respuestal on the Rates Tah SUGGESTED STEPS FOR COMPLETION OF THE PROJECT: CON BONN Determine what amounts are needed to calculate the ratios requested For example you need C i Axuty Cunnilines to complex Cum Race Enter of the is nended in the boxes in cohan A for each of the ratios. See Ratios Tal com A for Curent Ratio Nertuce the cell reerence function and any other necessary formulas to enter the mubers for each of the items for each of the companies in the boxes under the requested ratios. Again see Ratios Tab Ceres Cand for the mont Ranfor Walms and for Amazon Next use the members you lave entered to calculate the ratios requested Again see the Ratios Tab Cohes cand for CET Rate for Walmart and for Amazon. ROUND ALL RATIO AMOUNTS TO 3 DECIMAL PLACES Repeat the steps for each of the ratios listed on the Ratio Tab SS Assume all sales were on credit where cessary. Final step-So that we can see your use of formas you must use the followice steps to display your formulas for the ratios on the Ratios Forma Tab. Copy all of the Ratios information from the Ratios Tablou firmutstab Hicheelsmin and Jeeschley and the key This will cause the formas used to display instead of the numbers. Save your de with the formulas displayed on the Ratio Formulas Tab page and the members displayed on the Ratios POSSIBLE 5 POINTS EXTRA CREDIT For an opportunity to earn 5 points or credit, please read the posted article Wallfart has already lost its battle with Amazon". Prepare al-I page (max) double spaced paper with your opinion on the statements in the article. For the potential to carm the full 3 points Into and Instructions Amazon Walmart Ratios Ratio Formuss ACC 2010 Proj3 Fall 2019-1 - Excel Aurinbow @ File Home X Cut 2 9 Insert Page Layout Share Comments Formula A . A Data REVICH === = View Hep Wap Tunt Mye Cami- um 47 4 Tell me what you want to do Number - Normal Normal $ % ) * Conditions Formats Check Cell Formatting Table Number Ball Exploratory ... Good Input Neutral linked Cell Cakulation Note Deere To 3 format Panter So Insert BIL Clear find F liesdal . Editing X 2104 1 Amazon Financial Statement Dec. 31, 2018 De Consolidated Statements Of Operations - USD ($) shares in Millions, $ in Millions 12 Months Fnded Dec 31, 2018 Dec 31, 2017 $ 232,887 $177,866 Dec 31, 2016 $ 135,987 4 Total net sales 5 Operating expenses: Cost of sales 7 Fulfillment 8 Marketing Expense Technology and content 4,265 139,156 34,027 13,814 28,837 Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Marketable securities Inventories Accounts receivable, net and other Total currenlassels Property and equipment, net 111,934 25,749 10.069 22,620 $31.750 9.500 1/1/4 16,677 75,101 61.797 17,619 7,233 16,085 4.336 3,674 2,432 14.548 214 167 11 202 162,648 220,466 12,421 173,760 4,106 131.801 4,186 100 10 General and administrative 11 Other operating expense, net 12 Total operating expenses 13 Operating Income (less) 14 Interest income 15 Interest expense 16 Other Income (expensel.net 17 Total non operating income expense) 18 Income before income taxes 19 Provision for income taxes 20 Equity-method investment activity, net of tax 21 Net Income Basic camnings per share 1848) 346 1434) 90 1,417 1183) (1,160) 11,261 1,197 38,192 23.663 6.536 68,391 23,495 27,213 1300) 1769) 3,892 (1.125) 196) $ 10,073 $ 20. $ 3,033 $6.32 $2371 $5.01 Goodwill Other assets Total assets Current liabilities: Accounts payable Accrued expenses and other Uncanned revenue Total current liabilities Long-term debt Other long-term liabilities Commitments and contingencies (Note 7) Stockholders' equity Preferred stock. S0.01 par value: Authorized shares 500 Issued and outstanding shares none Common stock. $0.01 par value: Authorized shares 5,000 Issued shares 507 and 514 Outstanding shares.484 and 491 Treasury stock, at cost Additional pald-In capital Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' cquity Diluted camings per share $ 20.14 $6.15 $ 4.90 482 490 474 500 484 24 Weighted average shares used in computation of carnings per share: 25 Basic in shares) 26 luted (In shares) 27 Net product sales 28 Totaal net sales 29 Net service sales 30 Total net sales 11.837) 26.29: 11.035) 19,525 43.549 $ 162,648 $ 141,915 $ 118,573 $ 94,665 $ 90,972 $ 59,293 $ 41,322 33 word instructions Amaron walmart Ratios Ratio Formulas Ray - + 107% Share Comments XC AutoSamson ACC 3070 PO3 Fal 2019-1 - Excel File Home r oert Page Layout Formulas Data Review Vich Help Tell me what you want to do Calitri -11 . ** === Wrap Test Number : EZ Normal Bad romat Printer BI... 04 RTU. . A.EE . E E s ger Center s ter. $.% $. 8 Cond bonal Formats Check Cell Exploratory... Fruiting Table Cliphard Alinnen Nurmber - X 2104 LUCopy Good Input Neutral Linked Cell Calculation Nute Treet Delete Format * Sort & Find Ch Flix-Select- S T U V W 7 Man NO AD A NG HN Cowdated statement at Caths-Uni Sin Miti 12 Munich Ended D. 31, 2018 31, 2017 Dec 31, 2015 CASH CASH REJIVALENTS AND RESTRICTED CASH TGINNING OF PERIOD 5 21.456 $ 19934 $16.175 20.075 2971 Ad en 15 reconcile ser inne 10 net cash from per attiec Depreciation of property and equipment and other amortization, including 15,341 11429 8116 AS SUR Odrer operating expense.net Cuner expense income.net Deferred income In peruling Jasad bilis CIJI (4.7821 7.100 Accounts payable HP en And the 14,365 17,203 Mercach provided by used in sperating activitier INVESTING ACTIVITIES Purchases of property and esulent 111 955 Proceeds from property and equipment incentives 1. Acuisicions, et of cash aceuired, and other Sales and maurities of marketable Securities Puis ulmarkabuntis Metush provided by used in any w (12.7311 1270341 17,2001 19,516 Proceeds from lan d ebat and other Repayment of langt debt and other Freinalement napital obligatione (1.30 1954 Per cash provides by used in tinencing activitier Foreign currency Mect or cash.cash equivalents, and restricted cash Mer increase (decresse in cash, cash equivalents, and restricted cash CASH, CASH EQUIVALENTS, AND STRICTED CASH END OF PERIOD SUPPLEMENTAL CASH FLOW INFORMATION Cash paid for interest on lon cebi Cash paid for interest on capital and finance les obligations Cash paid for income escurofunda Property and in ty der pilalle Property and equipment acquired under build-to-suite 53541 31 209 into and Instructions Amazon Walmart Ratios Ratio Formulas Ready W AutoSave Of Holz ACC 3010 Proj 3 Fall 2019-1 - Excel Page Layout Formulas Data Review View Help Tell me what you want to do Calibri 11 A = = = 1. ab Wrap Text General Neutral Calculation File Home Insert X Cut Lo Copy - Paste Format Painter Clipboard Bad Explanatory... Normal Conditional Format as Check Cell Formatting* Table Good Input D BI A S E Merge & Center, $ % 949.00 Insert Linked Cell Note Font Alignment Number Styles G41 BC F H 1 Walmart Financial Statements Jan. 31, 2019 Jan. 31, 2018 Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 12 Months Ended Jan. 31, 2019 Jan. 31, 2018 3 Jan. 31, 2017 Consolidated Balance Sheets - USD ($) $ in Millions Current assets: Cash and cash equivalents Receivables, net Inventories $ 510,329 4,076 $ 495,761 4,582 $ 481,317 4,556 $ 7,722 6,283 44,269 $ 6,756 5,614 43,783 514,405 500,343 485,873 3,623 61,897 3,511 59,664 385,301 107,147 21,957 373,396 106,510 20,437 361,256 101,853 22,764 185,810 (81,493) 104,317 185,154 77,479 107,675 1,975 371 (217) 2,129 2,044 323 (100) 2,267 4 Revenues: 5 Net Sales Membership and other income 6 7 Total revenues 8 Costs and expenses: 9 Cost of sales 10 Operating, selling, general and administrative expenses 11 Operating income 12 Interest: 13 Debt 14 Capital lease and financing obligations 15 Interest income 16 Interest, net 17 Loss on extinguishment of debt 18 Other (gains) and losses 19 Income before income taxes 20 Provision for income taxes 21 Consolidated net income 22 Consolidated net income attributable to noncontrolling interest 23 Consolidated net income attributable to Walmart 24 Net income per common share: 25 Basic net income per common share attributable to Walmart 26 Diluted net income per common share attributable to Walmart 27 Weighted average common shares outstanding: 28 Basic 29 Diluted 30 Dividends declared per common share 1,978 352 (152) 2,178 3,136 0 15,123 4,600 10,523 (661) $9,862 12,760 (5,682) 7,078 31,181 14,822 219,295 12,703 (5,560) 7,143 18,242 11,798 204,522 8,368 11,460 4,281 7,179 (509) $ 6,670 20,497 6,204 14,293 (650) $ 13,643 5,225 47,060 22,159 Prepaid expenses and other Total current assets Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net Property under capital lease and financing obligations: Property under capital lease and financing obligations Less accumulated amortization Property under capital lease and financing obligations, net Goodwill Other long-term assets Total assets Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Capital lease and financing obligations due within one year Total current liabilities Long-term debt Long-term capital lease and financing obligations Deferred income taxes and other Commitments and contingencies Equity: Common stock Capital in excess of par value Retained earnings Accumulated other comprehensive loss Total Walmart shareholders' equity Noncontrolling interest Total equity Total liabilities and equity 428 $ 2.28 $ 2.26 $ 3.29 $ 3.28 $ 4.40 $ 4.38 1,876 729 77,477 43,520 6,683 11,981 5,257 46,092 22,122 645 3,738 667 78,521 30,045 6,780 8,354 2,929 2,945 $ 2.08 2,995 3,010 $ 2.04 3,101 3,112 $ 2 288 2,965 80,785 (11,542) 72,496 7,138 79,634 $ 219,295 295 2,648 85,107 (10,181) 77,869 2,953 80,822 $ 204,522 AutoSave Off Hb ACC 3010 Proj 3 Fall 2019-1 - Excel Page Layout Formulas Data Review View Help Tell me what you want to do Calibri 11 = = = 1. 2 F2 File Home Insert X Cut Lo Copy - Paste Format Painter Clipboard A A ab Wrap Text 3 Merge & Center - General $ -% Number - 8-98 Normal Check Cell BIU - 2 Formatting* Table Font Alignment G41 NO P Q R S Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended Jan. 31, 2019 Jan. 31, 2018 Jan. 31, 2017 $ 7,179 $ 10,523 $14,293 10,529 10,080 10,678 3,516 4,850 (499) (304) 3,136 1,210 0 761 0 206 1,734 (368) (1,311) 1,831 183 (40) 27,753 (1,074) (140) 4,086 928 (557) 28,337 (402) 1,021 3,942 1,280 492 31,673 10,344 519 876 10,051 378 1,046 10,619 456 662 Cash flows from operating activities: Consolidated net income Adjustments to reconcile income from continuing operations to net cash provided by operating activities: Depreciation and amortization Unrealized Gain (Loss) on Investments (Gains) and losses for disposal of business operations Deferred income taxes Loss on extinguishment of debt Other operating activities Changes in certain assets and liabilities, net of effects of acquisitions: Receivables, net Inventories Accounts payable Accrued liabilities Accrued income taxes Net cash provided by operating activities Cash flows from investing activities: Payments for property and equipment Proceeds from the disposal of property and equipment Proceeds from the disposal of certain operations Purchase of available for sale securities Payments for business acquisitions, net of cash acquired Other investing activities Net cash used in investing activities Cash flows from financing activities: Net change in short-term borrowings Proceeds from issuance of long-term debt Repayments of long-term debt Premiums paid to extinguish debt Dividends paid Purchase of Company stock Dividends paid to noncontrolling interest Purchase of noncontrolling interest Other financing activities Net cash used in financing activities Effect of Exchange Rate on Cash, Cash Equivalents, and Restricted Cash Net increase (decrease) in cash, cash equivalents and restricted cash Cash, cash equivalents and restricted cash at beginning of year Cash, cash equivalents and restricted cash at end of period Supplemental disclosure of cash flow information: Income taxes paid Interest paid (14,656) (431) (24,036) (375) (77) (9,079) (1,901) (2,463) (31) (13,896) (53) 15,872 (3,784) (1,673) 137 (2,055) 4,148 7,476 (13,061) (3,059) 6,124 (8,296) (690) 6,102 (7,410) (431) (261) (19,875) 6,216 (8,298) (479) (90) (398) (19,072) (452) (1,747) 8,891 7,144 (629) (2,537) (438) 742 7,014 7,756 487 (130) 7,144 7,014 3,982 $ 2,348 6,179 $ 2,450 4,507 $ 2,351 AutoSave Of Holz - AC Page Layout Formulas Data Review View Help Tell me what you want to do Calibri = = General 11 - A - A- = S 1. E ab Wrap Text 3 Merge & Center - BIU - 58 58 File Home Insert X Cut Lo Copy - Paste Format Painter Clipboard A13 : A $ -% Number Formatting Font Alignment for G H I J Ratios WALMART AMAZON 5 Current Ratio 0.799 1.098 8 Current Assets 61,897 61,897 | 75,101 9 77,477 68,391 10 Current Liabilities 11 12 13 Debt to Asset Ratio Non non Return on Equity Return on Assets 35 Inventory Turnover 164 B C D E F G H I J 42 Days in Inventory 46 48 49 Accounts Receivable Turnover Times Interest Earned don more on dan 65 Free Cash Floy 73 75 Gross Profit Rate 77 82 Profit Margin 89 Asset Turnover