Investment Guide - Lakshmi Personal Finance Assistant

Overview

Comprehensive guide for tracking, analyzing, and monitoring Indian investments. Focus on accurate position tracking, returns calculation, and portfolio performance monitoring for equity, debt, gold, and retirement accounts.

Demat Account Statement Reading (CDSL/NSDL CAS Format)

Consolidated Account Statement (CAS)

The CAS is issued monthly/quarterly by CDSL or NSDL and shows all holdings in one statement:

Key Information to Extract

• Demat Account Number: Shows in statement header (8 digit/alphanumeric)
• Statement Date: Month/Quarter of statement
• ISIN Code: International Securities Identification Number (12 character)
• Security Name: Name of stock or security
• Quantity: Number of shares held
• Holdings Date: Date holdings updated
• Market Value: Current market value (calculated from price)
• Pledge Status: If shares pledged as collateral

Interpreting CAS Holdings

Example format:

ISIN: INE002A01018 (TCS)
Quantity: 100 shares
Market Value: ₹46,50,000 (@ ₹46,500 per share)
Pledge: None

CAS Processing Steps

1. Download latest CAS from DP (Depository Participant)
   • HDFC Bank DP, ICICI Direct, Zerodha, etc.
2. Extract each ISIN code
3. Identify security name and quantity
4. Match with buy prices for cost basis
5. Calculate current market value
6. Compute gain/loss per holding
7. Update portfolio tracker

Mutual Fund Statement Reading (CAMS/KFintech)

Statement Types

Mutual funds processed through two main registers:

• CAMS: HDFC Mutual Fund, IDFC Mutual Fund, SBI MF, Kotak MF, etc.
• KFintech: ICICI Prudential, Axis Mutual Fund, Franklin Templeton, etc.

Key MF Information

• Fund Name: Name of mutual fund scheme
• Folio Number: Account number with fund house
• Scheme Type: Growth, Dividend, IDCW (Income Distribution Cum Capital Withdrawal)
• ISIN Code: Fund's ISIN
• Units Held: Number of units in fund
• NAV (Net Asset Value): Current price per unit
• Current Value: Units × NAV = Current market value
• Investment Amount: Total amount invested
• Date of Valuation: As on which date

SIP vs Lump Sum Tracking

Lump Sum Investments:

• Single large purchase
• Record: Date, Amount, NAV, Units purchased
• Track against purchase NAV

SIP (Systematic Investment Plan):

• Monthly/Quarterly investments
• Each investment at different NAV
• Track: Date, Amount, NAV, Units each month
• Calculate average cost basis

MF Statement Example

Folio: 12345678
Fund: HDFC Growth Fund
Units: 500.50 units
NAV: ₹850 per unit
Current Value: ₹4,25,425
Total Investment: ₹3,50,000
Gain: ₹75,425 (21.55%)

Stock Portfolio Tracking

Buy Price vs Current Price

Record for each stock:

• ISIN/Symbol: TCS, Infosys, HUL, etc.
• Quantity: Number of shares
• Buy Date: Date of purchase
• Buy Price: Price at which purchased
• Cost Basis: Buy Price × Quantity
• Current Price: Latest market price
• Current Value: Current Price × Quantity
• Gain/Loss: Current Value - Cost Basis
• Gain % Return: (Current Value / Cost Basis - 1) × 100

Example Portfolio Entry

Stock: TCS (Tata Consultancy Services)
Quantity: 50 shares
Buy Date: 15-Jun-2023
Buy Price: ₹3,200/share
Cost Basis: ₹1,60,000
Current Price: ₹3,650/share
Current Value: ₹1,82,500
Gain: ₹22,500 (14.06% return)

XIRR (Extended Internal Rate of Return)

What is XIRR?

XIRR calculates annualized return accounting for:

• Amount invested
• Date of investment
• Timing of flows
• Current value or exit value

XIRR Calculation (Excel Formula)

Use =XIRR(values_range, dates_range) where:

• values_range: Include all cash flows as negative (investments) and positive (exits/current value)
• dates_range: Corresponding dates for each flow

Example XIRR Calculation

Date          | Amount (₹) | Flow Type
15-Jun-2023   | -1,60,000  | Investment
01-Jan-2024   | -1,20,000  | Additional investment
28-Mar-2026   | +1,82,500  | Current value

XIRR Result: 8.75% annualized

Interpreting XIRR

• XIRR 0-5%: Low return (maybe bank FD rate)
• XIRR 5-12%: Moderate return (reasonable equity)
• XIRR 12%+: Good return (strong performance)
• XIRR Negative: Losses (depreciation)

Asset Allocation Monitoring

Asset Classes to Track

1. Equity: Stocks, Equity MF, ETF
2. Debt: Bonds, Debt MF, Fixed Deposits, Debentures
3. Gold: Physical gold, Gold ETF, Gold MF
4. Cash Equivalents: Savings account, Liquid funds
5. Real Estate: Property value (if tracked)
6. Retirement: PPF, NPS, EPF
7. Insurance: Insurance-linked investments

Target Asset Allocation (Sample Portfolios)

Conservative (Age 50+, Risk Averse)

• Equity: 30%
• Debt: 40%
• Gold: 10%
• Real Estate: 10%
• Cash: 10%

