|
FUND 162 -CIP 4 CASHFLOW
<br /> 2016 2017 2018 2019 2020 2021 2022 2023
<br /> Actual Actual Actual Estimate Forecast Forecast Forecast Forecast
<br /> 'BEGINNING BALANCE 8,129,134 10,132,739 12,336,285 12,747,846 1,327,330 1,564,234 1,808,246 2,059,577
<br /> REVENUES
<br /> General Fund Contribution 2,540,000 2,000,000 - -
<br /> Lease Revenue 220,940 235,682 218,826 230,004 236,904 244,011 251,332 258,872
<br /> LIFT Grant(sales tax) 327,865 492,735
<br /> Transfers In 150,192
<br /> Total Revenue 2,911,132 2,563,546 711,561 230,004 236,904 244,011 251,332 258,872
<br /> (TOTAL RESOURCES(Beg FB+Rev) I 11,040,266 1 12,696,285 I 13,047,846 1 12,977,850 1,564,234 1,808,246 I 2,059,577 I 2,318,449 I
<br /> 'PROJECT EXPENSES I 907,527 1 360,000 I 300,000 I 11,650,520 - - I - J -
<br /> 'ENDING BALANCE I 10,132,739 I 12,336,285 I 12,747,846 I 1,327,330 1,564,234 1,808,246 1 2,059,577 I 2,318,449 I
<br /> 2018 2017 2018 2019 2020 2021 2022 2023
<br /> Second line(BLACK)showing added cost of Committed To Projects
<br /> Beginning Fund Balance 8,129,134 10,132,739 12,336,285 12,747,846 1,003,940 1,240,844 1,484,856 1,736,187
<br /> Total Annual Revenues 2,911,132 2,563,546 711,561 230,004 236,904 244,011 251,332 258,872
<br /> Total Expenses 907,527 360,000 300,000 11,650,520 - - - -
<br /> ADD:
<br /> 'Ending Balance w/Committed To projects 1 10,132,739 1 12,336,285 I 12,747,846 I 1,003,940 I 1,240,844 I 1,484,856 I 1,736,187 1 1,995,059 I
<br /> Third line(RED)showing added cost of Requested Projects
<br /> Beginning Fund Balance 8,129,134 10,132,739 12,336,285 12,747,846 303,940 (209,156) (715,144) (1,213,813)
<br /> Total Annual Revenues 2,911,132 2,563,546 711,561 230,004 236,904 244,011 251,332 258,672
<br /> Total Expenses 907,527 360,000 300,000 11,650,520 - - - -
<br /> ADD:Projects Committed To - - - 323,390 - - - -
<br /> ADD:Department Requests - - - 700,000 750,000 750,000 750,000 750,000
<br /> 'Ending Balance w/Committed and Requester I 10,132,739 1 12,336,285 1 12,747,846 1 303,940 I (209,156)1 (715,144)1 (1,213,813)1 (1,704,941)1
<br /> CIP 4 Ending Balances
<br /> 25,000,000
<br /> 20,000,000
<br /> 15,000,000
<br /> 10,000,000 er."'"..'"'"'°..43
<br /> 7%41'44%
<br /> 5,000,000 .. _ .-.
<br /> r� 2018 2017 2018 2019 2020 2 1 2? 43
<br /> C.-__>3
<br /> (5Aoo,000)
<br /> �✓ Approved Projects only -0-Approved plus Committed Projects Approved plus Committed and Requested Projects
<br />
|