Kalkulator NPV (Net Present Value)
Evaluasi kelayakan investasi dengan analisis NPV yang komprehensif. Hitung present value dengan mempertimbangkan time value of money untuk keputusan investasi yang optimal.
Investasi awal yang dikeluarkan
Required rate of return / WACC
Cashflow per tahun, pisahkan dengan koma. Tahun 1, Tahun 2, dst.
๐ NPV Formula:
NPV = ฮฃ [CFโ รท (1 + r)แต] - Initial Investment
CF = Cash Flow, r = Discount Rate, t = Time Period
NPV > 0: Accept project, NPV < 0: Reject project
โ Decision Criteria:
NPV > 0: Project adds value - ACCEPT
NPV = 0: Project breaks even
NPV < 0: Project destroys value - REJECT
PI > 1: Return exceeds cost of capital
Analisis NPV (Net Present Value)
๐ Key Metrics
Initial Investment-Rp 1.000.000.000
Discount Rate10% per year
Net Present Value (NPV)
Rp 823.416.185
โ
Positive (Accept)
Profitability Index (PI)
1.82
๐ข Excellent
NPV Break-evenYear 4
๐ฐ Discounted Cashflows
Year | Cash Flow | Present Value | Cumulative NPV |
---|---|---|---|
0 | -Rp 1.000.000.000 | -Rp 1.000.000.000 | -Rp 1.000.000.000 |
1 | Rp 300.000.000 | Rp 272.727.273 | Rp -727.272.727 |
2 | Rp 400.000.000 | Rp 330.578.512 | Rp -396.694.215 |
3 | Rp 500.000.000 | Rp 375.657.400 | Rp -21.036.814 |
4 | Rp 600.000.000 | Rp 409.808.073 | Rp 388.771.259 |
5 | Rp 700.000.000 | Rp 434.644.926 | Rp 823.416.185 |
Green rows indicate positive cumulative NPV
๐ Sensitivity Analysis
Discount Rate 8%
NPV: Rp 935.055.576
PI: 1.94
Discount Rate 10%
NPV: Rp 823.416.185
PI: 1.82
Discount Rate 12%
NPV: Rp 721.134.464
PI: 1.72
Discount Rate 15%
NPV: Rp 583.160.810
PI: 1.58
Shows how NPV changes with different discount rates
๐ฏ Investment Decision
ACCEPT PROJECT
Project creates value of Rp 823.416.185 in today's money
๐ก Rekomendasi
โ
NPV positif - investasi menguntungkan.
๐ข Profitability Index >1.2 - investasi sangat menarik.
โฑ๏ธ Break-even NPV pada tahun ke-4.
๐ Investment Insights:
โข NPV per rupiah invested: Rp 0.82
โข Total PV of cashflows: Rp 1.823.416.185
โข Project duration: 5 years
โข Project returns 82.0% more than required rate
โข Cumulative NPV becomes positive in year 4