Balanced (Age 30-50)

• Equity: 50%
• Debt: 25%
• Gold: 10%
• Real Estate: 10%
• Cash: 5%

Aggressive (Age <30)

• Equity: 70%
• Debt: 15%
• Gold: 5%
• Real Estate: 5%
• Cash: 5%

Current vs Target Monitoring

Track quarterly:

• Current allocation percentages
• Variance from target (e.g., Equity 55% vs 50% target)
• Rebalancing required if variance > 5%
• Monitor when to rebalance (usually quarterly or semi-annual)

SIP Tracking

SIP Details to Record

• Fund Name: Which MF scheme
• SIP Amount: Monthly/quarterly contribution
• SIP Start Date: When SIP commenced
• SIP Frequency: Monthly, Quarterly, etc.
• Status: Active, Paused, Closed
• Total Invested: Cumulative amount
• Units Accumulated: Total units purchased
• Current Value: Units × Current NAV
• XIRR: Annualized return including timing

SIP Monitoring

1. Verify monthly SIP debit from account
2. Confirm units purchased match expected NAV
3. Track increase in holdings month-on-month
4. Monitor fund performance vs benchmark
5. Review SIP continuation annually

FD/RD Maturity Tracking

Fixed Deposit Details

• Bank Name: Which bank issued FD
• FD Amount: Principal amount
• Tenure: Duration (1 year, 3 years, etc.)
• Rate of Interest: Annual interest percentage
• Maturity Date: When FD matures
• Maturity Amount: Principal + Interest
• Maturity Status: Active, Matured, Renewed
• Renewal Details: If renewed, new rate and tenure

RD (Recurring Deposit) Tracking

• Installment Amount: Monthly/quarterly amount
• Tenure: Total months/quarters
• Rate: Current interest rate
• Maturity Date: Final installment date
• Maturity Amount: Total paid + interest
• Status: Active, Completed

Maturity Alerts

Maintain calendar of maturity dates:

• 30 days before: Review renewal options
• Maturity date: Note received amount
• Post-maturity: Update portfolio with proceeds

EPF/PPF Balance Tracking

Public Provident Fund (PPF)

• Account Number: 7-character PPF account ID
• Current Balance: As per latest statement
• Interest Rate: Current annual rate (FY 2025-26: 7.1%)
• Financial Year: Track by FY for withdrawal rules
• Subscription: Annual contribution limits
• Years Completed: For maturity tracking (15-year lock)

PPF Rules to Remember

• Minimum ₹500/year, Maximum ₹1.5L/year
• Lock-in 15 years (can extend 5 years thereafter)
• Withdrawal allowed from 7th year (50% of balance)
• Tax-free returns
• Eligible for Section 80C deduction

EPF (Employee Provident Fund)

• Account Number: UAN (Universal Account Number)
• Employee Contribution: Monthly amount deducted
• Employer Contribution: Employer match
• Total Balance: Both employee + employer portions
• Interest Rate: Current rate
• Passbook/Statement: Latest available statement
• Vesting Status: For gratuity eligibility

NPS (National Pension Scheme)

• Account Number: 12-digit NPS account number
• Contributor ID: Tier I account holder
• Contributions: Monthly/quarterly SIP details
• Current Value: Net market value
• Fund Choice: Fund allocation percentage
• Withdrawal Rules: Partial, full withdrawal eligibility
• Maturity Date: Expected maturity when fund ends

Key Metrics & Calculations

Absolute Returns

Return from investment start to current date:

Absolute Return % = [(Current Value - Cost Basis) / Cost Basis] × 100

Compound Annual Growth Rate (CAGR)

Annualized return over multiple years:

CAGR = [(Ending Value / Beginning Value) ^ (1/Number of Years)] - 1

Short-term vs Long-term Holding

• Short-term: < 1 year (for capital gains tax)
• Long-term: ≥ 1 year (for capital gains tax)

Dividend Yield

Income return from investments:

Dividend Yield % = (Annual Dividend / Current Price) × 100

Portfolio Rebalancing Alerts

Rebalancing Triggers

Rebalance when:

• Any asset class variance from target > 5%
• Significant wealth increase/decrease
• Market correction > 15%
• Annual portfolio review (recommended quarterly)
• Major life event (marriage, child, retirement)

Rebalancing Actions

1. Identify over-allocated asset class
2. Identify under-allocated asset class
3. Calculate shift required
4. Execute trades to rebalance
5. Document rebalancing action
6. Update asset allocation tracker

Risk Profile Monitoring

Low Risk Metrics

• XIRR consistent with expectations
• Volatility low (debt-heavy)
• Diversification good
• Drawdown tolerance high

Medium Risk Metrics

• Balanced equity-debt mix
• Volatility moderate
• Good diversification
• Regular rebalancing

High Risk Metrics

• Equity-heavy portfolio
• Volatility significant
• Concentrated positions possible
• Higher expected returns

Annual Investment Review

Conduct annually (preferably in March):

• Update all holdings with latest valuations
• Calculate XIRR for each investment
• Review asset allocation vs target
• Check tax-saving investment deadlines
• Plan NPS/PPF contributions
• Review and rebalance portfolio
• Document learnings and changes
• Set goals for next financial year