Money Excel - Personal Finance Blog

Menu
MENUMENU
MENUMENU
  • Home
  • Business Ideas
    • 225 Small Business Ideas
    • 40 Online Business Ideas
    • 20 Business Ideas for Beginners
    • 20 small manufacturing business
    • 30 Food Business Ideas
    • 100 Business Ideas low investment
  • Stock Market
    • Best Demat & Trading Accounts 2020
    • Best Stocks 2020 by Experts
    • Best Virtual Trading Apps
    • Best Stock Screener
    • Best Discount Brokers in India
    • Multibagger Stocks of LockDown
    • Rakesh Jhunjhunwala Portfolio
  • Mutual Funds
    • Best Mutual Funds 2020-21
    • Best Direct Mutual Fund Platform
    • Best Mutual Fund Mobile Apps
  • Incometax
    • Income Tax Slab FY 2020-21
    • Income Tax Calculator FY 2020-21
    • Income Tax Refund Request
    • Pay Advance Tax Online
    • Download New 15G -15 H Forms
  • Investment
    • Best Investment Ideas 2020
    • Long Term Investment Options
    • Best Investment Regular Income
    • Best Investment Options NRI
  • Credit Card
    • Best Credit Cards 2020-21
    • Best credit card for online shopping
    • Best Forex Card in India
    • Best Business Credit Cards
    • Credit Cards against Fixed Deposit
  • Insurance
    • Best Term Insurance Plans 2020
    • Best Health Insurance 2020
    • Best LIC Policy 2020
    • Best Car Insurance Companies
    • Best Mobile Insurance Companies
  • Downloads
Home
Personal Finance
Cost of Child Education – Planning and Calculator

Cost of Child Education – Planning and Calculator

Shitanshu Kapadia June 14, 2020

education cost

We always dream to give best education to our child but do we really think about growing cost of child education? We want a child to become doctor or engineer but do we really plan for this? As per me saving for child education is the most important goal for parents. Other goals like buying car or buying home can be compromised, but we cannot compromise our child education.

When it comes to child education planning majority of people rely on child education plan which ends up paying them peanut type returns. In this post, I will be highlighting details of growing child education cost and will be giving education planning calculator.

Cost of Child Education –

The cost of child education is growing rapidly. A Recent survey carried out ASSOCHAM on child education says that it is very difficult to pay school and tuition fees by salaried people. Finding of survey carried out on 1600 working parents across country is given below –

Do not miss below posts -
  • Learning from Amitabh bachchan life
  • Special offers by banks on financial products
  • Google Pay or Paytm – Which one is best?
  • School fees, tuition fees and other associated expenses have gone up by 150% in last 10 years.
  • Education expenses for a single child including tuition fee is grown to 1.25 lakh in 2015, from 55,000 in 2005.
  • 9 out of 10 parents responded that rising cost has affected even their choice of school.
  • 70% of parents spend 30-40% of take home salary on their child education.
  • School cost is growing at more than double the rate of inflation.
  • Apart from fees another cost is also growing like a cost of uniforms, books, transport, sports activity, school aids etc.
  • 80% of respondents say that they are worried about growing cost of education.

Average cost of  Education in School  – 2015

cost child education

Source – ASSOCHAM Survey 

If you are worrying about the rise in school education expense, there is one more time bomb ticking away i.e Cost of higher education. The cost of higher education is growing even faster than this. Average fees of Engineering course is roughly Rs 8 Lakh today, five years down the line it would be close to double meaning Rs 16 Lakh. In 10 years’ time, it’s likely to cost around Rs 25 Lakh.

The cost of MBA course has grown even faster. The current cost of MBA is approximate 20 Lakh and expected to be 60 Lakh after 10 years.

The cost of education is growing exponentially and has no end. We are planning for retirement but looking at details above we must plan for child education.

One thing is sure that you have to save & invest enough money for your child education. Follow steps are given below to plan your child education.

1 Set Target Year

Do not miss below posts -
  • How to update KYC EPF UAN Online?
  • E-fraud – Learning from Crime Petrol story
  • 15 Money Mantras of 2015

The first step is to find out target year for education expense. It is very easy to find out this if your child age is 1 year then he will enter in graduation year after 18 years. If he is likely to do MBA after graduation you need to consider target age 21-22 year for MBA.

2 Find Current Education Cost

The second step is to find current education cost. Arriving at current education cost is somehow difficult. First you need to decide that which educational institute you are planning for your child. You have various options like Regional Engineering colleges, IIT etc for engineering. You need to find out current education cost applicable to that course in the specific institute.

3 Find Future Education Cost

The third step is to find future education cost. Inflation rate comes in to picture at this stage. You can find future education cost by using simple excel formula of FV.

4 Find Monthly Investment Amount

In order to find out monthly investment amount required you can use simple excel formula PMT. PMT formula calculates constant payment on constant interest rates.

5 Invest in Suitable Investment Option

Once you are done with all above step you need to find out investment option which can generate a return as per your expectation. You can select good mutual funds which can generate a return in the range of 12-15%.

In order to help you out here is simple excel based Child Education Calculator.

education calculator

Download Child Education Calculator

Hope you find this calculator useful.

Do share this calculator with every parent you come across!

Prev Article
Next Article
Tags:child education child education calculator child education cost child education planning cost of education

About The Author

Shitanshu Kapadia

Hi, I am Shitanshu. By Profession I am Engineer and working in the IT field. I am crazy about Finance and like to research on financial matters. I have written 80+ article on this blog. If you like my efforts kindly subscribe to this blog and also let your friends know about this website by sharing.

3 Comments

  1. Pardeep Goyal

    This is the blog post I was looking for. Thanks for writing and sharing.

    I was doing some research for child’s education recently. This post has most of data points at same place which I have gathered from many places on internet.

    Being a parent, child’s education expense is second biggest expense on pocket. We even can not compromise with quality while optimizing these expenses.

    I am also running a blog on personal finance but this post is too good. I hope to see more post on similar lines in future.

    May 29, 2015
  2. Yogesh Tiwari

    I was just wondering, which school is selling shoes for 3500 every year to students??

    I think, some of the cost is inflated in the excel itself.

    RIP

    November 15, 2015
  3. Raviraj Parekh

    Dear Yogesh,

    This cost details are taken from survey of ASSOCHAM Survey. You can place your own value.

    Regards,
    Raviraj

    November 15, 2015

Leave a Reply

Cancel reply

IIFL Demat Account

Search

Top Posts & Pages

  • Rakesh Jhunjhunwala Portfolio Holdings - January 2021
  • How to check Property Records and Land Records online in India?
  • Income Tax Calculator FY 2020-21 (AY 2021-22) – Excel Download
  • 20 small manufacturing business ideas with low cost
  • Cash Deposit Machine Locator – How to find CDM Near You?
  • 225 Small Business Ideas with Low Investment in 2021-22
  • LIC Premium Paid Certificate Download For Income Tax Purpose - Online
  • 10 ways to Convert Black Money to White
  • 30 Food Business Ideas with low investment
  • Top 60 Manufacturing Business Ideas

Subscribe to Blog via Email

Join 5,474 other subscribers

Follow MoneyExcel

Money Excel – Personal Finance Blog

Personal Finance Blog
Copyright © 2021 Money Excel - Personal Finance Blog
| About |Downloads | Contact Us | Sitemap | Disclaimer | Privacy Policy |