Considering the following case: THE PROCTER & GAMBLE COMPANY: CREST WHITESTRIPS ADVANCED SEAL,

Could you explain to me how to make a discounted cash flow valuation based on the following steps?

How can I make a four-year Discounted Cash Flow Model on Excel sheet?

1. Input the financial data for each scenario into separate worksheets in Excel. 2. Make a summary worksheet that links to the other worksheets using formulas or data tables. 3. Calculate the net present value (NPV) for each scenario by discounting the cash flows using an appropriate discount rate. 4. Compare the NPVs of each scenario and identify which scenario has the highest value. 5. Make a recommendation based on your analysis.