Use Excel skills to calculate and fill out all the blank in this file. I got trouble in those. If you can help me, I am really appreciate it. thank again.

FIN2304 Chapters 2&3 In-Class Quiz 2012 ASSETS Current Assets Cash Accounts Receivable Inventory Total $ $ 22,050 13,850 $ $ 24,650 60,550 $ $ 260,525 287,375 $ 26,850 $ 321,075 Fixed Assets Net Plant and Equipment Total Assets Earl Grey Golf Club Statement of Comprehensive Income For the year ended December 31, 2012 Sales (90% Credit) Cost of Goods Sold Gross Margin Depreciation EBIT Interest paid EBT Income Taxes 35% Net Income Less Dividends Addition to Retained Earnings Note: No disposals of Fixed Assets occurred during the year Additions to Fixed Assets were $53,307 Required: 1 Complete the missing information in the Income Statement 2 Prepare common-size analysis for the Income Statement 3 Compute the following ratios for 2012: Current Ratio Quick Ratio Inventory Turnover Receivables Turnover Average Collection period Total Debt Ratio Debt-Equity Ratio Times Interest Earned Ratio Profit Margin Return on Assets Return on Equity 4 Calculate the Following: CFO CFC CFS Change in NWC Earl Grey Golf Club Statement of Financial Position 2011 LIABILITIES AND OWNER'S EQUITY Current Liabilities $ 21,860 Accounts Payable $ $ 11,316 Notes Payable $ 22,850 9,000 $ $ $ $ 11,385 43,235 Long-Term Debt $ 85,000 Owner's Equity Common Stock $ 25,000 $ 167,840 $ 192,840 $ 321,075 $ 23,084 56,260 234,068 Other Total Retained Earnings $ 290,328 y Golf Club omprehensive Income ded December 31, 2012 $ 305,830 $ 210,935 $ 94,895 $ 11,930 Total Total Liabilities and Owner's Equity 2012 ed during the year n the Income Statement he Income Statement 2011 $ $ 19,320 10,000 $ $ 9,643 38,963 $ 75,000 $ 25,000 $ 151,365 $ 16,475 $ 176,365 $ 290,328 DATA CALCULATE: Sales Cash Interest Expense Accounts Payable Income Taxes Accounts Receivable Long-Term Debt Cost of Goods Sold Common Stock Inventory Accrued Payroll Common Shares Outstanding Retained Earnings Net Fixed Assets Depreciation Dividends Paid Other Selling and Admin Expesnes Market Price of Common share 1 Inventory Turnover Inventory What is cost of Goods Sold $ 2 Accounts Receivable Turnover is What is the average collection p Accounts Receivable is $ What are Credit Sales $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 9.5 12,500.00 9 times 24,000 3 Cost of Goods Sold Inventory Turnover is What is inventory $ 365,000 14 times 4 Current Liabilities Quick Ratio Current Assets $ 43,000 2.2 times 138,000 $ 1,560,000 43,000 14,000 9,000 12,000 22,000 80,000 960,000 200,000 78,000 5,600 20000 88,400 240,000 39,000 100,000 135,000 84 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 What is Inventory CALCULATE: NET INCOME TOTAL CURRENT ASSETS TOTAL CURRENT LIABILITIES TOTAL ASSETS TOTAL EQUITY TOTAL DEBT PROFIT MARGIN QUICK RATIO DEBT RATIO EPS GROSS PROFIT MARGIN ACCOUNTS RECEIVABLE TURNOVER ROE CURRENT RATIO PRICE EARNINGS RATIO INVENTORY TURNOVER AVERAGE COLLECTION PERIOD ROA