| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | Taking Trimet's Long Range Forecast Half Seriously | ||||||
2 | Sources per Links | ||||||
3 | |||||||
4 | Annual Growth Rate | 9.50% | 2.60% | ||||
5 | Average Health Insurance Premium | Luxury Tax Threshold for Family Plans | Luxury Tax | ||||
6 | 2012 | ||||||
7 | 2013 | 19,000 | |||||
8 | 2014 | 20,805 | |||||
9 | 2015 | 22,781 | |||||
10 | 2016 | 24,946 | |||||
11 | 2017 | 27,316 | |||||
12 | 2018 | 29,911 | 27,500 | 964 | |||
13 | 2019 | 32,752 | 28,215 | 1,815 | |||
14 | 2020 | 35,863 | 28,949 | 2,766 | |||
15 | 2021 | 39,271 | 29,701 | 3,828 | |||
16 | 2022 | 43,001 | 30,473 | 5,011 | |||
17 | 2023 | 47,086 | 31,266 | 6,328 | |||
18 | 2024 | 51,560 | 32,079 | 7,792 | |||
19 | 2025 | 56,458 | 32,913 | 9,418 | |||
20 | 2026 | 61,821 | 33,768 | 11,221 | |||
21 | 2027 | 67,694 | 34,646 | 13,219 | |||
22 | 2028 | 74,125 | 35,547 | 15,431 | |||
23 | 2029 | 81,167 | 36,472 | 17,878 | |||
24 | 2030 | 88,878 | 37,420 | 20,583 | |||
25 | |||||||
26 | Employee Count | 2,000 | |||||
27 | Total Tax in 2030 | 41,166,484 | |||||
28 | Total Tax Through 2030 | 232,510,036 | |||||