How do you calculate CAGR when the value of the end term is negative?

39 Views Asked by At

Trying to calculate CAGR = (end value/beginning value)^1/t - 1

Looking at company X's operating income from its income statement, it starts with a positive operating income and its end value is negative.

Company X's operating income:

  • 2020 = (370.2)
  • 2019 = (272.2)
  • 2018 = 6.8

Attempting to calculate the CAGR from 2018 to 2020 produces this calculation (-370.2/6.8)^1/2 - 1 however it results in an error

How can I calculate the annual growth rate over the two years after 2018?

Is there another way to denote the average annual change in values that equates to CAGR?