AW
Apex Private Wealth Advisory
Institutional Retirement Cashflow & FY 26-27 Tax Stress Audit
AMFI ARN-128450 | SEBI RIA
Prepared by: Vikram Mehta, CFP®
+91 98200 XXXXX • advisory@apexwealth.in

Institutional SIP + SWP Wealth Engine

🏛 White-Label Advisor / MFD / CA Report Branding Studio Stamps your firm's letterhead on top of the dashboard & printed client PDF reports.
Primary Drivers Secondary / Fine-Tune Auto-Calc
Personal Profile
Year 1 corresponds to Age 33 (Current Age).
1. Equity Bucket
Runs from Yr 1 (Age 33) till Yr 25 (Age 57).
Empirical Return Path & Volatility Mode ❓ How Volatility Works
4 Return Simulation Modes Explained:
• 1. Flat Deterministic CAGR (Default): Compounds smoothly every year at your entered Pre/Post Return % (use Card 4 for manual Crash Stress).
• 2. Historical Indian Pattern (Scaled to Your CAGR): Replays the real Indian bull/bear sequence (Sensex 44-Yr, Flexi Cap 29-Yr, Midcap 21-Yr, Smallcap 20-Yr) scaled so the compounded CAGR matches your entered Return % to the exact decimal!
• 3. Actual Historical Indian Returns (Unscaled 1980–2023): Replays the 100% raw, untouched historical calendar-year returns exactly as they happened in India across every rolling start year!
• 4. Stochastic Regime Path (Scaled to Your CAGR): Generates 200 realistic non-linear paths (~3 in 4 positive yrs, ~1 in 4 negative yrs + post-crash rebounds) matching your exact entered CAGR!
2. Debt / FD Safety Bucket
Runs from Yr 1 (Age 33) till Yr 25 (Age 57).
3. Retirement SWP & Guardrails
SWP starts in Year 26 (Age 58).
Extra / Pension / Rental Income Offset
Evaluates target wealth at Year 53 (Age 85).
❓ Explain Cut/Floor
How Adaptive Dynamic Guardrails Work:
• Init WR: Locked in your 1st SWP Year (Annual Net SWP ÷ Opening Portfolio).
• ▼ Cut (Danger Trigger): If a crash pushes your live Withdrawal Rate above Init WR × (1 + Danger %), the engine applies your Belt-Tightening Action (e.g., skips inflation + trims SWP by 10%).
• 🛡 Floor (Min Real Lifestyle Floor %): Guarantees your spending is never cut below e.g. 75% of your baseline inflation-adjusted lifestyle.
• 🔄 Restored (Auto-Restore): As soon as the market recovers and live WR heals below the Danger Trigger, SWP automatically steps back up toward your 100% baseline lifestyle!
• ▲ Boost (Prosperity Trigger): If live WR drops below Init WR × (1 - Prosperity %), gives a bonus raise up to your Ceiling %.
4. Glide Path, Tax (FY 26-27) & Stress Test
Indian Taxation Rules (FY 2026-27) ❓ Tax Without NAV?
How FIFO Tax Is Calculated Without Entering Real NAV:
Capital gains tax depends strictly on Percentage Gain Ratio (Sell NAV - Buy NAV) ÷ Sell NAV, never on the absolute NAV price. Initializing a standardized ₹10.00 base NAV and compounding it monthly issues exact CAMS/KFintech unit lots (Units = SIP ÷ Current NAV).
• 12-Mo SIP Trap: Every monthly SIP is a separate lot! If you run a ₹4,000 SIP for 12 months and withdraw all in Month 13, only Lot #1 (held 12 mos) is LTCG (₹0 tax under ₹1.25L limit); Lots #2–#12 (held 1–11 mos) are taxed at 20% STCG!
Market Crash & Bear Sequence Stress ❓ 4 Recovery Modes
4 Post-Crash Recovery Shapes (₹100 Portfolio, 12% Return, 25% 1-Yr Drop to ₹75, 2-Yr Recovery):
• 1. Peak Recovery: Climbs from ₹75 back to ₹100 over the 2 recovery yrs (loses 3 yrs of time, then resumes 12%/yr).
• 2. Bear-Only Loss: Heals the 25% drop plus earns normal 12%/yr during the 2 recovery yrs (reaches ₹125.44; only lost 1 bear yr of growth).
• 3. Full Trendline Catch-Up: V-shape surge to ₹140.49 (catches right back up to the un-crashed baseline; 0 growth lost).
• 4. L-Shape Permanent Shift: No rebound boost; grows at normal 12%/yr from ₹75 forever.
• Multi-Crash Occurrences + Calm Gap: Choose 2x, 3x, or 4x crashes and set Calm Normal Yrs Between Crashes (e.g. 5 yrs of normal compounding after recovery finishes before the next crash starts).
No crash active (enter Crash Year & Drop % below).
Standby: Enter Crash Year & Drop % above (or enter Drop % and click Scan).
5. One-Time Goals & Milestones
Goal occurs in Yr 15, Mo 6 (Age 47).
📋 Advisor Executive Summary & Strategy Diagnosis
    1. Portfolio Longevity & Stress
    Enter Inputs
    Awaiting Plan Data
    Target Yr 53: ₹0
    Market Crash Stress Test
    No Crash Active
    Enter Crash Yr & Drop % in Card 4
    2. Closing Corpus in Target Yr 53
    At Age 85 (Year 53)
    0.00 Cr
    Nominal: ₹ 0
    In Today's Purchasing Power
    0.00 Cr
    ₹ 0
    Discounted at inflation
    3. Pre-SWP Corpus (End Yr 25)
    At Age 57 (End Yr 25)
    0.00 Cr
    Equity: 0.00 Cr | Debt: 0.00 Cr
    In Today's Purchasing Power
    0.00 Cr
    Equity: 0.00 Cr | Debt: 0.00 Cr
    Discounted at pre-retire inflation
    Institutional Fragility & Resilience Scorecard (40 / 25 / 20 / 15 Audit) ❓ How Scoring Works
    4-Pillar Institutional Scoring (100 Points Total):
    • 1. Baseline Post-SWP Longevity (40 Pts): Measures how many Post-SWP Years your money sustains after retirement begins (45+ yrs = 40 pts; 35 yrs = 32 pts; 25 yrs = 21 pts).
    • 2. Sequence-of-Returns Crash Immunity (25 Pts): Measures Post-SWP Years sustained under your active Market Crash (or a automatic 25% Retirement-Start Benchmark Crash if Card 4 is blank).
    • 3. Debt Safety Shield & Cushion (20 Pts): Evaluates Debt-First order & years of initial Net SWP covered by Debt at retirement.
    • 4. Milestone Liquidity Load (15 Pts): Evaluates whether one-time goals drain excessive capital (drops to 0/15 if any Goal suffers an unpaid shortfall).
    • Anti-Anomaly Rule: Any plan sustaining < 25 Post-SWP Years is hard-capped at 59 / 100 (BBB), while plans sustaining 35+ Post-SWP Years receive a Surplus Solvency Floor on Pillars 3 & 4 so a 40-year plan always outscores a 25-year plan!
    0 / 100
    Awaiting Inputs
    Enter Lumpsum, SIP & SWP to Evaluate
    Fill in the primary inputs or click 'Sample Preset' in the top bar.
    1. Baseline Post-SWP Longevity (Yrs Sustained)0 / 40
    Waiting for plan inputs...
    2. Sequence-of-Returns (Crash) Immunity0 / 25
    Waiting for plan inputs...
    3. Debt Safety Shield & Cushion0 / 20
    Waiting for plan inputs...
    4. Milestone Liquidity Load0 / 15
    Waiting for plan inputs...
    5×5 Inflation vs. Post-Retire Return Survival Sensitivity Matrix
    Center Cell (★): 0% Post-Retire Equity Return & 0% Inflation. Top Line shows the exact Age/Year money lasts till; Bottom Pill shows Post-SWP Years Sustained & Target Yr 53 corpus.
    Invested vs. Returns & SWP Split
    101-Year Corpus Trajectory (₹ Crores)
    Chronological Cashflow, Tax & Balance Schedule (Hover on 'Total Tax ⓘ' for Breakdown)
    MoYrAgeOpen EqOpen Debt SIP EqSIP DebtNet SWP (Nom)SWP (Today's Val)Goal / Manual Eq Int.Debt Int.Glide ShiftTotal Tax ⓘ Eq ClosedDebt ClosedTotal Closed

    📖 Welcome to the Institutional SIP + SWP Wealth Engine — Complete User Guide & Mathematical Reference

    How to Think About This Tool (The "Two Water Tanks" Analogy): Imagine your life savings as two connected water tanks. Tank 1 (The Equity Bucket) is your high-growth engine invested in stock market mutual funds/index funds — over 10–30 years it compounds rapidly, though in bear markets it can temporarily dip 20%–40%. Tank 2 (The Debt / FD Safety Bucket) is your safe shock-absorber invested in Debt Mutual Funds or Fixed Deposits — it grows steadily and shields you from ever having to sell your Equity units at crashed prices during retirement!

    🎨 1. Color-Coded Inputs, Live Rupee Words & Running Age

    • Soft Yellow Boxes (Primary Drivers): These are the core inputs. Fill just these yellow boxes to get an instant, accurate 101-year projection!
    • Aqua-Sky Blue Boxes (Secondary / Fine-Tuning): Optional advanced levers (SIP pauses, pension offsets, glide path, taxes, empirical volatility, and market crashes). Leave them blank if you don't need them yet.
    • Lavender Dashed Boxes (Auto-Calculated): Computed automatically by the engine.
    • Live Rupee Word Readout: As you type in any money box (including Goal Today's Value vs. Future Nominal), a live readout below it displays = ₹10.00 Lakh or = ₹1.50 Crore so you never miscount zeros.
    • Running Age Convention: Year 1 corresponds to your Current Age (e.g., Age 33). If you run SIPs from Year 1 to Year 25, your pre-retirement phase finishes at the end of Year 25 (Age 57), and your Retirement SWP starts on Day 1 of Year 26 (Age 58).

    📈 2. True Annual CAGR vs. Standard Calculators & 3 Goal Solvers

    • Why Our Math Is More Accurate Than Standard Online Calculators: Mutual fund returns in India are quoted in Effective Annual CAGR (an 8% return means ₹100 grows to exactly ₹108.00 in 12 months, using (1 + R)^(1/12) - 1 = 0.6434%/mo) and retirees withdraw living expenses on Day 1 of each month. Many standard retail online calculators and basic spreadsheet functions use nominal R ÷ 12 = 0.6667%/mo (which secretly inflates an 8% return into 8.30%/yr) and deduct SWP on Day 30 — overstating 10-year balances by ₹1–3 Lakhs!
    • 3 Instant Goal Solvers (⚡ Solve SIP, ⚡ Solve Lumpsum & ⚡ Solve Max SWP): Click Solve SIP or Solve Lumpsum in Card 1 to find the exact investment needed for a target lifestyle, or click Solve Max SWP in Card 3 to find the maximum sustainable monthly withdrawal through your Target Year (automatically displaying both Today's Purchasing Power and 1st-Year Future Nominal SWP)!

    📊 3. Card 1 Deep-Dive: Empirical Indian Equity Volatility Engine (4 Return Modes)

    • Why Real Markets Don't Move in a Straight Line: Over 44+ years of Indian equity history across Large Cap, Flexi Cap, Mid Cap, and Small Cap segments, calendar year returns are non-linear: roughly 3 out of 4 years (~75%–79%) end positive and ~21%–25% end negative, consecutive negative calendar streaks never exceed 2 years, and severe bear drops are followed by strong elastic rebounds.
    • 4 Return Simulation Modes to Stress-Test Your Plan:
      • 1. Flat Deterministic CAGR (Default): Smooth compounding every year at your entered Pre/Post Return % (use Card 4 for manual/scanned Crash Stress).
      • 2. Historical Indian Pattern (Scaled to Your CAGR): Replays the real Indian bull/bear sequence (Large Cap 44-Yr, Flexi Cap 29-Yr, Mid Cap 21-Yr, or Small Cap 20-Yr) scaled so the compounded geometric CAGR over your Pre-SWP and Post-SWP phases matches your entered Return % to the exact decimal.
      • 3. Actual Historical Indian Returns (Unscaled 1980–2023): Replays the 100% raw, unedited Indian calendar-year returns exactly as they occurred in history! Clicking the Scan button tests all historical starting years (e.g. starting in 1980 vs. 1992 vs. 2000 vs. 2008) to find the Worst, Median, and Best historical starting cohort.
      • 4. Stochastic Regime Path (Scaled to Your CAGR): Generates 200 synthetic volatile paths obeying Indian market laws while locking in your exact entered CAGR, and scans all 200 paths to find the Worst (0th Percentile), Median (50th Percentile), and Best (100th Percentile) sequence!

    🛡 4. Card 3 Deep-Dive: SWP Order, Two-Stage Inflation & Adaptive Dynamic Guardrails

    • SWP Withdrawal Order: Debt First (Safety Shield) spends your safe Debt bucket first so Equity compounds undisturbed. Once Debt reaches ₹0, it automatically falls back to Equity.
    • Monthly SWP (Today's Value ₹) & Two-Stage Inflation: Enter your monthly retirement lifestyle need in today's purchasing power (e.g., ₹50,000/mo today). The engine inflates it up to your retirement year using Pre-Retire Inflation %, and steps it up annually thereafter using Post-Retire Inflation % + Extra SWP Step-Up %.
    • Adaptive Dynamic Guardrails (Guyton-Klinger Institutional Rules Explained Step-by-Step):
      • 1. Locking Initial Withdrawal Rate (Init WR): On Day 1 of your first SWP year, the engine calculates Init WR = First Year Annual Net SWP ÷ Opening Portfolio. (Example: ₹20 Lakh annual SWP on a ₹4 Crore portfolio locks Init WR = 5.00%).
      • 2. ▼ Cut — Danger Trigger (e.g. +20% above Init WR = 6.00%): In future years, if a bear market shrinks your portfolio so that your planned SWP exceeds 6.00% of your remaining corpus, the guardrail triggers a belt-tightening action: Skip Inflation + Cut SWP % (freezes last year's SWP and trims it by 10%), Freeze SWP Only (skips inflation), or Apply Inflation then Cut %.
      • 3. 🛡 Floor — Min Real Lifestyle Floor (e.g. 75%): Your safety net. Even during a severe multi-year depression, the guardrail will never reduce your spending below 75% of your target inflation-adjusted purchasing power.
      • 4. 🔄 Restored — Auto-Restore When WR Heals: As soon as the market recovers and your live Withdrawal Rate drops back below the 6.00% Danger Trigger, the engine automatically raises your monthly SWP back up toward your original 100% baseline lifestyle!
      • 5. ▲ Boost — Prosperity Bonus Raise (e.g. -20% below Init WR = 4.00%): If a strong bull market grows your corpus so large that your live WR falls below 4.00%, the engine rewards you with a +10% bonus raise (capped at your Max Real Lifestyle Ceiling %, e.g. 130%).

    ⚖ 5. Card 4 Deep-Dive: Dual Glide Path Modes & How FIFO Tax Works Without Entering Real NAV

    • Pre-SWP Glide Modes — Gradual Step-Down vs. Discounted One-Time Shift:
      • SWP Cushion (Gradual Step-Down Over N Yrs): Shifts ~1/Nth of your target Debt cushion each year over the N years before retirement, utilizing N separate ₹1.25L annual LTCG tax-free exemptions while keeping remaining funds compounding in Equity longer.
      • SWP Cushion (One-Time Shift N Yrs Early): Shifts your target retirement Debt cushion in one single transfer N years before SWP starts, discounted by your net Debt compounding rate over the remaining pre-SWP years so it compounds in Debt to land on your exact target cushion at retirement! (Planning Note: Shifting money from higher-return Equity into lower-return Debt acts as crash insurance to protect early retirement withdrawals during bear markets, though in smooth bull markets it may reduce total returns.)
    • Post-SWP Refill Cadence & 12-Month Tax-Harvesting Reserve Protection: Choose between Every N Yrs (When Cushion Empties) or Annual Rolling Top-Up. When Auto-Harvest ₹1.25L Tax-Free Equity Gain Yearly is ticked, the engine automatically leaves enough seasoned LTCG units untouched at the front of the FIFO queue to cover your upcoming 12 months of SWP and One-Time Goals so harvesting never triggers 20% STCG on next year's withdrawals!

    Why Withdrawing a 12-Month ₹4,000/mo SIP in Month 13 Triggers Both LTCG & STCG (16% Annual Return):

    SIP LotMonth InvestedMonths Held at Mo 13Principal (₹) Value at Mo 13 (₹)Capital Gain (₹)Tax CategoryFY 26-27 Tax (₹)
    Lot #1Month 112 Mos (≥12m)4,000.004,640.00640.00LTCG (12.5%)0.00 (₹1.25L Exempt)
    Lot #2Month 211 Mos (<12m)4,000.004,582.97582.97STCG (20%)116.59
    Lots #3–#11Months 3–1110 down to 2 Mos36,000.0038,792.982,792.98STCG (20%)558.60
    Lot #12Month 121 Mo (<12m)4,000.004,049.7849.78STCG (20%)9.96
    TOTAL12 LotsWithdrawn Mo 1348,000.0052,065.734,065.731 LTCG + 11 STCG₹685.15 (Net: ₹51,381)

    🔍 6. Crash Recovery Modes, Multi-Crash Occurrences & Scanner

    Suppose your portfolio is at ₹100, normal return is 12%/yr, and a 25% Crash hits over 1 Year (dropping it to ₹75), followed by a 2-Year Recovery:

    • 1. Peak Recovery: Climbs from ₹75 back to ₹100 over the 2 recovery years. You lost 3 years of time, then normal 12%/yr resumes.
    • 2. Bear-Only Loss: Heals the 25% drop plus earns normal 12%/yr during the 2 recovery years — reaching ₹125.44.
    • 3. Full Trendline Catch-Up: V-shaped rebound to ₹140.49, catching right back up to the un-crashed baseline line.
    • 4. L-Shape Permanent Shift: No rebound boost; grows at normal 12%/yr from ₹75 forever.
    • Crash Occurrences + Scanner: Test 1x, 2x, 3x, or 4x crashes separated by Calm Normal Years. Clicking Scan for Deadliest Crash Window automatically tests every possible crash start month to find the exact timing that depletes your portfolio earliest or triggers the deepest lifestyle cut!

    🏆 7. 3-View Donut, 7-Metric Cumulative Bar & 4-Pillar Scorecard

    • 3-View Donut Chart: Switch between 1. Pre-SWP Retirement (Principal vs. Retained Returns), 2. Target Yr With SWP & Tax (Remaining Corpus vs. Total Withdrawn vs. Total Tax — shows 0% Depleted if money ran out), and 3. Target Yr Pure Compounding (hypothetical uninterrupted compounding with withdrawals and glide shifts excluded).
    • 7-Metric Pinned Cumulative Bar: Displays cumulative Principal Put In, Equity Growth Earned, Debt Growth Earned, Net SWP Paid, Goals Paid, Taxes Paid, and Closing Corpus for both your Target Year and full 101-Year horizon.
    • 4-Pillar Fragility Scorecard (40 / 25 / 20 / 15): Grades your plan on Baseline Post-SWP Years Sustained (40 pts), Crash Immunity Post-SWP Years (25 pts), Debt Shield (20 pts), and Milestone Load (15 pts).