1 2 3 4 5 6 7 8 9 0 1 2 342 Term Project-Lab 5: DCF Name: Company Stock Ticker: NAME HERE TICKER HERE Prompt: The CFO has tasked you with performing a fundamental valuation of the company as a whole. With this valuation, the CFO will have a better idea of whether the stock is overvalued or undervalued relative to internal estimates. If the stock is significantly undervalued, they might be interested in buying back some shares at a discount. If it is overvalued, they might sell some issue new shares at a premium to fund future projects. To do so, you will need to perform a discounted cash flow analysis (DCF). This information will go on slide 19 and 20 of your presentation, Instructions: Do Not Delete Any Columns, Rows, or Cells in this Workbook. It will mess up the grading! Part A: Practice On the tab "DCF - Practice"-The CFO has provided you with some Pro Forma (abbreviated) financial statements and internal estimates of growth. Fill in the table where necessary with that information.-The red flags in each