City of Roseville Attachment A
<br />December 31, 2018 Cash Reserve (Fund balance)Levels
<br />AmountAmountAmount
<br />AmountDesignatedDesignatedDesignated
<br />Held InForForFor12/31/2018
<br />DonationsOperationsCapitalOtherTotal
<br />Restricted Funds
<br />Police Forfeitures (General)$ -$ 238,965$ -$ -$ 238,965
<br />Community Development - 422,730 1,717,032 - 2,139,762
<br />Debt Service - - - 2,510,964 2,510,964
<br />Lawful Gambling - 71,844 - 9,907 81,751
<br />Sanitary Sewer - 440,385 658,870 - 1,099,255
<br />Water - - - - -
<br />Storm Drainage - 118,572 478,499 - 597,071
<br />Recycling - 95,667 - - 95,667
<br />MSA Funds - - - - -
<br />Park Dedication - - - 512,171 512,171
<br />TIF - - - 4,140,609 4,140,609
<br />Roseville HRA - 4,089,380 - - 4,089,380
<br />Roseville EDA - 229,599 - - 229,599
<br />Total: Restricted$ -$ 5,707,143$ 2,854,401$ 7,173,651$ 15,735,195
<br />ProjectedProjected
<br />2023 CIP 2028 CIP
<br />Unrestricted Funds Cash LevelCash Level
<br />General$ 62,803$ 5,040,278$ -$ -$ 5,103,081n/an/a
<br />Recreation 300,612 1,870,851 - - 2,171,463n/an/a
<br />License Center - 356,665 174,200 - 530,865 262,909 239,937
<br />Information Technology - 616,458 919,217 - 1,535,675 523,885 320,937
<br />Communications - 101,056 244,000 - 345,056 21,705 (98,948)
<br />Police Vehicles & Equip. - - 457,299 - 457,299 240,016 139,584
<br />Fire Vehicles & Equip. - - 1,002,626 - 1,002,626 428,100 554,585
<br />Parks & Rec Vehicles & Equip. - - 299,717 - 299,717 417,563 684,603
<br />Public Works Vehicles & Equip. - - 711,067 - 711,067 397,731 230,909
<br />Administration Equip. - - (27,541) - (27,541) (12,802) (6,353)
<br />Finance Equip. - - 63,588 - 63,588 103,465 53,772
<br />Central Services Equip. - - 98,692 - 98,692 92,065 83,953
<br />Building Replacement - - 1,143,781 - 1,143,781 (616,822) 1,254,713
<br />Streetlight Replacement - - 91,361 - 91,361 52,858 79,177
<br />Pathway/Parking Lot Maint. - - 212,737 - 212,737 308,479 325,862
<br />Parks Improvement Program - - 1,066,137 - 1,066,137 156,351 989,015
<br />Boulevard Landscaping - 246,371 - - 246,371n/an/a
<br />2719 Lexington Ave - 48,580 - - 48,580n/an/a
<br />Street Replacement - - - 6,021,195 6,021,195 4,982,507 4,302,037
<br />Golf Course - 95,000 - - 95,000n/an/a
<br />Risk Management Funds - - - 1,887,459 1,887,459n/an/a
<br />Total: Unrestricted$ 363,414$ 8,375,259$ 6,456,879$ 7,908,654$ 23,104,206$ 7,358,010$ 9,153,783
<br />Combined: All Funds$ 363,414$ 14,082,402$ 9,311,280$ 15,082,305$ 38,839,401
<br />CIP Cash Level Projection Assumptions:
<br />*$765,000 expriing debt levy will be re-purposed towards the CIP beginning in 2020
<br />*Street Replacement Fund excludes $1.5 Million internal loan
<br />*Building Replacement Fund excludes State funding for Skating Center improvements
<br />
<br />
|