Although finding great, stable companies with more than 10 years of history to examine is ideal, not all companies fall into this category. A boat load of companies fall into the category of around 5 years of operational history. This modified spreadsheet calculates the intrinsic value based on the last 5 years and I’ll also take you through the steps to modify the spreadsheet yourself so that you can apply it to other databases other than Morningstar.