| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
mathematical formula of rate
what is the mathematical formula of RATE(nper,pmt,pv,fv,type,guess);
i have the pmt, the number of payments, and the present value i need to calculate the rate on paper |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
mathematical formula of rate
use the function RATE to calculate interest rate for constant payment loan -- jetted ------------------------------------------------------------------------ jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532 View this thread: http://www.excelforum.com/showthread...hreadid=558796 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
mathematical formula of rate
it is detailed in help, PV worksheet function -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=558796 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
mathematical formula of rate
Hi Robert Have a look at this web page for additional info http://techonthenet.com/excel//formulas/rate.php -- jetted ------------------------------------------------------------------------ jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532 View this thread: http://www.excelforum.com/showthread...hreadid=558796 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
mathematical formula of rate
hello robert111,
thanks for the information it was helpfull, but i need to calculate the rate in this formula: pmt= pv * i / 1 - (1/(1+i)^n) where i=rate, n=period, pmt=annuity, pv=present value i=? "robert111" wrote: it is detailed in help, PV worksheet function -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=558796 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
mathematical formula of rate
i = (PMT*(1-(1+i)^n))/pv -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=558796 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| bank cal for interest on cd | Excel Worksheet Functions | |||
| formula compund rate of growth | Excel Worksheet Functions | |||
| XNPV vs. NPV(quarterly) different results | Excel Worksheet Functions | |||
| Rate of return required formula | Excel Worksheet Functions | |||
Hybrid Mode
