Case 094Client portfolios and goal planningCore
A Rs 50 lakh portfolio started at 60/40 equity-debt; after equity rose 60% and debt 7% over two years it sits near 69/31, outside a 5-point band. How much must move, and how can a Rs 60,000 monthly SIP do the work with minimal tax?
1The situation
Tanvi Mahajan, 38, invested Rs 50 lakh two years ago at 60% equity and 40% debt, with a rule that either side may drift 5 points from target before she rebalances. Since then her equity funds have risen 60% to Rs 48 lakh and her debt funds 7% to Rs 21.4 lakh, so equity is 69.2% of Rs 69.4 lakh. She also runs a Rs 60,000 monthly SIP, currently split 60/40 like the portfolio.
All her equity units are more than a year old. For the tax arithmetic assume long-term gains on equity funds above an annual exemption of Rs 1.25 lakh are taxed at 12.5%, and confirm the current rates and exemption before advising; assume no exit loads. For the projections assume markets stay flat.
2Your task
How far is she outside her band, how much must move to get back to target, and how would you use the SIP to do most of it with the least tax?
Quick check
How much equity must be sold to get straight back to 60%?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
She is 4.2 points outside the band; Rs 6.4 lakh must move from equity to debt to reach 60%, and the SIP can do most of it. Selling it all at once realises about Rs 2.38 lakh of gains and about Rs 14,187 of tax on the assumed rules. Redirecting the whole SIP to debt gets her inside the band in 8 months and to target in 18, with no sale. Best: sell Rs 2.9 lakh now, within the exemption, to re-enter the band, then let the SIP finish the job in about 10 months.
Step 1How far has the portfolio drifted, and why does it matter?
Equity grew faster, so it is now a bigger share of her money than she chose. A household that budgeted a third of its spending on eating out and finds it has crept to half has not decided anything; it has drifted. Equity is 69.2% of Rs 69.4 lakh against a 60% target, 4.2 points past the 65% edge of her band. The band exists so that she does not trade on every wobble, and the breach is the signal that the portfolio now carries about 15% more equity risk than she signed up for: a 30% equity fall would cost her Rs 14.4 lakh today against Rs 12.5 lakh at target.
Step 2How much must move, and what would selling cost?
Target equity is 60% of Rs 69.4 lakh, Rs 41.64 lakh. Rs 6.36 lakh must move from equity to debt to reach target, and Rs 2.89 lakh just to get back to the 65% edge of the band. Selling triggers tax. Her equity has a cost of Rs 30 lakh against a value of Rs 48 lakh, so 37.5% of anything she sells is gain. A Rs 6.36 lakh sale realises about Rs 2.38 lakh of gain; after an assumed Rs 1.25 lakh exemption, 12.5% on the rest is about Rs 14,187. Modest, but avoidable. A Rs 2.89 lakh sale realises only about Rs 1.08 lakh, inside the exemption, so it costs nothing in tax.
Step 3How can the SIP do the work?
Redirect it. New money changes the weights without selling anything, so there is no gain to tax. If the entire Rs 60,000 goes to debt and markets stay flat, equity falls to 65% of the portfolio after 8 months and to 60% after 18 months. That is slow: for most of a year and a half she carries more equity than her rule allows, and if equity keeps rising, the SIP alone never catches up. The honest trade is between tax saved and time spent outside the band.
| Route | Equity sold now, Rs lakh | Tax on assumed rules | Back in band | At 60% |
|---|---|---|---|---|
| Sell to target at once | 6.36 | Rs 14,187 | Today | Today |
| SIP to debt only | 0 | Nil | Month 8 | Month 18 |
| Sell to band edge, then SIP to debt | 2.89 | Nil, inside the exemption | Today | Month 10 |
Step 4What would you recommend?
The mixed route. Sell Rs 2.9 lakh of equity now, which realises about Rs 1.08 lakh of gain and sits inside the Rs 1.25 lakh exemption, move it to debt, and switch the full SIP to debt until equity reaches 60%, about 10 months. Then restore the 60/40 SIP split. Use the exemption every year: a sale sized to Rs 1.25 lakh of gain each financial year keeps the band honest at no tax cost. The limits: the projections assume flat markets, a rally would lengthen the months and a fall would shorten them; the SIP buys debt at today's yields, which is fine for a rebalancing step but should not override her goal timeline; and the rates and exemption are assumptions to confirm.
Where candidates lose it
Candidates compute the drift on the original Rs 50 lakh and say Rs 4.6 lakh must move. The weights are measured on today's Rs 69.4 lakh, and the move is Rs 6.4 lakh.
The second miss is treating the choice as all or nothing: sell everything at once and pay tax, or wait for the SIP and sit outside the band for a year and a half. The exemption lets her do the urgent part today for free and the rest with new money.
What the interviewer asks next
- Equity keeps rising 1.5% a month. Does the SIP route ever reach 60%?
- She also holds Rs 8 lakh of equity units bought eight months ago. How does that change the sale you would recommend?
- Why might you set a wider band for equity than for debt?
- How would you explain to her why selling the winner is the right thing to do?
Company names and figures are illustrative.
