A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Escalation Formula



 
 
Thread Tools Display Modes
  #1  
Old May 30th 08, 12:55 PM posted to microsoft.public.excel.worksheet.functions
Joe Gieder
external usenet poster
 
Posts: 73
Default 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.

Thank you for your help
Joe
Ads
  #2  
Old May 30th 08, 01:33 PM posted to microsoft.public.excel.worksheet.functions
Marcelo
external usenet poster
 
Posts: 1,047
Default 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
Thanks in advance for your feedback.
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  
Old May 30th 08, 01:54 PM posted to microsoft.public.excel.worksheet.functions
Joe Gieder
external usenet poster
 
Posts: 73
Default 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
> Thanks in advance for your feedback.
> 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  
Old May 30th 08, 02:13 PM posted to microsoft.public.excel.worksheet.functions
Dana DeLouis
external usenet poster
 
Posts: 947
Default 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
>> Thanks in advance for your feedback.
>> 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  
Old May 30th 08, 02:35 PM posted to microsoft.public.excel.worksheet.functions
Joe Gieder
external usenet poster
 
Posts: 73
Default 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
> >> Thanks in advance for your feedback.
> >> 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  
Old May 30th 08, 03:40 PM posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
 
Posts: 10,124
Default Escalation Formula

It's amazing what you can find in the help index for FV. Look there.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Joe Gieder" > wrote in message
news
> 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
>> >> Thanks in advance for your feedback.
>> >> 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

>>


 




Thread Tools
Display Modes

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


All times are GMT +1. The time now is 12:27 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.