Build a quote comparison sheet that compares like with like

A quote comparison sheet is a grid with one column per quote and one row per feature that changes the value of the policy. The point is to make every column describe the same thing, so that the only remaining difference is price and the contract terms that price depends on. Most bad comparisons are not arithmetic errors; they are comparisons of two different products that happen to share a name.

This post gives you the rows, explains why each one is there, and then fills in a sheet for two hypothetical quotes so you can see how a cheaper-looking quote can end up costing more. The tool life insurance quote comparison worksheet covers the same ground interactively; this walk-through is for when you want to understand each row before you fill it in.

Why a sheet beats a pile of emails

Quotes arrive in different shapes. One is a web page with a monthly price. Another is a PDF from an agent that shows an annual premium and a list of riders. A third is a phone call. Each leaves out something the others state, and the missing item is often the one that explains a price gap.

Putting everything in a single grid does three things:

• It shows blanks. If you cannot fill in a cell for a quote, you have found a question to ask before you decide.
• It forces the same unit. Monthly against annual, or total over the term against cost per year, is where many comparisons quietly go wrong.
• It separates what you chose from what the seller assumed. You choose the face amount and term; the seller assumes your rate class, your tobacco status and sometimes your payment method.

The method below follows the same logic as the guide on how to compare life insurance quotes fairly, laid out as a form you can reuse.

The rows of the sheet

