Results 1 to 3 of 3

Thread: nper??? (2003)

  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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?
    A kick-start, please?
    Thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #3
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •