FinancialLevel: ExpertAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Related functions
PV returns today’s value of future payments at a discount rate — how much loan an EMI can support, or what an annuity is worth.
Syntax
=PV(rate, nper, pmt, [fv], [type])
| Argument |
What it means |
pmt |
Payment per period (negative). |
Examples
Example 1
=PV(9%/12, 20*12, -40000)
Loan amount a ₹40,000 EMI supports at 9% for 20 years — about ₹44.5 lakh.
FV · PMT · NPV
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong