Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Future Value Formula & Interest Rate Formula
I need to figure out how to do two functions, the basic future value and the
basic interest rate formula. All I can find are annuity formulas where you need to enter in a payment, but that is not what I need as there are no payments. Example 1 (Future Value): Such as on a financial calculator all I need to enter would be the Present Value, the Interest Rate, and the # of Years to find the future value. Example 2 (Interest Rate): Again on a financial calculator where I would only need to enter the Present Value, the Future Value, and the # of Years to find what the interest rate or rate of return would be. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Future Value Formula & Interest Rate Formula
Peter wrote:
I need to figure out how to do two functions, the basic future value and the basic interest rate formula. All I can find are annuity formulas where you need to enter in a payment, but that is not what I need as there are no payments. Enter zero for the payment parameter. Example 1 (Future Value): Such as on a financial calculator all I need to enter would be the Present Value, the Interest Rate, and the # of Years to find the future value. =fv(a1, a2, 0, -a3) where A1 is the annual interest rate, A2 is the number of years, and A3 is the present value. Note: This assumes annual compounding frequency. Example 2 (Interest Rate): Again on a financial calculator where I would only need to enter the Present Value, the Future Value, and the # of Years to find what the interest rate or rate of return would be. =rate(a2, 0, -a3, a4) where A2 and A3 are as above, and A4 is the future value. Caveat: Sometimes RATE() returns an error (#NUM!) if it cannot guesstimate the interest rate. See the RATE() Help page to learn about the "guess" parameter. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Future Value Formula & Interest Rate Formula
PS....
I wrote: =fv(a1, a2, 0, -a3) where A1 is the annual interest rate, A2 is the number of years, and A3 is the present value. I should have said "present value as a positive number". Often, the PV is represented as a negative number. In that case, you want "a3", not "-a3" above. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
financial function ..please | Excel Worksheet Functions | |||
interest rate mathematical formula | Excel Discussion (Misc queries) | |||
Financial formula to calculate interest income | Excel Discussion (Misc queries) | |||
Formula to calculate cumulative interest | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |