Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

analyze the strengths and weaknesses of the company and write a report either recommending or not recommending purchase of the company stock. PepsiCo / PEP

analyze the strengths and weaknesses of the company and write a report either recommending or not recommending purchase of the company stock. PepsiCo / PEP The completed report should include: 1. An introduction to the company, including background information. 2. A complete and thorough financial statement review. 3. Pro Forma financial statements (Balance Sheet and Income Statement) for the next fiscal year, assuming a 10 percent growth rate in sales and Cost of Goods Sold (COGS) for the next year. 4. Complete ratio analysis for the last fiscal year using at least two ratios from each of the following categories: a. Liquidity b. Financial leverage c. Asset management d. Profitability e. Market value 5. A calculation of Return on Equity (ROE) using the DuPont system. 6. Assessment of management performance by calculating Economic Value Added (EVA). 7. A synopsis of your findings, including your recommendations and rationale for whether or not to purchase stock from this company

Pepsico, Inc. (PEP)

-NYSE

Watchlist

102.12 0.31(0.30%) 11:13AM EDT - NYSE Real Time Price

Prev Close:

102.43

Open:

102.39

Bid:

102.09 x 100

Ask:

102.10 x 700

1y Target Est:

104.70

Beta:

0.743481

Next Earnings Date:

N/A

Day's Range:

101.85 - 102.69

52wk Range:

76.48 - 103.44

Volume:

905,830

Avg Vol (3m):

5,107,510

Market Cap:

148.77B

P/E (ttm):

30.30

EPS (ttm):

3.37

Div & Yield:

2.81 (2.74%)

Pepsico, Inc. (PEP)

-NYSE

102.11 0.32(0.31%) 11:15AM EDT - NYSE Real Time Price

Income Statement

Get Income Statement for:

View: Annual Data | Quarterly Data

All numbers in thousands

Period Ending

Dec 27, 2014

Dec 28, 2013

Dec 29, 2012

Total Revenue

66,683,000

66,415,000

65,492,000

Cost of Revenue

30,884,000

31,243,000

31,291,000

Gross Profit

35,799,000

35,172,000

34,201,000

Operating Expenses

Research Development

-

-

-

Selling General and Administrative

26,126,000

25,357,000

24,970,000

Non Recurring

-

-

-

Others

92,000

110,000

119,000

Total Operating Expenses

-

-

-

Operating Income or Loss

9,581,000

9,705,000

9,112,000

Income from Continuing Operations

Total Other Income/Expenses Net

85,000

97,000

91,000

Earnings Before Interest And Taxes

9,666,000

9,802,000

9,203,000

Interest Expense

909,000

911,000

899,000

Income Before Tax

8,757,000

8,891,000

8,304,000

Income Tax Expense

2,199,000

2,104,000

2,090,000

Minority Interest

(45,000)

(47,000)

(36,000)

Net Income From Continuing Ops

6,513,000

6,740,000

6,178,000

Non-recurring Events

Discontinued Operations

-

-

-

Extraordinary Items

-

-

-

Effect Of Accounting Changes

-

-

-

Other Items

-

-

-

Net Income

6,513,000

6,740,000

6,178,000

Preferred Stock And Other Adjustments

-

-

-

Net Income Applicable To Common Shares

6,513,000

6,740,000

6,178,000

Pepsico, Inc. (PEP)

-NYSE Watchlist

102.12 0.31(0.30%) 11:15AM EDT - Nasdaq Real Time Price

Balance Sheet

Get Balance Sheet for:

View: Annual Data | Quarterly Data

All numbers in thousands

Period Ending

Dec 27, 2014

Dec 28, 2013

Dec 29, 2012

Assets

Current Assets

Cash And Cash Equivalents

6,134,000

9,375,000

6,297,000

Short Term Investments

2,592,000

303,000

322,000

Net Receivables

6,651,000

6,954,000

7,041,000

Inventory

3,143,000

3,409,000

3,581,000

Other Current Assets

2,143,000

2,162,000

1,479,000

Total Current Assets

