Create a statement of cash flows. It is recommended that you note next to each data item whether it is flowing in, flowing out, or not applicable. - Create an Income Statement with sub totals for gross profit, operating profit and net profit. - Create a balance sheet. For full credit, the balance sheet should have subtotals for Current Assets. Fixed Assets. Total Assets, Current Liabilities, Long Term Liabilities. Total Liabilities, Total Owners Equity and Total Liabilities and Owners Equity Caiculate the following ratios: -Gross Profit Margin - Operating Profit Margin - Net Profit Margin - Debt to Equity -Return on Equity wiurn on asset - Current Ratio -Quick Ratio You will note that the data set for the Balance Sheet and Income statement is combined, so you will need to determine which if any of those two financial statements the datar belongs on. This data is also available as a spreadstuect on the ICON home page under the module for the week the homework is This data is also available as a spreadsheet on the ICON home pag due. It will likely be easier to use the spreadsheet and learning exc Accounts Interest Expense Accounts Payable $$2.00078,000 Revenues Utilities Expense $$625,0006,000 General Insurance Expense Accounts Receivable $4,000 Sales Tax Payable Cash Inventory Land $$125,000120,000 Cost of Goods Sold $$200,000375,000 Payroll Expense rotessional Fees Expenese \$ 180,000 Supplies Expense Buildings $$5,0002,500 Vehicles owned 700,000 Accumulated Depreciation 90,000 Credit Card balance 80,000 5-Year Bank Note Balance Outstanding 13,000 Depreciation Expense 675,000 Vehicle Expense 8,000 Bank Service Charges 4,000 Miscellaneous Expenses 500 Health Insurance Expense 3.000 Quemere Fouity 28 MacBook Air Create a statement of cash flows. It is recommended that you note next to each data item whether it is flowing in, flowing out, or not applicable. - Create an Income Statement with sub totals for gross profit, operating profit and net profit. - Create a balance sheet. For full credit, the balance sheet should have subtotals for Current Assets. Fixed Assets. Total Assets, Current Liabilities, Long Term Liabilities. Total Liabilities, Total Owners Equity and Total Liabilities and Owners Equity Caiculate the following ratios: -Gross Profit Margin - Operating Profit Margin - Net Profit Margin - Debt to Equity -Return on Equity wiurn on asset - Current Ratio -Quick Ratio You will note that the data set for the Balance Sheet and Income statement is combined, so you will need to determine which if any of those two financial statements the datar belongs on. This data is also available as a spreadstuect on the ICON home page under the module for the week the homework is This data is also available as a spreadsheet on the ICON home pag due. It will likely be easier to use the spreadsheet and learning exc Accounts Interest Expense Accounts Payable $$2.00078,000 Revenues Utilities Expense $$625,0006,000 General Insurance Expense Accounts Receivable $4,000 Sales Tax Payable Cash Inventory Land $$125,000120,000 Cost of Goods Sold $$200,000375,000 Payroll Expense rotessional Fees Expenese \$ 180,000 Supplies Expense Buildings $$5,0002,500 Vehicles owned 700,000 Accumulated Depreciation 90,000 Credit Card balance 80,000 5-Year Bank Note Balance Outstanding 13,000 Depreciation Expense 675,000 Vehicle Expense 8,000 Bank Service Charges 4,000 Miscellaneous Expenses 500 Health Insurance Expense 3.000 Quemere Fouity 28 MacBook Air
