using the information from the Vulcan Community Hospital Balance Sheet, complete the income statement, balanace sheet, cash flow statement, and ratio analysis. The formulas for the ratio analysis are provided, just provide the answers .
Hint the below information is necessary for you to complete the assignment Vulcan Community Hospital Balance Sheet and eration Statements accounts, End of 201 Cash Accounts Receivable,Net Inventory Prepaid Expense Net Building and Equipment Land Goodw ill $750,000 $ 75,000 $ 170,000 $ 25,000 s 205,000 $ 200,000 $ 300,000 Salaries and Benefits Medical Supplies and Drugs Insurance Depreciation Interest Provision for Bad Debts Other Operating Expenses $5,500 $ 10,000 $ 5,000 $15,000 700,000 $8,000 $6,000 $ 500,000 $ 350,000 Accounts Payable a Wages Payable Mortgage Payable $175,000 $ 350,000 $ 250,000 100,000 Unrestricted Temporarily Restricted Permanently Restricted Net Patient Services Revenue Premium Revenue Other Operating Revenue Unrestricted Contributions $ 750,000 150,000 $5,000 $12,000 Student info InstructionsJournal Entrie MRA I1 Assignment 2018, corrected [Compatibility Mode] Excel Home Insert Draw Page Layout Formulas Data ReviewView Tell me what you want to do S Cut Copy SForma, Panter ipboard Times New Rernal12 B 1 u-:- -KA-E > . A- Wrap Tert General Condtional Format as Formatting Table Merge & Center . $ . % , y Font Numbet tyles VULCAN COMMUNITY HOSPITAL Balance Sheet As of December 31, 2018 Liabiliries Current Assets Cash Accounts Receivable, Net Current liabilines Accounts Payable Wages Payable Total Current Liabiities Long-term liabiliries Mortgage Payable Total Long-term Eablities Prepaid Expense Total Current Assets Total Liabilities Fixed Assets Net Building and Equipment Land Total Ficed Assets Net Assers Unrestricted Temporanly Restricted Total Net Assets Goodwi TOTAL ASSETS TOTAL LIABILITIES &NET ASSETS ournal Entries Not-for-Profit Ledger Income Statement ation and press ENTER or choose Paste Type here to search MRA II Assig Insert Draw Page Layout Formulas Data Review View Arial 112-Ka" -- 9-12 Wrap Text Format Painter l B 1 u! A- 1 Merge & Home Cut Copy . ipboard Font Alignment VULCAN COMMUNITY HOSPITAL Statement of Cash Flows For the Year Ending December 31, 2018 Cash Flows from Operating Activities Collections Payments to Sellers Payments to Employees Insurance Payments interest Payments Net Cash from Operating Activities Cash Flows from Investing Activities Purchase of New Equipment Net Cash Used for Investing Activities Cash Flows from Financing Activities Payment of mortgage principal Net Cash from Financing Activities NET INCREASE/(DECREASE) IN CASH CASH BEGINNING OF YEAR CASH, END OF YEAR ;.; MRA IAssignment 2018 File Home Insert Draw Page Layout Formulas Data Review View Tell m Cut Times New Roma 114 -ka"-- 9- wrap Tent copy . Paste ,Format Painter Blu. E.IO-A-1 !Merge & Center. Clipboard Font Alignment F11 VULCAN COMMUNITY HOSPITAL FINANCIAL RATIOS Cureeet Assets 1 Current Ratio s Curenr Lisbilities n2 Quick Ritio i Currene Liablies Cash-Marketable Secunties , Dagi Cash onHand Bad Debts Elficiency Ratios Net Accounts Receivable 4 Dags in Accounts Receivab (Net Patient Revenue 365) Account Pagable 5 Days in Accounks Payables Operating Expences Depreciation) 35 Current Liabiities Avaage Payment Petiod Operating Expenses Depreciation)/385 Total Raue Income Statement BalanceSheet CashFlow Statement Ratio analyses Select destination and press ENTER or choose Paste O Type here to search MRA Home Insert Draw Page Layout Formulas Data Review File 9- wrap Times New Roma-114-..^^ BIW-1. -= X Cut Paste Format Painter Clipboard Alignment Font F11 Total Revenue 7 Total Asset Tumovers Total Asset rencg Ratios Excess of Fevenues over Expenses Interest Expense l & merest Coverages Interest Expense Excess of Revenuws over Expenses Interest Expense Depreciation Expense hterest Expeinse Plincipal Pagments Long-term Det 1o Long-twm Debt to Net Asse Net Assets Profitability Ratios Total Net hcome Total Rever Encess of Revenues ow Expenses Exsess of Peveues over Expenses Tors Asseta Fleun on Assets, teika destinastion and pres ENTER er choozs Paste elancesheet ashFlow Statement Ratio analyses Type here to search Home Insert Draw Page Layout Formulas Data Review File : Times New Roma 14 -Ka" Ep Copy Paste Alignment Clipboard Font F11 Net Assets Profitability Ratios 57 Total Net Incom s11 Total Margin Total Revenue Excess of Revenues over Expenses 12 Operating Margins Operating Revenue Excess of Revenues over Expenses 69-13 Return on Assets Total Assets Encess of Revenues over Expences 14 14 Return on Net Assetss Net Assets Hint the below information is necessary for you to complete the assignment Vulcan Community Hospital Balance Sheet and eration Statements accounts, End of 201 Cash Accounts Receivable,Net Inventory Prepaid Expense Net Building and Equipment Land Goodw ill $750,000 $ 75,000 $ 170,000 $ 25,000 s 205,000 $ 200,000 $ 300,000 Salaries and Benefits Medical Supplies and Drugs Insurance Depreciation Interest Provision for Bad Debts Other Operating Expenses $5,500 $ 10,000 $ 5,000 $15,000 700,000 $8,000 $6,000 $ 500,000 $ 350,000 Accounts Payable a Wages Payable Mortgage Payable $175,000 $ 350,000 $ 250,000 100,000 Unrestricted Temporarily Restricted Permanently Restricted Net Patient Services Revenue Premium Revenue Other Operating Revenue Unrestricted Contributions $ 750,000 150,000 $5,000 $12,000 Student info InstructionsJournal Entrie MRA I1 Assignment 2018, corrected [Compatibility Mode] Excel Home Insert Draw Page Layout Formulas Data ReviewView Tell me what you want to do S Cut Copy SForma, Panter ipboard Times New Rernal12 B 1 u-:- -KA-E > . A- Wrap Tert General Condtional Format as Formatting Table Merge & Center . $ . % , y Font Numbet tyles VULCAN COMMUNITY HOSPITAL Balance Sheet As of December 31, 2018 Liabiliries Current Assets Cash Accounts Receivable, Net Current liabilines Accounts Payable Wages Payable Total Current Liabiities Long-term liabiliries Mortgage Payable Total Long-term Eablities Prepaid Expense Total Current Assets Total Liabilities Fixed Assets Net Building and Equipment Land Total Ficed Assets Net Assers Unrestricted Temporanly Restricted Total Net Assets Goodwi TOTAL ASSETS TOTAL LIABILITIES &NET ASSETS ournal Entries Not-for-Profit Ledger Income Statement ation and press ENTER or choose Paste Type here to search MRA II Assig Insert Draw Page Layout Formulas Data Review View Arial 112-Ka" -- 9-12 Wrap Text Format Painter l B 1 u! A- 1 Merge & Home Cut Copy . ipboard Font Alignment VULCAN COMMUNITY HOSPITAL Statement of Cash Flows For the Year Ending December 31, 2018 Cash Flows from Operating Activities Collections Payments to Sellers Payments to Employees Insurance Payments interest Payments Net Cash from Operating Activities Cash Flows from Investing Activities Purchase of New Equipment Net Cash Used for Investing Activities Cash Flows from Financing Activities Payment of mortgage principal Net Cash from Financing Activities NET INCREASE/(DECREASE) IN CASH CASH BEGINNING OF YEAR CASH, END OF YEAR ;.; MRA IAssignment 2018 File Home Insert Draw Page Layout Formulas Data Review View Tell m Cut Times New Roma 114 -ka"-- 9- wrap Tent copy . Paste ,Format Painter Blu. E.IO-A-1 !Merge & Center. Clipboard Font Alignment F11 VULCAN COMMUNITY HOSPITAL FINANCIAL RATIOS Cureeet Assets 1 Current Ratio s Curenr Lisbilities n2 Quick Ritio i Currene Liablies Cash-Marketable Secunties , Dagi Cash onHand Bad Debts Elficiency Ratios Net Accounts Receivable 4 Dags in Accounts Receivab (Net Patient Revenue 365) Account Pagable 5 Days in Accounks Payables Operating Expences Depreciation) 35 Current Liabiities Avaage Payment Petiod Operating Expenses Depreciation)/385 Total Raue Income Statement BalanceSheet CashFlow Statement Ratio analyses Select destination and press ENTER or choose Paste O Type here to search MRA Home Insert Draw Page Layout Formulas Data Review File 9- wrap Times New Roma-114-..^^ BIW-1. -= X Cut Paste Format Painter Clipboard Alignment Font F11 Total Revenue 7 Total Asset Tumovers Total Asset rencg Ratios Excess of Fevenues over Expenses Interest Expense l & merest Coverages Interest Expense Excess of Revenuws over Expenses Interest Expense Depreciation Expense hterest Expeinse Plincipal Pagments Long-term Det 1o Long-twm Debt to Net Asse Net Assets Profitability Ratios Total Net hcome Total Rever Encess of Revenues ow Expenses Exsess of Peveues over Expenses Tors Asseta Fleun on Assets, teika destinastion and pres ENTER er choozs Paste elancesheet ashFlow Statement Ratio analyses Type here to search Home Insert Draw Page Layout Formulas Data Review File : Times New Roma 14 -Ka" Ep Copy Paste Alignment Clipboard Font F11 Net Assets Profitability Ratios 57 Total Net Incom s11 Total Margin Total Revenue Excess of Revenues over Expenses 12 Operating Margins Operating Revenue Excess of Revenues over Expenses 69-13 Return on Assets Total Assets Encess of Revenues over Expences 14 14 Return on Net Assetss Net Assets