How To Calculate

Learn how to calculate anything
Menu
  • bmi
Home
rate
How to Calculate NPV in Excel.
rate

How to Calculate NPV in Excel.

Rosemary Njeri

The net present value (NPV) is just one of the many ways to determine the return on investment.

The reason that NPV is often chosen as the model for financial analysts is because it evaluates the time value of money and delivers a specific comparison between initial cash outlay versus the present rate of return.

Formula to calculate NPV in excel.

There are two methods to calculate the NPV in the Excel sheet.

First is to use the basic formula or use the excel’s NPV function.

Example:

Suppose you have the cash flows of a certain project X as follows.

YearCash flow
0100,000
1120,000
290,000
3130,000
480,000

If the discounting factor is 10%, calculate the NPV.

First we will need to transfer the data to an excel spreadsheet.

Calculate NPV in Excel.

Just like other functions, we have an NPV function in excel. When you click on it, something like this should appear. This is where you fill in the discounting rate and the numbers you want to find NPV for.

You should note that we add the initial outlay to the total.

Calculate NPV in Excel.
 Calculate NPV in Excel.

Therefore, the your NPV is 343,576.258452291.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

How to Calculate Social Security Tax.
Social security tax is paid by workers and employers on …

How to Calculate Social Security Tax.

How to Calculate Celsius to Fahrenheit.
Celsius and Fahrenheit are both units of temperature. Celsius scale, …

How to Calculate Celsius to Fahrenheit.

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