Please find below, the review of a publicly traded company, and follow the instructions carefully.

The links to the company financial records are here...

PEPSI - INCOME STATEMENT
Breakdown	30/12/2022	30/12/2021	30/12/2020	30/12/2019
Total Revenue	86 392 000	79 474 000	70 372 000	67 161 000
Operating Revenue	86 392 000	79 474 000	70 372 000	67 161 000
Cost of Revenue	40 576 000	37 075 000	31 797 000	30 132 000
Gross Profit	45 816 000	42 399 000	38 575 000	37 029 000
Operating Expense	34 459 000	31 237 000	28 495 000	26 738 000
Selling General and Administrative	34 459 000	31 237 000	28 495 000	26 738 000
Operating Income	11 357 000	11 162 000	10 080 000	10 291 000
Net Non Operating Interest Income Expense	-939 000	-1 863 000	-1 128 000	-935 000
Interest Income Non Operating	-	-	-	200 000
Interest Expense Non Operating	939 000	1 863 000	1 128 000	1 135 000
Other Income Expense	287 000	522 000	117 000	-44 000
Special Income Charges	155 000	-	-	-
Other Non Operating Income Expenses	132 000	522 000	117 000	-44 000
Pretax Income	10 705 000	9 821 000	9 069 000	9 312 000
Tax Provision	1 727 000	2 142 000	1 894 000	1 959 000
Net Income Common Stockholders	8 910 000	7 618 000	7 120 000	7 314 000
Net Income	8 910 000	7 618 000	7 120 000	7 314 000
Otherunder Preferred Stock Dividend	-	-	0	0
Average Dilution Earnings	-	-	0	0
Diluted NI Available to Com Stockholders	8 910 000	7 618 000	7 120 000	7 314 000
Basic EPS	6,45	5,51	5,16	5,26
Diluted EPS	6,42	5,49	5,12	5,2
Basic Average Shares	1 380 000	1 383 000	1 380 000	1 391 000
Diluted Average Shares	1 387 000	1 389 000	1 392 000	1 407 000
Total Operating Income as Reported	11 512 000	11 162 000	10 080 000	10 291 000
Total Expenses	75 035 000	68 312 000	60 292 000	56 870 000
Net Income from Continuing & Discontinued Operation	8 910 000	7 618 000	7 120 000	7 314 000
Normalized Income	8 786 000	7 618 000	7 120 000	7 314 000
Interest Income	-	-	-	200 000
Interest Expense	939 000	1 863 000	1 128 000	1 135 000
Net Interest Income	-939 000	-1 863 000	-1 128 000	-935 000
EBIT	11 644 000	11 684 000	10 197 000	10 447 000
EBITDA	14 924 000	14 899 000	12 745 000	12 879 000
Reconciled Cost of Revenue	40 576 000	37 075 000	31 797 000	30 132 000
Reconciled Depreciation	3 280 000	3 215 000	2 548 000	2 432 000
Net Income from Continuing Operation Net Minority Interest	8 910 000	7 618 000	7 120 000	7 314 000
Total Unusual Items Excluding Goodwill	155 000	-	-	-
Total Unusual Items	155 000	-	-	-
Normalized EBITDA	14 769 000	14 899 000	12 745 000	12 879 000
Tax Rate for Calcs	0	0	0	0
Tax Effect of Unusual Items	31 000	0	0	0

You are required to;

a) Analyze their financial statements (Statement of Cash Flows, Income Statement, and Balance Sheet), and provide a detailed summary of their financial performance. You are expected to include your own tables/illustrations as part of this summary to reinforce your position. Your analysis should include a wide range of financial and performance indicators along with your interpretations of these measurements.

b) You are to prepare detailed recommendations on how they can increase their profitability in the future. You can choose between short, mid or long term projections, however your recommendation must be realistic based on their capabilities and market forces. You must justify your strategy based on your previous financial assessment of the company.

c) Be sure to include an introduction, and conclusion as part of your report.