Compound Interest in Open Office Calc

Question

I need a way to get the compound interest in open office calc, so do any functions already exist for such?

Answer 1

There is a function IPMT listed in the financial section, but personally, I always build the table and calculate this sort of thing manually, as I can't tell at a glance whether the results look right to the extent I can with the table.