Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Traveling Consultants Guide To Auditing UNIX

Authors: Mark Adams

1st Edition

1105616398, 978-1105616396

More Books

Students also viewed these Accounting questions