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.