compounding interest

[Daddywarbucks]

How do u do compounding interest in excel ?

[ratcat]

G'day and welcome to the forum


Formula

=IPMT

This returns the interest payment for the a given period for an investment, based on periodic, constant payments and a contstant interest rate. Press F1for Excel help to take you through step by step.

Or

You can google in keywords compound interest payments and you might find the mathematical formula to enter in excel.

HTH

Cheers

[Richard Buttrey]

How do u do compounding interest in excel ?

You may need to be a bit more specific. Have you checked out the various standard financial formulae in Excel?

If it's just the compounded value of an initial Payment (PMT) after (n) periods at (i) interest rate per period, just use the formula

=

Please Login or Register  to view this content.

HTH