+ Reply to Thread
Results 1 to 2 of 2

Calculate maturity date on loan

  1. #1
    Registered User
    Join Date

    Smile Calculate maturity date on loan

    Hi, I'm a first timer on this forum.

    I'm trying to find a function or build a formula that will allow me to calculate the maturity date on a loan or at least determine the number of months until the loan pays off. I know the current balance, interest rate and monthly payment. I thought this would be easy, hopefully it is and I'm just missing something. Any help would be appreciated.

  2. #2
    Registered User
    Join Date
    If you're hoping to set up an amortization schedule, you will need to know the principle amount as well. You can then calculate the loan term using the NPER formula.

    If all you know is the current balance (CB) and the monthly payment (MP), then simply divide: months remaining = CB/MP.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1