Financial Data Analysis
koulefianou
financial_data_analysis.docxFinancial Data Analysis
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:
1) Click on "Virtual Organizations" under student materials. 2) Click on "Healthcare" across the top. 3) Click on Patton-Fuller Community Hospital in the drop down menu. 4) Click on Corporate Officers across the top. 5) Click on Chief Financial Officer in the drop down menu. 6) 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.
Note: The explanations column is not an opportunity to talk about what depreciation is, for example, but rather to discuss why depreciation increased so significantly at PFCH.
Materials
· Financial Data Analysis Template
|
Patton-Fuller Community Hospital |
||||||
|
Statement of Revenue & Expense |
||||||
|
2009 and 2008 |
||||||
|
(in thousands) |
||||||
|
(audited) |
||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
REVENUE |
|
2009 |
2008 |
$ Change |
% Change |
Explanation of Changes Based on the Annual Report - WHY did the changes occur? (If the cell is grayed out then you do not need to provide an explanation) |
|
|
Net patient revenue |
|
|
|
|
|
|
|
Other revenue |
|
|
|
|
|
|
|
Total Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EXPENSES |
|
|
|
|
|
|
|
|
Salaries and benefits |
|
|
|
|
|
|
|
Supplies |
|
|
|
|
|
|
|
Physician and professional fees |
|
|
|
|
|
|
|
Utilities |
|
|
|
|
|
|
|
Other |
|
|
|
|
|
|
|
Depreciation & amortization (noncash expenses) |
|
|
|
|
|
|
|
Interest |
|
|
|
|
|
|
|
Provision for doubtful accounts |
|
|
|
|
|
|
|
Total Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
INCOME |
|
|
|
|
|
|
|
|
Operating Income |
|
|
|
|
|
|
|
Investment Income |
|
|
|
|
|
|
|
Net Income |
|
|
|
|
|
|
|
|
|
|
|
|
|
