J
joeleandri
Trending performance may be performed by calculating
compound sum interest factors to generate growth rates.
Using the sample data,one can calculate growth rates for
sales and net income for multiple periods.
To compute, divide the last-period figure by the first-
period figure. This returns a compound sum interest
factor. Then by referring to the compound interest table,
(number of periods & interest factors) one can determine
the growth rate represented by the ratio.
To determine the answer, one looks to the top of the
compound interest table (where rates are displayed) to
identify the compound interest rate which corresponds with
the interest factor.
My question for this excel worksheet function newsgroup
is -- does excel have a function that computes the
compound interest rate that corresponds to the computed
compound sum interest factor? Final answer I am looking
for is a compound interest rate. Thanks. jl
compound sum interest factors to generate growth rates.
Using the sample data,one can calculate growth rates for
sales and net income for multiple periods.
To compute, divide the last-period figure by the first-
period figure. This returns a compound sum interest
factor. Then by referring to the compound interest table,
(number of periods & interest factors) one can determine
the growth rate represented by the ratio.
To determine the answer, one looks to the top of the
compound interest table (where rates are displayed) to
identify the compound interest rate which corresponds with
the interest factor.
My question for this excel worksheet function newsgroup
is -- does excel have a function that computes the
compound interest rate that corresponds to the computed
compound sum interest factor? Final answer I am looking
for is a compound interest rate. Thanks. jl