Build the grid with one column for each quote, and these rows. Keep a "source" note under each quote column: where the figures came from (a web page, an agent's PDF, a phone call) and the date, because quotes expire.

Block 1: what you are buying

1. Product type. Level term, decreasing term, return-of-premium term, annual renewable term, or something else. Write it exactly as the quote labels it.
2. face amount (the death benefit). The quote must show the same figure in every column. If one quote is $500,000 and another is $450,000, adjust one of them before comparing.
3. Term length. Ten, 15, 20 or 30 years. Note whether the premium is level for the whole term or only for part of it.
4. Issue age and policy date. Small differences in age can move a price; make sure all quotes assume your actual age.

Block 2: who the quote assumes you are

1. rate class assumed. Preferred plus, preferred, standard plus, standard, or a tobacco class. This row decides more price gaps than any other. An online engine often shows its best class by default; an agent may quote the class they expect after reading your health history.
2. Tobacco and nicotine status. Written as the quote states it, including how the insurer treats vaping or occasional cigars.
3. Health answers used. Did the quote use your actual height, weight and blood pressure, or generic assumptions? If it is an estimate, mark it as one.
4. Underwriting route. Full underwriting with an exam, accelerated underwriting, or a no-exam product. Offers from different routes are not always interchangeable in price or in the maximum amount available.

Block 3: what the price really is

1. Premium and payment mode. Monthly, quarterly, semiannual or annual, and the amount. Write the mode in the cell next to the figure.
2. Annual cost. Convert everything to a yearly number. For monthly quotes, multiply by 12. For an annual quote, copy it. Where an insurer shows both a monthly and an annual price, record both, because the monthly total is normally higher; see paying life insurance monthly vs annually.
3. Policy fee. Some quotes build a flat annual fee into the premium and some show it separately. Add it if it is separate.
4. Cost per $1,000 of coverage per year. Annual cost divided by face amount in thousands. This is a quick yardstick for comparing quotes of different sizes.
5. Total over the term. Annual cost times the number of years of level premium. This is the figure that shows the real size of the commitment.

Block 4: what is guaranteed

1. Is the premium guaranteed level? For term, the answer should normally be yes for the whole level period. If a quote shows a premium that can change, that is a different product.
2. What happens after the level period? Look for a statement on renewal: whether the policy continues year by year, at what kind of price, and whether it is guaranteed renewable. The guide on renewing term life insurance after the level period ends explains why the later prices are usually far higher.
3. conversion privilege. Whether you can convert to permanent coverage without a new health exam, the last date you can do so, and the maximum amount. Deadlines vary a lot; some end with the level period, others earlier. See converting term life to permanent: how the conversion option works.
4. Free-look period. The number of days you can cancel for a refund after delivery. It is usually stated in the policy, not the quote, so mark it "ask" if the quote is silent.

Block 5: riders and company details

1. Included riders. List each one and whether it is free or priced. A common example is a waiver of premium rider. A quote that includes one and a quote that does not are not the same product.
2. Priced riders. For each optional rider you actually want, write its extra cost separately.
3. Insurer financial-strength rating and agency. Record the rating, the agency and the date you looked. Ratings change; see financial strength rating.
4. Seller type. Direct from the company, an independent agent or broker, an online marketplace. It does not change the policy, but it tells you who will service your questions.
5. Expiry of the quote. The date after which the figure no longer holds.

Filling in the sheet: two hypothetical quotes

The two quotes below are invented to show how the method works. They are illustrations, not market prices, and they do not describe any real insurer.

Say Maya, 36, wants $500,000 of 20-year level term coverage for her family. She receives two quotes.

• Quote A comes from an online marketplace. It shows $27 a month. The fine print says it assumes the preferred class and includes no riders. Conversion is allowed only during the first 10 years.
• Quote B comes from an independent agent. It shows $31 a month. The agent has read Maya's health history and quoted standard plus. It includes a waiver of premium rider at no extra charge. Conversion is allowed until the end of year 15.

Here is the filled-in sheet:

The arithmetic: Quote A is $27 times 12 months, which is $324 a year, and $324 times 20 years is $6,480. Quote B is $31 times 12, which is $372 a year, and $372 times 20 is $7,440. Cost per $1,000 is the annual cost divided by 500 (the face amount in thousands): $324 divided by 500 is $0.648, and $372 divided by 500 is $0.744.

On the surface, A is cheaper by $4 a month, or $960 across 20 years ($7,440 minus $6,480). But the sheet shows that the two columns are not equal yet.

Adjusting for what the quotes leave out

Maya works through three adjustments.

Adjustment 1: the rate class. Quote A assumes preferred, but Maya's health history suggests standard plus is more likely. She asks the marketplace what the same policy would cost at standard plus. The answer, in our hypothetical, is $33 a month. That is $396 a year ($33 times 12) and $7,920 over 20 years ($396 times 20).

Adjustment 2: the waiver of premium. Quote A has no waiver rider. Maya asks what it would add. In our hypothetical, it adds $2 a month, so the adjusted Quote A is $35 a month, or $420 a year ($35 times 12) and $8,400 over 20 years.

Adjustment 3: the conversion deadline. This one does not change the price, but it changes the value. Maya expects she might want to convert part of the policy if her income grows. Quote B's conversion window is five years longer. She writes that in the "value" notes rather than trying to turn it into dollars.

The adjusted sheet:

After the adjustments, Quote B is $4 a month cheaper, not more expensive: a $960 advantage across the term ($8,400 minus $7,440), plus a longer conversion window. The "cheap" quote was cheap because it described a different person and a thinner product.

This is a made-up case, and the real result could go the other way. A marketplace's preferred offer may be real if the applicant truly qualifies, and an agent's quote may be higher for reasons unrelated to class. The sheet does not tell you which seller is better. It tells you what to ask each one.

Reading the totals without fooling yourself

A few habits keep the numbers honest.

• Compare on the same payment mode. If you compare one company's annual premium with another's monthly premium multiplied by 12, you are comparing different things. Record both modes when available.
• Treat "total over the term" as a commitment, not a price tag. A term policy is a service you pay for, not an investment; you do not get the total back unless you bought a return-of-premium policy, which is a different product with a much higher premium.
• Do not average away a guarantee. If a quote has a lower price but a premium that can rise during the term, no total can be computed. The sheet should show a question mark there.
• Watch out for tiny rate-class gaps. A policy that is $2 a month cheaper at preferred may be several dollars more at the next class down. Knowing how close you are to the boundary matters; the post on borderline rate class cases: when a few points change your price works through that.

Questions to ask when a cell is blank

For each blank cell, the question is usually short. Here are the ones that come up most often.

1. "Which rate class does this price assume, and what would it be if I came in one class lower?"
2. "Is this premium guaranteed to stay level for the whole term, in writing?"
3. "What is the last date I can convert without a new exam, and to which products?"
4. "Which riders are included in this price, and which are extra?"
5. "Is this quote based on my own health answers or on a default?"
6. "Does the monthly price include any fee, and what is the annual price?"
7. "What is the free-look period, and what happens to my money if I cancel inside it?"

Ask in writing when you can. A reply in an email is easier to attach to your sheet than a phone call, and it is a record if the delivered policy differs from what you were told.

When the sheet is finished

When every cell is filled in and the quotes are normalized, the choice is usually clearer, but it is still a judgment. Two quotes with the same class, the same riders and the same guarantees may differ by a few dollars; then the seller's service, the insurer's financial strength and your comfort with the company matter more than the last few dollars. If the quotes still differ in ways you cannot explain, that is the moment to ask an independent agent or a fee-only planner to review them, or to contact your state insurance department for general questions about a company or a sales practice.

Keep the sheet after you buy. When the policy arrives, check it against the column you chose; the first 30 days after delivery are the time to catch a mismatch, and the post on illustration versus delivered policy: checking they match shows how.

Key takeaways

• A comparison sheet works when every column names the same face amount, term, rate class, riders and payment mode; mismatches in the rate-class row explain most price gaps.
• Convert every quote to an annual cost, a cost per $1,000 and a total over the level period so prices can be compared in one unit.
• In the hypothetical example, a $27 quote became $35 after adjusting to the likelier rate class and adding the missing rider, making the $31 quote cheaper by $960 over 20 years.
• Conversion deadlines, renewal terms and free-look periods change a policy's value without changing its price; record them as rows even if they cannot be turned into dollars.
• Every blank cell is a question for the seller; get the answers in writing and keep the sheet to check the policy when it arrives.