NISM Series X-B · Chapter 6: Miscellaneous aspects of Retirement Planning
L1 · FoundationFoundation — The adviser's role, the impact of inflation, and calculating the corpus required
The eleven matters on which an adviser can advise, what he must understand before recommending anything, why inflation makes the corpus look frightening, the 50-60 per cent rule of thumb, and the three-scenario corpus table worked through the PV function with all five arguments explained.
22 min read · Worth 7% of the paper · Written from pages 121–135 of the official NISM workbook · Updated 18 September 2026
6.1 The adviser's role in retirement planning
And why it is not a job for an amateur:
The eleven matters on which an adviser can advise
Notice how many of these are about DISTRIBUTION rather than accumulation — withdrawal rates, guaranteed income, restructuring for tax, the mortgage, the reverse mortgage. The adviser's value is concentrated at the point where the corpus turns into income.
What must be understood before any recommendation
Four things to understand before recommending: TIME HORIZON, LEVEL OF EXPERIENCE, GOALS, and TOLERANCE FOR RISK — plus the need for guaranteed income and a full picture of assets, liabilities and current and future income.
6.2 Calculations for retirement planning
The Indian household problem
Inflation, restated with numbers
More than five times, on Rs 10,000 of monthly spending, over 25 years, at a rate nobody would call alarming.
Why the corpus looks frightening, and why it must
The 50-60 per cent rule of thumb
And the longevity caution:
The three-scenario corpus table
The assumptions: an individual aged 35, retiring at 60, with life expectancy till 85.
| Particular | Scenario 1 | Scenario 2 | Scenario 3 |
|---|---|---|---|
| Monthly income (given) | Rs 20,000 | Rs 30,000 | Rs 50,000 |
| Monthly expense | Rs 15,000 | Rs 25,000 | Rs 40,000 |
| Monthly expense for retirement (say 60%) | Rs 9,000 | Rs 15,000 | Rs 24,000 |
| Inflation rate p.a. | 7% | 7% | 7% |
| Years to retire (60 − 35) | 25 | 25 | 25 |
| Monthly expense AT retirement | 9,000 × (1.07)^25 = Rs 48,847 | 15,000 × (1.07)^25 = Rs 81,411 | 24,000 × (1.07)^25 = Rs 1,30,258 |
| Life expectancy | 85 | 85 | 85 |
| Years post retirement (85 − 60) | 25 | 25 | 25 |
| Post retirement inflation expected | 6% p.a. | 6% p.a. | 6% p.a. |
| Return on the retirement corpus | 8% p.a. | 8% p.a. | 8% p.a. |
| RETIREMENT CORPUS REQUIRED | Rs 1.17 crore | Rs 1.95 crore | Rs 3.11 crore |
Read the structure of the calculation carefully, because it recurs throughout the exam:
- Start with income, take the part actually spent, then take 50-60 per cent of that as the retirement requirement in today's money.
- Inflate it to the retirement date using the pre-retirement inflation rate and the years to retire.
- Then compute the present value at retirement of that monthly sum, for the years post retirement, discounted at the inflation-adjusted return.
Note that two different inflation rates are used — 7% before retirement and 6% after. The exam will not always be so kind, but the structure is what matters.
The PV function, argument by argument
| Argument | Meaning | Input in the example |
|---|---|---|
| rate (required) | The interest rate PER COMPOUNDING PERIOD. A loan with a 12% annual rate and monthly payments would have a monthly rate of 12%/12 or 1% | The INFLATION ADJUSTED RETURN on the corpus = {(1+8%)/(1+6%) − 1} = 1.89% p.a., which is equivalent to 1.89%/12 per month. Same in all scenarios |
| nper (required) | The number of PAYMENT PERIODS. A 3-year loan with monthly payments has 36 periods | Expected post retirement years is 25 years, i.e. 300 MONTHS (25 × 12). Same in all scenarios |
| pmt (required) | The fixed payment per period | Scenario 1: −Rs 48,847; Scenario 2: −Rs 81,411; Scenario 3: −Rs 1,30,258. SINCE THESE ARE CASH OUTFLOWS, i.e. EXPENSES, THE AMOUNTS ARE PREFIXED WITH A MINUS SIGN |
| fv (optional) | An investment's future value at the end of all payment periods. If there is no input for fv, Excel will assume the input is 0 | Left blank |
| type (optional) | Indicates when payments are issued. Only two inputs, 0 and 1. If OMITTED OR 0, payments are made at PERIOD END. If set to 1, payments are made at PERIOD BEGINNING | The payments are considered to be made at THE END of each period. Thus it is taken as 0, i.e. left blank |
Three things trip candidates here. The rate must be converted to the same period as nper — here monthly. The inflation-adjusted rate is a RATIO, {(1+8%)/(1+6%) − 1} = 1.89%, not a difference of 2%. And the pmt carries a MINUS SIGN because it is a cash outflow.
Think of it like this
Ten thousand rupees becomes fifty-four thousand
The whole case for retirement planning fits one line: if one is spending Rs 10,000 p.m. today, to sustain the current living standard he will require RS 54,724 P.M. AFTER 25 YEARS at an expected inflation of 7%. Add the risk of longevity — the increase in life expectancy — and the retirement years can be REALLY PAINFUL IF NOT PLANNED IN ADVANCE.
The comfortable thirty-five-year-old with nothing spare
The workbook describes a familiar household: people in their mid 30s earning handsomely, children in good school, own house, a respectable social life. And then the catch — many of these lifestyle assets are MORTGAGED with lenders and one is burdened with many EMIs. All these expenses bundled with high education cost LEAVE VERY LESS FOR RETIREMENT SAVINGS. The lifestyle that must be funded is the same lifestyle that prevents the funding.
Sixty per cent of what you spend, not what you earn
The rule of thumb is often misquoted. Expenses at retirement are ROUGHLY 50%-60% OF ONE'S EXISTING EXPENSES IF THERE ARE NOT ANY LIABILITIES — and in the workbook's table, someone earning Rs 20,000 spends Rs 15,000, of which 60 per cent is Rs 9,000. Apply the percentage to income instead of expenses and every figure that follows is wrong.
A ratio, not a subtraction
The discount rate in the PV calculation is the inflation adjusted return on the retirement corpus: {(1+8%)/(1+6%) − 1} = 1.89% p.a. — not 8 minus 6. And because nper is 300 MONTHS, the rate must become 1.89%/12 per month. Two conversions, both easy to forget, and each one throws the corpus out by lakhs.
The minus sign that is not a typo
In the PV formula the payment is entered as −Rs 48,847, and the workbook explains why: since these are CASH OUTFLOWS, i.e. EXPENSES, the amounts are prefixed with a MINUS SIGN. Excel needs to know which way the money is travelling. Leave it out and the answer comes back negative, which candidates then "correct" by ignoring the sign — and sometimes by mis-stating the whole calculation.
Two inflation rates in one table
The workbook's corpus table uses 7% p.a. before retirement to inflate today's expense to the retirement date, and 6% p.a. after retirement in computing the discount rate. Nothing requires them to be equal — the pre-retirement rate grows the target, while the post-retirement rate, paired with the 8% return, determines how hard the corpus has to work once it exists.
The adviser's value is at the exit, not the entrance
Look at the eleven matters an adviser can advise on: what withdrawal rate is appropriate, how much should be in guaranteed investments, how investments can be restructured to reduce taxable income in retirement, whether to pay off the mortgage, whether a reverse mortgage is a good option, whether to keep life insurance policies. Most concern the distribution stage. Anyone can start an SIP; converting a corpus into a lifetime income is where the expertise lies.
Four things before any recommendation
An investment adviser will NOT MAKE RECOMMENDATIONS until they understand the client's EXPECTED TIME HORIZON, their LEVEL OF EXPERIENCE WITH INVESTMENTS, their GOALS, and their TOLERANCE FOR INVESTMENT RISK — plus the need for guaranteed income and all the current resources such as assets, liabilities, and current and future sources of income. It is the suitability principle of Chapter 18 of Level 1, applied to retirement.
Key terms in this chapter
- Accumulation stage
- The working years in which the retirement corpus is being built up. Growth-oriented investments belong here because the horizon is long and risk appetite is higher.
- All Citizen Model (NPS)
- The NPS model open to any Indian citizen in the eligible age band, in which the entire contribution is made by the subscriber alone. A subscriber whose new employer is not registered can continue the PRAN under this model.
- Capital protection (income-product factor)
- Alongside income, the capital itself must be protected; a product that generates income but lets the capital fluctuate is not viable for this objective.
- Charitable giving plan
- A structured plan through which an adviser helps a client express their social or environmental values with their money, once the retirement objectives are secure.
- Cost (evaluation factor)
- A major factor in any long-term product, because more cost means less earning and so less accumulation; in some products the total cost may not even be clear.
- Cost of delay
- The manifold increase in the monthly saving required when the start of investing is postponed. For Rs 1.18 crore at 12 per cent, starting at 30, 35 and 40 requires Rs 3,376, Rs 6,280 and Rs 11,928 a month.
- Distribution stage
- The retired years in which the corpus is drawn down to meet living expenses. Income generation and capital protection replace growth as the main objectives.
- EPF transfer on job change
- Moving the old employer's provident fund balance to the new employer's account instead of withdrawing it, which avoids any tax incidence and adds the old service period to total service.
- Five-year service test (EPF)
- If an employee changes employer in less than five years and withdraws the old EPF balance, the withdrawal becomes taxable; a transfer avoids this entirely.
- Following up (philanthropy step)
- The third step, in which the adviser returns to the client with resources and next steps, because philanthropy easily falls to the bottom of a busy person's to-do list.
- fv (function argument)
- Future value: the cash balance you wish to have after the last payment is made. If omitted it is assumed to be zero. The retirement corpus is entered here in a PMT calculation.
- Growth basket
- The portion of the retirement corpus kept invested for growth after retiring, with a horizon of 10 to 15 years, judged on the same four factors as pre-retirement but using products such as PPF and certain mutual fund categories rather than EPF or NPS.
- Inflation (income-product factor)
- The income generated in retirement must beat inflation to sustain longevity risk — how much income is produced for life and how it keeps pace with prices are both evaluated.
- Life-stage evaluation
- Judging a retirement benefit product against the objectives of the stage the investor is in — pre-retirement, retirement, or post retirement beyond 75 — rather than on returns alone.
- Liquidity event
- A moment at which a client comes into substantial liquid money, such as the sale of a business or an inheritance — one of the four natural triggers for a philanthropy conversation.
- Longevity risk
- The risk of outliving the retirement corpus. It is why the income requirement in retirement has no fixed time horizon and why the income must beat inflation.
- Multiple EPF accounts
- The result of opening a fresh EPF account at each job change without transferring; it causes operational issues, a cascading tax effect on older balances if conditions are not met, and lost compounding.
- nper (function argument)
- The total number of payment periods. For monthly workings the number of years is multiplied by 12 — 20 years becomes 240.
- Permanent Retirement Account Number (PRAN)
- The unique NPS account number generated for a subscriber. Because one cannot have multiple NPS accounts, the same PRAN moves with the subscriber from employer to employer.
- Philanthropy
- Voluntary giving of money or effort for the good of society. The chapter notes that in India it is no longer confined to the rich — individuals with any level of income are contributing within their capacity.
- PMT function
- The Excel function =PMT(rate, nper, pv, [fv], [type]) that tells you the periodic saving needed to reach a known future corpus. The corpus goes into fv and pv is left blank.
- Postponing retirement
- Continuing to work beyond the intended retirement age because the corpus is inadequate — one of the two remedies the chapter names, the other being to reduce lifestyle.
- Post Retirement stage
- The later years of life, beyond 75, where the objective shifts completely to income, capital protection is primary, returns are low and risk least, and liquidity matters because money is to be left for heirs.
- Pre-retirement stage
- The stage 15 to 20 years before retirement, where the objective is accumulation, risk appetite is higher, and products are judged on cost, return, risk and tax efficiency.
- Pre-retirement withdrawal
- Taking money out of a retirement fund such as EPF long before retirement, commonly for education, marriage, medical needs or a house, which permanently reduces the corpus.
- PV function
- The Excel function =PV(rate, nper, pmt, [fv], [type]) that tells you the corpus needed today to support a known stream of future withdrawals. The corpus is the answer, so fv is left blank.
- pv (function argument)
- Present value: the total amount that all future payments are worth now; in a loan, simply the amount borrowed. Left blank in a PMT calculation that starts from zero.
- rate (function argument)
- The constant interest rate per period. For monthly workings the annual rate is divided by 12 — 10 per cent a year becomes 10%/12 or 0.00833 a month.
- Retirement stage
- The stage on retiring, needing two baskets of products — one generating steady income for a lifetime, one growing the corpus over a 10 to 15 year horizon.
- Return (evaluation factor)
- The product must generate returns that beat inflation and grow money, since the focus in the accumulation phase is growth and ample time is available.
- Risk (evaluation factor)
- Products offering higher returns carry risk factors; understanding them is essential to ensure the product aligns with the investor's risk tolerance.
- Step-up SIP
- A mutual fund facility that automatically increases the SIP instalment after a specified period, for example Rs 5,000 in 2023 and Rs 5,000 plus 10 per cent in 2024.
- Step-up strategy
- Starting with a lower contribution and raising it by a fixed percentage every year, so that savings rise with income instead of being postponed until income rises.
- Tax efficiency (evaluation factor)
- Because taxation has a large impact over long periods and different products are treated differently under income tax provisions, products where the tax impact can be reduced are preferred for retirement.
- type (function argument)
- Specifies when payments fall due — 0 or omitted means at the end of each period, 1 means at the beginning.
- Universal Account Number (UAN)
- A 12-digit unique number allotted to each employee contributing to EPF, which stays the same for life however many organisations the employee joins, and makes online transfer of the EPF account possible.
- Voluntary Provident Fund (VPF)
- Extra contribution an employee may make to the provident fund beyond the statutory rate; suggested in the chapter for those aged 50 and above who wish to boost retirement savings, because returns are tax exempted.
Check you have understood it
The L1 test for this chapter has 8 questions. Score 60% to unlock L2 Application (worked numericals and scenarios) and then L3 Exam-Ready (NISM-style traps, timed, with this paper's real marking). Tests, the higher levels and full mock exams need a free account so we can track your progress.
Create a free accountOriginal explanatory writing based on the official NISM workbook for Series X-B, which is published and copyrighted by NISM. Check figures against the current edition at nism.ac.in.