RECEIVED Function in Excel: Amount Received at Maturity
FinancialLevel: ExpertAvailable in: Excel 2007+RECEIVED calculates what you get back at maturity for a discounted security.Syntax=RECEIVED(settlement.
Read article →Financial
Excel Financial functions explained with syntax, examples and common mistakes.
📊
← Excel
Financial
Excel Financial functions explained with syntax, examples and common mistakes.
📄 56 articles⬇️ 41 with practice files🕒 Updated 12 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →PDURATION Function in Excel: Years Needed to Reach a Target
PDURATION Function in Excel: Years Needed to Reach a Target
PDURATION returns how many periods an investment needs to grow to a target at a given rate (lump sum, no regular payments).
Read article →INTRATE Function in Excel: Interest Rate of a Fully Invested Security
INTRATE Function in Excel: Interest Rate of a Fully Invested Security
INTRATE returns the annualised return when you invest an amount and receive a larger amount at maturity, with nothing in between.
Read article →NPER Function in Excel: How Many Payments Until Paid Off
NPER Function in Excel: How Many Payments Until Paid Off
NPER returns the number of periods needed to repay a loan or reach a savings goal.
Read article →PV Function in Excel: What a Future Amount Is Worth Today
PV Function in Excel: What a Future Amount Is Worth Today
PV returns today's value of future payments at a discount rate — how much loan an EMI can support, or what an annuity is…
Read article →RRI Function in Excel: Equivalent Annual Growth Rate (CAGR)
RRI Function in Excel: Equivalent Annual Growth Rate (CAGR)
RRI returns the constant growth rate needed to go from a start value to an end value — i.e. CAGR in one function.
Read article →FVSCHEDULE Function in Excel: Growth at Changing Rates
FVSCHEDULE Function in Excel: Growth at Changing Rates
FVSCHEDULE compounds an amount through a list of different rates — FD renewals, varying annual returns.
Read article →XNPV Function in Excel: NPV for Cash Flows on Specific Dates
XNPV Function in Excel: NPV for Cash Flows on Specific Dates
XNPV discounts cash flows that happen on irregular dates — more accurate than NPV for real projects.
Read article →FV Function in Excel: Future Value of Savings or SIPs
FV Function in Excel: Future Value of Savings or SIPs
FinancialLevel: IntermediateAvailable in: Excel 2007+FV returns what regular investments (like a SIP or RD) grow to at a fixed rate.Syntax=FV(rate, nper.
Read article →IRR Function in Excel: Return of Regular (Periodic) Cash Flows
IRR Function in Excel: Return of Regular (Periodic) Cash Flows
IRR returns the rate at which the NPV of regular, equally spaced cash flows is zero. For irregular dates use XIRR.
Read article →MIRR Function in Excel: IRR With Realistic Reinvestment
MIRR Function in Excel: IRR With Realistic Reinvestment
MIRR fixes IRR's optimistic assumption that cash is reinvested at the IRR itself, using separate finance and reinvestment rates.
Read article →XIRR Function in Excel: Real Return on SIPs and Irregular Cash Flows
XIRR Function in Excel: Real Return on SIPs and Irregular Cash Flows
XIRR returns the annualised return for cash flows on specific dates — the right way to measure SIP and mutual-fund returns.
Read article →