Canton, Massachusetts · Saved source text
FinCom-20250123T081705
Saved text from 1 of 2 source pages. Transcription and OCR may contain errors; verify figures and wording against the original.
Source page 1
TAX IMPACT of $166.7 MILLION DEBT EXCLUSION PROJECT 11/15/2024 i 1 44,02 1 FY 2024 Values I I I CORRECTED INCORRECT CORRECTED INCORRECT Borrowed Term in Years Interest Rate OTHER POSSIBLE FUNDING SOURCES NEW COLUMN FY 2024 Levy Split NEWCOLUMN 5,79,78'95'5"6oTi,e,14,'g�58,660 725,688 EXISTING EXCLUDED DEBT PAY DOWN IMPACT IMPACT ON AVG. RESIDENTIAL TAX BILL ILL NET OF EXCI-UDED 11D DEBT PAY DOWN IMPACT ON AVG. RI RESIDENT)AL TAX BILL IMPACT ON AVG. RESIDENTIAL TAX BILL COMBINED IMPACT OF EXCLUDED DEBT 1 4" E- )j'/ P -A COMBINED IMPACT OF EXCLUDED DEBT $166300,359 30 4,00% ANNUAL Unused Levy Capacity Pension FUNDED FROM Assessment EXCLUDED Savings DEBT Resident Share 61147741,,��,, 1 39.5226% Unused Levy Residential Commercial Capacity Levy Levy Resident Share Unused Levy Capacity IMPACT ON IMPACT ON RESIDENTIAL COMMERCIAL TAX RATE TAX RATE IMPACT ON AVG. RESIDENTIAL TAX BILL Existing (FY24) Residential Impact On Impact On Avg. Excluded Debt Levy Tax Residential Residential Tax Paid Down Reduction Tax Rate Tax Bill FISCAL BONDS PRINCIPAL BOND DEBT YEAR YEAR OUTSTANDING PAYMENT INTEREST SERVICE 1 2030 $166,700,359 $5,556,679 $6.668,014 $12,224,693 $2,026,832 $0 $10,197,861 $1,225,775 $6,167,401 $2,087,637 $0 $9,914,789 $1,262,549 $5,996,206 $2,150,266 $4,236,877 $5,393,016 $1,300,425 $3,261,556 $2,214,774 $4,236,877 $5,106,240 $1,339,438 $3,088,121 $2,281,217 $4,236,877 $4,817,530 $1,379,621 $2,913,517 $2,349,654 $4,236,877 $4,526,826 $1,421,010 $2,737,707 $2,420,144 $3,851,706 $4,619,240 $1,463,640 $2,793,596 $2,492,748 $3,861,706 $4,324,369 $1,507,549 $2,615,266 $2,567,530 $3,081,365 $4,797660 $1,552,776 $2,901,500 $2,644,556 $3,081,365 $4,498,367 $1,599.359 $2,720,496 $4,030,460 $0.21 $1.06 $154 $158 $163 $168 $173 $178 $183 $189 $194 $200 $254 $261 $269 $277 $286 $294 $303 $312 $322 $331 $886 $867 $528 $510 $492 $474 $485 $467 $494 $476 $986 $971 $634 $619 $605 $590 $605 $590 $621 $607 $2.22 $2.16 $772 $751 $528,885 $553,665 $319,856 $334,842 ($0.06) ($0.06) 1$40') S, 4 /2-1 $732 $709 2 2031 $161,143,680 $5,556,679 $6,445,747 $12,002,426 $3,918,582 $0,22 $1.03 $2,131,460 $0.22 $0.56 3 2032 $155,587,002 $5,556,679 $6,223,480 $11,780,159 $1.17 $1.11 $409 $387 $573,195 $592,725 $346,653 $358,464 ($0.06) ($0.06) 1,95, 43, 'i 4 -5) $365 $342 4 2033 $150,030,323 $5,556,679 $6,01,213 $11,557,892 $2,018,119 K23 $0.53 $1,904,013 $0:24 $0.50 5 2034 $144,473,644 $5,556,679 $5,778,946 $11,335,624 $1.05 $0.99 $365 $343 $606,995 $621,190 $367,095 $375,679 ($0.06) ($0.06) 4 (-3 f�$4` $319 $296 6 2035 $138,916,966 $5,556,679 $5,556,679 $11,113,357 $1,789,119 $0.25 $0.47 $1,825,644 $0,25 $0.48 7 2036 $133,360,287 $5,556,679 $5,334,411 $10,891,090 $1.01 $0.94 $350 $328 $635,723 $650,783 $384,469 $393,577 ($0.07) ($0.07) (S48) iS 491 $302 $278 8 2037 $127,803,609 $5,556,679 $5,112,144 $10,668,823 $1,709,103 $0,26 $0.45 $1,896,160 $0.27 $0�50 $1,777,872 $0.28 $0.47 9 2038 $122,246,930 $5,556,679 $4,889, 877 $10,446,556 $1.04 $363 $846,182 $511,749 ($0.09) 4 $299 10 2039 $116,690,251 $5,556,679 $4,667,610 $10,224,289 $0.98 $341 $856,368 $517,909 ($aoq) S 6 5'�� $276 11 2040 $111,133,573 $5,556,679 $4,445,343 $10,002,022 $2,723,893 $2,896,483 $4,381,646 $1,647,340 $2,649,905 $2,805,610 $2,896,483 $4,077,662 $1,696,760 $2,466.064 $2,889,778 $2,896,483 $3,771,226 $1,747,663 $2,280,740 $2,976,471 $2,896,483 $3,462,266 $1,800,092 $2,093,888 $3,065,765 $2,896,483 $3,150,704 $1,854,095 $1,905,464 $3,157,738 $2,773,229 $2,959,719 $1,909,718 $1,789,961 $3,252,471 $2,711,601 $2,704,347 $1,967,010 $1,635,519 $3,350,045 $2,619,160 $2,476,947 $2,026,020 $1,497,993 $3,450,546 $2,465,092 $2,308,246 $2,086,801 $1,395,967 $3,554,062 $2,277,129 $2,170 426 $2,149,405 $1,312,617 $1,731,740 $0,28 $0.46 $1,611,598 $0,29 $0.43 $0.95 $332 $867,268 $524,501 ($0.09) ($66) $266 $206 $213 $219 $225 $232 $239 $246 $254 $261 5269 $341 $351 $362 $373 $384 $396 $407 $420 $432 $445 $473 $434 $417 $400 $384 $376 $364 $354 $349 $346 $607 $573 $560 $548 $535 $532 $525 $520 $520 $522 12 2041 $105,576,894 $5,556,679 $4,223,076 $9,779,754 $0.89 $0.82 $309 $286 $1,149,168 $1,153,368 $694,987 $697,527 ($0.12) ($0.12) $222 $198 13 2042 $100,020,215 $5,556,679 $4,000,809 $9,557,487 $1,490,487 $0.30 $0.39 $1,368,377 $0,31 $0.36 14 2043 $94,463,537 $5,556,679 $3,778,541 $9,335,220 $0.75 $0.69 $262 $239 $1,153,368 $1,153,368 $697,527 $697,527 ($0.12) ($0.12) -\$8,7 iT � 7' $175 $151 15 2044 $88,906,858 $5,556,679 $3,556,274 $9,112,953 $1,245,240 $032 $0.33 $1,169,758 $0.33 $0.31 16 2045 $83,350,180 $5,556,679 $3,334,007 $8,890,686 $0.64 $0.59 $224 $205 $1,153,368 $1,153,368 $697,527 $697,527 ($0.12) ($0.12) (S87t I t) $137 $117 17 2046 $77,793,501 $5,556,679 $3,111,740 $8,668,419 $1,068,828 $0.34 $0.28 $978,954 $0,35 $0,26 18 2047 $72,236,822 $5,556,679 $2,889,473 $8,446,152 $0.54 $0.50 $188 $175 $1,153,368 $1,153,368 $697,527 $697,527 ($0.12) ($0.12) S 8 fS8 $100 $87 19 2048 $66,680,144 $5,556,679 $2,667,206 $8,223,884 $912,279 $0.36 $0.24 $857,809 $0,37 $0.23 20 2049 $61,123,465 $5,556,679 $2,444,939 $8001,617 $0.47 $164 $1,153,368 $697,527 ($0.12) $77 21 2050 $55,566,786 $5,556,679 $2,222,671 $7,779,350 $3,660,684 $2,049,108 $2,069,558 $2,213,887 $1,251,615 $3,770,505 $1,818,005 $1,968,573 $2,280,303 $1,190,542 $3,883,620 $1,583,020 $1,868,175 $2,348,712 $1,129,824 $4,000,129 $1,349,638 $1,762,782 $2,419,174 $1,066,085 $4,120,132 $1,115,454 $1,654,695 $2,491,749 $1,000,716 $4,243,736 $2,424,278 $2,566,501 $1,466,140 $4,371,048 $2,074,69 $2,643,496 $1,254,724 $4,502,180 $1,721,300 $2,722,801 $1,040,998 $4,637,245 $1,363.968 $2,804,485 $824,892 $4,776,363 $1,002,583 $2,888,620 $606,336 $817,943 $038 $0.22 $778,031 $0,39 $0.21 $0.45 $157 $1,153,368 $697,527 ($0.12) $ 8 7, $69 $277 $286 $1294 $303 $312 $321 $,331 $341 $351 $362 $459 $472 $486 $501 $516 $532 $547 $564 $581 $598 $347 $347 $348 $349 $350 $418 $401 $384 $367 $350 $528 $534 $541 $547 $554 $628 $617 $607 $597 $587 22 2051 $50,010,108 $5,556,679 $2,000,404 $7,557,083 $0.43 $0.41 $149 $142 $1,153,368 $1,153,368 $697,527 $697,527 ($0.12) ($0.12) 8 7 $62 $54 23 2052 $44,453,429 $5,556,679 $1,778,137 $7,334,816 $738,351 $0A1 $0.20 $696,697 $0.42 $0.18 24 2053 $38,896,750 $5,556,679 $1,555,870 $7,112,549 $0.38 $0.36 $134 $125 $1,153,368 $1,153,368 $697,527 $697,527 ($0.12) ($0.12) 8 $46 $38 25 2054 $33,340,072 $5,556,679 $1,333,603 $6,890,282 $653,978 $0.43 $0.17 $958,138 $0.44 $0.25 26 2055 $27,783,393 $5,556,679 $1,111,336 $6,668,014 $0.53 $0.45 $184 $157 $1,153,368 $1,153,368 $697,527 $697,527 ($0.12) ($0.12) (S 5, 7 $96 $70 27 2056 $22,226,715 $5,556,679 $889,069 $6,445,747 $819,975 $0.46 $0,22 $680,303 $0.47 $0.18 28 2057 $16,670,036 $5,556,679 $666,801 $6,223,480 $0,37 $0,30 $130 $103 $1,153,368 $1,153,368 E29,242,776 $697,527 $697,527 ($0.12) ($0.12) (S 8 7'� 8 7 $43 $16 29 2058 $11,113,357 $5,556,679 $444,534 $6,001,213 $539,075 $0.48 $0.14 $396,247 $0.50 $0.10 30 2059 $5,556,679 5,556,679 $222,267 $5,778,946 $0.22 $76 $1,153,368 $697,527 ($0.12) $ 8 7- $166,700,369 $103,354,223 $270,054,582 $96,427,381 $66,057,503 $107,569,698 $58,316,773 $65,055,356 $42,514,341 $10.07 $11.23 $23.43 $8,148 17,685,271 ($3.05) ($2,215) 1 $5,933 $7,304 $12,078 1 $13,237 $18,011 2 'iq $243 $4013 $441 $600 Average Cost Per $1,000 / Year to Taxpayer $0.37 1 $0.78 1 $272 ($0.10) ($73.84) 1 $198 Galvin MS Funding Requirement Estimates V.14,xlsx Opt 9 1$240,26MW GPOS PROJECT PAGE 7