8885 Tax Credit - Excel

							                                       Johnson County Property Tax Bills by Ta
                                                         Pay 2005
Assessment and Deductions
Median Home Value, 2000 Census           122,500
Assessment-Sales Ratio                     0.988
Gross Assessed Value                     121,030
Homestead Deduction                       35,000
Mortgage Deduction                         3,000
Net Assessed Value                        83,030

Tax Rate, Credits and Tax Bill




Tax District                           Tax Rate Gross Tax PTRC Rate    PTRC
001 - BLUE RIVER TWP                       1.7792    1,477   35.1136      519
002 - EDINBURG TOWN-EDINBURG LIBRARY       3.5533    2,950   28.9162      853
004 - BLUE RIVER TWP-AMITY FPD             1.8843    1,565   34.1658      535
005 - CLARK TWP                            2.3609    1,960   19.4759      382
006 - CLARK TWP-NEEDHAM FPD                2.3874    1,982   19.8501      393
007 - CLARK TWP-WHITELAND FPD              2.4104    2,001   19.3443      387
008 - FRANKLIN TWP                         1.7426    1,447   28.9074      418
009 - FRANKLIN CITY-FRANKLIN TWP           2.5811    2,143   25.9727      557
010 - WHITELAND TOWN-FRANKLIN TWP-WF       2.0355    1,690   27.0935      458
011 - FRANKLIN TWP-AMITY FPD               1.8154    1,507   28.4410      429
012 - FRANKLIN TWP-NEEDHAM FPD             1.7582    1,460   29.1209      425
013 - FRANKLIN TWP-BARGERSVILLE FPD        1.8959    1,574   27.1923      428
014 - FRANKLIN TWP-WHITELAND FPD           1.7812    1,479   28.3165      419
015 - HENSLEY TWP                          1.7741    1,473   29.5392      435
016 - TRAFALGAR TOWN-HENSLEY TWP           2.1656    1,798   27.5363      495
017 - NEEDHAM TWP-NEEDHAM FPD              1.7498    1,453   29.1756      424
018 - FRANKLIN CITY-NEEDHAM TWP            2.5727    2,136   25.9986      555
019 - NEEDHAM TWP-AMITY FPD                1.8070    1,500   28.4901      427
020 - NINEVEH TWP-NINEVEH FPD              1.7761    1,475   29.5390      436
021 - PRINCES LAKES TOWN-NINEVEH FPD       2.2361    1,857   27.8885      518
022 - TRAFALGAR TOWN-NINEVEH TWP           2.1704    1,802   27.5176      496
023 - PLEASANT TWP-CP SCHOOL               2.3761    1,973   19.6050      387
024 - PLEASANT TWP-GREENWOOD SCHOOL        1.6822    1,397   29.4683      412
025 - GRNWD CITY-PLEAS TWP-CP SCHOOL       2.8954    2,404   18.0239      433
026 - GRNWD CITY-PLEAS TWP-GRNWD SCH       2.2015    1,828   25.0614      458
027 - NEW WHITELAND TOWN                   2.8532    2,369   20.1093      476
028 - WHITELAND TOWN-PLEAS TWP-WHITE       2.6571    2,206   19.2383      424
029 - FRANKLIN CITY-PLEASANT TWP           3.2027    2,659   19.6769      523
030 - GRNWD CITY-PLEAS TWP-CP SCHOOL       2.8813    2,392   18.1232      434
031 - PLEASANT TWP-CP SCHOOL-GRNWD L       2.3902    1,985   19.4760      387
032 - PLEASANT TWP-GRNWD SCHOOL-GRNW       1.6963    1,408   29.2022      411
033 - PLEASANT TWP-WHITELAND FPD           2.4028    1,995   19.3157      385
034 - UNION TWP                            1.7528    1,455   28.8530      420
035 - BARGERSVILLE TOWN-UNION TWP-BF       2.5114    2,085   24.0417      501
036 - UNION TWP-BFPD                          1.8932                        1,572        27.2204        428
037 - WHITE RIVER TWP-BFPD                    1.9466                        1,616        26.8609        434
038 - WHITE RIVER TWP-WHITE RIVER FP          1.9848                        1,648        25.9591        428
039 - BARGERSVILLE TOWN-WHITE RIVER           2.5648                        2,130        23.8349        508
040 - GRNWD CITY-WHITE RIVER TWP-CNT          2.3104                        1,918        24.6620        473
041 - GRNWD CITY-WR TWP-CG SCH-CNTY           2.3583                        1,958        23.1197        453
042 - GWD CITY-PLEAS TWP-GWD SCH-CO           2.1874                        1,816        25.2376        458
043 - GRNWD CITY-WR TWP-GRNWD SCH-CO          2.1933                        1,821        25.2206        459
044 - HENSLEY FPD-FRANKLIN TWP                1.7555                        1,458        28.8204        420
                                              3.4835
