If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Escalation Formula
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Escalation Formula

#1
May 30th 08, 12:55 PM posted to microsoft.public.excel.worksheet.functions
 Joe Gieder external usenet poster 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
 Marcelo external usenet poster 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.
>
> Thank you for your help
> Joe

#3
May 30th 08, 01:54 PM posted to microsoft.public.excel.worksheet.functions
 Joe Gieder external usenet poster 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.
> >
> > Thank you for your help
> > Joe

#4
May 30th 08, 02:13 PM posted to microsoft.public.excel.worksheet.functions
 Dana DeLouis external usenet poster 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.
>> >
>> > Thank you for your help
>> > Joe
#5
May 30th 08, 02:35 PM posted to microsoft.public.excel.worksheet.functions
 Joe Gieder external usenet poster 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.
> >> >
> >> > Thank you for your help
> >> > Joe

>

#6
May 30th 08, 03:40 PM posted to microsoft.public.excel.worksheet.functions
 Don Guillett external usenet poster Posts: 10,124
Escalation Formula

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

All times are GMT +1. The time now is 07:44 PM.