I need help with an accounting question. I am confused at where the calculations go and the book does not help. I would appreciate any assistance you can provide.

The attached is the assignment and the excel template . It has a tab for balance sheet, profit and loss statement, and cash flow statement.

PLEASE HELP!!!!

Healthcare Financial Management and Economics Week 7 Assignment Putman Medical Center Developing Financial Statements All organizations, including those in the healthcare industry, need to make money to be profitable and survive. Financial statements, such as balance sheets, profit and loss statements, and cash flow statements, summarize an organization's profitability and overall financial status. For this Assignment, you practice developing three key financial statements using data from the Putman Medical Center. Putman Medical Center Putman Medical Center is a large Midwestern acute care and ambulatory facility serving an urban city population. Givens (in '000s): Insurance expense Cash Patient revenues (net of contractuals) Net accounts receivable Ending balance, temporarily restricted net assets Wages payable Prepaid expense Long-term debt Supply expense Gross plant, property, and equipment Net assets released from temporary restriction Depreciation expense General expense Transfer to parent corporation Beginning balance, unrestricted net assets Accounts payable Beginning balance, temporarily restricted net assets Provision for bad debt expense Labor expense Accumulated depreciation Long-term investments Ending balance, unrestricted net assets $70,000 $23,000 $614,000 $25,000 $8,700 $9,100 $1,100 $191,700 $66,000 $556,000 $8,000 $10,000 $95,000 ($8,000) $203,400 $21,000 $16,700 $5,400 $145,000 $99,000 $150,400 $426,000 To prepare for this Assignment: Examine the data from Putman Medical Center. Reflect on how you will use this data to develop a Balance Sheet, Profit and Loss Statement, and Cash Flow Statement. Refer to the course text for additional guidance. 2015 Laureate Education, Inc. Page 1 of 2 The Assignment: Complete a Balance Sheet, Profit and Loss Statement (Statement of Operations), and Cash Flow Statement (Statement of Changes in Net Assets) using the \"Week 7 Financial Statement Excel Template\". Your Assignment is due by Day 7 of Week 7. 2015 Laureate Education, Inc. Page 2 of 2