FinancialLevel: IntermediateAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Related functions
FV returns what regular investments (like a SIP or RD) grow to at a fixed rate.
Syntax
=FV(rate, nper, pmt, [pv], [type])
| Argument |
What it means |
rate |
Rate per period (annual/12 for monthly). |
pmt |
Regular investment, as a negative number. |
type |
1 if you pay at the start of each period (typical for SIPs). |
Examples
Example 1
=FV(12%/12, 10*12, -10000, 0, 1)
₹10,000 a month for 10 years at 12% a year — about ₹23.2 lakh.
💡 Market-linked returns vary year to year; FV assumes a constant rate, so treat it as an estimate.
PV · PMT · XIRR
📚 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