Financial information and tools

Assignment Help Finance Basics
Reference no: EM131628227

THIS IS A GROUP PROJECT I JUST NEED AT LEAST 200WORDS FOR MY PART. THE COMPANY WE'RE DOING IS PEPSICO. MY PART IS THE GROSS PROFIT MARGIN AND EQUITY MULTIPLIER WHICH I'VE PUT IN BOLD AND UNDERLINED. THE NUMBERS HAVE TO BE ACCURATE AND FROM 2015 AND 2016. THE WEBSITES WHERE YOU CAN ACCESS THE INFORMATION ARE DOWN AT THE BOTTOM WHICH I'VE ALSO BOLDED AND UNDERLINED.

Purpose of Assignment

Students should understand how to use the financial information and tools learned in the class on a public company, obtain public company SEC reports, and use that data to calculate a company's financial ratios and their comparison to industry or competitor standards.

Assignment Steps 

Resources: Tutorial help on Excel® and Word functions can be found on the Microsoft®Office® website. There are also additional tutorials via the web that offer support for office products.

Select one of the publicly traded corporations listed below and obtain the most current SEC Form 10-K (annual financial report) from the company's web site (Do not use the Annual Report that is sent to shareholders):

  • Lowes Corporation
  • Kroger Corporation
  • Harley Davidson Corporation
  • Apple Corporation
  • Intel Corporation
  • Marriott Corporation
  • Berkshire Hathaway Corporation
  • PepsiCo Corporation
  • Procter and Gamble Corporation
  • General Electric Corporation

Calculate and analyze the following ratios for your selected company for the last two years from the SEC Form 10-K:

  • Current Ratio
  • Inventory Turnover
  • Debt Ratio
  • Time Interest Earned
  • Gross Profit Margin
  • Equity Multiplier
  • Return on Assets
  • Net Profit Margin
  • Return on Equity (Use three ratio DuPont method)

Compare and contrast your company's ratios to industry and competitor standard ratios obtained from Yahoo Finance, Morningstar, MotleyFool, Macroaxis or other Internet sources, and provide a detailed answer and analysis as to why your company's ratios are different than the industry/competitor standard.

Prepare your analysis in a minimum of 875words in Microsoft® Word. The use of Microsoft®Word tables is encouraged.

Cite the source of the industry/competitor ratio information.

Format your assignment consistent with APA guidelines.

Reference no: EM131628227

Questions Cloud

Find the overhead for each department based on sales : Overhead for one month at the Allimore Department Store totaled $6,000. Find the overhead for each department, based on sales, if the store had the following.
Describes impact of globalization on us businesses : Prepare a 4-6 page paper that describes the impact of globalization on U.S. businesses. In your analysis, please include information about the impact of at leas
Relationship of surplus to premiums : In view of the relationship of surplus to premiums that may be written, a severe decline in the stock market is likely to serve as a brake on price-cutting.
Focus on same-store sales : 1) Why might companies focus on same-store sales rather than total sales?
Financial information and tools : Students should understand how to use the financial information and tools learned in the class on a public company, obtain public company SEC reports.
What characteristics would you look for : Your firm is about to begin exporting. In selecting an export intermediary, what characteristics would you look for? What forms of exporting are available?
What type of insurance policy would you recommend : John Jones is married, with a son, and would like to purchase enough life insurance to provide the following for his family.
Explain rather than strict performance : Courts usually require substantial performance of one's duties under a contract rather than strict performance
How should scf negotiate with acl : How should SCF negotiate with ACL? How can SCF and ACL develop a positive, long-range relationship? Give some specifics.

Reviews

Write a Review

Finance Basics Questions & Answers

  Why did new technology made it harder to enforce limitations

Why did new technology made it harder to enforce limitations on bank branching?

  What is the ytm for a twenty year bond

What is the YTM for a 20 year bond with an 8% coupon if the price is 98.50?

  Determining the independent samples

One of our researchers wishes to determine whether people with high blood pressure can reduce their systolic blood pressure by taking a new drug we have develop

  Which one of the following alternatives is commonly used

Which one of the following alternatives is commonly used to reduce agency problems as they relate to corporate control?

  Why southwest airlines would want to hedge fuel costs

Briefly explain why Southwest Airlines would want to hedge fuel costs and how it would do so. Your answer should include a definition of hedging.

  Find the covariance of the cash flow with the market return

Find the covariance of the cash flow with the market return and its cash flow beta.

  Starbucks had a total assets turnover tat ratio of 12 in

1 starbucks had a total assets turnover tat ratio of 1.2 in 2007 which was an improvement over a tat of 0.96 in 2006.

  Plan a strategic quality change

For your chosen organization, Plan a strategic quality change to improve the organizational performance and explain how it helps the organization to compete with the leading global competitors? (A.C.3.1: Plan a strategic quality change to improve ..

  What is the current bond price

Ninja Co. issued 13-year bonds a year ago at a coupon rate of 7.9 percent. The bonds make semiannual payments. If the YTM on these bonds is 6.2 percent, what is the current bond price?

  You own a portfolio that consists of 8000 in stock a 4600

you own a portfolio that consists of 8000 in stock a 4600 in stock b 13000 in stock c and 5500 in stock d. what is the

  Computation of ytm and analysis of bond returns

Computation of YTM and analysis of bond returns and Explain why your bond is trading at a premium or discount based on current market conditions

  Compute the eps that dsf expects to generate this year

Debbie's Sod Farm (DSF) expects its EBIT to be $2,250 this year. DSF's marginal tax rate is 40 percent, it must pay $1,000 in interest this year, and it has 500 shares of common stock outstanding.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd