Financial Analysis Project

In: Business and Management

Submitted By tootie1125
Words 1970
Pages 8
Financial Analysis Project-Final Paper
Ladrica McRae
MBA 503
February 28, 2016

Purpose of Analysis All managers and investors needs to know and understand how well they are performing in their industry against competitors and to make sure they are meeting goals that they set for themselves as a company. This will also help them understand their risk and profitability as a company. The food industry is very diverse in the United States and Internationally.
Company Background and History Starbucks corporation, an American company founded in 1971 in Seattle, WA is a premier roaster marketer and retailer of specialty coffee around the world. Starbucks has about 182,000 employees across 19,767 company operated and licensed stores in 62 countries. Their product mix includes roasted and handcraft high quality premium priced coffees, teas, a variety of fresh food items and other beverages. They also sell a variety of natural food service accounts. Starbucks had a total revenue of $14.89 billion as of September 29th 2013. (Greedy) Starbucks receivables are mainly comprised of receivables for products and equipment sales and royalties from their licenses, as well as from receivables from CPG and foodservice business customers. Their allowances for doubtful accounts is calculated based on historical expense, customer credit risk and applications of specific identification method. As of September 28th 2014 and September 29th 2013, the allowance for doubtful account was $6.7 million and $5.7 million respectively and property, plant, equipment which includes assets under capital lease are carried at cost less accumulated depreciation. Although Starbucks corporation current assets declined from 2013-2014, but then slightly increased from 2014-2015. Cost includes all direct cost necessary to acquire and prepare assets for use and it includes internal labor and…...

Similar Documents

Busn460 Individual Financial Analysis Project

...BUSN460 Individual Financial Analysis Project |   |   |   |   | Student Name: | | | | | | Instructions: | | | | | | | Go to the CanGo intranet found in the Report Guide tab under Course Home | | | | | Use the financial statements from the most recent year to fill in the table below. | | | | | You may find some formulae calling for an average, e.g., average inventory, average receivables. | | | | Because we only have the Balance sheet for one year, you can only use the one year number not an average. | | | Assume interest expense is $0.00 | | | | | | Be careful of the Debt equity ratio. The review covers debt asset ratio as an example of how to calculate ratios and that is different from debt equity ratio, | | and that is different from the debt equity ratio so think about how you calculate the debt equity ratio using the debt asset ratio as an example. | | Be sure to cite your references | | | | | | Green boxes to be filled in by instructor | | | | | | Ratio | Formula (express the ratio in words) | Detailed calculation (actual numbers from financial statements used for the calculation) | Final number (final result of the detailed calculation) | Explanation of why ratio is important | Earned points (up to 3 points per "box"/cell) | Instructor feedback | Example: | Term A/Term B (Term A divided by Term B) | 1000/2000 | .50 | This is the explanation of the role of this ratio and why it is important | 3 |   | ...

Words: 577 - Pages: 3

Final Project - Financial Analysis

...The purpose of this paper is to provide a financial comparison of PepsiCo, Inc. and Coca Cola company. The comparison will reveal the financial status of each company according to the consolidated statements of income and the balance sheets provided for both companies. Current Ratio * Pepsico Inc. Consolidated Balance Sheet 2005 | 2004 | $31,727/$17,476 = 1.81 | $27,987/$14,464 = 1.93 | Answer – 1.81:1 | Answer – 1.93:1 | * Coca Cola Company’s Consolidated Balance Sheet 2005 | 2004 | $10,250/$9,836= 1.04 | $12,281/$11,133 = 1.10 | Answer – 1.04:1 | Answer – 1.10:1 | Horizontal Analysis * Pepsico Inc. Consolidated Balance Sheet $10,454/$8,639 = 1.21% $9,406/$6,752 = 1.39% * Coca Cola Company’s Consolidated Balance Sheet $10,250/$12,281 = 0.83% $9,836/$11,133 = 0.88% Vertical Analysis * Pepsico Inc. Consolidated Balance Sheet Current Assets | 2005 | 2004 | $10,454/$31,727 x 100 | $8,639/$7,987 x 100 | 32.94% | 30.86% | Current Liabilities | 2005 | 2004 | $9,406/$17,476 x 100 | $6,752/$14,464 x 100 | 53.82% | 46.68% | * Coca Cola Company’s Consolidated Balance Sheet Current Assets | 2005 | 2004 | $10,250/$29,427 x 100 | $12,281/$31,447 x 100 | 34.83% | 39.05% | Current Liabilities | 2005 | 2004 | $9,836/$29,427 x 100 | $11,133/$31,441 x 100 | 33.42% | 35.40% | Current Ratio * Pepsico Inc. Consolidated Statements of Income 2005 | 2004 | $31,727/$17,476 = 1.81 | $27,987/$14,464 =......

