Financial Data Analysis

In: Science

Submitted By cokonta
Words 1359
Pages 6
Financial Data Analysis

HCS/577
July 14, 2014

Financial Data Analysis Patton - Fuller Community Hospital | Balance Sheet as of December 31 | 2009 and 2008 | (In thousands) | (Audited) | 2009 | 2008 | Assets | Current Assets | Cash and Cash Equivalents | $22,995 | $41,851 | Assets of Limited Use | $27,594 | $41,851 | Patient Accounts Receivable (1) | $58,787 | $37,666 | (net of Allowance for Bad Debts 2009: $11,757 / 2008: $7,533) | Other Receivables (3rd party payer settlements | - | $87 | Inventories | $18,396 | $8,370 | Prepaid Expenses | $95 | $201 | Total Current Assets | $127,867 | $130,026 | Other Assets | Funded Depreciation | $137,970 | $167,404 | Held under Bond Indenture | $73,584 | $75,332 | Property, Plant and Equipment, net | $248,346 | $175,774 | Total Assets | $587,767 | $548,535 | Liabilities and Equity | Current Liabilities | Current portion of long-term debt | $14,599 | $4,185 | Accounts payable, accrued expenses | $9,198 | $4,185 | Bond interest payable | $10 | $10 | Total Current Liabilities | $23,807 | $8,380 | Other Liabilities | Long term debt | $452,945 | $209,255 | less: current portion of long term debt | $14,599 | $4,185 | Net long term debt | $438,346 | $205,069 | Total Liabilities | $462,153 | $213,450 | Patton - Fuller Community Hospital | Statement of Revenue and Expense | 2009 and 2008 | (In thousands) | (Audited) | 2009 | 2008 | Revenues | Net Patient Revenue | $459,900 | $418,509 | Other Revenue | $3,082 | $2,805 | Total Revenues | $462,982 | $421,314 | Expenses | Salaries and benefits | $220,752 | $214,129 | Supplies | $74,584 | $71,346 | Physician and professional fees | $110,376 | $107,065 | Utilities | $1,200 | $1,164 | Other | $1,840 | $1,785 |…...

Similar Documents

Hcs577 - Financial Data Analysis

...Financial Data Analysis HCS/577 Financial Data Analysis Patton-Fuller Community Hospital (PFCH) is a for-profit health care provider for the Northwest Valley area. The hospital opened in 1975 and owned by the physicians practicing at the facility, PFCH is dedicated to providing cutting edge services with high quality patient care. Currently, the 600 bed facility received a majority of its revenue (80%) through in-patient services including surgical care, nurse services, both medical and surgical as well as their Intensive Care Unit (ICU). The remaining 20% of revenue is gained through Emergency Department visits and additional out-patient care. The remainder of this paper will determine the variances between the 2008 and 2009 fiscal year in attempts to determine where major gains and losses can be seen within Patton-Fuller’s financial environment. Variances between 2008 and 2009: The first area analyzed for variances between the 2008 and 2009 operating years, was the assets of Patton-Fuller Community Hospital. With both the stock market and real estate industries reeling during this most recent economic downturn, the return on these types of investments is much lower in 2009 than in 2008. Cash and Cash equivalents saw a depreciation of 45% going from $41,000,000 in 2008 to $22,000,000 in 2009. Based on long-term investment options, future projections estimate that this loss will ultimately be negligible as the stock market begins to rebound. Additionally,......

Words: 762 - Pages: 4

Data Analysis

... Data Table Analysis Brief Ashley Jones ACC/542 November 5, 2012 Anita Rodriguez, M.A., CPA Data Table Analysis Brief Kudler Fine Foods has data that must be evaluated and automated into the data systems. Before the data can be automated, it must be evaluated for completeness. One must evaluate two different items: The Access data tables and The Inventory Database. To better assist Kudler Fine Foods, one must evaluate the design elements of the Access data tables from an accounting perspective and recommend improvements to the existing tables. An entity relationship diagram and pivot table will assist with understanding the data. One can then provide an explanation of how the information in the pivot table may improve decision making. Design Elements From an accounting perspective, the design elements of the data tables lack the information needed for processing transactions on a daily basis. The data in the table provide information on the customers, inventories, items, orders, order lines, stores, suppliers, tax tables, and tenders. The tables do not provide information on the transactions to journalize and add to the general ledger. The tables lack information for the financial reports, except for a few of the tables. The inventory table will provide the basic information for the quantity on hand for cost of goods calculations with unit cost for the income statement. The tender table will provide basic information on whether the payment is cash, credit......

Words: 536 - Pages: 3

Financial Data Analysis

...Financial Data Analysis Sharon M Flemming HCS 577 July 8, 2013 Dr. Patricia Jenkins Financial Data Analysis Financial management is an important aspect of health care financing. Whether for a hospital, medical group, or home care agency, long-term or short-term finance, maintaining accurate asset management records could mean the difference in failure or success for many organizations. The purpose of this assignment is to compare financial data for two consecutive years for Patton-Fuller Community Hospital from the 2008 and 2009 Balance sheets and Revenue and Expense sheets, and to identify significant changes between the years. I will also attempt to provide possible explanations for those changes based upon information provided within the Annual Report for that hospital. Patton-Fuller Community Hospital Financial Statements 2008-2009 Patton-Fuller Community Hospital (PFCH) is a large full service hospital providing cutting-edge medical care to Kelsey and the Northwest Valley since 1975. This is a physician owned organization with a fourteen member governing board in which each member with exception of the Chief Executive Officer (CEO) and the Chief Financial Officer (CFO) have equal voting rights. Each member serves a three-year term and elections are held each December, at which time four new members are voted in by the shareholders and profits are distributed among the owners (Apollo Group, Inc., 2013). According to the 2009 Annual Report the CFO indicates......

Words: 980 - Pages: 4

Financial Data

...Financial Data Analysis Paper December 2, 2013 Introduction Patton Fuller Community Hospital was started in the year of 1975. Patton Fuller Community Hospital has been dedicated to good quality care. It is a 600-bed capacity. It is known to be a for profit hospital. Its physicians and some that are still practicing at the facility own Patton Fuller Community Hospital. The financials of Balance Sheet and Statement of Revenue and Expense demonstrates how a firm has used its funds. These statements identify the financial stability of the organization. Which includes but is not limited to the cash flow statements along with the income statement, and the balance sheet. The financial reports show differences between 2008 and 2009. Based on the examination or audit performed for Patton Fuller Community Hospital, the auditors point out that there was a 10% raise in patient revenues as well as additional revenues. (Patton-Fuller Community Hospital 2009) This could be because of possible raise in patient visits and services, which may include admissions to the hospital. On the observation of the audited form that was submitted by the auditors, it is available under the expenses where Patton Fuller Community Hospital has experience increases. The supplies line item experienced a 5% increase, which totaled 3,238. The reason for such an increase may perhaps been easily related with the payments to vendors and the......

Words: 900 - Pages: 4

Financial Data

...COURSE WORK DONE BY : JEFF JACOB THOMAS STUDENT I.D: JAJED0A UNDERSTANDING AND INTERPRETING FINANCIAL DATA DBQAN30 COURSEWORK ON RATIO ANALYSIS This assignment comprises an individually analysed and presented case study, designed to assess the depth of knowledge of ratio analysis at an introductory level, and to demonstrate ability to comment on the result obtained and write a short report advising the users of financial information. You are provided with the criteria that will be used for assessment. The coursework will contribute 30 per cent of the final module mark. The assignment must be submitted by 12:00 on FRIDAY 14th May 2010. Late submissions will not be marked. Coursework assessment The aims of the coursework are as follows: • To demonstrate an understanding of appropriate theory and application of relevant techniques. • To apply ratio analysis in order to interpret financial data. • To write commentary and report as a structured, fluent and coherent piece of work. Assessment criteria are reported in the Appendix. Instructions • The word processed report should be 1000 words in length (excluding calculations), plus or minus 10 per cent. Assignments outside this length will be penalized 10 per cent for every further 10 per cent deviation in length. • All calculations should be shown in an appendix. All assignments will be checked electronically for plagiarism and collusion. MCC plc MCC plc is a carpet retailer......

Words: 2440 - Pages: 10

Financial Data Analysis

...Financial Data Analysis A financial data analysis “provides a great deal of important information regarding financial condition, it often fails to provide much insight into the operational causes of that condition” (Gapenski, 2008, p. 561). Financial data analysis identifies an organizations strengths and weaknesses by proving the relationship among items of a profit and loss account and a balance sheet. Numerous techniques or systems are used in analyzing financial statements. One such technique is comparative analysis. Comparative analysis “identifies new trends when data or ratios for a specific item from multiple time frames are presented alongside of each for a straight across comparison” (Investor Words, 2014, para. 1). This method can also be used to compare outcomes of alternate solutions or processes applied in similar situations. Other methods for analyzing financial data include “schedule of changes in working capital, common size percentages, funds analysis, trend analysis, and ratios analysis” (Accounting for Management, 2014, para. 3). The Patton-Fuller Community Hospital: Financial Analysis At first glance of the Patton-Fuller Health Care Organization one would assume this organization is viable. This would be due in part to a recent upgrade in operations. The balance sheet of December 31 2009-2008 reflects an increase of revenue. In addition to the increase of revenue, some expenses were also increased. It has yet to be determined if these increase were......

Words: 714 - Pages: 3

Financial Data Analysis

... MANAGEMENT INFORMATION REPORT PERFORMANCE OF THE WAGE BILL FOR THE PERIOD JANUARY TO DECEMBER 2010 1. General: The attached analysis shows actual performance of the wage bill for the period January to December 2010. The total actual payroll cost incurred during the period under review amounted to Le541.511 billion. The profiles indicate the expenditure pattern for MDAs, Teachers, Police, Foreign Missions, the Military, Salary Grants, Pensions/Gratuities and Government contributions to Social Security on a monthly basis. The total wage bill expended in 2010 compares unfavourably with the annual total projection of Le514.974 billion. The deficit of Le26.537 billion (representing 5.15% over the annual projection) was mainly due to excess expenditure as follows: * Pensions, Gratuity and other Retirement Benefits: Actual expenditure amounted to Le34.737 billion that is Le9.237 billion or 36.22% excess of the 2010 projection (Le25.500 billion). This was largely attributed to payment of arrears during the year. * Government’s Contribution to Social Secruity: Actual expenditure was Le34.674 billion which was Le3.568 billion or 11.47% more that what was projected (Le31.106 billion) for the financial year. The implementation of the free health care programme which resulted in the introduction of new salary structure for health workers largely triggered the rise in total payment made to NASSIT. * Teachers: Total actual expenditure for teachers amounted to Le164.874......

Words: 1870 - Pages: 8

Hcs 577 Financial Data Analysis

...Financial Data Analysis Patton Fuller Community Hospital is famous for specializing in medical care, surgery, physical therapy, pharmacy, radiology, delivery, and labor. Patton Fuller Hospital has been established in 1975. The main focus of the hospital is to offer quality medical services to all of their patients whether they are children or adults. Patton Fuller Hospital is one of the first hospitals in Kelsey. It is devoted to offer many diverse programs and services that would help them maintaining their patients' health. Patton Fuller hospital has a network that is complex and has built around the fundamentals of appropriate development of systems, in that the hospital as an organization is broken down into its primary operational components, a clinical half, and an administrative half. The administrative half of the hospital consists of such departments as human resources, accounting, reception, and executive offices; although the clinical side made of those areas perform patient care, such as operating rooms, the pharmacy, and so on. To begin, today what will be reviewed today will be analyzed financial data from the Patton-Fuller Hospital. Analysis of data is a process of inspecting, cleaning, transforming, and modeling data with the goal of discovering useful information, suggesting conclusions, and supporting decision making. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, in different......

Words: 725 - Pages: 3

Data Analysis

...EDUTL 5901 | Balanced Scorecard: an Empirical Study of Small and Medium Size Enterprises | Data Analysis | Guangting Zheng Guangting Zheng Introduction This study analyzes Balanced Scorecard (BSC) knowledge among small and medium enterprises (SMEs) in Portuguese industry. It basically resolves three problems: Do Portuguese industrial SMEs use the BSC? Are those in charge of management accounting aware of the Balanced Scorecard? Is there any relation between spreading knowledge about the Balanced Scorecard and specific contingency variables? Traditionally managers evaluate performance with exclusively financial measures. The first performance evaluation models were based solely on financial measures (BANKER; MASHRUWALA, 2007; CORONA, 2009; LUFT, 2009; MARTIN; PETTY, 2000). However, over-emphasis on this assessment method may drive managers to try to maximize short-term financial results, thus harming the sustainable development of the company. According to Dearman and Shields (2001), even when using other methods theoretically considered as inadequate, correct management decisions can be made as long as managers are aware of the more adequate methods. Then in 1990, a new model called Balanced Scorecard was proposed. Balanced scorecard (BSC) is a strategy performance management tool, which can be used by managers to keep track of the execution of activities in the company. Now BSC is used not only as performance evaluation, but also as a strategic management......

Words: 943 - Pages: 4

Data Analysis

...DATA ANALYSIS TAKE-HOME EXAM Introduction This report provides an insight into the investment behavior of 50 couples. Using different statistical methods and observing the trend followed by the effect of various independent variables on a single independent variable , a conclusion will be reached. The following are the main tools used for analysis of investment behavior of 50 couples who are selected from a sample size of 194 couples. 1. Descriptive statistics 2.Histograms 3.Pivot tables 4.Multiple Regression In this model , a scrutiny of the above statistical data will give the tendency to invest in retirement plans and the type of couples who invest and take advantage of the attractive investments in order to avail tax exemption. This report also elaborates on how the different independent variables - Number of children, Salary, Mortgage and Debt- have an effect on the dependent variable, i.e. the percentage of salary invested. Consequently the below tasks will be fulfilled. Step 1-Extracting a sample of 50 couples Step 2-Constructing histograms and point estimates with given confidence intervals Step 3-Inference from pivot tables to explain the preferences of different couples on investments based on independent variables Step 4-Performing multivariate regression and conducting significance tests on beta coefficients R^2 and F-tests and hence establish a correlation of different variables and ensuing effect on investments made. Dataset We have a......

Words: 1895 - Pages: 8

Financial Data

... N/A N/A -228% -9 7 5 1 16 Equity In Earnings N/A 0 0 0 0 0 After Tax Other Income/Expense N/A 0 0 0 0 0 Discontinued Operations N/A 0 0 2 -366 0 -12% 2,146 2,452 2,252 1,817 2,124 Minority Interest Net Income Before Extra Items/Preferred Dividends Extra Items & Gain/Loss Sale Of Assets Net Income Before Preferred Dividends Preferred Dividend Requirements N/A 0 0 8 0 0 -12% 2,146 2,452 2,259 1,817 2,124 N/A 0 0 0 0 0 Net Income Available To Common -12% 2,146 2,452 2,252 1,817 2,124 EPS -13% 1.71 1.96 1.82 1.49 1.75 EPS Consensus Analysis For: Wesfarmers Ltd Currency: AUD Current Year (FY1) 10.00 9.59 9.59 9.74 Current Quarter (FQ1) 2.05 9.74 9.34 9.50 9.17 9.05 9.03 9.05 8.81 9.00 9.03 9.12 9.12 2.00 1.99 1.95 Feb Mar 2.01 Apr 2.02 May 1.99 Now 1.90 1.90 8.50 1.85 8.00 1.80 Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Now Dec Jan Next Year (FY2) 11.00 1.99 1.96 Long Term Growth 10.69 10.73 10.64 10.64 10.50 15% 10.03 11.2% 11.2% 11.2% 11.1% 11.0% 10.8%......

Words: 8331 - Pages: 34

Financial Data Analysis

...Financial Data Analysis Patton-Fuller Community Hospital is a for-profit hospital that is owned by the physicians who currently works at the facility. Patton-Fuller was established in 1975 and has since provided innovative care to the surrounding communities of Kelsey. The key to this hospital's success is quality patient care and as shareholders their mission was to provide the best care to their patients (University of Phoenix, 2014). Patton-Fuller Community Hospital has been doing so well they were able to expand to an 600-bed, full-service facility. The hospital is directed by 14 board members, which consist of 12 physicians, the Chief Executive Officer and the Chief Financial Officer (University of Phoenix, 2014). The physicians are the only board members allowed to make any votes. Physicians would only serve 3-year terms, and four new members would come aboard every year in December during the annual shareholder meeting (University of Phoenix, 2014). Additional to the annual shareholder meeting, profits are dispersed to the physicians. Patton-Fuller Community Hospital made 80% of their revenue through inpatient services, which includes surgery, medical-surgical nursing, and intensive care unit. As 20% of their revenue made through outpatient services, the emergency department and other outpatient services (University of Phoenix, 2014). In the review of the financial statements, many events have occurred between the years of 2008-2009. Davis Geach, Chief Executive...

Words: 795 - Pages: 4

Identify the Industry—Analysis of Financial Statement Data

...A01-14-0012 Graeme Rankine Identify the Industry—Analysis of Financial Statement Data Since companies in the same industry face similar opportunities and constraints, they tend to make similar invest- ment, dividend, and financing decisions. Thus, the financial characteristics of firms in the same industry tend to cluster together. For example, old economy businesses with large amounts of tangible assets may have higher leverage ratios because such assets provide good collateral for lenders. Service or trading firms may have large amounts of intangible assets such as knowledge assets or a large and loyal customer base, and, hence, have low leverage ratios because growth options can devalue quickly. On the other hand, companies in different industries tend to exhibit different financial characteristics, as measured by financial ratios, because of cross-sectional dif- ferences in operating and financing decisions. With some knowledge of the different operating, investing, and financing decisions across industries, financial ratios may be used to identify an industry (see Exhibit 1 for the definition of ratios used). Common-sized balance sheets (all items scaled by total assets), common-sized income statements (all items scaled by net sales), and selected financial ratios for the nine companies are provided. Since unusual deviation from target values may occur in any given year, the values for the items were averaged over three years. The three- year average......

Words: 1848 - Pages: 8

Financial Data

...FINANCIAL DATA P1 Oralia N Ramirez FINA310 IP Unit 2 American Intercontinental University FINANCIAL DATA P2 PART 1 In determining the year to year percentage of the annual growth in total net sales for Micro Chip Computer Corporation I decide to use the formula that I used is as followed I used the Percentage Sales Method and a 20 % increased with the sales to be able continue with the problem: 2004 $11,062 I will use this number along with 2005 2005 $11,933 (11,933-11,062) * (100/11,062) 71*100= 87,100/11,062= 7.87% 2006 $ 9,181 (9,181-11,933) * (100/11,933) -2,752*100= -275,200/11,933= -23.06% 2007 $ 6,141 (6,141- 9,181) *(100/ 9,181) -3,040*100= -304,000/6141= -49.50% 2008 $ 8,334 (8,334-6,141) * (100/6,141) 2,193*100= 219,300/6141= 35.71% 2009 $ 9,167 (9167-8,334) * (100/8,334) 833*100= 83,300/8334= 9.99%~10% Below I have added what the 2009 year will look like when all the numbers are plugged in used Microsoft Excel. FINANCIAL DATA P3 Micro Chip Computer Corporation......

Words: 656 - Pages: 3

Financial Data Analysis for Patton Fuller Community Hospital

...Financial Data Analysis for Patton Fuller Community Hospital Bobbie Griffin HCS/577 April 16, 2012 Crystal Chilman University of Phoenix Patton Fuller Community Hospital This paper will analyze the for-profit organization, Patton Fuller Community Hospital, financial data and determine what happened to with the $1 million that Abigail left to the hospital after she passed.  Patton Fuller is very dedicated into providing excellent services to their patients. This community hospital is owned by a group of practicing physicians with the aim of providing quality care to around 600 plus patients in a complete service setting.  Finkler and Ward mentioned that all health care organizationought to demonstrate signs of revenue in order to obtain newer technology and be able to be compete with other organizations (Finkler & Ward, 2006). The community hospital provided a financial report also known as financial audit.   Gapenski stated that a monetary report show the monetary account of an organization from beginning to end, a cash flow statement, income statement and the balance sheet (Gapenski, 2008).  This statement identifies the financial stability of the organization and includes but not limited to the cash flow statements, income statement, and the balance sheet.  The organization’s financial reports show a considerable differentiation between 2008 and 2009. Based on the examination performed for Patton Fuller Community......

Words: 692 - Pages: 3

Web Elements | Republic of Doyle (18) | Bose: Dead/Alive Season 1 – Complete