Premium Essay

Financial Data

In: Business and Management

Submitted By jeffxiib
Words 2440
Pages 10
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 that operates a network of stores throughout the UK and aims to be the largest and most profitable carpet retailer in the UK. The market for floor coverings has not been very buoyant in recent years and for MCC’s year ended 30 April 2008 there was no growth in the market at all.

Given the general state of the market and the ambition of the business, MCC has committed itself to increasing sales…...

Similar Documents

Premium Essay

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

Premium Essay

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

Premium Essay

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

Premium Essay

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

Free Essay

Financial Data Analysis

...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 billion. This was Le2.788 billion or 1.72% higher than the projected figure (Le162.086 billion). Reasons for the deficit were mainly due to the eight months back-log pay (Le3.126 billion) to 1,597 newly recruited teachers for the period September 2009 to April 2010. In addition to the one-off payment (Le3.494 billion) made to teachers in December 2010. * Miscellaneous: Le5.755 billion was expended in respect of unbudgeted salary and salary related claims. Despite the high wage bill expended during the year, it is worth noting that the overall payroll process was executed under strict internal control procedures to minimise wastages. The use of various payroll reports to review data inputs, validation checks, variance analysis, etc were being used to ensure efficiency. It is important also to note that the nature by which the payroll was being process affects the status of the total monthly workforce and cost. The fluctuations shown on......

Words: 1870 - Pages: 8

Premium Essay

Analyzing Financial Data

...Analyzing Financial Data Dereca Akins ACC/230 August 15, 2014 Jean Petrie Analyzing Financial Data | Alternative 1 (Debt) | Alternative 2 (Equity) | Debt ratio | | | Times interest earned | | | Operating profit | 18 million | 18 million | Interest expense | 6.3 million | 4.8 million | Earnings before tax | 11.7 million | 13.2 million | Income tax expenses (40%) | 4,680,000 | 5,280,000 | Net earnings | 7,020,000 | 7,920,000 | Earnings per share | $8.78 for 800,000 shares | $7.92 for 1,000,000 shares | Return on Equity | = 0.1404 or 14.04% | | Adjusted Return on Assets | = 0.108 or 10.8% | or 10.8% | Financial Leverage Index | | | I think that the board should take a look at both scenarios before deciding on which financing route they decide to take. They should consider the change of the ratios in comparison to the numbers that they already represent prior to investing. For instance the debt ratio would decrease 4% if Laurel decided to use the equity financing, proving it to be the better choice based on possible debt (Fraser & Ormiston, 2007, 232). On the other hand earnings per share is higher when using debt financing than it previously was ($7.65) or would be with the equity finance ($7.92) (Fraser & Ormiston, 2007, 232). Likewise, in both cases the financial leverage index is greater than one, which means that the company’s ability to handle debt is well managed. Overall the board......

Words: 309 - Pages: 2

Premium Essay

Financial Data Analysis

...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...

Words: 1359 - Pages: 6

Premium Essay

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

Free Essay

Acc 230 Week 8 Analyzing Financial Data

...ACC 230 WEEK 8 ANALYZING FINANCIAL DATA To Download this course, visit this link http://www.nerdypupil.com/product/acc-230-week-8-analyzing-financial-data/ Or email us at support@nerdypupil.com ACC 230 WEEK 8 ANALYZING FINANCIAL DATA CheckPoint: Analyzing Financial Data Resource:Ch. 6 of Understanding Financial Statements Complete Problem 6.6 on p. 232 (Ch. 6). Submit your answers to questions A and B. Home Work Hour aims to provide quality study notes and tutorials to the students of ACC 230 Week 8 Analyzing Financial Data in order to ace their studies. ACC 230 WEEK 8 ANALYZING FINANCIAL DATA To Download this course, visit this link http://www.nerdypupil.com/product/acc-230-week-8-analyzing-financial-data/ Or email us at support@nerdypupil.com ACC 230 WEEK 8 ANALYZING FINANCIAL DATA CheckPoint: Analyzing Financial Data Resource:Ch. 6 of Understanding Financial Statements Complete Problem 6.6 on p. 232 (Ch. 6). Submit your answers to questions A and B. Home Work Hour aims to provide quality study notes and tutorials to the students of ACC 230 Week 8 Analyzing Financial Data in order to ace their studies. ACC 230 WEEK 8 ANALYZING FINANCIAL DATA To Download this course, visit this link http://www.nerdypupil.com/product/acc-230-week-8-analyzing-financial-data/ Or email us at support@nerdypupil.com ACC 230 WEEK 8 ANALYZING FINANCIAL DATA CheckPoint: Analyzing Financial Data Resource:Ch. 6 of Understanding Financial......

Words: 481 - Pages: 2

Free Essay

Financial Data of Angustora

...Limited, (the “Company”) will be held at the House of Angostura, Angostura Complex, Eastern Main Road, Laventille, Trinidad and Tobago, on Monday July 27, 2015 at 10:00 am for the following purposes: 1. To receive, consider and approve the Report of the Directors, the Audited Financial Statements of the Company for the financial year ended December 31, 2014, together with the report of the Auditors thereon, and 2. To appoint Messrs. KPMG as auditors of the Company for the financial year ending December 31, 2015, and authorise the Directors to fix their remuneration therefor, and 3. To re-elect Directors. BY ORDER OF THE BOARD Lyn Patricia Lopez Secretary June 30, 2015 NOTES 1. Every member who is entitled to attend and vote at the meeting is entitled to appoint a proxy to attend and on a poll to vote in that member’s place. A proxy need not be a member of the company. Where a proxy is appointed by a corporate member, the form of proxy should be executed under seal or be signed by its attorney 2. No service contracts not expiring or determinable within 10 years have been entered into between the company and any of its directors 3. To obtain a soft copy of the consolidated financial statements for the year ended 2014, please log onto on our website (www.angostura.com) 4. Queries may be directed to the Company Secretary at 623 1841 ext. 123 or lopezl@angostura.com Angostura Holdings Limited • Annual Report 2014 Table of......

Words: 24630 - Pages: 99

Premium Essay

Financial Data

...recommendations always supersede previously published research recommendations of the broker Key terminology used in Analyst Recommendation Model includes: Strong Buy : A Strong Buy rating is a broker's highest recommendation and means that broker believes the stock will outperform the market as compared to its peer group of companies and the company will display positive financial performance. Buy: A stock with a Buy recommendation is considered to perform in the market. The assessment is done on the basis of fundamentals of the companies, near term outlook and confidence in earning estimates of the company Hold: A stock with a Hold recommendation means the broker is neutral in his opinion on stock's performance. The stock with this recommendation is likely to perform in line with the market performance Underperform: The stock with an Underperform recommendation is not likely to perform in line with market returns Sell: A Sell recommendation by a broker means the broker believes the investor should sell the security as the company will perform below market expectations and deliver negative financial performance Inputs needed from the user: Start Date : The first period for which the analyst-by-analyst detail estimates is required (Cell F36) End Date : The last period up to which the analyst-by-analyst detail estimates is required (Cell I36) Note: Start date and end date are on a monthly basis and last two years' date period range is......

Words: 8331 - Pages: 34

Premium Essay

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

Premium Essay

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

Premium Essay

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

Premium Essay

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