Question

1. PepsiCo, near the top of Table 2-5 in the chapter, is a company that provides
comprehensive financial statements. Go to finance.yahoo.com. In the box next to
“Get Quotes,” type in its ticker symbol PEP and click.

2. Scroll all the way down to “Financials” and click on “Income Statement.” Compute
the annual percentage change between the three years for the following: (INCOME STATEMENT IS BELOW FOR 3 YEARS IS BELOW)
a. Total revenue.(PLEASE SHOW ALL WORK AS TO HOW YOU ARRIVED AT THE ANSWER)
b. Net income applicable to common shares.(PLEASE SHOW ALL WORK AS TO HOW YOU ARRIVED AT THE ANSWER)

3. Now click on “Balance Sheet” and compute the annual percentage change ( BALANCE SHEET FOR 3 YEARS IS BELOW)
between the three years for the following:
a. Total assets.(PLEASE SHOW ALL WORK AS TO HOW YOU ARRIVED AT THE ANSWER)
b. Total liabilities.(PLEASE SHOW ALL WORK AS TO HOW YOU ARRIVED AT THE ANSWER)

4. Write a one-paragraph summary of how the company is doing.

Income Statement

All numbers in thousands

Revenue	12/31/2016	12/26/2015	12/27/2014
Total Revenue	62,799,000	63,056,000	66,683,000
Cost of Revenue	28,209,000	28,731,000	31,238,000
Gross Profit	34,590,000	34,325,000	35,445,000
Operating Expenses
Research Development	-	-	-
Selling General and Administrative	24,735,000	24,538,000	25,772,000
Non Recurring	-	1,359,000	1,359,000
Others	70,000	75,000	92,000
Total Operating Expenses	-	-	-
Operating Income or Loss	9,785,000	8,353,000	9,581,000
Income from Continuing Operations
Total Other Income/Expenses Net	110,000	59,000	85,000
Earnings Before Interest and Taxes	9,895,000	8,412,000	9,666,000
Interest Expense	1,342,000	970,000	909,000
Income Before Tax	8,553,000	7,442,000	8,757,000
Income Tax Expense	2,174,000	1,941,000	2,199,000
Minority Interest	104,000	107,000	110,000
Net Income From Continuing Ops	6,329,000	5,452,000	6,513,000
Non-recurring Events
Discontinued Operations	-	-	-
Extraordinary Items	-	-	-
Effect Of Accounting Changes	-	-	-
Other Items	-	-	-
Net Income
Net Income	6,329,000	5,452,000	6,513,000
Preferred Stock And Other Adjustments	-	-	-
Net Income Applicable To Common Shares	6,329,000	5,452,000	6,513,000

Balance Sheet

All numbers in thousands

Period Ending	12/31/2016	12/26/2015	12/27/2014
Current Assets
Cash And Cash Equivalents	9,158,000	9,096,000	6,134,000
Short Term Investments	6,967,000	2,913,000	2,592,000
Net Receivables	6,694,000	6,437,000	6,651,000
Inventory	2,723,000	2,720,000	3,143,000
Other Current Assets	1,547,000	1,865,000	2,143,000
Total Current Assets	27,089,000	23,031,000	20,663,000
Long Term Investments	1,950,000	2,311,000	2,689,000
Property Plant and Equipment	16,591,000	16,317,000	17,244,000
Goodwill	14,430,000	14,177,000	14,965,000
Intangible Assets	13,433,000	13,081,000	14,088,000
Accumulated Amortization	-	-	-
Other Assets	636,000	750,000	860,000
Deferred Long Term Asset Charges	-	-	-
Total Assets	74,129,000	69,667,000	70,509,000
Current Liabilities
Accounts Payable	14,243,000	13,507,000	13,016,000
Short/Current Long Term Debt	6,892,000	4,071,000	5,076,000
Other Current Liabilities	-	-	-
Total Current Liabilities	21,135,000	17,578,000	18,092,000
Long Term Debt	30,053,000	29,213,000	23,821,000
Other Liabilities	6,669,000	5,887,000	5,744,000
Deferred Long Term Liability Charges	5,073,000	4,959,000	5,304,000
Minority Interest	104,000	107,000	110,000
Negative Goodwill	-	-	-
Total Liabilities	63,034,000	57,744,000	53,071,000
Stockholders' Equity
Misc. Stocks Options Warrants	-151,000	-145,000	-140,000
Redeemable Preferred Stock	-	-	-
Preferred Stock	-	-	-
Common Stock	24,000	24,000	25,000
Retained Earnings	52,518,000	50,472,000	49,092,000
Treasury Stock	-31,468,000	-29,185,000	-24,985,000
Capital Surplus	4,091,000	4,076,000	4,115,000
Other Stockholder Equity	-13,919,000	-13,319,000	-10,669,000
Total Stockholder Equity	11,246,000	12,068,000	17,578,000
Net Tangible Assets	-16,617,000	-15,190,000	-11,475,000

Answer 1

page 2