cc$"$Instructions $1.$ The purpose of this template is to gather data that will be analyzed and discussed in Memo #$3$ submission. Insert the name of the company in the "INSERT COMPANY HERE." $2.$ The template intends for you to gather financial information that is readily available in multiple online financial resources. Part of the learning process is the data gathering exercise. Please take your time looking for it$.$ Please use end of year ratios. Only some ratios$/$metrics have TTM$/$QoQ informaiton. Add what is applicable. $3.$ Ratios can be found from a variety of online financial resources, to include, but not limited to: Morningstar's, Yahoo Finance, Google Finance, Market Watch, Bloomberg, and many more. Sometimes it is as simple as Google: "What is Apple's revenue?" $4.$ Do not edit the table. Do not add extra ratios. More is not necessarily better $-$ we are looking for quality over quantity. $5.$ You can also change the font size and the column widths. Keep the headings standard. $6.$ While not a requirement, you can copy$/$paste the Excel completed table as a picture in your memorandum template. $"$

Pepsico Cocoa Cola

Insert Financial Resource$($s$)$ Used Here $20212022$ Trailing Twelve Months $($TTM$)/$ QoQ $/$ Forecast Insert Financial Resource$($s$)$ Used Here $20212022$ Trailing Twelve Months $($TTM$)/$ QoQ $/$ Forecast

Report in Millions or $\%$ Report in Millions or $\%$

Market Capitalization $($Market Cap$)$ Market Capitalization $($Market Cap$)$

Daily Trade Volume $/$ Average Volume Daily Trade Volume $/$ Average Volume

Beta Beta

Operating Cash Flow Operating Cash Flow

Investing Cash Flow Investing Cash Flow

Financing Cash Flow Financing Cash Flow

Capital Expenditure Capital Expenditure

Free Cash Flow Free Cash Flow