|
1
<br />-
<br />
<br />005000000
<br />034000
<br />008000000
<br />016000
<br />00010005
<br />9550000
<br />,,,,,,,
<br />,,,,,,,,
<br />000006
<br />734140420
<br />57555
<br />2781134023
<br />553,0004 1560,00076
<br />45572438603
<br />Qbhf!3:!pg!99
<br />,,
<br />,,,,,,,,,,,
<br />1
<br /> 317 4 7701 7 2 14
<br />Total
<br />80,000,0001 1 214 2 24,679,0003
<br />
<br />217,905,662
<br />
<br />$ $ $ $
<br />$ $ $
<br />Updated 7/9/2024
<br />--
<br />------
<br />
<br /> 0
<br />0
<br />0
<br />,
<br />4,000 5
<br />
<br />58,500
<br />20,00010,00020,000420,000
<br />
<br />
<br />641,800250,000341,300
<br />
<br />
<br />2044
<br />
<br />4,000,0001,850,000
<br />
<br />
<br />
<br />
<br /> (30,336,000)
<br />
<br />Total Funding187,569,662
<br />
<br />$ 78,346,587 6,364,909 1,693,667$ $ 217,905,662$
<br /> $
<br />$ 166,405,163
<br />Total Revenues166,405,163
<br />------
<br />
<br />0
<br />Total Expenditures
<br />0
<br />0Total Cash Reserves21,164,499
<br />,
<br />4
<br />23,00058,50065,0004
<br />
<br />655,900148,000371,300
<br />250,000
<br />2043
<br />4,000,0001,850,0001,076,0001,106,000
<br />
<br />
<br />11,087,000
<br />
<br />(34,823,307)
<br />
<br />
<br />Total Financing Surplus (Gap)(30,336,000)
<br />
<br />$ 3,696,000 30,000 21,908$ 7,747,908$ $ 3,260,600$
<br /> (34,823,307) 4,487,308$
<br />-----
<br />
<br />20,00058,50079,00065,000
<br />601,880585,000120,000635,000560,000391,300
<br />2042
<br />4,000,0001,850,0001,009,0001,454,000
<br />
<br />(23,748,311)
<br />$ 3,740,000$ 2,121,000$
<br /> 30,000 10,704$ 7,780,704 $ 18,855,700$ (23,748,311) (11,074,996)
<br />---
<br />-
<br />
<br />
<br />20,00058,50050,000
<br />34,000
<br />738,560297,000
<br />235,000376,300
<br />2041
<br />4,000,0001,625,0002,419,0001,115,0001,850,0001,039,0001,054,000
<br />(21,941,681)
<br />$ 3,696,000 30,000 6,050$ 7,732,050$
<br /> 2,110,000$ 9,538,680$ (21,941,681) (1,806,630)$
<br />---
<br />
<br />0
<br />0
<br />0
<br />,
<br />5
<br />23,00058,500464,000
<br />
<br />712,845737,350838,000157,000426,000535,000155,000366,300
<br />2040
<br />4,000,0001,014,0001,054,000
<br />1,850,000
<br />(16,594,977)
<br />
<br />$ 3,710,000 50,000 38,657$ 7,798,657$
<br /> 2,234,000$ 13,145,360$ (16,594,977) (5,346,703)$
<br />---
<br /> 0
<br />0
<br />0
<br />,
<br />0
<br />058,500
<br />20,00053,50085,000
<br />
<br />4
<br />652,120121,000280,000544,000405,000451,300118,500
<br />2039
<br />4,000,0001,850,0001,008,0001,173,500
<br />$ 3,759,000 50,000 30,885$
<br /> 2,443,000$ 10,478,995$ (13,955,867)
<br />$ 7,839,885 (2,639,110)$
<br />---
<br />-
<br />
<br />58,50050,00075,000
<br />20,000
<br />599,800180,000110,000596,000167,000321,300
<br />640,000
<br />2038
<br />1,134,0002,029,000
<br />4,000,0001,850,000
<br />$ 3,750,000 94,500 32,898$ 7,877,398$
<br /> 1,903,000$ 9,123,420$ (12,709,845) (1,246,022)$ (13,955,867)
<br />---
<br />
<br />58,50038,00020,00045,000
<br />665,260330,000857,500575,000860,000321,300108,000
<br />2037
<br />4,000,0001,034,0001,061,500
<br />1,850,000
<br />$ 3,753,000 2,494,000
<br /> 67,000 22,420$ 7,842,420$ $ 10,324,600$ (10,227,665)
<br /> (2,482,180)$ (12,709,845)
<br />-
<br />--
<br />
<br />58,50030,000
<br />69,000
<br />736,230311,100
<br />375,000163,000607,000451,300100,000
<br />2036
<br />4,000,0001,010,0001,850,0001,254,0001,094,000
<br />$ 3,774,000 60,000 21,088$ 7,855,088
<br /> 1,856,500$ 9,703,560$ (8,379,193) (1,848,472)
<br />$ 23,000$ (10,227,665)
<br />---
<br />
<br />0000
<br />0000
<br />0300
<br />,,,,
<br />5657
<br />58,5007548
<br />
<br />585,350671,000339,000872,000141
<br />
<br />2035
<br />4,000,0002,011,8501,054,0001,292,000
<br />1,041,0001,750,000
<br />$ 3,710,000 85,000 22,508$ 7,817,508$ 75,000
<br /> 2,625,000$ 10,809,130$ (5,387,571) (2,991,622)$ (8,379,193)
<br />----
<br />
<br />0
<br />0
<br />0
<br />,
<br />5
<br />58,5004
<br />745,845360,000428,000400,000837,500341,300104,500
<br />2034
<br />4,000,0001,397,0001,750,0001,087,0001,204,000
<br />$ 3,736,000 177,000 1,914,000$ 12,472,000
<br /> 56,660$ 7,969,660$ 20,000 $ (885,231) (4,502,340)$ (5,387,571)
<br />--
<br />--
<br />
<br />58,50047,00022,50084,000
<br />609,620633,000300,000351,300
<br />981,300557,500
<br />2033
<br />1,154,000
<br />4,000,0001,750,0001,054,000
<br />$ 3,666,000 64,500 72,294$ 7,802,794$ 23,000
<br /> 2,085,000$ 10,866,645$ 2,178,620 (3,063,851)$ (885,231)
<br />----
<br />
<br />$(30)
<br />58,50022,50030,000
<br />583,160607,000170,000447,000211,000663,000341,300
<br />2032
<br />4,000,0002,519,0001,089,000
<br />1,750,000
<br />
<br />$ 3,599,000 30,000 66,902$ 7,695,902$ 20,000
<br /> 1,609,000$ 9,231,720$ 3,714,438 (1,535,818)$ 2,178,620
<br />----
<br />
<br />58,500
<br />15,00017,000
<br />814,110196,000466,000895,000170,000371,300
<br />
<br />2031
<br />4,000,0001,099,0001,750,0001,109,0001,121,500
<br />$ 3,396,000 1,953,000 72,208
<br /> 1,849,000$ 10,360,460$ 4,653,689 (939,252)
<br />$ 9,421,208$ 20,000 $ 3,714,438
<br />---
<br />
<br />0
<br />0
<br />0
<br />,
<br />5
<br />Ending Cash Balance
<br />58,500449,000
<br />624,020374,350115,000428,000715,000347,500411,300684,000
<br />2030
<br />4,000,0001,154,000
<br />1,022,5001,750,000
<br />$ 3,315,000 130,000 87,430$ 7,532,430$ 20,000
<br /> 1,562,000$ 9,664,410$ 6,785,669 (2,131,980)$ 4,653,689
<br />----
<br />
<br />0000
<br />0000
<br />0350
<br />,,,,
<br />5143
<br />58,5008294
<br />
<br />645,350212,000165,000325,500452,500945,000136
<br />
<br />2029
<br />4,000,0001,650,0001,510,000
<br />Expenditures
<br />$ 3,285,000 123,000 1,114,000$ 8,912,170
<br /> 94,384$ 7,502,384$ 20,000 $ 8,195,455 (1,409,786)$ 6,785,669
<br />-----
<br />
<br />
<br />58,500
<br />733,845380,000441,300
<br />796,000244,000927,744940,000134,000
<br />2028
<br />1,356,000
<br />4,000,0002,650,0001,481,000
<br />Summary of CIP -Financial Projection
<br />$ 3,255,000 148,500 93,670$ 7,497,170$ 20,000
<br /> 1,165,000$ 8,392,650$ 9,090,936 (895,480)$ 8,195,455
<br />Revenues
<br />---
<br />
<br />$18
<br />58,50045,00069,500
<br />624,480676,500783,500204,000863,925805,000285,000551,300
<br />2027
<br />4,000,0001,984,5001,379,500
<br />3,350,000
<br />2025202820312034203720402043
<br />
<br />$ 4,249,430 133,000 109,326$ 8,491,756$ 23,000
<br /> 1,281,000$ 11,446,389$ 12,045,569 (2,954,633)$ 9,090,936
<br />--
<br /> 00
<br />0
<br />01
<br />0
<br /> $-
<br />50
<br />0
<br />, $30 $20 $10
<br />,,
<br /> $(10) $(20) $(30) $(40)
<br />8
<br />01
<br />5
<br />5 8
<br />7117,000192,000120,000336,300100,000672,000554,000
<br />
<br />2026
<br />4,000,0001,922,0002,201,0002,102,5003,425,0001,554,000
<br />Millions
<br />$ 4,986,350 165,500 147,067 1,335,500$ 13,061,205$
<br /> 15,807,858
<br />$ 9,298,916$ 45,000 (3,762,289)$ 12,045,569
<br />--
<br />
<br />58,50057,50045,00068,000
<br />675,900675,850341,000495,513289,300750,000944,000
<br />2025
<br />4,000,0004,532,6001,794,0001,124,000
<br />1,436,5002,125,000
<br />$ 6,738,208 2,776,909 316,071$ 13,831,188$ 75,000
<br /> 1,505,000$ 15,765,310$ 17,741,979 (1,934,122)$ 15,807,858
<br />A
<br />Summary of All Capital Funds
<br />Revenues9,070,138
<br />Expenditures12,492,658
<br /> Function
<br />r
<br />y
<br /> b
<br />y
<br />Tax Levy: CurrentTax Levy: Add/Sub*Fees, MSA, Asmnts,Trfs, ARPSale of Assets/Internal Loan167,000Interest Earnings370,538FinanceCentral ServicesPoliceFirePublic WorksParks & RecreationGeneral
<br /> Facility Improvements1,589,595Park ImprovementsStreet LightingPathways (Existing)Community DevelopmentGolfRecylingWaterSanitary SewerStorm SeweBeginning Cash Balance21,164,499Annual
<br /> Surplus (deficit)(3,422,520)
<br />Administration23,000Street ImprovementsEnding Cash Balance17,741,979
<br />City of Roseville
<br />Capital Improvement Plan: 2025-2044 Summar
<br />
<br />
|