Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete a Balance Sheet and Statement of Operations using Excel. FINANCIAL STATEMENT PROJECT BALANCE SHEET Given below is a list of account balances for Currie
Complete a Balance Sheet and Statement of Operations using Excel.
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.) Account Balance Property plant & $6,000,000 equipment Accounts Payable 130,000 Inventories 100,000 Other Current Liabilities 70,000 Net Accounts Receivable 650,000 Accrued expenses 100.000 Accumulated Depreciation 200,000 Long-term Debt 5,000,000 Cash 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. Account Administrative expenses Net assets released from temporary restricted accounts for operations Amount $80.000 Labor expense Interest expense Net patient service revenue Supply expense 120.000 200,000 12.000 540.000 2.000 20.000 Bad debt expense Depreciation expense 50.000 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 Subtotal Line: Total Net Assets Total Line: Total Liabilities and Net Assets Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started