Just to add, the formula is found under the PV function in Help:

For an OnLine version:

http://office.microsoft.com/en-us/ex...092251033.aspx

The other key elements are based on an algebraic manipulation of this
formula to get the unknown value alone on one side of the equal sign.

--
Regards,
Tom Ogilvy

"Niek Otten" wrote in message
...
Hi kudanil,

Excel's financial functions (PMT, RATE, IPMT, NPER, FV) are one family
with one basic formula. That is the formula for PV. It is
described fully in Excel Help and I can't reproduce it here because of the
math symbols.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kudanil" wrote in message
...
|I need to explain to my student how is PMT and IPMT work. Does anyone can
| explain what is the equation behind those formulas?
|
| Regards
|
| kudanil.