Get all Your Education Homework help from Tutorslite.com
Capella University Week 2 Ray Hospital Financial Management Paper
Using Excel, complete problem 11 on page 77 of your Financial Management of Health Care Organizations text by Zelman, McCue, Glick, and Thomas. Post your workbook to this discussion. Also, include a brief assessment of the financial position of Ray Hospital based on your completed balance sheet.
Remember to use citations and references as appropriate. Your post must follow APA sixth edition style and formatting guidelines. See the Campus APA Style and Format page, linked in the Resources, for more information.
The goal here is to learn and I do not want anyone losing sleep over these tasks. If you are confused with some of the financial, concepts, ratios or statements you may still complete the task by providing us (peers and me) with a narration of the financial concepts we have discussed that you may incorporate in your tasks. If you have financial experience and are comfortable with using and applying financial ratios you may provide additional detail in your approach.
Helpful Tips for Week 2:
[If the following link does not work, please try the attachment]
Unit 2 Problem 11 Balance Sheet.m4a
Problem 2-11 Ray Hospital
Please listen to my introduction and recording regarding this problem under the updates and Handouts section.
First, figure out what information you do have:
Gross plant, property, and equipment
$70,000,000
Accrued expenses
$6,000,000
Cash
$8,000,000
Net accounts receivable
$15,500,000
Accounts payable
$7,000,000
Long-term debt
$45,000,000
Supplies
$3,000,000
Accumulated depreciation
$5,000,000
Feel free to use the template below:
Ray Hospital
Balance Sheet
September 30, Year
9/30/20X1
9/30/20X1
9/30/20X1 9/30/20X1
Current Assets Current liabilities
Cash Accounts payable
Net accounts receivable Accrued expenses
Supplies Total current liabilities
Total current assets
Long-term debt
Gross plant, property, and equipment Total liabilities
(less accumulated depreciation) Net assets:
Net plant, property, and equipment Total net assets
Total assets Total liabilities and net assets
Second, start plugging in your assets and liabilities from the given information:
Ray Hospital
Balance Sheet
September 30, Year
9/30/20X1
9/30/20X1
9/30/20X1 9/30/20X1
Current Assets Current liabilities
Cash $8,000,000 Accounts payable
Net accounts receivable 15,500,000 Accrued expenses
Supplies 3,000,000 Total current liabilities
Total current assets 26,500,000
Long-term debt
Gross plant, property, and equipment Total liabilities
(less accumulated depreciation) Net assets:
Net plant, property, and equipment Total net assets
Total assets Total liabilities and net assets
Note: Non-profit healthcare organizations on their balance sheet should demonstrate unrestricted net assets, temporarily and permanently restricted net assets. However, in this problem, you will not have the information. Therefore, keep it basic, simply as Net Assets (one category) for this problem. For a non-profit organization: Assets – Liabilities = Net Assets.
