Your Perfect Assignment is Just a Click Away

Starting at $8.00 per Page

100% Original, Plagiarism Free, Customized to Your instructions!

glass
pen
clip
papers
heaphones

PepsiCo Inc Financial Statement Analysis

PepsiCo Inc Financial Statement Analysis

Question Description

Your grandparents have been left a substantial amount of money and want to invest in a company. Your grandfather trusts you to make a recommendation, but he also wants to see the reasoning behind your choice.

You have an idea of which company to choose and you decide to prepare 3 sets of documents for your grandparents to consider: business analysis, combined income and cash flow statement, and trend analysis.

Business Analysis

Select a public company that trades on either the NYSE or the NASDAQ. Perform a business analysis (both external and internal) for your company using the most recent information from various sources. Possible sources include the following:

  • Annual report or form 10-K
  • Magazine or newspaper articles
  • Company Web sites
  • Government information
  • Industry information
  • Rating agencies
  • Analyst reports
  • Internet articles

Your analysis should be approximately 5 pages long. Be sure to cite your sources using APA guidelines.

Combined Income and Cash Flow Statement

Download the company’s most recent annual report from its Web site or the company’s form 10-K from the U.S. Securities and Exchange Commission (SEC) Web site (www.sec.gov).

  • Confirm that the firm’s income, dividends, and other capital transactions explain the change in equity for the most recent year. (You may need to consult the statement of shareholders’ equity.)
  • Confirm that the firm’s cash flow statement begins with the same net income amounts found in the income statement.
  • Confirm that the firm’s cash flow statement shows a change in cash that is equal to the difference between cash shown on the balance sheet at the beginning and end of the year. In Excel, construct a combined income statement and cash flow statement.
  • Write 1–2 paragraphs that answer the following:
    • What would you do if you found there was a huge difference in the net income amounts and the reported cash flow amounts?
    • How could technology limit the likelihood of this happening again?

Trend Analysis

Finally, prepare a trend analysis of operating ratios for at least 3 years’ worth of financial data. Prepare the analysis in Excel. You may wish to create a common-sized income statement first, but it isn’t required.

If you adjusted for any nonrecurring items in step 1, explain the adjustments in a separate Word document. Use any other information in your company’s annual report to explain the change in revenues, gross margin percentage, and operating margin percentage. Add this information to the Word document.


"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."

Order Solution Now

Our Service Charter


1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.