Financial Data Analysis

Financial Data Analysis

 Assignment Content

  1. Use the Patton – Fuller Community Hospital Balance Sheet to complete the Financial Data Analysis Template
    (See two attachments)
    1. 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.
    2. 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 = 0.0989 which would be 9.89% (which is 0.0989* 100).
    3. 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.
    4. Complete all tabs located at the bottom of the spreadsheet.
    5. 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.

       

Title Page

Balance Sheet

Patton-Fuller Community Hospital
Balance Sheet as of December 31
2009 and 2008
(in thousands)
(audited)
ASSETS20092008$ Change% ChangeExplanation 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 equivalents22,99541,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)
REVENUE20092008$ Change% ChangeExplanation 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

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply