Week 7 6400 Accounting assgn

Week 7 6400 Accounting assgn
Please make sure calcuations is corect and usel the execl attachment wit the other document that is attach to do the assgn

Assignment: Developing Financial Statements
Note:Â The Instructor will post the document for this Assignment by Day 1 of Week 7.
All organizations, including those in the health care 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 a medical center.
To prepare for this Assignment:
Review the Week 7 Assignment document provided to you by the Instructor. Examine the data from the medical center described in the document. Reflect on how you will
use this data to develop a balance sheet, profit and loss statement (statement of operations), and cash flow statement (statement of changes in net assets). Refer to
the course text for additional guidance.
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”.
resources
Required Readings
Zelman, W. N., McCue, M. J., Glick, N. D., & Thomas, M. S. (2014). Financial management of health care organizations: An introduction to fundamental tools, concepts
and applications (4th ed.). San Francisco, CA: Jossey-Bass.
Chapter 1, “The Context of Health Care Financial Management” (Review pp. 1–23)
Chapter 2, “Health Care Financial Statements” (pp. 27–73)
Document: Week 7 Financial Statement Excel Template (Excel spreadsheet)
Â
Note: You will use this document to complete this week’s Assignment.
Optional Resources
Goodwill Community Foundation. (2015a). Excel 2003 [Online tutorial]. Retrieved from http://www.gcflearnfree.org/excel2003
Goodwill Community Foundation. (2015b). Excel 2007 [Online tutorial]. Retrieved from http://www.gcflearnfree.org/excel2007
Goodwill Community Foundation. (2015c). Excel 2010 [Online tutorial]. Retrieved from http://www.gcflearnfree.org/excel2010
Goodwill Community Foundation. (2015d). Excel 2013 [Online tutorial]. Retrieved from http://www.gcflearnfree.org/excel2013
Microsoft, Inc. (2016). Excel Training. Retrieved from https://support.office.com/en-us/article/Excel-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?ui=en-US&rs=en-
US&ad=US
Microsoft, Inc. (2015b). Excel 2010 videos and tutorials. Retrieved from https://support.office.com/en-US/article/Excel-2010-training-courses-videos-and-tutorials-
807211fe-ee81-4887-b48a-68a94e1e912f
Microsoft, Inc. (2015c). Excel 2013 videos and tutorials. Retrieved from https://support.office.com/en-us/article/Excel-2013-training-courses-videos-and-tutorials-
aaae974d-3f47-41d9-895e-97a71c2e8a4a?ui=en-US&rs=en-US&ad=US
Excel Easy. (2016, March 8). Financial Functions. Retrieved from http://www.excel-easy.com/functions/financial-functions.html
Â
Excel Finance Class 01: Intro To Excel 2007 & 2010 [Video file]. Retrieved March 8, 2016, from https://www.youtube.com/watch?v=qeWOy4Q-1n8&noredirect=1
Provides a tutorial of Excel, basic math functions, and about how to perform calculations. There are videos in a series and the link will take you to the first in the
series which is “The Basics”.
Â