Excel NPER Calculator

Written by:Abraham A.
Location:TVM

Finance.ThinkAndDone.com provides you online and windows calculators to calculate number of periods in a discounted lump sum or annuity just as you do with MS Excel NPER formula when you provide RATE, FV, PV and PMT

Location: TVM

Excel NPER Calculator

Developed by:Emma A.
Location:Financial Calculators
type in the authorization code in the box located below:

Results

NPER = 1

Input Data

Type in the present value (PV)  
Type in the rate per period (RATE)  
Type in the periodic contribution (PMT)  
Type in the future net worth (FV)  

Instructions

This online NPER Calculator works just like the NPER function in MS Excel. This online NPER calculator mimics the functionality provided by MS Excel's NPER function. It accepts the same number of parameters or arguments as the NPER function in Excel. The arguments that you have to provide to use this online NPER calculator include FV the future value of investment, PMT the periodic payment, PV the present value, the RATE of interest per period, and an optional argument of type which represent whether the PMT or payments begin at end of period which is the default value or begin at the start of the period. You will be delighted to find how this online NPER Calculator works and produces results just like MS Excel's NPER function. Thus if you are away from your computer and require using NPER function of Excel, this is the place to be at to get the results for your NPER calculations.

A sample example would be if you are borrowing $8000 from a lender who charges an monthly interest rate of approximately 0.77% and you have to make monthly payments of $200 for 48 months. You want to know the amount of loan you can afford at the interest rate and for the monthly payments you can afford. Follow the instructions below to find out the PV of the loan that you can afford.

  1. Type in 8000 in the box for PV
  2. Type in 0.77 in the box for RATE
  3. Type in -200 in the box for PMT (this is a negative amount since money is going out of your hands)
  4. Select End of Period for the payment TYPE
  5. Type in 0 for FV since the loan has no future worth
  6. Finally click on the calculate button to find NPER or number of periods required to pay off the loan
Location: Financial Calculators