Financial Data Analysis
Patton-Fuller Community Hospital virtual organization.
Patton - Fuller Community Hospital Statement of Revenue and Expense 2009-2008(InThousands)(Unaudited) Patton - Fuller Community Hospital Statement of Retained Earnings and Stockholders 1/2 Equity For the Year Ending December 31, 2009 (In Thousands) (Audited) Patton - Fuller Community Hospital Statement of Cash Flows 20092008 (As of December 31) (In Thousands) (Audited) Cash Flows From Operating Activities Net Income (Loss) Adjustments Complete the Financial Data Analysis. Template. Note the order of the 2009 and 2008 columns. 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=518.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=5418,509 providing a 5 change (third column) of $41,391. For the % change (fourth column)k. 541,391/418509=0.0989 which would be 9.899 twhich is 0.0989100. 3. Using the explanations column, explain why the significant changes occurred from one year to the next. This explanation is based onyour 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. Ensure you complete all tabs in the spreadsheet. Note: The explanations column is not an opportunity to talk about what depreciation is, for example, but rather to discuss why depreclation increased so significantly at PFCH. Patton-fuller Community Hospital Statement of Revenue \& Expenve 2009 and 2008 (in thousands) (audited) EXPENSES 4 B \begin{tabular}{|c|c|c|c|c|} \hline C & D & E & F & 9 \\ \hline Other revense & & & & \\ \hline Total Revenue & & & & \\ \hline \end{tabular} EXPENSES \begin{tabular}{|l|l|l|l|} \hline Solanies and benefits & & & \\ \hline Supplies & & & \\ \hline Physician and professional tees & & & \\ \hline utitities & & & \\ \hline Other & & & \\ \hline Depreciation \& amortuation (noncash expenses) & & & \\ \hline interest \\ Provision for doubtfol accounts & & & \\ \hline Total Fxpenves & & & \\ \hline \end{tabular} DUCOME \begin{tabular}{|l|l|l|l|} \hline Operating leceene & & & \\ \hline investment lecoine & & & \\ \hline Net income & & & \\ \hline \end{tabular} Patton - Fuller Community Hospital Balance Sheet as of December 31, 2009 and 2008 Bond interest payable Total Current Liabilitios \begin{tabular}{rr} 10 & 10 \\ \hline$23,807 & $8,380 \end{tabular} Other Liabilities Long-term debt \begin{tabular}{rr} $452,945 & $209,255 \\ 14,599 & 4,185 \\ \hline$438,346 & $205,069 \\ \hline$462,153 & $213,450 \end{tabular} Less: current portion of long-term debt Net long-term debt Total Liabilities Common stock, $0.01 par value $50$50 10,000,000 shares authorized 5,000,000 shares outstanding Additional Paid-in Capital 0 o 0 Retained Earnings Total Liabilities and Equity \begin{tabular}{|rr|} \hline 125,564 & 335.035 \\ \hline$587,767 & $548,535 \\ \hline \end{tabular} Includes adjustment due to audit Note: Maximum Annual Debt Service Equity Common stock, $0.01 par value $50$50 10,000,000 shares authorized 5,000,000 shares outstanding Additional Paid-in Capital 0 0 Retained Earnings Total Liabilities and Equity \begin{tabular}{rr} 125,564 & 335,035 \\ \hline$587,767 & $548,535 \\ \hline \hline \end{tabular} 1 Includes adjustment due to audit Note: Maximum Annual Debt Service Bond interest payable Current portion of long-term debt Maximum annual debt service \begin{tabular}{rr} $10 & $10 \\ 14,599 & 4,185 \\ \hline$14,609 & $4,195 \\ \hline \end{tabular} Complete the Financial Data Analysis Template. Note the order of the 2009 and 2008 columns. 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 96 change (fourth column), $41,391/418509=0.0989 which would be 9.899 (which is 0.0989100 ). 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. Ensure you complete all tabs in the spreadsheet. Patton - Fuller Community Hospital Balance Sheet as of December 31, 2009 and 2008 (In thousands) (Audited) Liabilities and Equity Curront Liabilities \begin{tabular}{lrr} Current portion of long-term debt & $14,599 & $4,185 \\ Accounts payable, accrued expenses & 9,198 & 4,185 \\ Bond interest payable & 10 & 10 \\ \hline Total Current Liabilitios & $23,807 & $8,380 \end{tabular} Other Liabilities Long-term debt $452,945T$209,255 Less: current portion of long-term debt Net long-term debt Total Liabilities \begin{tabular}{rrr} 14,599 & 4,185 \\ \hline$438,346 & $205,069 \\ \hline$462,153 & $213,450 \end{tabular} Equity Common stock. $0.01 par value 10.000.000 shares authorized 5,000,000 shares outstanding Additional Paid-in Capital Retained Eamings Total Liabilities and Equity \begin{tabular}{|rr|} \hline 125.564 & 335.035 \\ \hline$587.767 & $548,535 \\ \hline \end{tabular} Equity Common stock, $0.01 par value $50$50 10,000,000 shares authorized 5,000,000 shares outstanding Additional Paid-in Capital 0 Retained Eamings Total Liabilities and Equity \begin{tabular}{rr} 125,564 & 335,035 \\ \hline $587,767 & $548,535 \\ \hline \end{tabular} 'Includes adjustment due to audit Note: Maximum Annual Debt Service Bond interest payable Current portion of long-term debt Maximum annual debt service \begin{tabular}{rr|r|} \hline$10 & $10 \\ 14,599 & 4,185 \\ \hline$14,609 & $4,195 \\ \hline \end{tabular} Patton-Fuller Community Hospital Statement of Revenue \& Expense 2009 and 2003 (in thousands) (audited) INCOME \begin{tabular}{|l|l|l|l|l|l|} \hline Operating income & & & & \\ \hline Investment income & & & & \\ \hline Net income & & & & \\ \hline \end{tabular} Patton - Fuller Community Hospital Statement of Revenue and Expense 2009-2008(InThousands)(Unaudited) Patton - Fuller Community Hospital Statement of Retained Earnings and Stockholders 1/2 Equity For the Year Ending December 31, 2009 (In Thousands) (Audited) Patton - Fuller Community Hospital Statement of Cash Flows 20092008 (As of December 31) (In Thousands) (Audited) Cash Flows From Operating Activities Net Income (Loss) Adjustments Complete the Financial Data Analysis. Template. Note the order of the 2009 and 2008 columns. 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=518.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=5418,509 providing a 5 change (third column) of $41,391. For the % change (fourth column)k. 541,391/418509=0.0989 which would be 9.899 twhich is 0.0989100. 3. Using the explanations column, explain why the significant changes occurred from one year to the next. This explanation is based onyour 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. Ensure you complete all tabs in the spreadsheet. Note: The explanations column is not an opportunity to talk about what depreciation is, for example, but rather to discuss why depreclation increased so significantly at PFCH. Patton-fuller Community Hospital Statement of Revenue \& Expenve 2009 and 2008 (in thousands) (audited) EXPENSES 4 B \begin{tabular}{|c|c|c|c|c|} \hline C & D & E & F & 9 \\ \hline Other revense & & & & \\ \hline Total Revenue & & & & \\ \hline \end{tabular} EXPENSES \begin{tabular}{|l|l|l|l|} \hline Solanies and benefits & & & \\ \hline Supplies & & & \\ \hline Physician and professional tees & & & \\ \hline utitities & & & \\ \hline Other & & & \\ \hline Depreciation \& amortuation (noncash expenses) & & & \\ \hline interest \\ Provision for doubtfol accounts & & & \\ \hline Total Fxpenves & & & \\ \hline \end{tabular} DUCOME \begin{tabular}{|l|l|l|l|} \hline Operating leceene & & & \\ \hline investment lecoine & & & \\ \hline Net income & & & \\ \hline \end{tabular} Patton - Fuller Community Hospital Balance Sheet as of December 31, 2009 and 2008 Bond interest payable Total Current Liabilitios \begin{tabular}{rr} 10 & 10 \\ \hline$23,807 & $8,380 \end{tabular} Other Liabilities Long-term debt \begin{tabular}{rr} $452,945 & $209,255 \\ 14,599 & 4,185 \\ \hline$438,346 & $205,069 \\ \hline$462,153 & $213,450 \end{tabular} Less: current portion of long-term debt Net long-term debt Total Liabilities Common stock, $0.01 par value $50$50 10,000,000 shares authorized 5,000,000 shares outstanding Additional Paid-in Capital 0 o 0 Retained Earnings Total Liabilities and Equity \begin{tabular}{|rr|} \hline 125,564 & 335.035 \\ \hline$587,767 & $548,535 \\ \hline \end{tabular} Includes adjustment due to audit Note: Maximum Annual Debt Service Equity Common stock, $0.01 par value $50$50 10,000,000 shares authorized 5,000,000 shares outstanding Additional Paid-in Capital 0 0 Retained Earnings Total Liabilities and Equity \begin{tabular}{rr} 125,564 & 335,035 \\ \hline$587,767 & $548,535 \\ \hline \hline \end{tabular} 1 Includes adjustment due to audit Note: Maximum Annual Debt Service Bond interest payable Current portion of long-term debt Maximum annual debt service \begin{tabular}{rr} $10 & $10 \\ 14,599 & 4,185 \\ \hline$14,609 & $4,195 \\ \hline \end{tabular} Complete the Financial Data Analysis Template. Note the order of the 2009 and 2008 columns. 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 96 change (fourth column), $41,391/418509=0.0989 which would be 9.899 (which is 0.0989100 ). 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. Ensure you complete all tabs in the spreadsheet. Patton - Fuller Community Hospital Balance Sheet as of December 31, 2009 and 2008 (In thousands) (Audited) Liabilities and Equity Curront Liabilities \begin{tabular}{lrr} Current portion of long-term debt & $14,599 & $4,185 \\ Accounts payable, accrued expenses & 9,198 & 4,185 \\ Bond interest payable & 10 & 10 \\ \hline Total Current Liabilitios & $23,807 & $8,380 \end{tabular} Other Liabilities Long-term debt $452,945T$209,255 Less: current portion of long-term debt Net long-term debt Total Liabilities \begin{tabular}{rrr} 14,599 & 4,185 \\ \hline$438,346 & $205,069 \\ \hline$462,153 & $213,450 \end{tabular} Equity Common stock. $0.01 par value 10.000.000 shares authorized 5,000,000 shares outstanding Additional Paid-in Capital Retained Eamings Total Liabilities and Equity \begin{tabular}{|rr|} \hline 125.564 & 335.035 \\ \hline$587.767 & $548,535 \\ \hline \end{tabular} Equity Common stock, $0.01 par value $50$50 10,000,000 shares authorized 5,000,000 shares outstanding Additional Paid-in Capital 0 Retained Eamings Total Liabilities and Equity \begin{tabular}{rr} 125,564 & 335,035 \\ \hline $587,767 & $548,535 \\ \hline \end{tabular} 'Includes adjustment due to audit Note: Maximum Annual Debt Service Bond interest payable Current portion of long-term debt Maximum annual debt service \begin{tabular}{rr|r|} \hline$10 & $10 \\ 14,599 & 4,185 \\ \hline$14,609 & $4,195 \\ \hline \end{tabular} Patton-Fuller Community Hospital Statement of Revenue \& Expense 2009 and 2003 (in thousands) (audited) INCOME \begin{tabular}{|l|l|l|l|l|l|} \hline Operating income & & & & \\ \hline Investment income & & & & \\ \hline Net income & & & & \\ \hline \end{tabular}
