Financial Analysis Report of the Pepsico（百事可乐的财务分析作业）

(By Conley) Teamwork Of Accounting Course

5

(By Conley) Teamwork Of Accounting Course

The statement of Common Shareholders’ Equity

Fiscal years ended Dec.29, 2007, Dec. 30, 2006

Part 2 Financial Analysis of Pepsi

Dollar and percentage changes

The dollar and percentage changes of the assets ,liabilities and equities in balance sheet are shown in sheet as follow.

6

(By Conley) Teamwork Of Accounting Course

2006 is the base year in calculation. From the results of the calculation we can easily know the total current assets arise by 11.2%, total assets arise by 15.7%, total liabilities and equity arise by 15.7%, so the company actually didn’t improve so much .Besides, we can know the cash equivalent decreased by 44.8% while the short-term investment arise by 34.2%, which means that the company convert the cash to short investment or other plans.

2007ASSETSCurrent AssetCash and cash equivalentshort-term investmentAccounts and notes receviable,netInventoriesPrepaid expenses and other current asset Total current AssetsProperty,Plant and Equipment,netAmortizable Intangible Asset,netGoodwillOther nonamortizable intangible assets Nonamortizable Intangibe assetsInvestment in Noncontrollled AffiliatesOther Assets Total AssetsLIABILITYS AND SHAREHOLDERS' EQUITYCurrent Liabilitiesshort-term obligationAccounts payable and other current liabilitiesIncome taxes payable Total current LiabilitieLong-term Debt ObligationOther LiabilitiesDeferred Income Taxes Total LiabilitisPreferred Stock,no par valueRepurchased Preferred Stock Common Shareholders' Equity2006dallor changepercentage change(%)91015714389229099110151112287965169124864174354168234628165111713725192665791309687637459412125806369098029930-74140066436433410211541159575366116647024698-44.8818897634.158838617.8255033618.899273150.8371385111.1829134715.9079178324.9607535312.516325642.9702970310.5235962817.9945799571.6326530615.69662546076021517753420347926461739441-132302746496906860255046245281456241-1203058424837-224623205-77581544729930-274110661893165316811828320-120-134334712944507-262918784698-10017.0258620767.7777777813.0174927164.823529413.63321799322.3484848519.447878040100-22.9452054813.47586262-57.6135351719.4225382533.887599912.1577005215.69662546 Common stock,par value 1 2/3 per share(authorized Capital in excess of par valueRetained earningsAccumulated other comprehensive loss45028184-95227712Less:repurchased common stock,at cost(177and144-10387 Total Common Shareholders' Equity17325 Total Liabilities and Shareholders' Equity34628

7

(By Conley) Teamwork Of Accounting Course

Trend percentages of trend analysis

These ratios during three years reveal patterns in data which covers successive period. From the graph we can easily know the expense, cost, and revenue are all grow, but the sales cost and expenses grows faster than revenue.

INCOME STATEMENT OF PEPSICOIn millions(dollars)20072006Net Revenue3947435137Cost of sales1803815762SG&A expenses1420812711Use 2005 as the base year we can get the trend informaton(%)Net Revenue121.2271973107.9079909Cost of sales127.243228111.1879233SG&A expenses115.9647405103.74632714003503002502001501005002005200620072005325621417612252100100100 We use the trend percentages to construct a graph to see the trend over this three years.

SG&A expensesCost of salesNet Revenue Component percentage

i)

Common-sized percentages in Balance sheet of Pepsi

8