Let's say I have a number, 10
, and over a period of a year that number has increased by 100%
to 20
. I would like to figure out what the monthly increase should be for 10
to reach 20
over 12
months.
If I convert 100%
to a coefficient I get 2
. Now by trying several numbers manually I figured the monthly coefficient should be around 1.065
:
M. NUMBER COEFF 1 10 1.065 2 10.65 1.065 3 11.34225 1.065 4 12.07949625 1.065 5 12.8646635063 1.065 6 13.7008666342 1.065 7 14.5914229654 1.065 8 15.5398654581 1.065 9 16.5499567129 1.065 10 17.6257038992 1.065 11 18.7713746527 1.065 12 19.9915140051 1.065
Q: How can I obtain the monthly coefficient (something around 1.065
) from 2 and 12?