HCS/405 Version 9

Balance Sheet Worksheet
HCS/405 Version 9
1
University of Phoenix Material
Balance Sheet Worksheet
Consider the following scenario:
Imagine you are a manager of a small health care facility and in charge of developing an annual balance sheet to help your stakeholders understand the organization’s financial standing.
Your health care facilities figures are as follows:
Your facility has $700,000 of cash on hand, $1,300,000 in accounts receivables, $175,000 in inventory, and $150,000 in supplies.
Your chief financial officer has provided you with the following assets:
Land value
$3,000,000
Property value
$ 287,500
Plant value
$ 287,500
Investment income (loss)
$ 147,000
Equipment value
$ 350,000
Your chief financial officer has provided you with the following liabilities:
Accounts payable
$1,400,000
Wages payable
$ 480,000
Taxes payable
$ 225,000
Loans payable
$ 70,000
Bonds payable
$ 68,000
Your chief financial officer has provided you with the following owners equity:
Retained earnings
$ 148,000
Stock
$ 340,000
Using the ABC Health Care Balance Sheet template, complete a balance sheet in which you include the net profit (loss).
Write a 350- to 700-word executive summary that explains to the board of directors how you developed the balance sheet and its importance.
Include the following in your summary:
· Explain the process for creating a balance sheet.
· Explain the total assets, liabilities, and net worth (loss).
· Explain the use of profitability, liquidity, and debt ratios.
Cite at least 2 sources, including your textbook.
Format your assignment according to APA guidelines.
Click the Assignment Files tab to submit your assignment.
Copyright © 2016 by University of Phoenix. All rights reserved.