Words: 424 - Pages: 2

General Mills - Financial Analysis Project

...billion to their equity holders from dividends of $1.55 per share. However, General Mills as of 02/12/15 has a market share or value of $52.93. GM has 43,000 employees worldwide. The officers currently working for General Mills are: Y. Marc Belton, age 53, is Executive Vice President for Global Strategy, Growth and Marketing Innovation; John R. Church, age 46, is Senior Vice President of the Supply Chain; Michael L. Davis, age 56, is Senior Vice President of Global Human Resources; Peter C. Erickson, age 51, is Senior Vice President of Innovation, Technology and Quality; Ian R. Friendly, age 51, is Executive Vice President and Chief Operating Officer for their U.S. Retail; Donal L. Mulligan, age 51, is Executive Vice President as the Chief Financial Officer; Kimberly A. Nelson, age 49, is Senior Vice President for External Relations, and President of the General Mills Foundation; Shawn P. O’Grady, age 48, is Senior Vice President and President of the Consumer Foods Sales Division; Christopher D. O’Leary, age 52, is Executive Vice President and Chief Operating Officer of International relations; Roderick A. Palmore, age 60, is Executive Vice President, General Counsel, Chief Compliance and Risk Management Officer as well as Secretary; Kendall J. Powell, age 58, is Chairman of the Board and Chief Executive Officer of General Mills; lastly, Jerald A. Young, age 55, is Vice President and Controller. As a whole, the retail food and beverage industry sales grew just 1.5 percent......

Words: 2177 - Pages: 9

Sec 10-K Financial Statement Analysis Project

...SEC 10-K FINANCIAL STATEMENT ANALYSIS PROJECT Click Link Below To Buy: http://hwcampus.com/shop/sec-10-k-financial-statement-analysis-project/ SEC 10-K FINANCIAL STATEMENT ANALYSIS PROJECT (Wallmart and CA, Inc,) 10 K – SEC Analysis Project A written Case Analysis is required for this course. The project is expected to consist of comprehensive and relevant responses to all the requirements of the Case Analysis. Requirements of the Case Analysis, which require computation, must be prepared using Microsoft Excel or Word or both and all the work must be presented in a detailed manner. Requirements of the Case Analysis which require a written response are expected to consist of an introduction, well-referenced body with appropriate headings and sub-headings, conclusion and reference list. APA style is required. Completed papers will typically be 4-5 pages in length and must read as a well-edited, professional paper. All papers will be typed, double-spaced, spell-checked, grammar-checked, and prepared in APA format. Go the SEC website http://www.sec.gov/edgar/searchedgar/companysearch.html 1. Click on “Company Filings” , then click on “Company or fund name, ticker symbol, CIK ….” 2. Type in the CIK (or company name). (Sometimes there may be multiple options available; use your judgment, and click on the right link). 3. Once you get the list of forms filed for the company, type “10-K” in the Form Type box. Now, only Form 10-Ks filed will......

Words: 566 - Pages: 3

Finance Final Project Financial Company Analysis

...Finance Final project Financial Company Analysis Click Link Below To Buy: http://hwcampus.com/shop/finance-final-project-financial-company-analysis/ Or Visit www.hwcampus.com 1. Final project: Financial Company Analysis The course project will require students to complete a thorough financial analysis of an assigned publicly traded corporation. The project deliverable will be a in a structured Word document that includes embedded Excel spreadsheets. During Week 1 students will be given a publicly-traded company to research. Project requirements must include the following analysis: a. One page description of the corporation: it’s products, markets, b. Overall trend assessment of the company’s balance sheet, income statement, and statement of cash flows for the last three years. c. Selected ratio and trend analysis. Ratios must include liquidity, asset management, solvency, profitability, and market value ratios. A three-year ratio analysis is the minimum expectation. d. Analysis of the company’s stock price and EPS trends for the last three years. Analysis must include comparison to key market competitors. e. Evaluation of the firm’s Beta in relation to a specified market index (eg. S&P 500, Nasdaq 100, Dow 30). f. Assessment of the firm’s capital structure including any significant changes in the firm’s capital structure over the last three to five years. g. Calculate the WACC (weighted average cost of capital) based on the most recent......

