| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Enter your plan features here | |||||||||||||||||||||||||
2 | PPO Plan | HD/HSA Plan | ||||||||||||||||||||||||
3 | Monthly Premium | $47 | $35 | |||||||||||||||||||||||
4 | Annual Deductible | $750 | $1,700 | |||||||||||||||||||||||
5 | Co-insurance rate | 20% | 20% | |||||||||||||||||||||||
6 | Annual Out of pocket max | $3,500 | $4,200 | |||||||||||||||||||||||
7 | Annual Employer contribution to HSA | $1,000 | ||||||||||||||||||||||||
8 | Employee contribution to HSA | $1,000 | For 2026 maximum employee contribution is $4,400 and maximum family $8,750 | |||||||||||||||||||||||
9 | ||||||||||||||||||||||||||
10 | Tax Rates | |||||||||||||||||||||||||
11 | Federal | 24% | ||||||||||||||||||||||||
12 | State | 0% | ||||||||||||||||||||||||
13 | FICA | 7.65% | ||||||||||||||||||||||||
14 | Total | 31.65% | ||||||||||||||||||||||||
15 | ||||||||||||||||||||||||||
16 | Enter annual healthcare spend | PPO Net cost | HSA Plan | |||||||||||||||||||||||
17 | $ 930 | $1,350 | $34 | |||||||||||||||||||||||
18 | ||||||||||||||||||||||||||
19 | ||||||||||||||||||||||||||
20 | ||||||||||||||||||||||||||
21 | ||||||||||||||||||||||||||
22 | ||||||||||||||||||||||||||
23 | ||||||||||||||||||||||||||
24 | ||||||||||||||||||||||||||
25 | ||||||||||||||||||||||||||
26 | ||||||||||||||||||||||||||
27 | ||||||||||||||||||||||||||
28 | ||||||||||||||||||||||||||
29 | ||||||||||||||||||||||||||
30 | ||||||||||||||||||||||||||
31 | ||||||||||||||||||||||||||
32 | ||||||||||||||||||||||||||
33 | Tables that populate chart | For Chart | ||||||||||||||||||||||||
34 | Healthcare Expenses | PPO Patient Responsibility | Total PPO Premium | Net PPO Cost | HDP Patient Responsibility | HDP Employer Contribution | HDP Premium | Value of Tax Deduction | Net HDHP Cost | Healthcare Expenses | Net PPO Cost | Net HDHP Cost | ||||||||||||||
35 | $500 | $500 | $564 | $1,064 | $500 | ($1,000) | $420 | ($317) | ($397) | $500 | $1,064 | ($397) | ||||||||||||||
36 | $1,000 | $800 | $564 | $1,364 | $1,000 | ($1,000) | $420 | ($317) | $104 | $1,000 | $1,364 | $104 | ||||||||||||||
37 | $1,500 | $900 | $564 | $1,464 | $1,500 | ($1,000) | $420 | ($317) | $604 | $1,500 | $1,464 | $604 | ||||||||||||||
38 | $2,000 | $1,000 | $564 | $1,564 | $1,760 | ($1,000) | $420 | ($317) | $864 | $2,000 | $1,564 | $864 | ||||||||||||||
39 | $3,000 | $1,200 | $564 | $1,764 | $1,960 | ($1,000) | $420 | ($317) | $1,064 | $3,000 | $1,764 | $1,064 | ||||||||||||||
40 | $4,000 | $1,400 | $564 | $1,964 | $2,160 | ($1,000) | $420 | ($317) | $1,264 | $4,000 | $1,964 | $1,264 | ||||||||||||||
41 | $5,000 | $1,600 | $564 | $2,164 | $2,360 | ($1,000) | $420 | ($317) | $1,464 | $5,000 | $2,164 | $1,464 | ||||||||||||||
42 | $6,000 | $1,800 | $564 | $2,364 | $2,560 | ($1,000) | $420 | ($317) | $1,664 | $6,000 | $2,364 | $1,664 | ||||||||||||||
43 | $7,000 | $2,000 | $564 | $2,564 | $2,760 | ($1,000) | $420 | ($317) | $1,864 | $7,000 | $2,564 | $1,864 | ||||||||||||||
44 | $8,000 | $2,200 | $564 | $2,764 | $2,960 | ($1,000) | $420 | ($317) | $2,064 | $8,000 | $2,764 | $2,064 | ||||||||||||||
45 | $9,000 | $2,400 | $564 | $2,964 | $3,160 | ($1,000) | $420 | ($317) | $2,264 | $9,000 | $2,964 | $2,264 | ||||||||||||||
46 | $10,000 | $2,600 | $564 | $3,164 | $3,360 | ($1,000) | $420 | ($317) | $2,464 | $10,000 | $3,164 | $2,464 | ||||||||||||||
47 | $11,000 | $2,800 | $564 | $3,364 | $3,560 | ($1,000) | $420 | ($317) | $2,664 | $11,000 | $3,364 | $2,664 | ||||||||||||||
48 | $12,000 | $3,000 | $564 | $3,564 | $3,760 | ($1,000) | $420 | ($317) | $2,864 | $12,000 | $3,564 | $2,864 | ||||||||||||||
49 | $13,000 | $3,200 | $564 | $3,764 | $3,960 | ($1,000) | $420 | ($317) | $3,064 | $13,000 | $3,764 | $3,064 | ||||||||||||||
50 | $14,000 | $3,400 | $564 | $3,964 | $4,160 | ($1,000) | $420 | ($317) | $3,264 | $14,000 | $3,964 | $3,264 | ||||||||||||||
51 | $15,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $15,000 | $4,064 | $3,304 | ||||||||||||||
52 | $16,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $16,000 | $4,064 | $3,304 | ||||||||||||||
53 | $17,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $17,000 | $4,064 | $3,304 | ||||||||||||||
54 | $18,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $18,000 | $4,064 | $3,304 | ||||||||||||||
55 | $19,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $19,000 | $4,064 | $3,304 | ||||||||||||||
56 | $20,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $20,000 | $4,064 | $3,304 | ||||||||||||||
57 | $21,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $21,000 | $4,064 | $3,304 | ||||||||||||||
58 | $22,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $22,000 | $4,064 | $3,304 | ||||||||||||||
59 | $23,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $23,000 | $4,064 | $3,304 | ||||||||||||||
60 | $24,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $24,000 | $4,064 | $3,304 | ||||||||||||||
61 | $25,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $25,000 | $4,064 | $3,304 | ||||||||||||||
62 | $26,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $26,000 | $4,064 | $3,304 | ||||||||||||||
63 | $27,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $27,000 | $4,064 | $3,304 | ||||||||||||||
64 | $28,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $28,000 | $4,064 | $3,304 | ||||||||||||||
65 | $29,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $29,000 | $4,064 | $3,304 | ||||||||||||||
66 | $30,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $30,000 | $4,064 | $3,304 | ||||||||||||||
67 | $31,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $31,000 | $4,064 | $3,304 | ||||||||||||||
68 | $32,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $32,000 | $4,064 | $3,304 | ||||||||||||||
69 | $33,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $33,000 | $4,064 | $3,304 | ||||||||||||||
70 | $34,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $34,000 | $4,064 | $3,304 | ||||||||||||||
71 | $35,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $35,000 | $4,064 | $3,304 | ||||||||||||||
72 | $36,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $36,000 | $4,064 | $3,304 | ||||||||||||||
73 | $37,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $37,000 | $4,064 | $3,304 | ||||||||||||||
74 | $38,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $38,000 | $4,064 | $3,304 | ||||||||||||||
75 | $39,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $39,000 | $4,064 | $3,304 | ||||||||||||||
76 | $40,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $40,000 | $4,064 | $3,304 | ||||||||||||||
77 | $41,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $41,000 | $4,064 | $3,304 | ||||||||||||||
78 | $42,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $42,000 | $4,064 | $3,304 | ||||||||||||||
79 | $43,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $43,000 | $4,064 | $3,304 | ||||||||||||||
80 | $44,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $44,000 | $4,064 | $3,304 | ||||||||||||||
81 | $45,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $45,000 | $4,064 | $3,304 | ||||||||||||||
82 | $46,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $46,000 | $4,064 | $3,304 | ||||||||||||||
83 | $47,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $47,000 | $4,064 | $3,304 | ||||||||||||||
84 | $48,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $48,000 | $4,064 | $3,304 | ||||||||||||||
85 | $49,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $49,000 | $4,064 | $3,304 | ||||||||||||||
86 | $50,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $50,000 | $4,064 | $3,304 | ||||||||||||||
87 | $51,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $51,000 | $4,064 | $3,304 | ||||||||||||||
88 | $52,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $52,000 | $4,064 | $3,304 | ||||||||||||||
89 | $53,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $53,000 | $4,064 | $3,304 | ||||||||||||||
90 | $54,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $54,000 | $4,064 | $3,304 | ||||||||||||||
91 | $55,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $55,000 | $4,064 | $3,304 | ||||||||||||||
92 | $56,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $56,000 | $4,064 | $3,304 | ||||||||||||||
93 | $57,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $57,000 | $4,064 | $3,304 | ||||||||||||||
94 | $58,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $58,000 | $4,064 | $3,304 | ||||||||||||||
95 | $59,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $59,000 | $4,064 | $3,304 | ||||||||||||||
96 | $60,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $60,000 | $4,064 | $3,304 | ||||||||||||||
97 | $61,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $61,000 | $4,064 | $3,304 | ||||||||||||||
98 | $62,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $62,000 | $4,064 | $3,304 | ||||||||||||||
99 | $63,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $63,000 | $4,064 | $3,304 | ||||||||||||||
100 | $64,000 | $3,500 | $564 | $4,064 | $4,200 | ($1,000) | $420 | ($317) | $3,304 | $64,000 | $4,064 | $3,304 | ||||||||||||||