...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...
Words: 2440 - Pages: 10
...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 should...
Words: 309 - Pages: 2
...SIEGERT’s 190 SELECT A limited edition rum that epitomizes the Siegert legacy of Angostura A combination of warm and passionate aged rums and the company’s unique, iconic aromatic bitters, created in the memory of the only rum made using Angostura® aromatic bitters, Siegert Legacy - “Pink Rum”, and the very first rum made by the Siegerts – “Siegert’s Bouquet”, which became a Trinidadian tradition and was the start of the company’s rich rum heritage in the 1960s. Siegert’s 190 Select is truly a classic, showcasing the company’s creativity in blending which Dr. Johann Siegert, inventor of Angostura® aromatic bitters, was well known for. Full of flavour and aromatic appeal, this rum is like no other dark rum, marrying the strong aromatic strains of the bitters and the robust tones of the rums. It should be sipped neat or on the rocks, and enjoyed in commemoration of the 190 years of tradition that stand behind it. AMARO DI ANGOSTURA® A magnificent herbal liqueur marries spirit, spices and bitter herbs after a 3 month engagement period! Amaro di Angostura® was launched in 2014, crafted as a sophisticated and modern expression of versatility, inspired by our unique Angostura® aromatic bitters, first created in 1824. The result — AMARO DI ANGOSTURA® — an elevation of a classic liqueur to an entirely new world dimension to the category. Amaro di Angostura® can be enjoyed over ice, is splendid on its own and offers delicious harmony in a cocktail. Like...
Words: 24630 - Pages: 99
...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 Selected...
Words: 656 - Pages: 3
...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 common-sized...
Words: 1848 - Pages: 8
...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 Hospital...
Words: 692 - Pages: 3
...◄Ticker WES-AU Wesfarmers Ltd Country: AUSTRALIA Industry: Consumer Services Sector: General Retailers Exchange: ASX - ALL MARKETS General Info as of 03/04/2016 (Currency: AUD) Price (Previous Close): Price - 52 Week High: Price - 52 Week Low: Median Price Target: Balance Sheet Statement (Currency: AUD) 40.37 45.00 36.65 41.44 Cash Left Latest Period at: YoY % Chg Cash & Short Term Investments Dividend Yield (Indicated): P/E (NTM): Shares Outstanding (MIL): Market Cap (MIL): 4.5% N/A 1,126 45,462 Preliminary results included (if available): No (20152014) 2015 2014 2013 2012 2011 -47% 1,139 2,133 2,836 2,467 2,088 -3% 392 403 813 529 361 -57% 747 1,730 2,023 1,938 1,727 Receivables - Net 43% 2,269 1,584 2,341 2,922 2,704 Inventories - Total 3% 5,497 5,336 5,047 5,006 4,987 Raw Materials -4% 112 117 103 92 97 Work In Process 77% 55 31 27 39 48 Finished Goods 3% 5,330 5,188 4,917 4,875 4,842 Short Term Investments Progress Payments And Other Prepaid Expenses N/A N/A N/A N/A 0 0 0 N/A N/A 168 133 92 Other Current Assets -27% 188 258 194 383 347 Current Assets - Total -2% 9,093 9,311 10,586 10,911 10,218 Long Term Receivables N/A 0 0 58 226 480 Investments...
Words: 8331 - Pages: 34
...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 that...
Words: 980 - Pages: 4
...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
...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 due...
Words: 714 - Pages: 3
...to market measures of systematic equity risk was largely undertaken in the 1970s and early 1980s. More recent proposals on changes in accounting disclosure of risk mean that a rigorous theoretical model of the relationship between accounting measures and market measures of risk is timely. In this paper such a model is developed. In addition, the assumptions required to develop the model are explicitly identified. By so doing it becomes possible to identify the potential cross-sectional differences which drive the empirical relationship between accounting and market based measures of risk. The model developed highlights a clear relationship between accounting and market measures of risk which can be exploited in situations where accounting data alone is available. It also provides a framework within which the environmental factors leading to cross-sectional differences between companies can be further explored. On Accounting Flows and Systematic Risk I. Introduction Work that relates accounting numbers to market measures of systematic equity risk was largely undertaken in the 1970s and early 1980s (Ryan, 1997). More recent proposals on changes in accounting disclosure of risk (Scholes, 1996) mean that a theoretically sound model of the relationship between accounting measures and market measures of risk is timely. In addition, the...
Words: 3189 - Pages: 13
...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
...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 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...
Words: 1870 - Pages: 8
...Bond Valuation -Par Value$1000 / 4% coupon Paid Annually -5 years to maturity / Market yield 0 | 1 | 2 | 3 | 4 | 5 | | 40 | 40 | 40 | 40 | 40 | | | | | | 1000 | Calculator Solution N=5 Bond Terminology Face Value or Par Value- Amount to be repaid at end of loan Coupon- Stated interest payment made on bond Coupon Rate- The annual coupon/ Face Value of Bond Maturity- Specific Date the bond principle must be repaid Time to Maturity- the number of years until maturity Yield to Maturity- Return to bond holder if they hold the bond to maturity, Market driven rate, I/Y on your calculator Current Yield= (Annual coupon$/Current bond price) *100 Bond Par Value | 1,000.00 | FV | 1,000 | Years to Maturity | 5.00 | N | 5 | Coupon Rate | 6.0% Paid Annually | PMT | 60.00 | Yield to Maturity | 6.8% | I/Y | 6.80 | Current Price | ???? | CPT PV | | Par Value | 1,000.00 | FV | 1,000 | Years to Maturity | 5.00 | N | 10 | Coupon Rate | 6.0% Paid Semiannually | PMT | 30.00 | Yield to Maturity | 6.8% | I/Y | 3.40 | Current Price | ???? | CPT PV | 966.57 | Bond Information $1,000 Face or Par Values 10 Years to Maturity 6.6% coupon rate/ Paid SEMIANNUALLY Market Yield to Maturity 6.2% N | 20 | I/Y | 3.1 | PMT | 33 | FV | 1000 | CPT PV | $1029.48 | Bond Price | 980.00 | N | 16 | Par Value | 1000.00 | PV | (980.00) | Coupon Rate | 6% PAID SEMIANNUALLY | PMT | 30.00 | Years to Maturity | 8 | FV | 1,000 | Yield to Maturity...
Words: 265 - Pages: 2
...Week 5 What are the implications and effect of tough ethical beginning-of-life and end-of-life decisions? How do these decisions affect the individual, the family, society, and health care providers? The care of beginning-of-life and end-of-life decisions for patients has shifted from family, to community, to health care professionals. Medical professionals have sought ways to improve quality of life from a newborn to a person approaching the end of his or her life’s journey (Carrese & Rhodes, 1995). The effects of such situations on the families, community and health care professionals, can be a difficult decision regarding a patient’s medical treatment. These decisions can cause conflict between family members and health care professionals and community because of religious beliefs, moral principles and professional guidelines. These types of ethical issues arise when individuals are unclear about what is best for a patient and his or her quality of life. This is why it is important for a patient to have an advance directive in place so that he or she can communicate all end of life wishes. Family members should not be left with having to arrive at an appropriate decision When a decision pertains to a beginning-of-life dilemma the ethical principal of autonomy should be applied. A parent’s decision regarding the care and treatment of their newborn should be based off what is best for the child and not on the parent’s personal morals or religious beliefs...
Words: 492 - Pages: 2