Words: 451 - Pages: 2

Finance Final Project Financial Company Analysis

...Finance Final project Financial Company Analysis Click Link Below To Buy: http://hwcampus.com/shop/finance-final-project-financial-company-analysis/ Or Visit www.hwcampus.com 1. Final project: Financial Company Analysis The course project will require students to complete a thorough financial analysis of an assigned publicly traded corporation. The project deliverable will be a in a structured Word document that includes embedded Excel spreadsheets. During Week 1 students will be given a publicly-traded company to research. Project requirements must include the following analysis: a. One page description of the corporation: it’s products, markets, b. Overall trend assessment of the company’s balance sheet, income statement, and statement of cash flows for the last three years. c. Selected ratio and trend analysis. Ratios must include liquidity, asset management, solvency, profitability, and market value ratios. A three-year ratio analysis is the minimum expectation. d. Analysis of the company’s stock price and EPS trends for the last three years. Analysis must include comparison to key market competitors. e. Evaluation of the firm’s Beta in relation to a specified market index (eg. S&P 500, Nasdaq 100, Dow 30). f. Assessment of the firm’s capital structure including any significant changes in the firm’s capital structure over the last three to five years. g. Calculate the WACC (weighted average cost of capital) based on the most recent......

Words: 451 - Pages: 2

Acta 337 Financial Statement Analysis Project & Rubric

...ACTA 337 Financial Statement Analysis Project & Rubric Click Link Below To Buy: http://hwaid.com/shop/acta-337-financial-statement-analysis-project-rubric/ Financial Statement Analysis Project & Rubric Purpose: Students will assume the role of senior management or the board in analyzing the current financial performance of the firm using peer and trend ratio analysis and the Statement of Cash Flows. Deliverable: The final product will be a typed report that includes financial and ratio data and analysis. Ratio calculations should be calculated in Excel using formulas. The analysis portion of the report may be completed in Excel or Word. Steps: 1. Choose a publicly traded firm to analyze. Choices must be approved by the instructor and only one student may choose each firm. 2. Obtain three years of financial information, including the balance sheet, income statement, and statement of cash flows. 3. Compile financial information in Excel in such a way that ratios may be easily calculated for each of the three years. 4. Calculate the ratios discussed in Chapter 17 of the textbook. 5. Conduct peer and trend analysis for each ratio or groups of ratios. Find industry information or specific firm information to conduct the peer analysis. 6. Conduct trend analysis of the Statement of Cash Flows. Assess this year’s statement for noteworthy events or activities. 7. Provide an overall assessment of the firm’s financial performance. Rubric: Category Maximum......

Words: 311 - Pages: 2

Acta 337 Financial Statement Analysis Project & Rubric

...ACTA 337 Financial Statement Analysis Project & Rubric http://homeworklance.com/downloads/acta-337-financial-statement-analysis-project-rubric/ Financial Statement Analysis Project & Rubric Purpose: Students will assume the role of senior management or the board in analyzing the current financial performance of the firm using peer and trend ratio analysis and the Statement of Cash Flows. Deliverable: The final product will be a typed report that includes financial and ratio data and analysis. Ratio calculations should be calculated in Excel using formulas. The analysis portion of the report may be completed in Excel or Word. Steps: 1. Choose a publicly traded firm to analyze. Choices must be approved by the instructor and only one student may choose each firm. 2. Obtain three years of financial information, including the balance sheet, income statement, and statement of cash flows. 3. Compile financial information in Excel in such a way that ratios may be easily calculated for each of the three years. 4. Calculate the ratios discussed in Chapter 17 of the textbook. 5. Conduct peer and trend analysis for each ratio or groups of ratios. Find industry information or specific firm information to conduct the peer analysis. 6. Conduct trend analysis of the Statement of Cash Flows. Assess this year’s statement for noteworthy events or activities. 7. Provide an overall assessment of the firm’s financial performance. Rubric: Category Maximum Points......

Words: 306 - Pages: 2

Acta 337 Financial Statement Analysis Project & Rubric

