Financial Data Analysis

profileparkhill96
FinancialDataAnalysisTemplate.xlsx

Title Page

Balance Sheet

Patton-Fuller Community Hospital
Balance Sheet as of December 31
2009 and 2008
(in thousands)
(audited)
ASSETS 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)
Current Assets
Cash and cash equivalents 22,995 41,851 (18,856) -45%
Assets of limited use
Patient accounts receivable (net of allowance for bad debts)
Other receivables
Inventories
Prepaid expenses
Total current assets
Other Assets
Funded Depreciation
Held under bond indenture
Property, plant and equipment
Total assets
LIABILITIES AND EQUITY
Current Liabilities
Current portion of long-term debt
Accounts payable and accrued expenses
Bond interest payable
Total current liabilities
Other Liabilities
Long-term debt
Less: Current portion of long-term debt
Net long-term debt
Total liabilities
Equity
Common Stock
Retained earnings
Total liabilities and equity

Statement of Revenue & Expense

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

References