City of Roseville
<br />Capital Improvement Plan: Street Replacement Fund (590)
<br />2025-2044
<br />Tax Levy: Current
<br />Tax Levy: Add/Sub (a)
<br />MSA Revenue
<br />Other: Assessments (10-yr)
<br />Other: Internal Loan Repayments
<br />Interest Earnings
<br />Vehicles
<br />Equipment
<br />Furniture & Fixtures
<br />Buildings
<br />Improvements
<br />Beginning Cash Balance
<br />Annual Surplus (deficit)
<br />Cash Balance
<br />Cash Balance (Year -End)
<br />Planned CIP Surplus/Deficit
<br />Adjust for Delayed CIP Items
<br />Cash Balance (Beg. Year)
<br />Updated 81122024
<br />2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044
<br />$ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000
<br />575,000 1,775,000 1,700,000 1,000,000 - -
<br />83,000 83,000 83,000 83,000 83,000 83,000 83,000 83,000 -
<br />110,627 105,899 99,077 92,119 85,021 77,782 68,397 58,825 49,062 37,443 25,592 13,504 -
<br />Revenues $ 1,888,627 $ 3,083,899 $ 3,002,077 $ 2,295,119 $ 1,288,021 $ 1,280,782 $ 1,271,397 $ 1,261,825 $ 1,169,062 $ 1,157,443 $ 1,145,592 $ 1,133,504 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 1,120,000 $ 28,937,348
<br />2,125,000 3,425,000 3,350,000 2,650,000 1,650,000 1,750,000 1,750,000 1,750,000 1,750,000 1,750,000 1,750,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000 1,850,000
<br />Expenditures $ 2,125,000 $ 3,425,000 $ 3,350,000 $ 2,650,000 $ 1,650,000 $ 1,750,000 $ 1,750,000 $1,750,000 $1,750,000 $1,750,000 $1,750,000 $1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 40,350,000
<br />$ 5,531,341 $ 5,294,968 $ 4,953,867 $ 4,605,945 $ 4,251,063 $ 3,889,085 $ 3,419,866 $2,941,264 $2,453,089 $1,872,151 $1,279,594 $ 675,186 $ (41,311) $ (771,311) $(1,501,311) $(2,231,311) $(2,961,311) $(3,691,311) $ (4,421,311) $ (5,151,311) $ (11,412,652)
<br />(236,373) (341,101) (347,923) (354,881) (361,979) (469,218) (478,603) (488,175) (580,938) (592,557) (604,408) (716,496) (730,000) (730,000) (730,000) (730,000) (730,000) (730,000) (730,000) (730,000)
<br />$ 5,294,968 $ 4,953,867 $ 4,605,945 $ 4,251,063 $ 3,889,085 $ 3,419,866 $ 2,941,264 $2,453,089 $1,872,151 $1,279,594 $ 675,186 $ (41,311) $ (771,311) $(1,501,311) $(2,231,311) $(2,961,311) $(3,691,311) $(4,421,311) $ (5,151,311) $ (5,881,311)
<br />$ 5,718,877 2023
<br />(187,536) 2024 Pavement Management Fiend
<br />- 2024
<br />$ 5,531,341 2025 $6,000,000
<br />Fund 592 $ (1,362,845) 2023 $4,000,000
<br />Fund 590 $ 7,081,722 2023 $2,000,000
<br />Fund 591-MSA 2022
<br />5,718,877
<br />loan repaid $266,829 in 2023 - shown as delayed CIP items
<br />10-17-23 Updated projects, revenues and amounts
<br />Expenditure Detail
<br />Key Description
<br />I Mill & overlay - local streets
<br />I MSA - 25-04 - 2025 PMP (no MSA)
<br />I MSA- Harnline Pathway, Cry C-Josephine
<br />I MSA - County Road C, Lexington - Rice
<br />I MSA - Rice, Larpentuer -CryB
<br />I MSA - 26-04 - 2026 PMP (Walnut, Terminal, Centeipointe)
<br />I MSA- Victoria Pathway, County C-CountyD
<br />I MSA - Rice Street, CR B2-SouthOwasso
<br />I MSA - 27-04 2027 PMP
<br />I MSA -Lexington Pathway, County B2-Brooks
<br />I MSA - 28-04 2028 PMP
<br />2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044
<br />$ 1,550,000 $ 1,650,000 $ 1,650,000 $ 1,650,000 $ 1,650,000 $ 1,750,000 $ 1,750,000 $1,750,000 $1,750,000 $1,750,000 $1,750,000 $1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 F 35,300,000
<br />375,000 375,000
<br />150,000 400,000 - 550,000
<br />50,000 75,000 350,000 475,000
<br />- 1,050,000 -
<br />125,000 900,000 1,025,000
<br />125,000 - 750,000 875,000
<br />- 250,000 250,000
<br />200,000 200,000
<br />250,000
<br />$ 2,125,000 $ 3,425,000 $ 3,350,000 $ 2,650,000 $ 1,650,000 $ 1,750,000 $ 1,750,000 $1,750,000 $1,750,000 $1,750,000 $1,750,000 $1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 1,850,000 $ 40,350,000
<br />2.0%=projected interest earnings rate
<br />20
<br />Page 23 of 55
<br />
|