Question: how to calculate cagr from a negative number?
Answer: Official formula: (Ending Value/Beginning Value)^1/10-1. Excel formula:=(B11/B6)^(1/(10-1))-1.