70.2K

Verified Solution

Link Copied!

A) Balance sheet

B) Statement of Operation

C) Statement of changes in Net Assets

Excel Assignment #1 Fall Semester H352 (50 points) 1. Complete the multiple statements (Parts A, B, and C) for problem #15 in your textbook on page 76. Utilize Microsoft Excel to create your financial statements. I would prefer each statement done in a separate tab. The financial statements can still be linked through the tabs. 2. I would complete the financial statements in the order we mentioned in class. You don't necessarily have to complete the financial statements in the order represented in the question's instructions. 3. This is an individual assignment. If you have questions, email me. If you are unable to get the book yet, here are the givens for Problem 15: Givens: Insurance expense $45.000 Depreciation expense $40.000 Cash $81.000||General expense $355,000 Patient revenues (net of contractuals) $1,300,000 | Transfer to parent corporation $45,000 Net accounts receivable $450.000 Beginning balance, net assets without donor restrictions 5375.000 Ending balance, net assets with donor restrictions $58,000 Accounts payable $13,000 Wages payable $47.000 Beginning balance, net assets with donor restrictions $80,000 Prepaid expenses $12.000 Bad debt expense $6.000 Long-term debt $380,000 Labor expense $570,000 Supply expense $55,000 Accumulated depreciation $464,000 Gross plant, property, and equipment $1,000,000 Net assets released from donor restrictions $22,000 Ending balance, net assets without donor restrictions $581,000

Answer & Explanation Solved by verified expert

See Answer