Evaluate P&G's performance and determine the value of the company. A template is provided. Please build your valuation analysis based on the template. The template includes multiple work sheets. The highlighted (in yellow) are the cells you need to fill in.

You may search and use more relevant information of the company in addition to the financial statement data on SEC's website or other resources such as MarketWatch or Morningstar, etc.

You are expected to apply what you've learned in this course to the best of your ability. Essential components include pro forma analysis (cash flow estimations), risk analysis, discounted cash flow and relative valuation methods, etc. Please note: you are not required to estimate PG's WACC. The WACC (i.e the discount rate) is given as 6.5%.

Further explanations on risk analysis

• To identify top three value drivers, we need to calculate NPV. Since we don't have initial investment in our firm value analysis, you may assume $300 billion as your initial investment to compute NPV.