This article gives you an easy-to-use calculator to know your term insurance coverage amount.
How to calculate term insurance coverage amount?
Posted on 13 Nov 2022
Author: Sayan Sircar
10 mins read
Get new post notifications on WhatsApp!
This article gives you an easy-to-use calculator to know your term insurance coverage amount.
📚 Topics covered:
- Why do you need term insurance?
- How much term insurance do you need?
- Using the calculator
- Get the calculator
Note: This is post #200 on this blog. This milestone has been reached in 21 months since the day of starting this blog in March 2021. I wish to thank all my readers for their continued support.
Why do you need term insurance?
Term insurance is a type of life insurance that pays a benefit to the named beneficiaries in the event of the insured person’s death, as long as the policy is active. The purpose of term insurance is to provide financial protection for the policyholder’s loved ones in the event of their unexpected death, helping to cover daily expenses, future goals such as children’s education, and loans like home loans.
It is a straightforward insurance product, similar to car insurance, in that it only pays out in the event of a specific occurrence (death) and does not have a savings component like other types of life insurance. The cost of a term insurance policy is generally low compared to the potential benefit, and the recommended coverage amount is typically 20 times the policyholder’s annual after-tax income.
Insurance allows risk transfer from a single person to a group of people. Since many people buy insurance, only some are expected to die within the policy’s coverage time. However, it should be present at least for all earning members of the family before retirement age.
The concept of term insurance and why you need it has been covered in detail in this article: Term life insurance: what, why, how much to get and from where?.
This article shows you how to calculate the coverage amount that you need.Join the Arthgyaan WhatsApp community: You can stay updated on our latest content and learn about our webinars. Our community is fully private so that no one, other than the admin, can see your name or number. Also, we will not spam you.
How much term insurance do you need?
As a thumb rule, typically, coverage will be 15-25x current annual income after tax.
There are two ways of calculating insurance coverage/sum assured needed. The coverage required typically changes every few years since financial goals and life events (like marriage, the birth of a child etc. happen) change the requirement. Please review the term coverage needed every 3-4 years. The method of calculation of coverage required is called Human Life Value (HLV) method.
HLV Income method
Use a tool like Excel or Google Sheets to calculate using the following formula:
Coverage needed = PV(RealRate,Years_to_retire,-AfterTaxAnnualIncome,0,1)
- The real rate depends on the industry and salary growth potential vs inflation in the country. A value like 0-2% can be assumed. If the real rate is assumed to be 0%, then the coverage amount is simply Income multiplied by Years_to_retire
- Years_to_retire indicates how much time is left until retirement, typically from today to 55-60
- AfterTaxAnnualIncome is the in-hand salary (plus components of EPF) that are received every year
Someone currently 32 years old in a high growth industry expecting to retire at 55 and having an after-tax annual income of 20 lakhs needs coverage of
PV(0%,55-32,-20,0,1) = 4.6cr.
If they already have a 1cr term plan, then you should take additional 3.5cr coverage.
Here are some lookup tables that can help you:
Case 1: Real rate = 0%
Case 2: Real rate = 1%
Case 3: Real rate = 2%
HLV Expense method
Coverage needed = PV(Real_Rate_In_Retirement,Years_In_Retirement,-Current_Annual_Expenses,0,1) + LoansOutstanding - Current_Investments - Existing_Term_Insurance where
Salary credited to the bank
- minus the personal needs of the person being insured
- minus any EMI being paid
- minus any insurance premiums being paid
Example: (using the exact figures from above)
If a spouse spends 30 years in retirement where the real rate of return is 0% (a reasonable assumption), 33 lakhs in home loan outstanding, 80 lakhs in investments (stocks/mutual funds/FD etc. but not house) having 1cr current term insurance will need
In hand salary less personal needs of the person being insured (20 lakhs salary less two lakhs personal expenses) less any EMI being paid (25k/month, i.e. three lakhs/year for a home loan) less any insurance premiums being paid (11k/year for 1cr term plan)
= (20-2) - 3 - 0.11 = 14.89 lakhs.
Coverage needed = PV(0%,30,-14.89,0,1) + 0.33 - 0.80 - 1.00
= 4.47 + 0.33 - 0.80 - 1.0
Minimum term insurance coverage amount
If you are using the comprehensive Google sheets-based goal planner then you will see the minimum term insurance you need to have based on:
- the shortfall of current goals. If income stops, this amount, if invested, will fund current goals
- the amount needed to sustain a retirement-level lifestyle, including inflation adjustment, for the period income was expected to be there.
This figure is the minimum since you need to add any ongoing outstanding secured loans (like home or car loans) or loans where family members may be co-borrowers to this coverage amount. This means that if you have 30 lakhs in an outstanding home/car loan or an educational loan of 10 lakhs with parents as co-borrowers, add those amounts to the term insurance coverage.
Using the calculator
We have put together an easy-to-use calculator to calculate the coverage amount. The number will be approximate and will depend on the quality of the inputs that you enter into the calculator.
Important: You should enter data only in the yellow cells. If any cell is not relevant to you, please enter 0 to erase the number in the cell.
Step 1: Enter basic information
- Box 1: Enter your name.
- Box 2: Desired retirement age: this can be either the company-mandated age of 58 or 60 or the age you wish to take early retirement
- Box 3: If you already have personal, i.e. not company-provided life insurance, enter the covered amount here. If you don’t have any, enter 0. The number is in ₹ lakhs
Step 2: Do you have dependents?
Box 4: This is a Yes/No choice. Generally, if you do not have dependents, you do not need term insurance unless you have loans.
Step 3: Enter income and expense details
- Box 5: In hand monthly salary after tax
- Box 6: Employee provident fund (EPF) and NPS deductions if any per month
- Box 7: Annual bonus if any. This is yearly and not monthly
- Box 8: How much income growth potential do you have in your current industry? This is perception based and is the same real-rate figure mentioned above in the HLV Income section. Leave this at High if you do not know.
- Box 9: The real rate of return for the retirement portfolio will be 0% for most people. Do not change this. If you do, you need to create a very aggressive portfolio that may or may not suit your retirement goal
- Box 10: How much time are you expected to spend in retirement? This is a function of starting age for retirement and longevity. You should assume a high figure under normal circumstances
- Box 11: The money you spend today for the whole year apart from personal expenses, EMI and insurance premiums for yourself. If your family expense is ₹5 lakhs/year and you spend ₹30,000 for your own insurance and ₹70,000 for personal expenses, enter ₹4 lakhs here
Step 4: Enter goals
This is for Box 12 and is an important section. If you do not fill this out correctly, you will underestimate the amount of insurance coverage needed. The value should be the target corpus of future financial goals, projected to the present. For example, if you need 10 lakhs in 5 years and can invest at 5% post-tax returns, the value will be ₹10/(1.05)^5 = ₹7.8 lakhs.
You can enter goals in the table one after the other. The total will be added and fed into the calculation.
Similarly, you need to enter the current outstanding amounts of all loans. For example, if you have a ₹70 lakhs home loan and have already paid off ₹20 lakhs, then enter 50 here.
Step 5: Enter the market value of your assets
This is for boxes 14 and 15. You need to enter the market value of all your assets. For real estate, the market value of your primary residence is not included in the calculation since you do not expect your family to sell their home since you died.
The result will be calculated and shown to you in the middle of the page. The number you see, in lakhs, is the additional coverage amount. If you are buying a new policy today, the coverage should be around this number. If the number comes to be very low or zero, you do not need term insurance coverage as explained here: How your term insurance coverage changes with time.
Get the calculator
Since the calculator uses Google Sheets, you need to be logged into your Google Account on a browser before clicking the link.
Link to the calculator: here. You will get the calculator, which is free for use, in the “term-insurance” sheet.
What's next? You can join the Arthgyaan WhatsApp communityYou can stay updated on our latest content and learn about our webinars. Our community is fully private so that no one, other than the admin, can see your name or number. Also, we will not spam you.
If you liked this article, please leave us a ratingThe following button will take you to Trustpilot:
Discover an article from the archives
Worked out case studies for goal-based investing
Case study: how can this middle aged investor with two children plan for retirement and children's goals?
This article shows how a single-income middle aged couple with two small children reach their retirement and children’s goals.
This article shows how a double-income couple with a 2-year old reach their FIRE dream at the age of 50.
This article shows how a double-income couple with a newborn child can invest for their future goals of FIRE and real-estate investment.
Case study: how this double income recently married family can perform DIY goal-based investment planning
This article shows how a young just-married couple can invest for future goals using the Arthgyaan goal-based investing tool.
Did you welcome a bundle of joy in your 40s? This article will discuss ways of planning the child’s (and your’s financial future)
This article shows how a very typical salaried couple with one child can invest for future goals using the Arthgyaan goal-based investing tool.
Previous and next articles:
This article explores if short-term returns of the Nifty 50 allow you to predict future returns
Published: 9 November 2022
5 MIN READ
This article shows you the way to understand the risk and return potential for debt mutual funds using a SEBI-mandated risk classification tool.
Published: 16 November 2022
3 MIN READ
This article shows a handy ready reckoner for home loan EMI amounts for all tenures and interest rates along with the amount of principal and interest to be paid.
Published: 29 September 2023
1 MIN READ
A quick retirement calculation for a reader query who has a good amount of corpus already saved for retirement.
Published: 27 September 2023
7 MIN READ
Topics you will like:Asset Allocation (20) Basics (8) Behaviour (10) Budgeting (11) Calculator (17) Case Study (6) Children (12) Choosing Investments (38) FAQ (6) FIRE (13) Gold (11) Health Insurance (4) House Purchase (17) Insurance (15) International Investing (10) Life Stages (2) Loans (9) Market Movements (13) Mutual Funds (29) NPS (6) NRI (13) News (9) Pension (8) Portfolio Construction (46) Portfolio Review (27) Reader Questions (6) Real Estate (6) Retirement (36) Review (12) Risk (6) Safe Withdrawal Rate (5) Set Goals (27) Step by step (14) Tax (37)
1. Email me with any questions.2. Use our goal-based investing template to prepare a financial plan for yourself
use this quick and fast online calculator to find out the SIP amount and asset allocation for your goals.
Disclaimer: Content on this site is for educational purpose only and is not financial advice. Nothing on this site should be construed as an offer or recommendation to buy/sell any financial product or service. Please consult a registered investment advisor before making any investments.
This post titled How to calculate term insurance coverage amount? first appeared on 13 Nov 2022 at https://arthgyaan.com
We are currently at 299 posts and growing fast. Search this site: Copyright © 2021-2023 Arthgyaan.com. All rights reserved.