Calculator overview
Inputs and outputs
This summary comes from the calculator's published input and output contract.
Inputs
- Mortgage Balance (required)
-
Unit $ Default 260860 Range 0 to 1500000
About this input
The amount that would be needed to pay the mortgage off outright today, not the monthly payment and not the original loan. Enter nothing if you rent or own outright.
- Liquid Savings
-
When omitted Blank
Unit $ Default Not set Range 0 to 2000000
About this input
Optional. Savings and investments that could actually be used: cash, brokerage accounts and anything else reachable without a penalty. Leave it blank and nothing is taken off. Retirement accounts are usually left out, because drawing them early is expensive and they are needed later anyway.
- Income Years (required)
-
Unit years Default 20 Range 0 to 40
About this input
How many years of that income the household would need replaced. Published guidance does not agree: some sources suggest seven to ten years, others twenty to twenty-five where there are young children, and several tie it to the years until the youngest child leaves school. Twenty matches a twenty-year level term policy and sits in the middle of the published spread.
- Other Debts (required)
-
Unit $ Default 21603 Range 0 to 250000
About this input
Everything else owed: credit cards, car loans, personal loans, student loans and any other balance that would still have to be settled. The mortgage is entered separately because the method keeps it separate.
- Replacement Share
-
When omitted Blank
Unit fraction Default Not set Range 0 to 1
About this input
Optional. The share of the income that would have to be replaced. Leave it blank and the whole income is replaced. A household loses one person's spending as well as their earnings, so anything from fifty to a hundred is defensible; whichever you choose, say so when you quote the answer.
- PV Tax On Earnings
-
When omitted Blank
Unit fraction Default Not set Range 0 to 0.4
About this input
Optional. The effective tax the lump sum's investment earnings would attract each year. Leave it blank and the published twenty percent is used. It only ever reduces what the money earns, so raising it raises the lump sum needed.
- PV Interest Rate
-
When omitted Blank
Unit fraction Default Not set Range 0 to 0.12
About this input
Optional. The rate the lump sum is assumed to earn while it is being paid out. Leave it blank and the published six percent is used. A higher rate means a smaller lump sum is enough, so this is the single assumption that moves the discounted figure most; set it to zero and the discounted figure rises above the plain sum, because money that earns nothing while the income it replaces keeps rising has to be larger.
- Children (required)
-
Unit count Default 2 Range 0 to 6
About this input
How many children the education figure below should be counted for. Enter nothing, or zero, if there are none, and the education leg drops out of the answer entirely.
- Applicant Age (required)
-
Unit years Default 40 Range 18 to 75
About this input
The age of the person who would be insured. It chooses a band in the premium ladder and a band in the income multiple ladder, and nothing else in the calculation depends on it. Anyone older than the last band is priced at that last band, and the status line says so.
- Annual Income (required)
-
Unit $/year Default 87460 Range 0 to 2000000
About this input
The income the household would lose, before tax, each year. The method multiplies it by the years you want replaced, so it is the figure that drives the largest part of the answer by far. If two people earn and only one is being insured, enter that one person's income.
- Education Per Child (required)
-
Unit $ Default 123960 Range 0 to 400000
About this input
The whole cost of educating one child, not a yearly figure. Four years of the average total budget at a public four-year in-state institution, room and board included, is about 124,000 at 2025-26 prices; a private institution is roughly twice that. Guidance from insurers commonly suggests 100,000 to 150,000 per child.
- Income Growth
-
When omitted Blank
Unit fraction Default Not set Range 0 to 0.1
About this input
Optional. The rate the income being replaced would have grown at. It does two different things, and this is the one place in the calculator where a blank does not simply mean nothing. Left blank, the plain sum is income multiplied by years, which is the method as it is written down, while the discounted figure still grows the income at the published rate of three percent, because that is the assumption behind the published grid it reproduces. Type a figure, even zero, and both use it.
- Final Expenses
-
When omitted Blank
Unit $ Default Not set Range 0 to 30000
About this input
Optional. What a funeral and the immediate costs around it would take. Leave it blank and nothing is added. The figure shown beside the field is the published median for a funeral with viewing and burial; a cremation is roughly a quarter less and adding a burial vault is roughly a fifth more. Most published statements of this method put final expenses in with the debts rather than with the education.
- Existing Cover
-
When omitted Blank
Unit $ Default Not set Range 0 to 5000000
About this input
Optional. Life cover already in force, including any policy provided at work. Leave it blank and nothing is taken off. This and the savings below are what turn an obligation into an amount of NEW cover to buy, and leaving them out is the single most common reason a rule-of-thumb figure comes out too high.
Outputs
- Offsets
-
Unit $
About this output
The cover already in force plus the savings and investments entered, added together. Both are blank in the state this opens in, so this reads nothing until you fill one of them.
- Rate Per 1000
-
Unit $/year
About this output
The illustrative annual premium for each 1,000 of cover at the applicant's age band, taken from the editable ladder this workbook carries. It is a starting point rather than a price: two reputable published tables differ by about a fifth at age fifty for the same age, term, face amount and health class.
- Table1 Cover Column Axis
-
No unit declared
About this output
The values across the top of the grid: the annual income to replace, in steps of ten thousand either side of yours and never below nothing. Read a column to hold the income fixed and vary the years. The middle entry is the figure you entered.
- Monthly Premium Estimate
-
Unit $/month
About this output
The same estimate divided by twelve. Policies are commonly billed monthly and often cost a little more that way than paying for the year at once, which this does not attempt to model.
- Mortgage Term
-
Unit $
About this output
The M of the method: the balance needed to clear the mortgage, carried through from what you entered. It is a payoff figure, so it already falls as the loan is repaid and needs no separate discounting.
- Need In Years Of Income
-
Unit years
About this output
The cover needed divided by the annual income, so the answer can be compared directly with the multiples everyone quotes. A household with a large mortgage, young children and twenty years of income to replace lands well above ten, which is the point of showing it.
- Table1 Cover Row Input
-
Unit years
About this output
Machinery, and NOT an input. Excel substitutes each value from the row axis into this cell while it fills the grid; the rest of the time it mirrors the years of income to replace. Change that input, never this one: the axis is derived from it, so editing the mirror moves the axis while the table walks and the grid comes out meaningless.
- Table1 Cover Values
-
Unit currency
About this output
The body of the grid: the new cover needed, recomputed for every combination of the two axes. One hundred and twenty-one cells, each one the whole calculation run again. It is a component of the table rather than a result on its own.
- Ten Times Income
-
Unit $
About this output
What the most widely quoted rule of thumb would buy: ten times the annual income. It is shown so it can be compared with the arithmetic rather than trusted, and it is worth knowing that the insurer this figure traces back to publishes it for ages 61 to 65, not for everyone.
- Table1 Cover Column Input
-
Unit currency/yr
About this output
Machinery, and NOT an input. The same for the column axis: Excel substitutes into it while filling the grid, and the rest of the time it mirrors the annual income to replace.
- Table1 Cover Corner
-
Unit currency
About this output
Machinery. Excel requires the formula being tabulated to sit in the grid's top-left corner, where it means nothing to a reader, so it is formatted away. It holds the new cover needed.
- Table1 Cover Row Axis
-
No unit declared
About this output
The values down the left of the grid: the years of income to replace, in steps of two either side of yours and never below nothing. Read a row to hold the years fixed and vary the income. The middle entry is the figure you entered.
- Coverage Needed Discounted
-
Unit $
About this output
The same answer with the income leg valued as a lump sum instead of multiplied out. It is the smaller and the more defensible of the two whenever the money is assumed to earn more after tax than the income grows, which is the usual case, and it is the figure to take to a conversation about how much cover to actually buy.
- Debt Term
-
Unit $
About this output
The D of the method: everything owed apart from the mortgage, carried straight through from what you entered. Final expenses are reported on their own line here rather than folded into this one, so the two can be read separately or added together.
- DIME Overstatement
-
Unit fraction
About this output
How far the plain income leg sits above the discounted one, as a percentage of the discounted figure. At the published assumptions it is about fifteen percent over ten years and seventeen over twenty, and it grows with the number of years. A negative figure means the assumptions you entered make the lump sum larger than the plain sum, which happens when the money earns less after tax than the income grows.
- Age Banded Multiple Need
-
Unit $
About this output
What the same insurer's age-banded rule would buy: thirty times income up to forty, twenty to fifty, fifteen to sixty and ten beyond. Under forty it asks for three times what the ten-times rule asks for, which is why quoting a single multiple without an age tells a household very little.
- Annual Premium Estimate
-
Unit $/year
About this output
What the cover needed would cost in a year at that illustrative rate. It is not a quote and no underwriting is behind it; health, smoking, occupation and the medical exam all move a real price, and a rate from an actual quote entered into the ladder replaces this figure entirely.
- Coverage Needed
-
Unit $
About this output
The headline answer by the method as insurers state it: the whole obligation less what is already in place, floored at nothing. It uses the plain income leg, so it is the DIME figure as the method is usually stated.
- Income Term Discounted
-
Unit $
About this output
The same years of income, valued as the lump sum that would actually be needed to pay them. The money earns interest, the earnings are taxed, the income being replaced rises, and the first year is needed immediately. At the published assumptions twenty years of 60,000 comes to 1,022,981 rather than 1,200,000.
- Income Term Flat
-
Unit $
About this output
The income leg as the method is stated in words: the income to replace, multiplied by the years, or summed as a growing series where a growth rate is given. It is the largest leg in almost every case and it is the one that makes a plain DIME total too high, because a lump sum does not sit idle while it is being paid out.
- Model Status
-
No unit declared
About this output
Reads OK, or explains why the inputs are not valid, or why the answer deserves a second look before it is acted on.
- Education Term
-
Unit $
About this output
The E of the method: the cost per child multiplied by the number of children. It is a total rather than a yearly amount, and it is taken at today's prices with no allowance for education costs rising before the money is needed.
- Final Expenses Term
-
Unit $
About this output
What you entered for a funeral and the costs around it, shown on its own line rather than inside the debt leg. It reads nothing when the input is left blank.
- Gross Need
-
Unit $
About this output
The five legs added together: the whole obligation, before anything already in place is taken off. This is the figure most published statements of the method stop at, and on its own it overstates what has to be bought.
LogicCommons is in beta. If a result, label, or reference looks wrong, tell us here; we read every message.
Methodology
Purpose and model boundary
Use this to work out how much life cover a household actually needs, by adding up what would have to be met and taking off what is already in place. The method has five legs: debts other than the mortgage, the years of income to replace, the mortgage payoff, the cost of educating the children, and funeral and immediate costs.
The years of income are reported TWICE. Once the way the method is usually written down, income multiplied by the years, and once as the lump sum that would actually be needed to pay that income out while the money earns interest, the earnings are taxed and the income being replaced rises. The second is the smaller and the more defensible figure whenever the money earns more after tax than the income grows, which is the usual case.
Two rules of thumb are priced beside the answer for comparison and are never used in it. The illustrative premium is a rate ladder you can edit, not a quote: no underwriting is behind it.
Inputs and units
| Input | Unit | Accepted range | What it means |
|---|---|---|---|
| Annual Income | $/year | 0 through 2,000,000 | The income the household would lose, before tax, each year. The method multiplies it by the years you want replaced, so it drives the largest part of the answer by far. If two people earn and only one is being insured, enter that one person's income. |
| Income Years | years | 0 through 40 | How many years of that income the household would need replaced. Published guidance does not agree: some sources suggest seven to ten years, others twenty to twenty-five where there are young children, and several tie it to the years until the youngest child leaves school. |
| Applicant Age | years | 18 through 75 | The age of the person who would be insured. It chooses a band in the premium ladder and a band in the income multiple ladder, and nothing else in the calculation depends on it. |
| Mortgage Balance | $ | 0 through 1,500,000 | The amount that would clear the mortgage outright today. Not the monthly payment and not the original loan. Enter nothing if you rent or own outright. |
| Other Debts | $ | 0 through 250,000 | Everything else owed: cards, car loans, personal loans, student loans and any other balance that would still have to be settled. The mortgage is entered separately because the method keeps it separate. |
| Final Expenses | $ | 0 through 30,000 | Optional. What a funeral and the immediate costs around it would take. Most published statements of this method put these in with the debts rather than on their own line. |
| Children | count | 0 through 6 | How many children the education figure should be counted for. Enter nothing, or none, and the education leg drops out of the answer entirely. |
| Education Per Child | $ | 0 through 400,000 | The WHOLE cost of educating one child, not a yearly figure. |
| Existing Cover | $ | 0 through 5,000,000 | Optional. Life cover already in force, including any policy provided at work. This and the savings below are what turn an obligation into an amount of NEW cover to buy, and leaving them out is the commonest reason a rule-of-thumb figure comes out too high. |
| Liquid Savings | $ | 0 through 2,000,000 | Optional. Savings and investments that could actually be used: cash, brokerage accounts and anything reachable without a penalty. Retirement accounts are usually left out, because drawing them early is expensive and they are needed later anyway. |
| Replacement Share | % | 0% through 100% | Optional. The share of the income that would have to be replaced. Left blank, the whole income is replaced. A household loses one person's spending as well as their earnings, so anything from half to all of it is defensible; whichever you choose, say so when you quote this answer. |
| Income Growth | % | 0% through 10% | Optional. The rate the income being replaced would have grown at. This is the one place here where a blank does not simply mean nothing: left blank, the plain sum is income multiplied by years, which is the method as written down, while the discounted figure still grows the income at the published rate behind the grid it reproduces. Type a figure, even nothing, and both use it. |
| PV Interest Rate | % | 0% through 12% | Optional. The rate the lump sum is assumed to earn while it is being paid out. A higher rate means a smaller lump sum is enough, so this is the single assumption that moves the discounted figure most. Set it to nothing and the discounted figure rises above the plain sum. |
| PV Tax On Earnings | % | 0% through 40% | Optional. The effective tax the lump sum's investment earnings would attract each year. It only ever reduces what the money earns, so raising it raises the lump sum needed. |
Governing relationships
Four of the five legs are amounts you enter and are carried straight through: the debts other than the mortgage, the mortgage payoff, the education cost multiplied by the number of children, and the funeral and immediate costs. None of them is discounted, because a payoff figure is already what it would take today.
The fifth leg, the years of income, is valued two ways.
The plain version is the income, multiplied by the share to replace, multiplied by the years, or summed as a growing series where a growth rate is given.
The discounted version pays the same income out year by year from a lump sum. The lump sum earns interest, the earnings are taxed, and the income being replaced rises each year, so what is needed is the present value of that rising stream at the after-tax rate. The first year is needed immediately.
The obligation is the five legs added. The cover needed is the obligation less what is already in place, floored at nothing, using the plain income leg, as the method is usually stated. The discounted answer is the same subtraction with the discounted income leg.
The premium is the cover needed multiplied by the rate for the applicant's age band, divided by a thousand, and the monthly figure is that divided by twelve.
Calculation sequence
This is the order in which the reported figures depend on one another. It is not a claim about the order in which the model evaluates itself.
- Carry the debts, the mortgage payoff and the funeral costs through as they were entered.
- Multiply the education cost by the number of children.
- Value the years of income the plain way: income, times the share to replace, times the years, or as a growing series where a growth rate is given.
- Value the same years as a lump sum, paying the rising income out while the balance earns interest and the earnings are taxed.
- Add the five legs, using the plain income leg, to get the whole obligation.
- Add the cover already in force to the savings entered.
- Take that total off the obligation, floored at nothing, to get the cover needed, and do the same with the discounted income leg.
- Price the cover needed at the rate for the applicant's age band, and divide by twelve for the monthly figure.
- Work out the two rules of thumb for comparison and how far the plain income leg sits above the discounted one.
- Rerun the whole calculation across a grid of years and incomes, so the sensitivity to each is visible rather than asserted.
Outputs and interpretation
| Output | Role | Unit | What it means |
|---|---|---|---|
| Coverage Needed | primary | $ | The headline answer by the method as insurers state it: the whole obligation less what is already in place, floored at nothing. It uses the plain income leg. |
| Coverage Needed Discounted | primary | $ | The same answer with the years of income valued as a lump sum instead of multiplied out. It is the smaller and the more defensible of the two whenever the money is assumed to earn more after tax than the income grows, and it is the figure to take to a conversation about how much cover to actually buy. |
| Monthly Premium Estimate | primary | $/month | The annual estimate divided by twelve. Policies are commonly billed monthly and often cost a little more that way than paying for the year at once, which this does not model. |
| Gross Need | detail | $ | The five legs added together: the whole obligation, before anything already in place is taken off. This is the figure most published statements of the method stop at, and on its own it overstates what has to be bought. |
| Debt Term | detail | $ | Everything owed apart from the mortgage. |
| Income Term Flat | detail | $ | The years of income as the method is stated in words. It is the largest leg in almost every case, and it is the one that makes a plain total too high, because a lump sum does not sit idle while it is being paid out. |
| Income Term Discounted | detail | $ | The same years valued as the lump sum that would actually be needed to pay them. |
| Mortgage Term | detail | $ | The balance needed to clear the mortgage. It is a payoff figure, so it already falls as the loan is repaid and needs no separate discounting. |
| Education Term | detail | $ | The cost per child multiplied by the number of children. It is a total rather than a yearly amount, and it is taken at today's prices with no allowance for education costs rising before the money is needed. |
| Final Expenses Term | detail | $ | What you entered for a funeral and the costs around it, on its own line rather than inside the debt leg, because published statements of the method differ on where it belongs. It reads nothing when the input is left blank. |
| Offsets | detail | $ | The cover already in force plus the savings entered. |
| DIME Overstatement | detail | % | How far the plain income leg sits above the discounted one, as a share of the discounted figure. It grows with the number of years. A negative figure means the assumptions you entered make the lump sum larger than the plain sum, which happens when the money earns less after tax than the income grows. |
| Need In Years Of Income | detail | years | The cover needed divided by the annual income, so the answer can be compared directly with the multiples everyone quotes. |
| Ten Times Income | detail | $ | What the most widely quoted rule of thumb would buy. It is shown so it can be compared with the arithmetic rather than trusted. |
| Age Banded Multiple Need | detail | $ | What an age-banded rule of thumb would buy, which asks for a much larger multiple at a younger age. Quoting a single multiple without an age tells a household very little. |
| Rate Per 1000 | detail | $/year | The illustrative annual premium for each thousand of cover at the applicant's age band, taken from an editable ladder. It is a starting point rather than a price. |
| Annual Premium Estimate | detail | $/year | What the cover needed would cost in a year at that illustrative rate. It is not a quote and no underwriting is behind it; health, smoking, occupation and the medical exam all move a real price. |
Model Status reads OK, or explains why the inputs are not valid, or why the answer deserves a second look before you act on it. It is shown alongside the results rather than in place of them.
The shipped starting figures return a CHECK rather than OK, because at that income and that obligation the ten-times rule of thumb would leave a large gap. Every figure above is still reported: the status is about the rule of thumb, not about the calculation.
The calculator also returns a grid that reruns the whole calculation across a range of years and incomes at once. Its axes, corner and body arrive as separate values and are the grid's parts rather than results to read on their own; the page assembles them into the table.
Every figure above is returned by the model. The page arranges and formats them; it computes none of them.
Validation and status logic
These are the states the delivery's own recorded runs exercise, so the table records what this calculator has been observed to return rather than every branch it could take. No recorded run has produced a NOT VALID state: the numeric limits recorded above are what stop an unanswerable one being sent.
| Condition | Returned status |
|---|---|
| The ten-times rule of thumb comes to less than half the calculated need | CHECK: ten times income comes to less than half of what this calculation says is needed, so a policy bought on that rule of thumb would leave a large gap |
| The applicant is older than the last band in the premium ladder | CHECK: the applicant is older than the last age band in the premium table, so the premium estimate is priced at that last band and is likely to understate what a policy would cost |
| Existing cover and savings together exceed the whole obligation | CHECK: the cover already in force and the savings entered come to more than the whole obligation, so this calculation asks for no new cover at all |
| None of the preceding conditions applies | OK |
Assumptions and limitations
- Four of the five legs are amounts you supply, and nothing here checks them. The education figure in particular is a whole-course cost at today's prices with no allowance for education costs rising.
- The plain income leg is the method as written down and is deliberately not discounted, so the two answers can be compared. Neither is more correct than the other; they answer slightly different questions.
- The discounted leg rests on three assumptions you can change, and the rate the money earns moves it more than anything else on the page.
- The premium is read off an editable ladder by age band. It is illustrative: two reputable published tables can differ materially at the same age for the same cover, and nothing here reflects health, smoking, occupation or an underwriting decision.
- The two rules of thumb are shown for comparison and take no part in the calculation.
- Retirement accounts are not counted as savings, which is the usual convention and can be argued either way.
- Nothing here is a recommendation about the type of policy, the term, or whether cover is needed at all.
Restrictions and non-computing states
This calculator enforces the numeric limits recorded above before any figure is worked out, so a value outside them is refused rather than answered.
An applicant older than the last band in the premium ladder is answered rather than refused: the premium is priced at that last band and the status line says the figure is likely to understate a real one.
Errors and warnings
NOT VALID means the inputs do not describe a question this calculator can answer, and the figures beside it should not be relied on. CHECK is not an error: the arithmetic is sound and the figures stand, but something about the combination is worth knowing first, and here the commonest of those is that a familiar rule of thumb would leave a large gap at your figures. The status is shown with the results rather than in place of them, so a flagged answer is still a readable one.
A value the page itself refuses, because it falls outside the limits above, is rejected before the calculation is requested and no figures are returned at all. That is different again from a transport or service failure, where the page reports that the result could not be fetched rather than showing a stale or partial one.
References
One fact underlies the whole arithmetic here and is worth stating from the source rather than assuming: a death benefit is generally not taxed. The Internal Revenue Service puts it this way: "Generally, life insurance proceeds you receive as a beneficiary due to the death of the insured person, aren't includable in gross income and you don't have to report them." That is why the cover needed on this page is a gross figure rather than one grossed up for tax, and why the only tax in the calculation is the tax on what the lump sum EARNS while it is being paid out. See the Service's Life insurance and disability insurance proceeds questions and answers.
The method itself has no official source, and this page does not pretend otherwise. It is a widely taught way of organising the question into four or five parts, and published statements of it differ on details this calculator has had to choose between: whether funeral costs belong with the debts or on their own line, how many years of income to replace, and whether to replace the whole income or the part a household would actually miss. The years of income are the largest leg in almost every case, so the answer is driven by that choice more than by any figure anyone can look up.
The rules of thumb shown beside the answer take no part in it. They are there because they are what households are usually quoted, and comparing them against the arithmetic is the point of showing them.
The premium is read off an editable ladder by age band and is illustrative. Published rate tables from reputable sources differ materially for the same age, term, amount and health class, and none of them reflects health, smoking, occupation or an underwriting decision. Treat the shape of the premium against age as the finding and the level as a starting point, and replace the ladder with figures from a real quote if you have one.
These sources provide background; they do not supply the calculator's assumptions or certify its result. This calculator is informational and is not financial, investment, or tax advice. Results follow directly from the income, the debts, the children and the assumptions you enter, and nothing here recommends a type of policy, a term, or that cover be bought at all.
Found a problem, or have an idea?
Tell us if a result looks wrong, a label is unclear, or something is missing. We read every message.