Can you check all of my work. I particularly unsure of my ratios. if ANY are wrong show your aolutions and explanations.

AutoSave 2. fx 1 C23 8020000 1 Total Current Asset 10.01 800,000.00 9.11 670,000.00 Long-term liabilities Mortgage Payable 62.3% 5,000,000.00 71.0% 5,200,000.00 Fixed Assets Bond Payable 0.0% 56 Buildings and Equitment 6.2 500,000.00 6.1% 450,000.00 Other 1.9% 150,000.00 2.7 200,000.00 11 Less Accumlated Depreciatia 1 1 90,000.00 1.1% 79,000.00 Total Long-term Liabilities 64.2 5,150,000.00 73.7% 5,400,000.00 10 Net Buildings and Equitment 31.0% 6,500,000.00 81.9% 6,000,000.00 Total Liabilities 74.3% 5.960,000.00 839 6,150,000.00 Land 12% 100,000.00 1.4% 100,000.00 20 Total Fixed Asset 89.7% 7,190,000.00 90.4% 6,629,000.00 Net Assets 21 Goodwill 0.4% 30,000.00 0.4% 30,000.00 Unrestricted 12.5% 1,000,000.00 16N 119,000.00 D.ON 0.04 Temporarily Restricted 7.59 600,000.00 600,000.00 20 TOTAL ASSETS 100 ONS 8,020,000 100.0% S 7,329,000 Permanently Restricted 5.7 460,000.00 6.3N 460,000.00 24 Total Net Assets 25.7 2,060,000.00 16.1N 1.179.000.00 TOTAL LIABILITIES & NET ASSETS 8,020,000 100 ONS 7.329,000 27 Balance income cash flow ratio formulas B H 5 2018 2017 6 Revenues % % 7 Patient Service Revenue 87.0% 87.0% 8 Premium Revenue 8.796 8.7% $100,000.00 $10,000.00 $5,000.00 $115,000.00 $80,000.00 $8,000.00 $4,000.00 $92,000.00 4.3% 4.3% 100.0% 100.096 9 Other Operating Revenue 10 Total Revenues From Operations 11 Expenses 12 Salaries and Benefits 13 Medical Supplies and Drugs 14 Insurance 15 Depreciation 39.196 32.696 13.096 Page $45,000.00 $15,000.00 $8,000.00 $6,000.00 $2,500.00 7.696 5.296 6.596 $30,000.00 $12,000.00 $7,000.00 $6,000.00 $2,500.00 $15,000.00 $72,500.00 16 Interest 2.296 2.796 17 Provision for Bad Debts 17.496 16.396 $20,000.00 $96,500.00 18 Total Expenses From Operations 83.996 78.896 13 20 Excess of Revenue Over Expenses 16.196 $18,500.00 21.296 $19,500.00 21 22 Unrestricred Contribitions 26.196 27.296 $25,000.00 $30,000.00 $20,000.00 23 Transfer to Parent 17.496 16.396 $15,000.00 24 25 Net Income 59.696 $68,500.00 64.796 559,500.00 Statement of Cash Flows For the Years Ending December 31, 2018 and December 31, 2017 2018 2017 Cash Flows from Operating Activities Collections Payments to Suppliers Payments to Employees Insurance Payments Interest Payments Other Source/(Uses) of Cash Net Cash from Operating Activities $60,000.00 $8,000.00 -$40,000.00 $8,000.00 $2,500.00 $500.00 $2,000.00 $46,200.00 -$7,500.00 -$25,000.00 $7,000.00 $2,500.00 $0.00 $4,200.00 1 Page 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 5 Cash Flows from Investing Activities 5 Increase in Marketable Securities 7 Sale of Fixed Assets Purchase of New Equipment 3 Other 20 Net Cash Used for Investing Activities 21 22 Cash Flows from Financing Activities Payment of Mortgage Principal Transfer From/(To) Parent 25 Other 26 Net Cash from Financing Activities 27 NET INCREASE/(DECREASE) IN CASH 28 CASH, BEGINNING OF YEAR 24 -$20,000.00 $22,000.00 $0.00 $42,000.00 -$40,000.00 $190.000.00 $10,000.00 -$14,200.00 $0.00 -$24 200.00 -$20,000.00 S210.000.00 MALLIEREAD nin Balance income cash flow ratio formulas Liquidity Ratios 2018 2017 Current Assets 800,000.00 $670,000.00 Current Ratio 1.0 0.9 Current Liabilities 810,000.00 $750,000.00 Cash + Marketable Securities + Receivables 575,000.00 $540,000.00 2 Quick Ratio 0.7 0.5 Current Liabilities 810,000.00 $750,000.00 Cash +Marketable Securities $150,000.00 $190,000.00 3 Days Cash on Hand = 776.6 1,346.60 Operating Expenses - Bad Debts - Depreciation)/365 $193.15 $141.10 Efficiency Ratios Net Accounts Receivable 425,000.00 350,000.00 4 Days in Accounts Receivables 1551.3 1596.9 Net Patient Revenue/365) 273.97 219.2 Account Payable 560,000.00 350,000.00 5 Days in Accounts Payable: 2258.6 1921.1 Operating Expenses-Depreciation/365 247.95 192.19 Balance income cash flow ratio formulas O O Rias hp D B E 350,000.00 Net Accounts Receivable 1551.3 425,000.00 1596.9 273.97 4 Days in Accounts Receivables 2192 (Net Patient Revenue/365) 560,000.00 350,000.00 Account Payable 2258.6 1921.1 5 Days in Accounts Payable 247.95 182.19 (Operating Expenses - Depreciation)/365 Current Liabilities 810,000.00 750,000.00 3266.8 4116.6 6 Avarage Payment Period 247.95 182.19 (Operating Expenses. Depreciation)/365 $117,000.00 Total Reve (Unrestricred Contribitions+Total Revenues From Operations) 0.0 $ 145,000.00 0.0 $8,020,000.00 7 Total Asset Turnover $7,329,000.00 Total Asset Solvency Ratios $22,000.00 Excess of Revenues over Expenses +Interest Expense 8.4 $21,000.00 8.8 $2,500.00 8 Interest Coverage $2,500.00 Interest Expense 27000 28000 Excess of Revenues over Expenses Interest Expense+Depreciation Expense Balance income cash flow + ratio formulas a B Excess of Revenues over Expenses +Interest Expense+Depreciation Expense 28000 9 Debt Service Coverage -1.4 27000 3.7 -20000 Interest Expense + Principal Payments -7500 Long-term Debt 5,400,000.00 2.5 10 Long-term Debt to Net Assets 5,150,000.00 4.6 2,060,000.00 Net Assets 1,179,000.00 Profitability Ratios Total Net Income 59500 11 Total Margin 0.5 $68,500.00 0.5 5145,000.00 Total Revenue(Unrestricred Contribitions+Total Revenues From Operations) $117,000.00 Excess of Revenues over Expenses $19,500.00 0.2 12 Operating Margina $18,500.00 0.2 $115,000.00 Operating Revenue $92,000.00 Excess of Revenues over Expenses $19,500.00 7 13 Return on Assets 9 0.0 $18,500.00 0.0 $8,020,000.00 $7,329,000.00 Total Assets 4 PRO CLE Balance income cash flow ratio formulas E hp B Formatting Tab Font Alignment Number apboard 5 Style: toSave 2 Bfo se D E IDX RED X fo D Excess of Revenues over Expenses $19,500.00 0.2 $13,500.00 0.2 $115,000.00 12 Operating Marine $92,000.00 Operating Revenue $19,500.00 Excess of Revenues over Expenses 0.0 13 Return on Assets= $18,500.00 0.0 $8,020,000.00 Total Assets $7,329,000.00 $19,500.00 Excess of Revenues over Expenses 0.0 $18,500.00 0.0 2,060,000.00 14 Return on Net Assets $1 179,000.00 Net Assets Balance income cash flow ratio formulas