Hi! I'm trying to calculate the Compounding Monthly Growth Rate Formula (CMGR). The formula for this is: CAGR = (Ending Value ÷ Beginning Value) ^ (1 ÷ Number of Periods) – 1.

So i've done the following but getting a comple error.

any ideas?

eaRevenue is an array of doubles.

let monthlyVarianceRevenue = (ea.eaRevenue[11]/ea.eaRevenue[0]) ^ (1/12) - 1

and i'm getting the compile error on the line above.

/Users/j/Library/CloudStorage/drive/MobDEV/mob/Revenue.swift:69:25 The compiler is unable to type-check this expression in reasonable time; try breaking up the expression into distinct sub-expressions

Well I got this to compile, but Swift is return NaN. Not a Number. So what next?

let startValue = Int(ea.eaRevenue[11])
let endValue = Int(ea.eaRevenue[0])
let monthlyVarianceRevenue = (startValue / endValue) ^ (1 / 12) - 1

If you use double continue use double. Not sure how your exponentiation operator set up. But if you use Ints in (1/12) it will return 0. Try to convert them as to double as well. (Double(1) / Double(12))

Hi there. if you mean like this I get the same compile error as before

let startValue = ea.eaRevenue[11]
let endValue = ea.eaRevenue[0]
let monthlyVarianceRevenue = (startValue / endValue) ^ (Double(1) / Double(12)) - 1

Same error with this too

              let startValue = ea.eaRevenue[11]
                    let endValue = ea.eaRevenue[0]
                    let startMonth = 1.0
                    let endMonth = 12.0
                    let monthlyVarianceRevenue = (startValue / endValue) ^ (startMonth / endMonth) - 1

As i said i don't know how you set up exponentiation operator in your formula. Use pow() function instead.

Super! That compiles and gives me a number :) I need to chck the numbers but so far so good, thank you @ygeras! :)

To be on the safe side check the numbers as there are maybe imprecisions, if you need one of course. If you work with money you never now ))). It is recommended to use Decimals for them.

Filed in the SOLVED section!