(Net Present Value) NPV Calculator – The Calculation for Right Investment
Hello friends! Just think – if you are making any Investment today, like buying land, opening a shop, or investing in a Project, Business, Property, or Share Market, how will you know whether it will give Profit or Loss in the future?
Net Present Value (NPV) Calculator
Cash Flows:
| Year | Cash Flow (₹) | Action |
|---|---|---|
| 1 |
Net Present Value (NPV) = ∑ (Cash Flowt / (1 + r)t) – Initial Investment
जहाँ:
• r = Discount Rate
• t = Year
• Cash Flow = हर साल का inflow
• Initial Investment = Project में शुरू की गई राशि
Just seeing that money will come in the future is not enough. Because ₹100 today and ₹100 received five years later do not have the same value.
This is the play of the Time Value of Money. Money today is more valuable, money tomorrow is a bit less. Understanding this difference is how we decide whether our Investment is right or a loss-making deal.
This is where the Net Present Value (NPV Calculator) comes in. It tells us what the Present Value of future Cash Flows is. And based on that, we can know whether making the Investment is profitable or not. That’s why we need the NPV Calculator to know the real value of an Investment.
What is Net Present Value (NPV)?
In simple language – NPV is a method through which we find out that
NPV = Present Value of Future Cash Inflows – Initial Investment
That means, calculate the today’s value of the money that will come in the coming years and subtract the current expense. The result is the Net Present Value.
- If NPV > 0 (Positive) → Project is profitable.
- If NPV < 0 (Negative) → Project is a loss-making deal.
- If NPV = 0 → Project gives neither profit nor loss.
NPV Formula (Net Present Value Formula)
The easiest formula to calculate NPV is –
NPV — Net Present Value (Explained Simply)
Formula:
\(\displaystyle \text{NPV}=\sum_{t=1}^{n}\frac{\text{CashFlow}_t}{(1+r)^t}-\text{InitialInvestment}\)
Explanation (short): \( \text{CashFlow}_t \) is the amount received in year \(t\), \(r\) is the discount rate. Future cash is converted to present value to make a correct decision.
Example (step-by-step)
Assumptions: Initial Investment = ₹100,000; Cash Flows = [₹30,000, ₹40,000, ₹50,000]; r = 10%.
- Year 1 PV: \( \dfrac{30{,}000}{(1.10)^1} = 27{,}272.7273 \)
- Year 2 PV: \( \dfrac{40{,}000}{(1.10)^2} = 33{,}057.8512 \)
- Year 3 PV: \( \dfrac{50{,}000}{(1.10)^3} = 37{,}565.7400 \)
Sum of PVs: \(27{,}272.7273 + 33{,}057.8512 + 37{,}565.7400 = 97{,}896.3186\)
NPV = \(97{,}896.3186 – 100{,}000 = -2{,}103.6814\) → Negative NPV (loss)
Note: You can change cash flows and rate to quickly calculate NPV using the same template.
Example of NPV Calculation
Suppose you invested ₹1,00,000 in a Project. Now you will receive money every year for 3 years –
| Year | Cash Flow (₹) | Discount Rate (10%) | Present Value (₹) |
|---|---|---|---|
| 1 | 40,000 | 1 / (1+0.10)^1 | 36,364 |
| 2 | 50,000 | 1 / (1+0.10)^2 | 41,322 |
| 3 | 60,000 | 1 / (1+0.10)^3 | 45,078 |
👉 Total Present Value = 36,364 + 41,322 + 45,078 = ₹1,22,764
👉 Initial Investment = ₹1,00,000
✅ NPV = ₹1,22,764 – ₹1,00,000 = ₹22,764 (Positive)
This means – the Project is profitable.
NPV vs IRR
People often ask – “What is the difference between NPV and IRR?”
NPV (Net Present Value): Present Value of Future Cash Flow – Initial Investment.
IRR (Internal Rate of Return): The rate of return at which NPV = 0.
👉 Decision Rule:
If NPV is Positive → Invest.
If IRR is higher than the Required Rate → Invest.
FAQ: Online Free NPV Calculator
Why is NPV Important?
NPV tells you whether your Investment will give Profit or Loss in the future.
What to do if NPV is Negative?
Negative NPV means the Project will incur a loss. It’s better to avoid it.
Which is better, NPV or IRR?
Both are important, but NPV is more reliable.
Apart from Business, where else is NPV used?
In Real Estate, Share Market, Loan Calculation, Project Analysis – everywhere.
Leave a Comment