Using the information given above, construct the Income Statement and Balance Sheet for the Fiscal Year ended December 31, 2018.

(Below is the blank Excel spreadsheet that needs to be filled in. Give equations for each cell).

S S S $ S Gross Patient Service Revenue Bad Debt Charity Care Contractual Allowance Salaries Benefits Administrative Insurance Interest Depreciation Maintenance Purchased Services S $ $ S S $ $ S 115,981,250 2,655,000 1,575,000 70,093,750 15,825,000 4,178,292 1,342,500 125,000 164,575 3,200,000 435,500 6,146,500 240,000 9,169,813 356,000 1,545,000 2,750,000 7,125,000 1,135,000 90,500,000 (43,500,000) 94,500 2,375,000 1,125,000 16,515,000 1,000,000 26,500,000 13,040,000 $ $ S S $ Rent Supplies Utilities-Electricity Cash and Cash Equivalents Short-term Investments Net Patient Accounts Receivables Inventory - Supplies Property and Equipment Accumulated Depreciation Investment Income Account Payable Accrued Expenses Notes Payable Contributions Long-Term Debt Retained Earnings $ $ S $ $ S $ S S 1. Construct the Income Statement and Balance Sheet for FY 2018. St. John's Healthcare Income Statement for FY 2018 Revenue Gross Patient Service Revenue Contractual Allowance Charity Care Bad Debt Net Patient Service Revenue Expenses Salaries Benefits Purchased Services Supplies Utilities-Electricity Rent Maintenance Administrative Insurance Interest Depreciation Total Expenses Operating Income Non Operating Income (Expense) Contributions Investment Income Total Non Operating Income Net Income