Complete a Balance Sheet and Statement of Operations using Excel Spreadsheet

FINANCIAL STATEMENT PROJECT BALANCE SHEET Given below is a list of account balances for Currie Hospital as of December 31, 2018. Prepare a balance sheet as of December 31, 2018, in proper form. (Hint: You will need to compute the net assets account. Assume that all net assets at the beginning of the year are unrestricted.) Balance $6,000,000 Account Property plant & equipment Accounts Payable Inventories Other Current Liabilities Net Accounts Receivable Accrued expenses Accumulated Depreciation Long-term Debt Cash 130,000 100,000 70,000 650,000 100,000 200,000 5,000,000 210,000 STATEMENT OF OPERATIONS Below is a list of accounts for Currie Hospital for December 2018 (annual amounts). Prepare a statement of Operations for 2018 in good form. Amount $80,000 Account Administrative expenses Net assets released from temporarily restricted accounts for operations 120,000 Libor expense 250,000 Interest expense 12,000 Net patient service revenue 340,000 Supply expense 88,000 Bad debt expense 40,000 Depreciation expense 50,000 FORMATTING HINTS (click here to open folder) STATEMENT OF OPERATIONS Sections: Section 1: Unrestricted Revenues, Gains, and Other Support Section 2: Expenses Total Line: Operating Income (Loss) BALANCE SHEET Sections Section 1: Assets Sub Section: Current Assets Subtotal Line: Total Current Assets Sub Section: Non Current Assets Subtotal Line: Total Non Current Assets Total Line: Total Assets Section 2: Liabilities and Net Assets Section 3: Non Current Liabilities Section 4: Net Assets Section 1: Assets Sub Section: Current Assets Subtotal Line: Total Current Assets Sub Section: Non Current Assets Subtotal Line: Total Non Current Assets Total Line: Total Assets Section 2: Liabilities and Net Assets Section 3: Non Current Liabilities Section 4: Net Assets Subtotal Line: Total Net Assets Total Line: Total Liabilities and Net Assets