{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

6731036 - Common Size Balance sheet of Pepsi Co Fiscal Year...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Common Size Balance sheet of Pepsi Co. Fiscal Year 2008 2007 2006 2005 Fiscal Year End 27th Dec'08 29th Dec'07 30th Dec'06 31st Dec'05 Assets Current assets Cash and cash equivalents 5.73% 2.63% 5.52% 5.41% Short term Investments 0.59% 4.54% 3.91% 9.98% 6.33% 7.16% 9.43% 15.39% Accounts and notes recievable, net 13.01% 12.67% 12.45% 10.28% Inventories 7.01% 6.61% 6.44% 5.34% Prepaid expenses and other current assets 3.68% 2.86% 2.20% 1.95% Total current Assets 30.02% 29.31% 30.50% 32.95% Property, plant and Equipment, net 32.40% 32.42% 32.37% 27.36% Amortizable Intangible Asets, net 2.03% 2.30% 2.13% 1.67% Goodwill 14.24% 14.93% 15.35% 12.88% Other nonamortizable intangible assets 3.13% 3.60% 4.05% 3.42% Non amortizable Intangible assets 17.37% 18.53% 19.40% 16.31% Investments in Noncontrolled Affiliates 10.79% 12.57% 12.33% 10.98% Other Assets 7.38% 4.86% 3.27% 10.73% Total Assets 100.00% 100.00% 100.00% 100.00% Liabilities Current Liabilities Short term obligations 1.03% 0.00% 0.92% 9.11% Accounts payable and othet current liabilities 22.98% 21.95% 21.70% 18.82% Income taxes payable 0.40% 0.44% 0.30% 1.72% Total Current Liabilities 24.41% 22.39% 22.92% 29.65% Long term Debt obligations 21.83% 12.14% 8.52% 7.29% Other Liabilities 19.49% 13.84% 15.45% 13.63% Deferred Income taxes 0.63% 1.87% 1.76% 4.52% Total Liabilities 66.37% 50.23% 48.65% 55.08% Commitments and contingencies Preferred stok, no par value 0.11% 0.12% 0.14% 0.13% Repurchased Preferred stock -0.38% -0.38% -0.40% -0.35% Common Shareholders' Equity Common Stock, par value 0.08% 0.09% 0.10% 0.09% Capital in excess of par value 0.98% 1.30% 1.95% 1.94% Retained earnings 85.12% 81.39% 82.98% 66.56% Accumulated other comprehensive loss -13.04% -2.75% -7.50% -3.32% 73.14% 80.03% 77.53% 65.27%
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Less: repurchased common stock -39.23% -30.00% -25.92% -20.13% Total Common Shareholder's Equity 33.90% 50.03% 51.61% 45.14% Total Liabilities and Shareholder's Equity 100.00% 100.00% 100.00% 100.00%
Background image of page 2
2004 Average 25th Dec'04 4.57% 4.76% 7.74% 5.17% 12.31% 9.93% 10.72% 11.89% 5.51% 6.22% 2.34% 2.65% 30.87% 30.69% 29.12% 30.83% 2.14% 2.05% 13.97% 14.28% 3.33% 3.50% 17.30% 17.78% 11.73% 11.67% 8.84% 6.99% 100.00% 100.00% 3.77% 2.86% 20.01% 21.18% 0.35% 0.64% 24.13% 24.68% 8.56% 12.06% 14.65% 15.51% 4.34% 2.53% 51.68% 54.77% 0.15% 0.13% -0.32% -0.37% 0.11% 0.09% 2.21% 1.63% 66.92% 77.06% -3.17% -6.13% 66.07% 72.65%
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
-17.58% -27.19% 48.49% 45.47% 100.00% 100.00%
Background image of page 4
Common Size Income Statement of Pepsi Co. Fiscal Year 2008 2007 2006 2005 2004 Fiscal year ending on 27th Dec'08 29th Dec'07 30th Dec'06 31st Dec'05 25th Dec'04 Net Revenue 100.00% 100.00% 100.00% 100.00% 100.00% Cost of Goods sold 47.05% 45.70% 44.86% 43.54% 43.31% Selling, general and administrative expenses 36.76% 35.99% 36.18% 37.82% 37.70% Amortization of intangible assets 0.15% 0.15% 0.46% 0.46% 0.50% Restructuring and impairment charges 0.51% Operating Profit 16.03% 18.16% 18.50% 18.19% 17.97% Bottling equity income 0.86% 1.42% 1.57% 1.71% 1.30% Interest expense -0.76% -0.57% -0.68% -0.79% -0.57% Interest Income 0.09% 0.32% 0.49% 0.49% 0.25% Income from continuing operations before Income taxes 16.23% 19.33% 19.89% 19.60% 18.95% Provision for Income taxes 4.34% 5.00% 3.83% 7.08% 4.69% Income from Continuing operations 12.52% 14.26% Tax benefit from discontinued operations 0.13% Net Income 11.89% 14.33% 16.06% 12.52% 14.39% Net income per common share - basic Continuing operations 0.0075% 0.0088% 0.0097% 0.0075% 0.0084% Discontinued operations Total 0.0075% 0.0088% 0.0097% 0.0075% 0.0084% Net income per common share - diluted Continuing operations 0.0074% 0.0086% 0.0095% 0.0073% 0.0082% Discontinued operations Total 0.0074% 0.0086% 0.0095% 0.0073% 0.0083%
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Average 100.00% 45.08% 36.82% 0.32% 0.08% 17.69% 1.35% -0.68% 0.32% 18.68% 4.94% 4.59% 0.02% 13.76% 0.0084% 0.0084% 0.0082% 0.0082%
Background image of page 6
Comparative Analysis of Balance sheet of Pepsi Co. Fiscal Year 2008 2007 2006 2005 Fiscal Year End 27th Dec'08 29th Dec'07 30th Dec'06 31st Dec'05 Assets Current assets Cash and cash equivalents 126.81% -44.88% -3.79% 34.06% Short term Investments -86.44% 34.16% -63.01% 46.24% 97.31% -36.90% -43.53% 41.71% Accounts and notes recievable, net 6.70% 17.83% 14.23% 8.74% Inventories 10.13% 18.90% 13.76% 9.86% Prepaid expenses and other current assets 33.60% 50.84% 6.31% -5.50% Total current Assets 6.45% 11.18% -12.67% 21.01% Property, plant and Equipment, net 3.87% 15.91% 11.59% 6.53% Amortizable Intangible Asets, net -8.04% 24.96% 20.19% -11.37% Goodwill -0.87% 12.52% 12.38% 4.58% Other nonamortizable intangible assets -9.62% 2.97% 11.60% 16.40% Non amortizable Intangible assets -2.57% 10.52% 12.21% 6.86%
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}