How To Calculate

Learn how to calculate anything
Menu
  • bmi
Home
Cost
How to Calculate Present Value in Excel.
Cost

How to Calculate Present Value in Excel.

Rosemary Njeri

Present value, also known as discounted value describes how much a future sum of money is worth today.

The present value is conversely related to the discount rate. Thus, a higher discount rate implies a lower present value and vice versa.

Formula to calculate present value in excel.

Just like other functions, the PV function is available in excel.

To use the function, you will need to first understand the following terms.

  1. rate (required argument) – The interest rate per compounding period.
  2. nper (required argument) – The number of payment periods.
  3. pmt (required argument) – The fixed payment per period.
  4. fv (optional argument) – An investment’s future value at the end of all payment periods (nper). If there is no input for fv, Excel will assume the input is 0.
  5. type (optional argument) – Type indicates when payments are issued. There are only two inputs, 0 and 1. If type is omitted or 0 is the input, payments are made at period end. If set to 1, payments are made at period beginning.

Example:

Calculate the present value of an annuity that pays periodic payments of $100 with a 5.5% annual interest rate. The annuity makes payments twice per year and will do so for 3 years.

  1. The compounding rate (rate) will be 5.5 ÷ 2 = 2.75%
  2. The number of payment periods (nper) will be 3 x 2 = 6.
  3. The fixed payment period (pmt) is 3 years.

We will begin by transferring the data to an excel spreadsheet.

 Present Value in Excel.

Using the PV function, we are going to find the present value of the annuity.

Present Value in Excel.

We are required to fill the values in the function arguments.

Present Value in Excel.

Therefore, your present value is $-87.51.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

How To Calculate Total Cost
Total cost is the actual cost incurred in the production …

How To Calculate Total Cost

How to Calculate Interest Expense.
Interest expense is a non-operating expense shown on the income …

How to Calculate Interest Expense.

Leave a Reply Cancel Reply

Popular Posts

  • 5 Best AI Apps for Solving Complex …
    March 22, 2023 0

Categories

learntocalculate.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

How To Calculate

Learn how to calculate anything

Pages

  • About Us
  • Contact Us
  • Privacy Policy
Copyright © 2023 How To Calculate

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh