Collect three years of financial statement information for PepsiCo. To prepare the condensed balance sheet, the condensed income statement, and the condensed statement of cash flows. Use the three most recent years available. Organize your information using Worksheet A, B, and C Found in pictures below.

Balance sheet: Prepare a trend analysis and common-size balance sheet using the amounts from condensed balance sheet. Enter Results in Worksheet A found below.

Income Statement: Prepare the trend analysis and common-size income statement using the amounts from the condensed balance sheet. Enter Results in Worksheet B found below.

Statement of Cash Flows: Prepare the trend analysis and common-size income statement using amounts from the condensed statement of cash flows. Enter Results in Worksheet C found below.

BALANCE SHEET ANALYSIS WORKSHEET A: (Your Company Name) CONDENSED CLASSIFIED BALANCE SHEET Month (Day T Year End t recent in millions) Current assets Goodwill and intangibles Other assets TOTAL ASSETS Current liabilities Noncurrent liabilities Contributed capital Retained earnings Treasury stock and other SE TOTAL L & SE (Your Company Name) CONDENSED TREND ANALYSIS BALANCE SHEET Month) (Day) Year-End (Most recent) Current assets Goodwill and intangibles Other asse TOTAL ASSETS Current liabilities Noncurrent liabilities Contributed capital Retained earnings Treasury stock and other SE TOTAL L & SE (Your Company Name) CONDENSED COMMON-SIZE BALANCE SHEET (Month) (Day) Year-End Most recent Current assets net L Goodwill and intangibles Other assets TOTAL ASSETS 100.0% Current liabilities Noncurrent liabilities Contributed capital Retained earnings Treasury stock and other SE TOTAL L & SE 100.0% 100.0% L 100.0% 100 100 100 100.0% 100.0% BALANCE SHEET ANALYSIS WORKSHEET A: (Your Company Name) CONDENSED CLASSIFIED BALANCE SHEET Month (Day T Year End t recent in millions) Current assets Goodwill and intangibles Other assets TOTAL ASSETS Current liabilities Noncurrent liabilities Contributed capital Retained earnings Treasury stock and other SE TOTAL L & SE (Your Company Name) CONDENSED TREND ANALYSIS BALANCE SHEET Month) (Day) Year-End (Most recent) Current assets Goodwill and intangibles Other asse TOTAL ASSETS Current liabilities Noncurrent liabilities Contributed capital Retained earnings Treasury stock and other SE TOTAL L & SE (Your Company Name) CONDENSED COMMON-SIZE BALANCE SHEET (Month) (Day) Year-End Most recent Current assets net L Goodwill and intangibles Other assets TOTAL ASSETS 100.0% Current liabilities Noncurrent liabilities Contributed capital Retained earnings Treasury stock and other SE TOTAL L & SE 100.0% 100.0% L 100.0% 100 100 100 100.0% 100.0%