Using your example I got:
30,000 first year
33,504 second year
37,416 third year
41,786 fourth year
46,666 fifth year
52,116 sixth year
58,203 seventh year
65,000 eighth year
using a fixed 11.67869% raise for each year.
I used
=(B8/B1)^(1/7)-1
as the formula. Where B8 has the end value (65,000)
B1 has the starting value (30,000)
and the 7 is one less than the number of
rows.
(there is probably a simple financial function for this, but I haven't taken
that course yet.)
--
Gary''s Student
"Stormy Weather" wrote:
I need a formula for calculating an even percentage amount between a
specified range of numbers. This is for a pay plan. For example, the starting
salary is $30,000 and the top salary is $65,000; I need a formula that will
give the 8 steps from start to top with the exact same percentage - not
dollar amount.
|