20,663,000

22,203,000

18,720,000

Long Term Investments

2,689,000

2,623,000

1,633,000

Property Plant and Equipment

17,244,000

18,575,000

19,136,000

Goodwill

14,965,000

16,613,000

16,971,000

Intangible Assets

14,088,000

16,039,000

16,525,000

Accumulated Amortization

-

-

-

Other Assets

860,000

1,425,000

1,653,000

Deferred Long Term Asset Charges

-

-

-

Total Assets

70,509,000

77,478,000

74,638,000

Liabilities

Current Liabilities

Accounts Payable

13,016,000

12,533,000

12,274,000

Short/Current Long Term Debt

5,076,000

5,306,000

4,815,000

Other Current Liabilities

-

-

-

Total Current Liabilities

18,092,000

17,839,000

17,089,000

Long Term Debt

23,821,000

24,333,000

23,544,000

Other Liabilities

5,744,000

4,931,000

6,543,000

Deferred Long Term Liability Charges

5,304,000

5,986,000

5,063,000

Minority Interest

110,000

110,000

105,000

Negative Goodwill

-

-

-

Total Liabilities

53,071,000

53,199,000

52,344,000

Stockholders' Equity

Misc Stocks Options Warrants

(140,000)

(130,000)

(123,000)

Redeemable Preferred Stock

-

-

-

Preferred Stock

-

-

-

Common Stock

25,000

25,000

26,000

Retained Earnings

49,092,000

46,420,000

43,158,000

Treasury Stock

(24,985,000)

(21,004,000)

(19,458,000)

Capital Surplus

4,115,000

4,095,000

4,178,000

Other Stockholder Equity

(10,669,000)

(5,127,000)

(5,487,000)

Total Stockholder Equity

17,578,000

24,409,000

22,417,000

Net Tangible Assets

(11,475,000)

(8,243,000)

(11,079,000)

Pepsico, Inc. (PEP)

-NYQ

Watchlist

102.13 0.30(0.29%) 11:16AM EDT - Nasdaq Real Time Price

Cash Flow

Get Cash Flow for:

View: Annual Data | Quarterly Data

All numbers in thousands

Period Ending

Dec 27, 2014

Dec 28, 2013

Dec 29, 2012

Net Income

6,513,000

6,740,000

6,178,000

Operating Activities, Cash Flows Provided By or Used In

Depreciation

2,625,000

2,663,000

2,689,000

Adjustments To Net Income

433,000

(371,000)

(658,000)

Changes In Accounts Receivables

(343,000)

(88,000)

(250,000)

Changes In Liabilities

1,533,000

1,093,000

451,000

Changes In Inventories

(111,000)

4,000

144,000

Changes In Other Operating Activities

(189,000)

(400,000)

(111,000)

Total Cash Flow From Operating Activities

10,506,000

9,688,000

8,479,000

Investing Activities, Cash Flows Provided By or Used In

Capital Expenditures

(2,859,000)

(2,795,000)

(2,714,000)

Investments

(2,386,000)

(48,000)

(60,000)

Other Cash flows from Investing Activities

308,000

218,000

(231,000)

Total Cash Flows From Investing Activities

(4,937,000)

(2,625,000)

(3,005,000)

Financing Activities, Cash Flows Provided By or Used In

Dividends Paid

(3,730,000)

(3,434,000)

(3,305,000)

Sale Purchase of Stock

(4,267,000)

(1,905,000)

(2,172,000)

Net Borrowings

(331,000)

1,466,000

2,089,000

Other Cash Flows from Financing Activities

(50,000)

(33,000)

(42,000)

Total Cash Flows From Financing Activities

(8,264,000)

(3,789,000)

(3,306,000)

Effect Of Exchange Rate Changes

(546,000)

(196,000)

62,000

Change In Cash and Cash Equivalents

(3,241,000)

3,078,000

2,230,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Society Rituals Of Verification

Authors: Michael POWER

1st Edition

0198296037, 978-0198296034

More Books

Students also viewed these Accounting questions