ACC 305 Final - Common Size Balance sheet of Pepsi Co...

Info icon This 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%
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%
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%
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%
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%
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%
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% Investments in Noncontrolled Affiliates -10.82% 17.99% 5.88% 6.12% Other Assets 58.03% 71.63% -71.20%
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 ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern