XIRR
An Excel function that finds the compound annual rate when cash flows arrive on irregular dates.
This one is not written up yet
The definition above is the short version. A full explanation — how it works, a worked example and the exam traps — is still being written. In the meantime the chapter below covers it in context.
Written up from the same chapter
- BenchmarkThe independently published index a scheme's performance is measured against, chosen to match its investment objective, asset allocation and strategy, and disclosed in the Scheme Information Document.
- BetaHow sharply a share moves relative to the market index — beta 1 moves with the index, above 1 amplifies it, below 1 dampens it. The standard measure of systematic risk.
- Business riskThe variability of a firm's income flows caused by the nature of its business — driven by how volatile its sales are and how much of its cost base is fixed.
- CAGRThe single smoothed annual rate at which a starting value would have to grow, compounding each year, to reach the ending value over a given period.
- Credit riskThe risk that a borrower fails to meet its obligations on a debt instrument — the risk credit rating agencies exist to grade, and the one that triggers a segregated portfolio in a mutual fund.
- Holding period returnThe total of coupons, income earned on reinvesting them and any capital gain, expressed as a percentage of the purchase price — a crude return for the period actually held, with no compounding in it.
Where this is taught
Free preparation for NISM Series XV← All terms