1. Company Profile

• brief profile of the company you are assigned to including a description of their products or services and the markets they compete.
• Summary of their stock performance in the last quarter versus the market and closest competitors.

1. Financial Analysis

• The financial analysis should include, but not be limited to, the preparation of the latest 3-year financial statements (Income Statement, Balance Sheet, and Cash Flow Statement) including the Last Twelve Months (LTM).
• Provide an explanation of the results year-over-year including ratio and trend analysis.

1. Valuations

• Valuation Analysis for your assigned public company using Excel. The valuation analysis should calculate the assigned companies Enterprise Value using the following 3 methods of valuation:
  • Method #1 (current stock price to calculate the EV)
  • Method #2 (Intrinsic Value based on Average stock Target)
  • Method #3 (Trading EBITDA Multiples)
• Discussions on the results on your various methods of valuation and recommend if someone should buy, hold, or sell the stock.

Company: Nike