Number Styles A75 X fr '7. What was Apple's Current Ratio at the end of 2018 B E F H D G 1 BUS333 - Week 6 2 Chapter 3 (Working with Financial Statements); Chapter 4 (Long-Term Financial Planning) 3 5 Identify each of the following as either OPERATING, INVESTING, or FINANCING activity on a Statement of Cash Flows? 12 -- A 13 1. Dividends Paid: 14 -- Select One Operating Investing Financing 15 V 16 17 2. Decrease in Accounts Payable 18 A -- Select One Operating Investing Financing 19 V 20 21 3. Cost of Goods Sold A 22 -- Select One -- Operating Investing Financing 23 24 25 4. Capital Expenditures (increase in fixed assets) A 26 -- Select One - Operating Investing Financing 27 28 29 5. Principal Repayment on Debt 30 31 32 33 6. Income Tax Payments 34 -- Select One -- Operating Investing Financing v -- Select One -- Operating Investing Sheet1 Edit WT X Font 000 ormat as Neutral Table- Alignment Formatting A75 Number X 17. las Apple's Styles nt Ratio at end of 2018 C G B D H 1 BUS333 - Week 6 2 Chapter 3 (Working with Financial Statements); Chapter 4 (Long-Term Financial Planning) 3 33 6. Income Tax Payments -- Select One 34 Operating Investing 35 Financing 36 37 38 For questions #7-20, refer to the following financial information for Apple Inc. (all numbers are in Smillions): 39 2017 2018 40 41 BALANCE SHEET: 42 Assets: 43 Cash 44 Accounts Receivable 45 Inventory 46 Other Current Assets 47 Fixed Assets, net 48 Investments 49 Total Assets $74 181 35 673 4 855 13 936 33 783 212 891 $375 319 $66 301 48 995 3 986 12 057 41 304 233 082 $405 725 50 51 52 53 54 55 56 Liabilities and Equity: Accounts Payable Other Current Liabilities Long-term Debt Other Noncurrent Liabilities Common Stock Sheet1 $44 242 50 226 103 703 43 251 35 567 $55 888 55 416 102 519 48 209 33 293 Edit Clipboard Formatting Table Font Alignment Number A75 X 17. Vhat was Apple urrent Ratio at the end of 2018? G H B 1 BUS333 - Week 6 2 Chapter 3 (Working with Financial Statements); Chapter 4 (Long-Term Financial Planning) 3 2017 2018 40 41 BALANCE SHEET: 42 Assets: 43 Cash 44 Accounts Receivable 45 Inventory 46 Other Current Assets 47 Fixed Assets, net 48 Investments 49 Total Assets $74 181 35 673 4 855 13 936 $66 301 48 995 3 986 12 057 41 304 233 082 $405 725 33 783 212 891 $375 319 50 51 52 53 54 Liabilities and Equity: Accounts Payable Other Current Liabilities Long-term Debt Other Noncurrent Liabilities Common Stock Retained Earnings Total Liabilities and Equity 55 $44 242 50 226 103 703 43 251 35 567 98 330 S375 319 $55 888 55 416 102 519 48 209 33 293 110 400 S405 725 56 57 58 59 60 FY2018 61 INCOME STATEMENT: 62 Revenue 63 Cost of Goods Sold 1.1. Sheet1 $265 595 163 756 E Edit Alignment Number A75 '7. What was Apple's Current Ratio at the end of 2018 D F B E 1 BUS333 - Week 6 2 Chapter 3 (Working with Financial Statements); Chapter 4 (Long-Term Finan 3 59 60 FY2018 61 INCOME STATEMENT: 62 Revenue $265 595 63 Cost of Goods Sold 163 756 64 General and Administrative 14 793 65 Depreciation Expense 10 903 66 Earnings Before Interest and Taxes 76 143 67 Interest Expense 3 240 68 Pretax Net Income 72 903 69 Income Taxes 13 372 70 Net Income $59 531 71 72 73 YOU MUST SHOW ALL CALCULATIONS TO EARN CREDIT (insert rows where neede 74 75 1 of 2018? Merge & Center % Format Painter Clipboard Conditional Format as Neutral Formatting Table Font Alignment Number M87 E G B 1 BUS333 - Week 6 2 Chapter 3 (Working with Financial Statements); Chapter 4 (Long-Term Financial Planning) 3 73 YOU MUST SHOW ALL CALCULATIONS TO EARN CREDIT (insert rows where needed): 74 75 7. What was Apple's Current Ratio at the end of 2018? 76 77 8. What was Apple's Quick Ratio at the end of 2018? 78 79 9. What was Apple's Debt to Equity Ratio at the end of 2018? (AP is not part of Debt for purposes of this calculation) 80 81 10. What was Apple's Times Interest Earned Ratio in 2018? 82 83 11. Assuming that all Apple's sales in fiscal 2018 were on credit, how many days, on average, did it take Apple to sell its inventory in 2018? 84 (For balance sheet accounts, use the average of the beginning and end-of-year balances). 85 86 12. Assuming that all Apple's sales in fiscal 2018 were on credit, what was the company's Days Sales Outstanding in 2018? 87 (For balance sheet accounts, use the average of the beginning and end-of-year balances). 88 89 13. How much did Apple pay out in dividends during fiscal 2018? 90 91 14. What was Apple's dividend payout ratio during fiscal 2018? 92 93 15. What as Apple's Equity Multiplier for 2018? 94 95 16. What was Apple's Return on Equity for 2018? 96 (For balance sheet accounts, use the average of the beginning and end-of-year balances). Sheet1 Times New Ro - 12 Wrap Text do Cut Ee Copy - * Format Painter Custom 1. D. Normal Paste BTU Merge & Center - - % Conditional Format as Neutral Formatting Table Clipboard Font Alignment Number Styles M87 fr C E G H B D F 1 BUS333 - Week 6 2 Chapter 3 (Working with Financial Statements); Chapter 4 (Long-Term Financial Planning) 3 89 13. How much did Apple pay out in dividends during fiscal 2018? 90 91 14. What was Apple's dividend payout ratio during fiscal 2018? 92 93 15. What as Apple's Equity Multiplier for 2018? 94 95 16. What was Apple's Return on Equity for 2018? 96 (For balance sheet accounts, use the average of the beginning and end-of-year balances). 97 98 17. If Apple had an average of 4,337 million common shares outstanding during 2018 and its stock is currently worth $195 per share, 99 what is its Price : Earnings (PE) ratio? 100 101 18. If the analysts who follow Apple project 2019 sales to increase by 7.4% over 2018, its after-tax profit margin to remain the same, 102 and anticipate a 60% dividend payout ratio, what are the projected retained earnings by the end of 2019? 103 104 19. Assuming that Apple's net working capital is expected to vary directly with sales, based on a projected 7.4% sales increase in 2019, 105 what is the projected accounts receivable balance at the end of 2019? 106 107 20. If the management of Apple projects that by the end of 2018, it was operating at 62% of capacity, what is its full level capacity of sales? 108 109 110 111 112