I am working with bisnode panel data https://www.bisnodegroup.com/solutio.../company-data/ which has ID, year, and company revenue info.

I would like to calculate Year-on-year revenue growth (i.e. growth compared to previous year) and CAGR (Compounded Annual Growth Rate) over a multiple year period https://www.investopedia.com/terms/c/cagr.asp

I have never worked with panel data before, so not sure how to it....I've only ever done it for timeseries data (i.e. single company).

The other thing I want to do is remove all companies that at some point had revenues, but had zero revenues in a later year. (if they had zero revenues in the beginning, but later had positive revenues, then I don't want to remove them.

Any suggestions/ideas/advice?