Step 1:

Select a company and its comparables.

Below is the guideline.

1. The company should be a Food or Beverage company.
   1. The company should have at least five years of history.
   2. For the last 5 years, the company should be profitable (with positive net profit) for at least 3 years.
2. For the company you pick, you need to find another three companies in the same business. Keep the list for your record.

Step 2:

We use the stockanalysis.com for data collection.

1. Open the website: https://stockanalysis.com.
2. Type in selected stock ticker
3. In the stock page à Financials
   1. Organize the data in the order of ascending date from left to right.
   2. Select balance sheet -> download
   3. Select income statement -> download
   4. Select cash flow statement -> download
   5. Select ratios -> download
4. You can also collect the key information from the “statistics” page such as market cap, beta, etc…
5. The “overview” page shows a collection of recent news for the company.
6. Compare your company with the industry or competitors. Conduct a brief SWOT analysis.

Hint:

• There is no need to include long paragraph analysis in the excel, but you should have the data collected for analysis later.