| PV | PV(rate, nper, pmt, [fv], [type]) | Present value of a goal or annuity | pmt / fv negative for outflows |
|---|
| FV | FV(rate, nper, pmt, [pv], [type]) | Corpus after n periods | pv negative for an outflow |
|---|
| PMT | PMT(rate, nper, pv, [fv], [type]) | EMI on a loan, SIP needed for a goal | pv negative → positive EMI |
|---|
| NPER | NPER(rate, pmt, pv, [fv], [type]) | Tenure to repay a loan or reach a goal | pmt negative, pv positive |
|---|
| RATE | RATE(nper, pmt, pv, [fv], [type]) | CAGR, implied yield, loan rate | pv negative when solving for a return |
|---|
| PPMT | PPMT(rate, per, nper, pv) | Principal in a given EMI | Same as PMT |
|---|
| IPMT | IPMT(rate, per, nper, pv) | Interest in a given EMI | Same as PMT |
|---|
| NPV | NPV(rate, values) + CF₀ | NPV of goal-based cash flows | NPV excludes CF₀; add it separately |
|---|
| IRR | IRR(values, [guess]) | MWRR, project return | First cash flow usually negative |
|---|
| XIRR | XIRR(values, dates) | MWRR with irregular dates (e.g. SIPs) | Same as IRR |
|---|
| YIELD | YIELD(settle, maturity, rate, price, redemption, freq, [basis]) | Bond YTM | G-Secs: freq = 2 |
|---|