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