Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Constant growth
The formul =FV((rate cell),(Year cell - year cell),(amount cell +amount
cell)) is giving me result "num". The objective is to apply a constant inflationery rate to amounts to arrive at future amount. -- 050529 Accountant |
#2
|
|||
|
|||
Make sure that (Year cell-year cell) in your formula is actually giving you
the correct total number of payments. -- Gary's Student "050529" wrote: The formul =FV((rate cell),(Year cell - year cell),(amount cell +amount cell)) is giving me result "num". The objective is to apply a constant inflationery rate to amounts to arrive at future amount. -- 050529 Accountant |
#3
|
|||
|
|||
Yes it is. The start time (year cell) is locked by $ sign.
I am trying to project future $ value at constant growth rate i.e. if I spend $10,000 to buy a new car, how many dollars I will spend after five years for the same new car if the price growth rate is say 3%? -- 050529 Accountant "Gary's Student" wrote: Make sure that (Year cell-year cell) in your formula is actually giving you the correct total number of payments. -- Gary's Student "050529" wrote: The formul =FV((rate cell),(Year cell - year cell),(amount cell +amount cell)) is giving me result "num". The objective is to apply a constant inflationery rate to amounts to arrive at future amount. -- 050529 Accountant |
#4
|
|||
|
|||
FV is normally used to compute the future value of a cash stream of periodic
constant payments. Please look at FVSCHEDULE in EXCEL Help to see if this function might be more useful to you. It calculates the future value of an initial investment given either constant or fluctuating rates. Good Luck -- Gary's Student "050529" wrote: Yes it is. The start time (year cell) is locked by $ sign. I am trying to project future $ value at constant growth rate i.e. if I spend $10,000 to buy a new car, how many dollars I will spend after five years for the same new car if the price growth rate is say 3%? -- 050529 Accountant "Gary's Student" wrote: Make sure that (Year cell-year cell) in your formula is actually giving you the correct total number of payments. -- Gary's Student "050529" wrote: The formul =FV((rate cell),(Year cell - year cell),(amount cell +amount cell)) is giving me result "num". The objective is to apply a constant inflationery rate to amounts to arrive at future amount. -- 050529 Accountant |
#5
|
|||
|
|||
Thanks Gary's Student
-- 050529 Accountant "Gary's Student" wrote: FV is normally used to compute the future value of a cash stream of periodic constant payments. Please look at FVSCHEDULE in EXCEL Help to see if this function might be more useful to you. It calculates the future value of an initial investment given either constant or fluctuating rates. Good Luck -- Gary's Student "050529" wrote: Yes it is. The start time (year cell) is locked by $ sign. I am trying to project future $ value at constant growth rate i.e. if I spend $10,000 to buy a new car, how many dollars I will spend after five years for the same new car if the price growth rate is say 3%? -- 050529 Accountant "Gary's Student" wrote: Make sure that (Year cell-year cell) in your formula is actually giving you the correct total number of payments. -- Gary's Student "050529" wrote: The formul =FV((rate cell),(Year cell - year cell),(amount cell +amount cell)) is giving me result "num". The objective is to apply a constant inflationery rate to amounts to arrive at future amount. -- 050529 Accountant |
#6
|
|||
|
|||
For a single sum you really don't require and XL function. Just use the
formula for future value youramount * (1+rate)^n where rate is the "inflationary" rate (as a decimal) and n is the number of years. PC "050529" wrote in message ... The formul =FV((rate cell),(Year cell - year cell),(amount cell +amount cell)) is giving me result "num". The objective is to apply a constant inflationery rate to amounts to arrive at future amount. -- 050529 Accountant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating growth with negative numbers | Excel Worksheet Functions | |||
Employing constant arrays to limit nested IF statements. | Excel Worksheet Functions | |||
percentage of growth | Excel Worksheet Functions | |||
making a column of formuls constant | Excel Worksheet Functions | |||
making calculated fields constant. | Excel Worksheet Functions |