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 →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
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 →Look Up the 2nd, 3rd or Nth Match in Excel
Look Up the 2nd, 3rd or Nth Match in Excel
VLOOKUP only finds the first match. Return a customer’s Nth order, the first N rows, the last match or the Nth largest per group…
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 →SUMIFS Between Two Dates and With OR Conditions in Excel
SUMIFS Between Two Dates and With OR Conditions in Excel
Total sales between two dates, for this month, or for “North OR East”: SUMIFS with date operators, array constants, SUMPRODUCT and FILTER, with the…
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 →