Remember Me?

#1
May 30th 08, 12:55 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 73
Escalation Formula

First, thank you for looking at this post and any and all help you can offer.

Is there a formula to calculate escalation?
Say I have a price of \$1,000, the average increase is 4.5% per year and I
want to escalate the 1000 over a 10 year period. Could this be done? I'm
trying to find the result for each year and then separately for year 10.

Joe

#2
May 30th 08, 01:33 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 1,047
Escalation Formula

assuming

a1 = 1000
b1 = 4,5%
c1 = # of years (1,2..10)
d1 =(a1*(1+b1)^c1)

change c1 to see the result as you need

hth
--
regards from Brazil
Marcelo

"Joe Gieder" escreveu:

First, thank you for looking at this post and any and all help you can offer.

Is there a formula to calculate escalation?
Say I have a price of \$1,000, the average increase is 4.5% per year and I
want to escalate the 1000 over a 10 year period. Could this be done? I'm
trying to find the result for each year and then separately for year 10.

Joe

#3
May 30th 08, 01:54 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 73
Escalation Formula

Thank you for the formula. It does just what I need. How does the formula
know to compound?

"Marcelo" wrote:

assuming

a1 = 1000
b1 = 4,5%
c1 = # of years (1,2..10)
d1 =(a1*(1+b1)^c1)

change c1 to see the result as you need

hth
--
regards from Brazil
Marcelo

"Joe Gieder" escreveu:

First, thank you for looking at this post and any and all help you can offer.

Is there a formula to calculate escalation?
Say I have a price of \$1,000, the average increase is 4.5% per year and I
want to escalate the 1000 over a 10 year period. Could this be done? I'm
trying to find the result for each year and then separately for year 10.

Joe

#4
May 30th 08, 02:13 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 947
Escalation Formula

If you wish...

=FV(4.5%,C1,,-1000)

where C1 is the year in question.

--
HTH :)
Dana DeLouis

"Joe Gieder" wrote in message ...

Thank you for the formula. It does just what I need. How does the formula
know to compound?

"Marcelo" wrote:

assuming

a1 = 1000
b1 = 4,5%
c1 = # of years (1,2..10)
d1 =(a1*(1+b1)^c1)

change c1 to see the result as you need

hth
--
regards from Brazil
Marcelo

"Joe Gieder" escreveu:

First, thank you for looking at this post and any and all help you can offer.

Is there a formula to calculate escalation?
Say I have a price of \$1,000, the average increase is 4.5% per year and I
want to escalate the 1000 over a 10 year period. Could this be done? I'm
trying to find the result for each year and then separately for year 10.

Joe
#5
May 30th 08, 02:35 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 73
Escalation Formula

Thank you for the formula it works perfectly, I appreciate your help and
response. One question, why do you use a -1000? I used the formula without it
and I received a negative answer for the value but why does this formula
require a -1000?

Joe

"Dana DeLouis" wrote:

If you wish...

=FV(4.5%,C1,,-1000)

where C1 is the year in question.

--
HTH :)
Dana DeLouis

"Joe Gieder" wrote in message
...
Thank you for the formula. It does just what I need. How does the

formula
know to compound?

"Marcelo" wrote:

assuming

a1 = 1000
b1 = 4,5%
c1 = # of years (1,2..10)
d1 =(a1*(1+b1)^c1)

change c1 to see the result as you need

hth
--
regards from Brazil
Marcelo

"Joe Gieder" escreveu:

First, thank you for looking at this post and any and all help you

can offer.

Is there a formula to calculate escalation?
Say I have a price of \$1,000, the average increase is 4.5% per year

and I
want to escalate the 1000 over a 10 year period. Could this be done?

I'm
trying to find the result for each year and then separately for year

10.

Joe

#6
May 30th 08, 03:40 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 10,124
Escalation Formula

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 02:13 PM.