046 - EDINBURG TOWN-BLUE RIVER TWP-COUNTY LIBRARY                           2,892        29.2798        847
047 - GWD CITY-CP-CLARK TWP-CO LIB            2.8816                        2,393        18.1361        434

Note: Median Home Value for this county is from the 2000 U.S. Census.
Assessment-Sales Ratio is the median assessment to sales price ratio, from the State Equalization Study.
Counties with Assessment-Sales Ratios listed as "0" have studies that are incomplete. Gross assessed values are assumed e
Gross Assessed Value is the product of the Median Home Value and the Assessment Ratio.
Net Assessed Value is Gross Assessed Value less Deductions/Exemptions. Homestead deduction cannot exceed 50% of gros
Tax Districts are areas within a county with particular combinations of government units. The district Tax Rate is the sum of the
Gross Tax is the District Tax Rate times Net Assessed Value.
Property Tax Replacement Credit Dollars are the PTRC Rate times the Gross Tax; they are subtracted from the Gross Tax.
The Homestead Credit Rate is multiplied by the Tax After PTRC. Homestead Credit dollars are subtracted from Tax After PTR
Rank, All Districts is the rank, from highest to lowest net tax, among all of Indiana's 1,960 tax districts.
Net Tax, Half the Median Value is the tax bill calculation starting with a home value equal to half the county's median.
Net Tax, Twice the Median Value is the tax bill calculation starting with a home value equal to twice the county's median.

Prepared by Larry DeBoer, Agricultural Economics, Purdue University, using Indiana Department of Local
Government Finance rate information, available on the DLGF website, at www.in.gov/dlgf.
erty Tax Bills by Tax District
ay 2005




                                                                   Net Tax, Net Tax,
                                                          Rank     Half the Twice the
                        State/Local Home-                Among     Median    Median
         Gross Tax -    Homestead    stead              All 1,960   Home     Home
            PTRC        Credit Rate  Credit  Net Tax    Districts   Value    Value
                  959         9.5821      92      867          588       285    2,130
                2,097        17.1357     359    1,738           48       571    4,271
                1,030        10.1458     105      925          502       304    2,275
                1,578         5.9596      94    1,484           90       487    3,648
                1,589         6.5102     103    1,485           89       488    3,650
                1,614         6.0941      98    1,516           79       498    3,725
                1,029         9.3146      96      933          495       306    2,293
                1,586        13.0255     207    1,380          133       453    3,391
                1,232        10.3482     128    1,105          297       363    2,715
                1,079         9.6583     104      974          427       320    2,395
                1,035         9.7927     101      933          494       306    2,294
                1,146         9.0435     104    1,042          358       342    2,562
                1,060         9.0799      96      964          443       316    2,369
                1,038         9.6062     100      938          484       308    2,306
                1,303        11.3364     148    1,155          259       379    2,839
                1,029         9.7488     100      929          498       305    2,282
                1,581        13.0089     206    1,375          135       451    3,380
                1,073         9.6157     103      970          433       318    2,383
                1,039         9.6328     100      939          482       308    2,308
                1,339        12.3865     166    1,173          239       385    2,883
                1,306        11.3654     148    1,158          255       380    2,845
                1,586         6.1836      98    1,488           88       488    3,657
                  985         9.0113      89      896          545       294    2,203
                1,971         6.8658     135    1,835           31       603    4,511
                1,370         9.1986     126    1,244          195       408    3,057
                1,893         8.9698     170    1,723           50       566    4,234
                1,782         7.1949     128    1,654           59       543    4,064
                2,136         9.7075     207    1,929           27       633    4,740
                1,959         6.9187     136    1,823           32       599    4,481
                1,598         6.1240      98    1,500           86       492    3,687
                  997         8.8825      89      909          519       298    2,233
                1,610         6.0220      97    1,513           80       497    3,718
                1,035         9.3810      97      938          483       308    2,306
                1,584        10.2446     162    1,422          110       467    3,494
                       1,144          9.0481          104      1,041   360   342   2,557
                       1,182          8.0983           96      1,086   315   357   2,670
                       1,220          7.4299           91      1,130   274   371   2,776
                       1,622          9.5242          154      1,467    93   482   3,607
                       1,445          8.7820          127      1,318   158   433   3,240
                       1,505          7.3474          111      1,395   124   458   3,428
                       1,358          9.2954          126      1,232   201   404   3,027
                       1,362          9.3225          127      1,235   198   405   3,035
                       1,038          9.3752           97        940   477   309   2,311
                       2,045         17.3197          354      1,691    55   555   4,156
                       1,959          6.9700          137      1,822    33   598   4,478



assessed values are assumed equal to home values.

tion cannot exceed 50% of gross assessed value.
istrict Tax Rate is the sum of the tax rates of these units.

btracted from the Gross Tax.
e subtracted from Tax After PTRC to get the Tax Bill.

f the county's median.
wice the county's median.