...ACTA 337 Financial Statement Analysis Project & Rubric http://homeworklance.com/downloads/acta-337-financial-statement-analysis-project-rubric-2/ Financial Statement Analysis Project & Rubric Purpose: Students will assume the role of senior management or the board in analyzing the current financial performance of the firm using peer and trend ratio analysis and the Statement of Cash Flows. Deliverable: The final product will be a typed report that includes financial and ratio data and analysis. Ratio calculations should be calculated in Excel using formulas. The analysis portion of the report may be completed in Excel or Word. Steps: 1. Choose a publicly traded firm to analyze. Choices must be approved by the instructor and only one student may choose each firm. 2. Obtain three years of financial information, including the balance sheet, income statement, and statement of cash flows. 3. Compile financial information in Excel in such a way that ratios may be easily calculated for each of the three years. 4. Calculate the ratios discussed in Chapter 17 of the textbook. 5. Conduct peer and trend analysis for each ratio or groups of ratios. Find industry information or specific firm information to conduct the peer analysis. 6. Conduct trend analysis of the Statement of Cash Flows. Assess this year’s statement for noteworthy events or activities. 7. Provide an overall assessment of the firm’s financial performance. Rubric: Category Maximum Points......

Words: 307 - Pages: 2

Finance Final Project Financial Company Analysis

...Finance Final project Financial Company Analysis Click Link Below To Buy: http://hwcampus.com/shop/finance-final-project-financial-company-analysis/ Or Visit www.hwcampus.com 1. Final project: Financial Company Analysis The course project will require students to complete a thorough financial analysis of an assigned publicly traded corporation. The project deliverable will be a in a structured Word document that includes embedded Excel spreadsheets. During Week 1 students will be given a publicly-traded company to research. Project requirements must include the following analysis: a. One page description of the corporation: it’s products, markets, b. Overall trend assessment of the company’s balance sheet, income statement, and statement of cash flows for the last three years. c. Selected ratio and trend analysis. Ratios must include liquidity, asset management, solvency, profitability, and market value ratios. A three-year ratio analysis is the minimum expectation. d. Analysis of the company’s stock price and EPS trends for the last three years. Analysis must include comparison to key market competitors. e. Evaluation of the firm’s Beta in relation to a specified market index (eg. S&P 500, Nasdaq 100, Dow 30). f. Assessment of the firm’s capital structure including any significant changes in the firm’s capital structure over the last three to five years. g. Calculate the WACC (weighted average cost of capital) based on the most recent......

Words: 451 - Pages: 2

Acta-337 Financial Statement Analysis Project & Rubric

...ACTA-337 Financial Statement Analysis Project & Rubric http://homeworklance.com/downloads/acta-337-financial-statement-analysis-project-rubric-2/ Copy & paste above Link Into your Browser to Buy Tutorial Or Visit: www.homeworklance.com Financial Statement Analysis Project & Rubric Purpose: Students will assume the role of senior management or the board in analyzing the current financial performance of the firm using peer and trend ratio analysis and the Statement of Cash Flows. Deliverable: The final product will be a typed report that includes financial and ratio data and analysis. Ratio calculations should be calculated in Excel using formulas. The analysis portion of the report may be completed in Excel or Word. Steps: 1. Choose a publicly traded firm to analyze. Choices must be approved by the instructor and only one student may choose each firm. 2. Obtain three years of financial information, including the balance sheet, income statement, and statement of cash flows. 3. Compile financial information in Excel in such a way that ratios may be easily calculated for each of the three years. 4. Calculate the ratios discussed in Chapter 17 of the textbook. 5. Conduct peer and trend analysis for each ratio or groups of ratios. Find industry information or specific firm information to conduct the peer analysis. 6. Conduct trend analysis of the Statement of Cash Flows. Assess this year’s statement for noteworthy events or activities. 7. Provide an......

Words: 322 - Pages: 2

Financial Analysis Team Project

