Financial Analysis of GlaxoSmithKline Liquidity Ratio 1. Current ratio Year | 2007 | 2008 | 2009 | 2010 | 2011 | Current Ratio: | 4.64 times | 2.96 times | 3.11 times | 2.59 times | 2.05 times | Interpretation: In 2011‚ the company’s current assets were 2.05 times the current liabilities. The current ratio has been decreasing significantly over the years and this clearly indicates that the current ratio is not in a good shape. In 2011‚ although the current assets have increased
Premium Balance sheet Asset Inventory
Date: February 8‚ 2013 To: Dr. Harland Hodges From: Kacie Burton Subject: Evaluation of HCA’s financials The following is an analysis of HCA’s financial statements and an explanation of changes in revenue; cost of goods sold to sales; selling‚ general‚ and administrative to sales; accounts receivable turnover; inventory turnover; plant property‚ and equipment; and accounts payable turnover. Income Statement During the past year‚ total revenue increased by 5.9%‚ a near $1.6 billion
Premium Health care Health insurance
Nike Financial Analysis Nike is a company that has thoroughly embedded itself into the psyche of people around the world. It’s a company that started with humble origins from selling footwear in the basement to becoming the behemoth in the athletic industry. Bill Bowerman‚ University of Oregon track & field coach‚ and Phil Knight‚ middle-distance runner under Bowerman co-founded Nike. Nike was first established as Blue Ribbon Sports in 1964 as a partnership and the name Nike was officially adopted
Premium Dividend Stock market Stock
Personal Budget Exercise – MS Excel (These instructions are also attached here as a Word document) Creating a spreadsheet to track personal expenses is an excellent use of Microsoft Excel. For this exercise‚ you will create a spreadsheet to enter a personal budget and track actual expenses for the year. You may choose to use real data or create a fictitious budget using a monthly income amount of $2‚500. Here are suggested budget categories if you are not using a real budget. At a minimum‚ you
Premium Spreadsheet Typography Microsoft Excel
References: www.finance.yahoo.com http://topics.nytimes.com/top/news/business/companies/pfizer_inc/index.html http://www.stock-analysis-on.net/NYSE/Company/Pfizer-Inc/Ratios/Profitability http://en.wikipedia.org/wiki/Pfizer
Premium Financial ratios Financial ratio Generally Accepted Accounting Principles
ADMN919: Financial Accounting Project Company: Amazon.com Bikram Gautam UNH (MANCHESTER) Q1 - 9. Brief Description of the Company: Founder and CEO Jeff Bezos opened the virtual doors of Amazon.com’s online store in July 1995. The company was incorporated in 1994 in the state of Washington and reincorporated in 1996 in Delaware. The Company’s principal corporate offices are located in Seattle‚ Washington. Amazon.com completed its initial public offering in May 1997‚ and its common stock
Premium Generally Accepted Accounting Principles Balance sheet Income statement
Today‚ the most popular spreadsheet can be said to be Microsoft Excel which was developed in the 1980’s. The purpose of this term-paper is to introduce at other spreadsheets other than Microsoft Excel. VISICALC This is the first electronic spreadsheet to be made available on personal computers. The idea originated from Dan Bricklin‚ a business administration student at Harvard University. He desired a better way in dealing with financial processes instead of using the traditional manual spreadsheets
Premium Spreadsheet
Contents References_________________________________________________________________1 Company Overview AT&T is one of the largest provider of long distance and local telephone services in the United States. It became At&t in the year 1857‚ Alexander Graham Bell and two others agreed on this company. One of their first openings were in New Haven‚ Ct in 1878. The company starting name was American Bell Telephone Company. The acronyms standing for AT&T mean (American Telephone and Telegraph
Premium Alexander Graham Bell Revenue Income statement
1 More 0 Q1 Descriptive Statistics Excel Worksheet b Q2 d Q3 e Q4 b 5. For the following sample of scores: 2‚ 6‚ 1‚ 4‚ 2‚ 2‚ 4‚ 3‚ 2 Mean variance standard deviation 2.889 2.099 1.537 Find the mean‚ variance and standard deviation 6. A sample of size 7 (n = 7) has a mean of M = 9. One of the sample scores is changed from x = 19 to x = 5. What is the value for the new sample mean? New Sample Mean 7 7. Using Excel create a histogram and a line graph using
Premium Standard deviation Variance Arithmetic mean
time‚ with a market price of $47.50. Liquidity In 2011‚ Walmart’s current ratio is .89‚ and the industry average for the year is 1.19 (Stock-analysis) When comparing Walmart’s current ratio to the range of comparability it is substantially different in a negative way. The quick ratio for Walmart’s is .21 and the industry average is .45(stock-analysis). The quick ratio also falls on the positive side of the range of comparability that is shown in appendix B. While viewing the historical values
Premium Financial ratios Financial ratio Generally Accepted Accounting Principles