you will be using the Microsoft Excel Participant Template provided below. Each of the tasks will build on sections of the template that you have completed in prior tasks, so please ensure that you have your progress on the template saved.
For this first task, please navigate to the first tab of the template labeled “Financial Summary” and enter the 2017 figures using Davis Industries’ 10-K filing provided below. The areas highlighted in yellow (Columns “D” and “I”) indicate which items you will need to fill out to complete the task. The filing is highlighted in the left margin to help you out.
(1) Income Statement
Enter the following line items from Davis Industries’ 2017 Income Statement: Revenue, Gross Profit, Operating income, and Net income.
(2) Balance Sheet
Enter the following line items from Davis Industries’ 2017 Balance Sheet: Cash, Accounts Receivable, Inventory, Accounts Payable, Total Debt, and Equity.
(3) Cash Flow Statement
Enter the following line items from Davis Industries’ 2017 Cash Flow Statement: Cash flow from operations, Capital expenditures, Acquisitions, and Dividends paid.