Quantitative techniques — CFP IPS

Numbers settle financial debates. A CFP must be able to compute, present, and explain investment returns at multiple levels of precision. This sub-module covers TVM, NPV, IRR, and the four major return concepts every CFP candidate needs cold. The exam tests calculation; practice converts these into instinct.

Foundation

TVM — Time Value of Money: the founding principle. ₹100 today > ₹100 tomorrow. Discount future cash flows to present value. PV = FV / (1+r)^n. NPV — Net Present Value: sum of discounted cash flows, minus initial investment. Decision rule: NPV > 0, accept; NPV < 0, reject. IRR — Internal Rate of Return: discount rate at which NPV = 0. Compare to required return: IRR > required, accept. Return types: • Arithmetic mean: simple average of period returns • Geometric mean (CAGR): compound growth rate. Use for actual investor experience. • Money-weighted return (XIRR): IRR including the timing and size of investor cash flows. Captures actual investor experience including SIP timing. • Time-weighted return (TWR): manager-skill measure, neutral to cash-flow timing. Used to compare managers.

Deep Dive

TVM applications in financial planning: Goal corpus calculation: PV of goal future value = Goal FV ÷ (1+r)^n Example: ₹1 cr in 20 years, expected return 10% → PV = 1 cr / (1.10)^20 = ₹14.86 lakh today SIP corpus: FV = PMT × [((1+r)^n − 1) / r] × (1+r) for SIP-due (start of month). Loan EMI: EMI = P × r × (1+r)^n / [(1+r)^n − 1] Example: ₹50 lakh loan, 9% annual (0.75%/month), 20 years (240 months) EMI = 50,00,000 × 0.0075 × (1.0075)^240 / [(1.0075)^240 − 1] = ₹44,986 Use Excel/Sheets functions: PV(), FV(), PMT(), NPER(), RATE(), IRR(), XIRR(). These solve any TVM problem in seconds. NPV/IRR for project evaluation: NPV > 0 → project creates value at required return → accept IRR > required return → same conclusion Multiple positive-NPV projects, capital constrained → rank by Profitability Index = NPV / Initial Investment Return types in practice: Arithmetic mean overstates compound growth (Jensen's inequality). Geometric (CAGR) is the actual investor experience. XIRR handles uneven cash flows (SIPs, withdrawals); time-weighted is manager-evaluation neutral.

Worked example

Worked example — child education planning Mrs. Reddy's daughter is 5 years old. She wants to fund engineering education at age 18. Current annual cost in tier-1 college: ₹4 lakh. Inflation in education costs: 10%. Her investment options yield 10% nominal return. Step 1: Project cost at age 18. Years to fund: 13 Cost in 13 years: ₹4 lakh × (1.10)^13 = ₹4 lakh × 3.452 = ₹13.81 lakh per year 4-year program total: ~₹55-60 lakh Step 2: Compute monthly SIP needed. Goal corpus: ₹56 lakh Years: 13, Monthly rate r = (1.10)^(1/12) − 1 ≈ 0.797% n = 156 months FV = PMT × [(1.00797)^156 − 1] / 0.00797 ₹56,00,000 = PMT × 309.99 PMT = ₹18,065 per month Mrs. Reddy needs to SIP ~₹18,065 per month for 13 years to fund education. If education inflation actually runs 12% (more conservative): cost in year 13 = ₹4 × (1.12)^13 = ₹17.5 lakh/year, total ~₹70 lakh. SIP needed: ₹22,500 per month. The CFP's value-add: showing the math, the assumptions, and recommending review every 3 years to adjust if returns or inflation differ.

Real-world scenario

Real-world scenario — explaining XIRR to Mr. Khanna Mr. Khanna started a ₹15K monthly SIP in 2020 in an equity fund. Today (5 years later) the fund's 5-year NAV CAGR shows 13%. His statement says XIRR 16.5%. "Why are these different?" he asks his CFP. Explanation: • Fund's NAV grew 13% per year compound from any starting point. • Mr. Khanna started in March 2020 (low) and continued through volatility. • During 2020 lows, his SIP installments bought more units cheaply. • Recovery added strong returns to those cheap purchases. • His XIRR captures: each ₹15K invested, returned how many rupees, given the cash-flow timing. • XIRR 16.5% = he earned more than the fund's buy-and-hold CAGR because his SIPs averaged into low prices. If Mr. Khanna had lump-summed in January 2020 (just before crash), his XIRR would be 9-10% (worse than the 13% fund CAGR) — because he bought high and rode the drop. Lesson: SIP discipline through volatility creates the gap. CFPs can show this concretely to motivate continued SIP through future bear markets. "Don't look at fund CAGR; look at your XIRR to understand your experience. The difference is your behaviour."

Advanced

Practitioner insight: most retail investors confuse XIRR (their actual experience) with the fund's NAV-based CAGR. A client SIP-ing through a volatile market will have higher XIRR than the fund's 5-year CAGR if they bought low; lower if they bought high. Reporting both numbers educates the client on the value of disciplined investing: Client SIP example: • Fund CAGR over 5 years: 12% (the fund returned this from any starting point) • Client's XIRR: depends on when they invested and how much If client did monthly ₹10K SIP through a volatile period that ended at the same NAV: XIRR ≈ fund CAGR. If client lump-summed at NIFTY peak in 2018 vs SIP: lump-sum XIRR much lower than SIP XIRR despite same fund CAGR. If client started SIP in 2020 (during crash), XIRR is significantly higher than fund CAGR — they bought low. This is why "fund returned 12% over 5 years" isn't what most clients earned. Their behaviour determined their actual XIRR. Also: IRR has known issues with non-conventional cash flows (multiple sign changes can produce multiple IRRs); use NPV at required-return as the primary decision metric in those cases.

Regulatory references

CFA Institute reading on TVM, NPV, IRR
AMFI XIRR-based reporting in CAS
FPSB India syllabus on quantitative techniques

Common mistakes & pitfalls

Using arithmetic mean for compound returns — overstates actual experience.
Quoting fund CAGR to clients without explaining XIRR may be different.
Using NPV without specifying the discount rate.
Forgetting that IRR can have multiple solutions for non-conventional cash flows.
Confusing TWR (manager-neutral) with MWR (client-specific).

Frequently asked

Should I use arithmetic or geometric mean for fund returns?

Geometric mean (CAGR) for fund return reporting and long-term planning. Arithmetic mean only for next-period expected return calculations. Marketing materials sometimes use arithmetic to inflate apparent returns; use geometric in client conversations.

What's XIRR and how is it different from CAGR?

XIRR is the IRR for a series of cash flows (deposits and withdrawals) at irregular intervals. CAGR assumes a single deposit and a single withdrawal. For SIP investors, XIRR captures the actual investor experience; CAGR captures fund's buy-and-hold performance. They differ when there are multiple cash flows.

When should I use NPV vs IRR?

For accept/reject decisions, both work for conventional cash flows. For ranking projects (capital constrained), use NPV (higher NPV = more value). For comparing return rates across different scales, IRR is intuitive. Avoid IRR for non-conventional cash flows (multiple sign changes).

Practice questions

Click each question to reveal the answer and explanation.

Q 1

A fund's annual returns: 10%, −5%, 20%. The geometric mean is closest to:

(a)8.0%
(b)8.1%
(c)8.3%
(d)8.5%

Correct: (a) 8.0%

Geometric: [(1.10)(0.95)(1.20)]^(1/3) − 1 = (1.254)^(1/3) − 1 = 7.85% ≈ 8.0%. Arithmetic mean would be 8.33%, but geometric is the correct compounded experience.

Q 2

A ₹10K monthly SIP for 10 years at 12% yields a future value closest to:

(a)₹12 lakh
(b)₹16 lakh
(c)₹23 lakh
(d)₹30 lakh

Correct: (c) ₹23 lakh

FV = 10,000 × [(1.01)^120 − 1] / 0.01 = 10,000 × 230.04 = ₹23 lakh. Investment of ₹12 lakh becomes ~₹23 lakh.

Q 3

A project requires ₹1 cr investment, returns ₹30 lakh per year for 5 years. At 10% required return, the project NPV is closest to:

(a)Zero
(b)+ ₹13.7 lakh
(c)+ ₹50 lakh
(d)+ ₹75 lakh

Correct: (b) + ₹13.7 lakh

NPV = −1,00,00,000 + 30,00,000 × [1 − (1.10)^−5] / 0.10 = −1,00,00,000 + 30,00,000 × 3.7908 = +₹13.72 lakh. Accept.

Q 4

XIRR vs fund CAGR: when SIP investor went through a crash and recovery, XIRR is typically:

(a)Equal to CAGR
(b)Lower than CAGR
(c)Higher than CAGR (bought low through crash)
(d)Always negative

Correct: (c) Higher than CAGR (bought low through crash)

SIP through a crash buys cheap units; recovery prices these up. XIRR captures this favourable timing and exceeds buy-and-hold fund CAGR.

Q 5

A ₹50 lakh home loan at 9% annual for 20 years has EMI closest to:

(a)₹30,000
(b)₹45,000
(c)₹60,000
(d)₹75,000

Correct: (b) ₹45,000

EMI = 50,00,000 × 0.0075 × (1.0075)^240 / [(1.0075)^240 − 1] = ₹44,986 ≈ ₹45,000.

Q 6

Time-weighted return (TWR) is preferred over money-weighted return (XIRR) when:

(a)Reporting investor's actual experience
(b)Comparing fund manager performance neutral to cash-flow timing
(c)Computing tax liability
(d)Setting EMI schedules

Correct: (b) Comparing fund manager performance neutral to cash-flow timing

TWR is cash-flow-neutral, isolating manager skill from investor timing. XIRR captures investor's actual experience. Use TWR for fund comparison; XIRR for individual investor reporting.

Educational purposes only. The numbers, returns, and examples used in this lesson are illustrative. Past performance does not guarantee future results. Mutual fund and securities investments are subject to market risks. This lesson is not investment advice; for advice tailored to your circumstances, consult a SEBI-registered Investment Adviser. Read our full disclaimer.