How to calculate the net present value

Written by bradley james bryant
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to calculate the net present value
Calculate NPV using an Excel formula. (calculator image by L. Shat from Fotolia.com)

One of the most salient laws of finance is referred to as the time value of money. The concept states that a dollar today is worth more than a dollar tomorrow because you can invest that dollar today and make more than a dollar tomorrow. The Net Present Value (NPV) formula is based on the time value of money and is commonly used to make capital budgeting decisions. In layman's terms, the formula is used to find the present value of future cash flows. One way to calculate NPV is with Excel.

Skill level:
Moderately Easy

Other People Are Reading

Things you need

  • Excel

Show MoreHide

Instructions

  1. 1

    Determine the rate of discount (rate) over the length of one period. Let's say the discount rate is 8 per cent. This is usually equivalent to the minimum rate of return for a particular project.

  2. 2

    Determine Value 1, Value 2, etc. Each value represents a cash payment at the end of the year. That is a project that promises £65 for the next three years will have Value 1 = £65, Value 2 = £65, and Value 3 = £65.

  3. 3

    Determine the initial cost of the project. This is referred to as the project cost and is considered to be an outlay of funds. Let's say the project has a total cost of £130.

  4. 4

    Calculate the NPV. Insert the formula: "=NPV(8, -200, 100, 100, 100)", where 8 is the discount rate, -200 is the initial cost or outlay, and 100 is the cash flow at the end of the next three years.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.