Excel PV Calculator

Written by:Abraham A.
Location:TVM

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

Location: TVM

Excel PV Calculator

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

Results

PV = PV = -59777.15

Input Data

Type in the number of periods (NPER)  
Type in the rate per period (RATE)  
Type in the periodic contribution (PMT)  
Type in the future net worth (FV)  

Instructions

This online PV Calculator works just like the PV function in MS Excel. This online PV calculator mimics the functionality provided by MS Excel's PV function. It accepts the same number of parameters or arguments as the PV function in Excel. The arguments that you have to provide to use this online PV calculator include FV the future value of investment, PMT the periodic payment, NPER the number of periods (may be years, quarters, months, weeks, or days), 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 PV Calculator works and produces results just like MS Excel's PV function. Thus if you are away from your computer and require using PV function of Excel, this is the place to be at to get the results for your PV calculations.

A sample example would be if you are borrowing money 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 48 in the box for NPER
  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 PV of the loan
Location: Financial Calculators