Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PPMT & IPMT
Please review the following formula's and let me know if they are
correct: I'm trying to calculate the principal payment for $19,855,000 @ 6.25% interest rate over 15.5 years with 1 principal payment per year. =-PPMT(6.25%,1,15.5,19,855,000) I'm trying to calculate the interest payment for $19,855,000 @ 6.25% interest rate over 15.5 years with 2 interest payments per year =-IPMT(6.25,1,15.5,$19,855,000) I think something's missing. Please advise. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IPMT Function for fractional periods | Excel Discussion (Misc queries) | |||
How to use IPMT and PPMT to compute Interest and Investment paymen | Excel Worksheet Functions | |||
pPMT malfunction | Excel Worksheet Functions | |||
PPMT formula that generates equal payments | Excel Worksheet Functions | |||
IPMT and ISPMT | Excel Worksheet Functions |