hi,
you basicly have to create a table because both formulas key on balance due
and balance due drops with each payment so each month requires a new
calculation based on balance due.
the sentax and examples are in xl help.

regards
FSt1

"William" wrote:

How to use IPMT and PPMT to compute Interest and Investment payment, says, at
10 months period.

Thanks