| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating future values for assets & liabilities based on ror
I am trying to figure out how to calculate what a future value of assets and
liabilities will be in 5 & 10 years based on what I estimate the Rate of Return to be. Ex: If my home is valued at X and I assume in 5 years it will valued at 3% more...what will the value be in 5 years. I need to make sure that I am calculating the cumalative interest rate comounded annually? Can anyone help me? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating future values for assets & liabilities based on ror
Hi,
Take a look at the FV (future value) function. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Janna" wrote: I am trying to figure out how to calculate what a future value of assets and liabilities will be in 5 & 10 years based on what I estimate the Rate of Return to be. Ex: If my home is valued at X and I assume in 5 years it will valued at 3% more...what will the value be in 5 years. I need to make sure that I am calculating the cumalative interest rate comounded annually? Can anyone help me? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating future values for assets & liabilities based on ror
To calculate future value, use the FV function as in:
=fv(3%,5,0,a1) Regards, Fred. "Janna" <Janna @discussions.microsoft.com wrote in message ... I am trying to figure out how to calculate what a future value of assets and liabilities will be in 5 & 10 years based on what I estimate the Rate of Return to be. Ex: If my home is valued at X and I assume in 5 years it will valued at 3% more...what will the value be in 5 years. I need to make sure that I am calculating the cumalative interest rate comounded annually? Can anyone help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating values based on selection from a drop-down list in Exc | Excel Worksheet Functions | |||
| Calculating a future date | Excel Discussion (Misc queries) | |||
| Calculating values in two columns based on a variable | Excel Discussion (Misc queries) | |||
| Calculating a Date for the Future | Excel Worksheet Functions | |||
| calculating the future value of a present value | Excel Worksheet Functions | |||
![Janna[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
