please complete the formula sheet for ratio analysis
fx 30.1% of As of 2014 2013 TE 20 POE ASS Current UUDEN MITASSETS Daniel Los 345.000 SW 10 2000 5.000 FR . NE WOODS NE 0.000 SIE SEE O 1,600 OS 4.000 ME 4 H V SITE ME LO 24 WIDE NEDE 11 TO BEN 15700 11 ww FW 2 00 150 MH so SI TON NE Sound SIST 2 000 G 000 2 TOTAL Instructions Balance income cash flow ratio formulas + fx Statement or operations For the Years Ended December 31, 2014 and December 31, 2013 2014 2013 Revenues % % Patient Service Revenue $ 110,000 $ 100,000 Premium Revenue 12,500 Other Operating Revenue 10 Total Revenues From Operations 15,000 10,000 8,000 100.0% $ 135,000 100.0% $ 120,500 $ 40,000 12,000 11 Expenses 12 Salaries and Benefits Medical Supplies and Drugs Insurance Depreciation Interest Provision for Bad Debts Total Expenses From Operations 10,000 $ 45,000 15,000 15,000 20,000 30,000 48,000 $ 173,000 15,000 20,000 15,000 $ 112,000 10 Excess of Revenue Over Expenses $ (38,000) $ 8,500 Unrestricred Contribitions 24 Transfer to Parent 35,000 (28,000) 25,000 (20.000) increase(Decrease) in Unrestricted Net Asset $(31.000) $ 13,500 Instructions Balance Income cash flow ratio formulas + Community Hospital Statement of Cash Flows For the Years Ending December 31, 2013 and December 31, 2012 2014 2013 Cash Flows from Operating Activities Collections 5 75,000 $ Payments to Soplars 66,000 (10,000) 15,000.00 19.000 19,000.00 Payments to Employees Insurance Payments Interest Payments Other sources of Cash (10,000.00 (15,000) (30,000) 120,000.00 Net Cash from Operating Activities $ 11.000 22.000 Cath Flows from westing Activities Increase in Marble Securities $ Se of Food Ats 5 $ Purchase of New Event $ $ Other 5 3 Net Cash Used forest Acties 5 5 & Cashew naming Active 5 125.000 Other 0.000001 (15 000 20.000.00 NT INCREASE DECREASE IN CASA CASIE, BEGINGO YEAR CAT END OF YEAR 151.000 142.000 22.00 111000 Instructions Balance income cash flow Tato formulas Liquidity Ratios 2013 Ratios 2014 Ratios Current Assets 1 Current Ratio Current Liabilities Cash Marketable Securities + Receivables 2 Quick Ratio Current Liabilities Cash+Marketable Securities Days Cash on Hand Operating Expenses - Bad Debts - Depreciation)/365 Efficiency Ratios Net Accounts Receivable 4 Days in Accounts Receivables (Net Patient Revenue/365) 22 Account Payable 5 Days in Accounts Payable- (Operating Expenses - Depreciation)/365 Current Liabilities 6 Avarage Payment Period Operating Expenses-Depreciation)/365 Total Revenue 7 Total Amet Turnover Total Asset Selvency Rates Instructions Excess of Revenues over went interest Expense Balance income cash flow ratio formulas CRIS 7 Total Asset Turnovers 36 Total Asset 37 Solvency Ratios Excess of Revenues over Expenses Interest Expense 8 Interest Coverages Interest Expense 14 Excess of Revenues over Expenses+Interest Expense + Depreciation Expense 9 Debt Service Coverage Interest Expense + Principal Payments 4 10 Long-term Debt 10 Long-term Debt to Net Assets Net Assets 2 Profitability Ratios Total Net Income 11 Total Margins 5 Total Revenue Excess of Revenues over Expenses 12 Operating Margine Operating Revenue GA Excess of Revenues over Expenses 13 Return on Assets Total Assets Excess of Revenues over Expenses 14 Return on Net Assets Net Assets Instructions Balance income cash flow ratio formulas + 30.1% Community Hospital Statement of Financial Putin As of December 31, 2014 and December 31, 2013 2014 2014 2011 ASSETS Current Anet LIABLES & NET ASSETS Curatat 110 245.000 11 Can 16 207.000 Account Payable 1945 M. 350.000 4.000 50.000 SIN Wayable Markusble Secure 2 000 500 ON 4.000 Prepaid en ONS head 3000 12.000 14 KAS000 Total Current cu cei Net BON 157000 inceton ILIK 15000 10.000 Tati Current 26 Sood 22 15S 100.000 Papa 22 Assets 1,000 115 1s 0.000 LIS Dec o for Balance com Instruciom Home Insert Draw Formulas Data Review View Calibri (Body 14 abe Et A Tile StOEY Sx 30.1% M TO FAST Bond Patie 300.000 INFO 00.000 Vad Auto 50.000 300,000 NET 45.000 12 buildings and met 15.63 250,000 On NEST 000 4513 26 S000 NET 45.000 mated Demon Total Contable ONE 20 Toallito SO 10 1.147.00 255.000 200 200 137 Nei Buldings and out 10 N 000002 104 Land 200.00 000K 12 1000 NA TOTA 150 000 16 30.000 Ohrid 000's OOSE Tore Red 150.00 SIZE 50,000 SIME 000 100 100 19.000 $ manently TOTAL ALETS IR 0.000 SINER SELO LOOD 200 ET SE S 1.000 TOTALITNETANSET Balance income Can flow fx 30.1% of As of 2014 2013 TE 20 POE ASS Current UUDEN MITASSETS Daniel Los 345.000 SW 10 2000 5.000 FR . NE WOODS NE 0.000 SIE SEE O 1,600 OS 4.000 ME 4 H V SITE ME LO 24 WIDE NEDE 11 TO BEN 15700 11 ww FW 2 00 150 MH so SI TON NE Sound SIST 2 000 G 000 2 TOTAL Instructions Balance income cash flow ratio formulas + fx Statement or operations For the Years Ended December 31, 2014 and December 31, 2013 2014 2013 Revenues % % Patient Service Revenue $ 110,000 $ 100,000 Premium Revenue 12,500 Other Operating Revenue 10 Total Revenues From Operations 15,000 10,000 8,000 100.0% $ 135,000 100.0% $ 120,500 $ 40,000 12,000 11 Expenses 12 Salaries and Benefits Medical Supplies and Drugs Insurance Depreciation Interest Provision for Bad Debts Total Expenses From Operations 10,000 $ 45,000 15,000 15,000 20,000 30,000 48,000 $ 173,000 15,000 20,000 15,000 $ 112,000 10 Excess of Revenue Over Expenses $ (38,000) $ 8,500 Unrestricred Contribitions 24 Transfer to Parent 35,000 (28,000) 25,000 (20.000) increase(Decrease) in Unrestricted Net Asset $(31.000) $ 13,500 Instructions Balance Income cash flow ratio formulas + Community Hospital Statement of Cash Flows For the Years Ending December 31, 2013 and December 31, 2012 2014 2013 Cash Flows from Operating Activities Collections 5 75,000 $ Payments to Soplars 66,000 (10,000) 15,000.00 19.000 19,000.00 Payments to Employees Insurance Payments Interest Payments Other sources of Cash (10,000.00 (15,000) (30,000) 120,000.00 Net Cash from Operating Activities $ 11.000 22.000 Cath Flows from westing Activities Increase in Marble Securities $ Se of Food Ats 5 $ Purchase of New Event $ $ Other 5 3 Net Cash Used forest Acties 5 5 & Cashew naming Active 5 125.000 Other 0.000001 (15 000 20.000.00 NT INCREASE DECREASE IN CASA CASIE, BEGINGO YEAR CAT END OF YEAR 151.000 142.000 22.00 111000 Instructions Balance income cash flow Tato formulas Liquidity Ratios 2013 Ratios 2014 Ratios Current Assets 1 Current Ratio Current Liabilities Cash Marketable Securities + Receivables 2 Quick Ratio Current Liabilities Cash+Marketable Securities Days Cash on Hand Operating Expenses - Bad Debts - Depreciation)/365 Efficiency Ratios Net Accounts Receivable 4 Days in Accounts Receivables (Net Patient Revenue/365) 22 Account Payable 5 Days in Accounts Payable- (Operating Expenses - Depreciation)/365 Current Liabilities 6 Avarage Payment Period Operating Expenses-Depreciation)/365 Total Revenue 7 Total Amet Turnover Total Asset Selvency Rates Instructions Excess of Revenues over went interest Expense Balance income cash flow ratio formulas CRIS 7 Total Asset Turnovers 36 Total Asset 37 Solvency Ratios Excess of Revenues over Expenses Interest Expense 8 Interest Coverages Interest Expense 14 Excess of Revenues over Expenses+Interest Expense + Depreciation Expense 9 Debt Service Coverage Interest Expense + Principal Payments 4 10 Long-term Debt 10 Long-term Debt to Net Assets Net Assets 2 Profitability Ratios Total Net Income 11 Total Margins 5 Total Revenue Excess of Revenues over Expenses 12 Operating Margine Operating Revenue GA Excess of Revenues over Expenses 13 Return on Assets Total Assets Excess of Revenues over Expenses 14 Return on Net Assets Net Assets Instructions Balance income cash flow ratio formulas + 30.1% Community Hospital Statement of Financial Putin As of December 31, 2014 and December 31, 2013 2014 2014 2011 ASSETS Current Anet LIABLES & NET ASSETS Curatat 110 245.000 11 Can 16 207.000 Account Payable 1945 M. 350.000 4.000 50.000 SIN Wayable Markusble Secure 2 000 500 ON 4.000 Prepaid en ONS head 3000 12.000 14 KAS000 Total Current cu cei Net BON 157000 inceton ILIK 15000 10.000 Tati Current 26 Sood 22 15S 100.000 Papa 22 Assets 1,000 115 1s 0.000 LIS Dec o for Balance com Instruciom Home Insert Draw Formulas Data Review View Calibri (Body 14 abe Et A Tile StOEY Sx 30.1% M TO FAST Bond Patie 300.000 INFO 00.000 Vad Auto 50.000 300,000 NET 45.000 12 buildings and met 15.63 250,000 On NEST 000 4513 26 S000 NET 45.000 mated Demon Total Contable ONE 20 Toallito SO 10 1.147.00 255.000 200 200 137 Nei Buldings and out 10 N 000002 104 Land 200.00 000K 12 1000 NA TOTA 150 000 16 30.000 Ohrid 000's OOSE Tore Red 150.00 SIZE 50,000 SIME 000 100 100 19.000 $ manently TOTAL ALETS IR 0.000 SINER SELO LOOD 200 ET SE S 1.000 TOTALITNETANSET Balance income Can flow
