Re: PMT function... Message #4 Posted by bill platt on 25 Mar 2004, 1:58 p.m., in response to message #1 by eclectic_echidna
Hi,
You need to look at the Excel help for "PV" to see the formula they are using.
An excerpt from Excel Help:
[quote]
PMT
See Also
Calculates the payment for a loan based on constant payments and a constant interest rate.
Syntax
PMT(rate,nper,pv,fv,type)
For a more complete description of the arguments in PMT, see the PV function.
[quote/]
Best regards,
Bill
Edited: 25 Mar 2004, 1:59 p.m.
|