Net Present Value (NPV) - Basics, Formula, Calculations in Excel (Step by Step)
WallStreetMojo
0:00 / 0:00
Net Present Value (NPV) - Basics, Formula, Calculations in Excel (Step by Step)
53 453 просмотра · 4 г. назад
WallStreetMojo
128 тыс. подписчиков
53 453 просмотра · 4 г. назад
In this video, we will talk about the Net Present Value (NPV), its meaning, formulas, calculations, and its uses.
00:00 - Introduction
01:05 - Future Value Concept
05:11 - Present Value Concept
08:47 - NPV - Net Present Value of Project
12:31 - NPV Formula
13:50 - NPV Calculation in Excel
16:14 - NPV Graph Profile
22:36 - NPV Limitation
What is NPV?
Net Present Value is primarily used to assess a project's profitability and is calculated as the difference between the present value of cash inflows and the present value of cash outflows over the project's time period.
Formula for NPV = NPVt=1 to T = ∑Xt / [(1+R) t – X0]
Two parts of NPV:
1. Cash Inflows from Investment
2. Cost of Investments in the project
Uses of NPV:
1. It compares both cash inflow and outflow
2. It offers a conclusive decision
3. Very easy to calculate
#wallstreetmojo, #NPV, #netpresentvalue
For more details, you can refer to our article at -https://www.wallstreetmojo.com/net-pr...
Subscribe to Our Channel -
Youtube ► / @wallstreetmojo
LinkedIn ► / mycompany
Facebook ► / wallstreetmojo
Instagram ► / wallstreetmojoofficial
Twitter ► / wallstreetmojo