USING THE INFORMATION BELOW, HOW WOULD I DO THE FOLLOWING? PLEASE EXPLAIN STEP BY STEP.

1.) Set up a worksheet for the liquidity ratios.

Current Maturities of Long-Term Debt $525,000 Metropolis Health System Statement of Revenue and Expense for the Year Ended March Metropolis Health System Balance Sheet March 31, 2_ Accounts Payable and Accrued Expenses 4,900,000 31, 2_ Assets Bond Interest Payable 300,000 Other professional services 13,100,000 Current Assets Reimbursement Settlement Payable 100,000 General services 3,200,000 Cash and Cash Equivalents $1,150,000 Total Current Liabilities 5,825,000 Support services 8,300,000 Assets Whose Use Is Limited 825,000 Long-Term Debt 6,000,000 Depreciation 1,900,000 Patient Accounts Receivable 7,400,000 Less Current Portion of Long-Term Debt (525,000) Amortization 50,000 (Net of $1,300,000 Allowance for Bad Debts) Net Long-Term Debt 5,475,000 Interest 325,000 Other Receivables 150,000 Total Liabilities 11,300,000 Provision for doubtful accounts 1.500.000 Inventories 900,000 Fund Balances Total Expenses 33.400.000 Prepaid Expenses 200,000 General Fund 21,500,000 Income from Operations $1,700,00 Total Current Assets 10,625,000 Total Fund Balances 21,500,000 Nonoperating Gains (Losses) Assets Whose Use Is Limited Total Liabilities and Fund Balances $32,800,000 Unrestricted gifts and memorials $20,000 Corporate Funded Depreciation 1,950,000 Interest income 80.000 Exhibit 28-2Statement of Revenue and Expense Held by Trustee Under Bond Indenture Agreement 1,425,000 Nonoperating Gains, Net 100.000 Total Assets Whose Use Is Limited 3,375,000 Metropolis Health System Statement of Revenue and Expense for the Year Ended March Revenue and Gains in Excess of Expenses and Losses $1,800,000 Less Current Portion (825,000) 31, 2_ Net Assets Whose Use Is Limited 2,550,000 Revenue Property, Plant, and Equipment, Net 19,300,000 Net patient service revenue $34,000,000 Metropolis Health System Statement of Cash Flows for the Year Ended March 31, 2_ Other Assets 325,000 Other revenue 1.100.000 Statement of Cash Flows Total Assets $32,800,000 Total Operating Revenue $35,100,000 Expenses Operating Activities Liabilities and Fund Balance $1,700,000 $5,025,000 Income from operations Current Liabilities Nursing servicesAdjustments to reconcile income from operations Exhibit 28-4 Statement of Changes in Fund Balance Patient Services Revenue ash flows from operating activities Routine revenue $9,850,000 Metropolis Health System Statement of Changes in Fund Balance for the Year Ended March 7,375,000 Depreciation and amortization 1,950,000 Laboratory 31, 2_ Radiology and CT scanner 5,825,000 Changes in asset and liability accounts General Fund Balance April 1, 2_ $19,700,000 Patient accounts receivable 250,000 OB-nursery 450,000 Revenue and Gains in Excess of Expenses and Losses 1.800.000 Other receivables (50,000) Pharmacy 3,175,000 General Fund Balance March 31, 2_ $21,500,000 Inventories (50,000) Emergency service 2,200,000 Prepaid expenses and other assets (50,000) Exhibit 28-5 Schedule of Property, Plant, and Equipment Medical and surgical supply and IV 5,050,000 Accounts payable and accrued expenses (400,000) Operating rooms 5,250,000 (25,000) Metropolis Health System Schedule of Property, Plant, and Equipment for the Year Ended Reduction of bond interest payable 1,600,000 March 31, 2_ Anesthesiology Estimated third-party payer settlements (75,000) Respiratory therapy 900,000 Buildings and Improvements $14, 700,000 Interest income received 80,000 Physical therapy 1,475,000 Land Improvements 1,100,000 Unrestricted gifts and memorials received 20.000 EKG and EEG 1,050,000 Equipment 28.900.000 Net cash flow from operating activities $3,350,000 Ambulance service 900,000 Total $44,700,00 Cash Flows from Capital and Related Financing Activities Oxygen 575,000 Less Accumulated Depreciation (26.100.000) Repayment of long-term obligations (500,000) Home health and hospice 1,675,000 Net Depreciable Assets $18,600,00 Cash Flows from Investing Activities Substance abuse 375,000 Land 480,000 Purchase of assets whose use is limited (100,000) Other 775.000 Construction in Progress 220.000 Equipment purchases and building improvements (2,000,000) Subtotal $48,500,000 Net Property, Plant, and Equipment $19,300,000 Net Increase (Decrease) in Cash and Cash Equivalents $750,000 Less allowances and charity care (14.500.000) Cash and Cash Equivalents, Beginning of Year 400,000 Exhibit 28-6 Schedule of Patient Revenue Net Patient Service Revenue $34,000,000 Cash and Cash Equivalents, End of Year $1,150,000 Metropolis Health System Schedule of Patient Revenue for the Year Ended March 31, 2_ - Exhibit 28-7 Schedule of Operating ExpensesTotal $13,100,000 Metropolis Health System Schedule of Operating Expenses for the Year Ended March 31, 2_ General Services $1,055,000 Nursing Services Dietary Routine Medical Surgical $3,880,000 Maintenance 1,000,00 Operating Room 300,000 Laundry 295,000 470,000 Intensive Care Units 395,000 Housekeeping Security 50,000 OB-Nursery 150,000 Medical Records 330.000 Other 300.000 $5,025,00 Total $3,200,000 Total Other Professional Services Support Services Laboratory $2,375,000 General $4,600,000 240.000 Radiology and CT Scanner 1,700,000 Insurance Payroll Taxes 1,130,000 Pharmacy 1,375,000 950,000 Employee Welfare 1,900,000 Emergency Service 430.000 Medical and Surgical Supply 1,800,000 Other Operating Rooms and Anesthesia 1,525,000 Total $8,300,000 1,900,000 Respiratory Therapy 525,000 Depreciation Physical Therapy 700,000 Amortization 50,000 325,000 EKG and EEG 185,000 Interest Expense Ambulance Service 80,000 Provision for Doubtful Accounts 1.500.00 Substance Abuse 460,000 Total Operating Expenses $33,400,000 Home Health and Hospice 1,295,000 Other 130.000