I hope you will find the template below useful; it allows you to compare up to five pharmaceutical products in terms of sales/profits over a period of time.
Calculation of threat from generics is also feasible and useful in guiding assumptions around the growth of the product over time.
You can modify the template as you wish and use it for other applications of course; let me know of any comments/suggestions.