Health and family

Health premium at renewal: a year-by-year table to spot jumps

Keep a year-by-year table of what you paid for each health policy, with the change from last year and a note, so a jump at renewal can be explained.

Editorial illustration for Health premium at renewal: a year-by-year table to spot jumps

A year-by-year premium table lists what you paid for each health policy every year, the change from the previous year in rupees and as a percentage, and a short note on what changed. When the renewal notice arrives with a bigger number, you can see at once whether the jump follows an age band, a claim, an added family member or nothing you can explain, and you can ask the insurer the right question.

What goes in the table?

YearPremium paidChange in rupeesChange in percentNote
2023₹18,000Not applicableNot applicableFirst year, two adults
2024₹19,800₹1,80010.0Same cover, no claim
2025₹19,800₹00.0Same cover
2026₹25,740₹5,94030.0Child added to the policy

These numbers are made up. Check the working: 19,800 minus 18,000 is 1,800, and 1,800 divided by 18,000 is 10 percent. For 2026, 25,740 minus 19,800 is 5,940, and 5,940 divided by 19,800 is 30 percent.

How do you build it in a sheet?

Put the years in column A and the premiums in column B, starting at row 2. In C3, enter =B3-B2 for the change in rupees. In D3, enter =(B3-B2)/B2 and format the cell as a percentage. Copy both formulas down. Leave the first year's change cells blank, since there is nothing to compare with. If you have several policies, repeat the block for each, or add a column for the policy name.

What explains a jump, and what does not?

There are usually a few reasons a premium changes, and your notes column can name each. Common ones to check are a move into a higher age band, a member added or removed, a change in sum insured or optional cover, and the insurer revising its prices. Do not assume which of these applied. Compare the new schedule with the old one, line by line, and look for what is different.

  • Age band: check the age printed on the new schedule.
  • Members: count the people listed against last year.
  • Sum insured and add-ons: compare the cover lines.
  • Claim in the past year: note it, but do not assume it explains the change.
  • Insurer notice: read any revised pricing letter that came with the renewal.

What should you do when the notice arrives?

  1. Add the new premium to your table the same day.
  2. Look at the percentage change, and read your note column for what you expected.
  3. Compare the schedule's cover lines and members with last year's.
  4. If something is unexplained, ask the insurer, and note the date you asked.
  5. Decide whether to renew as is, change the cover or look at other options with a licensed adviser, before the due date and the grace period you noted.

Can an app help with the table?

SpendixAI's reports can list the payments you made under a health insurance category by year, once the statements are imported and the rows reviewed. You can then copy the yearly totals into your table, and keep the notes about age band or added members in the sheet, which is where they belong.

Add a column for the total premium per insured member, so a rise caused by an extra person does not look like a price rise. In the made-up table above, 2025 had two members at ₹19,800 in total, so ₹9,900 each, while 2026 had three members at ₹25,740, so ₹8,580 each. The total rose, but the cost per member fell, which is a more useful thing to know.

Keep these with the table

  • Each year's renewal notice and premium receipt.
  • The policy schedule showing members and cover.
  • Any reply from the insurer about a change.
  • A note of the date you paid and the date the policy renewed.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports