| Description | PPO | HSA | Tax bracket = | .3 30% | HSA Interest = HSA Interest = | .05 5% | | | jonboy |
| Monthly Premium | 105 $105.00 | 105 $105.00 | This is often the monthly amount your employer requires you to contribute. This is often the monthly amount your employer requires you to contribute. | | | | | | |
| x 12 = Annual Insurance Cost | 1260 $1,260.00 | 1260 $1,260.00 | This is calculated based on the monthly amount entered above. This is calculated based on the monthly amount entered above. | | | | | | |
| + HSA deposit | N/A | 2600 $2,600.00 | This should represent the annual amount you plan to contribute to the HSA. This should represent the annual amount you plan to contribute to the HSA. | | | | | | |
| Assumed annual medical and dental expenses not covered by insurance | 0 $0.00 | 0 $0.00 | Estimate your medical/dental out-of-pocket expenses. Coverages may vary between the PPO and HSA. Estimate your medical/dental out-of-pocket expenses. Coverages may vary between the PPO and HSA. | | | | | | |
| TOTAL OUTLAY | 1260 $1,260.00 | 3860 $3,860.00 | This is annual amount spent, calculated based on the data entered above. This is annual amount spent, calculated based on the data entered above. | | | | | | |
| HSA balance from previous years | N/A | 0 $0.00 | If you are past the first year of having an HSA, use this to indicate your account balance. If you are past the first year of having an HSA, use this to indicate your account balance. | | | | | | |
| HSA balance at end of year | N/A | 2600 $2,600.00 | This calculation shows what your balance is expected to be, based on the numbers entered above. This calculation shows what your balance is expected to be, based on the numbers entered above. | | | | | | |
| Tax savings | N/A | 780 $780.00 | Cell E1 above indicates the assumed tax bracket. Change this to change your estimated tax savings. Cell E1 above indicates the assumed tax bracket. Change this to change your estimated tax savings. | | | | | | |
| Est. Interest Earned | N/A | 21.666666666666668 $21.67 | Cell G1 above is the anticipated interest rate on your HSA balance. Change this to alter your estiamted interest earned. Cell G1 above is the anticipated interest rate on your HSA balance. Change this to alter your estiamted interest earned. | | | | | | |
| Net Cost | 1260 $1,260.00 | 480 $480.00 | This calculated row shows the total cost for each option (the lower the better)! This calculated row shows the total cost for each option (the lower the better)! | | | | | | |
| | | | | | | | | |
| Interest Table | Interest | Balance | | | | | | | |
| Jan | 10.833333333333334 $10.83 | 216.66666666666666 $216.67 | 216.66666666666666 | #VALUE! | | | | | |
| Feb | $0.00 | 216.66666666666666#VALUE! 216.66666666666666#VALUE! | | | | | | | |
| Mar | 10.833333333333334 $10.83 | 216.66666666666666 $216.67 | | | | | | | |
| Apr | $0.00 | #VALUE! | | | | | | | |
| May | $0.00 | #VALUE! | | | | | | | |
| Jun | $0.00 | #VALUE! | | | | | | | |
| Jul | $0.00 | #VALUE! | | | | | | | |
| Aug | $0.00 | #VALUE! | | | | | | | |
| Sep | $0.00 | #VALUE! | | | | | | | |
| Oct | $0.00 | #VALUE! | | | | | | | |
| Nov | $0.00 | #VALUE! | | | | | | | |
| Dec | $0.00 | #VALUE! | | | | | | | |
| Totals | 21.666666666666668 $21.67 | #VALUE!NaN $0.00 | | | | | | | |
| | | | | | | | | |
