Loading...
Ammon Foothill MPC_Fiscal Impact Analysis_Galena    August 18, 2021    Pete Evans  Flagship Homes  1250 E 200 S  Suite 1D  Lehi, UT 84043      Dear Mr. Evans,     Attached please find our completed analysis of the projected fiscal impact of the proposed Flagship  Homes project in Ammon, Idaho.    Using conservative assumptions, we project the proposed development will contribute a net revenue  surplus of at least $49,000 to the City of Ammon’s General Fund beginning in the first year and rising  continually thereafter.  A net present value calculation of the fund balance to the City was calculated  using a 3% annual discount rate, resulting in an NPV of $4.1 million over a 15 year period.  As a  secondary calculation, because of the timing of property tax revenues to the City, a modified cash flow  was created.  Under this scenario, the City could experience a funding shortfall in the first two years but  would recover these funds and receive positive cash flows thereafter.  The NPV under this scenario is  also positive at $2.5 million.    The Enterprise Funds including Sewer and Water are budgeted based on fee for service and therefore  will always have the opportunity to adjust their rates to maintain adequate cash flow.  As such, these  funds were not included in this analysis.    We would be happy to meet with the City of Ammon to discuss this analysis and our findings at their  convenience.    Sincerely,       Ozzie Gripentrog  Galena Consulting       Flagship Homes – Ammon, Idaho  Fiscal Impact Analysis  August 2021    Galena Consulting was retained by the Flagship Homes to calculate the fiscal impact to ongoing  operations of the City of Ammon as a result of the Flagship Homes Development in Ammon, Idaho.   Galena has prepared Fiscal Impact Studies for multiple governmental jurisdictions in Idaho and Utah and  used the methodology created for those studies in its development of this analysis.  Flagship Homes was broken down into three distinct projects:    A 3,141 unit residential development consisting of:  o 796 large single‐family homes averaging approximately 3,000 square feet  o 1,848 standard single‐family homes averaging approximately 2,400 square feet  o and 498 townhomes averaging approximately 1,800 square feet   A commercial development consisting of 7.47 acres.  Revenue calculations for the project were based on the following:   Property Taxes ‐ FY 2021 Levy rates for the City of Ammon only.   Residential Assessed Property Values at approximately:  o $700,000 per unit for large single‐family homes  o $430,000 per unit for standard single‐family homes  o And $290,000 for townhomes   Commercial Assessed Property Values at $130 per square foot.   Homeowners Exemption assumed at 80% of single‐family residential construction and 75% of  townhomes, as owner occupied primary homes.  Expenditure calculations were based on the following factors:   FY 2021 City of Ammon Budget   Population data from the State of Idaho.   Variable costs for City services and Residential vs Commercial impacts based on Fiscal Impact  Studies, conducted by Galena, for other Idaho Cities.         Methodology and Results    Galena calculated the average cost per unit (residential housing units and/or commercial acreage) for  each City Service and multiplied that cost by the number of units of development proposed by Flagship  Homes.  This amount was then multiplied by a factor which applied the variable costs of service.  This  factor is vital to a Fiscal Impact as not all services are variable.  For example, if the City were to double in  size, it would not require two Mayors.  It would, however require twice as many police officers.  The  majority of administrative functions are typically fixed, while the majority of police functions are  typically variable.  A final factor that affects costs is related to the mix between residential and  commercial development.  Administrative costs are more heavily impacted by residential development  and police services are basically shared equally between residential and commercial needs.  In this fiscal  impact study, each City service was given an impact factor that is a result of historical studies conducted  by Galena for several cities in Southwestern Idaho.  All of these factors were then reviewed and  modified by City of Ammon staff to ensure they reflect their operations.  As a result of the most standard calculations for impacts, the City of Ammon’s General Fund could  reasonably anticipate a net annual operating surplus of approximately $49,000 in the first full year,  driven by residential development of $46,000 and approximately $3,000 from commercial development.   A net present value calculation of the fund balance to the City was calculated using a 3% annual discount  rate, resulting in an NPV of $4.1 million.  As a secondary calculation, because of the timing of property  tax revenues to the City, a modified cash flow was created.  Under this scenario, the City could  experience a funding shortfall in the first two years but would recover these funds and receive positive  cash flows thereafter.  The NPV under this scenario is also positive at $2.5 million.  One final calculation was created to identify the benefit of this development in relation to its costs  whereby any number greater than one would indicate a net benefit to the city and anything below one  would be a detriment.  This project should be expected to fall in the 1.4 to 1.6 benefit range for the vast  majority of the build out period.      Sensitivity    Newly enacted legislation (originally introduced as HB 389) in Idaho has complicated development  programs for many cities and counties.  Prior to HB 389, cities and counties were able to receive the full  value of annexation and new construction and were not limited in their property tax collections.  This is  now no longer the case.  Annexation and new construction values are limited to 90% of their total value  and are additionally limited to prevent the jurisdiction from raising total property taxes above 8% over  the prior year.  The size of the Flagship development in relation to the size of the City of Ammon will  force the development to moderate their construction plan so that it does not negatively impact the  City.  As such, two models were created for Flagship Homes in an attempt to isolate the optimal buildout  period for the City.      The primary fiscal impact analysis was originally created assuming the completed project at full buildout  over 20 years.  This time frame allowed for the City to stay well below the cap imposed by HB 389 but  was not optimal, either for the City or for Flagship Homes.  A secondary analysis was then conducted to  identify the maximum level of construction that could occur, allowing for 75% of new construction from  Flagship Homes and 25% from all others in the City.  This calculation created a full buildout at just  under16 years and was used for this analysis with the nomenclature “HB 389 CAP Restricted”.  The actual length time for development completion, the actual ratio of primary vs secondary  homeowners and the actual impact factors will have an effect on the overall results.  The first year of a  new development generally has the greatest negative impact to a jurisdiction as the property taxes are  collected in arrears.  The City is required to provide services for tax revenue that will be collected at  least a year into the future.  To quantify the impact, Galena assumed a complete buildout of just over 15 years, with fluctuations  each year to maximize development, and calculated the fiscal impact for the first year.  Under this  scenario, the General Fund would be obligated to provide approximately $44k in services throughout  the City.  The City can choose to not raise their operating budgets by the cost of the additional impacts  for the first year and recognize that their service levels may decline slightly to match costs to funding  sources, as a method to bridge the short‐term deficit.  Another alternative would be to utilize existing  reserves to fund the temporary shortfall.  The City is eminently qualified to make the best decision for  their constituents.    Notes  It should be noted that this analysis was conducted on the fiscal impact of Flagship Homes on the City of  Ammon’s annual operating budgets for the General Fund.  It does not take into consideration the cost of  any offsite capital infrastructure that may be necessitated by the proposed development, as these were  not included within the scope of this assignment.    Galena Consulting  Flagship Homes - Ammon, IdahoFiscal Impact AnalysisSummarySummary Financial Statements2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036RevenueProperty Tax 93,070 191,597 275,512 366,440 465,783 572,285 688,149 812,066 946,712 1,092,508 1,247,984 1,415,244 1,594,955 1,786,131 1,992,281Sales Tax 10,041 23,774 34,841 46,447 58,733 71,476 84,889 98,793 113,465 128,877 144,841 161,570 179,042 197,125 216,133Liquor Tax 7,337 17,304 25,235 33,473 42,124 51,018 60,318 69,883 79,93090,440 100,950 111,771 123,075 134,846 146,974Total Revenue 110,447 232,674 335,588 446,360 566,641 694,780 833,356 980,742 1,140,106 1,311,825 1,493,775 1,688,585 1,897,072 2,118,103 2,355,389ExpendituresLegislative 308 738 1,093 1,474 1,884 2,317 2,780 3,270 3,793 4,353 4,942 5,571 6,241 6,946 7,696Executive 1,982 4,751 7,035 9,490 12,128 14,915 17,901 21,053 24,424 28,025 31,820 35,867 40,180 44,720 49,550Finance 1,916 4,593 6,800 9,173 11,722 14,416 17,303 20,349 23,608 27,08930,757 34,670 38,838 43,226 47,895Clerk 3,059 7,333 10,857 14,647 18,717 23,018 27,627 32,491 37,694 43,25249,109 55,356 62,012 69,018 76,472Planning & Zoning 2,375 5,692 8,428 11,370 14,530 17,868 21,446 25,222 29,261 33,575 38,121 42,970 48,137 53,576 59,363Engineering 3,153 7,558 11,190 15,096 19,290 23,723 28,473 33,487 38,84944,577 50,614 57,052 63,912 71,132 78,815Parks & Rec Fund Tsfr24,574 58,903 87,213 117,652 150,345 184,894 221,914 260,989 302,780 347,426 394,479 444,656 498,120 554,392 614,273Law Enforcement 24,099 57,767 85,531 115,386 147,449 181,332 217,640 255,962 296,945 340,729 386,872 436,081 488,518 543,708 602,435Subtotal 61,466 147,334 218,147 294,288 376,065 462,483 555,084 652,824757,353 869,024 986,715 1,112,223 1,245,958 1,386,717 1,536,499Net Fund Balance 48,982 85,340 117,440 152,072 190,576 232,296 278,272327,917 382,753 442,800 507,060 576,362 651,114 731,386 818,890Benefit/Cost Ratio 1.80 1.58 1.54 1.52 1.51 1.50 1.50 1.50 1.51 1.51 1.51 1.52 1.52 1.53 1.53NPV @ 3% Discount Rate 4,060,5608/16/2021Ammon Fiscal Impact - FINALPage 1 Flagship Homes - Ammon, IdahoFiscal Impact AnalysisSummaryCash Flow Summary (Assuming One Year Lag in Property Taxes)2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036RevenueProperty Tax 93,070 191,597 275,512 366,440 465,783 572,285 688,149 812,066 946,712 1,092,508 1,247,984 1,415,244 1,594,955 1,786,131Sales Tax 10,041 23,774 34,841 46,447 58,733 71,476 84,889 98,793 113,465 128,877 144,841 161,570 179,042 197,125 216,133Other 7,337 17,304 25,235 33,473 42,124 51,018 60,318 69,883 79,930 90,440 100,950 111,771 123,075 134,846 146,974Total Revenue 17,378 134,147 251,672 355,431 467,298 588,278 717,492 856,824 1,005,461 1,166,029 1,338,298 1,521,325 1,717,361 1,926,927 2,149,239ExpendituresLegislative 308 738 1,093 1,474 1,884 2,317 2,780 3,270 3,793 4,353 4,942 5,571 6,241 6,946 7,696Executive 1,982 4,751 7,035 9,490 12,128 14,915 17,901 21,053 24,424 28,025 31,820 35,867 40,180 44,720 49,550Finance 1,916 4,593 6,800 9,173 11,722 14,416 17,303 20,349 23,608 27,08930,757 34,670 38,838 43,226 47,895Clerk 3,059 7,333 10,857 14,647 18,717 23,018 27,627 32,491 37,694 43,25249,109 55,356 62,012 69,018 76,472Planning & Zoning 2,375 5,692 8,428 11,370 14,530 17,868 21,446 25,222 29,261 33,575 38,121 42,970 48,137 53,576 59,363Engineering 3,153 7,558 11,190 15,096 19,290 23,723 28,473 33,487 38,84944,577 50,614 57,052 63,912 71,132 78,815Parks & Rec Fund Tsfr24,574 58,903 87,213 117,652 150,345 184,894 221,914 260,989 302,780 347,426 394,479 444,656 498,120 554,392 614,273Law Enforcement 24,099 57,767 85,531 115,386 147,449 181,332 217,640 255,962 296,945 340,729 386,872 436,081 488,518 543,708 602,435Subtotal 61,466 147,334 218,147 294,288 376,065 462,483 555,084 652,824757,353 869,024 986,715 1,112,223 1,245,958 1,386,717 1,536,499Net Fund Balance (44,088) (13,187) 33,525 61,143 91,233 125,794 162,408 204,000 248,108 297,004 351,584 409,102 471,403 540,210 612,739Benefit/Cost Ratio 0.28 0.91 1.15 1.21 1.24 1.27 1.29 1.31 1.33 1.34 1.36 1.37 1.38 1.39 1.40NPV @ 3% Discount Rate 2,530,4338/16/2021Ammon Fiscal Impact - FINALPage 2 Flagship Homes - Ammon, IdahoFiscal Impact AnalysisProfit/(Loss) by TypeS.F. NBHD @ 80% H.O.E. Summary2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036RevenueProperty Tax 36,517 74,915 107,719 142,853 181,166 222,129 266,654 314,165 365,806 421,696 481,183 544,446 612,683 685,155 763,171Sales Tax 3,734 8,841 12,956 17,272 21,841 26,579 31,567 36,737 42,194 47,925 53,861 60,082 66,579 73,304 80,372Liquor Tax 2,728 6,435 9,384 12,447 15,665 18,972 22,430 25,987 29,723 33,631 37,540 41,564 45,767 50,144 54,655Total Revenue 42,979 90,191 130,060 172,572 218,672 267,680 320,652 376,889 437,722 503,252 572,583 646,092 725,030 808,604 898,197ExpendituresLegislative 112 269 399 538 686 844 1,013 1,191 1,382 1,587 1,803 2,030 2,274 2,531 2,805Executive 717 1,715 2,545 3,429 4,379 5,382 6,461 7,600 8,819 10,125 11,501 12,952 14,509 16,149 17,894Finance 708 1,693 2,512 3,384 4,322 5,312 6,377 7,501 8,704 9,993 11,351 12,783 14,320 15,938 17,660Clerk 1,130 2,703 4,011 5,404 6,900 8,482 10,182 11,977 13,897 15,955 18,124 20,410 22,864 25,448 28,197Planning & Zoning 854 2,042 3,031 4,083 5,214 6,409 7,694 9,050 10,501 12,056 13,695 15,423 17,277 19,229 21,307Engineering 1,164 2,785 4,134 5,569 7,112 8,741 10,494 12,344 14,323 16,444 18,679 21,035 23,565 26,227 29,061Parks & Rec Fund Tsfr9,138 21,863 32,446 43,713 55,819 68,611 82,367 96,886 112,419 129,067 146,613 165,106 184,959 205,855 228,098Law Enforcement 8,828 21,120 31,344 42,228 53,922 66,280 79,568 93,594 108,599 124,681 141,631 159,495 178,674 198,860 220,347Subtotal 22,650 54,189 80,422 108,348 138,354 170,062 204,156 240,144 278,643 319,908 363,397 409,234 458,444 510,237 565,369Net Fund Balance 20,329 36,001 49,638 64,224 80,318 97,619 116,495 136,745 159,079 183,344 209,186 236,857 266,586 298,366 332,828S.F. Village @ 80% H.O.E. Summary2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036RevenueProperty Tax 46,196 95,306 136,943 182,480 232,208 285,599 343,841 406,210 473,861 547,281 625,657 710,328 801,126 897,802 1,002,047Sales Tax 5,361 12,693 18,602 24,799 31,359 38,162 45,324 52,747 60,580 68,810 77,333 86,265 95,593 105,248 115,397Liquor Tax 3,917 9,239 13,473 17,872 22,491 27,239 32,205 37,311 42,676 48,287 53,899 59,676 65,712 71,996 78,472Total Revenue 55,475 117,237 169,019 225,150 286,057 351,000 421,369 496,269 577,117 664,378 756,888 856,269 962,431 1,075,047 1,195,915ExpendituresLegislative 161 387 571 772 986 1,213 1,456 1,712 1,986 2,278 2,586 2,917 3,268 3,637 4,029Executive 1,029 2,468 3,646 4,923 6,290 7,736 9,286 10,922 12,668 14,534 16,500 18,607 20,845 23,200 25,701Finance 1,016 2,436 3,598 4,858 6,208 7,635 9,165 10,780 12,502 14,344 16,285 18,364 20,573 22,898 25,366Clerk 1,622 3,889 5,745 7,757 9,913 12,191 14,633 17,211 19,962 22,902 26,001 29,322 32,848 36,560 40,501Planning & Zoning 1,226 2,939 4,341 5,862 7,490 9,212 11,058 13,006 15,084 17,306 19,648 22,157 24,821 27,626 30,604Engineering 1,672 4,009 5,921 7,995 10,216 12,564 15,082 17,739 20,573 23,604 26,798 30,220 33,854 37,680 41,741Parks & Rec Fund Tsfr13,120 31,464 46,473 62,750 80,188 98,616 118,375 139,230 161,480 185,266 210,334 237,193 265,721 295,746 327,626Law Enforcement 12,675 30,395 44,893 60,618 77,463 95,265 114,352 134,499 155,993 178,971 203,187 229,134 256,692 285,697 316,493Subtotal 32,521 77,986 115,188 155,534 198,756 244,432 293,406 345,099 400,249 459,205 521,339 587,913 658,621 733,043 812,061Net Fund Balance 22,954 39,251 53,831 69,617 87,301 106,569 127,963 151,170 176,868 205,172 235,549 268,356 303,809 342,004 383,8558/16/2021Ammon Fiscal Impact - FINALPage 3 Flagship Homes - Ammon, IdahoFiscal Impact AnalysisProfit/(Loss) by TypeTownhomes @ 75% H.O.E. Summary2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036RevenueProperty Tax 7,067 14,630 21,197 28,311 36,214 44,748 53,947 63,846 74,748 86,448 98,990 112,873 127,718 143,571 160,855Sales Tax 946 2,240 3,283 4,376 5,534 6,734 7,998 9,308 10,691 12,143 13,647 15,223 16,869 18,573 20,364Liquor Tax 691 1,630 2,378 3,154 3,969 4,807 5,683 6,584 7,531 8,521 9,51210,531 11,596 12,705 13,848Total Revenue 8,704 18,501 26,857 35,841 45,716 56,289 67,628 79,739 92,969 107,113 122,148 138,628 156,183 174,850 195,067ExpendituresLegislative 28 69 102 138 176 217 260 306 355 407 462 521 583 649 720Executive 182 437 651 878 1,125 1,386 1,661 1,951 2,266 2,596 2,944 3,323 3,722 4,141 4,593Finance 179 432 642 866 1,110 1,368 1,639 1,926 2,236 2,562 2,906 3,279 3,673 4,087 4,533Clerk 286 689 1,025 1,383 1,772 2,184 2,617 3,075 3,570 4,091 4,640 5,236 5,864 6,526 7,238Planning & Zoning 216 521 775 1,045 1,339 1,650 1,978 2,323 2,698 3,091 3,506 3,957 4,431 4,931 5,469Engineering 295 710 1,057 1,426 1,827 2,251 2,698 3,169 3,680 4,216 4,782 5,396 6,044 6,726 7,459Parks & Rec Fund Tsfr2,315 5,576 8,295 11,189 14,338 17,666 21,173 24,873 28,881 33,093 37,53242,357 47,440 52,790 58,549Law Enforcement 2,237 5,387 8,013 10,809 13,851 17,066 20,453 24,028 27,899 31,968 36,257 40,918 45,828 50,996 56,559Subtotal 5,739 13,821 20,560 27,733 35,539 43,788 52,479 61,652 71,584 82,025 93,028 104,987 117,586 130,847 145,121Net Fund Balance 2,965 4,679 6,298 8,108 10,177 12,501 15,149 18,087 21,385 25,088 29,120 33,641 38,597 44,003 49,947General Commercial Summary2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036RevenueProperty Tax 3,289 6,745 9,652 12,797 16,195 19,810 23,707 27,845 32,29837,082 42,155 47,596 53,429 59,602 66,209Sales Tax000000000000000Liquor Tax000000000000000Total Revenue 3,289 6,745 9,652 12,797 16,195 19,810 23,707 27,845 32,298 37,082 42,155 47,596 53,429 59,602 66,209ExpendituresLegislative 6 14 20 27 35 43 51 61 70 81 91 103 115 129 142Executive 54 131 193 261 334 410 493 579 672 770 874 986 1,105 1,230 1,363Finance 13 32 48 64 82 101 122 143 166 190 216 243 273 303 336Clerk 21 51 76 103 131 162 194 228 265 303 344 388 435 484 537Planning & Zoning 79 190 281 380 486 597 717 843 978 1,121 1,272 1,434 1,6071,790 1,983Engineering 22 53 78 106 135 167 200 235 273 313 355 400 448 499 553Parks & Rec Fund Tsfr000000000000000Law Enforcement 360 866 1,281 1,731 2,213 2,721 3,266 3,841 4,454 5,108 5,797 6,535 7,324 8,154 9,035Subtotal 556 1,336 1,978 2,673 3,416 4,202 5,043 5,930 6,876 7,886 8,950 10,089 11,307 12,590 13,949Net Fund Balance 2,733 5,409 7,674 10,124 12,779 15,608 18,664 21,915 25,421 29,196 33,205 37,507 42,121 47,013 52,2608/16/2021Ammon Fiscal Impact - FINALPage 4 Flagship Homes - Ammon, IdahoFiscal Impact AnalysisAbsorptionAbsorption Schedule - HB 389 CAP RestrictedAbsorption Rate 2022 2023 20242025 2026 2027 2028 2029 2030 2031 2032 2033 20342035 2036 TotalS.F. NBHD 6% 7% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 90.9%S.F. Village 6% 7% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 90.9%Townhomes 6% 7% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 90.9%General Commercial 6% 7% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 6% 90.9%Units Occupied/Sq. Ft.S.F. NBHD 44 58 45 45 46 46 47 47 48 49 49 49 50 50 51 796S.F. Village 102 135 103 105 107 107 109 109 111 113 113 115 116 116 118 1,848Townhomes 27 36 28 28 29 29 29 29 30 30 30 31 31 31 32 498General Commercial 17,897 23,75418,222 18,547 18,873 18,873 19,198 19,198 19,52419,849 19,849 20,17420,500 20,500 20,825 325,393Cost per Sq. Ft.S.F. NBHD 225 234 243 253 263 274 285 296 308 320 333 346 360 375 390S.F. Village 180 187 195 202 211 219 228 237 246 256 266 277 288 300 312Townhomes 160 166 173 180 187 195 202 211 219 228 237 246 256 266 277General Commercial 130 135 141 146 152 158 164 171 178 185 192 200 208 216 225Taxable ValueS.F. NBHD 27,621,00037,865,88030,553,84831,776,002 33,781,421 35,132,67837,332,28938,825,58041,237,723 43,780,71645,531,94447,353,222 50,252,39952,262,495 55,440,054608,747,249S.F. Village 39,657,60054,587,52043,314,18645,921,44848,667,98850,614,70753,623,20855,768,13659,063,061 62,532,35065,033,645 68,832,07072,207,83475,096,14779,446,545 874,366,445Townhomes 6,998,4009,704,4487,849,8208,163,813 8,793,593 9,145,3379,511,1509,891,59610,641,993 11,067,673 11,510,38012,369,821 12,864,61413,379,19914,363,217156,255,053General Commercial 2,093,949 2,890,3872,305,943 2,440,9542,583,213 2,686,541 2,842,1172,955,801 3,126,233 3,305,4043,437,6203,633,663 3,840,0763,993,679 4,219,273 46,354,852Subtotal 76,370,949105,048,23584,023,79788,302,21793,826,21497,579,263 103,308,763 107,441,113 114,069,010120,686,143 125,513,588132,188,776139,164,923 144,731,519153,469,0891,685,723,598Property Tax RevenueS.F. NBHD @ 80% H.O.E. 36,517 37,303 30,557 31,902 34,028 35,528 37,861 39,511 42,216 44,916 46,836 48,828 51,90454,092 57,461S.F. Village @ 80% H.O.E. 46,196 47,723 38,778 41,429 44,253 46,425 49,675 52,05455,46459,20461,958 65,902 69,488 72,643 77,310Townhomes @ 75% H.O.E. 7,067 7,352 6,128 6,478 7,053 7,448 7,857 8,281 8,986 9,458 9,948 10,91411,458 12,022 12,977General Commercial 3,289 3,357 2,704 2,855 3,015 3,129 3,303 3,427 3,6173,816 3,960 4,177 4,405 4,571 4,818Total Property Tax Revenue 93,07095,735 78,16782,663 88,35092,52998,695 103,273110,283117,395122,701129,821137,254143,327152,566Sales Tax RevenueState Base - Ammon Population 17,115 17,115 17,115 17,115 17,115 17,115 17,115 17,115 17,115 17,115 17,115 17,115 17,115 17,115 17,115State Total Population - <Avg 666,345 666,345 666,345 666,345 666,345 666,345 666,345 666,345 666,345 666,345 666,345 666,345 666,345 666,345 666,345Ammon Share 2.57% 2.57% 2.57% 2.57% 2.57% 2.57% 2.57% 2.57% 2.57% 2.57% 2.57% 2.57% 2.57% 2.57% 2.57%Annual Excess Distribution 15,050,552 15,351,563 15,658,59415,971,76616,291,202 16,617,02616,949,36617,288,353 17,634,12017,986,803 18,346,53918,713,47019,087,73919,469,49419,858,884Ammon Sales Tax - Excess 386,572 394,303 402,189 410,233 418,438 426,807 435,343 444,050452,930461,989 471,229 480,653 490,267 500,072 510,073Ammon Revised Population 17,572 18,176 18,640 19,110 19,590 20,070 20,558 21,046 21,545 22,052 22,558 23,073 23,592 24,112 24,642Revised State Total Pop. - <Avg 666,802 667,406667,870668,340668,820669,300669,788 670,276670,775 671,282 671,788 672,303 672,822 673,342 673,872Revised Ammon Share 2.64% 2.72% 2.79% 2.86% 2.93% 3.00% 3.07% 3.14% 3.21% 3.28% 3.36% 3.43% 3.51% 3.58% 3.66%Revised Ammon Sales Tax - Excess 396,613 418,077 437,030456,680477,171 498,283 520,232 542,842 566,395 590,866616,070642,223 669,308 697,197 726,207Sales Tax Increment 10,041 23,77434,841 46,44758,733 71,47684,88998,793 113,465128,877144,841161,570179,042197,125216,133Liquor Tax RevenueBase Liquor Tax 275,000282,337 292,304300,235 308,473 317,124326,018 335,318 344,883 354,930365,440376,261 387,565 399,336411,464Liquor Tax Per Capita 16.1 16.5 17.1 17.5 18.0 18.5 19.0 19.6 20.2 20.7 21.4 22.0 22.6 23.3 24.0New Residents 457 604 464 470 480 480 488 488 499 507 507 514 520 520 530Incremental Liquor Tax7,337 9,967 7,931 8,238 8,651 8,894 9,300 9,565 10,047 10,510 10,821 11,30411,771 12,128 12,747New Liquor Tax Revenue 7,337 17,30425,235 33,473 42,12451,01860,31869,883 79,93090,440100,950111,771123,075134,846146,9748/16/2021Ammon Fiscal Impact - FINALPage 5 Flagship Homes - Ammon, IdahoFiscal Impact AnalysisImpact on ExpendituresOperational Impact2022 2023 20242025 2026 2027 2028 2029 2030 2031 2032 2033 20342035 2036Expenditures - TotalLegislative 188,305 193,954199,773 205,766211,939 218,297224,846231,592 238,539 245,696253,066260,658268,478276,533 284,829Executive 720,759 742,382 764,654787,593 811,221 835,558860,624886,443 913,036940,428968,640997,7001,027,6311,058,4591,090,213Finance 889,191 915,867943,343 971,643 1,000,7921,030,8161,061,7411,093,5931,126,4011,160,1931,194,9991,230,8491,267,7741,305,8071,344,981Clerk 141,974146,234150,621 155,139 159,793 164,587169,525 174,611 179,849 185,244190,802 196,526202,422 208,494214,749Planning & Zoning190,723 196,444202,338208,408214,660221,100227,733 234,565 241,602 248,850256,315 264,005 271,925 280,083 288,485Engineering 146,324150,713 155,235 159,892 164,688169,629 174,718179,960185,358190,919 196,647202,546208,622 214,881 221,328Parks & Rec Fund Tsfr706,761 727,964749,803 772,297795,466819,330843,910869,227895,304922,163 949,828978,323 1,007,6721,037,9021,069,039Law Enforcement1,920,5121,978,1282,037,4722,098,5962,161,5542,226,4002,293,1922,361,9882,432,8482,505,8332,581,0082,658,4382,738,1922,820,3372,904,947Subtotal 4,904,5505,051,6875,203,2375,359,3345,520,1145,685,7185,856,2896,031,9786,212,9376,399,3256,591,3056,789,0446,992,7167,202,4977,418,572Expenditures - Variable %Legislative 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%5.0% 5.0%Executive 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0% 10.0%Finance 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%5.0%Clerk 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0%Planning & Zoning50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0%Engineering 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0%Parks & Rec Fund Tsfr65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0%Law Enforcement35.6% 35.6% 35.6% 35.6% 35.6% 35.6% 35.6% 35.6% 35.6% 35.6% 35.6% 35.6% 35.6% 35.6% 35.6%Absorption By TypeS.F. NBHD 5.5% 12.8% 18.4% 24.1% 29.9% 35.7% 41.6% 47.5% 53.5% 59.6% 65.7%71.9% 78.2% 84.5% 90.9%S.F. Village 5.5% 12.8% 18.4% 24.1% 29.9% 35.7% 41.6% 47.5% 53.5% 59.6% 65.7% 71.9% 78.2% 84.5% 90.9%Townhomes 5.5% 12.8% 18.4% 24.1% 29.9% 35.7% 41.6% 47.5% 53.5% 59.6% 65.7%71.9% 78.2% 84.5% 90.9%General Commercial 5.5% 12.8% 18.4% 24.1% 29.9% 35.7% 41.6% 47.5% 53.5% 59.6% 65.7% 71.9% 78.2% 84.5% 90.9%Proportionate ShareS.F. NBHD 36% 36% 36% 36% 36% 36% 36% 36% 36% 36% 36% 36% 36% 36% 36%S.F. Village 52% 52% 52% 52% 52% 52% 52% 52% 52% 52% 52% 52% 52% 52% 52%Townhomes 9% 9% 9% 9% 9% 9% 9% 9% 9% 9% 9% 9% 9% 9% 9%General Commercial 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3% 3%Residential Expenditure ShareLegislative 60.0% 60.0% 60.0% 60.0% 60.0% 60.0% 60.0% 60.0% 60.0% 60.0% 60.0% 60.0% 60.0% 60.0% 60.0%Executive 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0%Finance 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0%Clerk 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0%Planning & Zoning45.0% 45.0% 45.0% 45.0% 45.0% 45.0% 45.0% 45.0% 45.0% 45.0% 45.0% 45.0% 45.0% 45.0% 45.0%Engineering 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0% 80.0%Parks & Rec Fund Tsfr100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0%Law Enforcement65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0% 65.0%Commercial Expenditure ShareLegislative 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0% 40.0%Executive 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0% 50.0%Finance 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0%Clerk 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0%Planning & Zoning55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0% 55.0%Engineering 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0% 20.0%Parks & Rec Fund Tsfr0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%Law Enforcement35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0% 35.0%8/16/2021Ammon Fiscal Impact - FINALPage 6 Flagship Homes - Ammon, IdahoFiscal Impact AnalysisImpact on ExpendituresOperational Impact2022 2023 20242025 2026 2027 2028 2029 2030 2031 2032 2033 20342035 2036S.F. NBHD Variable ExpendituresLegislative 112 269 399 538 686 844 1,013 1,191 1,382 1,587 1,803 2,0302,2742,531 2,805Executive 717 1,715 2,545 3,429 4,379 5,382 6,461 7,6008,819 10,125 11,501 12,952 14,509 16,149 17,894Finance 708 1,693 2,512 3,3844,322 5,312 6,377 7,501 8,7049,993 11,351 12,783 14,32015,93817,660Clerk 1,1302,703 4,011 5,4046,9008,482 10,182 11,977 13,897 15,955 18,12420,41022,86425,44828,197Planning & Zoning854 2,042 3,031 4,083 5,2146,409 7,6949,05010,501 12,05613,695 15,423 17,277 19,229 21,307Engineering 1,1642,785 4,1345,569 7,112 8,741 10,49412,34414,323 16,44418,679 21,035 23,565 26,227 29,061Parks & Rec Fund Tsfr9,138 21,863 32,44643,713 55,819 68,611 82,367 96,886112,419 129,067146,613 165,106184,959 205,855 228,098Law Enforcement8,828 21,12031,34442,22853,922 66,28079,56893,594108,599 124,681 141,631 159,495 178,674198,860220,347Subtotal 22,65054,189 80,422 108,348138,354170,062 204,156240,144278,643 319,908363,397409,234458,444510,237565,369S.F. Village Variable ExpendituresLegislative 161 387 571 772 986 1,213 1,456 1,712 1,986 2,278 2,586 2,917 3,268 3,637 4,029Executive 1,029 2,468 3,646 4,923 6,2907,736 9,286 10,922 12,66814,53416,50018,607 20,845 23,20025,701Finance 1,016 2,436 3,598 4,858 6,208 7,635 9,165 10,78012,502 14,34416,285 18,36420,573 22,89825,366Clerk 1,622 3,889 5,745 7,757 9,913 12,191 14,633 17,211 19,962 22,902 26,001 29,322 32,84836,56040,501Planning & Zoning1,226 2,939 4,341 5,862 7,4909,212 11,05813,00615,08417,30619,64822,157 24,821 27,62630,604Engineering 1,672 4,009 5,921 7,995 10,21612,56415,082 17,739 20,573 23,60426,79830,22033,85437,68041,741Parks & Rec Fund Tsfr13,12031,46446,473 62,75080,18898,616118,375 139,230161,480185,266210,334237,193 265,721 295,746327,626Law Enforcement12,675 30,395 44,893 60,61877,463 95,265 114,352 134,499 155,993 178,971 203,187229,134256,692 285,697316,493Subtotal 32,521 77,986115,188155,534198,756244,432 293,406345,099 400,249 459,205 521,339 587,913 658,621 733,043 812,061Townhomes Variable ExpendituresLegislative 28 69 102 138 176 217 260 306 355 407 462 521 583 649 720Executive 182 437 651 878 1,125 1,386 1,661 1,951 2,266 2,596 2,9443,323 3,722 4,141 4,593Finance 179 432 642 866 1,1101,368 1,639 1,926 2,236 2,562 2,906 3,279 3,673 4,087 4,533Clerk 286 689 1,025 1,383 1,772 2,1842,617 3,075 3,5704,091 4,6405,236 5,8646,526 7,238Planning & Zoning216 521 775 1,045 1,339 1,6501,978 2,323 2,698 3,091 3,506 3,957 4,431 4,931 5,469Engineering 295 710 1,057 1,426 1,827 2,251 2,698 3,169 3,6804,216 4,782 5,396 6,0446,726 7,459Parks & Rec Fund Tsfr2,315 5,576 8,295 11,189 14,33817,66621,173 24,873 28,881 33,093 37,532 42,357 47,44052,79058,549Law Enforcement2,237 5,387 8,013 10,809 13,851 17,06620,453 24,02827,899 31,96836,257 40,91845,82850,99656,559Subtotal 5,739 13,821 20,56027,733 35,539 43,78852,479 61,652 71,58482,025 93,028104,987117,586130,847145,121General Commercial Variable ExpendituresLegislative 6 14 20 27 35 43 51 61 70 81 91 103 115 129 142Executive 54 131 193 261 334 410 493 579 672 770 874 986 1,105 1,2301,363Finance 13 32 48 64 82 101 122 143 166 190 216 243 273 303 336Clerk 21 51 76 103 131 162 194 228 265 303 344 388 435 484 537Planning & Zoning79 190 281 380 486 597 717 843 978 1,121 1,272 1,4341,607 1,7901,983Engineering 22 53 78 106 135 167 200 235 273 313 355 400 448 499 553Parks & Rec Fund Tsfr000000000000000Law Enforcement360 866 1,281 1,731 2,213 2,721 3,266 3,841 4,4545,108 5,797 6,535 7,3248,1549,035Subtotal 556 1,336 1,978 2,673 3,416 4,202 5,043 5,9306,876 7,886 8,95010,089 11,307 12,59013,949Total Variable ExpendituresLegislative 308 738 1,093 1,4741,8842,317 2,7803,2703,793 4,353 4,942 5,571 6,241 6,946 7,696Executive 1,982 4,751 7,035 9,49012,12814,915 17,901 21,053 24,42428,025 31,82035,867 40,18044,72049,550Finance 1,916 4,593 6,8009,173 11,722 14,41617,303 20,349 23,60827,089 30,757 34,67038,83843,22647,895Clerk 3,059 7,333 10,857 14,647 18,717 23,01827,627 32,491 37,69443,252 49,109 55,35662,012 69,01876,472Planning & Zoning2,375 5,692 8,428 11,37014,53017,86821,44625,222 29,261 33,575 38,121 42,97048,137 53,57659,363Engineering 3,153 7,558 11,19015,09619,29023,723 28,473 33,487 38,849 44,577 50,61457,052 63,912 71,132 78,815Parks & Rec Fund Tsfr24,57458,903 87,213 117,652 150,345 184,894221,914260,989 302,780347,426394,479 444,656498,120554,392 614,273Law Enforcement24,099 57,767 85,531 115,386147,449 181,332 217,640255,962 296,945 340,729 386,872 436,081 488,518543,708602,435Total Variable Expenditures 61,466147,334218,147 294,288376,065 462,483 555,084652,824757,353 869,024986,715 1,112,2231,245,9581,386,7171,536,4998/16/2021Ammon Fiscal Impact - FINALPage 7