Discussion: Financial Data Analysis

Discussion: Financial Data Analysis
Discussion: Financial Data Analysis
Permalink:
Financial Data Analysis for the Patton-Fuller Community Hospital (PFCH)
You will use the Patton-Fuller Community Hospital (PFCH) virtual organization for this assignment.
Follow the steps below to access the PFCH 2009 Annual Audit:
Click on “Virtual Organizations” under student materials.
Click on “Healthcare” across the top.
Click on Patton-Fuller Community Hospital in the drop down menu.
Click on Corporate Officers across the top.
Click on Chief Financial Officer in the drop down menu.
Click on Annual Report on the left side of the page.
Complete the Financial Data Analysis Template. Note the order of the 2009 and 2008 columns.
In the third column, calculate the difference by subtracting 2008 data from 2009 data. For instance, with cash, this would be $22,995 – $41,851 = -$18,856.
In the fourth column, calculate the percentage change from the 2008 number. For instance, with Net Patient Revenue, 2009 = $459,900 and 2008 = $418,509 providing a $ change (third column) of $41,391. For the % change (fourth column), $41,391 / 418509 = .0989 which would be 9.89% (which is .0989 * 100).
Using the explanations column, explain why the significant changes occurred from one year to the next. This explanation is based on your conceptual understanding of the way specific line items on financial statements work as well as thorough review and research of the PFCH Annual Audit.
Click the Assignment Files tab to submit your Financial Data Analysis for the Patton-Fuller Community Hospital (PFCH) assignment.
Patton Fuller Community Hospital: Financial Analysis and…
Succeeding the statement of revenue and expenses it the balance sheet for the two years showing changes experienced. Patton-Fuller Community Hospital Statement of Revenue and Expense For years 2009 and 2010
In thousands $
$
2009
2010
$amount of change
Percentage of change
Revenues
Patient revenue 459,900
473,697
13,797
3%
Other revenue 3,082
3,544
462
15%
Total Revenues
462,982
477,241
14,259
3%
Expenses Benefits and salaries
220,752
222,959.52
2207.52
1%
Professional and physician fees
110,376
113,687.28
3311.28
3% supplies 74,584
72,346.48
(2237.52)
-3%
Utilities 1,200
1,260
60
5%
Other 1,840
1,840
0
0%
Amortization and depreciation
36,036
36,036
0
0%
Interest
3,708
4,820.4
1112.4
30%
Provision for doubtful accounts
13,797
15,176.7
1,379.7
10%
Total Expenses $462,293
$ 468126.38
5,833.38
1.26% Operating income 689
9,114.62
8425.62
1222.90%
Investment income ($62)
(62)
0
0%
Net Income 627 9052.62
8425.62
1222.90% Patton- Fuller Community Hospital Balance sheet as at 31, 2009 and 2010
In thousands $
$
2009
2010
Amount of percentage Assets change change Current assets Cash and…