Loading...
HomeMy WebLinkAbout2018 07-16 CCP Joint Work Session with the Financial CommissionAGENDA CITY COUNCIL/FINANCIAL COMMISSION JOINT WORK SESSION Monday, July 16, 2018 6:30 p.m. City Hall – City Council Chambers I. Call to Order II. Approval of Agenda III. Overview/Introduction IV. Capital Improvements Plan 2019 – 2033 V. Individual Capital Projects Funds a. Capital Improvements Fund b. Municipal State Aid Fund c. Street Reconstruction Fund d. Special Assessments Fund e. Overview of Utility Funds f. Technology Fund g. EBHC Capital Fund h. BC Liquor Capital Plan VI. Adjournment i City of Brooklyn Center City Council/Financial Commission Joint Work Session Capital Projects – July 16, 2018 Table of Contents 2019 – 2033 Capital Improvement Plan Introduction ................................................................ Pages 1-2 Charts ......................................................................... Page 3 Project Listing ............................................................. Pages 4-7 Individual Capital Projects Funds Capital Improvements Fund Cash Flows .................................................................. Page 8 Municipal State Aid Fund Cash Flows .................................................................. Page 9 Street Reconstruction Fund Cash Flows .................................................................. Page 10 Special Assessments Fund Cash Flows .................................................................. Page 11 Water Utility Fund Cash Flows .................................................................. Page 12 Sanitary Sewer Utility Fund Cash Flows .................................................................. Page 13 Storm Water Utility Fund Cash Flows .................................................................. Page 14 Street Light Utility Fund Cash Flows .................................................................. Page 15 Technology Fund Technology Capital Plan ............................................. Pages 16-17 Cash Flows .................................................................. Page 18 EBHC Capital Fund EBHC Capital Plan ..................................................... Pages 19-20 Cash Flows .................................................................. Page 21 BC Liquor BC Liquor Capital Plan .............................................. Page 22 Attachments: 2019-2033 CIP Power Point Presentation 2019-2033 Capital Improvement Program Page | 1 City of Brooklyn Center 2019 CAPITAL IMPROVEMENT PROGRAM PROFILE The 2019-33 Capital Improvement Plan (CIP) is a planning document that presents a fifteen-year overview of scheduled capital projects to address the City’s goals for maintaining public infrastructure. The CIP includes a long-term financing plan that allows the City to allocate funds for these projects based on assigned priorities. The fifteen-year horizon of the CIP provides the City with an opportunity to evaluate project priorities annually and to adjust the timing, scope and cost of projects as new information becomes available. The information contained in this plan represents an estimate of improvement costs based on present knowledge and expected conditions. Changes in community priorities, infrastructure condition and inflation rates require that adjustments be made on a routine basis. A capital improvement is defined as a major non-recurring expenditure related to the City’s physical facilities and grounds. The 2019-2033 CIP makes a concerted effort to distinguish between major maintenance projects contained in the City’s operating budgets and capital improvement projects financed through the City’s capital funds and proprietary funds. Typical expenditures include the cost to construct roads, utilities, parks, or municipal structures. The CIP is predicated on the goals and policies established by the City Council, including the general development, redevelopment and maintenance policies that are part of the City’s Comprehensive Plan. A primary objective of the CIP is to identify projects that further these goals and policies in a manner consistent with funding opportunities and in coordination with other improvement projects. CIP Project Types The CIP proposes capital expenditures totaling approximately $198.2 million over the next 15 years for improvements to the City’s streets, parks, public utilities and municipal buildings. A brief description of the four functional areas is provided below. Public Utilities The City operates four utility systems, all of which have projects included in the CIP - water, sanitary sewer, storm drainage and street lighting. A vast majority of the public utility improvements are constructed in conjunction with street reconstruction projects. The remaining portion of public utilities projects include improvements to water supply wells, water towers, lift stations, force mains and storm water treatment system. Street Improvements Street improvements include reconstruction or resurfacing of neighborhood (local), collector and arterial streets. Proposed improvements include the installation or reconstruction of curb and gutter along public roadways. As noted earlier, street improvements are often accompanied by replacement of public utilities. Park Improvements Park improvements include the construction of trails, shelters, playground equipment, athletic field lighting and other facilities that enhance general park appearance and increase park usage by providing recreational facilities that meet community needs. 1 2019-2033 Capital Improvement Program Page | 2 Capital Maintenance Building Improvements Capital maintenance building improvements include short and long term building and facility improvements identified in the 18-year Capital Maintenance Building Program approved in 2007. CIP Funding Sources Capital expenditures by funding source for the fifteen-year period are shown in Table 1 and Figure 1. Major funding sources are described below. Public Utility Funds Customers are billed for services provided by the City’s water, sanitary sewer, storm sewer and street lighting public utilities. Fees charged to customers are based on operating requirements and capital needs to ensure that equipment and facilities are replaced to maintain basic utility services. Annually the City Council evaluates the needs of each public utility system and establishes rates for each system to meet those needs. Special Assessments Properties benefiting from street and storm sewer improvements are assessed a portion of the project costs in accordance with the City’s Special Assessment Policy. Every year the City Council establishes special assessment rates for projects occurring the following year. Rates are typically adjusted annually to maintain the relative proportion of special assessments to other funding sources. Street Reconstruction Fund The Street Reconstruction Fund provides for the cost of local street improvements along roadways that are not designated as Municipal State Aid (MSA) routes. The revenue for this fund is generated from franchise fees charged for the use of public right-of-way by natural gas and electric utility companies. Debt was issued in 2018 to supplement this fund and is expected to again be issued in future years to maintain the current reconstruction plan. MSA Fund State-shared gas taxes provide funding for street improvements and related costs for those roadways identified as MSA streets. The City has 21 miles of roadway identified as MSA streets and is therefore eligible to receive funding based on this designation. The annual amount available in 2019 is estimated to be $1,070,000 and provides for maintenance and construction activities within the City’s MSA street system. Capital Projects Funds The City Council adopted a Capital Project Funding Policy in January 2014, to provide reoccurring sources of funding for the City’s Capital Projects Funds. The Policy specifically identifies three main funding sources including: audited year-end General Fund unassigned fund balance above 52 percent of the next year’s General Fund operating budget; audited year-end Liquor Fund unrestricted cash balance that exceeds three and a half months of the next year’s operating budget and one year of budgeted capital equipment needs; and Local Governmental Aid (LGA) received in the amount of $650,000 or half of the amount received by the City (whichever is greater). Other funding sources in this category include grants, park district funding, watershed funding, federal and state funding and county funding as determined on a project by project basis. Typically the City Council has directed these funds towards municipal facilities such as parks, trails, public buildings and other general purpose needs. 2 2019-2033 Capital Improvement Program Page | 3 TABLE 1. 2019-2033 Capital Improvement Plan - Summary by Funding Source FIGURE 1. 2019-2033 Capital Improvement Plan – Overview of Project and Funding Sources Water Utility, 12%Sanitary Sewer, 9% Storm Drainage, 10% Street Light, 1% MSA, 6.0% Street Reconstruction, 16.0% Capital Projects, 35% Special Assessments, 11% Capital Improvement Plan by Funding Source Total Funding Need 15-yr Average Annual Funding Need Percent of Total Need Water Utility $22,107,000 $1,473,800 11% Sanitary Sewer Utility $18,227,000 $1,215,133 9% Storm Drainage Utility $18,424,470 $1,228,298 10% Street Lighting Utility $1,883,000 $125,533 1% Municipal State Aid $11,504,000 $766,933 6% Street Reconstruction Fund $32,238,235 $2,149,216 16% Capital Projects Fund $74,119,000 $4,941,267 37% Special Assessment Collections $19,698,295 $1,313,220 10% TOTAL $198,201,000 $13,213,400 100% 3 Ta b l e 2 Ca p i t a l I m p r o v e m e n t P r o g r a m ( 2 0 1 9 - 2 0 3 3 ) Ju l y 9 , 2 0 1 8 Sp e c i a l S t r e e t M S A S t o r m D r a i n a g e S a n i t a r y S e w e r W a t e r S t r e e t L i g h t C a pi t a l P r o j e c t s T o t a l P r o j e c t Pr o j e c t As s e s s m e n t s R e c o n s t . F u n d F u n d U t i l i t y U t i l i t y U t i l i t y U t i l i t y F u n d s C o st tracking Notes 20 1 9 In t e r s t a t e A r e a I m p r o v e m e n t s $1 , 4 4 0 , 0 0 0 $ 3 , 4 4 0 , 0 0 0 $0 $ 1 , 6 7 0 , 0 0 0 $ 1 , 7 5 0 , 0 0 0 $ 2 , 6 0 0 , 0 0 0 $ 9 0 , 0 0 0 $0 $10,990,000 Be l l v u e A r e a M i l l a n d O v e r l a y $2 5 0 , 0 0 0 $ 7 9 0 , 0 0 0 $ 1 6 0 , 0 0 0 $ 3 9 0 , 0 0 0 $ 6 0, 0 0 0 $ 4 0 , 0 0 0 $0 $0 $1,690,000 Carryover from 2018 So u t h e a s t A r e a M i l l a n d O v e r la y $1 , 3 7 0 , 0 0 0 $ 7 3 0 , 0 0 0 $ 9 0 , 0 0 0 $ 5 9 0 , 0 0 0 $ 1 2 0 , 0 0 0 $ 7 0 , 0 0 0 $0 $0 $2,970,000 Br o o k l y n B o u l e v a r d C o r r i d o r P r o j e c t ( 4 9 t h A v e . t o B a s s L k R d ) $0 $0 $0 $ 4 8 2 , 0 0 0 $ 7 5 , 0 0 0 $ 1 6 7 , 0 0 0 $ 1 4 0 , 00 0 $ 1 4 , 2 2 1 , 0 0 0 ( A ) $ 1 5 , 0 8 5 , 0 0 0 Carryover from 2018 with updated co sts ; a potion of the projec t was spent in 2017 and 2018 51 s t A v e n u e I m p r o v e m e n t s ( a t B r o o k l y n B l v d ) $2 8 , 2 9 5 $ 2 4 8 , 2 3 5 $ 1 2 0 , 00 0 $ 7 3 , 4 7 0 $ 6 0 , 0 0 0 $ 7 0 , 0 0 0 $0 $0 $600,000 Carryover from 2018 Br i d g e R e h a b ( 4 b r i d g e s ) $0 $ 2 2 6 , 0 0 0 $0 $0 $0 $0 $0 $0 $226,000 Carryover from 2018 Pa r k P l a y g r o u n d E q u i p R e p l a c em e n t $0 $0 $0 $0 $0 $0 $0 $ 4 7 6 , 0 0 0 $476,000 Co n n e c t i o n s a t S h i n g l e C r e e k P h a s e 2 ( C r e e k S t a b i l i z a t i o n P r o j e ct $0 $0 $0 $ 9 6 , 0 0 0 $0 $0 $0 $ 2 8 7 , 0 0 0 ( B ) $383,000 70 t h A v e n u e S t o r m S e w e r T r u n k L i n e R e h a b i l i t a t i o n $0 $0 $0 $ 3 2 8 , 0 0 0 $0 $0 $0 $0 $328,000 St o r m W a t e r P o n d s 2 6 - 0 0 4 , 2 6 - 00 6 , 3 5 - 0 0 3 & 3 5 - 0 0 4 R e h a b $0 $0 $ 1 4 9 , 0 00 $0 $0 $0 $0 $149,000 Grouped ponds in similar area: Ponds 26-004 and 35-003 moved from 2022 to 2019 Li f t S t a t i o n N o . 2 R e h a b i l i t a t i o n a n d M i s s . R i v e r T r u n k S e w e r L in i n g $0 $0 $0 $ 8 5 0 , 0 0 0 $0 $0 $0 $850,000 Carryover from 2018 and added sewer lining W e l l N o s . 2 a n d 3 R e h a b i l i t a t i on $0 $0 $0 $0 $0 $ 1 4 0 , 0 0 0 $0 $0 $140,000 CM B P : P u b l i c W o r k s - R o o f R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 5 8 3 , 0 0 0 $583 ,000 CARS spreadsheet CM B P : C i v i c C e n t e r - G e n e r a t o r R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 1 1 4 , 0 0 0 $114,000 CARS spreadsheet 20 1 9 S u b t o t a l $3 , 0 8 8 , 2 9 5 $ 5 , 4 3 4 , 2 3 5 $ 3 7 0 , 0 0 0 $ 3 , 7 7 8 , 4 7 0 $ 2 , 9 1 5 , 0 0 0 $ 3 , 0 8 7 , 0 0 0 $ 2 3 0 , 0 0 0 $ 1 5 , 6 8 1 , 0 0 0 $34,584,000 NO T E S : (B ) W a t e r s h e d f u n d i n g e s t i m a t e d a t 7 5 % ( $ 2 8 7 k ) a n d 2 5 % C i t y f u n di n g ( $ 9 6 k ) 20 2 0 Gr a n d v i e w P a r k A r e a I m p r o v em e n t s $ 1 , 9 0 0 , 0 0 0 $ 3 , 9 1 0 , 0 0 0 $ 3 7 0 , 0 0 0 $ 1 , 9 1 0 , 0 0 0 $ 1 , 7 6 0 , 0 0 0 $ 2 , 3 2 0 , 00 0 $ 1 4 0 , 0 0 0 $0 $12,310,000 Hu m b o l d t A v e ( C R 5 7 ) R e c o n s t r u c t i o n ( 5 3 r d t o 5 7 t h ) $3 9 0 , 0 0 0 $0 $ 2 0 0, 0 0 0 $ 1 1 0 , 0 0 0 $ 3 3 0 , 0 0 0 $ 3 2 0 , 0 0 0 $ 2 0 , 0 0 0 $7 0 0 , 0 0 0 ( C ) $ 2 , 0 7 0 , 0 0 0 P r e v . 2019: Lo g a n / L i l a c / 5 9 t h A v e n u e s R e c o n s t r u c t i o n $4 0 0 , 0 0 0 $0 $ 1 , 2 9 0 , 0 0 0 $ 1 2 0 ,0 0 0 $ 1 0 , 0 0 0 $ 2 8 0 , 0 0 0 $ 2 0 , 0 0 0 $0 $2,120,000 Mi s c e l l a n e o u s R e t a i n i n g W a l l R e p l a c e m e n t s $0 $0 $0 $0 $0 $0 $0 $ 3 6 4 , 0 0 0 $364,000 $ Change Br o o k l y n B l v d C i t y E n t r a n c e S i g n s R e h a b $0 $0 $0 $0 $0 $0 $0 $ 5 3 , 0 0 0 $53 ,000 Pa r k P l a y g r o u n d E q u i p R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 5 0 1 , 0 0 0 $501,000 Li f t S t a t i o n N o s . 8 R e h a b i l i t a t i o n $0 $0 $0 $0 $ 2 5 8 , 0 0 0 $0 $0 $0 $258,000 Prev. 2025 W a t e r T o w e r N o . 1 P a i n t i n g $0 $0 $0 $0 $0 $ 9 5 0 , 0 0 0 $0 $0 $950,000 Revise d cost per Consultant estimate W e l l N o . 5 R e h a b i l i t a t i o n $0 $0 $0 $0 $0 $ 7 4 , 0 0 0 $0 $0 $74,000 St o r m W a t e r P o n d 4 0 - 0 0 1 R e h a b $0 $0 $0 $ 2 5 8 , 0 0 0 $0 $0 $0 $0 $258,000 Adde d Engineering and Admin 20 2 0 S u b t o t a l $2 , 6 9 0 , 0 0 0 $ 3 , 9 1 0 , 0 0 0 $ 1 , 8 6 0 , 0 0 0 $ 2 , 3 9 8 , 0 0 0 $ 2 , 3 5 8 , 0 0 0 $ 3 , 9 4 4 , 0 0 0 $ 1 8 0, 0 0 0 $ 1 , 6 1 8 , 0 0 0 $18,958,000 NO T E S : (C ) A n t i c i p a t e d H e n n e p i n C o u n t y f u n d i n g s h a r e - H u m b o l d t A v e i s a c o u n t y r o a d ( C R 5 7 ) 20 2 1 Ry a n L a k e I n d u s t r i a l P a r k A r e a I m p r o v e m e n t s $ 2 9 0 , 0 0 0 $ 5 6 0 , 0 0 0 $ 0 $ 2 70 , 0 0 0 $ 1 6 0 , 0 0 0 $ 4 2 0 , 0 0 0 $ 1 0 , 0 0 0 $ 0 $ 1 , 7 1 0 , 0 0 0 No r t h w e s t A r e a M i l l a n d O v e r la y $ 2 1 0 , 0 0 0 $ 5 5 0 , 0 0 0 $ 0 $ 3 9 0 , 0 0 0 $ 1 2 0 , 0 00 $ 2 0 0 , 0 0 0 $ 5 0 , 0 0 0 $ 0 $ 1 , 5 2 0 , 0 0 0 Ly n d a l e A v e n u e I m p r o v e m e n t s $5 0 , 0 0 0 $ 2 3 0 , 0 0 0 $ 1 6 0 , 0 0 0 $ 9 0 , 0 0 0 $ 1 4 0 , 0 00 $ 2 0 , 0 0 0 $ 2 0 , 0 0 0 $ 0 $ 7 1 0 , 0 0 0 Br o o k l y n B o u l e v a r d C o r r i d o r P h a s e 2 - B a s s L k R d t o I - 9 4 $ 0 $ 0 $ 7 0 0, 0 0 0 $ 2 4 0 , 0 0 0 $ 9 0 , 0 0 0 $ 1 8 0 , 0 0 0 $ 0 $ 1 3 , 60 3 , 0 0 0 ( D ) $ 1 4 , 8 1 3 , 0 0 0 U p d a t e d Costs for construction, ROW, OH utilities undergrounding and ut ilities TH 2 5 2 / 6 6 t h I n t e r c h a n g e a n d 7 0 t h P ed e s t r i a n O v e r p a s s $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 3 5 , 0 0 0 , 0 0 0 ( E ) $ 3 5 , 0 0 0 , 0 0 0 Tr a f f i c S i g S y s R e h a b ( S h i n g l e C r e e k P k w y / S u m m i t ) $ 0 $ 6 7 , 0 0 0 $ 2 0 1 , 00 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 2 6 8 , 0 0 0 Tr a f f i c S i g S y s R e h a b . ( S h i n g l e C r k P k w y / J o h n M a r t i n ) $ 0 $ 6 7 , 0 0 0 $ 20 1 , 0 0 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 2 6 8 , 0 0 0 Pa r k P l a y g r o u n d E q u i p R e p l a c em e n t $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 5 2 8 , 0 0 0 $ 5 2 8 , 0 0 0 61 s t & P e r r y A v e n u e s S t o r m S e w e r I m p r o v e m e n t $ 0 $ 0 $ 0 $ 1 7 0 , 0 0 0 $ 0 $ 0 $ 0 $ 0 $ 1 7 0 , 0 0 0 65 t h A v e n u e T r u n k S t o r m S e w e r R eh a b i l i t a t i o n $ 0 $ 0 $ 0 $ 4 6 4 , 0 0 0 $ 0 $ 0 $ 0 $ 0 $ 4 6 4 , 0 0 0 Li f t S t a t i o n N o . 9 R e h a b i l i t a t i o n $ 0 $ 0 $ 0 $ 0 $ 2 6 5 , 0 0 0 $ 0 $ 0 $ 0 $ 2 6 5 , 0 0 0 Prev. 2025 Li f t S t a t i o n N o . 9 F o r c e M a i n R e p l a c e m e n t $ 0 $ 0 $ 0 $ 0 $ 3 0 5 , 0 0 0 $ 0 $ 0 $ 0 $305,000 Prev. 2018 Moved due to Opportunity Site W e l l N o . 1 0 a n d H i g h S e r v i c e P u m p ( H S P ) R e h a b ( B W ) $ 0 $ 0 $ 0 $ 0 $ 0 $ 9 3 ,0 0 0 $ 0 $ 0 $ 9 3 , 0 0 0 CM B P : C i v i c C e n t e r - C o o l i n g R e p l a c e ( C h i l l e r s / c o n d e n s e r s ) $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 1 1 0 , 0 0 0 $ 1 1 0 , 0 0 0 C A R S s p r e a d s h e e t 20 2 1 S u b t o t a l $5 5 0 , 0 0 0 $ 1 , 4 7 4 , 0 0 0 $ 1 , 2 6 2 , 0 0 0 $ 1 , 6 2 4 , 0 0 0 $ 1 , 0 8 0 , 0 0 0 $ 9 1 3 , 0 0 0 $ 8 0 , 0 0 0 $ 4 9 , 2 4 1 , 0 0 0 $56,224,000 NO T E S : (D ) B r o o k l y n B o u l e v a r d C o r r i d o r I m p . f u n d i n g e s t i m a t e d a t 7 5 % o ut s i d e s o u r c e ( $ 1 1 , 4 6 6 , 0 0 0 ) a n d w o rs t c a s e 2 5 % b y t h e C i t y C a p i ta l I m p r o v e m e n t s F u n d ( $ 2 , 1 3 7 , 0 0 0 ) (E ) P r o v i s i o n a l p r o j e c t : f u n d i n g e s t i m a t e d o u t s i d e s o u r c e ( $ 2 9 , 50 0 , 0 0 0 ) a n d C i t y C a p i t a l I m pr o v e m e n t s F u n d ( $ 5 , 5 0 0 , 0 0 0 ) (A ) F e d e r a l f u n d i n g ( $ 7 , 1 0 1 , 0 0 0 ) , H e n n e p i n C o u n t y ( $ 2 , 9 8 3 , 0 0 0 ) , M i n n e a p o l i s ( $ 9 8 , 0 0 0 ) , T h r e e R i v e r s P a r k D i s t r i c t ( $ 1 0 , 0 0 0 ) , X c e l U t i l i t y S u r c h a r g e ( $ 2 8 0 , 0 0 0 ) T I F Di s t r i c t 2 F u n d ( $ 5 2 5 , 0 0 0 ) C i t y C a p i t a l I m p r o v e m e n t s F u n d ( $ 3 , 2 24 , 0 0 0 ) . G: \ B u d g e t \ 2 0 1 9 B u d g e t \ C a p i t a l I m p r o v e m e n t P l a n s \ C o p y o f 1 8 0 7 0 9 _ D R A F T _ 2 0 1 9 - 2 0 3 3 C I P T a b l e 2 4 Ta b l e 2 Ca p i t a l I m p r o v e m e n t P r o g r a m ( 2 0 1 9 - 2 0 3 3 ) Ju l y 9 , 2 0 1 8 Sp e c i a l S t r e e t M S A S t o r m D r a i n a g e S a n i t a r y S e w e r W a t e r S t r e e t L i g h t C a pi t a l P r o j e c t s T o t a l P r o j e c t Pr o j e c t As s e s s m e n t s R e c o n s t . F u n d F u n d U t i l i t y U t i l i t y U t i l i t y U t i l i t y F u n d s C o st tracking Notes 20 2 2 W o o d b i n e A r e a I m p r o v e m e n t s $1 , 6 2 0 , 0 0 0 $ 1 , 7 5 0 , 0 0 0 $ 1 5 0 , 0 0 0 $ 4 9 0 , 0 0 0 $ 1 , 3 4 0 , 0 0 0 $ 2 , 4 5 0 , 0 0 0 $ 1 3 0 , 0 0 0 $0 $7,930,000 Mi s c e l l a n e o u s P a r k P a r k i n g L o t M i l l a n d O v e r l a y $0 $0 $0 $0 $0 $0 $ 5 5 3 ,0 0 0 $553,000 new W e s t R i v e r R d , A r b o r e t u m , F r e e w a y , P a l m e r L a k e & N o r t h p o r t T r a i l R e p l a c e m e n t s $0 $0 $0 $0 $0 $0 $ 5 3 3 , 0 0 0 $533,000 St o r m W a t e r P o n d s 1 2 - 0 0 1 , 1 2 - 00 6 & 5 7 - 0 0 3 R e h a b $0 $0 $0 $ 1 1 8 , 0 0 0 $0 $0 $0 $0 $118,000 Grouped ponds in sim ilar area: Ponds 12-001 and 1 2-006 moved from 2019 to 2022 Fr e e w a y a n d H i g h w a y U t i l i t y C r o s s i n g R e p l a c e m e n t $0 $0 $0 $0 $ 1 7 3 , 0 0 0 $ 3 4 4 , 0 0 0 $0 $0 $517,000 new W e l l N o . 7 a n d W a t e r T r e a t m e n t P l a n t H S P N o . 1 $0 $0 $0 $0 $0 $ 9 6 , 0 0 0 $0 $0 $96,000 CM B P : E & W F i r e - R o o f R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 3 3 5 , 0 0 0 $335,000 CARS spreadsheet CM B P : P u b l i c W o r k s - L i g h t i n g S y s t e m U p g r a d e $0 $0 $0 $0 $0 $0 $0 $ 9 0 , 0 00 $90,000 CARS spreadsheet CM B P : C i v i c C e n t e r - A i r H a n d l e r s # 4 , # 5 R e p l a c e $0 $0 $0 $0 $0 $0 $0 $ 62 , 0 0 0 $62,000 CARS spreadsheet CM B P : W e s t F i r e - R o o f t o p U n i t R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 5 5 , 0 0 0 $55,000 CARS spreadsheet CM B P : P u b l i c W o r k s - F u r n a c e R e p l a c e m e n t s ( 3 ) $0 $0 $0 $0 $0 $0 $0 $ 5 0 , 00 0 $50,000 CARS spreadsheet 20 2 2 S u b t o t a l $1 , 6 2 0 , 0 0 0 $ 1 , 7 5 0 , 0 0 0 $ 1 5 0 , 0 0 0 $ 6 0 8 , 0 0 0 $ 1 , 5 1 3 , 0 0 0 $ 2 , 8 9 0 , 0 0 0 $ 1 3 0 , 0 0 0 $ 1 , 6 7 8 , 0 0 0 $10,339,000 20 2 3 53 r d A v e n u e I m p r o v e m e n t s ( P e n n A v e t o L y n d a l e A v e ) $ 3 0 , 0 0 0 $ 0 $ 2 , 3 80 , 0 0 0 $ 4 0 0 , 0 0 0 $ 1 0 0 , 0 0 0 $ 4 6 0 , 0 0 0 $ 1 4 0 , 0 0 0 $0 $3,510,000 50 t h A v e n u e I m p r o v e m e n t s ( F r a n c e A v e t o D r e w A v e ) $5 0 , 0 0 0 $ 1 0 0 , 0 0 0 $0 $ 3 0 , 0 0 0 $ 2 0 , 0 0 0 $ 1 4 0 , 0 0 0 $0 $0 $340,000 51 s t A v e n u e I m p r o v e m e n t s ( w e s t o f F r a n c e A v e n u e ) $1 5 0 , 0 0 0 $ 1 3 0 , 0 0 0 $0 $ 5 0 , 0 0 0 $ 1 0 , 0 0 0 $ 1 0 , 0 0 0 $ 2 0 , 0 0 0 $0 $370,000 Kn o x , J a m e s a n d 5 4 t h A v e . A r ea I m p r o v e m e n t s $2 6 0 , 0 0 0 $ 4 6 0 , 0 0 0 $0 $ 2 1 0 , 0 0 0 $ 2 0 , 0 0 0 $ 1 0 , 0 0 0 $0 $0 $960,000 Ea r l e B r o w n / O p p o r t u n i t y A r e a S t r e e t L i g h t R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $ 2 5 3 , 0 0 0 $0 $253,000 Prev. 2018 Mov ed due to Opportunity Site Ev e r g r e e n P a r k S c o r e B o a r d I m p r o v e m e n t s $0 $0 $0 $0 $0 $0 $0 $ 1 4 0 , 0 0 0 $1 40,000 Prev. 2027 Li f t S t a t i o n N o s . 3 a n d 4 R e h a b i l i t a t i o n $0 $0 $0 $0 $ 5 6 3 , 0 0 0 $0 $0 $0 $563,000 Prev. 2028 W e l l N o s . 4 a n d 9 ; W a t e r T r e a t m e n t P l a n t H S P N o . 2 $0 $0 $0 $0 $0 $ 1 8 0, 0 0 0 $0 $0 $180,000 St o r m W a t e r P o n d 4 8 - 0 0 1 R e h a b $0 $0 $0 $ 2 0 2 , 0 0 0 $0 $0 $0 $0 $202,000 Adde d Engineering and Admin CM B P : C i t y H a l l / C C A d d i t i o n - R o o f R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 3 3 4, 0 0 0 $334,000 CARS spreadsheet 20 2 3 S u b t o t a l $4 9 0 , 0 0 0 $ 6 9 0 , 0 0 0 $ 2 , 3 8 0 , 0 0 0 $ 8 9 2 , 0 0 0 $ 7 1 3 , 0 0 0 $ 8 0 0 , 0 0 0 $ 4 1 3 , 0 0 0 $ 4 7 4 , 00 0 $6,852,000 20 2 4 Or c h a r d L a n e E a s t I m p r o v e m e n t s $ 2 , 4 6 0 , 0 0 0 $ 2 , 7 0 0 , 0 0 0 $ 0 $ 2 8 0 , 0 0 0 $ 1 , 3 9 0 , 0 0 0 $ 2 , 9 6 0 , 0 0 0 $ 1 6 0 , 0 0 0 $0 $9,950,000 Hu m b o l d t A v e I m p r o v e m e n t s $3 2 0 , 0 0 0 $0 $ 3 8 0 , 0 0 0 $ 7 0 , 0 0 0 $ 2 9 0 , 0 0 0 $ 1 7 0 , 0 0 0 $ 3 0 , 0 0 0 $0 $1,260,000 Ce n t e n n i a l P a r k S o f t b a l l F i e l d I m p r o v e m e n t s $0 $0 $0 $0 $0 $0 $0 $ 5 6 2 , 0 0 0 $562,000 Prev. 2026 W e l l N o s . 6 a n d 8 ; W a t e r T r e a t m en t P l a n t H S P N o . 3 $0 $0 $0 $0 $0 $ 1 85 , 0 0 0 $0 $0 $185,000 CM B P : P o l i c e - R o o f R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 2 1 9 , 0 0 0 $219,000 CA RS spreadsheet 20 2 4 S u b t o t a l $2 , 7 8 0 , 0 0 0 $ 2 , 7 0 0 , 0 0 0 $ 3 8 0 , 0 0 0 $ 3 5 0 , 0 0 0 $ 1 , 6 8 0 , 0 0 0 $ 3 , 3 1 5 , 0 0 0 $ 1 9 0 , 0 0 0 $ 7 8 1 , 0 0 0 $12,176,000 20 2 5 Or c h a r d L a n e W e s t A r e a I m p r o v em e n t s $ 3 , 5 5 0 , 0 0 0 $ 2 , 9 1 0 , 0 0 0 $ 0 $ 2 1 0 , 0 0 0 $ 1 , 6 0 0 , 0 0 0 $ 1 7 0 , 0 0 0 $ 2 0 0 , 0 0 0 $0 $8,640,000 53 r d a n d X e r x e s A v e n u e I m p r o v em e n t s $8 0 , 0 0 0 $ 3 7 0 , 0 0 0 $0 $ 1 1 0 , 0 0 0 $0 $0 $ 6 0 , 0 0 0 $0 $620,000 Tr a f f i c S i g S y s R e h a b . ( S h i n g l e C r k P k w y / B r o o k d a l e S q ) $0 $ 1 0 0 , 0 0 0 $2 0 2 , 0 0 0 $0 $0 $0 $0 $0 $302,000 Pa r k N a m e S i g n R e p l a c e m e n t s $0 $0 $0 $0 $0 $0 $0 $ 7 0 , 0 0 0 $70,000 W e l l N o s . 2 a n d 3 ; W a t e r T r e a t m e n t P l a n t H S P N o . 4 $0 $0 $0 $0 $0 $ 1 9 0, 0 0 0 $0 $0 $190,000 New W a t e r M e t e r F u l l S y s t e m R e p l a c e m e n t $0 $0 $0 $0 $ 5 0 0 , 0 0 0 $ 1 , 5 0 0 , 0 0 0 $0 $0 $2,000,000 New per Finance on 8/11/17 St o r m W a t e r P o n d 1 7 - 0 0 1 R e h a b $0 $0 $0 $ 1 5 4 , 0 0 0 $0 $0 $0 $0 $154,000 Adde d Engineering and Admin CM B P : P u b l i c W o r k s C o l d - R o o f R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 1 0 1 , 0 0 0 $101,000 CARS spreadsheet CM B P : P u b l i c W o r k s S a l t - R o o f R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 4 8 , 0 0 0 $48,000 CARS spreadsheet 20 2 5 S u b t o t a l $3 , 6 3 0 , 0 0 0 $ 3 , 3 8 0 , 0 0 0 $ 2 0 2 , 0 0 0 $ 4 7 4 , 0 0 0 $ 2 , 1 0 0 , 0 0 0 $ 1 , 8 6 0 , 0 0 0 $ 2 6 0 , 0 0 0 $ 2 1 9 , 0 0 0 $12,125,000 G: \ B u d g e t \ 2 0 1 9 B u d g e t \ C a p i t a l I m p r o v e m e n t P l a n s \ C o p y o f 1 8 0 7 0 9 _ D R A F T _ 2 0 1 9 - 2 0 3 3 C I P T a b l e 2 5 Ta b l e 2 Ca p i t a l I m p r o v e m e n t P r o g r a m ( 2 0 1 9 - 2 0 3 3 ) Ju l y 9 , 2 0 1 8 Sp e c i a l S t r e e t M S A S t o r m D r a i n a g e S a n i t a r y S e w e r W a t e r S t r e e t L i g h t C a pi t a l P r o j e c t s T o t a l P r o j e c t Pr o j e c t As s e s s m e n t s R e c o n s t . F u n d F u n d U t i l i t y U t i l i t y U t i l i t y U t i l i t y F u n d s C o st tracking Notes 20 2 6 Me a d o w l a r k G a r d e n s A r e a I m p r o v e m e n t s $ 9 5 0 , 0 0 0 $ 7 0 0 , 0 0 0 $ 3 8 0 , 0 0 0 $ 1 7 0 , 0 0 0 $ 8 0 , 0 0 0 $ 3 2 0 , 0 0 0 $ 1 2 0 , 0 0 0 $0 $2,720,000 67 t h A v e n u e a n d J a m e s A v e n u e M il l a n d O v e r l a y $1 6 0 , 0 0 0 $ 1 1 0 , 0 0 0 $0 $1 1 0 , 0 0 0 $ 1 0 , 0 0 0 $ 1 0 , 0 0 0 $ 2 0 , 0 0 0 $0 $420,000 68 t h A v e n u e a n d L e e A v e n u e M i l l a n d Ov e r l a y $1 3 0 , 0 0 0 $ 9 0 , 0 0 0 $0 $ 8 0 ,0 0 0 $ 1 0 , 0 0 0 $ 1 0 , 0 0 0 $ 2 0 , 0 0 0 $0 $340,000 Jo h n M a r t i n D r i v e M i l l a n d O v e r l a y $1 0 0 , 0 0 0 $0 $ 1 2 0 , 0 0 0 $ 3 0 , 0 0 0 $ 1 0 , 00 0 $ 1 0 , 0 0 0 $ 6 0 , 0 0 0 $0 $330,000 St . A l p h o n s e s A r e a M i l l a n d O v er l a y $4 0 0 , 0 0 0 $ 1 9 0 , 0 0 0 $0 $ 2 3 0 , 0 0 0 $ 4 0 , 0 0 0 $ 2 0 , 0 0 0 $ 5 0 , 0 0 0 $0 $930,000 Ho c k e y R i n k R e h a b i l i t a t i o n / R e p l a c e m e n t s $0 $0 $0 $0 $0 $0 $0 $ 2 0 5 , 0 0 0 $2 05,000 Ir r i g a t i o n S y s t e m s R e h a b i l i t a t i o n / R e p l a c e m e n t s $0 $0 $0 $0 $0 $0 $0 $ 1 3 7, 0 0 0 $137,000 Li f t S t a t i o n N o s . 5 a n d 6 R e h a b i l i t a t i o n $0 $0 $0 $0 $ 6 0 6 , 0 0 0 $0 $0 $0 $606,000 Prev. 2029 W e l l N o . 5 a n d W a t e r T r e a t m e n t P l a n t H S P ( B W ) $0 $0 $0 $0 $0 $ 1 0 7 , 0 0 0 $0 $0 $107,000 St o r m W a t e r P o n d s 4 1 - 0 0 1 , 4 1 - 00 2 & 5 3 - 0 0 1 R e h a b $0 $0 $0 $ 1 3 8 , 0 0 0 $0 $0 $0 $0 $138,000 Added Engineering and Admin CM B P : W e s t F i r e - G e n e r a t o r / T r a n s f e r R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 13 0 , 0 0 0 $130,000 CARS spreadsheet 20 2 6 S u b t o t a l $1 , 7 4 0 , 0 0 0 $ 1 , 0 9 0 , 0 0 0 $ 5 0 0 , 0 0 0 $ 7 5 8 , 00 0 $ 7 5 6 , 0 0 0 $ 4 7 7 , 0 0 0 $ 2 7 0 , 0 0 0 $ 4 7 2, 0 0 0 $6,063,000 20 2 7 Ea r l e B r o w n D r i v e A r e a I m p r o v e m e n t s $ 5 0 , 0 0 0 $ 1 , 3 6 0 , 0 0 0 $ 5 1 0 , 0 0 0 $ 1 1 0, 0 0 0 $ 2 0 , 0 0 0 $ 2 0 , 0 0 0 $ 0 $ 0 $ 2 , 0 7 0 , 0 0 0 66 t h A v e n u e a n d C a m d e n A v e n u e M il l a n d O v e r l a y $ 2 0 , 0 0 0 $ 6 3 0 , 0 0 0 $ 3 6 0 , 0 0 0 $ 7 0 , 0 0 0 $ 1 0 , 0 0 0 $ 1 0 , 0 0 0 $0 $0 $1,100,000 73 r d A v e n u e M i l l a n d O v e r l a y ( H um b o l d t t o C a m d e n ) $5 0 , 0 0 0 $0 $ 2 0 0 , 00 0 $ 4 0 , 0 0 0 $ 2 0 , 0 0 0 $ 1 0 , 0 0 0 $0 $0 $320,000 So f t b a l l / B a s e b a l l F e n c e R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 6 2 , 0 0 0 $62,000 69 t h A v e n u e T r a i l R e c o n s t r u c t i o n $0 $0 $0 $0 $0 $0 $0 $ 2 0 8 , 0 0 0 $208,000 69 t h A v e n u e L a n d s c a p e R e h a b i l i t a t i o n $0 $0 $0 $0 $0 $0 $0 $ 1 3 9 , 0 0 0 $139,000 W e l l N o . 1 0 a n d W a t e r T r e a t m e n t P l a n t H S P N o . 1 $0 $0 $0 $0 $0 $ 1 0 8 , 0 00 $0 $0 $108,000 CM B P : P o l i c e - M a i n C o n d e n s e r $0 $0 $0 $0 $0 $0 $0 $ 5 4 , 0 0 0 $54,000 CARS s preadsheet CM B P : P o l i c e - G e n e r a t o r / T r a n s f e r R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 1 5 5 ,0 0 0 $155,000 CARS spreadsheet 20 2 7 S u b t o t a l $1 2 0 , 0 0 0 $ 1 , 9 9 0 , 0 0 0 $ 1 , 0 7 0 , 0 0 0 $ 2 2 0 , 00 0 $ 5 0 , 0 0 0 $ 1 4 8 , 0 0 0 $0 $ 6 1 8 , 0 0 0 $4,216,000 20 2 8 Ga r d e n C i t y C e n t r a l A r e a M il l a n d O v e r l a y $ 7 1 0 , 0 0 0 $ 1 , 6 6 0 , 0 0 0 $ 2 6 0 , 0 0 0 $ 8 8 0 , 0 0 0 $ 3 7 0 , 0 0 0 $ 1 0 0 , 0 0 0 $0 $0 $3,980,000 Pa r k T r a i l a n d P a r k i n g L o t L i g h t i n g I m p r o v e m e n t s $0 $0 $0 $0 $0 $0 $0 $ 38 0 , 0 0 0 $380,000 W e l l N o . 7 a n d W a t e r T r e a t m e n t P l a n t H S P N o . 2 $0 $0 $0 $0 $0 $ 1 1 0 , 0 0 0 $0 $0 $110,000 CM B P : C i t y H a l l - R i b b o n W i n d o w R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 7 0 , 0 0 0 $70,000 CARS spreadsheet CM B P : C o m m u n i t y C e n t e r - R i b b o n W i n d o w R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 9 5 , 0 0 0 $95,000 CARS spreadsheet CM B P : P o l i c e - C a r p e t R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 5 0 , 0 0 0 $50,000 CA RS spreadsheet 20 2 8 S u b t o t a l $7 1 0 , 0 0 0 $ 1 , 6 6 0 , 0 0 0 $ 2 6 0 , 0 0 0 $ 8 8 0 , 0 0 0 $3 7 0 , 0 0 0 $ 2 1 0 , 0 0 0 $0 $ 5 9 5 , 0 0 0 $4,685,000 20 2 9 Ga r d e n C i t y N o r t h A r e a M i l l an d O v e r l a y $ 6 0 0 , 0 0 0 $ 2 , 2 3 0 , 0 0 0 $ 0 $ 2 , 7 1 0 , 0 0 0 $ 5 7 0 , 0 0 0 $ 5 1 0 , 0 0 0 $0 $0 $6,620,000 Re t a i n i n g W a l l R e p l a c e m e n t ( m i s c e l l a n e o u s l o c a t i o n s ) $0 $0 $0 $0 $0 $0 $0 $ 1 1 7 , 0 0 0 $117,000 Revised funding from Street Recon to Capital Projects Fund Li f t S t a t i o n N o s . 7 a n d 1 0 R e h a b i l i t a t i o n $0 $0 $0 $0 $ 6 3 4 , 0 0 0 $0 $0 $0 $634,000 Prev. 2029 W e l l N o s . 4 a n d 9 a n d W a t e r T r e a t m e n t P l a n t H S P N o . 3 $0 $0 $0 $0 $0 $2 0 3 , 0 0 0 $0 $0 $203,000 St o r m W a t e r P o n d s 1 1 - 0 0 1 , 5 9 - 0 0 3 , 6 0 - 0 0 3 , 6 3 - 0 0 1 , 6 3 - 0 0 2 & 6 4 - 0 01 R e h a b $0 $0 $ 1 1 6 , 0 0 0 $0 $0 $0 $0 $116,000 Added Engineering and Admin CM B P : C i t y H a l l - M a i n S w i t c h G e a r R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 2 1 2, 0 0 0 $212,000 CARS spreadsheet CM B P : C o m m u n i t y C e n t e r - C a r p e t R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 5 0 , 0 0 0 $50,000 CARS spreadsheet 20 2 9 S u b t o t a l $6 0 0 , 0 0 0 $ 2 , 2 3 0 , 0 0 0 $0 $ 2 , 8 2 6 , 0 0 0 $ 1 , 2 0 4 , 0 0 0 $ 7 1 3 , 0 0 0 $0 $ 3 7 9 , 0 0 0 $7,952,000 20 3 0 Ga r d e n C i t y S o u t h A r e a M i l l an d O v e r l a y $ 4 8 0 , 0 0 0 $ 2 , 3 7 0 , 0 0 0 $ 8 6 0 , 0 0 0 $ 1 , 1 7 0 , 0 0 0 $ 7 1 0 , 0 0 0 $ 1 , 5 9 0 , 0 0 0 $ 1 0 , 0 0 0 $0 $7,190,000 Sa n i t a r y S e w e r L i n i n g ( M i s s . R iv e r T r u n k N . o f I - 6 9 4 t o 7 0 t h / W i ll o w ) $0 $0 $0 $ 1 , 5 1 4 , 0 0 0 $0 $0 $0 $1,514,000 Li f t N o . 2 F o r c e m a i n L i n i n g ( U n d e r I - 9 4 ) $0 $0 $0 $0 $ 2 4 9 , 0 0 0 $0 $0 $0 $249,000 W e l l N o s . 6 a n d 8 ; W a t e r T r e a t m e n t P l a n t H S P N o . 4 $0 $0 $0 $0 $0 $ 2 0 6, 0 0 0 $0 $0 $206,000 St o r m W a t e r P o n d s 5 7 - 0 0 4 & 5 7 - 00 5 R e h a b $0 $0 $0 $ 8 3 , 0 0 0 $0 $0 $0 $0 $83 ,000 Added Engineering and Admin CM B P : C i t y H a l l - B r i c k V e n e e r R e s t o r a t i o n $0 $0 $0 $0 $0 $0 $0 $ 1 0 3 , 0 0 0 $103,000 CARS spreadsheet CM B P : C o m m u n i t y C e n t e r - B r i c k V e n e e r R e s t o r a t i o n $0 $0 $0 $0 $0 $0 $0 $1 6 2 , 0 0 0 $162,000 CARS spreadsheet 20 3 0 S u b t o t a l $4 8 0 , 0 0 0 $ 2 , 3 7 0 , 0 0 0 $ 8 6 0 , 0 0 0 $ 1 , 2 5 3 , 0 0 0 $ 2 , 4 7 3 , 0 0 0 $ 1 , 7 9 6 , 0 0 0 $ 1 0 , 0 0 0 $2 6 5 , 0 0 0 $9,507,000 G: \ B u d g e t \ 2 0 1 9 B u d g e t \ C a p i t a l I m p r o v e m e n t P l a n s \ C o p y o f 1 8 0 7 0 9 _ D R A F T _ 2 0 1 9 - 2 0 3 3 C I P T a b l e 2 6 Ta b l e 2 Ca p i t a l I m p r o v e m e n t P r o g r a m ( 2 0 1 9 - 2 0 3 3 ) Ju l y 9 , 2 0 1 8 Sp e c i a l S t r e e t M S A S t o r m D r a i n a g e S a n i t a r y S e w e r W a t e r S t r e e t L i g h t C a pi t a l P r o j e c t s T o t a l P r o j e c t Pr o j e c t As s e s s m e n t s R e c o n s t . F u n d F u n d U t i l i t y U t i l i t y U t i l i t y U t i l i t y F u n d s C o st tracking Notes 20 3 1 So u t h w e s t A r e a M i l l a n d O v e r la y $ 5 5 0 , 0 0 0 $ 1 , 3 3 0 , 0 0 0 $ 9 6 0 , 0 0 0 $ 7 7 0 , 0 0 0 $ 5 0 0 , 0 0 0 $ 1 , 1 2 0 , 0 0 0 $ 7 0 , 0 0 0 $0 $5,300,000 Pa r k B l e a c h e r R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 6 2 , 0 0 0 $62,000 Li f t S t a t i o n N o . 1 G e n e r a t o r R e p l a c e m e n t $0 $0 $0 $0 $ 2 0 5 , 0 0 0 $0 $0 $0 $205,000 W e l l N o s . 2 a n d 3 a n d W a t e r T r e a t m e n t P l a n t H S P ( B W ) $0 $0 $0 $0 $0 $ 20 9 , 0 0 0 $0 $0 $209,000 St o r m W a t e r P o n d 2 6 - 0 0 5 & 7 0 - 0 0 2 Re h a b $0 $0 $0 $ 6 7 , 0 0 0 $0 $0 $0 $0 $67,000 Added Engineering and Admin CM B P : E a s t / W e s t F i r e - E p o x y F l o o r R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 9 2 ,0 0 0 $92,000 CARS spreadsheet CM B P : P u b l i c W o r k s - E x t e r i o r P a i n t $0 $0 $0 $0 $0 $0 $0 $ 8 0 , 0 0 0 $80,000 CARS spreadsheet CM B P : P u b l i c W o r k s - M a k e U p A i r ( 2 ) R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 13 0 , 0 0 0 $130,000 CARS spreadsheet 20 3 1 S u b t o t a l $5 5 0 , 0 0 0 $ 1 , 3 3 0 , 0 0 0 $ 9 6 0 , 0 0 0 $ 8 3 7 , 0 0 0 $ 7 0 5 , 0 0 0 $ 1 , 3 2 9 , 0 0 0 $ 7 0 , 0 0 0 $ 3 6 4 ,0 0 0 $6,145,000 20 3 2 Ha p p y H o l l o w M i l l a n d O v e r l a y $ 3 0 0 , 0 0 0 $ 1 , 0 6 0 , 0 0 0 $ 2 6 0 , 0 0 0 $ 6 8 0 , 0 0 0 $ 2 0 0 , 0 0 0 $ 3 4 0 , 0 0 0 $ 5 0 , 0 0 0 $2,890,000 Pa r k B l e a c h e r R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 8 2 , 0 0 0 $82,000 Br o o k l y n B l v d S t r e e t L i g h t R e p l a c e m e n t ( 6 5 t h t o B P B o r d e r ) $0 $0 $0 $0 $0 $0 $0 $ 8 8 1 , 0 0 0 $881,000 W e l l N o . 5 a n d W a t e r T r e a t m e n t P l a n t H S P N o . 1 $0 $0 $0 $0 $0 $ 1 1 7 , 0 0 0 $0 $0 $117,000 St o r m W a t e r P o n d 1 2 - 0 0 2 , 1 2 - 0 0 4 , 1 2 - 0 0 5 & 1 8 - 0 0 1 R e h a b $0 $0 $0 $ 3 6 6 ,0 0 0 $0 $0 $0 $0 $366,000 new CM B P : P u b l i c W o r k s - M a i n S w i t c h G e a r R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $1 8 0 , 0 0 0 $180,000 CARS spreadsheet CM B P : P u b l i c W o r k s - G e n e r a t o r / T r a n s f e r R e p l a c e m e n t $0 $0 $0 $0 $0 $0 $0 $ 1 4 0 , 0 0 0 $140,000 CARS spreadsheet 20 3 2 S u b t o t a l $3 0 0 , 0 0 0 $ 1 , 0 6 0 , 0 0 0 $ 2 6 0 , 0 0 0 $ 1 , 0 4 6 , 0 0 0 $ 2 0 0 , 0 0 0 $ 4 5 7 , 0 0 0 $ 5 0 , 0 0 0 $ 1 , 2 8 3 , 0 0 0 $4,656,000 20 3 3 No r t h p o r t A r e a M i l l a n d O v e r la y $ 3 5 0 , 0 0 0 $ 1 , 0 0 0 , 0 0 0 $ 4 8 0 , 0 0 0 $ 4 8 0 , 0 00 $ 1 1 0 , 0 0 0 $ 5 0 , 0 0 0 $ 0 $ 2 , 4 7 0 , 0 0 0 n e w Tr a f f i c S i g S y s R e h a b . ( 6 5 t h A v e n u e / D u p o n t A v e ) $ 0 $ 0 $ 3 4 0 , 0 0 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 3 4 0 , 0 0 0 n e w Tr a f f i c S i g S y s R e h a b . ( 6 6 t h A v e / C a m d e n A v e ) $ 0 $ 1 7 0 , 0 0 0 $ 1 7 0 , 0 0 0 $ 0 $0 $ 0 $ 0 $ 0 $ 3 4 0 , 0 0 0 n e w Ev e r g r e e n P a r k F o o t b a l l / S o c c e r F i e l d I m p r o v e m e n t s $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $1 3 5 , 0 0 0 $ 1 3 5 , 0 0 0 n e w W e l l N o . 1 0 a n d W a t e r T r e a t m e n t P l a n t H S P N o . 2 $ 0 $ 0 $ 0 $ 0 $ 0 $ 1 1 8 , 0 00 $ 0 $ 0 $ 1 1 8 , 0 0 0 n e w CM B P : P u b l i c W o r k s - M a k e U p A i r ( 2 ) R e p l a c e m e n t $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 76 , 0 0 0 $ 7 6 , 0 0 0 C A R S s p r e a d s h e e t CM B P : E a s t / W e s t F i r e - O v e r h e a d D o o r R e p l a c e m e n t s $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $1 7 0 , 0 0 0 $ 1 7 0 , 0 0 0 C A R S s p r e a d s h e e t CM B P : C o m m u n i t y C e n t e r - S a u n a R e c o n s t r u c t i o n $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 7 0 , 00 0 $ 7 0 , 0 0 0 C A R S s p r e a d s h e e t 20 3 3 S u b t o t a l $3 5 0 , 0 0 0 $ 1 , 1 7 0 , 0 0 0 $ 9 9 0 , 0 0 0 $ 4 8 0 , 0 0 0 $1 1 0 , 0 0 0 $ 1 6 8 , 0 0 0 $ 0 $ 4 5 1 , 0 0 0 $3,719,000 TO T A L S $1 9 , 6 9 8 , 2 9 5 $ 3 2 , 2 3 8 , 2 3 5 $ 1 1 , 5 0 4 , 0 0 0 $ 1 8 , 4 2 4 , 4 7 0 $ 1 8 , 2 2 7 , 0 0 0 $ 2 2 , 1 0 7 , 0 0 0 $ 1 , 8 8 3 , 0 0 0 $ 7 4 , 1 1 9 , 0 0 0 $198,201,000 G: \ B u d g e t \ 2 0 1 9 B u d g e t \ C a p i t a l I m p r o v e m e n t P l a n s \ C o p y o f 1 8 0 7 0 9 _ D R A F T _ 2 0 1 9 - 2 0 3 3 C I P T a b l e 2 7 Ci t y o f B r o o k l y n C e n t e r Ca p i t a l I m p r o v e m e n t s F u n d C a s h F l o w s A n a l y s i s Re v i s e d : 6 - 2 5 - 1 8 Ac t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 2 0 3 3 Re v e n u e s In t e r g o v e r n m e n t a l ( L G A ) 7 7 5 , 8 8 7 $ 88 4 , 4 5 4 $ 89 1 , 8 2 5 $ 89 1 , 8 2 5 $ 89 1 , 8 2 5 $ 89 1 , 8 2 5 $ 89 1 , 8 2 5 $ 89 1 , 8 2 5 $ 89 1 , 8 2 5 $ 89 1 , 8 2 5 $ 89 1 , 8 2 5 $ 89 1 , 8 2 5 $ 89 1 , 8 2 5 $ 891,825 $ 891,825 $ 891,825 $ 891,825 $ In v e s t m e n t E a r n i n g s 32 , 4 9 4 40 , 9 4 6 40 , 9 4 6 - - - - 3 , 2 5 6 7, 8 9 6 18 , 2 0 4 26 , 0 8 4 32 , 5 8 3 39 , 3 7 7 48,399 58,651 68,016 68,284 Mi s c e l l a n e o u s - 3 9 6 , 2 0 7 - - - - - - - - - - - - - - - TH 2 5 2 E x t e r n a l F u n d i n g E s t . - - - - 2 9 , 5 0 0 , 0 0 0 - - - - - - - - - - - Ex t e r n a l F u n d i n g S o u r c e s 2 2 9 , 5 8 5 10 , 1 9 2 , 0 0 0 19 1 , 0 0 0 - 1 1 , 4 6 6 , 0 0 0 - - - - - - - - - - - - Bo n d P r o c e e d s - - - - 7 , 6 3 7 , 0 0 0 - - - - - - - - - - - - De b t S e r v i c e T a x L e v y - - - - - 8 9 5 , 2 8 9 89 5 , 2 8 9 89 5 , 2 8 9 89 5 , 2 8 9 89 5 , 2 8 9 89 5 , 2 8 9 89 5 , 2 8 9 89 5 , 2 8 9 895,289 895,289 - - Tr a n s f e r s ( G e n e r a l ) 71 5 , 5 4 4 14 9 , 6 3 0 20 0 , 0 0 0 20 0 , 0 0 0 20 0 , 0 0 0 20 0 , 0 0 0 20 0 , 0 0 0 20 0 , 0 0 0 20 0 , 0 0 0 20 0 , 0 0 0 20 0 , 0 0 0 20 0 , 0 0 0 20 0 , 0 0 0 200,000 200,000 200,000 200,000 Tr a n s f e r s ( L i q u o r ) 11 2 , 8 9 8 18 5 , 7 0 7 15 0 , 0 0 0 15 0 , 0 0 0 15 0 , 0 0 0 15 0 , 0 0 0 15 0 , 0 0 0 15 0 , 0 0 0 15 0 , 0 0 0 15 0 , 0 0 0 15 0 , 0 0 0 15 0 , 0 0 0 15 0 , 0 0 0 150,000 150,000 150,000 150,000 To t a l 1, 8 6 6 , 4 0 8 11 , 8 4 8 , 9 4 4 1, 4 7 3 , 7 7 1 1, 2 4 1 , 8 2 5 49 , 8 4 4 , 8 2 5 2, 1 3 7 , 1 1 4 2, 1 3 7 , 1 1 4 2, 1 4 0 , 3 7 0 2, 1 4 5 , 0 1 0 2, 1 5 5 , 3 1 8 2, 1 6 3 , 1 9 8 2, 1 6 9 , 6 9 7 2, 1 7 6 , 4 9 1 2,185,513 2,195,765 1,309,841 1,310,109 Ex p e n d i t u r e s Ot h e r S e r v i c e s & C h a r g e s 3 7 , 8 8 7 - - - - - - - - - - - - - - - - Ca p i t a l O u t l a y 3, 9 7 7 , 6 0 7 14 , 5 1 6 , 1 3 2 1, 4 6 0 , 0 0 0 1, 6 1 8 , 0 0 0 49 , 2 4 1 , 0 0 0 1, 6 7 8 , 0 0 0 47 4 , 0 0 0 78 1 , 0 0 0 21 9 , 0 0 0 47 2 , 0 0 0 61 8 , 0 0 0 59 5 , 0 0 0 37 9 , 0 0 0 265,000 364,000 1,283,000 451,000 De b t S e r v i c e P r o j e c t e d - - - - - 8 9 5 , 2 8 9 89 5 , 2 8 9 89 5 , 2 8 9 89 5 , 2 8 9 89 5 , 2 8 9 89 5 , 2 8 9 89 5 , 2 8 9 89 5 , 2 8 9 895,289 895,289 - - Tr a n s f e r s - - - - - - - - - - - - - - - - - To t a l 4, 0 1 5 , 4 9 4 14 , 5 1 6 , 1 3 2 1, 4 6 0 , 0 0 0 1, 6 1 8 , 0 0 0 49 , 2 4 1 , 0 0 0 2, 5 7 3 , 2 8 9 1, 3 6 9 , 2 8 9 1, 6 7 6 , 2 8 9 1, 1 1 4 , 2 8 9 1, 3 6 7 , 2 8 9 1, 5 1 3 , 2 8 9 1, 4 9 0 , 2 8 9 1, 2 7 4 , 2 8 9 1,160,289 1,259,289 1,283,000 451,000 Ca s h B a l a n c e - B e g i n n i n g 4, 4 6 7 , 2 5 2 2, 4 1 9 , 6 6 8 (2 4 7 , 5 2 0 ) (2 3 3 , 7 4 9 ) (6 0 9 , 9 2 4 ) (6 , 0 9 9 ) (4 4 2 , 2 7 4 ) 32 5 , 5 5 1 78 9 , 6 3 2 1, 8 2 0 , 3 5 3 2, 6 0 8 , 3 8 2 3, 2 5 8 , 2 9 1 3, 9 3 7 , 6 9 9 4,839,901 5,865,125 6,801,601 6,828,442 Ch a n g e s i n A c c r u a l s 10 1 , 5 0 2 Re v e n u e s 1, 8 6 6 , 4 0 8 11 , 8 4 8 , 9 4 4 1, 4 7 3 , 7 7 1 1, 2 4 1 , 8 2 5 49 , 8 4 4 , 8 2 5 2, 1 3 7 , 1 1 4 2, 1 3 7 , 1 1 4 2, 1 4 0 , 3 7 0 2, 1 4 5 , 0 1 0 2, 1 5 5 , 3 1 8 2, 1 6 3 , 1 9 8 2, 1 6 9 , 6 9 7 2, 1 7 6 , 4 9 1 2,185,513 2,195,765 1,309,841 1,310,109 Ex p e n d i t u r e s (4 , 0 1 5 , 4 9 4 ) (1 4 , 5 1 6 , 1 3 2 ) (1 , 4 6 0 , 0 0 0 ) (1 , 6 1 8 , 0 0 0 ) (4 9 , 2 4 1 , 0 0 0 ) (2 , 5 7 3 , 2 8 9 ) (1 , 3 6 9 , 2 8 9 ) (1 , 6 7 6 , 2 8 9 ) (1 , 1 1 4 , 2 8 9 ) (1 , 3 6 7 , 2 8 9 ) (1 , 5 1 3 , 2 8 9 ) (1 , 4 9 0 , 2 8 9 ) (1 , 2 7 4 , 2 8 9 ) (1,160,289) (1,259,289) (1,283,000) (451,000) Ca s h B a l a n c e - E n d i n g 2 , 4 1 9 , 6 6 8 $ (2 4 7 , 5 2 0 ) $ (2 3 3 , 7 4 9 ) $ (6 0 9 , 9 2 4 ) $ (6 , 0 9 9 ) $ (4 4 2 , 2 7 4 ) $ 32 5 , 5 5 1 $ 78 9 , 6 3 2 $ 1, 8 2 0 , 3 5 3 $ 2, 6 0 8 , 3 8 2 $ 3, 2 5 8 , 2 9 1 $ 3, 9 3 7 , 6 9 9 $ 4, 8 3 9 , 9 0 1 $ 5,865,125 $ 6,801,601 $ 6,828,442 $ 7,687,551 $ No t e s : 1. C a s h f l o w b a s e d o n t h e p r o j e c t s l i s t e d i n t h e C i t y ' s p r o p o s e d 1 5 - y e a r C a p i t a l I m p r o v e m e n t P l a n ( U p d a t e d J u n e 2 0 1 8 ) . 2. G e n e r a l F u n d t r a n s f e r i s a n e s t i m a t e o f a u d i t e d y e a r - e n d G e n e r a l F u n d U n a s s i g n e d F u n d B a l a n c e a b o v e 5 2 % o f t h e n e x t y e a r ' s G e n e r a l F u n d o p e r a t i n g b u d g e t . 3. L i q u o r t r a n s f e r i s a n e s t i m a t e o f a u d i t e d y e a r - e n d L i q u o r F u n d u n r e s t r i c t e d c a s h b a l a n c e t h a t e x c e e d s 3 . 5 m o n t h s o f t h e n e x t y e a r ' s o p e r a t i n g b u d g e t a n d o n e y e a r o f b u d g e t e d c a p i t a l i m p r o v e m e n t n e e d s . 4. L o c a l G o v e r n m e n t A i d ( L G A ) r e c e i v e d i n t h e a m o u n t o f $ 6 5 0 , 0 0 0 o r h a l f o f t h e a m o u n t r e c e i v e d b y t h e C i t y i f g r e a t e r . 5. T h e p r o j e c t e d 2 0 1 8 a m o u n t i n c l u d e s c a r r y f o r w a r d o f $ 4 0 k f o r E v e r g r e e n , $ 4 0 k f o r E v e r g r e e n S R T S , $ 5 0 k f o r c o m p l e t i o n o f 1 7 p a v e m e n t a n d s i g n a l r e h a b , $ 5 0 0 k f o r C o m m u n i t y C e n t e r H V A C , $ 4 0 8 , 8 3 3 a d d i t i o n a l B r o o k l y n B l v d C o s t , a n d r e d u c e d $ 5 2 5 k f o r B r o o k l y n B l v d p u b l i c i m p r o v e m e n t s c o d e d t o T I F # 2 . 2 0 1 8 A m o u n t a l s o r e d u c e d b y 2 0 1 7 E n g i n e e r i n g c o s t s f o r B r o o k l y n B l v d ( c a s h p a i d i n 2 0 1 7 o f $ 9 1 0 , 7 0 1 ) . 6. T h e p r o j e c t e d 2 0 1 8 e x t e r n a l f u n d i n g r e d u c e d b y s t r e e t s c a p i n g c o s t s n o t r e i m b u r s e d b y f e d e r a l a n d c o u n t y f u n d s - $ 1 , 0 5 9 , 0 0 0 ( R e v i s e d C I P e x t e r n a l f u n d i n g o f $ 1 0 , 1 9 2 , 0 0 0 l e s s 2 0 1 8 C I P o f $ 1 1 , 2 5 1 , 0 0 0 ) . 7. . T h e p r o j e c t e d 2 0 2 1 a m o u n t i n c l u d e s a b o n d s a l e o f $ 7 , 6 3 7 , 0 0 0 ( $ 5 . 5 m i l l i o n f o r T H 2 5 2 a n d $ 2 . 1 3 7 m i l l i o n f o r B r o o k l y n B l v d . P h a s e I I i m p r o v e m e n t s ) . A n n u a l d e b t s e r v i c e p a y m e n t s o f $ 8 9 5 , 2 8 9 t o b e p a i d w i t h p r o p e r t y t a x l e v y . 8. D i d n o t m o v e a n y B r o o k l y n B l v d . C o s t s t o 2 0 1 9 , h o w e v e r a s i g n i f i c a n t a m o u n t o f c o s t s w i l l o c c u r i n 2 0 1 9 .  ( 5 , 0 0 0 , 0 0 0 )  ‐  5 , 0 0 0 , 0 0 0  1 0 , 0 0 0 , 0 0 0  1 5 , 0 0 0 , 0 0 0  2 0 , 0 0 0 , 0 0 0  2 5 , 0 0 0 , 0 0 0  3 0 , 0 0 0 , 0 0 0  3 5 , 0 0 0 , 0 0 0 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 Ca p i t a l   I m p r o v e m e n t s   F u n d   Ci t y   F u n d e d   C a p i t a l   O u t l a y Ex t e r n a l   F u n d e d   C a p i t a l   O u t l a y TH   2 5 2   E x t e r n a l   F u n d i n g   E s t . Ca s h   B a l a n c e   ‐   E n d i n g 8 Ci t y o f B r o o k l y n C e n t e r Mu n i c i p a l S t a t e A i d ( M S A ) F u n d C a s h F l o w s A n a l y s i s Re v i s e d : 7 - 2 - 1 8 Ac t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 2 0 3 3 Re v e n u e s In t e r g ov e r n m e n t a l (Ma i n t e n a n c e 16 0 , 0 0 0 $ 1 6 0 , 0 0 0 $ 1 6 0 , 0 0 0 $ 1 7 0 , 0 0 0 $ 1 7 5 , 0 0 0 $ 1 8 0 , 0 0 0 $ 1 8 5 , 0 0 0 $ 1 9 0 , 0 0 0 $ 1 9 0 , 0 0 0 $ 1 9 0 , 0 0 0 $ 1 9 0 , 0 0 0 $ 1 9 0 , 0 0 0 $ 1 9 0 , 0 0 0 $ 1 9 0 , 0 0 0 $ 1 9 0 , 0 0 0 $ 190,000 $ 190,000 $ In t e r g ov e r n m e n t a l (Co n s t r u c t i o n 76 6 , 3 0 1 9 3 3 , 2 0 4 - - 5 0 0 , 0 0 0 1 , 0 4 3 , 5 9 4 1 , 0 3 8 , 5 9 4 1 , 0 3 3 , 5 9 4 1 , 0 5 7 , 0 0 0 1 , 0 5 7 , 0 0 0 1 , 0 5 7 , 0 0 0 1 , 0 5 7 , 0 0 0 1 , 0 5 7 , 0 0 0 1 , 0 5 7 , 0 0 0 1 , 0 5 7 , 0 0 0 1,057,000 1,057,000 In v e s t m e n t E a r n i n g s - 4 , 1 9 8 4 , 1 9 8 - - - - - - - - - - - - - - To t a l 9 2 6 , 3 0 1 1 , 0 9 7 , 4 0 2 1 6 4 , 1 9 8 1 7 0 , 0 0 0 6 7 5 , 0 0 0 1 , 2 2 3 , 5 9 4 1 , 2 2 3 , 5 9 4 1 , 2 2 3 , 5 9 4 1 , 2 4 7 , 0 0 0 1 , 2 4 7 , 0 0 0 1 , 2 4 7 , 0 0 0 1 , 2 4 7 , 0 0 0 1 , 2 4 7 , 0 0 0 1 , 2 4 7 , 0 0 0 1 , 2 4 7 , 0 0 0 1,247,000 1,247,000 Ex p e n d i t u r e s Su p p l i e s 4 1 , 1 0 6 6 4 , 0 0 0 6 4 , 0 0 0 6 8 , 0 0 0 7 0 , 0 0 0 7 2 , 0 0 0 7 4 , 0 0 0 7 6 , 0 0 0 7 6 , 0 0 0 7 6 , 0 0 0 7 6 , 0 0 0 7 6 , 0 0 0 7 6 , 0 0 0 7 6 , 0 0 0 7 6 , 0 0 0 76,000 76,000 Ot h e r S e r v i c e s & C h a r g e s 5 6 , 1 5 1 9 6 , 0 0 0 9 6 , 0 0 0 1 0 2 , 0 0 0 1 0 5 , 0 0 0 1 0 8 , 0 0 0 1 1 1 , 0 0 0 1 1 4 , 0 0 0 1 1 4 , 0 0 0 1 1 4 , 0 0 0 1 1 4 , 0 0 0 1 1 4 , 0 0 0 1 1 4 , 0 0 0 1 1 4 , 0 0 0 1 1 4 , 0 0 0 114,000 114,000 Ca p i t a l O u t l a y 1 , 3 1 0 , 2 5 2 8 7 5 , 0 0 0 3 7 0 , 0 0 0 1 , 8 6 0 , 0 0 0 1 , 2 6 2 , 0 0 0 1 5 0 , 0 0 0 2 , 3 8 0 , 0 0 0 3 8 0 , 0 0 0 2 0 2 , 0 0 0 5 0 0 , 0 0 0 1, 0 7 0 , 0 0 0 26 0 , 0 0 0 - 8 6 0 , 0 0 0 960,000 260,000 990,000 To t a l 1, 4 0 7 , 5 0 9 1, 0 3 5 , 0 0 0 53 0 , 0 0 0 2, 0 3 0 , 0 0 0 1, 4 3 7 , 0 0 0 33 0 , 0 0 0 2, 5 6 5 , 0 0 0 57 0 , 0 0 0 39 2 , 0 0 0 69 0 , 0 0 0 1, 2 6 0 , 0 0 0 45 0 , 0 0 0 19 0 , 0 0 0 1, 0 5 0 , 0 0 0 1,150,000 450,000 1,180,000 Ca s h B a l a n c e - B e g i n n i n g (1 5 , 6 5 9 ) 2, 4 1 9 , 6 6 8 2, 4 8 2 , 0 7 0 2, 1 1 6 , 2 6 8 25 6 , 2 6 8 (5 0 5 , 7 3 2 ) 38 7 , 8 6 2 (9 5 3 , 5 4 4 ) (2 9 9 , 9 5 0 ) 55 5 , 0 5 0 1, 1 1 2 , 0 5 0 1, 0 9 9 , 0 5 0 1, 8 9 6 , 0 5 0 2, 9 5 3 , 0 5 0 3,150,050 3,247,050 4,044,050 Ch a n g e s i n A c c r u a l s 2, 9 1 6 , 5 3 5 Re v e n u e s 92 6 , 3 0 1 1, 0 9 7 , 4 0 2 16 4 , 1 9 8 17 0 , 0 0 0 67 5 , 0 0 0 1, 2 2 3 , 5 9 4 1, 2 2 3 , 5 9 4 1, 2 2 3 , 5 9 4 1, 2 4 7 , 0 0 0 1, 2 4 7 , 0 0 0 1, 2 4 7 , 0 0 0 1, 2 4 7 , 0 0 0 1, 2 4 7 , 0 0 0 1, 2 4 7 , 0 0 0 1,247,000 1,247,000 1,247,000 Ex p e n d i t u r e s (1 , 4 0 7 , 5 0 9 ) (1 , 0 3 5 , 0 0 0 ) (5 3 0 , 0 0 0 ) (2 , 0 3 0 , 0 0 0 ) (1 , 4 3 7 , 0 0 0 ) (3 3 0 , 0 0 0 ) (2 , 5 6 5 , 0 0 0 ) (5 7 0 , 0 0 0 ) (3 9 2 , 0 0 0 ) (6 9 0 , 0 0 0 ) (1 , 2 6 0 , 0 0 0 ) (4 5 0 , 0 0 0 ) (1 9 0 , 0 0 0 ) (1 , 0 5 0 , 0 0 0 ) (1,150,000) (450,000) (1,180,000) Ca s h B a l a n c e - E n d i n g 2, 4 1 9 , 6 6 8 $ 2, 4 8 2 , 0 7 0 $ 2, 1 1 6 , 2 6 8 $ 25 6 , 2 6 8 $ (5 0 5 , 7 3 2 ) $ 38 7 , 8 6 2 $ (9 5 3 , 5 4 4 ) $ (2 9 9 , 9 5 0 ) $ 55 5 , 0 5 0 $ 1, 1 1 2 , 0 5 0 $ 1, 0 9 9 , 0 5 0 $ 1, 8 9 6 , 0 5 0 $ 2, 9 5 3 , 0 5 0 $ 3, 1 5 0 , 0 5 0 $ 3,247,050 $ 4,044,050 $ 4,111,050 $ No t e s : 1) R e q u e s t e d a n d r e c e i v e d a c a s h a d v a n c e i n 2 0 1 7 o f a n n u a l c o n s t r u c t i o n a l l o c a t i o n s , w h i c h w i l l i m p a c t 2 0 1 9 t h r o u g h 2 0 2 1 a n n u a l a m o u n t s . W i l l b e a b l e t o r e q u e s t a d v a n c e t o c o v e r 2 0 2 0 p r o j e c t . 2) 2 0 1 8 a m o u n t s i n c l u d e $ 5 0 , 0 0 0 f o r c o m p l e t i o n o f E v e r g r e e n , $ 2 2 0 , 0 0 f o r c o m p l e t i o n o f 1 7 p a v e m e n t a n d s i g n a l r e h a b , $ 8 0 , 0 0 0 f o r c o m p l e t i o n o f 5 7 t h m i l l a n d o v e r l a y , l e s s $ 1 6 0 , 0 0 0 f o r B e l l v u e m i l l a n d o v e r l a y m o v e d t o 2 0 1 9 , a n d l e s s $ 1 2 0 , 0 0 0 5 1 s t A v e n u e m o v e d t o 2 0 1 9 .  ( 2 , 0 0 0 , 0 0 0 )  ( 1 , 0 0 0 , 0 0 0 )  ‐  1 , 0 0 0 , 0 0 0  2 , 0 0 0 , 0 0 0  3 , 0 0 0 , 0 0 0  4 , 0 0 0 , 0 0 0  5 , 0 0 0 , 0 0 0 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 MS A   F u n d   Ex p e n d i t u r e s Ca s h   B a l a n c e   ‐   E n d i n g 9 Ci t y o f B r o o k l y n C e n t e r St r e e t R e c o n s t r u c t i o n F u n d C a s h F l o w s A n a l y s i s Re v i s e d : 6 - 2 5 - 1 8 Ac t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 2 0 3 3 Re v e n u e s Fr a n c h i s e F e e s 70 2 , 6 0 0 $ 68 9 , 0 0 0 $ 68 9 , 0 0 0 $ 71 0 , 0 0 0 $ 71 0 , 0 0 0 $ 71 0 , 0 0 0 $ 73 1 , 0 0 0 $ 73 1 , 0 0 0 $ 73 1 , 0 0 0 $ 75 3 , 0 0 0 $ 75 3 , 0 0 0 $ 75 3 , 0 0 0 $ 77 6 , 0 0 0 $ 776,000 $ 776,000 $ 776,000 $ 776,000 $ In v e s t m e n t E a r n i n g s 4 7 , 7 0 0 41 , 9 9 1 41 , 9 9 1 21 , 1 4 3 12 , 3 5 4 4, 8 3 8 13 , 5 8 6 14 , 1 3 2 21 , 5 8 4 29 , 1 0 9 26 , 0 3 1 13 , 9 2 1 21 , 5 9 0 7,266 15,099 9,710 6,967 Fu t u r e B o n d s - L e v i e s - - - 2 6 9 , 6 3 0 53 9 , 2 6 0 53 9 , 2 6 0 76 3 , 1 7 1 76 3 , 1 7 1 1, 0 7 9 , 6 9 3 1, 4 7 5 , 9 3 2 1, 4 7 5 , 9 3 2 1, 4 7 5 , 9 3 2 1, 6 9 0 , 4 6 4 1, 4 2 0 , 8 3 4 1,151,204 1,151,204 927,293 Bo n d P r o c e e d s 2, 4 8 5 , 3 6 5 2, 1 3 7 , 6 7 9 2, 3 0 0 , 0 0 0 2, 3 0 0 , 0 0 0 - 1 , 9 1 0 , 0 0 0 - 2 , 7 0 0 , 0 0 0 3, 3 8 0 , 0 0 0 - - 1 , 6 6 0 , 0 0 0 - 2 , 3 7 0 , 0 0 0 - - - To t a l 3, 2 3 5 , 6 6 5 2, 8 6 8 , 6 7 0 3, 0 3 0 , 9 9 1 3, 3 0 0 , 7 7 3 1, 2 6 1 , 6 1 5 3, 1 6 4 , 0 9 8 1, 5 0 7 , 7 5 7 4, 2 0 8 , 3 0 3 5, 2 1 2 , 2 7 7 2, 2 5 8 , 0 4 2 2, 2 5 4 , 9 6 3 3, 9 0 2 , 8 5 3 2, 4 8 8 , 0 5 4 4, 5 7 4 , 1 0 0 1,942,302 1,936,913 1,710,260 Ex p e n d i t u r e s Ca p i t a l O u t l a y 2, 1 6 5 , 3 7 0 3, 1 7 7 , 5 9 2 5, 4 3 4 , 2 3 5 3, 9 1 0 , 0 0 0 1, 4 7 4 , 0 0 0 1, 7 5 0 , 0 0 0 69 0 , 0 0 0 2, 7 0 0 , 0 0 0 3, 3 8 0 , 0 0 0 1, 0 9 0 , 0 0 0 1, 9 9 0 , 0 0 0 1, 6 6 0 , 0 0 0 2, 2 3 0 , 0 0 0 2, 3 7 0 , 0 0 0 1,330,000 1,060,000 1,170,000 De b t S e r v i c e ( P r o j e c t e d ) - - - 2 6 9 , 6 3 0 53 9 , 2 6 0 53 9 , 2 6 0 76 3 , 1 7 1 76 3 , 1 7 1 1, 0 7 9 , 6 9 3 1, 4 7 5 , 9 3 2 1, 4 7 5 , 9 3 2 1, 4 7 5 , 9 3 2 1, 6 9 0 , 4 6 4 1, 4 2 0 , 8 3 4 1,151,204 1,151,204 927,293 Bo n d I s s u e C o s t s 24 , 5 6 2 30 , 0 0 0 30 , 0 0 0 - - - - - - - - - - - - - - To t a l 2, 1 8 9 , 9 3 2 3, 2 0 7 , 5 9 2 5, 4 6 4 , 2 3 5 4, 1 7 9 , 6 3 0 2, 0 1 3 , 2 6 0 2, 2 8 9 , 2 6 0 1, 4 5 3 , 1 7 1 3, 4 6 3 , 1 7 1 4, 4 5 9 , 6 9 3 2, 5 6 5 , 9 3 2 3, 4 6 5 , 9 3 2 3, 1 3 5 , 9 3 2 3, 9 2 0 , 4 6 4 3, 7 9 0 , 8 3 4 2,481,204 2,211,204 2,097,293 Ca s h B a l a n c e - B e g i n n i n g 3, 8 5 3 , 9 7 7 4 , 8 8 6 , 4 7 2 4 , 5 4 7 , 5 5 0 2 , 1 1 4 , 3 0 6 1 , 2 3 5 , 4 4 9 4 8 3 , 8 0 3 1 , 3 5 8 , 6 4 1 1 , 4 1 3 , 2 2 8 2 , 1 5 8 , 3 6 0 2 , 9 1 0 , 9 4 4 2 , 6 0 3 , 0 5 3 1 , 3 9 2 , 0 8 4 2 , 1 5 9 , 0 0 4 7 2 6 , 5 9 4 1 , 5 0 9 , 8 6 0 970,959 696,669 Ch a n g e s i n A c c r u a l s ( 1 3 , 2 3 8 ) - - - - - - - - - - - - - - - - Re v e n u e s 3 , 2 3 5 , 6 6 5 2 , 8 6 8 , 6 7 0 3 , 0 3 0 , 9 9 1 3 , 3 0 0 , 7 7 3 1 , 2 6 1 , 6 1 5 3 , 1 6 4 , 0 9 8 1 , 5 0 7 , 7 5 7 4 , 2 0 8 , 3 0 3 5 , 2 1 2 , 2 7 7 2 , 2 5 8 , 0 4 2 2 , 2 5 4 , 9 6 3 3 , 9 0 2 , 8 5 3 2 , 4 8 8 , 0 5 4 4 , 5 7 4 , 1 0 0 1 , 9 4 2 , 3 0 2 1,936,913 1,710,260 Ex p e n d i t u r e s ( 2 , 1 8 9 , 9 3 2 ) ( 3 , 2 0 7 , 5 9 2 ) ( 5 , 4 6 4 , 2 3 5 ) ( 4 , 1 7 9 , 6 3 0 ) ( 2 , 0 1 3 , 2 6 0 ) ( 2 , 2 8 9 , 2 6 0 ) ( 1 , 4 5 3 , 1 7 1 ) ( 3 , 4 6 3 , 1 7 1 ) ( 4 , 4 5 9 , 6 9 3 ) ( 2 , 5 6 5 , 9 3 2 ) ( 3 , 4 6 5 , 9 3 2 ) ( 3 , 1 3 5 , 9 3 2 ) ( 3 , 9 2 0 , 4 6 4 ) ( 3 , 7 9 0 , 8 3 4 ) ( 2 , 4 8 1 , 2 0 4 ) (2,211,204) (2,097,293) Ca s h B a l a n c e - E n d i n g 4 , 8 8 6 , 4 7 2 $ 4 , 5 4 7 , 5 5 0 $ 2 , 1 1 4 , 3 0 6 $ 1 , 2 3 5 , 4 4 9 $ 4 8 3 , 8 0 3 $ 1 , 3 5 8 , 6 4 1 $ 1 , 4 1 3 , 2 2 8 $ 2 , 1 5 8 , 3 6 0 $ 2 , 9 1 0 , 9 4 4 $ 2 , 6 0 3 , 0 5 3 $ 1 , 3 9 2 , 0 8 4 $ 2 , 1 5 9 , 0 0 4 $ 7 2 6 , 5 9 4 $ 1 , 5 0 9 , 8 6 0 $ 9 7 0 , 9 5 9 $ 696,669 $ 309,635 $ No t e s : 1. F r a n c h i s e f e e s i n c l u d e p r o j e c t e d i n c r e a s e s o f 3 . 0 % f o r 2 0 1 7 , 3 . 0 % f o r 2 0 2 0 , 3 . 0 % f o r 2 0 2 3 , 3 . 0 % f o r 2 0 2 6 , a n d 3 . 0 % f o r 2 0 2 9 2. 2 0 1 8 i n c l u d e s $ 3 4 0 , 0 0 0 f o r c o m p l e t i o n o f E v e r g r e e , $ 1 5 , 0 0 0 f o r 1 7 p a v e m e n t a n d s i g n a l r e h a b , l e s s $ 8 7 9 , 1 7 3 f o r F i r e h o u s e p r o j e c t b e l o w e s t i m a t e , l e s s p r o j e c t s m o v e d t o 2 0 1 9 ( $ 7 9 0 , 0 0 0 f o r B e l l v u e , $ 2 2 6 , 0 0 0 f o r b r i d g e r e h a b , a n d $ 2 4 8 , 3 2 5 5 1 s t A v e n u e ) .  ‐  1 , 0 0 0 , 0 0 0  2 , 0 0 0 , 0 0 0  3 , 0 0 0 , 0 0 0  4 , 0 0 0 , 0 0 0  5 , 0 0 0 , 0 0 0  6 , 0 0 0 , 0 0 0 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 St r e e t   R e c o n s t r u c t i o n   F u n d     Ex p e n d i t u r e s Ca s h   B a l a n c e   ‐   E n d i n g 10 Ci t y o f B r o o k l y n C e n t e r Sp e c i a l A s s e s s m e n t s C o n s t r u c t i o n F u n d C a s h F l o w s A n a l y s i s Re v i s e d : 6 - 2 5 - 1 8 Pr o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 2 0 3 3 Re v e n u e s Sp e c i a l A s s e s s m e n t s 61 6 , 8 9 3 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -$ -$ -$ -$ Sp e c i a l A s s e s s m e n t s ( P r o j e c t e d E x i s t i n g ) - 5 3 1 , 5 3 6 61 0 , 0 6 3 56 2 , 1 0 4 46 1 , 5 5 8 44 2 , 2 6 7 42 2 , 1 4 3 40 4 , 9 1 5 - - - - - - - - - Sp e c i a l A s s e s s m e n t s ( P r o j e c t e d P r e p a i d s ) - 4 7 2 , 0 2 8 77 2 , 0 7 4 67 2 , 5 0 0 13 7 , 5 0 0 40 5 , 0 0 0 12 2 , 5 0 0 69 5 , 0 0 0 90 7 , 5 0 0 43 5 , 0 0 0 30 , 0 0 0 17 7 , 5 0 0 15 0 , 0 0 0 120,000 137,500 75,000 87,500 Sp e c i a l A s s e s s m e n t s ( P r o j e c t e d N e w ) - - 3 6 , 9 6 0 36 9 , 8 0 4 60 1 , 7 5 8 64 3 , 0 3 2 79 3 , 9 2 6 82 3 , 4 1 0 1, 0 8 8 , 6 6 4 1, 4 3 0 , 6 5 8 1, 5 6 3 , 4 6 2 1, 5 2 6 , 3 4 6 1, 5 2 3 , 3 7 0 1,295,700 1,128,450 1,105,320 977,550 In t e r g o v e r n m e n t a l - - - - - - - - - - - - - - - - - Ch a r g e s f o r S e r v i c e s 1, 2 0 0 - - - - - - - - - - - - - - - - In v e s t m e n t E a r n i n g s 52 5 - - - - - - - - - - - - - - - - Mi s c e l l a n e o u s 3, 7 3 9 - - - - - - - - - - - - - - - - Bo n d P r o c e e d s 1, 4 3 6 , 1 3 7 2, 0 2 9 , 3 3 7 2, 8 1 0 , 0 0 0 - - - - 2 , 4 5 0 , 0 0 0 2, 0 0 0 , 0 0 0 - - - - - - - - Tr a n s f e r s I n 16 1 , 5 7 5 - - - - - - - - - - - - - - - - To t a l 2, 2 2 0 , 0 6 9 3, 0 3 2 , 9 0 1 4, 2 2 9 , 0 9 7 1, 6 0 4 , 4 0 8 1, 2 0 0 , 8 1 6 1, 4 9 0 , 2 9 9 1, 3 3 8 , 5 6 9 4, 3 7 3 , 3 2 5 3, 9 9 6 , 1 6 4 1, 8 6 5 , 6 5 8 1, 5 9 3 , 4 6 2 1, 7 0 3 , 8 4 6 1, 6 7 3 , 3 7 0 1,415,700 1,265,950 1,180,320 1,065,050 Ex p e n d i t u r e s Ot h e r S e r v i c e s & C h a r g e s 33 , 7 6 2 - - - - - - - - - - - - - - - - Ca p i t a l O u t l a y 1, 5 5 2 , 0 8 4 2, 2 7 3 , 5 4 9 3, 0 8 8 , 2 9 5 2, 6 9 0 , 0 0 0 55 0 , 0 0 0 1, 6 2 0 , 0 0 0 49 0 , 0 0 0 2, 7 8 0 , 0 0 0 3, 6 3 0 , 0 0 0 1, 7 4 0 , 0 0 0 12 0 , 0 0 0 71 0 , 0 0 0 60 0 , 0 0 0 480,000 550,000 300,000 350,000 De b t S e r v i c e ( P r o j e c t e d ) - - 2 4 7 , 3 5 6 57 6 , 7 7 4 57 6 , 7 7 4 57 6 , 7 7 4 57 6 , 7 7 4 57 6 , 7 7 4 86 3 , 9 8 9 1, 0 9 8 , 4 5 0 1, 0 9 8 , 4 5 0 1, 0 9 8 , 4 5 0 85 1 , 0 9 3 521,676 521,676 521,676 521,676 Bo n d I s s u a n c e C o s t s 16 , 4 6 7 - - - - - - - - - - - - - - - - Tr a n s f e r s - - - - - - - - - - - - - - - - - To t a l 1, 6 0 2 , 3 1 3 2, 2 7 3 , 5 4 9 3, 3 3 5 , 6 5 1 3, 2 6 6 , 7 7 4 1, 1 2 6 , 7 7 4 2, 1 9 6 , 7 7 4 1, 0 6 6 , 7 7 4 3, 3 5 6 , 7 7 4 4, 4 9 3 , 9 8 9 2, 8 3 8 , 4 5 0 1, 2 1 8 , 4 5 0 1, 8 0 8 , 4 5 0 1, 4 5 1 , 0 9 3 1,001,676 1,071,676 821,676 871,676 Ca s h B a l a n c e - B e g i n n i n g 1, 2 5 8 , 8 1 7 1, 0 0 8 , 8 1 7 1, 7 6 8 , 1 6 9 2, 6 6 1 , 6 1 5 99 9 , 2 4 9 1, 0 7 3 , 2 9 1 36 6 , 8 1 7 63 8 , 6 1 1 1, 6 5 5 , 1 6 3 1, 1 5 7 , 3 3 8 18 4 , 5 4 6 55 9 , 5 5 8 45 4 , 9 5 4 677,231 677,231 871,505 1,230,149 Ch a n g e s i n A c c r u a l s (8 6 7 , 7 5 6 ) - - - - - - - - - - - - - - - - Re v e n u e s 2, 2 2 0 , 0 6 9 3, 0 3 2 , 9 0 1 4, 2 2 9 , 0 9 7 1, 6 0 4 , 4 0 8 1, 2 0 0 , 8 1 6 1, 4 9 0 , 2 9 9 1, 3 3 8 , 5 6 9 4, 3 7 3 , 3 2 5 3, 9 9 6 , 1 6 4 1, 8 6 5 , 6 5 8 1, 5 9 3 , 4 6 2 1, 7 0 3 , 8 4 6 1, 6 7 3 , 3 7 0 1,415,700 1,265,950 1,180,320 1,065,050 Ex p e n d i t u r e s (1 , 6 0 2 , 3 1 3 ) (2 , 2 7 3 , 5 4 9 ) (3 , 3 3 5 , 6 5 1 ) (3 , 2 6 6 , 7 7 4 ) (1 , 1 2 6 , 7 7 4 ) (2 , 1 9 6 , 7 7 4 ) (1 , 0 6 6 , 7 7 4 ) (3 , 3 5 6 , 7 7 4 ) (4 , 4 9 3 , 9 8 9 ) (2 , 8 3 8 , 4 5 0 ) (1 , 2 1 8 , 4 5 0 ) (1 , 8 0 8 , 4 5 0 ) (1 , 4 5 1 , 0 9 3 ) (1,001,676) (1,071,676) (821,676) (871,676) Ca s h B a l a n c e - E n d i n g 1, 0 0 8 , 8 1 7 $ 1, 7 6 8 , 1 6 9 $ 2, 6 6 1 , 6 1 5 $ 99 9 , 2 4 9 $ 1, 0 7 3 , 2 9 1 $ 36 6 , 8 1 7 $ 63 8 , 6 1 1 $ 1, 6 5 5 , 1 6 3 $ 1, 1 5 7 , 3 3 8 $ 18 4 , 5 4 6 $ 55 9 , 5 5 8 $ 45 4 , 9 5 4 $ 67 7 , 2 3 1 $ 1,091,255 $ 871,505 $ 1,230,149 $ 1,423,524 $ No t e s : 1) P r e p a i d s e s t i m a t e d a t 2 5 % o f n e w a s s e s s m e n t s , w h i c h i s e q u a l t o c a p i t a l o u t l a y f o r t h e g i v e n y e a r . 2) 2 0 1 8 i n c l u d e s $ 2 0 0 , 0 0 0 f o r c o m p l e t i o n o f E v e r g r e e n , $ 6 0 , 0 0 0 f o r c o m p l e t i o n o f 1 7 p a v e m e n t a n d s i g n a l r e h a b , l e s s $ 1 0 8 , 1 5 6 f o r F i r e h o u s e b i d b e l o w e s t i m a t e , l e s s $ 2 5 0 , 0 0 0 B e l l v u e m i l l a n d o v e r l a y a n d $ 2 8 , 2 9 5 5 1 s t A v e n u e m o v e d t o 2 0 1 9 .  ‐  5 0 0 , 0 0 0  1 , 0 0 0 , 0 0 0  1 , 5 0 0 , 0 0 0  2 , 0 0 0 , 0 0 0  2 , 5 0 0 , 0 0 0  3 , 0 0 0 , 0 0 0  3 , 5 0 0 , 0 0 0  4 , 0 0 0 , 0 0 0  4 , 5 0 0 , 0 0 0  5 , 0 0 0 , 0 0 0 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 Sp e c i a l   A s s e s s m e n t s   R e c o n s t r u c t i o n   F u n d   Ex p e n d i t u r e s Ca s h   B a l a n c e   ‐   E n d i n g 11 Ci t y o f B r o o k l y n C e n t e r Wa t e r U t i l i t y C a s h F l o w s Re v i s e d : 7 - 2 - 1 8 Av e r a g e R e s i d e n t i a l F e e (1 8 , 0 0 0 G a l l o n s / P e r Q t r . ) 58 . 5 6 $ 5 8 . 5 6 $ 6 2 . 1 4 $ 6 7 . 6 8 $ 7 3 . 7 0 $ 8 0 . 4 0 $ 8 7 . 6 1 $ 9 1 . 9 5 $ 9 4 . 6 2 $ 9 7 . 4 9 $ 9 9 . 4 2 $ 9 9 . 4 2 $ 9 9 . 4 2 $ 9 7 . 4 8 $ 94.59 $ 89.81 $ 83.56 $ Pe r Q u a r t e r C h a n g e 9. 8 2 $ - $ 3 . 5 8 $ 5 . 5 4 $ 6 . 0 2 $ 6 . 7 0 $ 7 . 2 1 $ 4 . 3 4 $ 2 . 6 7 $ 2 . 8 7 $ 1 . 9 3 $ - $ - $ ( 1 . 9 4 ) $ (2.89)$ (4.78)$ (6.25)$ Ba s e C h a r g e 14 . 6 4 $ 1 4 . 6 4 $ 1 5 . 5 2 $ 1 6 . 9 2 $ 1 8 . 4 4 $ 2 0 . 1 0 $ 2 1 . 9 1 $ 2 3 . 0 1 $ 2 3 . 7 0 $ 2 4 . 4 1 $ 2 4 . 9 0 $ 2 4 . 9 0 $ 2 4 . 9 0 $ 2 4 . 4 0 $ 23.67 $ 22.49 $ 20.92 $ Co n s u m p t i o n C h a r g e ( 0 - 3 0 ) 2. 4 4 $ 2 . 4 4 $ 2 . 5 9 $ 2 . 8 2 $ 3 . 0 7 $ 3 . 3 5 $ 3 . 6 5 $ 3 . 8 3 $ 3 . 9 4 $ 4 . 0 6 $ 4 . 1 4 $ 4 . 1 4 $ 4 . 1 4 $ 4 . 0 6 $ 3.94 $ 3.74 $ 3.48 $ Co n s u m p t i o n C h a r g e ( 3 0 - 6 0 ) 3. 0 4 $ 3 . 0 4 $ 3 . 2 2 $ 3 . 5 1 $ 3 . 8 3 $ 4 . 1 7 $ 4 . 5 5 $ 4 . 7 8 $ 4 . 9 2 $ 5 . 0 7 $ 5 . 1 7 $ 5 . 1 7 $ 5 . 1 7 $ 5 . 0 7 $ 4.92 $ 4.67 $ 4.34 $ Co n s u m p t i o n C h a r g e ( 6 0 + ) 4. 5 4 $ 4. 5 4 $ 4. 8 1 $ 5. 2 4 $ 5. 7 1 $ 6. 2 2 $ 6. 7 8 $ 7. 1 2 $ 7. 3 3 $ 7. 5 5 $ 7. 7 0 $ 7. 7 0 $ 7. 7 0 $ 7.55 $ 7.32 $ 6.95 $ 6.46 $ Ac t u a l B u d g e t e d B u d g e t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e cted Projected Projected 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 20 2 4 20 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 2 0 3 2 Re v e n u e s Op e r a t i n g 3, 5 4 3 , 3 2 3 $ 3, 5 4 3 , 3 2 3 $ 3, 7 5 5 , 9 2 2 $ 4, 0 9 3 , 9 5 5 $ 4, 4 6 2 , 4 1 1 $ 4, 8 6 4 , 0 2 8 $ 5, 3 0 1 , 7 9 1 $ 5, 5 6 6 , 8 8 1 $ 5, 7 3 3 , 8 8 7 $ 5, 9 0 5 , 9 0 4 $ 6, 0 2 4 , 0 2 2 $ 6, 0 2 4 , 0 2 2 $ 6, 0 2 4 , 0 2 2 $ 5,903,541 $ 5,726,435 $ 5,440,113 $ 5,059,305 $ In v e s t m e n t E a r n i n g s 28 , 1 5 4 36 , 5 5 1 26 , 8 5 9 24 , 6 2 0 18 , 2 6 9 8, 9 8 7 7, 9 0 4 4, 3 4 0 7, 4 1 7 8, 3 3 3 8, 8 9 2 13 , 5 3 3 18 , 5 3 5 21,780 19,149 22,730 31,697 No n o p e r a t i n g 42 , 2 7 4 - - - - - - - - - - - - - - - - Bo n d P r o c e e d s ( G O ) 3, 2 3 0 , 0 0 0 3, 1 9 1 , 4 5 1 2, 6 0 0 , 0 0 0 3, 2 7 0 , 0 0 0 - 2 , 4 5 0 , 0 0 0 - 2 , 9 6 0 , 0 0 0 1, 5 0 0 , 0 0 0 - - - - - - - - To t a l 6, 8 4 3 , 7 5 1 6, 7 7 1 , 3 2 5 6, 3 8 2 , 7 8 1 7, 3 8 8 , 5 7 5 4, 4 8 0 , 6 8 1 7, 3 2 3 , 0 1 5 5, 3 0 9 , 6 9 5 8, 5 3 1 , 2 2 0 7, 2 4 1 , 3 0 4 5, 9 1 4 , 2 3 6 6, 0 3 2 , 9 1 4 6, 0 3 7 , 5 5 5 6, 0 4 2 , 5 5 7 5,925,322 5,745,584 5,462,843 5,091,003 Ex p e n d i t u r e s Pe r s o n a l S e r v c i e s 55 1 , 6 8 0 57 7 , 0 5 3 59 4 , 0 2 3 61 1 , 8 4 4 63 0 , 1 9 9 64 9 , 1 0 5 66 8 , 5 7 8 68 8 , 6 3 5 70 9 , 2 9 5 73 0 , 5 7 3 75 2 , 4 9 1 77 5 , 0 6 5 79 8 , 3 1 7 822,267 846,935 872,343 898,513 Su p p l i e s 20 7 , 8 6 9 28 2 , 6 6 0 26 5 , 7 1 0 27 1 , 0 2 4 27 6 , 4 4 5 28 1 , 9 7 4 28 7 , 6 1 3 29 3 , 3 6 5 29 9 , 2 3 3 30 5 , 2 1 7 31 1 , 3 2 2 31 7 , 5 4 8 32 3 , 8 9 9 330,377 336,985 343,724 350,599 Ot h e r S e r v i c e s & C h a r g e s 5 0 6 , 9 5 2 46 9 , 8 3 6 45 2 , 2 7 5 46 1 , 3 2 1 47 0 , 5 4 7 47 9 , 9 5 8 48 9 , 5 5 7 49 9 , 3 4 8 50 9 , 3 3 5 51 9 , 5 2 2 52 9 , 9 1 2 54 0 , 5 1 0 55 1 , 3 2 1 562,347 573,594 585,066 596,767 In s u r a n c e 35 , 1 7 4 37 , 2 8 4 39 , 5 2 2 40 , 3 1 2 41 , 1 1 9 41 , 9 4 1 42 , 7 8 0 43 , 6 3 5 44 , 5 0 8 45 , 3 9 8 46 , 3 0 6 47 , 2 3 2 48 , 1 7 7 49,141 50,123 51,126 52,148 Ut i l i t i e s 22 2 , 0 5 6 23 6 , 9 0 0 23 6 , 9 0 0 24 1 , 6 3 8 24 6 , 4 7 1 25 1 , 4 0 0 25 6 , 4 2 8 26 1 , 5 5 7 26 6 , 7 8 8 27 2 , 1 2 4 27 7 , 5 6 6 28 3 , 1 1 7 28 8 , 7 8 0 294,555 300,446 306,455 312,585 De p r ec i a t i o n 1, 6 3 5 , 2 5 5 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1,935,476 1,935,476 1,935,476 1,935,476 Ca p i t a l O u t l a y ( C I P ) 2, 7 6 6 , 0 0 9 4, 6 1 2 , 2 5 3 3, 0 8 7 , 0 0 0 3, 9 4 4 , 0 0 0 91 3 , 0 0 0 2, 8 9 0 , 0 0 0 80 0 , 0 0 0 3, 3 1 5 , 0 0 0 1, 8 6 0 , 0 0 0 47 7 , 0 0 0 14 8 , 0 0 0 21 0 , 0 0 0 71 3 , 0 0 0 1,796,000 1,329,000 457,000 168,000 De b t S e r v i c e ( E x i s t i n g ) 16 6 , 9 1 8 38 3 , 9 9 7 79 0 , 3 9 4 1, 0 0 8 , 5 8 4 1, 0 0 2 , 7 0 9 1, 0 0 8 , 3 5 9 1, 0 0 5 , 4 5 9 1, 0 0 6 , 3 4 5 99 7 , 1 5 0 86 9 , 5 8 1 86 4 , 7 1 3 72 4 , 9 3 4 35 5 , 2 5 0 - - - - De b t S e r v i c e ( P F A ) 1, 1 4 0 , 1 5 3 1, 1 4 0 , 4 9 0 1, 1 4 0 , 8 6 0 1, 1 4 0 , 1 3 0 1, 1 4 0 , 3 1 0 1, 1 4 0 , 3 9 0 1, 1 4 0 , 3 7 0 1, 1 4 0 , 2 5 0 1, 1 4 1 , 0 3 0 1, 1 4 0 , 7 0 0 1, 1 4 0 , 2 7 0 1, 1 4 0 , 7 4 0 1, 1 4 1 , 1 0 0 1,140,350 1,140,350 1,140,350 1,140,350 De b t S e r v i c e ( P r o j e c t e d ) - - - 3 0 4 , 7 9 9 68 8 , 1 4 3 68 8 , 1 4 3 97 5 , 3 5 8 97 5 , 3 5 8 1, 3 2 2 , 3 6 0 1, 4 9 8 , 2 0 6 1, 4 9 8 , 2 0 6 1, 4 9 8 , 2 0 6 1, 4 9 8 , 2 0 6 1,193,407 810,063 810,063 810,063 To t a l 7, 2 3 2 , 0 6 6 9, 6 7 5 , 9 4 9 8, 5 4 2 , 1 6 0 9, 9 5 9 , 1 2 9 7, 3 4 4 , 4 1 9 9, 3 6 6 , 7 4 6 7, 6 0 1 , 6 1 9 10 , 1 5 8 , 9 7 0 9, 0 8 5 , 1 7 4 7, 7 9 3 , 7 9 8 7, 5 0 4 , 2 6 1 7, 4 7 2 , 8 3 0 7, 6 5 3 , 5 2 6 8,123,919 7,322,972 6,501,603 6,264,501 Ca s h B a l a n c e - B e g i n n i n g 1, 7 7 9 , 8 5 8 3, 6 5 5 , 0 5 3 2, 6 8 5 , 9 0 4 2, 4 6 2 , 0 0 1 1, 8 2 6 , 9 2 4 89 8 , 6 6 2 79 0 , 4 0 7 43 3 , 9 5 9 74 1 , 6 8 5 83 3 , 2 9 0 88 9 , 2 0 5 1, 3 5 3 , 3 3 3 1, 8 5 3 , 5 3 4 2,178,041 1,914,920 2,273,008 3,169,724 Ch a n g e s i n A c c r u a l s 62 8 , 2 5 5 - - - - - - - - - - - - - - - - Re v e n u e s 6, 8 4 3 , 7 5 1 6, 7 7 1 , 3 2 5 6, 3 8 2 , 7 8 1 7, 3 8 8 , 5 7 5 4, 4 8 0 , 6 8 1 7, 3 2 3 , 0 1 5 5, 3 0 9 , 6 9 5 8, 5 3 1 , 2 2 0 7, 2 4 1 , 3 0 4 5, 9 1 4 , 2 3 6 6, 0 3 2 , 9 1 4 6, 0 3 7 , 5 5 5 6, 0 4 2 , 5 5 7 5,925,322 5,745,584 5,462,843 5,091,003 Ex p e n d i t u r e s (7 , 2 3 2 , 0 6 6 ) (9 , 6 7 5 , 9 4 9 ) (8 , 5 4 2 , 1 6 0 ) (9 , 9 5 9 , 1 2 9 ) (7 , 3 4 4 , 4 1 9 ) (9 , 3 6 6 , 7 4 6 ) (7 , 6 0 1 , 6 1 9 ) (1 0 , 1 5 8 , 9 7 0 ) (9 , 0 8 5 , 1 7 4 ) (7 , 7 9 3 , 7 9 8 ) (7 , 5 0 4 , 2 6 1 ) (7 , 4 7 2 , 8 3 0 ) (7 , 6 5 3 , 5 2 6 ) (8,123,919) (7,322,972) (6,501,603) (6,264,501) No n c a s h - D e p r e c i a t i o n 1 , 6 3 5 , 2 5 5 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1,935,476 1,935,476 1,935,476 1,935,476 Ca s h B a l a n c e - E n d i n g 3, 6 5 5 , 0 5 3 $ 2, 6 8 5 , 9 0 4 $ 2, 4 6 2 , 0 0 1 $ 1, 8 2 6 , 9 2 4 $ 89 8 , 6 6 2 $ 79 0 , 4 0 7 $ 43 3 , 9 5 9 $ 74 1 , 6 8 5 $ 83 3 , 2 9 0 $ 88 9 , 2 0 5 $ 1, 3 5 3 , 3 3 3 $ 1, 8 5 3 , 5 3 4 $ 2, 1 7 8 , 0 4 1 $ 1,914,920 $ 2,273,008 $ 3,169,724 $ 3,931,702 $ No t e s : 1) A d d e d $ 9 0 0 , 0 0 0 t o 2 0 1 8 f o r t h e c o m p l e t i o n o f W a t e r T o w e r # 2 a n d # 3 , a d d e d $ 3 5 0 , 0 0 0 f o r t h e c o m p l e t i o n o f E v e r g r e e n , l e s s $ 2 12 , 7 4 7 f o r F i r e h o u s e b i d b e l o w e s t i m a t e , a n d l e s s $ 4 0 , 0 0 0 f o r B el l v u e m i l l a n d o v e r l a y m o v e d t o 2 0 1 9 , l e s s $ 7 0 , 0 0 0 f o r 5 1 s t A v enue moved to 2019.  ‐  5 0 0 , 0 0 0  1 , 0 0 0 , 0 0 0  1 , 5 0 0 , 0 0 0  2 , 0 0 0 , 0 0 0  2 , 5 0 0 , 0 0 0  3 , 0 0 0 , 0 0 0  3 , 5 0 0 , 0 0 0  4 , 0 0 0 , 0 0 0  4 , 5 0 0 , 0 0 0  5 , 0 0 0 , 0 0 0 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 Wa t e r   U t i l i t y Ca p i t a l   O u t l a y   ( C I P ) Ca s h   B a l a n c e   ‐   E n d i n g 12 Ci t y o f B r o o k l y n C e n t e r Sa n i t a r y S e w e r U t i l i t y C a s h F l o w s Re v i s e d : 7 - 2 - 1 8 Re s i d e n t i a l - F l a t F e e / P e r Q t r . 82 . 4 2 $ 8 2 . 4 2 $ 8 4 . 8 9 $ 8 9 . 1 4 $ 9 3 . 5 9 $ 9 8 . 2 7 $ 1 0 3 . 1 9 $ 1 0 5 . 2 5 $ 1 0 7 . 3 6 $ 1 0 9 . 5 0 $ 1 1 1 . 6 9 $ 1 1 3 . 9 3 $ 1 1 5 . 0 7 $ 1 1 5 . 0 7 $ 115.07 $ 115.07 $ 115.07 $ Pe r Q u a r t e r C h a n g e 2. 4 0 $ - $ 2. 4 7 $ 4. 2 4 $ 4. 4 6 $ 4. 6 8 $ 4. 9 1 $ 2. 0 6 $ 2. 1 1 $ 2. 1 5 $ 2. 1 9 $ 2. 2 3 $ 1. 1 4 $ -$ - $ - $ - $ Ac t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 2 0 3 3 Re v e n u e s Op e r a t i n g 4, 2 8 7 , 6 7 4 $ 4, 2 8 7 , 6 7 4 $ 4, 4 1 6 , 3 0 4 $ 4, 6 3 7 , 1 1 9 $ 4, 8 6 8 , 9 7 5 $ 5, 1 1 2 , 4 2 4 $ 5, 3 6 8 , 0 4 5 $ 5, 4 7 5 , 4 0 6 $ 5, 5 8 4 , 9 1 4 $ 5, 6 9 6 , 6 1 3 $ 5, 8 1 0 , 5 4 5 $ 5, 9 2 6 , 7 5 6 $ 5, 9 8 6 , 0 2 3 $ 5,986,023 $ 5,986,023 $ 5,986,023 $ 5,986,023 $ In v e s t m e n t E a r n i n g s 46 , 9 8 7 48 , 6 6 2 29 , 5 2 8 23 , 4 3 1 21 , 7 9 1 14 , 2 6 1 3, 9 8 0 3, 4 8 2 7, 5 0 1 13 , 1 8 1 9, 6 8 1 15 , 4 2 1 19 , 6 3 3 16,896 2,610 6,622 16,027 No n o p e r a t i n g 98 1 - - - - - - - - - - - - - - - - Bo n d P r o c e e d s 1, 3 9 5 , 0 0 0 - 1 , 7 5 0 , 0 0 0 1, 7 6 0 , 0 0 0 - - - 1 , 3 9 0 , 0 0 0 2, 1 0 0 , 0 0 0 - - - - - - - - To t a l 5, 7 3 0 , 6 4 2 4, 3 3 6 , 3 3 6 6, 1 9 5 , 8 3 2 6, 4 2 0 , 5 5 1 4, 8 9 0 , 7 6 6 5, 1 2 6 , 6 8 6 5, 3 7 2 , 0 2 5 6, 8 6 8 , 8 8 8 7, 6 9 2 , 4 1 5 5, 7 0 9 , 7 9 4 5, 8 2 0 , 2 2 6 5, 9 4 2 , 1 7 7 6, 0 0 5 , 6 5 7 6,002,919 5,988,633 5,992,645 6,002,050 Ex p e n d i t u r e s Pe r s o n a l S e r v c i e s 19 5 , 8 6 5 22 4 , 4 5 9 23 1 , 8 0 2 23 8 , 7 5 6 24 5 , 9 1 9 25 3 , 2 9 6 26 0 , 8 9 5 26 8 , 7 2 2 27 6 , 7 8 4 28 5 , 0 8 7 29 3 , 6 4 0 30 2 , 4 4 9 31 1 , 5 2 3 320,868 330,494 340,409 350,621 Su p p l i e s 13 , 0 7 7 39 , 7 1 5 35 , 1 1 5 35 , 8 1 7 36 , 5 3 4 37 , 2 6 4 38 , 0 1 0 38 , 7 7 0 39 , 5 4 5 40 , 3 3 6 41 , 1 4 3 41 , 9 6 6 42 , 8 0 5 43,661 44,971 44,534 45,870 Ot h e r S e r v i c e s & C h a r g e s 2 , 7 9 2 , 4 4 8 2, 8 6 9 , 2 5 8 3, 0 1 3 , 1 7 6 3, 1 3 3 , 7 0 3 3, 2 5 9 , 0 5 1 3, 3 2 4 , 2 3 2 3, 3 9 0 , 7 1 7 3, 4 5 8 , 5 3 1 3, 5 2 7 , 7 0 2 3, 5 9 8 , 2 5 6 3, 6 7 0 , 2 2 1 3, 7 4 3 , 6 2 5 3, 8 1 8 , 4 9 8 3,894,868 4,011,714 3,972,765 4,091,948 In s u r a n c e 25 , 0 6 3 26 , 5 6 8 28 , 1 6 2 28 , 7 2 5 29 , 3 0 0 29 , 8 8 6 30 , 4 8 3 31 , 0 9 3 31 , 7 1 5 32 , 3 4 9 32 , 9 9 6 33 , 6 5 6 34 , 3 2 9 35,016 36,066 35,716 36,788 Ut i l i t i e s 44 , 7 5 5 39 , 1 0 0 39 , 1 0 0 39 , 8 8 2 40 , 6 8 0 41 , 4 9 3 42 , 3 2 3 43 , 1 7 0 44 , 0 3 3 44 , 9 1 4 45 , 8 1 2 46 , 7 2 8 47 , 6 6 3 48,616 50,074 49,588 51,076 De p r e c i a t i o n 89 7 , 8 0 3 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1,124,040 1,124,040 1,124,040 1,124,040 Ca p i t a l O u t l a y 1, 9 4 9 , 7 7 8 2, 6 2 6 , 8 5 8 2, 9 1 5 , 0 0 0 2, 3 5 8 , 0 0 0 1, 0 8 0 , 0 0 0 1, 5 1 3 , 0 0 0 71 3 , 0 0 0 1, 6 8 0 , 0 0 0 2, 1 0 0 , 0 0 0 75 6 , 0 0 0 50 , 0 0 0 37 0 , 0 0 0 1, 2 0 4 , 0 0 0 2,473,000 705,000 200,000 110,000 De b t S e r v i c e ( E x i s t i n g ) 28 2 , 2 9 3 42 3 , 7 4 3 54 3 , 1 4 0 54 4 , 5 6 3 54 0 , 7 5 1 54 4 , 1 7 9 53 4 , 9 2 2 53 5 , 2 1 9 53 0 , 1 8 4 48 2 , 2 0 4 29 1 , 8 4 4 16 1 , 9 0 0 - - - - - De b t S e r v i c e ( P r o j e c t e d ) - - - 2 0 5 , 1 5 3 41 1 , 4 7 9 41 1 , 4 7 9 41 1 , 4 7 9 41 1 , 4 7 9 57 4 , 4 2 9 82 0 , 6 1 4 82 0 , 6 1 4 82 0 , 6 1 4 82 0 , 6 1 4 615,460 409,134 409,134 409,134 To t a l 6, 2 0 1 , 0 8 2 7, 3 7 3 , 7 4 1 7, 9 2 9 , 5 3 5 7, 7 0 8 , 6 4 0 6, 7 6 7 , 7 5 3 7, 2 7 8 , 8 7 0 6, 5 4 5 , 8 6 9 7, 5 9 1 , 0 2 3 8, 2 4 8 , 4 3 3 7, 1 8 3 , 8 0 0 6, 3 7 0 , 3 0 9 6, 6 4 4 , 9 7 8 7, 4 0 3 , 4 7 1 8,555,529 6,711,494 6,176,187 6,219,478 Ca s h B a l a n c e - B e g i n n i n g 4, 7 3 1 , 9 8 2 4, 8 6 6 , 1 5 9 2, 9 5 2 , 7 9 4 2, 3 4 3 , 1 3 0 2, 1 7 9 , 0 8 1 1, 4 2 6 , 1 3 4 39 7 , 9 9 0 34 8 , 1 8 7 75 0 , 0 9 1 1, 3 1 8 , 1 1 4 96 8 , 1 4 8 1, 5 4 2 , 1 0 6 1, 9 6 3 , 3 4 5 1,689,570 261,000 662,180 1,602,677 Ch a n g e s i n A c c r u a l s (2 9 3 , 1 8 6 ) - - - - - - - - - - - - - - - - Re v e n u e s 5, 7 3 0 , 6 4 2 4, 3 3 6 , 3 3 6 6, 1 9 5 , 8 3 2 6, 4 2 0 , 5 5 1 4, 8 9 0 , 7 6 6 5, 1 2 6 , 6 8 6 5, 3 7 2 , 0 2 5 6, 8 6 8 , 8 8 8 7, 6 9 2 , 4 1 5 5, 7 0 9 , 7 9 4 5, 8 2 0 , 2 2 6 5, 9 4 2 , 1 7 7 6, 0 0 5 , 6 5 7 6,002,919 5,988,633 5,992,645 6,002,050 Ex p e n d i t u r e s (6 , 2 0 1 , 0 8 2 ) (7 , 3 7 3 , 7 4 1 ) (7 , 9 2 9 , 5 3 5 ) (7 , 7 0 8 , 6 4 0 ) (6 , 7 6 7 , 7 5 3 ) (7 , 2 7 8 , 8 7 0 ) (6 , 5 4 5 , 8 6 9 ) (7 , 5 9 1 , 0 2 3 ) (8 , 2 4 8 , 4 3 3 ) (7 , 1 8 3 , 8 0 0 ) (6 , 3 7 0 , 3 0 9 ) (6 , 6 4 4 , 9 7 8 ) (7 , 4 0 3 , 4 7 1 ) (8,555,529) (6,711,494) (6,176,187) (6,219,478) No n c a s h - D e p r e c i a t i o n 89 7 , 8 0 3 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1,124,040 1,124,040 1,124,040 1,124,040 Ca s h B a l a n c e - E n d i n g 4, 8 6 6 , 1 5 9 $ 2, 9 5 2 , 7 9 4 $ 2, 3 4 3 , 1 3 0 $ 2, 1 7 9 , 0 8 1 $ 1, 4 2 6 , 1 3 4 $ 39 7 , 9 9 0 $ 34 8 , 1 8 7 $ 75 0 , 0 9 1 $ 1, 3 1 8 , 1 1 4 $ 96 8 , 1 4 8 $ 1, 5 4 2 , 1 0 6 $ 1, 9 6 3 , 3 4 5 $ 1, 6 8 9 , 5 7 0 $ 261,000 $ 662,180 $ 1,602,67 7 $ 2,509,29 0 $ No t e s : 1) 2 0 1 8 a m o u n t s i n c l u d e $ 4 1 0 , 0 0 0 f o r l i f t s t a t i o n # 1 r e h a b , $ 2 6 0 , 0 0 0 f o r c o m p l e t i o n o f E v e r g r e e n , l e s s $ 6 3 8 , 1 4 2 f o r F i r e h o u s e b i d b e l o w e s t i m a t e , a n d l e s s $ 6 0 , 0 0 0 f o r B e l l v u e m i l l a n d o v e r l a y m o v e d t o 2 0 1 9 , l e s s $ 6 0 , 0 0 0 f o r 5 1 s t A v e n u e m o v e d t o 2 0 1 9 .  ‐  1 , 0 0 0 , 0 0 0  2 , 0 0 0 , 0 0 0  3 , 0 0 0 , 0 0 0  4 , 0 0 0 , 0 0 0  5 , 0 0 0 , 0 0 0  6 , 0 0 0 , 0 0 0 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 Ca p i t a l   O u t l a y Ca s h   B a l a n c e   ‐   E n d i n g 13 Ci t y o f B r o o k l y n C e n t e r St o r m W a t e r U t i l i t y C a s h F l o w s Re v i s e d : 6 - 2 9 - 1 8 Re s i d e n t i a l - F l a t F e e / P e r Q t r . 14 . 4 8 $ 1 4 . 7 7 $ 1 5 . 0 6 $ 1 5 . 3 7 $ 15 . 6 7 $ 15 . 9 9 $ 16 . 3 1 $ 16 . 6 3 $ 16 . 9 7 $ 17 . 3 0 $ 17 . 6 5 $ 18 . 0 0 $ 18 . 3 6 $ 18.73 $ 19.11 $ 19.49 $ 19.88 $ Pe r Q u a r t e r C h a n g e - $ 0. 2 9 $ 0. 3 0 $ 0. 3 0 $ 0. 3 1 $ 0. 3 1 $ 0. 3 2 $ 0. 3 3 $ 0. 3 3 $ 0. 3 4 $ 0. 3 5 $ 0. 3 5 $ 0. 3 6 $ 0.37 $ 0.37 $ 0.38 $ 0.39 $ Ac t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 20 2 4 20 2 5 20 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2030 2031 2032 2033 Re v e n u e s Op e r a t i n g 1, 5 9 8 , 3 7 4 $ 1, 6 3 0 , 3 4 1 $ 1, 6 6 2 , 9 4 8 $ 1, 6 9 6 , 2 0 7 $ 1, 7 3 0 , 1 3 1 $ 1, 7 6 4 , 7 3 4 $ 1, 8 0 0 , 0 2 9 $ 1, 8 3 6 , 0 2 9 $ 1, 8 7 2 , 7 5 0 $ 1, 9 1 0 , 2 0 5 $ 1, 9 4 8 , 4 0 9 $ 1, 9 8 7 , 3 7 7 $ 2, 0 2 7 , 1 2 5 $ 2,067,667 $ 2,109,021 $ 2,151,201 $ 2,194,225 $ In v e s t m e n t E a r n i n g s 42 , 2 2 0 46 , 5 4 8 46 , 5 4 8 27 , 4 6 8 28 , 2 9 1 15 , 6 8 4 13 , 2 8 1 8, 2 3 7 8, 7 9 4 8, 2 5 3 5, 1 1 1 7, 4 7 0 4, 7 1 7 9,784 4,275 5,325 4,513 No n o p e r a t i n g 25 0 - - - - - - - - - - - - - - - - Bo n d P r o c e e d s - 1 , 5 3 0 , 1 4 2 1, 6 7 0 , 0 0 0 1, 9 1 0 , 0 0 0 - - - - - - - - 2 , 7 1 0 , 0 0 0 - - - - To t a l 1, 6 4 0 , 8 4 4 3, 2 0 7 , 0 3 1 3, 3 7 9 , 4 9 6 3, 6 3 3 , 6 7 5 1, 7 5 8 , 4 2 3 1, 7 8 0 , 4 1 9 1, 8 1 3 , 3 0 9 1, 8 4 4 , 2 6 7 1, 8 8 1 , 5 4 4 1, 9 1 8 , 4 5 8 1, 9 5 3 , 5 2 0 1, 9 9 4 , 8 4 7 4, 7 4 1 , 8 4 2 2,077,451 2,113,296 2,156,526 2,198,738 Ex p e n d i t u r e s Pe r s o n a l S e r v c i e s 20 8 , 9 3 2 22 6 , 7 2 5 23 2 , 3 0 4 23 9 , 2 7 3 24 6 , 4 5 1 25 3 , 8 4 5 26 1 , 4 6 0 26 9 , 3 0 4 27 7 , 3 8 3 28 5 , 7 0 5 29 4 , 2 7 6 30 3 , 1 0 4 31 2 , 1 9 7 321,563 331,210 341,146 351,381 Su p p l i e s 19 , 4 2 0 61 , 5 0 0 53 , 2 6 5 54 , 3 3 0 55 , 4 1 7 56 , 5 2 5 57 , 6 5 6 58 , 8 0 9 59 , 9 8 5 61 , 1 8 5 62 , 4 0 8 63 , 6 5 7 64 , 9 3 0 66,228 67,553 68,904 70,282 Ot h e r S e r v i c e s & C h a r g e s 30 4 , 2 8 1 35 1 , 4 8 5 35 2 , 4 5 0 35 9 , 4 9 9 36 6 , 6 8 9 37 4 , 0 2 3 38 1 , 5 0 3 38 9 , 1 3 3 39 6 , 9 1 6 40 4 , 8 5 4 41 2 , 9 5 1 42 1 , 2 1 0 42 9 , 6 3 5 438,227 446,992 455,932 465,050 In s u r a n c e 2, 2 3 3 2, 3 6 7 2, 5 0 9 2, 5 5 9 2, 6 1 0 2, 6 6 3 2, 7 1 6 2, 7 7 0 2, 8 2 6 2, 8 8 2 2, 9 4 0 2, 9 9 8 3, 0 5 8 3,120 3,182 3,246 3,311 Ut i l i t i e s 2, 9 2 4 3, 6 0 0 3, 7 0 0 3, 7 7 4 3, 8 4 9 3, 9 2 6 4, 0 0 5 4, 0 8 5 4, 1 6 7 4, 2 5 0 4, 3 3 5 4, 4 2 2 4, 5 1 0 4,600 4,692 4,786 4,882 De p r e c i a t i o n 1, 2 7 7 , 8 8 3 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1,373,350 1,373,350 1,373,350 1,373,350 Ca p i t a l O u t l a y 1, 6 2 8 , 8 0 1 2, 1 8 2 , 1 1 6 3, 7 7 8 , 4 7 0 2, 3 9 8 , 0 0 0 1, 6 2 4 , 0 0 0 60 8 , 0 0 0 89 2 , 0 0 0 35 0 , 0 0 0 47 4 , 0 0 0 75 8 , 0 0 0 22 0 , 0 0 0 88 0 , 0 0 0 2, 8 2 6 , 0 0 0 1,253,000 837,000 1,046,000 480,000 De b t S e r v i c e ( e x i s t i n g ) 18 , 0 8 0 11 6 , 6 5 0 15 8 , 4 8 5 29 8 , 1 0 0 30 0 , 4 0 0 30 2 , 1 5 0 29 8 , 6 0 0 29 4 , 8 0 0 30 0 , 7 0 0 29 6 , 0 5 0 30 1 , 1 0 0 17 5 , 0 5 0 17 5 , 1 0 0 - - - - De b t S e r v i c e ( p r o j e c t e d ) - - - 1 9 5 , 7 7 5 41 9 , 6 8 5 41 9 , 6 8 5 41 9 , 6 8 5 41 9 , 6 8 5 41 9 , 6 8 5 41 9 , 6 8 5 41 9 , 6 8 5 41 9 , 6 8 5 41 9 , 6 8 5 541,605 317,695 317,695 317,695 To t a l 3, 4 6 2 , 5 5 4 4, 3 1 7 , 7 9 3 5, 9 5 4 , 5 3 3 4, 9 2 4 , 6 6 1 4, 3 9 2 , 4 5 2 3, 3 9 4 , 1 6 7 3, 6 9 0 , 9 7 5 3, 1 6 1 , 9 3 7 3, 3 0 9 , 0 1 2 3, 6 0 5 , 9 6 1 3, 0 9 1 , 0 4 6 3, 6 4 3 , 4 7 7 5, 6 0 8 , 4 6 5 4,001,694 3,381,674 3,611,059 3,065,950 Ca s h B a l a n c e - B e g i n n i n g 4, 2 3 7 , 6 1 5 3 , 6 8 5 , 8 6 2 3, 9 4 8 , 4 5 0 2, 7 4 6 , 7 6 4 2, 8 2 9 , 1 2 8 1, 5 6 8 , 4 4 9 1, 3 2 8 , 0 5 0 82 3 , 7 3 4 87 9 , 4 1 4 82 5 , 2 9 6 51 1 , 1 4 3 74 6 , 9 6 8 47 1 , 6 8 8 978,415 427,522 532,494 451,311 Ch a n g e s i n A c c r u a l s (7 , 9 2 6 ) - - - - - - - - - - - - - - - - Re v e n u e s 1, 6 4 0 , 8 4 4 3, 2 0 7 , 0 3 1 3, 3 7 9 , 4 9 6 3, 6 3 3 , 6 7 5 1, 7 5 8 , 4 2 3 1, 7 8 0 , 4 1 9 1, 8 1 3 , 3 0 9 1, 8 4 4 , 2 6 7 1, 8 8 1 , 5 4 4 1, 9 1 8 , 4 5 8 1, 9 5 3 , 5 2 0 1, 9 9 4 , 8 4 7 4, 7 4 1 , 8 4 2 2,077,451 2,113,296 2,156,526 2,198,738 Ex p e n d i t u r e s (3 , 4 6 2 , 5 5 4 ) (4 , 3 1 7 , 7 9 3 ) (5 , 9 5 4 , 5 3 3 ) (4 , 9 2 4 , 6 6 1 ) (4 , 3 9 2 , 4 5 2 ) (3 , 3 9 4 , 1 6 7 ) (3 , 6 9 0 , 9 7 5 ) (3 , 1 6 1 , 9 3 7 ) (3 , 3 0 9 , 0 1 2 ) (3 , 6 0 5 , 9 6 1 ) (3 , 0 9 1 , 0 4 6 ) (3 , 6 4 3 , 4 7 7 ) (5 , 6 0 8 , 4 6 5 ) (4,001,694) (3,381,674) (3,611,059) (3,065,950) No n c a s h - D e p r e c i a t i o n 1, 2 7 7 , 8 8 3 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1,373,350 1,373,350 1,373,350 1,373,350 Ca s h B a l a n c e - E n d i n g 3, 6 8 5 , 8 6 2 $ 3 , 9 4 8 , 4 5 0 $ 2, 7 4 6 , 7 6 4 $ 2, 8 2 9 , 1 2 8 $ 1, 5 6 8 , 4 4 9 $ 1, 3 2 8 , 0 5 0 $ 82 3 , 7 3 4 $ 87 9 , 4 1 4 $ 82 5 , 2 9 6 $ 51 1 , 1 4 3 $ 74 6 , 9 6 8 $ 47 1 , 6 8 8 $ 97 8 , 4 1 5 $ 427,522 $ 532,494 $ 451,311 $ 957,449 $ No t e s : 1) 2 0 1 8 i n c l u d e s $ 2 6 0 , 0 0 0 f o r t h e c o m p l e t i o n o f E v e r g r e e n , l e s s $ 2 1 4 , 4 1 4 f o r F i r e h o u s e b i d u n d e r e s t i m a t e , l e s s $ 3 9 0 , 0 0 0 f o r B e l l v u e m i l l a n d o v e r l a y m o v e d t o 2 0 1 9 , a n d l e s s $ 7 3 , 4 7 0 5 1 s t A v e n u e m o v e d t o 2 0 1 9 .  ‐  5 0 0 , 0 0 0  1 , 0 0 0 , 0 0 0  1 , 5 0 0 , 0 0 0  2 , 0 0 0 , 0 0 0  2 , 5 0 0 , 0 0 0  3 , 0 0 0 , 0 0 0  3 , 5 0 0 , 0 0 0  4 , 0 0 0 , 0 0 0  4 , 5 0 0 , 0 0 0 20 1 7 20 1 8 20 1 9 20 2 0 20 2 1 20 2 2 20 2 3 20 2 4 20 2 5 20 2 6 20 2 7 20 2 8 20 2 9 2030 2031 203 2 Ca p i t a l   O u t l a y Ca s h   B a l a n c e   ‐   E n d i n g 14 Ci t y o f B r o o k l y n C e n t e r St r e e t L i g h t U t i l i t y F u n d R a t e A n a l y s i s Re v i s e d : 6 - 2 9 - 1 8 Re s i d e n t i a l - F l a t F e e / P e r Q t r . 6. 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6.55 $ 6.55 $ Pe r Q u a r t e r C h a n g e - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ Ac t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 2 0 3 3 Re v e n u e s Op e r a t i n g 45 1 , 3 5 8 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 450,500 $ 450,500 $ 450,500 $ 450,500 $ In v e s t m e n t E a r n i n g s 6, 1 7 0 6, 6 3 6 6, 6 3 6 6, 1 3 9 6, 4 9 1 7, 7 9 7 8, 5 6 8 6, 4 6 6 6, 5 2 2 5, 8 2 6 4, 9 6 9 6, 7 5 0 8, 4 9 3 10,197 11,761 12,681 13,750 No n o p e r a t i n g 2, 9 3 5 - - - - - - - - - - - - - - - - To t a l 46 0 , 4 6 3 45 7 , 1 3 6 45 7 , 1 3 6 45 6 , 6 3 9 45 6 , 9 9 1 45 8 , 2 9 7 45 9 , 0 6 8 45 6 , 9 6 6 45 7 , 0 2 2 45 6 , 3 2 6 45 5 , 4 6 9 45 7 , 2 5 0 45 8 , 9 9 3 460,697 462,261 463,181 464,250 Ex p e n d i t u r e s Su p p l i e s 5, 9 0 1 7, 7 8 0 7, 7 8 0 7, 9 3 6 8, 0 9 4 8, 2 5 6 8, 4 2 1 8, 5 9 0 8, 7 6 2 8, 9 3 7 9, 1 1 6 9, 2 9 8 9, 4 8 4 9,673 9,867 10,064 10,266 Ot h e r S e r v i c e s & C h a r g e s 32 , 9 5 0 47 , 9 0 4 48 , 0 7 3 49 , 0 3 4 50 , 0 1 5 51 , 0 1 5 52 , 0 3 6 53 , 0 7 6 54 , 1 3 8 55 , 2 2 1 56 , 3 2 5 57 , 4 5 2 58 , 6 0 1 59,773 60,968 62,188 63,431 In s u r a n c e 79 8 84 6 89 7 91 5 93 3 95 2 97 1 99 0 1, 0 1 0 1, 0 3 0 1, 0 5 1 1, 0 7 2 1, 0 9 3 1,115 1,138 1,160 1,184 Ut i l i t i e s 16 8 , 1 1 8 18 0 , 0 0 0 18 0 , 0 0 0 18 3 , 6 0 0 18 7 , 2 7 2 19 1 , 0 1 7 19 4 , 8 3 8 19 8 , 7 3 5 20 2 , 7 0 9 20 6 , 7 6 3 21 0 , 8 9 9 21 5 , 1 1 7 21 9 , 4 1 9 223,807 228,284 232,849 237,506 De p r e c i a t i o n 59 , 3 0 2 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 1 0 3 , 1 8 3 1 0 3 , 1 8 3 103,183 103,183 Ca p i t a l O u t l a y 1 1 7 , 2 5 5 3 1 8 , 7 8 1 2 3 0 , 0 0 0 1 8 0 , 0 0 0 8 0 , 0 0 0 1 3 0 , 0 0 0 4 1 3 , 0 0 0 1 9 0 , 0 0 0 2 6 0 , 0 0 0 2 7 0 , 0 0 0 - - - 1 0 , 0 0 0 7 0 , 0 0 0 50,000 - To t a l 3 8 4 , 3 2 4 6 5 8 , 4 9 4 5 6 9 , 9 3 3 5 2 4 , 6 6 8 4 2 9 , 4 9 8 4 8 4 , 4 2 4 7 7 2 , 4 4 9 5 5 4 , 5 7 4 6 2 9 , 8 0 2 6 4 5 , 1 3 4 3 8 0 , 5 7 3 3 8 6 , 1 2 1 3 9 1 , 7 8 0 4 0 7 , 5 5 2 4 7 3 , 4 3 9 459,444 415,570 Ca s h B a l a n c e - B e g i n n i n g 58 1 , 4 6 9 7 2 1 , 6 8 6 6 2 3 , 5 1 1 6 1 3 , 8 9 7 6 4 9 , 0 5 1 7 7 9 , 7 2 7 8 5 6 , 7 8 3 6 4 6 , 5 8 5 6 5 2 , 1 6 0 5 8 2 , 5 6 2 4 9 6 , 9 3 7 6 7 5 , 0 1 6 8 4 9 , 3 2 8 1 , 0 1 9 , 7 2 4 1 , 1 7 6 , 0 5 2 1,268,057 1,374,976 Ch a n g e s i n A c c r u a l s 4 , 7 7 6 - - - - - - - - - - - - - - - - Re v e n u e s 4 6 0 , 4 6 3 4 5 7 , 1 3 6 4 5 7 , 1 3 6 4 5 6 , 6 3 9 4 5 6 , 9 9 1 4 5 8 , 2 9 7 4 5 9 , 0 6 8 4 5 6 , 9 6 6 4 5 7 , 0 2 2 4 5 6 , 3 2 6 4 5 5 , 4 6 9 4 5 7 , 2 5 0 4 5 8 , 9 9 3 4 6 0 , 6 9 7 4 6 2 , 2 6 1 463,181 464,250 Ex p e n d i t u r e s ( 3 8 4 , 3 2 4 ) ( 6 5 8 , 4 9 4 ) (5 6 9 , 9 3 3 ) (5 2 4 , 6 6 8 ) (4 2 9 , 4 9 8 ) (4 8 4 , 4 2 4 ) (7 7 2 , 4 4 9 ) (5 5 4 , 5 7 4 ) (6 2 9 , 8 0 2 ) (6 4 5 , 1 3 4 ) (3 8 0 , 5 7 3 ) (3 8 6 , 1 2 1 ) (3 9 1 , 7 8 0 ) (407,552) (473,439) (459,444) (415,570) No n c a s h - D e p r e c i a t i o n 59 , 3 0 2 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 103,183 103,183 103,183 103,183 Ca s h B a l a n c e - E n d i n g 72 1 , 6 8 6 $ 62 3 , 5 1 1 $ 61 3 , 8 9 7 $ 64 9 , 0 5 1 $ 77 9 , 7 2 7 $ 85 6 , 7 8 3 $ 64 6 , 5 8 5 $ 65 2 , 1 6 0 $ 58 2 , 5 6 2 $ 49 6 , 9 3 7 $ 67 5 , 0 1 6 $ 84 9 , 3 2 8 $ 1, 0 1 9 , 7 2 4 $ 1, 1 7 6 , 0 5 2 $ 1,268,057 $ 1,374,976 $ 1,526,839 $  ‐  2 0 0 , 0 0 0  4 0 0 , 0 0 0  6 0 0 , 0 0 0  8 0 0 , 0 0 0  1 , 0 0 0 , 0 0 0  1 , 2 0 0 , 0 0 0  1 , 4 0 0 , 0 0 0  1 , 6 0 0 , 0 0 0 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 Ca p i t a l   O u t l a y Ca s h   B a l a n c e   ‐   E n d i n g 15 Ci t y o f B r o o k l y n C e n t e r - T e c h n o l o g y F u n d B u d g e t - 2 0 1 9 t o 2 0 2 3 Ap p r o v e d R e q u e s t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 On - s i t e S e r v e r H a r d w a r e ( R e p l a c e m e n t , 4 - y e a r c y c l e ) VM S e r v e r b c - e s x i 1 - c h ( h o s t s b c - a d 0 1 , b c - v i d e o - v m 1 , b c - v i d e o - v m 2 ) ( 2 0 1 6 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 12 , 0 0 0 ( 5 1 % G e n e r a l , 2 2 % E B H C , 2 2 % L i q u o r , P U 5 % ) VM S e r v e r b c - e s x i 2 - p d ( h o s t s b c - p d 0 1 , b c - v i d e o - v m 3 , b c - v i d e o - v m 4 ) ( 2 0 1 6 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 12 , 0 0 0 ( 5 1 % G e n e r a l , 2 2 % E B H C , 2 2 % L i q u o r , P U 5 % ) S u b - T o t a l O n - s i t e S e r v e r H a r d w a r e - - 24 , 0 0 0 Ne t w o r k H a r d w a r e ( R e p l a c e m e n t , 3 - 5 - y e a r c y c l e ) Fi r e w a l l C i t y H a l l ( 2 0 1 4 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 6, 0 0 0 Fi r e w a l l P o l i c e ( 2 0 1 4 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 6, 0 0 0 La y e r 3 S w i t c h ( 2 0 1 4 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 10 , 0 0 0 Wi r e l e s s C o n t r o l l e r ( 2 0 1 6 ) ( 3 3 % G e n e r a l , 5 5 % E B H C , 4 % L i q u o r , 8 % P U ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 6,000 Ci t y H a l l N e t w o r k S w i t c h e s ( 3 4 8 - p o r t / 2 0 1 4 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 28 , 0 0 0 Co m m u n i t y C e n t e r N e t w o r k S w i t c h ( 1 4 8 - p o r t / 2 0 1 4 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 7, 5 0 0 Po l i c e N e t w o r k S w i t c h e s ( 4 4 8 - p o r t / 2 0 1 3 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 3 5 , 0 0 0 38,500 Po l i c e N e t w o r k E n c r y p t i o n T r a n s c e i v e r s - ( N E W 2 0 1 7 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 3,800 Pu b l i c W o r k s G a r a g e N e t w o r k S w i t c h e s ( 1 4 8 - p o r t / 2 0 1 3 ; 1 2 4 - p o r t / 2 0 1 3 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 1 3 , 0 0 0 14,300 We s t F i r e N e t w o r k S w i t c h ( 1 4 8 - p o r t / 2 0 1 5 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 7, 8 0 0 Ea s t F i r e N e t w o r k S w i t c h ( 1 2 4 - p o r t / 2 0 1 5 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 5, 8 0 0 Ce n t e r b r o o k N e t w o r k S w i t c h ( 1 2 4 - p o r t / 2 0 1 5 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 5, 8 0 0 Ci t y H a l l N e t w o r k W i r e l e s s ( 1 / 2 0 1 3 , 5 / 2 0 1 6 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 75 0 4,000 825 Co m m u n i t y C e n t e r N e t w o r k W i r e l e s s ( 3 / 2 0 1 3 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 2 , 2 5 0 2,475 Po l i c e N e t w o r k W i r e l e s s ( 4 / 2 0 1 3 , 2 / 2 0 1 6 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 3 , 0 0 0 1,800 3,300 Pu b l i c W o r k s G a r a g e N e t w o r k W i r e l e s s ( 3 / 2 0 1 5 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 2, 3 5 0 We s t F i r e N e t w o r k W i r e l e s s ( 2 / 2 0 1 3 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 1 , 5 0 0 1,650 Ea s t F i r e N e t w o r k W i r e l e s s ( 1 / 2 0 1 3 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 75 0 825 Ce n t e r b r o o k W i r e l e s s ( 1 / 2 0 1 3 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 75 0 825 UP S I T R o o m C i t y H a l l ( 2 0 1 6 ) ( 1 0 - 1 5 y e a r c y c l e ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 5 4 0 S u b - T o t a l N e t w o r k H a r d w a r e 57 , 0 0 0 57 , 5 0 0 21 , 7 5 0 11,800 3,800 62,700 IP T e l e p h o n y ( R e p l a c e m e n t , 5 - 8 - y e a r c y c l e ) Vo i c e G a t e w a y ( 2 0 1 5 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 8,000 Ha n d s e t R e p l a c e m e n t ( 2 0 1 0 ) ( 8 5 % G e n e r a l , 1 0 % E B H C , 5 % L i q u o r ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 5 4 0 6 8 , 0 0 0 Ri g h t F a x S o f t w a r e ( i n t e g r a t e s I P T w i t h E x c h a n g e f o r d i r e c t f a x i ng ) ( N E W ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 4 2 1 4 , 5 0 0 S u b - T o t a l I P T e l e p h o n y 72 , 5 0 0 - - So f t w a r e ( o v e r $ 2 5 , 0 0 0 ) La s e r f i c h e U p g r a d e Te c h n o l o g y F u n d 4 1 0 0 0 - 6 4 2 1 40 , 0 0 0 S u b - T o t a l S o f t w a r e - - 40 , 0 0 0 Vi d e o S u r v e i l l a n c e ( R e p l a c e m e n t , 7 - 1 0 y e a r c y c l e ) Ge n e r a l F u n d D e p a r t m e n t s ( N E W ) 2 0 1 8 - P u b l i c W o r k s G a r a g e Te c h n o l o g y F u n d 4 1 0 0 0 - 6 5 4 0 2 0 , 0 0 0 20 , 0 0 0 S u b - T o t a l V i d e o S u r v e i l l a n c e 20 , 0 0 0 20 , 0 0 0 - Se c u r i t y C a r d A c c e s s ( R e p l a c e m e n t , 7 - 2 0 y e a r c y c l e ) Ge n e r a l F u n d D e p a r t m e n t s ( N E W ) 2 0 1 8 - P u b l i c W o r k s G a r a g e / C o m m u n i t y C e n t e r T e c h n o l o g y F u n d 4 1 0 0 0 - 6 5 4 0 3 8 , 0 0 0 S u b - T o t a l S e c u r i t y C a r d A c c e s s 38 , 0 0 0 - - 16 Ap p r o v e d R e q u e s t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 Mu l t i - F u n c t i o n D e v i c e s ( R e p l a c e m e n t 7 - y e a r c y c l e ) Ge n e r a l F u n d D e p a r t m e n t s ( p u r c h a s e d 2 0 1 1 , 2 0 1 2 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 7 4 , 0 0 0 74 , 0 0 0 S u b - T o t a l M u l t i - F u n c t i o n D e v i c e s 74 , 0 0 0 74 , 0 0 0 - Sc a n n e r s ( R e p l a c e m e n t 7 - y e a r c y c l e ) Ge n e r a l F u n d D e p a r t m e n t s ( p u r c h a s e d 2 0 0 9 ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 30 , 0 0 0 S u b - T o t a l M u l t i - F u n c t i o n D e v i c e s - 30 , 0 0 0 - Di g i t a l S i g n a g e Ci t y H a l l / C o m m u n i t y C e n t e r & W e s t F i r e S t a t i o n ( o u t s i d e ) ( N E W ) Te c h n o l o g y F u n d 4 1 0 0 0 - 6 5 4 0 60 , 0 0 0 60 , 0 0 0 S u b - T o t a l M u l t i - F u n c t i o n D e v i c e s - 60 , 0 0 0 60 , 0 0 0 Au d i o V i s u a l ( R e p l a c e m e n t 5 - 7 - y e a r c y c l e ) Ge n e r a l F u n d B u i l d i n g C o n f e r e n c e R o o m s ( e x c l u d e s C o u n c i l C h a m b e r s ) ( N E W ) T e c h n o l o g y F u n d 4 1 0 0 0 - 6 2 4 3 2 0 , 0 0 0 - - S u b - T o t a l A u d i o V i s u a l 20 , 0 0 0 - - Fi b e r O p t i c I n f r a s t r u c t u r e Te c h n o l o g y F u n d 4 1 0 0 0 - 6 3 0 7 S u b - T o t a l F i b e r O p t i c I n f r a s t r u c t u r e - - - To t a l T e c h n o l o g y F u n d 28 1 , 5 0 0 24 1 , 5 0 0 14 5 , 7 5 0 11,800 3,800 62,700 17 Ci t y o f B r o o k l y n C e n t e r Te c h n o l o g y C a p i t a l F u n d C a s h F l o w s A n a l y s i s Up d a t e d 7 / 2 / 2 0 1 8 Ac t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 Re v e n u e s Tr a n s f e r s I n 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 140,000 $ 140,000 $ 140,000 $ In v e s t m e n t E a r n i n g s 2 , 0 6 3 3, 7 2 8 1, 0 8 4 - - 1 , 6 0 4 2, 9 8 2 3, 7 8 5 4, 3 5 2 4, 9 0 7 5, 4 5 0 5, 9 8 0 6,497 7,000 7,489 7,963 To t a l 14 2 , 0 6 3 14 3 , 7 2 8 14 1 , 0 8 4 14 0 , 0 0 0 14 0 , 0 0 0 14 1 , 6 0 4 14 2 , 9 8 2 14 3 , 7 8 5 14 4 , 3 5 2 14 4 , 9 0 7 14 5 , 4 5 0 14 5 , 9 8 0 14 6 , 4 9 7 147,000 147,489 147,963 Ex p e n d i t u r e s Pr i o r Y e a r P r o j e c t s - C a r r y F o r w a r d 1 2 6 , 6 6 2 - - - - - - - - - - - - - - Ca p i t a l O u t l a y 19 , 4 6 6 28 1 , 5 0 0 21 1 , 5 0 0 14 5 , 7 5 0 11 , 8 0 0 3, 8 0 0 62 , 7 0 0 87 , 1 1 0 88 , 8 5 2 90 , 6 2 9 92 , 4 4 2 94 , 2 9 1 96 , 1 7 6 98,100 100,062 102,063 To t a l 19 , 4 6 6 40 8 , 1 6 2 21 1 , 5 0 0 14 5 , 7 5 0 11 , 8 0 0 3, 8 0 0 62 , 7 0 0 87 , 1 1 0 88 , 8 5 2 90 , 6 2 9 92 , 4 4 2 94 , 2 9 1 96 , 1 7 6 98,100 100,062 102,063 Ca s h B a l a n c e - B e g i n n i n g 25 0 , 3 8 4 37 2 , 8 3 8 10 8 , 4 0 4 37 , 9 8 8 32 , 2 3 8 16 0 , 4 3 8 29 8 , 2 4 3 37 8 , 5 2 5 43 5 , 2 0 0 49 0 , 7 0 0 54 4 , 9 7 8 59 7 , 9 8 6 64 9 , 6 7 5 699,995 748,895 796,322 Ch a n g e s i n A c c r u a l s ( 1 4 3 ) - - - - - - - - - - - - - - - Re v e n u e s 14 2 , 0 6 3 14 3 , 7 2 8 14 1 , 0 8 4 14 0 , 0 0 0 14 0 , 0 0 0 14 1 , 6 0 4 14 2 , 9 8 2 14 3 , 7 8 5 14 4 , 3 5 2 14 4 , 9 0 7 14 5 , 4 5 0 14 5 , 9 8 0 14 6 , 4 9 7 147,000 147,489 147,963 Ex p e n d i t u r e s (1 9 , 4 6 6 ) ( 4 0 8 , 1 6 2 ) (2 1 1 , 5 0 0 ) (1 4 5 , 7 5 0 ) (1 1 , 8 0 0 ) (3 , 8 0 0 ) ( 6 2 , 7 0 0 ) (8 7 , 1 1 0 ) (8 8 , 8 5 2 ) (9 0 , 6 2 9 ) (9 2 , 4 4 2 ) (9 4 , 2 9 1 ) (9 6 , 1 7 6 ) (98,100) (100,062) (102,063) Ca s h B a l a n c e - E n d i n g 37 2 , 8 3 8 $ 10 8 , 4 0 4 $ 37 , 9 8 8 $ 32 , 2 3 8 $ 16 0 , 4 3 8 $ 29 8 , 2 4 3 $ 37 8 , 5 2 5 $ 43 5 , 2 0 0 $ 49 0 , 7 0 0 $ 54 4 , 9 7 8 $ 59 7 , 9 8 6 $ 64 9 , 6 7 5 $ 69 9 , 9 9 5 $ 748,895 $ 796,322 $ 842,222 $ No t e s : 1) 2 0 1 8 - 2 0 2 3 p e r T e c h n o l o g y C a p i t a l P l a n , 2 0 2 4 - 2 0 3 2 i s t h e a v e r a g e o f 2 0 1 9 - 2 0 2 3 p l u s g e n e r a l i n f l a t i o n ( 2 % ) 2) A d d e d 2 0 1 6 / 2 0 1 7 p r o j e c t s n o t c o m p l e t e d a s " P r i o r Y e a r P r o j e c t s - C a r r y F o r w a r d " i n t h e 2 0 1 8 p r o j e c t e d e x p e n s e s . P r o j e c t s i n c l u d e a u d i o v i s u a l e q u i p m e n t f o r c o n f e r e n c e r o o m s , v i d e o s u r v e i l l a n c e o f g o v e r n m e n t b u i l d i n g s , a c c e s s c o n t r a n d f i b e r t o C e n t e r b r o o k .  ‐  1 0 0 , 0 0 0  2 0 0 , 0 0 0  3 0 0 , 0 0 0  4 0 0 , 0 0 0  5 0 0 , 0 0 0  6 0 0 , 0 0 0  7 0 0 , 0 0 0  8 0 0 , 0 0 0  9 0 0 , 0 0 0 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 Te c h n o l o g y   F u n d   Ex p e n d i t u r e s Ca s h   B a l a n c e   ‐   E n d i n g 18 EARLE BROWN HERITAGE CENTER Page 1 2018-2035 CAPITAL IMPROVEMENT PLAN (revised June 18 2018) Estimated Acquisition or Subtotals Acquisition Acquisition Useful Replacement Estimated and Capital Item Year Cost Life Year Cost Totals Elec. Reader Boards for Inside/Outside New 15 2012 $128,000.00 Grey Chair Replacement 1989 - 2007 10 2018 $183,000.00 Booking & Reservation Sysytem 2000 15 2018 $91,000.00 Garden City Roof 2001 15 2018 $29,925.00 Phone System 1998 $32,000.00 10 2018 $40,000.00 Dewatering Well & Header 1995-2012 20 2018 $47,000.00 $390,925.00 Hippodrome Roof (EDPM) 1990 $91,575.00 20 2019 $205,000.00 Phone System 1998 $32,000.00 10 2019 $40,000.00 Switches (3) 2013-2015 $21,000.00 6 2019 $25,000.00 Carriage Hall Rotunda Doors (4 sets) 1989 30 2019 $70,000.00 Tack/Morgan/Hall Carpet 2011 $27,000.00 8 2019 $32,000.00 Replace Harvest/Garden City Carpet 2013 $40,000.00 6 2019 $50,000.00 GC/Harvest Prefunction/Link Carpet 2012 $45,000.00 6 2019 $60,000.00 $482,000.00 Carriage Hall RTU (Pre #1 & CH A #2) 1989 25 2020 $200,000.00 Facility Security System Server 2012 8 2020 $50,000.00 Main Kitchen Dishwasher 2005 $75,000.00 15 2020 $95,000.00 $345,000.00 Carriage Hall RTU (LL #4 & CH B #3)1989 25 2021 $200,000.00 Replace 2 Boilers Convention Center 2010 10 2021 $45,000.00 Captains/Estate/Loft Carpet 2014 $18,000.00 7 2021 $25,000.00 Replace Admin Office Carpet 2006 $18,000.00 16 2021 $25,000.00 Inn Carpet at Earle Brown House 2011 9 2021 $30,000.00 $325,000.00 Air Handling Unit #5 and #6 1989 27 2022 $73,000.00 D Barn Remodel 2011 10 2022 $325,000.00 $398,000.00 Main Large Marquee and Electronics 1989 15 2023 $30,000.00 Prefunction & Carriage Hall Carpet 2017 6 2023 $92,000.00 Replace Combi Oven 1990 $14,165.00 12 2023 $40,000.00 Stable Remodel 1989 2023 $200,000.00 $362,000.00 Replace S. Carriage Hall Door/Windows 2009 15 2024 $45,000.00 $45,000.00 Parking Lot Mill and Overlay (East Lots) 2000 25 2025 $100,000.00 Replace Harvest Divider Walls 2000 25 2025 $50,000.00 Tack/Morgan/Hall Carpet 2019 $30,000.00 8 2025 $32,000.00 $182,000.00 19 EARLE BROWN HERITAGE CENTER Page 2 2018-2035 CAPITAL IMPROVEMENT PLAN (revised June 18 2018) Estimated Acquisition or Subtotals Acquisition Acquisition Useful Replacement Estimated and Capital Item Year Cost Life Year Cost Totals Replace Harvest/GC/Link Carpet 2019 $30,000.00 7 2026 $30,000.00 $30,000.00 Replace Harvest/GC Carpet 2020 $40,000.00 7 2027 $50,000.00 $50,000.00 Prefunction Tile or Carpet Carriage Hall 2022 6 2028 $92,000.00 Rotunda Roof & CH Metal Work 1989 20 2028 $91,000.00 HVAC EMS 2018 $15,500.00 10 2028 $49,300.00 Facility Security System Server 2020 8 2028 $50,000.00 Captain's/Estate/Loft Carpet 2021 $18,000.00 7 2028 $30,000.00 $312,300.00 Phone System 2019 $32,000.00 10 2029 $40,000.00 Inn Carpet 2020 9 2029 $30,000.00 Carriage Hall Carpet 2023 $50,000.00 6 2029 $50,000.00 $120,000.00 Replace Stable Roof 1990 20 2030 $28,000.00 Parking Lot Mill and Overlay (Main Lot) 2005 $70,000.00 25 2030 $100,000.00 Replace Chiller 1989 20 2030 $160,000.00 $288,000.00 Hippodrome Roof (EDPM) 1990 $91,575.00 17 2031 $100,000.00 $100,000.00 Carriage Hall Wall Panels 1989 $72,000.00 20 2032 $99,000.00 $99,000.00 Replace 2 Steam Jacket Kettles 1989 20 2033 $30,000.00 Replace GC/Harvest/Link Carpet 2026 $30,000.00 7 2033 $30,000.00 $60,000.00 Replace Inn Roofs 1989 20 2034 $50,000.00 Replace D Barn Roof 2009 $24,000.00 20 2034 $25,000.00 Prefunction Tile or Carpet Carriage Hall 2028 6 2034 $92,000.00 Harvest /Garden City Carpet 2027 $40,000.00 7 2034 $40,000.00 $207,000.00 Main Kitchen Dishwasher 2005 $75,000.00 15 2035 $75,000.00 Tack/Morgan/Hall Carpet 2027 $30,000.00 8 2035 $30,000.00 Replace 2 Boilers (Inn) 2015 $30,000.00 20 2035 $35,000.00 Replace Carriage Hall Carpet 2029 $50,000.00 6 2035 $50,000.00 Replace Combi Oven 2023 $14,165.00 12 2035 $40,000.00 Captain's/Estate/Loft carpet 2028 $30,000.00 7 2035 $30,000.00 $260,000.00 This report encompasses all anticipated capital expenditures (items exceeding $25,000) from 2019-2035. All dollar amounts are shown in 2018 dollars, with appropriate yearly increases projected where possible. 20 Ci t y o f B r o o k l y n C e n t e r EB H C C a p i t a l P r o je c t s F u n d C as h F l o w s A n a l y s i s Re v i s e d : J u n e 2 9 , 2 0 1 8 Ac t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 2 0 3 2 2 0 3 3 2 0 3 4 Re v e n u e s Tr a n s f e r s 50 0 , 0 0 0 $ 32 5 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 318,000 $ 318,000 $ 318,000 $ Ca p i t a l C o n t r i b u t i o n s - - - - - - - - - - - - - - - - - - In v e s t m e n t E a r n i n g s 7, 3 9 7 12 , 7 9 7 15 , 7 8 0 15 , 7 8 0 9, 0 0 0 9, 0 2 0 8, 3 1 0 7, 9 5 3 10 , 7 6 3 12 , 2 3 0 15 , 2 3 3 18 , 0 6 5 18 , 3 0 2 20 , 4 6 6 20 , 9 7 0 23,360 25,783 28,621 To t a l 50 7 , 3 9 7 33 7 , 7 9 7 33 3 , 7 8 0 33 3 , 7 8 0 32 7 , 0 0 0 32 7 , 0 2 0 32 6 , 3 1 0 32 5 , 9 5 3 32 8 , 7 6 3 33 0 , 2 3 0 33 3 , 2 3 3 33 6 , 06 5 33 6 , 3 0 2 33 8 , 4 6 6 33 8 , 9 7 0 341,360 343,783 346,621 Ex p e n d i t u r e s Ca p i t a l O u t l a y 30 6 , 2 2 4 55 8 , 0 6 5 48 2 , 0 0 0 34 5 , 0 0 0 32 5 , 0 0 0 39 8 , 0 0 0 36 2 , 0 0 0 45 , 0 0 0 18 2 , 0 0 0 30 , 0 0 0 50 , 0 0 0 31 2 , 3 0 0 12 0 , 0 0 0 28 8 , 0 0 0 10 0 , 0 0 0 99,000 60,000 207,000 To t a l 30 6 , 2 2 4 55 8 , 0 6 5 48 2 , 0 0 0 34 5 , 0 0 0 32 5 , 0 0 0 39 8 , 0 0 0 36 2 , 0 0 0 45 , 0 0 0 18 2 , 0 0 0 30 , 0 0 0 50 , 0 0 0 31 2 , 3 0 0 12 0 , 0 0 0 28 8 , 0 0 0 10 0 , 0 0 0 99,000 60,000 207,000 Ca s h B a l a n c e - B e g i n n i n g 1, 0 7 8 , 5 1 1 1, 2 7 9 , 6 8 4 1, 0 5 9 , 4 1 6 91 1 , 1 9 6 89 9 , 9 7 6 90 1 , 9 7 5 83 0 , 9 9 5 79 5 , 3 0 5 1, 07 6 , 2 5 8 1, 2 2 3 , 0 2 1 1, 5 2 3 , 2 5 1 1, 8 0 6 , 4 8 3 1, 8 3 0 , 2 4 8 2, 0 4 6 , 5 5 1 2, 0 9 7 , 0 1 6 2,335,986 2,578,346 2,862,130 Ch a n g e s i n A c c r u a l s - - - - - - - - - - - - - - - - - - Re v e n u e s 50 7 , 3 9 7 33 7 , 7 9 7 33 3 , 7 8 0 33 3 , 7 8 0 32 7 , 0 0 0 32 7 , 0 2 0 32 6 , 3 1 0 32 5 , 9 5 3 32 8 , 7 6 3 33 0 , 2 3 0 33 3 , 2 3 3 33 6 , 0 6 5 33 6 , 3 0 2 33 8 , 4 6 6 33 8 , 9 7 0 341,360 343,783 346,621 Ex p e n d i t u r e s (3 0 6 , 2 2 4 ) (55 8 , 0 6 5 ) (48 2 , 0 0 0 ) (3 4 5 , 0 0 0 ) (3 2 5 , 0 0 0 ) (3 9 8 , 0 0 0 ) (3 6 2 , 0 0 0 ) (4 5 , 0 0 0 ) (18 2 , 0 0 0 ) (3 0 , 00 0 ) (5 0 , 00 0 ) (31 2 , 3 0 0 ) (12 0 , 0 0 0 ) (28 8 , 0 0 0 ) (10 0 , 0 0 0 ) (99,000) (60,000) (207,000) Ca s h B a l a n c e - E n d i n g 1 , 2 7 9 , 6 8 4 $ 1, 0 5 9 , 4 1 6 $ 91 1 , 1 9 6 $ 89 9 , 9 7 6 $ 90 1 , 9 7 5 $ 83 0 , 9 9 5 $ 79 5 , 3 0 5 $ 1, 0 7 6 , 2 5 8 $ 1, 2 2 3 , 0 2 1 $ 1, 5 2 3 , 2 5 1 $ 1, 8 0 6 , 4 8 3 $ 1, 8 3 0 , 2 4 8 $ 2, 0 4 6 , 5 5 1 $ 2, 0 9 7 , 0 1 6 $ 2, 3 3 5 , 9 8 6 $ 2,578,346 $ 2,862,130 $ 3,001,751 $ No t e s : 1) T h e 2 0 1 8 P r o j e c t i o n i n c l u d e s t h e c a r r y - f o r w a r d o f E l e c t r o n i c B o a r d R e a d e r s ( $ 1 2 8 , 0 0 0 ) a n d C a r r i a g e H a l l C a r p e t ( $ 7 9 , 1 4 0 ) , l es s P h o n e S y s t e m m o v e d t o 2 0 1 9 ( $ 4 0 , 0 0 0 ) 2) T h e 2 0 1 8 P r o j e c t i o n i n c l u d e s a c t u a l p r o p o s e d t r a n s f e r , f u t u r e y e a r s b a s e d o n 5 - y e a r h i s t o r i c a l a v e r a g e  ‐  5 0 0 , 0 0 0  1 , 0 0 0 , 0 0 0  1 , 5 0 0 , 0 0 0  2 , 0 0 0 , 0 0 0  2 , 5 0 0 , 0 0 0 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 2 0 2 4 2 0 2 5 2 0 2 6 2 0 2 7 2 0 2 8 2 0 2 9 2 0 3 0 2 0 3 1 Ex p e n d i t u r e s Ca s h   B a l a n c e   ‐   E n d i n g Ea r l e B r o w n   H e r i t a g e   C e n t e r   ‐ C a p i t a l   F u n d 21 BC Liquor Page 1 2019-2033 CIP (revised June 25, 2018) Acquisition or Subtotals Replacement Estimated and Capital Item Year Cost Totals Blvd. Signage at Store #2 2018 $25,000 Business Site/Location Feasibility Analysis 2018 $25,000 2018 $50,000 Business Site/Location Feasibility Analysis -2019 $750,000 Implementation of Results (Store #1 Land Acquisition) 2019 $750,000 Business Site/Location Feasibility Analysis -2020 $1,650,000 Implementation of Results (Store #1 Building Construction) 2020 $1,650,000 Business Site/Location Feasibility Analysis -2022 $600,000 Implementation of Results (Store #2 Land Acquisition) 2022 $600,000 Business Site/Location Feasibility Analysis -2023 $1,250,000 Implementation of Results (Store #2 Building Construction) Business Site/Location Feasibility Analysis -2023 $600,000 Implementation of Results (Store #3 Land Acquisition) 2023 $1,850,000 Business Site/Location Feasibility Analysis -2024 $1,250,000 Implementation of Results (Store #3 Building Construction) 2024 $1,250,000 This report encompasses all anticipated capital expenditures (items exceeding $25,000) from 2019-2033. 22 Ca p i t a l I m p r o v e m e n t P l a n 2 0 1 9 – 2 0 3 3 20 1 9 C a p i t a l P r o j e c t B u d g e t s July 16, 2018 23 Ag e n d a  In t r o d u c t i o n  Ca p i t a l I m p r o v e m e n t P l a n  In d i v i d u a l C a p i t a l P r o j e c t F u n d s ◦ Ca p i t a l I m p r o v e m e n t s F u n d ◦ Mu n i c i p a l S t a t e A i d F u n d ◦ St r e e t R e c o n s t r u c t i o n F u n d ◦ In f r a s t r u c t u r e F u n d ◦ Ut i l i t y F u n d s ◦ Te c h n o l o g y C a p i t a l F u n d ◦ EB H C C a p i t a l F u n d s ◦ BC L i q u o r C a p i t a l P l a n 24 In t r o d u c t i o n  Ca p i t a l I m p r o v e m e n t P l a n ◦ No n - b i n d i n g d o c u m e n t o f f u t u r e i n t e n t o f C i t y ca p i t a l p r o j e c t s o v e r t h e n e x t 1 5 y e a r s ◦ By d e s i g n , t h e C I P i s f l u i d b e c a u s e f u t u r e pr i o r i t i e s c a n c h a n g e d r a m a t i c a l l y b a s e d o n cu r r e n t c i r c u m s t a n c e s ◦ De v e l o p e d b y p r i o r i t i z i n g a l i s t o f c a p i t a l p r o j e c t s ba s e d o n e s t i m a t e d y e a r n e e d e d a n d b a s e d o n an t i c i p a t e d f u n d i n g o p p o r t u n i t i e s ◦ 20 1 9 p r o j e c t s w i l l b e i n c o r p o r a t e d i n t h e re q u e s t e d 2 0 1 9 b u d g e t 25 In t r o d u c t i o n  Ca p i t a l I m p r o v e m e n t s P l a n ( C I P ) ◦ Pu b l i c U t i l i t i e s ◦ St r e e t I m p r o v e m e n t s ◦ Pa r k & T r a i l I m p r o v e m e n t s ◦ Ca p i t a l M a i n t e n a n c e B u i l d i n g P r o g r a m ( C M B P )  Va r i o u s F u n d i n g S o u r c e s ◦ Ut i l i t y f e e s , s p e c i a l a s s e s s m e n t s , f r a n c h i s e f e e s , st a t e a i d , l i q u o r o p e r a t i o n s , e t c .  Te c h n o l o g y , B C L i q u o r & E B H C C a p i t a l P l a n s 26 20 1 9 – 2 0 2 0 C a p i t a l I m p r o v e m e n t P l a n 27 Br o o k l y n B l v d . P r o j e c t U p d a t e  Up d a t e d P r o j e c t C o s t E s t i m a t e d o f $ 1 5 , 0 8 5 , 0 0 0 (p r e v i o u s l y $ 1 4 , 6 0 0 , 0 0 0 ) ◦ Fu l l a m o u n t b e i n g s h o w n i n 2 0 1 9 i n C I P  Up d a t e d C i t y E s t i m a t e d C o s t s o f $ 4 , 6 1 3 , 0 0 0 (p r e v i o u s l y $ 3 , 3 4 9 , 0 0 0 ) ◦ St r e e t s c a p i n g c o s t s n o t e l i g i b l e f o r F e d e r a l / C o u n t y f u n d i n g (a p p r o v e d i n o r i g i n a l f u n d i n g s u b m i t t a l ) ◦ Su p p l e m e n t a l f u n d i n g f r o m T I F # 2 $ 5 2 5 k , U t i l i t i e s $ 8 6 4 k  Cu r r e n t S p e n d i n g ◦ 20 1 7 - $ 1 , 1 1 2 , 8 9 0 E n g i n e e r i n g / E a s e m e n t s ◦ YT D 2 0 1 8 - $ 8 9 5 , 8 2 6 E n g i n e e r i n g / E a s e m e n t s  Ju l y 1 2 B i d O p e n i n g ( p r o j e c t c o s t s t o b e r e v i s e d )  Pr o j e c t t i m e l i n e J u l y 2 0 1 8 t h r o u g h S u m m e r 2 0 1 9 28 CI P – R e v i s i o n s f o r 2 0 1 9 Pr o j e c t 20 1 7 P l a n fo r 2 0 1 9 20 1 8 P l a n fo r 2 0 1 9 Notes Be l l v u e A r e a M i l l a n d O v e r l a y $ - $ 1 , 6 9 0 , 0 0 0 C a r r y o v e r f r o m 2 0 1 8 *B r o o k l y n B o u l e v a r d C o r r i d o r P r o j e c t ( 4 9 th Av e . t o B a s s L k . R d ) - 1 5 , 0 8 5 , 0 0 0 C a r r y o v e r f r o m 2 0 1 8 51 st Av e n u e I m p r o v e m e n t s ( a t B r o o k l y n B l v d ) - 6 0 0 , 0 0 0 C a r r y o v e r f r o m 2 0 1 8 Li f t S t a t i o n N o . 2 R e h a b i l i t a t i o n a n d M i s s . Ri v e r S e w e r L i n i n g 3 5 5 , 0 0 0 8 5 0 , 0 0 0 C a r r y o v e r f r o m 2 0 1 8 , added sewer lining Br i d g e R e h a b ( 4 b r i d g e s ) - 2 2 6 , 0 0 0 C a r r y o v e r f r o m 2 0 1 8 In t e r s t a t e A r e a I m p r o v e m e n t s 11 , 4 2 0 , 0 0 0 1 0 , 9 9 0 , 0 0 0 So u t h e a s t A r e a M i l l a n d O v e r l a y 2, 7 6 0 , 0 0 0 2 , 9 7 0 , 0 0 0 Pa r k P l a y g r o u n d E q u i p m e n t R e p l a c e m e n t 45 3 , 0 0 0 4 7 6 , 0 0 0 St o r m W a t e r P o n d s R e h a b (2 6 - 0 0 4 , 2 6 - 0 0 6 , 3 5 - 0 0 3 , 3 5 - 0 0 4 Re h a b ) 15 5 , 0 0 0 1 4 9 , 0 0 0 G r o u p e d p o n d s i n similar areas Ca p i t a l M a i n t e n a n c e B u i l d i n g P r o g r a m – P u b l i c W o r k s R o o f Re p l a c e m e n t 60 0 , 0 0 0 5 8 3 , 0 0 0 Ca p i t a l M a i n t e n a n c e B u i l d i n g P r og r a m – C i t y H a l l G e n e r a t o r Re p l a c e m e n t - 1 1 4 , 0 0 0 * A d d e d Hu m b o l d t A v e ( C R 5 7 ) R e c o n s t r u c t i o n ( 5 3 rd to 5 7 th ) 2, 0 9 0 , 0 0 0 - M o v e d t o 2 0 2 0 Li f t S t a t i o n N o . 9 F o r c e M a i n R e p l a c e m e n t 28 7 , 0 0 0 - M o v e d t o 2 0 2 1 *P r o j e c t b i d s r e c e i v e d f o r B r o o k l y n B l v d . o n J u l y 1 2 a n d w e r e n o t r e f l e c t e d . P r o j e c t i s s h o w n a t f u l l c o s t , ho w e v e r a p o r t i o n o f t h e c o s t w i l l b e p a i d i n 2 0 1 7 / 2 0 1 8 . 29 20 1 9 – 2 0 3 3 C a p i t a l I m p r o v e m e n t s P l a n C h a n g e s Ye a r V e r s i o n 2 0 1 7 . 0 V e r s i o n 2 0 1 8 . 0 C h a n g e 20 1 9 1 8 , 6 1 6 , 0 0 0 3 4 , 5 8 4 , 0 0 0 1 5 , 9 6 8 , 0 0 0 20 2 0 1 7 , 2 1 4 , 0 0 0 1 8 , 9 5 8 , 0 0 0 1 , 7 4 4 , 0 0 0 20 2 1 5 1 , 4 1 2 , 0 0 0 5 6 , 2 2 4 , 0 0 0 4 , 8 1 2 , 0 0 0 20 2 2 9 , 5 1 5 , 0 0 0 1 0 , 3 3 9 , 0 0 0 8 2 4 , 0 0 0 20 2 3 5 , 9 1 0 , 0 0 0 6 , 8 5 2 , 0 0 0 9 4 2 , 0 0 0 20 2 4 1 2 , 5 3 7 , 0 0 0 1 2 , 1 7 6 , 0 0 0 (3 6 1 , 0 0 0 ) 20 2 5 1 2 , 5 0 7 , 0 0 0 1 2 , 1 2 5 , 0 0 0 (3 8 2 , 0 0 0 ) 20 2 6 5 , 3 1 2 , 0 0 0 6 , 0 6 3 , 0 0 0 7 5 1 , 0 0 0 20 2 7 4 , 0 2 3 , 0 0 0 4 , 2 1 6 , 0 0 0 1 9 0 , 0 0 0 20 2 8 4 , 8 2 2 , 0 0 0 4 , 6 8 5 , 0 0 0 (1 3 7 , 0 0 0 ) 20 2 9 7 , 5 4 0 , 0 0 0 7 , 9 5 2 , 0 0 0 4 1 2 , 0 0 0 20 3 0 9 , 4 8 1 , 0 0 0 9 , 5 0 7 , 0 0 0 2 6 , 0 0 0 20 3 1 6 , 0 4 6 , 0 0 0 6 , 1 4 5 , 0 0 0 9 9 , 0 0 0 20 3 2 4 , 2 5 4 , 0 0 0 4 , 6 5 6 , 0 0 0 4 0 2 , 0 0 0 20 3 3 - 3 , 7 1 9 , 0 0 0 30 20 1 9 C a p i t a l I m p r o v e m e n t s F u n d De s c r i p t i o n Cost Br o o k l y n B o u l e v a r d C o r r i d o r P r o j e c t ( 4 9 th Av e . t o B a s s L k R d ) $14,221,000^ Pa r k P l a y g r o u n d E q u i p m e n t r e p l a c e m e n t 476,000 Co n n e c t i o n s a t S h i n g l e C r e e k – P h a s e 2 287,000 Ca p i t a l B u i l d i n g M a i n t e n a n c e P l a n – P u b l i c W o r k s R o o f R e p l a c e m e n t 583,000 Ca p i t a l B u i l d i n g M a i n t e n a n c e P l a n – C i v i c C e n t e r G e n e r a t o r R e p l a c e m e n t 1 1 4 , 0 0 0 20 1 9 T o t a l C o s t $ 1 5 , 6 8 1 , 0 0 0 ^ F u n d e d , i n p a r t , b y F e d e r a l G r a n t ($ 7 , 1 0 1 , 0 0 0 ) a n d H e n n e p i n C o u n t y ( $ 2 , 9 8 3 , 0 0 0 ) , Mi n n e a p o l i s ( $ 9 8 , 0 0 0 ) , a n d T h r e e R i v e r s P a r k D i s t r i c t ( $ 1 0 , 0 0 0 ) , X c e l U t i l i t y S u r c h a r g e ($ 2 8 0 , 0 0 0 ) , T I F D i s t r i c t # 2 F u n d i n g ( $ 5 2 5 , 0 0 0 ) , C a p i ta l I m p r o v e m e n t s P o r t i o n e s t i m a t e d t o b e $4 , 6 1 3 , 0 0 0 . 31 Ca p i t a l I m p r o v e m e n t s F u n d i n g P o l i c y  Ge n e r a l F u n d t r a n s f e r o f a u d i t e d y e a r - e n d u n a s s i g n e d fu n d b a l a n c e a b o v e 5 2 % o f n e x t y e a r ’ s G e n e r a l F u n d op e r a t i n g b u d g e t  Li q u o r o p e r a t i o n s t r a n s f e r i s a n e s t i m a t e o f a u d i t e d ye a r - e n d L i q u o r F u n d u n r e s t r i c t e d c a s h b a l a n c e t h a t ex c e e d s 3 . 5 m o n t h s o f n e x t y e a r ’ s o p e r a t i n g b u d g e t a n d on e y e a r o f b u d g e t e d c a p i t a l i m p r o v e m e n t n e e d s  Lo c a l G o v e r n m e n t A i d ( L G A ) r e c e i v e d i n t h e a m o u n t o f $6 5 0 , 0 0 0 o r h a l f o f t h e a m o u n t r e c e i v e d b y t h e C i t y (w h i c h e v e r i s g r e a t e r )  Ot h e r o u t s i d e s o u r c e s o f r e v e n u e s ( i . e . g r a n t f u n d s ) 32 Ca p i t a l I m p r o v e m e n t s F u n d – C a s h F l o w A n a l y s i s A c t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 Re v e n u e s In t e r g o v e r n m e n t a l ( L G A ) 7 7 5 , 8 8 7 $ 8 8 4 , 4 5 4 $ 8 9 1 , 8 2 5 $ 8 9 1 , 8 2 5 $ 8 9 1 , 8 2 5 $ 8 9 1 , 8 2 5 $ 8 9 1 , 8 2 5 $ In v e s t m e n t E a r n i n g s 3 2 , 4 9 4 4 0 , 9 4 6 4 0 , 9 4 6 - - - - Mi s c e l l a n e o u s - 3 9 6 , 2 0 7 - - - - - TH 2 5 2 E x t e r n a l F u n d i n g E s t . - - - - 2 9 , 5 0 0 , 0 0 0 - Ex t e r n a l F u n d i n g S o u r c e s 2 2 9 , 5 8 5 1 0 , 1 9 2 , 0 0 0 1 9 1 , 0 0 0 - 1 1 , 4 6 6 , 0 0 0 - - Bo n d P r o c e e d s - - - - 7 , 6 3 7 , 0 0 0 - - De b t S e r v i c e T a x L e v y - - - - - 8 9 5 , 2 8 9 8 9 5 , 2 8 9 Tr a n s f e r s ( G e n e r a l ) 7 1 5 , 5 4 4 1 4 9 , 6 3 0 2 0 0 , 0 0 0 2 0 0 , 0 0 0 2 0 0 , 0 0 0 2 0 0 , 0 0 0 2 0 0 , 0 0 0 Tr a n s f e r s ( L i q u o r ) 11 2 , 8 9 8 18 5 , 7 0 7 15 0 , 0 0 0 15 0 , 0 0 0 15 0 , 0 0 0 15 0 , 0 0 0 150,000 To t a l 1, 8 6 6 , 4 0 8 11 , 8 4 8 , 9 4 4 1, 4 7 3 , 7 7 1 1, 2 4 1 , 8 2 5 49 , 8 4 4 , 8 2 5 2, 1 3 7 , 1 1 4 2,137,114 Ex p e n d i t u r e s Ot h e r S e r v i c e s & C h a r g e s 37 , 8 8 7 - - - - - - Ca p i t a l O u t l a y 3, 9 7 7 , 6 0 7 14 , 5 1 6 , 1 3 2 1, 4 6 0 , 0 0 0 1, 6 1 8 , 0 0 0 49 , 2 4 1 , 0 0 0 1, 6 7 8 , 0 0 0 474,000 De b t S e r v i c e P r o j e c t e d - - - - - 8 9 5 , 2 8 9 895,289 Tr a n s f e r s - - - - - - - To t a l 4, 0 1 5 , 4 9 4 14 , 5 1 6 , 1 3 2 1, 4 6 0 , 0 0 0 1, 6 1 8 , 0 0 0 49 , 2 4 1 , 0 0 0 2, 5 7 3 , 2 8 9 1,369,289 Ca s h B a l a n c e - B e g i n n i n g 4, 4 6 7 , 2 5 2 2, 4 1 9 , 6 6 8 (2 4 7 , 5 2 0 ) (2 3 3 , 7 4 9 ) (6 0 9 , 9 2 4 ) (6 , 0 9 9 ) (442,274) Ch a n g e s i n A c c r u a l s 10 1 , 5 0 2 Re v e n u e s 1, 8 6 6 , 4 0 8 11 , 8 4 8 , 9 4 4 1, 4 7 3 , 7 7 1 1, 2 4 1 , 8 2 5 49 , 8 4 4 , 8 2 5 2, 1 3 7 , 1 1 4 2,137,114 Ex p e n d i t u r e s (4 , 0 1 5 , 4 9 4 ) (1 4 , 5 1 6 , 1 3 2 ) (1 , 4 6 0 , 0 0 0 ) (1 , 6 1 8 , 0 0 0 ) (4 9 , 2 4 1 , 0 0 0 ) (2 , 5 7 3 , 2 8 9 ) (1,369,289) Ca s h B a l a n c e - E n d i n g 2, 4 1 9 , 6 6 8 $ (2 4 7 , 5 2 0 ) $ (2 3 3 , 7 4 9 ) $ (6 0 9 , 9 2 4 ) $ (6 , 0 9 9 ) $ (4 4 2 , 2 7 4 ) $ 325,551 $ 33 20 1 9 M u n i c i p a l S t a t e A i d ( M S A ) F u n d De s c r i p t i o n Co s t Be l l v u e A r e a M i l l a n d O v e r l a y $1 6 0 , 0 0 0 So u t h e a s t A r e a M i l l a n d O v e r l a y 90,000 51 st Av e n u e I m p r o v e m e n t s ( a t B r o o k l y n B l v d . ) 12 0 , 0 0 0 20 1 9 T o t a l C o s t $ 3 7 0 , 0 0 0 34 MS A F u n d – C a s h F l o w A n a l y s i s Ac t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 Re v e n u e s In t e r g o v e r n m e n t a l ( M a i n t e n a n c e ) 1 6 0 , 0 0 0 $ 16 0 , 0 0 0 $ 16 0 , 0 0 0 $ 17 0 , 0 0 0 $ 17 5 , 0 0 0 $ 180,000 $ 185,000 $ In t e r g o v e r n m e n t a l ( C o n s t r u c t i o n ) 7 6 6 , 3 0 1 93 3 , 2 0 4 - - 5 0 0 , 0 0 0 1,043,594 1,038,594 In v e s t m e n t E a r n i n g s - 4 , 1 9 8 4, 1 9 8 - - - - To t a l 92 6 , 3 0 1 1, 0 9 7 , 4 0 2 16 4 , 1 9 8 17 0 , 0 0 0 67 5 , 0 0 0 1,223,594 1,223,594 Ex p e n d i t u r e s S u p p l i e s 41 , 1 0 6 64 , 0 0 0 64 , 0 0 0 68 , 0 0 0 70 , 0 0 0 72,000 74,000 Ot h e r S e r v i c e s & C h a r g e s 56 , 1 5 1 96 , 0 0 0 96 , 0 0 0 10 2 , 0 0 0 10 5 , 0 0 0 108,000 111,000 Ca p i t a l O u t l a y 1, 3 1 0 , 2 5 2 87 5 , 0 0 0 37 0 , 0 0 0 1, 8 6 0 , 0 0 0 1, 2 6 2 , 0 0 0 150,000 2,380,000 To t a l 1, 4 0 7 , 5 0 9 1, 0 3 5 , 0 0 0 53 0 , 0 0 0 2, 0 3 0 , 0 0 0 1, 4 3 7 , 0 0 0 330,000 2,565,000 Ca s h B a l a n c e - B e g i n n i n g (1 5 , 6 5 9 ) 2, 4 1 9 , 6 6 8 2, 4 8 2 , 0 7 0 2, 1 1 6 , 2 6 8 25 6 , 2 6 8 (505,732) 387,862 Ch a n g e s i n A c c r u a l s 2, 9 1 6 , 5 3 5 Re v e n u e s 92 6 , 3 0 1 1, 0 9 7 , 4 0 2 16 4 , 1 9 8 17 0 , 0 0 0 67 5 , 0 0 0 1,223,594 1,223,594 E x p e n d i t u r e s (1 , 4 0 7 , 5 0 9 ) (1 , 0 3 5 , 0 0 0 ) (5 3 0 , 0 0 0 ) (2 , 0 3 0 , 0 0 0 ) (1 , 4 3 7 , 0 0 0 ) (330,000) (2,565,000) Ca s h B a l a n c e - E n d i n g 2, 4 1 9 , 6 6 8 $ 2 , 4 8 2 , 0 7 0 $ 2 , 1 1 6 , 2 6 8 $ 2 5 6 , 2 6 8 $ (50 5 , 7 3 2 ) $ 387,862 $ (953,544 )$ 35 20 1 9 S t r e e t R e c o n s t r u c t i o n F u n d De s c r i p t i o n Co s t In t e r s t a t e A r e a I m p r o v e m e n t s $3 , 4 4 0 , 0 0 0 Be l l v u e A r e a M i l l a n d O v e r l a y 79 0 , 0 0 0 So u t h e a s t A r e a M i l l a n d O v e r l a y 73 0 , 0 0 0 51 st Av e n u e I m p r o v e m e n t s ( a s B r o o k l y n B l v d ) 24 8 , 2 3 5 Br i d g e R e h a b ( 4 b r i d g e s ) 22 6 , 0 0 0 20 1 9 T o t a l C o s t $ 5 , 4 3 4 , 2 3 5 36 St r e e t R e c o n s t r u c t i o n F u n d – C a s h F l o w A n a l y s i s A c t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 Re v e n u e s Fr a n c h i s e F e e s 7 0 2 , 6 0 0 $ 6 8 9 , 0 0 0 $ 6 8 9 , 0 0 0 $ 7 1 0 , 0 0 0 $ 7 1 0 , 0 0 0 $ 7 1 0 , 0 0 0 $ 7 3 1 , 0 0 0 $ In v e s t m e n t E a r n i n g s 4 7 , 7 0 0 4 1 , 9 9 1 4 1 , 9 9 1 2 1 , 1 4 3 1 2 , 3 5 4 4 , 8 3 8 1 3 , 5 8 6 Fu t u r e B o n d s - L e v i e s - - - 2 6 9 , 6 3 0 5 3 9 , 2 6 0 5 3 9 , 2 6 0 7 6 3 , 1 7 1 Bo n d P r o c e e d s 2 , 4 8 5 , 3 6 5 2 , 1 3 7 , 6 7 9 2 , 3 0 0 , 0 0 0 2 , 3 0 0 , 0 0 0 - 1 , 9 1 0 , 0 0 0 - To t a l 3 , 2 3 5 , 6 6 5 2 , 8 6 8 , 6 7 0 3 , 0 3 0 , 9 9 1 3 , 3 0 0 , 7 7 3 1 , 2 6 1 , 6 1 5 3 , 1 6 4 , 0 9 8 1 , 5 0 7 , 7 5 7 Ex p e n d i t u r e s Ca p i t a l O u t l a y 2 , 1 6 5 , 3 7 0 3 , 1 7 7 , 5 9 2 5 , 4 3 4 , 2 3 5 3 , 9 1 0 , 0 0 0 1 , 4 7 4 , 0 0 0 1 , 7 5 0 , 0 0 0 6 9 0 , 0 0 0 De b t S e r v i c e ( P r o j e c t e d ) - - - 2 6 9 , 6 3 0 5 3 9 , 2 6 0 5 3 9 , 2 6 0 7 6 3 , 1 7 1 Bo n d I s s u e C o s t s 2 4 , 5 6 2 3 0 , 0 0 0 3 0 , 0 0 0 - - - - To t a l 2 , 1 8 9 , 9 3 2 3 , 2 0 7 , 5 9 2 5 , 4 6 4 , 2 3 5 4 , 1 7 9 , 6 3 0 2 , 0 1 3 , 2 6 0 2 , 2 8 9 , 2 6 0 1 , 4 5 3 , 1 7 1 Ca s h B a l a n c e - B e g in n i n g 3, 8 5 3 , 9 7 7 4 , 8 8 6 , 4 7 2 4 , 5 4 7 , 5 5 0 2 , 1 1 4 , 3 0 6 1 , 2 3 5 , 4 4 9 4 8 3 , 8 0 3 1 , 3 5 8 , 6 4 1 Ch a n g e s i n A c c r u a l s ( 1 3 , 2 3 8 ) - - - - - - Re v e n u e s 3 , 2 3 5 , 6 6 5 2 , 8 6 8 , 6 7 0 3 , 0 3 0 , 9 9 1 3 , 3 0 0 , 7 7 3 1 , 2 6 1 , 6 1 5 3 , 1 6 4 , 0 9 8 1 , 5 0 7 , 7 5 7 E x p e n d i t u r e s ( 2 , 1 8 9 , 9 3 2 ) ( 3 , 2 0 7 , 5 9 2 ) ( 5 , 4 6 4 , 2 3 5 ) ( 4 , 1 7 9 , 6 3 0 ) ( 2 , 0 1 3 , 2 6 0 ) ( 2 , 2 8 9 , 2 6 0 ) ( 1 , 4 5 3 , 1 7 1 ) Ca s h B a l a n c e - E n d i n g 4 , 8 8 6 , 4 7 2 $ 4 , 5 4 7 , 5 5 0 $ 2 , 1 1 4 , 3 0 6 $ 1 , 2 3 5 , 4 4 9 $ 4 8 3 , 8 0 3 $ 1 , 3 5 8 , 6 4 1 $ 1 , 4 1 3 , 2 2 8 $ 37 20 1 9 S p e c i a l A s s e s s m e n t s F u n d De s c r i p t i o n Co s t In t e r s t a t e A r e a I m p r o v e m e n t s $1 , 4 4 0 , 0 0 0 Be l l v u e A r e a M i l l a n d O v e r l a y 25 0 , 0 0 0 So u t h e a s t A r e a M i l l a n d O v e r l a y 1, 3 7 0 , 0 0 0 51 st Av e n u e I m p r o v e m e n t s ( a t B r o o k l y n B l v d . ) 28 , 2 9 5 20 1 9 T o t a l C o s t $ 3 , 0 8 8 , 2 9 5 38 Sp e c i a l A s s e s s m e n t s F u n d – C a s h F l o w A n a l y s i s A c t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 Re v e n u e s Sp e c i a l A s s e s s m e n t s 6 1 6 , 8 9 3 $ - $ - $ - $ - $ - $ -$ Sp e c i a l A s s e s s m e n t s ( P r o j e c t e d E x i s t i n g ) - 5 3 1 , 5 3 6 61 0 , 0 6 3 56 2 , 1 0 4 46 1 , 5 5 8 442,267 422,143 Sp e c i a l A s s e s s m e n t s ( P r o j e c t e d P r e p a i d s ) - 4 7 2 , 0 2 8 77 2 , 0 7 4 67 2 , 5 0 0 13 7 , 5 0 0 405,000 122,500 Sp e c i a l A s s e s s m e n t s ( P r o j e c t e d N e w ) - - 3 6 , 9 6 0 36 9 , 8 0 4 60 1 , 7 5 8 643,032 793,926 Ch a r g e s f o r S e r v i c e s 1, 2 0 0 - - - - - - In v e s t m e n t E a r n i n g s 52 5 - - - - - - Mi s c e l l a n e o u s 3, 7 3 9 - - - - - - B o n d P r o c e e d s 1, 4 3 6 , 1 3 7 2, 0 2 9 , 3 3 7 2, 8 1 0 , 0 0 0 - - - - Tr a n s f e r s I n 16 1 , 5 7 5 - - - - - - To t a l 2, 2 2 0 , 0 6 9 3, 0 3 2 , 9 0 1 4, 2 2 9 , 0 9 7 1, 6 0 4 , 4 0 8 1, 2 0 0 , 8 1 6 1,490,299 1,338,569 Ex p e n d i t u r e s Ot h e r S e r v i c e s & C h a r g e s 33 , 7 6 2 - - - - - - Ca p i t a l O u t l a y 1, 5 5 2 , 0 8 4 2, 2 7 3 , 5 4 9 3, 0 8 8 , 2 9 5 2, 6 9 0 , 0 0 0 55 0 , 0 0 0 1,620,000 490,000 De b t S e r v i c e ( P r o j e c t e d ) - - 2 4 7 , 3 5 6 57 6 , 7 7 4 57 6 , 7 7 4 576,774 576,774 B o n d I s s u a n c e C o s t s 16 , 4 6 7 - - - - - - To t a l 1, 6 0 2 , 3 1 3 2, 2 7 3 , 5 4 9 3, 3 3 5 , 6 5 1 3, 2 6 6 , 7 7 4 1, 1 2 6 , 7 7 4 2,196,774 1,066,774 Ca s h B a l a n c e - B e g i n n i n g 1, 2 5 8 , 8 1 7 1, 0 0 8 , 8 1 7 1, 7 6 8 , 1 6 9 2, 6 6 1 , 6 1 5 99 9 , 2 4 9 1,073,291 366,817 Ch a n g e s i n A c c r u a l s (8 6 7 , 7 5 6 ) - - - - - - Re v e n u e s 2, 2 2 0 , 0 6 9 3, 0 3 2 , 9 0 1 4, 2 2 9 , 0 9 7 1, 6 0 4 , 4 0 8 1, 2 0 0 , 8 1 6 1,490,299 1,338,569 Ex p e n d i t u r e s (1 , 6 0 2 , 3 1 3 ) (2 , 2 7 3 , 5 4 9 ) (3 , 3 3 5 , 6 5 1 ) (3 , 2 6 6 , 7 7 4 ) (1 , 1 2 6 , 7 7 4 ) (2 , 1 9 6 , 7 7 4 ) (1,066,774) Ca s h B a l a n c e - E n d i n g 1, 0 0 8 , 8 1 7 $ 1, 7 6 8 , 1 6 9 $ 2, 6 6 1 , 6 1 5 $ 99 9 , 2 4 9 $ 1, 0 7 3 , 2 9 1 $ 366,817 $ 638,611 $ 39 20 1 9 U t i l i t y P r o j e c t s ( $ 1 0 , 0 1 0 , 4 7 0 ) De s c r i p t i o n Co s t In t e r s t a t e A r e a I m p r o v e m e n t s St o r m D r a i n a g e U t i l i t y Sa n i t a r y S e w e r U t i l i t y Wa t e r U t i l i t y St r e e t L i g h t $1,670,000 1,750,000 2,600,000 90,000 Br o o k l y n B o u l e v a r d C o r r i d o r P r o j e c t ( 4 9 th Av e . t o B a s s L a k e ) St o r m D r a i n a g e U t i l i t y Sa n i t a r y S e w e r U t i l i t y Wa t e r U t i l i t y St r e e t L i g h t U t i l i t y $482,000 75,000 167,000 140,000 Sa n i t a r y S e w e r - L i f t S t a t i o n N o . 2 R e ha b a n d M i s s . R i v e r S e w e r L i n i n g $ 8 5 0 , 0 0 0 Wa t e r - W e l l N o . 3 a n d N o . 3 R e h a b $ 1 4 0 , 0 0 0 St o r m D r a i n a g e - S t o r m W a t e r P o n d s (2 6 - 0 0 4 , 2 6 - 0 0 6 , 3 5 - 0 0 3 , & 3 5 - 0 0 4 R e h a b ) $149,000 So u t h e a s t A r e a M i l l a n d O v e r l a y St o r m D r a i n a g e U t i l i t y Sa n i t a r y S e w e r Wa t e r U t i l i t y $590,000 120,000 70,000 Be l l v u e A r e a M i l l a n d O v e r l a y St o r m D r a i n a g e U t i l i t y Sa n i t a r y S e w e r Wa t e r U t i l i t y $390,000 60,000 40,000 51 st Av e n u e I m p r o v e m e n t s ( a t B r o o k l y n B o u l e v a r d ) St o r m D r a i n a g e U t i l i t y Sa n i t a r y S e w e r Wa t e r U t i l i t y $73,470 60,000 70,000 40 CI P I m p a c t o n U t i l i t y F u n d s  Ca s h f l o w s s h o w t h e i m p a c t o f t h e C I P Pl a n o n U t i l i t y F u n d s  De t a i l s w i l l b e f u r t h e r c o v e r e d i n t h e re v i e w o f U t i l i t y F u n d s b u d g e t s a n d r a t e s . 41 Wa t e r F u n d – C a s h F l o w A n a l y s i s Av e r a g e R e s i d e n t i a l F e e (1 8 , 0 0 0 G a l l o n s / P e r Q t r . ) 58 . 5 6 $ 5 8 . 5 6 $ 6 2 . 1 4 $ 6 7 . 6 8 $ 7 3 . 7 0 $ 8 0 . 4 0 $ 8 7 . 6 1 $ Pe r Q u a r t e r C h a n g e 9. 8 2 $ - $ 3. 5 8 $ 5. 5 4 $ 6. 0 2 $ 6. 7 0 $ 7.21 $ Ba s e C h a r g e 14 . 6 4 $ 14 . 6 4 $ 15 . 5 2 $ 16 . 9 2 $ 18 . 4 4 $ 20 . 1 0 $ 21.91 $ Co n s u m p t i o n C h a r g e ( 0 - 3 0 ) 2. 4 4 $ 2. 4 4 $ 2. 5 9 $ 2. 8 2 $ 3. 0 7 $ 3. 3 5 $ 3.65 $ Co n s u m p t i o n C h a r g e ( 3 0 - 6 0 ) 3. 0 4 $ 3. 0 4 $ 3. 2 2 $ 3. 5 1 $ 3. 8 3 $ 4. 1 7 $ 4.55 $ Co n s u m p t i o n C h a r g e ( 6 0 + ) 4. 5 4 $ 4. 5 4 $ 4. 8 1 $ 5. 2 4 $ 5. 7 1 $ 6. 2 2 $ 6.78 $ Ac t u a l B u d g e t e d B u d g e t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 Re v e n u e s Op e r a t i n g 3, 5 4 3 , 3 2 3 $ 3, 5 4 3 , 3 2 3 $ 3, 7 5 5 , 9 2 2 $ 4, 0 9 3 , 9 5 5 $ 4, 4 6 2 , 4 1 1 $ 4, 8 6 4 , 0 2 8 $ 5,301,791 $ In v e s t m e n t E a r n i n g s 28 , 1 5 4 36 , 5 5 1 26 , 8 5 9 24 , 6 2 0 18 , 2 6 9 8, 9 8 7 7,904 No n o p e r a t i n g 42 , 2 7 4 - - - - - - Bo n d P r o c e e d s ( G O ) 3, 2 3 0 , 0 0 0 3, 1 9 1 , 4 5 1 2, 6 0 0 , 0 0 0 3, 2 7 0 , 0 0 0 - 2 , 4 5 0 , 0 0 0 - To t a l 6, 8 4 3 , 7 5 1 6, 7 7 1 , 3 2 5 6, 3 8 2 , 7 8 1 7, 3 8 8 , 5 7 5 4, 4 8 0 , 6 8 1 7, 3 2 3 , 0 1 5 5,309,695 Ex p e n d i t u r e s Pe r s o n a l S e r v c i e s 55 1 , 6 8 0 57 7 , 0 5 3 59 4 , 0 2 3 61 1 , 8 4 4 63 0 , 1 9 9 64 9 , 1 0 5 668,578 S u p p l i e s 20 7 , 8 6 9 28 2 , 6 6 0 26 5 , 7 1 0 27 1 , 0 2 4 27 6 , 4 4 5 28 1 , 9 7 4 287,613 Ot h e r S e r v i c e s & C h a r g e s 5 0 6 , 9 5 2 46 9 , 8 3 6 45 2 , 2 7 5 46 1 , 3 2 1 47 0 , 5 4 7 47 9 , 9 5 8 489,557 In s u r a n c e 35 , 1 7 4 37 , 2 8 4 39 , 5 2 2 40 , 3 1 2 41 , 1 1 9 41 , 9 4 1 42,780 Ut i l i t i e s 22 2 , 0 5 6 23 6 , 9 0 0 23 6 , 9 0 0 24 1 , 6 3 8 24 6 , 4 7 1 25 1 , 4 0 0 256,428 De p r e c i a t i o n 1, 6 3 5 , 2 5 5 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1,935,476 Ca p i t a l O u t l a y ( C I P ) 2, 7 6 6 , 0 0 9 4, 6 1 2 , 2 5 3 3, 0 8 7 , 0 0 0 3, 9 4 4 , 0 0 0 91 3 , 0 0 0 2, 8 9 0 , 0 0 0 800,000 De b t S e r v i c e ( E x i s t i n g ) 16 6 , 9 1 8 38 3 , 9 9 7 79 0 , 3 9 4 1, 0 0 8 , 5 8 4 1, 0 0 2 , 7 0 9 1, 0 0 8 , 3 5 9 1,005,459 De b t S e r v i c e ( P F A ) 1, 1 4 0 , 1 5 3 1, 1 4 0 , 4 9 0 1, 1 4 0 , 8 6 0 1, 1 4 0 , 1 3 0 1, 1 4 0 , 3 1 0 1, 1 4 0 , 3 9 0 1,140,370 De b t S e r v i c e ( P r o j e c t e d ) - - - 3 0 4 , 7 9 9 68 8 , 1 4 3 68 8 , 1 4 3 975,358 To t a l 7, 2 3 2 , 0 6 6 9, 6 7 5 , 9 4 9 8, 5 4 2 , 1 6 0 9, 9 5 9 , 1 2 9 7, 3 4 4 , 4 1 9 9, 3 6 6 , 7 4 6 7,601,619 Ca s h B a l a n c e - B e g i n n i n g 1, 7 7 9 , 8 5 8 3, 6 5 5 , 0 5 3 2, 6 8 5 , 9 0 4 2, 4 6 2 , 0 0 1 1, 8 2 6 , 9 2 4 89 8 , 6 6 2 790,407 Ch a n g e s i n A c c r u a l s 62 8 , 2 5 5 - - - - - - Re v e n u e s 6, 8 4 3 , 7 5 1 6, 7 7 1 , 3 2 5 6, 3 8 2 , 7 8 1 7, 3 8 8 , 5 7 5 4, 4 8 0 , 6 8 1 7, 3 2 3 , 0 1 5 5,309,695 E x p e n d i t u r e s (7 , 2 3 2 , 0 6 6 ) (9 , 6 7 5 , 9 4 9 ) (8 , 5 4 2 , 1 6 0 ) (9 , 9 5 9 , 1 2 9 ) (7 , 3 4 4 , 4 1 9 ) (9 , 3 6 6 , 7 4 6 ) (7,601,619) No n c a s h - D e p r e c i a t i o n 1 , 6 3 5 , 2 5 5 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1, 9 3 5 , 4 7 6 1,935,476 Ca s h B a l a n c e - E n d i n g 3 , 6 5 5 , 0 5 3 $ 2, 6 8 5 , 9 0 4 $ 2, 4 6 2 , 0 0 1 $ 1, 8 2 6 , 9 2 4 $ 89 8 , 6 6 2 $ 79 0 , 4 0 7 $ 433,959 $ 42 Wa t e r F u n d – C a s h F l o w A n a l y s i s 43 Sa n i t a r y S e w e r F u n d – C a s h F l o w A n a l y s i s Re s i d e n t i a l - F l a t F e e / P e r Q t r . 82 . 4 2 $ 8 2 . 4 2 $ 8 4 . 8 9 $ 8 9 . 1 4 $ 9 3 . 5 9 $ 9 8 . 2 7 $ 1 0 3 . 1 9 $ Pe r Q u a r t e r C h a n g e 2. 4 0 $ - $ 2. 4 7 $ 4. 2 4 $ 4. 4 6 $ 4.68 $ 4.91 $ A c t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 Re v e n u e s Op e r a t i n g 4, 2 8 7 , 6 7 4 $ 4, 2 8 7 , 6 7 4 $ 4, 4 1 6 , 3 0 4 $ 4, 6 3 7 , 1 1 9 $ 4, 8 6 8 , 9 7 5 $ 5, 1 1 2 , 4 2 4 $ 5,368,045 $ In v e s t m e n t E a r n i n g s 46 , 9 8 7 48 , 6 6 2 29 , 5 2 8 23 , 4 3 1 21 , 7 9 1 14,261 3,980 No n o p e r a t i n g 98 1 - - - - - - Bo n d P r o c e e d s 1, 3 9 5 , 0 0 0 - 1 , 7 5 0 , 0 0 0 1, 7 6 0 , 0 0 0 - - - To t a l 5, 7 3 0 , 6 4 2 4, 3 3 6 , 3 3 6 6, 1 9 5 , 8 3 2 6, 4 2 0 , 5 5 1 4, 8 9 0 , 7 6 6 5, 1 2 6 , 6 8 6 5,372,025 Ex p e n d i t u r e s P e r s o n a l S e r v c i e s 19 5 , 8 6 5 22 4 , 4 5 9 23 1 , 8 0 2 23 8 , 7 5 6 24 5 , 9 1 9 25 3 , 2 9 6 260,895 S u p p l i e s 13 , 0 7 7 39 , 7 1 5 35 , 1 1 5 35 , 8 1 7 36 , 5 3 4 37,264 38,010 Ot h e r S e r v i c e s & C h a r g e s 2 , 7 9 2 , 4 4 8 2, 8 6 9 , 2 5 8 3, 0 1 3 , 1 7 6 3, 1 3 3 , 7 0 3 3, 2 5 9 , 0 5 1 3, 3 2 4 , 2 3 2 3,390,717 In s u r a n c e 25 , 0 6 3 26 , 5 6 8 28 , 1 6 2 28 , 7 2 5 29 , 3 0 0 29,886 30,483 Ut i l i t i e s 44 , 7 5 5 39 , 1 0 0 39 , 1 0 0 39 , 8 8 2 40 , 6 8 0 41,493 42,323 D ep r e c i a t i o n 89 7 , 8 0 3 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1,124,040 Ca p i t a l O u t l a y 1, 9 4 9 , 7 7 8 2, 6 2 6 , 8 5 8 2, 9 1 5 , 0 0 0 2, 3 5 8 , 0 0 0 1, 0 8 0 , 0 0 0 1, 5 1 3 , 0 0 0 713,000 De b t S e r v i c e ( E x i s t i n g ) 28 2 , 2 9 3 42 3 , 7 4 3 54 3 , 1 4 0 54 4 , 5 6 3 54 0 , 7 5 1 54 4 , 1 7 9 534,922 De b t S e r v i c e ( P r o j e c t e d ) - - - 2 0 5 , 1 5 3 41 1 , 4 7 9 41 1 , 4 7 9 411,479 To t a l 6, 2 0 1 , 0 8 2 7, 3 7 3 , 7 4 1 7, 9 2 9 , 5 3 5 7, 7 0 8 , 6 4 0 6, 7 6 7 , 7 5 3 7, 2 7 8 , 8 7 0 6,545,869 Ca s h B a l a n c e - B e g i n n i n g 4, 7 3 1 , 9 8 2 4, 8 6 6 , 1 5 9 2, 9 5 2 , 7 9 4 2, 3 4 3 , 1 3 0 2, 1 7 9 , 0 8 1 1, 4 2 6 , 1 3 4 397,990 Ch a n g e s i n A c c r u a l s (2 9 3 , 1 8 6 ) - - - - - - Re v e n u e s 5, 7 3 0 , 6 4 2 4, 3 3 6 , 3 3 6 6, 1 9 5 , 8 3 2 6, 4 2 0 , 5 5 1 4, 8 9 0 , 7 6 6 5, 1 2 6 , 6 8 6 5,372,025 E x p e n d i t u r e s (6 , 2 0 1 , 0 8 2 ) (7 , 3 7 3 , 7 4 1 ) (7 , 9 2 9 , 5 3 5 ) (7 , 7 0 8 , 6 4 0 ) (6 , 7 6 7 , 7 5 3 ) (7 , 2 7 8 , 8 7 0 ) (6,545,869) No n c a s h - D e p r e c i a t i o n 89 7 , 8 0 3 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1, 1 2 4 , 0 4 0 1,124,040 Ca s h B a l a n c e - E n d i n g 4, 8 6 6 , 1 5 9 $ 2 , 9 5 2 , 7 9 4 $ 2 , 3 4 3 , 1 3 0 $ 2 , 1 7 9 , 0 8 1 $ 1 , 4 2 6 , 1 3 4 $ 3 9 7 , 9 9 0 $ 3 4 8 , 1 8 7 $ 44 Sa n i t a r y S e w e r F u n d – C a s h F l o w A n a l y s i s 45 St o r m D r a i n a g e F u n d – C a s h F l o w A n a l y s i s Re s i d e n t i a l - F l a t F e e / P e r Q t r . 14 . 4 8 $ 1 4 . 7 7 $ 1 5 . 0 6 $ 1 5 . 3 7 $ 1 5 . 6 7 $ 1 5 . 9 9 $ 1 6 . 3 1 $ Pe r Q u a r t e r C h a n g e - $ 0. 2 9 $ 0. 3 0 $ 0. 3 0 $ 0. 3 1 $ 0.31 $ 0.32 $ A c t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 Re v e n u e s Op e r a t i n g 1, 5 9 8 , 3 7 4 $ 1, 6 3 0 , 3 4 1 $ 1, 6 6 2 , 9 4 8 $ 1, 6 9 6 , 2 0 7 $ 1, 7 3 0 , 1 3 1 $ 1,764,734 $ 1,800,029 $ In v e s t m e n t E a r n i n g s 42 , 2 2 0 46 , 5 4 8 46 , 5 4 8 27 , 4 6 8 28 , 2 9 1 15,684 13,281 No n o p e r a t i n g 25 0 - - - - - - B o n d P r o c e e d s - 1 , 5 3 0 , 1 4 2 1, 6 7 0 , 0 0 0 1, 9 1 0 , 0 0 0 - - - To t a l 1, 6 4 0 , 8 4 4 3, 2 0 7 , 0 3 1 3, 3 7 9 , 4 9 6 3, 6 3 3 , 6 7 5 1, 7 5 8 , 4 2 3 1,780,419 1,813,309 Ex p e n d i t u r e s P e r s o n a l S e r v c i e s 20 8 , 9 3 2 22 6 , 7 2 5 23 2 , 3 0 4 23 9 , 2 7 3 24 6 , 4 5 1 253,845 261,460 S u p p l i e s 19 , 4 2 0 61 , 5 0 0 53 , 2 6 5 54 , 3 3 0 55 , 4 1 7 56,525 57,656 Ot h e r S e r v i c e s & C h a r g e s 30 4 , 2 8 1 35 1 , 4 8 5 35 2 , 4 5 0 35 9 , 4 9 9 36 6 , 6 8 9 374,023 381,503 In s u r a n c e 2, 2 3 3 2, 3 6 7 2, 5 0 9 2, 5 5 9 2, 6 1 0 2,663 2,716 Ut i l i t i e s 2, 9 2 4 3, 6 0 0 3, 7 0 0 3, 7 7 4 3, 8 4 9 3,926 4,005 D ep r e c i a t i o n 1, 2 7 7 , 8 8 3 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1,373,350 1,373,350 Ca p i t a l O u t l a y 1, 6 2 8 , 8 0 1 2, 1 8 2 , 1 1 6 3, 7 7 8 , 4 7 0 2, 3 9 8 , 0 0 0 1, 6 2 4 , 0 0 0 608,000 892,000 De b t S e r v i c e ( e x i s t i n g ) 18 , 0 8 0 11 6 , 6 5 0 15 8 , 4 8 5 29 8 , 1 0 0 30 0 , 4 0 0 302,150 298,600 De b t S e r v i c e ( p r o j e c t e d ) - - - 1 9 5 , 7 7 5 41 9 , 6 8 5 419,685 419,685 To t a l 3, 4 6 2 , 5 5 4 4, 3 1 7 , 7 9 3 5, 9 5 4 , 5 3 3 4, 9 2 4 , 6 6 1 4, 3 9 2 , 4 5 2 3,394,167 3,690,975 Ca s h B a l a n c e - B e g i n n i n g 4, 2 3 7 , 6 1 5 3, 6 8 5 , 8 6 2 3, 9 4 8 , 4 5 0 2, 7 4 6 , 7 6 4 2, 8 2 9 , 1 2 8 1,568,449 1,328,050 Ch a n g e s i n A c c r u a l s (7 , 9 2 6 ) - - - - - - Re v e n u e s 1, 6 4 0 , 8 4 4 3, 2 0 7 , 0 3 1 3, 3 7 9 , 4 9 6 3, 6 3 3 , 6 7 5 1, 7 5 8 , 4 2 3 1,780,419 1,813,309 E x p e n d i t u r e s (3 , 4 6 2 , 5 5 4 ) (4 , 3 1 7 , 7 9 3 ) (5 , 9 5 4 , 5 3 3 ) (4 , 9 2 4 , 6 6 1 ) (4 , 3 9 2 , 4 5 2 ) (3,394,167) (3,690,975) No n c a s h - D e p r e c i a t i o n 1, 2 7 7 , 8 8 3 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1, 3 7 3 , 3 5 0 1,373,350 1,373,350 Ca s h B a l a n c e - E n d i n g 3, 6 8 5 , 8 6 2 $ 3, 9 4 8 , 4 5 0 $ 2, 7 4 6 , 7 6 4 $ 2, 8 2 9 , 1 2 8 $ 1, 5 6 8 , 4 4 9 $ 1,328,050 $ 823,734 $ 46 St o r m D r a i n a g e F u n d – C a s h F l o w A n a l y s i s 47 St r e e t L i g h t F u n d – C a s h F l o w A n a l y s i s Re s i d e n t i a l - F l a t F e e / P e r Q t r . 6. 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6 . 5 5 $ 6.55 $ Pe r Q u a r t e r C h a n g e - $ - $ - $ - $ - $ - $ - $ A c t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 Re v e n u e s Op e r a t i n g 45 1 , 3 5 8 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 45 0 , 5 0 0 $ 450,500 $ 450,500 $ In v e s t m e n t E a r n i n g s 6, 1 7 0 6, 6 3 6 6, 6 3 6 6, 1 3 9 6, 4 9 1 7,797 8,568 No n o p e r a t i n g 2, 9 3 5 - - - - - - To t a l 46 0 , 4 6 3 45 7 , 1 3 6 45 7 , 1 3 6 45 6 , 6 3 9 45 6 , 9 9 1 458,297 459,068 Ex p e n d i t u r e s Su p p l i e s 5, 9 0 1 7, 7 8 0 7, 7 8 0 7, 9 3 6 8, 0 9 4 8,256 8,421 Ot h e r S e r v i c e s & C h a r g e s 32 , 9 5 0 47 , 9 0 4 48 , 0 7 3 49 , 0 3 4 50 , 0 1 5 51,015 52,036 In s u r a n c e 79 8 84 6 89 7 91 5 93 3 952 971 Ut i l i t i e s 16 8 , 1 1 8 18 0 , 0 0 0 18 0 , 0 0 0 18 3 , 6 0 0 18 7 , 2 7 2 191,017 194,838 De p r e c i a t i o n 59 , 3 0 2 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 103,183 103,183 Ca p i t a l O u t l a y 11 7 , 2 5 5 31 8 , 7 8 1 23 0 , 0 0 0 18 0 , 0 0 0 80 , 0 0 0 130,000 413,000 T ot a l 38 4 , 3 2 4 65 8 , 4 9 4 56 9 , 9 3 3 52 4 , 6 6 8 42 9 , 4 9 8 484,424 772,449 Ca s h B a l a n c e - B e g i n n i n g 58 1 , 4 6 9 72 1 , 6 8 6 62 3 , 5 1 1 61 3 , 8 9 7 64 9 , 0 5 1 779,727 856,783 Ch a n g e s i n A c c r u a l s 4, 7 7 6 - - - - - - Re v e n u e s 46 0 , 4 6 3 45 7 , 1 3 6 45 7 , 1 3 6 45 6 , 6 3 9 45 6 , 9 9 1 458,297 459,068 Ex p e n d i t u r e s (3 8 4 , 3 2 4 ) (6 5 8 , 4 9 4 ) (5 6 9 , 9 3 3 ) (5 2 4 , 6 6 8 ) (4 2 9 , 4 9 8 ) (484,424) (772,449) No n c a s h - D e p r e c i a t i o n 59 , 3 0 2 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 10 3 , 1 8 3 103,183 103,183 Ca s h B a l a n c e - E n d i n g 72 1 , 6 8 6 $ 62 3 , 5 1 1 $ 61 3 , 8 9 7 $ 64 9 , 0 5 1 $ 77 9 , 7 2 7 $ 856,783 $ 646,585 $ 48 St r e e t L i g h t F u n d – C a s h F l o w A n a l y s i s 49 An t i c i p a t e d D e b t S e r v i c e  An t i c i p a t e d b o n d i s s u e s b a s e d o n o u r ca p i t a l i n v e s t m e n t n e e d s a r e a s f o l l o w s : ◦ St r e e t R e c o n s t r u c t i o n ( L e v y ) ◦ In f r a s t r u c t u r e / S p e c i a l A s s e s s m e n t ( S p e c i a l As s e s s m e n t ) ◦ Wa t e r ( U s e r F e e s ) ◦ Sa n i t a r y S e w e r ( U s e r F e e s ) ◦ St o r m D r a i n a g e ( U s e r F e e s ) 50 An t i c i p a t e d D e b t I s s u e s Ye a r Ca p i t a l I m p . (L e v y ) Sp e c i a l As s e s s m e n t s (A s s e s s m e n t ) St r e e t Re c o n s t r u c t i o n (L e v y ) Wa t e r (U s e r F e e s ) Sa n i t a r y Se w e r (U s e r F e e s ) Storm Dr a i n a g e (User Fees) Total 20 1 8 2, 0 2 9 , 3 3 7 2 , 1 3 7 , 6 7 9 3 , 1 9 1 , 4 5 1 1,530,142 8,888,609 20 1 9 2, 8 1 0 , 0 0 0 2 , 3 0 0 , 0 0 0 2 , 6 0 0 , 0 0 0 1 , 7 5 0 , 0 0 0 1 , 6 7 0 , 0 0 0 1 1 , 1 3 0 , 0 0 0 20 2 0 2, 3 0 0 , 0 0 0 3 , 2 7 0 , 0 0 0 1 , 7 6 0 , 0 0 0 1 , 9 1 0 , 0 0 0 9 , 2 4 0 , 0 0 0 20 2 1 7 , 6 3 7 , 0 0 0 7,637,000 20 2 2 1, 9 1 0 , 0 0 0 2 , 4 5 0 , 0 0 0 4,360,000 20 2 4 2, 4 5 0 , 0 0 0 2 , 7 0 0 , 0 0 0 2 , 9 6 0 , 0 0 0 1 , 3 9 0 , 0 0 0 9,500,000 20 2 5 2, 0 0 0 , 0 0 0 3 , 3 8 0 , 0 0 0 1 , 5 0 0 , 0 0 0 2 , 1 0 0 , 0 0 0 8,980,000 20 2 8 1, 6 6 0 , 0 0 0 1,660,000 20 2 9 2,710,000 2,710,000 20 3 0 2, 3 7 0 , 0 0 0 2,370,000 To t a l $ 7 , 6 3 7 , 0 0 0 $ 7 , 2 6 0 , 0 0 0 $ 1 6 , 6 2 0 , 0 0 0 $ 1 2 , 78 0 , 0 0 0 $ 7 , 0 0 0 , 0 0 0 $ 6 , 2 9 0 , 0 0 0 $ 5 7 , 5 8 7 , 0 0 0 51 20 1 9 – 2 0 2 0 S u m m a r y  $2 0 . 4 m i l l i o n i n d e b t i s s u a n c e s o v e r t h e ne x t t w o y e a r s ( N R P d r i v i n g f a c t o r )  Fi n a n c i a l I m p a c t ◦ 1. 6 % a n n u a l i n c r e a s e i n t a x l e v y f o r d e b t se r v i c e ( A p p r o x i m a t e l y $ 1 6 / y e a r o n t h e me d i a n v a l u e h o m e ) ◦ Qu a r t e r l y u t i l i t y b i l l ( t y p i c a l r e s i d e n t ) ◦ 20 1 8 - $ 1 5 5 . 7 5 ◦ 20 1 9 - $ 1 6 2 . 1 0 ( $ 6 . 3 5 q u a r t e r l y i n c r e a s e ) ◦ 20 2 0 - $ 1 7 2 . 1 8 ( $ 1 0 . 0 9 q u a r t e r l y i n c r e a s e ) 52 20 1 9 T e c h n o l o g y F u n d De s c r i p t i o n Co s t Ne t w o r k H a r d w a r e $5 7 , 5 0 0 Vi d e o S u r v e i l l a n c e 20 , 0 0 0 Mu l t i - F u n c t i o n D e v i c e s 74 , 0 0 0 Sc a n n e r s 30 , 0 0 0 Di g i t a l S i g n a g e ( C i t y H a l l / C o m m u n i t y C e n t e r ) 60 , 0 0 0 20 1 9 T o t a l C o s t $ 2 4 1 , 5 0 0 53 Te c h n o l o g y F u n d – C a s h F l o w A n a l y s i s Ac t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 Re v e n u e s Tr a n s f e r s I n 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 14 0 , 0 0 0 $ 140,000 $ In v e s t m e n t E a r n i n g s 2, 0 6 3 3, 7 2 8 1, 0 8 4 - - 1 , 6 0 4 2,982 To t a l 14 2 , 0 6 3 14 3 , 7 2 8 14 1 , 0 8 4 14 0 , 0 0 0 14 0 , 0 0 0 14 1 , 6 0 4 142,982 Ex p e n d i t u r e s P r i o r Y e a r P r o j e c t s - C a r r y F o r w a r d 1 2 6 , 6 6 2 - - - - - Ca p i t a l O u t l a y 19 , 4 6 6 28 1 , 5 0 0 21 1 , 5 0 0 14 5 , 7 5 0 11 , 8 0 0 3, 8 0 0 62,700 To t a l 19 , 4 6 6 40 8 , 1 6 2 21 1 , 5 0 0 14 5 , 7 5 0 11 , 8 0 0 3, 8 0 0 62,700 Ca s h B a l a n c e - B e g i n n i n g 25 0 , 3 8 4 37 2 , 8 3 8 10 8 , 4 0 4 37 , 9 8 8 32 , 2 3 8 16 0 , 4 3 8 298,243 Ch a n g e s i n A c c r u a l s (1 4 3 ) - - - - - - Re v e n u e s 14 2 , 0 6 3 14 3 , 7 2 8 14 1 , 0 8 4 14 0 , 0 0 0 14 0 , 0 0 0 14 1 , 6 0 4 142,982 E x p e n d i t u r e s (1 9 , 4 6 6 ) (4 0 8 , 1 6 2 ) (2 1 1 , 5 0 0 ) (1 4 5 , 7 5 0 ) (1 1 , 8 0 0 ) (3 , 8 0 0 ) (62,700) Ca s h B a l a n c e - E n d i n g 37 2 , 8 3 8 $ 10 8 , 4 0 4 $ 37 , 9 8 8 $ 32 , 2 3 8 $ 16 0 , 4 3 8 $ 29 8 , 2 4 3 $ 378,525 $ 54 20 1 9 E B H C C a p i t a l F u n d De s c r i p t i o n Co s t Hi p p o d r o m e R o o f $2 0 5 , 0 0 0 Ph o n e S y s t e m 40 , 0 0 0 Sw i t c h e s 25 , 0 0 0 Ca r r i a g e H a l l R o t u n d a D o o r s ( 4 s e t s ) 70 , 0 0 0 Mo r g a n / H a l l C a r p e t 32 , 0 0 0 Re p l a c e H a r v e s t / G a r d e n C i t y C a r p e t 50 , 0 0 0 Ga r d e n C i t y / H a r v e s t P r e f u n c t i o n / L i n k C a r p e t 60 , 0 0 0 20 1 9 T o t a l C o s t $ 4 8 2 , 0 0 0 55 EB H C C a p i t a l F u n d – C a s h F l o w A n a l y s i s Ac t u a l P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d P r o j e c t e d 20 1 7 2 0 1 8 2 0 1 9 2 0 2 0 2 0 2 1 2 0 2 2 2 0 2 3 Re v e n u e s Tr a n s f e r s 50 0 , 0 0 0 $ 32 5 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 31 8 , 0 0 0 $ 318,000 $ Ca p i t a l C o n t r i b u t i o n s - - - - - - - In v e s t m e n t E a r n i n g s 7, 3 9 7 12 , 7 9 7 15 , 7 8 0 15 , 7 8 0 9, 0 0 0 9, 0 2 0 8,310 To t a l 50 7 , 3 9 7 33 7 , 7 9 7 33 3 , 7 8 0 33 3 , 7 8 0 32 7 , 0 0 0 32 7 , 0 2 0 326,310 Ex p e n d i t u r e s Ca p i t a l O u t l a y 30 6 , 2 2 4 55 8 , 0 6 5 48 2 , 0 0 0 34 5 , 0 0 0 32 5 , 0 0 0 39 8 , 0 0 0 362,000 To t a l 30 6 , 2 2 4 55 8 , 0 6 5 48 2 , 0 0 0 34 5 , 0 0 0 32 5 , 0 0 0 39 8 , 0 0 0 362,000 Ca s h B a l a n c e - B e g i n n i n g 1, 0 7 8 , 5 1 1 1, 2 7 9 , 6 8 4 1, 0 5 9 , 4 1 6 91 1 , 1 9 6 89 9 , 9 7 6 90 1 , 9 7 5 830,995 Ch a n g e s i n A c c r u a l s - - - - - - - Re v e n u e s 50 7 , 3 9 7 33 7 , 7 9 7 33 3 , 7 8 0 33 3 , 7 8 0 32 7 , 0 0 0 32 7 , 0 2 0 326,310 E x p e n d i t u r e s (3 0 6 , 2 2 4 ) (5 5 8 , 0 6 5 ) (4 8 2 , 0 0 0 ) (3 4 5 , 0 0 0 ) (3 2 5 , 0 0 0 ) (3 9 8 , 0 0 0 ) (362,000) Ca s h B a l a n c e - E n d i n g 1, 2 7 9 , 6 8 4 $ 1 , 0 5 9 , 4 1 6 $ 9 1 1 , 1 9 6 $ 89 9 , 9 7 6 $ 90 1 , 9 7 5 $ 83 0 , 9 9 5 $ 795,305 $ 56 20 1 9 B C L i q u o r  Ma r k e t S t u d y – d r a f t c o m p l e t e d M a y 2 4 , 2 0 1 8  Re c o m m e n d a t i o n s i n v o l v i n g c a p i t a l i n v e s t m e n t in c l u d e : ◦ St o r e # 1 – P u r c h a s e l a n d w h i c h a c i t y - o w n e d l i q u o r st o r e c a n b e b u i l t i n p r o x i m a t e l o c a t i o n . ( 8 , 5 0 0 t o 9, 0 0 0 s q u a r e f e e t ) . C u r r e n t l e a s e e x p i r e s J u n e 2 0 2 0 . ◦ St o r e # 2 - P u r c h a s e l a n d w h i c h a c i t y - o w n e d l i q u o r st o r e c a n b e b u i l t i n p r o x i m a t e l o c a t i o n . ( 4 , 5 0 0 t o 5, 0 0 0 s q u a r e f e e t ) . C u r r e n t l e a s e e x p i r e s 2 0 2 3 . ◦ St o r e # 3 - P u r c h a s e l a n d w h i c h a c i t y - o w n e d l i q u o r st o r e c a n b e b u i l t n e a r T H 2 5 2 a n d 6 6 th Av e n u e . (5 , 0 0 0 t o 6 , 0 0 0 s q u a r e f e e t ) . R e c o m m e n d e d t a r g e t co m p l e t i o n o f t h r e e t o f i v e y e a r s . 57 20 1 9 B C L i q u o r De s c r i p t i o n Co s t Bu s i n e s s S i t e / L o c a t i o n F e a s i b i l i t y A n a l y s i s - I m p l e m e n t a t i o n of R e c o m m e n d a t i o n s ( S t o r e # 1 L a n d A c q u i s i t i o n ) $7 5 0 , 0 0 0 20 1 9 T o t a l C o s t $ 7 5 0 , 0 0 0 58 Po t e n t i a l L i q u o r S t o r e # 1 L o c a t i o n s Cu r r e n t L o c a t i o n 59 Qu e s t i o n s ? 60