The URL can be used to link to this page

Reserve Fund Analysis5, City of Otsego Reserve Funds Analysis 11/24/2014 C:\Users\Dan\Documents\2015 Budget\Reserve Funds Analysis 10/31/2014 Established Ongoing Periodic No Regular Fund Fund Name Cash Balance Year Revenues Revenues Revenues Revenue Sources) Purpose 201 Street Pavement Management $ 387,891.26 2007 X property tax levy regular, ongoing maintenance of city streets 202 Trail Pavement Management $ 15,322.04 2011 X property tax levy regular, ongoing maintenance of pedestrian & bicycle trails 203 Park Development $ 702,075.63 2005 X developer fees purchase ofpark land, development of parks, development of trails (and purchase of park equipment prior to 2011) 204 Insurance Reserve $ 88,194.79 12004 X annual LMCIT rebate/refund offset insurance claim deductibles and claim costs 205 Park Equipment Capital $ 99,866.03 2011 X property tax levy purchase of park equipment 206 Capital Equipment Revolving $ 417,887.24 12004 X property tax levy purcahse ofequipment and rolling stock for governmental fund functions (enterprise pays for its own) X none discontinued in 2011; proceeds transferred to fund 203 207 Park Tree $ - 0004 208 Community Facilities $ 462,545.59 12004 X interest Income only originally established to construct a community center facility 209 Street Reconstruction $ (307,384.90) 2009 X funded only by General Fund transfers originaly established to reconstruct streets. Only project done was LaBeaux Avenue frontage and the fund carries some assessments receivable ($ 52,460). Fund deficit comes from charges for 70th Street project right-of-way acquisitions 214 Fire Capital Reserve $1,628,019.30 12004 X property tax levy originally established as four fire district funds. Four districts were consolidated to two (East and West) in 2010. Those two were -consolidated into one fundin 2011. To be used for buildings, furnishings and equipment for fire protection. 10/31/2014 Established Ongoing Periodic No Regular Fund# Fund Name Cash Balance Year Revenues? Revenues? Revenues? Revenue Sourc(s) Purpose 403 Collector Streets (MSA) $ 314,905.03 12004 X Municipal State Aid (MSA) for collection and disbursement of street funding received from the State from the Municipal State Aid program 414 Revolving Capital Improvement $ 306,605.58 2005 X fund transfers, assessment payments, finance smaller city improvements that are not bonded and to remaining funds from bonds finance the portion of city improvements that are not supported by other fund sources such as assessments, MSA funds or Federal and State grants. 441 Otsego Municipal Building $ 36,774.63 2007 X allocated interest revenues only used to construct the public works building/city hall inclusion. Some fund transferred to bond payments in 2012. Should be closed to debt service fund 385 (20108). 11/24/2014 C:\Users\Dan\Documents\2015 Budget\Reserve Funds Analysis 210 211 212 213/214 201 202 203 204 205 206 207 208 209 225 250 255 Fire Dist Fire Dist Fire Dist Fire Dist Self Fund Capital Park Community Building 2004 Elk Riv Albertvl Rogers Monticell Insurance Equipment Tree Center I -P Fire Dist Fire Dist Fire Dist Fire Dist Self Fund Capital Park Community 2005 Elk Riv Albertvl Rogers Monticell Insurance Equipment Time Center Fire Dist Fire Di. Fire Dist Fire Dist Park Self Fund Capital Park Community 2005 Elk Riv Albertvl Rogers Monticell Developmt Insurence Equlpment Tree Center Com Dev. 2007 Fire Dist Elk Riv Fire Dist Albertvl Fire Dist Rogers Fire Dist Monticell Pave/Treil Mangt Park Developmt Self Fund Insurance Capital Equipment Park Tree Community Fecllities Building Safety 210 211 212 213 201 203 204 206 207 208 250 C" Dev. 2008 Fire Dist Elk Riv Fire Dist Albertvl Fire Dist Rogers Fire Dist Monticell Pave/Trail Mangt Park Developmt Self Fund Insurance Capital Equipment Park Tree Community Facilities Building Safety 210 211 212 213 201 203 204 206 207 208 209 225 250 Collector Co. Dev. 2009 Fire Dist Elk Riv Fire Dist Albertvl Fire Dist Rogers Fire Dirt Monticell Pave/rodI Mangt Park Developmt Self Fund Insurance Capital Equipment Park Tree Community Facilities Street Reconstruct Street Lighting Building Safety 210/212 211/213 201 203 204 206 207 208 209 Cnnecmr 225 250 Co. Dev. 2010 East Fire Svc West Fire Svc Peve/1-mil Mangt Park Developmt Self Fund Insurance Capital Equipment Park Tree Community Facilities Street Reconstruct Street Lighting Building Safety 214 201 202 203 204 205 206 207 208 209 225 250 Fire Street Trail Co. Dev. Capital Pavement Pavement Park Self Fund Park Capital Park Community Street Street Building 2011 Reserve Management Management Development Insurance Equipment Equipment Tree Facllities Reconstruct Lighting Safety 214 201 202 203 2114 205 206 206 209 225 250 255 Fire Street Trail Cam Dev. Capital Pavement Pavement Park Self Fund Park Capital Community Street Street Building Development 2012 Reserve Management Management Development Insurance Equipment Equipment Facllities Reconstruct Ughting Safety Loan 214 201 202 203 204 205 206 208 209 225 255 Fire Capital Street Pavement Trail Pavement Park Self Fund Park Capital Community Street Street Development 2013 - Reserve Management Management Development Insurance Equipment Equipment Facllltles Reconrtruct Ughting Loan C:\Users\Dan\Documents\Funds Reporting Structure 2004 2013 11/24/2014 315/360 316 350 365 375 380 385 395 399 G.O. G.O. Bonds 'at/Sew G.O. Imp, Waterfront Wert Quaday 2004 1996 98&98A 99B&03 West Water/Sewer 2004 G.O. G.O. Bonds Water/Sewer G.O. Imp, Waterfront West Quaday Waterfront East 2005 1996 98&98A 99B&03 West Water/Sewer 2004 Miss. Shares G.O. Bonds East G.O.Impr Waterfront Wert Quaday Waterfront East G.O. Imp, 2005 1996 Water/Sewer 99B & 03 West Water/Sewer 2004 Miss. Shores 2006 Pub Facil East/West G.O. Impr Waterfront Quaday Waterfront East G.O. Impr Le ase Revenue Quantrelle 2007 Water/Sewer 99B&03 West 2004 Miss. Shores 2006 2007 &88th 315/360 316 350 365 375 380 385 395 Pub Facil East/West G.O.Impr Waterfront Quaday Waterfront East G.O. Imp, Lease Revenue Quantrelle 2008 Water/Sewer 99B&03 West 2004 Miss. Shares 2006 2007 &88th 315/360 316 350 365 375 380 385 395 Pub Facia East/West G.O.Impr Waterfront Quaday Waterfront East G.O. Impr Lease Revenue Quantrelle 2009 Water/Sewer 99B & 03 West 2004 Miss. Shores 2006 2007 &88th 350 365 371 380 385 395 399 Pub FbOl Waterfront Quaday Waterfront East G.O. Impr Lease Revenue Quantrelle Equip Certif 2010 West 2004 MI- Shores 2006 2007 &88th 2010A 350 365 375 380 385 395 399 G.O. CIP Waterfront Quaday Waterfront East G.O. Impr Refunding Quamrelle Equip Certif 2011 West 2004 Miss. Shares 2006 20108 & 88th 2010A 350 365 375 380 385 395 399 G.O. CIP Waterfront Quaday Waterfront East G.O. Impr Refunding Quantrelle Equip Certif 2012 West 2004 Miss. Shores 2006 20108 & 88th 2010A 350 365 375 380 385 395 399 G.O. CIP Waterfront Quaday Waterfront Eart G.O. Impr Refunding Quantrelle Equip Certif 2013 West 2004 Miss. Shores 2006 20108 &88th 2010A C.\Users\Dan\Documents\Funds Reporting Str-un, 2004 2013 11/24/2014