D
daniel
I am unable to find the correct formula for a compounded quarterly
interest rate. For example, Quarter 0 (previous year) = 100 in sales
and I have an annual interest rate of 10%, then one would presume that
Q1 would equal 100 *(1+.10)^(1/4) however if you extract that for 4
quarters it does not sum to 110 i.e. 100 * (1+.1). I am trying to find
the correct formula and want the flexibility to have a different
interest rate for each quarter i.e. that q1 grows at a 10% compounded
annualized rate and Q2 grows at a 5% compounded annualized rate.
thanks for any assistance.
Daniel
interest rate. For example, Quarter 0 (previous year) = 100 in sales
and I have an annual interest rate of 10%, then one would presume that
Q1 would equal 100 *(1+.10)^(1/4) however if you extract that for 4
quarters it does not sum to 110 i.e. 100 * (1+.1). I am trying to find
the correct formula and want the flexibility to have a different
interest rate for each quarter i.e. that q1 grows at a 10% compounded
annualized rate and Q2 grows at a 5% compounded annualized rate.
thanks for any assistance.
Daniel