1. ## nper??? (2003)

I'm struggling with solving a straightforward problem:
How many on-time full-sized repayments on a loan of x moneyunits over a period y months at interest rate i % per month are needed to diminish the loan by d %?
I figure it's something to do with NPER and/or FV and/or PMT but can't get my head round it. I also figure that it's independent of the value of x, isn't it?
Thanks

2. ## Re: nper??? (2003)

If I understand your question, Isn't it a matter ofjust setting the future value (instead of assuming it to be zero)? This seems to work:

<pre>=NPER(i,PMT(i,y,-x),-x,x*d)</pre>

Or since the periods are independent of the X, you could use (note you still need the X to calculate the payments):
<pre>=NPER(i,PMT(i,y,-x),-1,d)</pre>

Steve

3. ## Re: nper??? (2003)

Thanks, Steve, sorted.
Couldn't sort out the +'s from the minuses.
Drongo. Me.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•