50.1K

Verified Solution

Link Copied!

I am not sure my numbers are correct. Can you check? The ones that are incorrect can you explain where I went wrong and show your work.

I am unsure if any of my ratios are correct.

AutoSave abe DP B6 X for Liquidity Ratios 2018 2017 3 Current Assets 800,000.00 $670,000.00 5 1 Current Ratio 1.0 0.9 Current Liabilities 810,000.00 $750,000.00 7 Cash+Marketable Securities Receivables 575,000.00 $540,000.00 10 2 Quick Ratio 0.7 0.5 11 Current Liabilities 810,000.00 $750,000.00 13 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 16 17 16 13 Efficiency Ratios Net Accounts Receivable 350,000.00 4 Days in Accounts Receivables 15513 425,000.00 1596.9 273.97 21 22 23 24 (Net Patient Revenue/365) 219.2 Account Payable 560,000.00 350,000.00 26 5 Days in Accounts Payable 2258.6 1921.1 (Operating Expenses - Depreciation/365 247.95 182.19 Balance income cash flow ratio formulas Ready OBI a Clipboard Number Font Alignment 2 x G D AutoSave 02 X B10 X fo Quick Ratio Account Payable 350,000.00 24 25 26 27 28 5 Days in Accounts Payable 2258.6 560,000.00 1921.1 247.95 (Operating Expenses - Depreciation)/365 182.19 Current Liabilities 750,000.00 6 Avarage Payment Periode 3266.8 01 02 810,000.00 4116.6 247.95 (Operating Expenses - Depreciation)/365 182.19 Total Revenue (Unrestricred Contribitions Total Revenues From Operations) $117,000.00 35 36 31 7 Total Asset Turnover 0.0 $145,000.00 0.0 $8,020,000.00 Total Asset $7,329,000,00 30 Page 1 Solvency Ratios 40 41 Excess of Revenues over Expenses +Interest Expense $22,000.00 8 Interest Coverage 8.4 $21,000.00 8.8 $2,500.00 Interest Expense $2,500.00 44 46 Excess of Revenues over Expenses Interest Expense+Depreciation Expense 28000 47 9 Debt Service Coverage 27000 3.7 -20000 40 Interest Expense + Principal Payments -7500 49 50 AO Balance income cash flow ratio formulas Ready CORT 3 AutoSave 2. fx BGE X 3x B16 A D c Interest Expense Principal Payments 48 -20000 -7500 50 Long-term Debt 5,150,000.00 5,400,000.00 2.5 4.6 5210 Long-term Debt to Net Assetse 53 Net Assets 2,060,000.00 1,179,000.00 54 55 Profitability Ratios 56 Total Net Income 59500 0.5 57 58 11 Total Margin 59 60 568,500.00 0.5 $145,000.00 Total Revenue(Unrestricred Contribitions+Total Revenues From Operations) $117,000.00 6 Excess of Revenues over Expenses $19,500.00 0.2 6 12 Operating Marine 64 $13,500.00 0.2 $115,000.00 Operating Revenue $92,000.00 66 Excess of Revenues over Expenses $19,500.00 68. 13 Return on Assets 0.0 $18,500.00 00 58,020,000.00 Total Assets $7,329,000.00 TI 72 Excess of Revenues over Expenses $19,500.00 0.0 10 14 Return on Net Assets 74 $18,500.00 0.0 2,060,000.00 Net Assets $1 179,000.00 Balance income cash flow ratio formulas Ready ORE 2 autosave B B fx G D ex 23 > f 8020000 Community Hospital Statement of Financial Position As of December 31, 2018 and December 31, 2017 2018 2017 2018 2017 ASSETS Current Assets * % LIABILITIES & NET ASSETS Current liabilities * Cash 1.9 150,000.00 2.6% 190,000.00 Accounts Payable 7.0% 560,000.00 4.8% 350,000.00 Marketable Securities 0.0N 0.0% Wapes Payable 1.9% 150,000.00 1.99 140,000.00 Prepaid Expenses 0.3 25,000.00 0.4N 30,000.00 Unernad Revenue 1.24 100,000.00 2.7 200,000.00 Accounts Receivable, Net 5.3 425,000.00 4 BN 350,000.00 Total Current Liabilities 10.1% 810,000.00 10.2 750,000.00 Inventory 2.5 200,000.00 1.4N 100,000.00 Total Current Asset 10.09 300,000.00 9.1N 670,000.00 Long-term Nobilities Mortgage Payable 62 3 5,000,000.00 710N ,200,000.00 Fixed Assets Bond Payable O.ON 62 Buildings and Equitment 500,000.00 6.15 450,000.00 Other 1.9 150,000.00 2.7% 200,000.00 Less Accumlated Depreciatia 1.14 90,000.00 1.18 79,000.00 Total Long-term Liabilities 64.24 5,150,000.00 73.74 5,400,000.00 nason LEA Balance income cash flow ratio formulas eady Clipboard Font Alignment Number Styles AutoSave LL 2C-B fx at G C23 8020000 13 Total Current Asset 10.0% 800,000.00 9.1 670,000.00 Long-term liabilities 14 Mortgage Payable 62 3N 5,000,000.00 71.0% 5,200,000.00 Fixed Assets Bond Payable 0.0% M Buildings and Equitment 6.2 500,000.00 6.1% 450,000.00 Other 1.9N 150,000.00 2.7% 200,000.00 11 Less Accumlated Depreciatid 1.1% 90,000.00 1.1N 79,000.00 Total Long-term Liabilities 64.28 5,150,000.00 73.7N 5,400,000.00 * Net Buildings and Equitment 81.0% 6,500,000.00 31.9% 6,000,000.00 Total Liabilities 74.3% 5,960,000.00 83.9% 6,150,000.00 13 Land 1.2 100,000.00 1.4 100,000.00 20 Total Fixed Asset 89.7% 7,190,000.00 90.48 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 1.6 119,000.00 0.0 O.ON Temporarily Restricted 7.5 600,000.00 3.2% 600,000.00 23 TOTAL ASSETS 100 ONS 8,020,000 100.0% 5 7,329,000 Permanently Restricted 5.7% 460,000.00 6.3 460,000.00 24 Total Net Assets 25.7 2,060,000.00 16.15 1,179,000.00 26 27 TOTAL LIABILITIES & NET ASSETS w $ 8,020,000 100.0N S 7,329.000 Balance income cash flow ratio formulas + Ready DOBA as Calibri 14 - ce Wiap Paste BIU. - A Merc Clipboard Font Alignment 7 AutoSave fx Gabes 023 20000 B G 4 2018 2017 5 6 Revenues 96 96 7 Patient Service Revenue 87.096 87.096 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.396 4.396 100.0% 100.0% 9 Other Operating Revenue 10 Total Revenues From Operations 11 Expenses 22 Salaries and Benefits 39.196 32.6% 13 Medical Supplies and Drugs 3.096 13.096 Pamjena , 14 Insurance 7.696 15 Depreciation 5.296 $45,000.00 $15,000.00 $8,000.00 $6,000.00 $2,500.00 $20,000.00 596,500.00 6.5% $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 13 Total Expenses From Operations 83.996 78.896 20 Excess of Revenue Over Expenses 16.196 $18,500.00 21.296 $19,500.00 21 22 Unrestricred Contribitions 27.296 26.196 17.450 $30,000.00 $20,000.00 $25,000.00 $ 15,000.00 Transfer to Parent 16.396 24 Balance income cash flow ratio formulas Calibri > A ce Wrap La Paste BIU a. A 2011 lul Merge Clipboard Font Alignment AutoSave on 2. B fx YG ADE E B A16 X for Increase in Marketable Securities For the Years Ending December 31, 2018 and December 31, 2017 2018 2017 3 Cash Flows from Operating Activities Collections 3 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 Page 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Cash Flows from Investing Activities Increase in Marketable Securities Sale of Fixed Assets Purchase of New Equipment Other Net Cash Used for Investing Activities 1 2 Cash Flows from Financing Activities 3 Payment of Mortgage Principal Transfer From/(To) Parent Other 5 Net Cash from Financing Activities NET INCREASE/DECREASE IN CASH BCASH, BEGINNING OF YEAR CASH END OF YEAR -$20,000.00 -522,000.00 $0.00 -$42.000,00 -$40,000.00 $ 190,000.00 SI50.000,00 $10,000.00 -$14,200.00 $0.00 $24,200.00 -$20,000.00 S210,000.00 $190.000.00 Balance income cash flow ratio formulas a AutoSave abe DP B6 X for Liquidity Ratios 2018 2017 3 Current Assets 800,000.00 $670,000.00 5 1 Current Ratio 1.0 0.9 Current Liabilities 810,000.00 $750,000.00 7 Cash+Marketable Securities Receivables 575,000.00 $540,000.00 10 2 Quick Ratio 0.7 0.5 11 Current Liabilities 810,000.00 $750,000.00 13 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 16 17 16 13 Efficiency Ratios Net Accounts Receivable 350,000.00 4 Days in Accounts Receivables 15513 425,000.00 1596.9 273.97 21 22 23 24 (Net Patient Revenue/365) 219.2 Account Payable 560,000.00 350,000.00 26 5 Days in Accounts Payable 2258.6 1921.1 (Operating Expenses - Depreciation/365 247.95 182.19 Balance income cash flow ratio formulas Ready OBI a Clipboard Number Font Alignment 2 x G D AutoSave 02 X B10 X fo Quick Ratio Account Payable 350,000.00 24 25 26 27 28 5 Days in Accounts Payable 2258.6 560,000.00 1921.1 247.95 (Operating Expenses - Depreciation)/365 182.19 Current Liabilities 750,000.00 6 Avarage Payment Periode 3266.8 01 02 810,000.00 4116.6 247.95 (Operating Expenses - Depreciation)/365 182.19 Total Revenue (Unrestricred Contribitions Total Revenues From Operations) $117,000.00 35 36 31 7 Total Asset Turnover 0.0 $145,000.00 0.0 $8,020,000.00 Total Asset $7,329,000,00 30 Page 1 Solvency Ratios 40 41 Excess of Revenues over Expenses +Interest Expense $22,000.00 8 Interest Coverage 8.4 $21,000.00 8.8 $2,500.00 Interest Expense $2,500.00 44 46 Excess of Revenues over Expenses Interest Expense+Depreciation Expense 28000 47 9 Debt Service Coverage 27000 3.7 -20000 40 Interest Expense + Principal Payments -7500 49 50 AO Balance income cash flow ratio formulas Ready CORT 3 AutoSave 2. fx BGE X 3x B16 A D c Interest Expense Principal Payments 48 -20000 -7500 50 Long-term Debt 5,150,000.00 5,400,000.00 2.5 4.6 5210 Long-term Debt to Net Assetse 53 Net Assets 2,060,000.00 1,179,000.00 54 55 Profitability Ratios 56 Total Net Income 59500 0.5 57 58 11 Total Margin 59 60 568,500.00 0.5 $145,000.00 Total Revenue(Unrestricred Contribitions+Total Revenues From Operations) $117,000.00 6 Excess of Revenues over Expenses $19,500.00 0.2 6 12 Operating Marine 64 $13,500.00 0.2 $115,000.00 Operating Revenue $92,000.00 66 Excess of Revenues over Expenses $19,500.00 68. 13 Return on Assets 0.0 $18,500.00 00 58,020,000.00 Total Assets $7,329,000.00 TI 72 Excess of Revenues over Expenses $19,500.00 0.0 10 14 Return on Net Assets 74 $18,500.00 0.0 2,060,000.00 Net Assets $1 179,000.00 Balance income cash flow ratio formulas Ready ORE 2 autosave B B fx G D ex 23 > f 8020000 Community Hospital Statement of Financial Position As of December 31, 2018 and December 31, 2017 2018 2017 2018 2017 ASSETS Current Assets * % LIABILITIES & NET ASSETS Current liabilities * Cash 1.9 150,000.00 2.6% 190,000.00 Accounts Payable 7.0% 560,000.00 4.8% 350,000.00 Marketable Securities 0.0N 0.0% Wapes Payable 1.9% 150,000.00 1.99 140,000.00 Prepaid Expenses 0.3 25,000.00 0.4N 30,000.00 Unernad Revenue 1.24 100,000.00 2.7 200,000.00 Accounts Receivable, Net 5.3 425,000.00 4 BN 350,000.00 Total Current Liabilities 10.1% 810,000.00 10.2 750,000.00 Inventory 2.5 200,000.00 1.4N 100,000.00 Total Current Asset 10.09 300,000.00 9.1N 670,000.00 Long-term Nobilities Mortgage Payable 62 3 5,000,000.00 710N ,200,000.00 Fixed Assets Bond Payable O.ON 62 Buildings and Equitment 500,000.00 6.15 450,000.00 Other 1.9 150,000.00 2.7% 200,000.00 Less Accumlated Depreciatia 1.14 90,000.00 1.18 79,000.00 Total Long-term Liabilities 64.24 5,150,000.00 73.74 5,400,000.00 nason LEA Balance income cash flow ratio formulas eady Clipboard Font Alignment Number Styles AutoSave LL 2C-B fx at G C23 8020000 13 Total Current Asset 10.0% 800,000.00 9.1 670,000.00 Long-term liabilities 14 Mortgage Payable 62 3N 5,000,000.00 71.0% 5,200,000.00 Fixed Assets Bond Payable 0.0% M Buildings and Equitment 6.2 500,000.00 6.1% 450,000.00 Other 1.9N 150,000.00 2.7% 200,000.00 11 Less Accumlated Depreciatid 1.1% 90,000.00 1.1N 79,000.00 Total Long-term Liabilities 64.28 5,150,000.00 73.7N 5,400,000.00 * Net Buildings and Equitment 81.0% 6,500,000.00 31.9% 6,000,000.00 Total Liabilities 74.3% 5,960,000.00 83.9% 6,150,000.00 13 Land 1.2 100,000.00 1.4 100,000.00 20 Total Fixed Asset 89.7% 7,190,000.00 90.48 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 1.6 119,000.00 0.0 O.ON Temporarily Restricted 7.5 600,000.00 3.2% 600,000.00 23 TOTAL ASSETS 100 ONS 8,020,000 100.0% 5 7,329,000 Permanently Restricted 5.7% 460,000.00 6.3 460,000.00 24 Total Net Assets 25.7 2,060,000.00 16.15 1,179,000.00 26 27 TOTAL LIABILITIES & NET ASSETS w $ 8,020,000 100.0N S 7,329.000 Balance income cash flow ratio formulas + Ready DOBA as Calibri 14 - ce Wiap Paste BIU. - A Merc Clipboard Font Alignment 7 AutoSave fx Gabes 023 20000 B G 4 2018 2017 5 6 Revenues 96 96 7 Patient Service Revenue 87.096 87.096 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.396 4.396 100.0% 100.0% 9 Other Operating Revenue 10 Total Revenues From Operations 11 Expenses 22 Salaries and Benefits 39.196 32.6% 13 Medical Supplies and Drugs 3.096 13.096 Pamjena , 14 Insurance 7.696 15 Depreciation 5.296 $45,000.00 $15,000.00 $8,000.00 $6,000.00 $2,500.00 $20,000.00 596,500.00 6.5% $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 13 Total Expenses From Operations 83.996 78.896 20 Excess of Revenue Over Expenses 16.196 $18,500.00 21.296 $19,500.00 21 22 Unrestricred Contribitions 27.296 26.196 17.450 $30,000.00 $20,000.00 $25,000.00 $ 15,000.00 Transfer to Parent 16.396 24 Balance income cash flow ratio formulas Calibri > A ce Wrap La Paste BIU a. A 2011 lul Merge Clipboard Font Alignment AutoSave on 2. B fx YG ADE E B A16 X for Increase in Marketable Securities For the Years Ending December 31, 2018 and December 31, 2017 2018 2017 3 Cash Flows from Operating Activities Collections 3 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 Page 1 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Cash Flows from Investing Activities Increase in Marketable Securities Sale of Fixed Assets Purchase of New Equipment Other Net Cash Used for Investing Activities 1 2 Cash Flows from Financing Activities 3 Payment of Mortgage Principal Transfer From/(To) Parent Other 5 Net Cash from Financing Activities NET INCREASE/DECREASE IN CASH BCASH, BEGINNING OF YEAR CASH END OF YEAR -$20,000.00 -522,000.00 $0.00 -$42.000,00 -$40,000.00 $ 190,000.00 SI50.000,00 $10,000.00 -$14,200.00 $0.00 $24,200.00 -$20,000.00 S210,000.00 $190.000.00 Balance income cash flow ratio formulas a

Answer & Explanation Solved by verified expert

See Answer