Using the information provided below, students are asked to determine the following information. In order do so, students will need to create a balance sheet, an income statement, and a statement of cash flow. Students should use Excel to create each sheet Balance Sheet as of June 30, 20XX 1. Total current assets 2. Total long-term (fixed) assets 3. Total Assets 4. Total Current Liabilities 5. Total Long-term (Fixed) Liabilities 6. Total Liabilities 7. Total Equity Income Statement as of June 30, 20XX 1. Total Revenue 2. Total Expenses 3. Earnings Before ITDA 4. Net Income Statement of Cash Flows for Year Ending June 30, 20XX **Hint: Keep in mind some of the numbers may be negative. For example, a payment is funds leaving the organization, thus is a negative number. 1. Total from Operating Activities 2. Total from Investing Activities 3. Total from Financing Activities 4. Total Statement Account Payable Account Receivable Administrative Services Allowance for Bad Debts Bad Debt Expense Bond Payable (due in 2050) Cash Cash paid to employees Cash paid to suppliers Collections from patients / third-party payers Dividends Paid Earnings from Investments Employee Benefits Housekeeping Services Increase in Inventory Interest Paid Inventory Investment (Maturity in 2050) Land Maintenance of Facility Mortgage Payable Other Operating Revenue Patient Care Supplies Patient Revenue Payment of mortgage principal Prepaid Assets Proceeds from issuing stock Rent and Leases Taxes Payable Wages for Clinical Services Wages Payable 912,000 1,972,000 650,000 200,000 262,000 980,000 1,589,000 675,000 15,865 720,000 50,000 56,000 600,000 722,000 84,000 1,500 726,000 500,000 362,000 19,500 1,000,000 1,800,000 416,000 8,300,000 45,000 105,500 150,000 568,700 320,000 1,412,000 675,000 Using the information provided below, students are asked to determine the following information. In order do so, students will need to create a balance sheet, an income statement, and a statement of cash flow. Students should use Excel to create each sheet Balance Sheet as of June 30, 20XX 1. Total current assets 2. Total long-term (fixed) assets 3. Total Assets 4. Total Current Liabilities 5. Total Long-term (Fixed) Liabilities 6. Total Liabilities 7. Total Equity Income Statement as of June 30, 20XX 1. Total Revenue 2. Total Expenses 3. Earnings Before ITDA 4. Net Income Statement of Cash Flows for Year Ending June 30, 20XX **Hint: Keep in mind some of the numbers may be negative. For example, a payment is funds leaving the organization, thus is a negative number. 1. Total from Operating Activities 2. Total from Investing Activities 3. Total from Financing Activities 4. Total Statement Account Payable Account Receivable Administrative Services Allowance for Bad Debts Bad Debt Expense Bond Payable (due in 2050) Cash Cash paid to employees Cash paid to suppliers Collections from patients / third-party payers Dividends Paid Earnings from Investments Employee Benefits Housekeeping Services Increase in Inventory Interest Paid Inventory Investment (Maturity in 2050) Land Maintenance of Facility Mortgage Payable Other Operating Revenue Patient Care Supplies Patient Revenue Payment of mortgage principal Prepaid Assets Proceeds from issuing stock Rent and Leases Taxes Payable Wages for Clinical Services Wages Payable 912,000 1,972,000 650,000 200,000 262,000 980,000 1,589,000 675,000 15,865 720,000 50,000 56,000 600,000 722,000 84,000 1,500 726,000 500,000 362,000 19,500 1,000,000 1,800,000 416,000 8,300,000 45,000 105,500 150,000 568,700 320,000 1,412,000 675,000