Calculating Intrinsic Stock Value in Excel
Cell E9: Stock Symbol. This is the ticker symbol for the company’s stock. Cell F9: Excess Return Period (years) This is the number of years into the future that the Excel model forecasts cash flow for a company.