7:061 Done Home Depot BS Inc Stmt CF Year Ended 2019 2018 2017 2016 2015 NET SALES 108,203 100,904 94,595 88,519 83,176 Cost of Sales 71.043 66,548 62.282 58.254 54.787 GROSS PROFIT 37,160 34,356 32.313 30.265 28,389 Operating Expenses: Selling, General and Administrative 19,513 17,864 17,132 16,801 16,280 Depreciation and Amortization 1,870 1,811 1,754 1,690 1,640 Impairment loss 247 Total Operating Expenses 21,630 19.675 18.886 18.491 17,920 OPERATING INCOME 15.530 14,681 13.427 11,774 10.469 Interest and Investment Income (93) (74) (36) (166) (337) Interest Expense 1,051 1,057 972 919 830 Other 16 0 0 Interest and Other, net 974 983 936 753 493 EARNINGS BEFORE INCOME TAXES 14,556 13,698 12,491 11,021 9.976 Provision for Income Taxes 3,435 5,068 4,534 4,012 3.631 NET EARNINGS 11.121 8.630 7.957 7.009 6.345 Weighted Average Common Shares 1,137 1,178 1,229 1,277 1,338 BASIC EARNINGS PER SHARE 10 5 Diluted Weighted Average Common Shares 1,143 1,184 1,234 1,283 1,346 DILUTED EARNINGS PER SHARE 10 7 6 5 57:061 Done Home Depot BS Inc Stmt CF Year Ended 2019 2018 2017 2016 2015 2014 Cash Flows from Operating Activities: Net earnings $ 11,121 $ 8,630 $ 7,957 $ 7,009 $ 6,345 $ 5,385 Reconciliation of net earnings to net cash provided by operating activities: Depreciation and amortization 2,152 2,062 1,973 1.863 1,786 ,757 Stock-based compensation expense 282 273 267 244 225 228 Impairment loss 247 0 (144) (323) Changes in receivables, net 33 139 138) (181) (81) (15) Changes in merchandise inventories (1,244) (84 ) 769 (546) (124) 455 Changes in other current assets (257) (10) (48) (5) (199) (5) Changes in accounts payable and accrued expenses 743 352 446 888 244 505 Changes in deferred revenue 80 128 99 109 146 75 Changes in income taxes payable (42) 29 109 154 168 119 Changes in deferred income taxes 26 92 (117) 15 159 (31) Other operating activities (103) 420 (33) (104) (35) Net cash provided by operating activities 13,038 12,031 9.783 9,373 8,242 2,628 Cash Flows from Investing Activities: Capital expenditures, net of non-cash capital expenditures (2,442) (1,897) (1,621) (1,503) (1,442) (1,389) Payments for businesses acquired, net (21) (374) 144 323 Proceeds from sales of property and equipment 33 47 38 (1,666) 200) 206 Other investing activities 14 (4) 43 48 88 Net cash used in investing activities (2416) (2,228) (1,583) (2.982) (1,271) (1,507) Cash Flows from Financing Activities: (Repayments of) proceeds from short-term debt, net (220) 850 360 60 290 Proceeds from long-term debt, net of discount 3,466 2.991 4,959 3.991 1,981 5,222 Repayments of long-term debt (1,209) (543) (3,045) (39) (39) (1,289) Repurchases of common stock (9,963) (8,000) (6.880 (7,000) (7,000) (8,546) Proceeds from sales of common stock 236 255 218 228 252 241 Cash dividends (4,704) (4,212) (3,404) (3,031) (2,530) (2,243) Other financing activities (26) (211) (78) (25) (37) Net cash used in financing activities (12.420) (8,870) (7.870) (5,787) (7.071) (6,652) Change in cash and cash equivalents (1,798) 933 330 604 (100) (531) Effect of exchange rate changes on cash and cash equivalents (19 ) 124 (8) 111 (106) (34 ) Cash and cash equivalents at beginning of year 3,595 2.538 2216 1.723 1,929 2.494 Cash and cash equivalents at end of year $ 1,778 $ 3,595 $ 2,538 $ 2,216 $ 1,723 $ 1,929 SUPPLEMENTAL DISCLOSURE OF CASH PAYMENTS MADE FOR: Cash paid for income taxes $ 3,774 $ 4,732 $ 4,623 $ 3,853 $ 3,435 $ 2,839 Cash paid for interest, net of interest capitalized $ 1,035 $ 991 $ 924 $ 874 $ 782 $ 6397:061 Done Home Depot BS Inc Stmt CF Home Depot 10-K Financial Information 2019 2018 2017 2016 2015 2014 Cash and Cash Equivalents BLL'T 3.595 2.538 2,216 1,723 1,929 Receivables, net 1,936 1,952 2,029 1,890 1,484 1,398 Merchandise Inventories 13,925 12,748 12,549 11,809 11,079 11,057 Other Current Assets 890 638 608 569 1.016 895 Total Current Assets 18,529 18,933 17,724 16,484 15,302 15,279 Property and Equipment, cost 42,939 41.414 40.426 39,26 38,513 39,064 Less Accumulated Depr. & Amort. 20,564 19,339 18,512 17.075 15,793 15,716 Net Property and Equipment 22,375 22,075 21,914 22,191 22,720 23,348 Goodwill 2,252 2,275 2,093 2,102 1,353 1,289 Other Assets 847 1,246 1,235 1,196 571 602 Total Assets 44,003 44,529 42,966 41,973 39,946 40,518 Current Liabilities: Short-Term Debt 1,339 1,559 710 350 290 Accounts Payable 7,755 7,24 7.000 6,565 5,807 5,797 Accrued Salaries and Related Expenses 1,506 1,640 1.484 1,515 1,391 1,428 Sales Taxes Payable 656 520 508 476 434 396 Deferred Revenue 1,782 1,805 1,669 1,566 1,468 1,337 Income Taxes Payable 11 54 25 34 35 12 Current Installments of Long-Term Debt 1,056 1,202 542 77 38 33 Other Accrued Expenses 2.611 2.170 2.195 1.941 1,806 1,746 Total Current Liabilities 16,716 16,194 14.133 12,524 11.269 10,749 Long-Term Debt, excluding current installments 26,807 24,267 22,349 20,789 16,869 14,691 Other Long-Term Liabilities 491 440 1,855 1,965 1,844 2.042 Deferred Income Taxes 1,867 2,174 296 379 642 514 Total Liabilities 45,881 43.075 38,633 35.657 30.624 27,996 Common Stock 89 89 88 88 88 88 PIC 10,578 10,192 9,787 9,347 8,885 8,402 Retained earnings 46,423 39,935 35,519 30,973 26,995 23,180 AOCL (772) (566 (867) (898) (452) 46 Treasury stock (58,196) (48.196) (40,194) (33,194) (26,194) (19,194) Total SE (1.878) 1,454 4,333 6,316 9,322 12,522 Total Liabilities and SE 44.003 $ 44,529 42.966 41.973 39.946 40.5187:10 7 AA Agastate.view.usg.edu C Purpose of the Excel Project What was is no longer, what will be is unknown. This project is designed to help you develop some important new skills to look into the future for a path that may have a high probability for business and personal success: 1. Learn how to use the SEC EDGAR filings to prepare an Excel data base of company filings for analysis. 2. Analyze company filings using the resources/ratios provided in Chapter 5 of the textbook (see steps below). 3. Convert the ratios to visualizations that allow the user to better comprehend the information to draw conclusions and insights. 4. Include in your report minority views with an explanation of their bases. The views could be the post pandemic year economy or on the assumptions used for the forecast year. 5. Use the Beneish Model to evaluate the potential financial statement fraud and provide your input and calculations and any proposed impact on the audit plan. Steps: 1. For your group's company prepare a schedule of the last 5 years and most current interim balance sheets, and income statements. Calculate the following ratios: a. Short-term liquidity ratios: i. Current ratio ii. Quick ratio iii. Operating cash flow ratio b. Activity ratios: i. Days outstanding in accounts receivable ii Days of inventory on hand inil CCC Cash Conversion Cycle c. Pro bility ratios: i. Gross profit margin ii. Profit margin ifi. Return on assets iv. Return of equity 3. Convert each ratio into a visual presentation. 4. Prepare trend analysis on KPIs and determine those that require special attention in designing your audit plan and program. Include the trend analyses visualizations in your report. 5. Note any issues/anomalies you believe should be further analyzed. 6. Include in your ratios the most current interim information from the latest 10-Qs. 7. Using your conclusions and insights, plus what you can learn about the company's plans post pandemic, prepare a forecast of the company's income from operations for the first full post pandemic year. Provide details of what bases your team used to forecast revenue and expenses and references/citations to sources of important information used. State your forecast assumptions and how they were developed. Disclose how the Company and their industry are thinking about the future. ACCT 4610 Excel Project 8. Calculate the Beneish Model and note your conclusion on impact to the audit plan. The instructor hac nranared an Evcal enreadchest of Home Denat's 5 weare of financial A