excel function cumipmt
 

This function does not recognize a cell referrence (or a number directly
input) for the second input, number of periods. Instead it returns #N/A.

I think you are forgetting the last argument.
Rate / Nper / Pv / Start_period / End_Period / Type
If you're using the wizard, there is a 5th argument that you must tab down to.
Type...
0 = Payment at the end of the period
1 = payment at the start of the period.

=CUMIPMT(0.09/12,30*12,125000,13,24,0)
returns -11,135.23

HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Computer Bob" wrote:

This function does not recognize a cell referrence (or a number directly
input) for the second input, number of periods. Instead it returns #N/A.