This article gives you an easy-to-use calculator to know your term insurance coverage amount.
How to calculate term insurance coverage amount?
13 Nov 2022 - Contact Sayan Sircar
9 mins read
This article gives you an easy-to-use calculator to know your term insurance coverage amount.
Table of Contents
- 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 the simplest possible insurance policy: you pay the premium every year. If you die, the nominee gets money; if you do not die, they don’t. The money you pay to the insurance company is the premium. The money that the nominee(s) gets is called sum assured.
Insurance allows risk transfer from a single person to a group of people. Since many people buy insurance, very few of them 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.Recent articles:
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.If you liked this article, consider subscribing to new posts by email by filling the form below.
Worked out case studies for goal-based investing
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 the effect of postponing early retirement by just a little since it allows you to spend more in retirement.
Published: 4 December 2022
2 MIN READ
This article shows a way to decide what to do when stock markets reach all-time or lifetime highs. Should investors buy more or sell to book profits?
Published: 30 November 2022
4 MIN READ
Topics you will like:Asset Allocation (17) Basics (8) Behaviour (10) Budgeting (9) Calculator (13) Case Study (3) Children (9) Choosing Investments (28) FAQ (3) FIRE (10) Gold (6) Health Insurance (4) House Purchase (13) Insurance (12) International Investing (8) Life Stages (2) Loans (10) Market Movements (8) Mutual Funds (14) NPS (5) NRI (4) News (5) Pension (6) Portfolio Construction (36) Portfolio Review (22) Retirement (29) Review (7) Risk (6) Safe Withdrawal Rate (5) Set Goals (26) Step by step (8) Tax (16)
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 206 posts and growing fast. Search this site: Copyright © 2021-2022 Arthgyaan.com. All rights reserved.