Education Planning Checklist
A Complete Guide to Funding Your Child's Education
Prepared by NovaRock Advisory – Your Partner in Financial Success
Table of Contents
- Education Cost Estimation Tool
- Savings Timeline & Strategy
- Education Loan Guide
- Investment Options for Education Goals
- Tax Benefits Overview
- Implementation Timeline
Section 1: Education Cost Estimation Tool
Planning for your child's education begins with understanding future costs. Education inflation runs at 8–12% annually, significantly higher than general inflation.
Types of Education Costs
| Education Level | Current Avg Cost (India) | Duration |
|---|---|---|
| Primary School (1–8) | ₹ 50,000 – ₹ 2 lakh/year | 8 years |
| Secondary School (9–12) | ₹ 1 – ₹ 3 lakh/year | 4 years |
| Undergraduate (BA/BSc/BCom) | ₹ 2 – ₹ 8 lakh total | 3 years |
| Engineering (BTech) | ₹ 10 – ₹ 25 lakh total | 4 years |
| Medical (MBBS) | ₹ 20 – ₹ 1 crore total | 5.5 years |
| MBA (Top B-Schools) | ₹ 20 – ₹ 35 lakh total | 2 years |
| Study Abroad (UG) | ₹ 50 lakh – ₹ 1.5 crore | 3–4 years |
| Study Abroad (PG) | ₹ 30 lakh – ₹ 80 lakh | 1–2 years |
Education Cost Calculator
Step 1: Define Your Child's Education Path
- Child's current age: _____ years
- Years until higher education: _____ years
- Planned education level: _______________
- Location preference: India / Abroad
Step 2: Current Cost Estimation
Research current costs for your target education path:
- Tuition fees (per year): ₹ _____________
- Hostel / accommodation: ₹ _____________
- Books & materials: ₹ _____________
- Living expenses: ₹ _____________
- Travel & other costs: ₹ _____________
- Total annual cost (today): ₹ _____________
Step 3: Apply Education Inflation
Use this formula to calculate future cost:
Your Calculation:
- Current annual cost: ₹ _____________
- Education inflation rate: ______ % (assume 8–12%)
- Years to higher education: _____ years
- Inflation multiplier: (1 + 0.10)^years = _______
- Future annual cost: ₹ _____________
Step 4: Total Education Corpus Required
| Year | Annual Cost | Notes |
|---|---|---|
| Year 1 | ₹ _____________ | First year of college |
| Year 2 | ₹ _____________ | Apply inflation on Year 1 |
| Year 3 | ₹ _____________ | Apply inflation on Year 2 |
| Year 4 | ₹ _____________ | If 4-year course |
| Total Education Corpus Needed | ₹ _____________ | |
💡 Sample Calculation: Engineering After 10 Years
Assumption: BTech, current cost ₹ 5 lakh/year, 10% education inflation, 10 years away.
- Year 1 cost: ₹ 5L × (1.10)^10 = ₹ 12.97 lakh
- Year 2 cost: ₹ 12.97L × 1.10 = ₹ 14.27 lakh
- Year 3 cost: ₹ 14.27L × 1.10 = ₹ 15.69 lakh
- Year 4 cost: ₹ 15.69L × 1.10 = ₹ 17.26 lakh
- Total corpus needed: ₹ 60.19 lakh
Cost Estimation Checklist
- [ ] Child's age and years to higher education noted
- [ ] Target education path decided (engineering, medical, etc.)
- [ ] Current cost researched for preferred colleges
- [ ] Education inflation rate applied (8–12%)
- [ ] Future annual cost calculated
- [ ] Total education corpus estimated (4-year total)
Section 2: Savings Timeline & Strategy
Once you know the target corpus, create a systematic savings plan to achieve it.
Monthly SIP Calculation
Use this formula to calculate required monthly savings (SIP):
Your Monthly SIP Requirement
- Total education corpus needed: ₹ _____________
- Years available to save: _____ years
- Expected annual return: ______ % (assume 10–12% for equity)
- Monthly return rate: ______ % (annual / 12)
- Monthly SIP required: ₹ _____________
Phased Savings Strategy
Consider increasing your SIP over time as income grows:
| Phase | Years | Monthly SIP | Strategy |
|---|---|---|---|
| Phase 1 | Years 1–3 | ₹ _____________ | Start conservatively |
| Phase 2 | Years 4–7 | ₹ _____________ | Increase by 15–20% |
| Phase 3 | Years 8–10 | ₹ _____________ | Final push, top-up if needed |
Goal-Based Investment Timeline
When Child is 0–5 Years Old (15+ years to college)
- Allocation: 80% equity, 20% debt
- Instruments: Equity mutual funds, index funds, Sukanya Samriddhi (for girl child)
- Strategy: Maximum growth potential, time to recover from volatility
When Child is 6–10 Years Old (8–12 years to college)
- Allocation: 70% equity, 30% debt
- Instruments: Balanced funds, ELSS, PPF, child plans
- Strategy: Continue growth focus, start building stability
When Child is 11–15 Years Old (3–7 years to college)
- Allocation: 50% equity, 50% debt
- Instruments: Debt funds, FDs, conservative hybrid funds
- Strategy: Reduce risk, preserve capital
When Child is 16+ Years Old (0–2 years to college)
- Allocation: 20% equity, 80% debt/liquid
- Instruments: Liquid funds, short-term FDs, sweep accounts
- Strategy: Full capital preservation, easy liquidity
💡 Pro Tip: Step-Up SIP
Use a step-up SIP that automatically increases contribution by 10% every year. This aligns with salary increments and significantly boosts corpus without extra effort.
Example: Start with ₹ 15,000/month, increase 10% annually = ₹ 39,000/month by Year 10.
Savings Timeline Checklist
- [ ] Monthly SIP amount calculated based on target corpus
- [ ] Step-up SIP considered (10% annual increase)
- [ ] Asset allocation decided based on child's age
- [ ] Automatic SIP set up (don't rely on manual investing)
- [ ] Annual review scheduled to adjust contributions
- [ ] Windfall allocations planned (bonus, gifts, etc.)
Section 3: Education Loan Guide
Education loans can bridge the funding gap or preserve family savings. Understand the options, costs, and tax benefits.
Types of Education Loans
| Loan Type | Amount | Interest Rate | Collateral |
|---|---|---|---|
| Domestic Education (India) | Up to ₹ 10 lakh | 9–12% | Not required |
| Domestic Education (India) | Above ₹ 10 lakh | 9–12% | Required |
| Study Abroad | Up to ₹ 7.5 lakh | 10–13% | Not required |
| Study Abroad | Above ₹ 7.5 lakh | 10–13% | Required |
Eligibility Criteria
- Student: Indian resident with admission to recognized institution
- Age: Typically no upper age limit
- Course: UG, PG, diploma, or vocational courses in approved colleges
- Co-applicant: Parent, guardian, or spouse required
- Academic record: Consistent performance preferred
What Education Loans Cover
- [ ] Tuition fees (full coverage)
- [ ] Hostel / accommodation charges
- [ ] Examination / library / lab fees
- [ ] Books, equipment, instruments
- [ ] Study tour / project expenses
- [ ] Travel expenses (for abroad study)
- [ ] Purchase of computers / laptops
- [ ] Two-wheeler (in some cases)
- [ ] Caution deposit, refundable deposits
Repayment Timeline
- Moratorium period: Course duration + 6 months (or 1 year for some banks)
- Repayment tenure: 5–15 years after moratorium
- EMI start: After getting a job or end of moratorium
- Prepayment: Allowed without penalty (check bank policy)
Sample Loan Repayment
| Loan Amount | Interest Rate | Tenure | Monthly EMI |
|---|---|---|---|
| ₹ 10 lakh | 10% | 10 years | ₹ 13,215 |
| ₹ 20 lakh | 10% | 10 years | ₹ 26,430 |
| ₹ 30 lakh | 11% | 15 years | ₹ 34,125 |
| ₹ 50 lakh | 11% | 15 years | ₹ 56,875 |
Top Education Loan Providers
- SBI Education Loan
- HDFC Credila Education Loan
- ICICI Bank Education Loan
- Axis Bank Education Loan
- Bank of Baroda Education Loan
- Avanse Financial Services
- IDFC First Bank
💡 Pro Tip: Tax Benefit on Education Loan
Under Section 80E, you can claim full interest deduction (no upper limit) on education loans. This benefit is available for up to 8 years from the start of repayment.
Example: If interest paid = ₹ 80,000/year, tax saved (30% bracket) = ₹ 24,000/year.
Education Loan Checklist
- [ ] Admission letter secured from recognized institution
- [ ] Compared loan offers from 3–5 banks/NBFCs
- [ ] Understood interest rates and processing fees
- [ ] Checked collateral requirements (if applicable)
- [ ] Co-applicant (parent/guardian) ready with documents
- [ ] Moratorium and repayment tenure understood
- [ ] Tax benefits under Section 80E noted
Section 4: Investment Options for Education Goals
Choose the right mix of investments based on your time horizon and risk appetite.
Long-Term Investments (10+ Years Away)
Equity Mutual Funds
- Type: Large cap, flexi-cap, index funds
- Expected return: 12–15% annually
- Risk: High (short-term volatility)
- Best for: Children aged 0–8 years
- Example funds: Parag Parikh Flexi Cap, HDFC Index Fund Nifty 50
Sukanya Samriddhi Yojana (SSY) - For Girl Child Only
- Eligibility: Girl child under 10 years
- Maximum contribution: ₹ 1.5 lakh/year
- Interest rate: 7.6% (quarterly revised)
- Maturity: 21 years from opening
- Tax benefit: Triple tax exemption (EEE)
- Partial withdrawal: Allowed after 18 years for education
Public Provident Fund (PPF)
- Maximum contribution: ₹ 1.5 lakh/year
- Interest rate: 7.1% (quarterly revised)
- Lock-in: 15 years (extendable in 5-year blocks)
- Tax benefit: Full deduction under 80C, tax-free returns
- Partial withdrawal: Allowed from 7th year
Medium-Term Investments (5–10 Years Away)
Balanced / Hybrid Mutual Funds
- Type: 50–70% equity, 30–50% debt mix
- Expected return: 9–12% annually
- Risk: Moderate
- Best for: Children aged 8–13 years
Child Insurance Plans (ULIP / Traditional)
- Type: Insurance + investment combo
- Expected return: 6–10% (varies by plan)
- Lock-in: 5+ years (ULIPs), 10–15 years (traditional)
- Death benefit: Premiums waived if parent passes away
- Tax benefit: Premium deduction under 80C
Short-Term Investments (0–5 Years Away)
Debt Mutual Funds
- Type: Short-duration, corporate bond funds
- Expected return: 6–8% annually
- Risk: Low
- Best for: Children aged 14–17 years
Fixed Deposits (Bank / Post Office)
- Interest rate: 6–7.5%
- Risk: Very low (capital guaranteed)
- Liquidity: Moderate (penalty on early withdrawal)
- Tax: Interest taxable as per slab
Liquid / Overnight Funds
- Expected return: 4–5%
- Risk: Very low
- Liquidity: Instant withdrawal
- Best for: Parking funds 6–12 months before college starts
Sample Portfolio Allocation
| Child's Age | Years to College | Equity % | Debt % | Liquid % |
|---|---|---|---|---|
| 0–5 years | 13–18 years | 80% | 20% | 0% |
| 6–10 years | 8–12 years | 70% | 30% | 0% |
| 11–14 years | 4–7 years | 50% | 40% | 10% |
| 15–17 years | 1–3 years | 20% | 60% | 20% |
Investment Options Checklist
- [ ] Investment mix decided based on child's age and time horizon
- [ ] Opened Sukanya Samriddhi account (if girl child under 10)
- [ ] Started SIP in equity mutual funds (long-term goal)
- [ ] PPF account active with annual contributions
- [ ] Annual portfolio review scheduled
- [ ] Rebalancing strategy planned (shift to debt as goal nears)
Section 5: Tax Benefits Overview
Education planning offers multiple tax-saving opportunities. Use them to maximize savings and reduce tax liability.
Section 80C - Education-Related Deductions
Tuition Fees Deduction (Section 80C)
- Limit: Included in overall ₹ 1.5 lakh 80C limit
- Eligible: Tuition fees paid to school, college, university (India only)
- Coverage: Maximum 2 children
- Excluded: Development fees, transport, hostel, donations
- Documents needed: Fee receipt from institution
Life Insurance / Child Plans (Section 80C)
- Limit: Part of ₹ 1.5 lakh 80C limit
- Deduction: Annual premium paid
- Tax on maturity: Exempt if premium ≤ 10% of sum assured
Other 80C Investments for Education Goal
- PPF contributions (₹ 1.5 lakh max)
- Sukanya Samriddhi Yojana (₹ 1.5 lakh max)
- ELSS mutual funds (₹ 1.5 lakh max, 3-year lock-in)
- 5-year bank/post office FDs
Section 80E - Education Loan Interest Deduction
- Deduction: Full interest amount (no upper limit)
- Duration: Up to 8 years from start of repayment
- Eligible: Loan for self, spouse, children, or student (if repaying own loan)
- Course: Any full-time higher education (UG, PG, vocational)
- Institution: India or abroad, recognized by govt/approved body
- Documents needed: Interest certificate from lender
Sample Tax Savings on Education Loan
| Annual Interest Paid | Tax Slab 30% | Annual Tax Saved | 8-Year Total Savings |
|---|---|---|---|
| ₹ 50,000 | 30% | ₹ 15,000 | ₹ 1,20,000 |
| ₹ 1,00,000 | 30% | ₹ 30,000 | ₹ 2,40,000 |
| ₹ 1,50,000 | 30% | ₹ 45,000 | ₹ 3,60,000 |
Triple Tax Exemption (EEE) Schemes
These schemes offer tax benefits on contribution, accumulation, and withdrawal:
- Sukanya Samriddhi Yojana: Contribution (80C), growth, and withdrawal all tax-free
- PPF: Contribution (80C), interest, and maturity all tax-free
💡 Maximize Tax Savings Strategy
Combine multiple benefits:
- ₹ 1.5L in SSY/PPF → Tax saved (30%): ₹ 45,000
- ₹ 50,000 tuition fees → Tax saved (30%): ₹ 15,000
- ₹ 1,00,000 education loan interest (80E) → Tax saved: ₹ 30,000
- Total annual tax saving: ₹ 90,000+
Tax Benefits Checklist
- [ ] Claiming tuition fee deduction under 80C (if applicable)
- [ ] Maximizing SSY/PPF contributions for 80C benefit
- [ ] Keeping education loan interest certificates for 80E claim
- [ ] Using EEE schemes (SSY, PPF) for maximum tax efficiency
- [ ] Filing ITR annually to claim all education-related deductions
Section 6: Implementation Timeline
Follow this step-by-step timeline to execute your education plan successfully.
When Child is Born to Age 5
- [ ] Open Sukanya Samriddhi account (if girl child)
- [ ] Start PPF account in parent's name for education goal
- [ ] Begin small SIP in equity mutual funds (₹ 5,000–10,000/month)
- [ ] Create education goal calculator spreadsheet
- [ ] Decide target education path (tentative)
Age 6–10 Years
- [ ] Increase SIP by 10–15% annually with income growth
- [ ] Add balanced/hybrid funds to portfolio
- [ ] Review child's academic interests and strengths
- [ ] Research education costs for target courses
- [ ] Update education corpus estimate
Age 11–14 Years (Pre-High School / Early High School)
- [ ] Finalize target education path (engineering, medical, commerce, etc.)
- [ ] Calculate exact corpus needed with inflation
- [ ] Check if current savings on track (50–70% of target)
- [ ] Start shifting 20–30% from equity to debt funds
- [ ] Research target colleges and entrance exams
Age 15–17 Years (Final School Years)
- [ ] Accelerate savings if shortfall exists (top-up SIP)
- [ ] Shift majority to debt/liquid funds (preserve capital)
- [ ] Research education loan options (backup plan)
- [ ] Prepare for entrance exams (coaching fees budgeted)
- [ ] Shortlist 5–10 target colleges with fee structures
Age 18 (Admission Year)
- [ ] Admission secured in target college
- [ ] Final education cost confirmed
- [ ] Liquidate investments as per fee schedule
- [ ] Apply for education loan if required
- [ ] Pay first-year fees from accumulated corpus
- [ ] Plan year-wise fund allocation (Year 2–4)
During College Years (Age 18–22)
- [ ] Withdraw funds as per annual fee requirement
- [ ] Keep remaining corpus in debt/liquid funds
- [ ] Ensure education loan EMI (if any) planned
- [ ] Monitor child's academic performance
- [ ] Encourage part-time work / internships (if feasible)
💡 Pro Tip: Annual Review
Review your education plan every year on your child's birthday. Adjust SIP amounts, rebalance portfolio, and update corpus estimates with current education inflation rates.
Master Implementation Checklist
- [ ] Education corpus target calculated and documented
- [ ] Monthly SIP started in appropriate asset mix
- [ ] SSY/PPF accounts opened and active
- [ ] Annual portfolio review scheduled
- [ ] Tax benefits optimized (80C, 80E where applicable)
- [ ] Education loan options researched (backup plan)
- [ ] Timeline followed with age-appropriate actions