I'm not sure if this quite got there,
and I may have taken some shortcuts in the calculations,
but nonetheless, maybe the workbook attached in the Forum thread could give an idea.
270405cagr_v10.2.twbx 2.4 MB
This definitely works for my purposes. It's a clever solution. Thank you so much!