...Financial Analysis Team Project Overview: Your team works for a major mutual fund management company. Your boss is the lead fund manager for a technology investment fund specializing in an area set forth below. Your task is to develop a professional, 10- to 15-minute (maximum) presentation dealing with investment in the technology area of your fund. Because the fund company is paying you "top dollar" to guide investment decisions, your boss expects your presentation to be "top quality." At a minimum, this means that your presentation will make use of computer presentation technology (PowerPoint slides and/or the Internet), appropriate handouts, etc., to present an overview of investment opportunities and strategy in your technology area. Remember, your presentation is to be directed at a fund manager who makes buy/sell decisions based on your recommendations, not at a class. This means that, although there are questions listed below to guide you, your presentation should not be a series of answers to the questions. Instead, it should be a professional presentation dealing with the knowledge and information needed to guide investment policy. Any presenter who makes a statement such as, "The second question we had to answer was ...," will earn a 10-point deduction for his/her team on this project. Deliverable: The team will prepare a 15 slide (max) PowerPoint presentation that emphasizes charts and graphs, keeping text to a minimum. A two-page (max) narrative will......

Words: 323 - Pages: 2

Acta 337 Financial Statement Analysis Project & Rubric

...ACTA 337 Financial Statement Analysis Project & Rubric Follow Below Link to Download Tutorial http://homeworklance.com/downloads/acta-337-financial-statement-analysis-project-rubric/ For More Information Visit Our Website ( http://homeworklance.com/ ) Email us At: Support@homeworklance.com or lancehomework@gmail.com Financial Statement Analysis Project & Rubric Purpose: Students will assume the role of senior management or the board in analyzing the current financial performance of the firm using peer and trend ratio analysis and the Statement of Cash Flows. Deliverable: The final product will be a typed report that includes financial and ratio data and analysis. Ratio calculations should be calculated in Excel using formulas. The analysis portion of the report may be completed in Excel or Word. Steps: 1. Choose a publicly traded firm to analyze. Choices must be approved by the instructor and only one student may choose each firm. 2. Obtain three years of financial information, including the balance sheet, income statement, and statement of cash flows. 3. Compile financial information in Excel in such a way that ratios may be easily calculated for each of the three years. 4. Calculate the ratios discussed in Chapter 17 of the textbook. 5. Conduct peer and trend analysis for each ratio or groups of ratios. Find industry information or specific firm information to conduct the peer analysis. 6. Conduct trend analysis of the Statement of Cash......

Words: 331 - Pages: 2

Acta 337 Financial Statement Analysis Project & Rubric

...ACTA 337 Financial Statement Analysis Project & Rubric Follow Below Link to Download Tutorial http://homeworklance.com/downloads/acta-337-financial-statement-analysis-project-rubric-2/ For More Information Visit Our Website ( http://homeworklance.com/ ) Email us At: Support@homeworklance.com or lancehomework@gmail.com Financial Statement Analysis Project & Rubric Purpose: Students will assume the role of senior management or the board in analyzing the current financial performance of the firm using peer and trend ratio analysis and the Statement of Cash Flows. Deliverable: The final product will be a typed report that includes financial and ratio data and analysis. Ratio calculations should be calculated in Excel using formulas. The analysis portion of the report may be completed in Excel or Word. Steps: 1. Choose a publicly traded firm to analyze. Choices must be approved by the instructor and only one student may choose each firm. 2. Obtain three years of financial information, including the balance sheet, income statement, and statement of cash flows. 3. Compile financial information in Excel in such a way that ratios may be easily calculated for each of the three years. 4. Calculate the ratios discussed in Chapter 17 of the textbook. 5. Conduct peer and trend analysis for each ratio or groups of ratios. Find industry information or specific firm information to conduct the peer analysis. 6. Conduct trend analysis of the Statement of Cash......

Words: 332 - Pages: 2

Financial Analysis Project

...Introduction Financial analysis (also referred to as financial statement analysis or accounting analysis) refers to an assessment of the viability, stability and profitability of a business, sub-business or project. It is defined as “The process of evaluating businesses, projects, budgets and other finance-related entities to determine their suitability for investment.” Typically, financial analysis is used to analyze whether an entity is stable, solvent, liquid, or profitable enough to be invested in. When looking at a specific company, the financial analyst will often focus on the income statement, balance sheet, and cash flow statement.  In any organization, the two important financial statements are the Balance sheet & Profit and loss account of the business. Balance sheet is a statement of the financial position of an enterprise at a particular point of time. Profit and loss account shows the net profit or net loss of a company for a specified period of time. When these statements of the last few year of any organization are studied and analyzed, significant conclusions may be arrived regarding the changes in the financial position, the important policies followed and trends in profit and loss etc. Analysis of financial statement is necessary because it help in depicting the financial position on the basis of past and current records. Analysis of financial statement help in making the future decision and strategies.......

Words: 336 - Pages: 2