Loading...
Rocking R Ranch Fiscal Impact Analysis - FINAL    November 18, 2021    Kurt Roland, PLS  Eagle Rock Engineering & Land Surveying, PC  1331 Fremont Ave  Idaho Falls, ID 83402      Dear Kurt,     Attached please find our completed analysis of the projected fiscal impact of the proposed Rocking R  Ranch project in Ammon, Idaho.    Using conservative assumptions, we project the proposed development will contribute a net revenue  surplus of at least $6,700 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%, 6% and 9% annual discount rates, resulting in NPV’s of $279,000, $211,000 and $163,000  respectively, 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 year but would recover these funds and receive positive cash flows  thereafter.  The NPV’s under this scenario are also positive at $237,000, $173,000 and $128,000  respectively.    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     Page | 1    Rocking R Ranch Project – Ammon, Idaho  Fiscal Impact Analysis  November 2021    Galena Consulting was retained by the Eagle Rock Engineering to calculate the fiscal impact to ongoing  operations of the City of Ammon as a result of the Rocking R Ranch 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.  Rocking R Ranch was broken down into three distinct projects:    A Residential development consisting of:  o 55 single‐family homes averaging approximately 3,000 square feet  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 $555,000 per unit for single‐family homes   Homeowners Exemption assumed at 80% of single‐family residential construction, as owner  occupied primary homes.  Expenditure calculations were based on the following factors:   FY 2022 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.       Page | 2    Subject Site    Preliminary Plat      Page | 3    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 Rocking R  Ranch.  This amount was then multiplied by the variability of each service, or the degree to which the  City budget for a specific service reacts or increases due to growth.  This factor is vital to a Fiscal Impact  Analysis 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.   For example, 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  analysis, assumptions about variability and land use were based on 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.  At full buildout (3 years), the Rocking R Ranch project is anticipated to add approximately $23 Million in  new taxable value and approximately 170 new residents to the City of Ammon.  This would increase the  size of Ammon by approximately 2% in taxable value and 1% in population.  The methodology in these calculations is straightforward.  The total operating expenditure budget for  the General Fund of the City of Ammon is identified by department.  Although Rocking R Ranch accounts  for a 1% increase in population, it accounts for a nearly 2% increase in taxable value.  As such, Galena  assumed 2% impact on the City Budget, which again is a more conservative approach and allocates more  costs to the project.  This allocated expenditure amount was then segmented into the fixed and variable  components, as mutually agreed upon by City staff and Galena.  Finally, these costs were again  segmented into their residential and commercial components.  Rocking R Ranch is not proposing any  commercial component to their program, so only the residential related costs are included in the  analysis.  Revenues are calculated based on the assessed value of each element reduced to 90% and  then reduced again by the effective homeowners exemption calculation described earlier.  This value is  multiplied by the Ammon City levy rate to generate property tax revenue.  Sales and Liquor taxes are  formulas based on the population growth.    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.  Funding for  capital costs related to the project are assumed to be negotiated through the development agreement.   As such, these funds were not included in this analysis.  Also, no impact to districts or entities apart from  the City are included in this analysis, as these authorities would communicate directly with the  developer, should they have issues or concerns.      Page | 4    Based on the variability and land use assumptions used in the analysis, the City of Ammon’s General  Fund would experience a positive net fiscal impact of approximately $379,000 for the City of Ammon’s  General Fund over the fifteen‐year analysis period.  A net present value calculation of the surplus over  the 15‐year period, using a 3%, 6% and 9% annual discount rate, resulted in $279,000, 211,000 and  163,000 revenue surpluses for the city, respectively.  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 year but would recover these funds and receive positive  cash flows thereafter.  The NPV’s under this scenario are also positive at $237,000, $173,000 and  $129,000.  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.6 to 1.8 benefit range for the vast  majority of the build out period and approaching 3 by year 15 of the analysis period.      Additional Assumptions    Newly enacted legislation (originally introduced as HB 389) in Idaho may result in reduced revenues  from new development 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 Rocking R Ranch development is substantial in size, at full  buildout it accounts for 36% total taxable value growth for the City of Ammon.  This project by itself  would enable the City of Ammon to stay below the 8% cap in any given year, as a result of this  development.  The City would however need to review all of their pending and approved projects on an  annual basis, at minimum, to ensure that the City is able to maximize proceeds from development.  Finally, 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 because services are  anticipated to be provided when the development begins, while new tax revenue will not be collected at  least a year into the future.  To quantify the impact, Galena assumed a complete buildout of 3 years with an overall analysis horizon  of 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 a temporarily  funding source of approximately $5,600 for the first year, until the development is self‐funding and  providing consistent positive cash flows.  As an alternative, the City could choose to not to provide  additional services and collect additional budget for the first few years, recognizing that their service  levels may decline slightly to match costs to funding sources, as a method to bridge the short‐term    Page | 5    deficit.  This is a very practical approach as it is not possible to hire part of a typical full‐time position.   The City would wait until the growth justifies hiring full‐time positions, which could take up to three  years and would easily bridge the funding shortfall.  Both of these approaches are included in the Cash  Flow Summary section of this analysis, as possible methods to temporarily fund any shortfalls.  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 Rocking R Ranch 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 such as  police or fire stations.  These costs will be recovered by the City through exactions, contributions and/or  impact fees.    Rocking R Ranch Project ‐ Ammon, IdahoFiscal Impact AnalysisSummarySummary Financial Statements2023 20242025 2026 2027 2028 2029 2030 2031 2032 2033 20342035 2036 2037RevenueProperty Tax 12,338 22,28433,109 34,103 35,126 36,179 37,265 38,383 39,53440,720 41,942 43,200 44,496 45,831 47,206Sales Tax 1,248 2,545 3,894 3,971 4,051 4,132 4,215 4,299 4,385 4,472 4,562 4,653 4,746 4,841 4,938Liquor Tax 911 1,825 2,742 2,742 2,742 2,742 2,742 2,742 2,742 2,742 11,582 20,687 30,065 39,72449,673Total Revenue 14,497 26,65439,745 40,816 41,919 43,053 44,221 45,42446,661 47,935 58,086 68,540 79,307 90,396 101,817ExpendituresLegislative 38 79 122 126 130 134 138 142 146 150 155 160 164 169 174Executive 273 562 869 895 922 949 978 1,007 1,037 1,068 1,100 1,133 1,167 1,202 1,238Finance 242 499 770 793 817 842 867 893 920 947 976 1,005 1,035 1,066 1,098Clerk 386 796 1,230 1,267 1,305 1,344 1,384 1,426 1,469 1,513 1,558 1,605 1,653 1,702 1,754Planning & Zoning 292 602 929 957 986 1,016 1,046 1,077 1,110 1,143 1,177 1,213 1,249 1,286 1,325Engineering 398 820 1,268 1,306 1,345 1,385 1,427 1,469 1,514 1,559 1,606 1,654 1,704 1,755 1,807Parks & Rec Fund Tsfr 3,126 6,440 9,949 10,248 10,555 10,872 11,198 11,53411,880 12,236 12,603 12,982 13,371 13,772 14,185Law Enforcement 3,024 6,230 9,625 9,913 10,211 10,517 10,833 11,158 11,492 11,837 12,192 12,558 12,935 13,323 13,723Subtotal 7,780 16,027 24,762 25,505 26,270 27,058 27,870 28,706 29,567 30,45431,368 32,309 33,278 34,277 35,305Net Fiscal Impact 6,717 10,62714,983 15,311 15,64815,995 16,351 16,71817,09417,481 26,71836,231 46,02956,12066,512Benefit/Cost Ratio 1.86 1.66 1.61 1.60 1.60 1.59 1.59 1.58 1.58 1.57 1.85 2.12 2.38 2.64 2.88NPV @ 3/6/9% Discount Rates 279,197 210,949 163,12211/19/2021RRR Fiscal Impact ‐ FINALPage 1 Rocking R Ranch Project ‐ Ammon, IdahoFiscal Impact AnalysisSummaryCash Flow Summary (Assuming One Year Lag in Property Taxes)2023 20242025 2026 2027 2028 2029 2030 2031 2032 2033 20342035 2036 2037RevenueProperty Tax 12,338 22,28433,109 34,103 35,126 36,179 37,265 38,383 39,53440,720 41,942 43,200 44,496 45,831Sales Tax 1,248 2,545 3,894 3,971 4,051 4,132 4,215 4,299 4,385 4,472 4,562 4,653 4,746 4,841 4,938Other 911 1,825 2,742 2,742 2,742 2,742 2,742 2,742 2,742 2,742 11,582 20,687 30,065 39,72449,673Total Revenue 2,159 16,708 28,920 39,823 40,896 42,000 43,136 44,306 45,510 46,749 56,86467,282 78,011 89,061 100,442ExpendituresLegislative 38 79 122 126 130 134 138 142 146 150 155 160 164 169 174Executive 273 562 869 895 922 949 978 1,007 1,037 1,068 1,100 1,133 1,167 1,202 1,238Finance 242 499 770 793 817 842 867 893 920 947 976 1,005 1,035 1,066 1,098Clerk 386 796 1,230 1,267 1,305 1,344 1,384 1,426 1,469 1,513 1,558 1,605 1,653 1,702 1,754Planning & Zoning 292 602 929 957 986 1,016 1,046 1,077 1,110 1,143 1,177 1,213 1,249 1,286 1,325Engineering 398 820 1,268 1,306 1,345 1,385 1,427 1,469 1,514 1,559 1,606 1,654 1,704 1,755 1,807Parks & Rec Fund Tsfr 3,126 6,440 9,949 10,248 10,555 10,872 11,198 11,53411,880 12,236 12,603 12,982 13,371 13,772 14,185Law Enforcement 3,024 6,230 9,625 9,913 10,211 10,517 10,833 11,158 11,492 11,837 12,192 12,558 12,935 13,323 13,723Subtotal 7,780 16,027 24,762 25,505 26,270 27,058 27,870 28,706 29,567 30,45431,368 32,309 33,278 34,277 35,305Net Fiscal Impact (5,622) 681 4,15814,31814,625 14,941 15,26615,60015,94216,29425,49634,973 44,733 54,785 65,137Benefit/Cost Ratio 0.28 1.04 1.17 1.56 1.56 1.55 1.55 1.54 1.54 1.54 1.81 2.08 2.34 2.60 2.84NPV @ 3/6/9% Discount Rates 237,347 173,266128,76911/19/2021RRR Fiscal Impact ‐ FINALPage 2 Rocking R Ranch Project ‐ Ammon, IdahoFiscal Impact AnalysisSummaryCash Flow Summary (Delayed Service Alternative)2023 20242025 2026 2027 2028 2029 2030 2031 2032 2033 20342035 2036 2037RevenueProperty Tax 12,338 22,28433,109 34,103 35,126 36,179 37,265 38,383 39,53440,720 41,942 43,200 44,496 45,831Sales Tax 1,248 2,545 3,894 3,971 4,051 4,132 4,215 4,299 4,385 4,472 4,562 4,653 4,746 4,841 4,938Other 911 1,825 2,742 2,742 2,742 2,742 2,742 2,742 2,742 2,742 11,582 20,687 30,065 39,72449,673Total Revenue 2,159 16,708 28,920 39,823 40,896 42,000 43,136 44,306 45,510 46,749 56,86467,282 78,011 89,061 100,442ExpendituresLegislative 38 79 122 126 130 134 138 142 146 150 155 160 164 169Executive 273 562 869 895 922 949 978 1,007 1,037 1,068 1,100 1,133 1,167 1,202Finance 242 499 770 793 817 842 867 893 920 947 976 1,005 1,035 1,066Clerk 386 796 1,230 1,267 1,305 1,344 1,384 1,426 1,469 1,513 1,558 1,605 1,653 1,702Planning & Zoning 292 602 929 957 986 1,016 1,046 1,077 1,110 1,143 1,177 1,213 1,249 1,286Engineering 398 820 1,268 1,306 1,345 1,385 1,427 1,469 1,514 1,559 1,606 1,654 1,704 1,755Parks & Rec Fund Tsfr 3,126 6,440 9,949 10,248 10,555 10,872 11,198 11,53411,880 12,236 12,603 12,982 13,371 13,772Law Enforcement 3,024 6,230 9,625 9,913 10,211 10,517 10,833 11,158 11,492 11,837 12,192 12,558 12,935 13,323Subtotal 0 7,780 16,027 24,762 25,505 26,270 27,058 27,870 28,706 29,567 30,45431,368 32,309 33,278 34,277Net Fiscal Impact 2,159 8,92812,89215,061 15,391 15,72916,07816,43616,80417,18226,41035,91445,70255,783 66,166Benefit/Cost Ratio 0.00 2.15 1.80 1.61 1.60 1.60 1.59 1.59 1.59 1.58 1.87 2.14 2.41 2.68 2.93NPV @ 3/6/9% Discount Rates 268,588 201,339 154,30811/19/2021RRR Fiscal Impact ‐ FINALPage 3 Rocking R Ranch Project ‐ Ammon, IdahoFiscal Impact AnalysisAbsorptionAbsorption Schedule  ‐  Straight Line AbsorptionAbsorption Rate 2023 20242025 2026 2027 2028 2029 20302031 2032 2033 20342035 2036 2037 TotalSingle Family 33% 33% 33% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 100.0%Units Occupied/Sq. Ft.Single Family 18 18 18000000000000 55Cost per Sq. Ft.Single Family 185 192 200208 216 225 234 243 253 263 274 285 296 308 320Taxable ValueSingle Family 8,991,0009,350,6409,724,66600000000000028,066,306Subtotal 8,991,0009,350,6409,724,66600000000000028,066,306Property Tax RevenueSingle Family @ 80% H.O.E. 12,338 9,576 10,157000000000000Total Property Tax Revenue 12,3389,57610,157000000000000Sales 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,172 17,228 17,285 17,285 17,285 17,285 17,285 17,285 17,285 17,285 17,285 17,285 17,285 17,285 17,285Revised State Total Pop. ‐ <Avg 666,402 666,458 666,515 666,515 666,515 666,515 666,515 666,515 666,515 666,515 666,515 666,515 666,515 666,515 666,515Revised Ammon Share 2.58% 2.59% 2.59% 2.59% 2.59% 2.59% 2.59% 2.59% 2.59% 2.59% 2.59% 2.59% 2.59% 2.59% 2.59%Revised Ammon Sales Tax ‐ Excess 387,819 396,848 406,083 414,205 422,489 430,938 439,557 448,348 457,315 466,462 475,791 485,307 495,013 504,913 515,011Sales Tax Increment 1,2482,545 3,8943,971 4,051 4,132 4,215 4,299 4,385 4,472 4,562 4,653 4,7464,841 4,938Liquor Tax RevenueBase Liquor Tax 275,000275,911 276,825 277,742 277,742 277,742 277,742 277,742 286,074294,657 303,496312,601 321,979 331,639 341,588Liquor Tax Per Capita 16.1 16.1 16.2 16.2 16.2 16.2 16.2 16.2 16.7 17.2 17.7 18.3 18.8 19.4 20.0New Residents 57 57 57000000000000Incremental Liquor Tax911914917000000000000New Liquor Tax Revenue 911 1,825 2,742 2,742 2,742 2,742 2,742 2,742 2,742 2,742 11,58220,68730,065 39,72449,67311/19/2021RRR Fiscal Impact ‐ FINALPage 4 Rocking R Ranch Project ‐ Ammon, IdahoFiscal Impact AnalysisImpact on ExpendituresOperational Impact2023 20242025 2026 2027 2028 2029 20302031 2032 2033 20342035 2036 2037Expenditures ‐ TotalLegislative 3,8443,959 4,078 4,201 4,327 4,456 4,5904,728 4,8705,016 5,166 5,321 5,481 5,645 5,815Executive 16,375 16,86617,372 17,893 18,43018,983 19,552 20,139 20,743 21,365 22,00622,667 23,347 24,047 24,768Finance 18,152 18,697 19,25819,835 20,43021,043 21,675 22,325 22,995 23,68424,395 25,127 25,881 26,657 27,457Clerk 2,898 2,985 3,075 3,167 3,262 3,3603,461 3,565 3,671 3,782 3,895 4,012 4,132 4,256 4,384Planning & Zoning3,893 4,0104,131 4,2544,382 4,5144,649 4,788 4,932 5,0805,232 5,389 5,551 5,718 5,889Engineering 2,987 3,077 3,169 3,2643,362 3,463 3,567 3,6743,7843,897 4,0144,135 4,259 4,387 4,518Parks & Rec Fund Tsfr14,42814,861 15,307 15,76616,239 16,72617,22817,745 18,277 18,825 19,39019,972 20,571 21,18821,824Law Enforcement39,20640,382 41,593 42,841 44,12645,45046,81448,21849,665 51,155 52,689 54,27055,89857,575 59,302Subtotal 101,784104,837107,982 111,222 114,558117,995 121,535 125,181 128,936132,805 136,789 140,892 145,119 149,473 153,957Expenditures ‐ 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 TypeSingle Family33.3% 66.7% 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%Proportionate ShareSingle Family100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100%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%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%11/19/2021RRR Fiscal Impact ‐ FINALPage 5 Rocking R Ranch Project ‐ Ammon, IdahoFiscal Impact AnalysisImpact on ExpendituresOperational Impact2023 20242025 2026 2027 2028 2029 20302031 2032 2033 20342035 2036 2037Single Family Variable ExpendituresLegislative 38 79 122 126 130 134 138 142 146 150 155 160 164 169 174Executive 273 562 869 895 922 949 978 1,007 1,037 1,068 1,1001,133 1,167 1,202 1,238Finance 242 499 770 793 817 842 867 893 920 947 976 1,005 1,035 1,066 1,098Clerk 386 796 1,2301,267 1,305 1,3441,3841,426 1,469 1,513 1,558 1,605 1,653 1,702 1,754Planning & Zoning292 602 929 957 986 1,016 1,046 1,077 1,1101,143 1,177 1,213 1,249 1,286 1,325Engineering 398 820 1,268 1,306 1,345 1,385 1,427 1,469 1,5141,559 1,606 1,6541,7041,755 1,807Parks & Rec Fund Tsfr3,126 6,4409,949 10,24810,555 10,872 11,19811,53411,88012,23612,603 12,982 13,371 13,772 14,185Law Enforcement3,0246,2309,625 9,913 10,211 10,517 10,833 11,15811,492 11,837 12,192 12,55812,935 13,323 13,723Subtotal 7,78016,027 24,762 25,505 26,27027,05827,87028,70629,567 30,45431,36832,309 33,27834,277 35,305Total Variable ExpendituresLegislative 38 79 122 126 130 134 138 142 146 150 155 160 164 169 174Executive 273 562 869 895 922 949 978 1,007 1,037 1,068 1,1001,133 1,167 1,202 1,238Finance 242 499 770 793 817 842 867 893 920 947 976 1,005 1,035 1,066 1,098Clerk 386 796 1,2301,267 1,305 1,3441,3841,426 1,469 1,513 1,558 1,605 1,653 1,702 1,754Planning & Zoning292 602 929 957 986 1,016 1,046 1,077 1,1101,143 1,177 1,213 1,249 1,286 1,325Engineering 398 820 1,268 1,306 1,345 1,385 1,427 1,469 1,5141,559 1,606 1,6541,7041,755 1,807Parks & Rec Fund Tsfr3,126 6,4409,949 10,24810,555 10,872 11,19811,53411,88012,23612,603 12,982 13,371 13,772 14,185Law Enforcement3,0246,2309,625 9,913 10,211 10,517 10,833 11,15811,492 11,837 12,192 12,55812,935 13,323 13,723Total Variable Expenditures 7,780 16,027 24,762 25,505 26,27027,05827,87028,70629,567 30,45431,36832,309 33,27834,277 35,30511/19/2021RRR Fiscal Impact ‐ FINALPage 6