zakruti.com » IT - Software » Geeks Tutorial

How to Calculate Net Present Value (Npv) in Excel

video description

Rating: 4.0; Vote: 1

you will learn to calculate Net Present Value, or NPV, in Excel. In this tutorial, you will learn to calculate Net Present Value, or NPV, in Excel. Net Present Value is a financial function that is calculated for an investment, and it represents the present value of the investment minus the amount of money that costs to buy in. Excel offers a preset function for this called NPV. Please be aware that all the investment cash flows must occur at the same interval for the calculation to be accurate. NPV has two arguments: rate -- which refers to the discount rate, and the range of values that contains future cash flows. Step 1: Open the document in which you want to calculate NPV. Step 2. Go to the cell where you want the function to be calculated, and type the following: = npv (our discount rate /12 as the rate is compounded monthly, the range of values you want to be considered)+the initial investment, in our case the starting 100, 000$. Step 3. Excel will calculate for you the Net Present Value of this investment. Step 4. Go to the cell that you want to hold the NPV result for comparison, and type: =npv(the same discount rate/12, the range of values)+the initial investment. Hit Enter. Step 5. Excel will calculate for you the Net Present Value of this investment. Step 6. Now that we see both results, we will agree that the first option is better and proceed with it. Result: Congratulations, you have learned how to calculate the Net Present Value in Excel
Date: 2023-07-08

← How to Sort data in a Pivot Table or Pivot Chart

How to Change Caps to Lowercase in Excel →

Related videos

Is Selecting Hair STILL a Pain in Photoshop [SOLUTION]

• PiXimperfect

How to Speed Up Windows 11 (Best Settings)

• Geeks Tutorial

JUSTICE: NZXT, Fragile to Pay $3,450,000 for Rental PC Scam

• Gamers Nexus

Private DIY Servers Are Illegal Black Markets of Piracy - The ESA's Shady Ties

• Gamers Nexus

Intel Arc GPU Driver Problems Revisited: 2025 Arc Graphics Driver Review

• Gamers Nexus

The DRAM Cartel - Price Fixing, Anti-Consumer Collusion, & Corporate Conspiracy

• Gamers Nexus

Comments and reviews: 6

lbisthebestband
You just copied this video from LinkedIn Learning Solutions, and you're both wrong. You do not divide the interest rate by 12. Watch any other video, use a financial calculator, or calculate each year's present value manually and then subtract the initial investment to see you are just wrong.
reply

Karina
Omg, thank you. I was including the initial investment as part of the values. Why doesn't excel do this? It's much more intuitive to include it as part of the values (as negative cash flow) than add it at the end of the formula. So freaking weird.
reply

dembh
It seems wrong. To calculate the PV of the $25, 000, we compute PV of an Annuity.
$25, 000/0. 07 ( 1 - [ 1 / (1. 075) ] ) which is = $102, 504. 9359 and then subtract the initial investment of -$100, 000; total NPV = $2, 504. 94
reply

Alessandro
by the way. the two investments should have the same life. To evaluate two investments that have different life is used a method called replacement chain.
reply

Iliketriangles2
? I did What u did in the video and I got the same npv but +$200k? So:
222 841, 93 and 222 416, 13?
reply

itech
Why dont need to minus Initial Investment? THE EXCEL SHOW THAT YOUR NPV IS ADD Initial Investment
i
reply

Add a review, comment