Loading...
HomeMy WebLinkAbout07-2017 Controller's Trustee Cash ReportPeriod Ending: July 31, 2017 Issued By: Administration/Finance City of South Bend Controller's Trustee Cash Report Page Contents 2 Purpose & Narrative 3 Summary 4 Graph of Cash Balances Distribution Mayor Pete Buttigieg Interim Chief of Staff Angela Kouters Deputy Chief of Staff Suzanna Fritzberg Common Council Department Heads Fiscal Officers Department of Administration & Finance Purpose of Report Current Activity The City of South Bend maintains certain cash balances with bank trustees in connection with bond and capital lease financing agreements that have been approved by the Common Council, Redevelopment Commission, and the Board of Public Works. The cash reserves are restricted and may not be used for general city operations. Rather, trustee cash reserves must be used as provided for in the debt documents including for capital projects, debt service payments, debt service reserves and operating reserves The bank trustee accounts are also used for the defeasance of prior debt that has been refunded. The primary bank trustees used by the city are US Bank and Wells Fargo Bank. The debt service payments on bonds and capital leases are included in the regular city budget. The current trustee cash accounts include capital project money for the Smart Streets bond and the Parks/EDIT bond. Cash in capital project accounts is spent down as work is completed on projects. Trustee cash accounts also includes proceeds from lease purchase agreements for the replacement of certain city vehicles and equipment on a regular basis. During February 2017, the 2005 Erskine Village bonds were paid off early. $561,229 in trustee cash was paid back to the City of South Bend and deposited into Fund 430. During March 2017, the remaining interest earned was paid back to the City and deposited into Fund 430 and the associated Wells Fargo bank accounts were closed. Additionally, the final payment on the 2009 MPAC bonds was made on February 1 and $735,235 in trustee cash was paid back to the City of South Bend and deposited into Fund 408. During March 2017, the remaining interest earned was paid back to the City and deposited into Fund 408 and the associated Wells Fargo bank accounts were closed. If you should have any questions regarding this report, please contact the Department of Administration & Finance. Administration Finance 8/24/2017 Page 2 City of South Bend, IndianaTrustee Cash SummaryJanuary 1, 2017 thru July 31, 2017Beginning YTD YTD EndingName Purpose EntityTrustee Fund Cash Receipts Disbursements Cash2012 Police/Fire Building Refunding Sinking Fund Building Corporation US Bank 755 61.80 1,571,117.19 786,061.82 785,117.172012 Police/Fire Building Refunding Operating & Repair Building Corporation US Bank 755 23,941.92 1,410.72 500.00 24,852.642012 Police/Fire Building Refunding Reserve Fund Building Corporation US Bank 755 3,887.07 12.32 0.00 3,899.392013 EMS Revenue Bond Sinking Fund Building Corporation US Bank 7557.81 516,680.62 315,427.50 201,260.932013 EMS Revenue Bond Operating & Reserve Building Corporation US Bank 755 116,703.04 28.61 111,053.59 5,678.062013 EMS Revenue Bond Reserve Fund Building Corporation US Bank 7550.00 0.00 0.00 0.002013 EMS Revenue Bond Construction Fund Building Corporation US Bank 755 116.09 0.01 116.10 0.002013 EMS Revenue Bond Bond Interest Account Building Corporation US Bank 755 0.00 0.00 0.00 0.002010 BPW Building Refunding Debt Service Reserve Fund Building Corporation Wells Fargo 755 607,504.83 765.35 765.35 607,504.832010 BPW Building Refunding Sinking Fund Building Corporation Wells Fargo 755 20.30 674,773.38 336,594.55 338,199.132010 BPW Building Refunding Operating & Reserve Building Corporation Wells Fargo 755 9,845.74 1,291.10 2,500.00 8,636.84Total Building Corporation762,088.60$ 2,766,079.30$ 1,553,018.91$ 1,975,148.99$ 2015 Parks/EDIT Bond Bond Retirement Account City of South Bend US Bank 757 164,263.42 226,602.25 198,565.63 192,300.042015 Parks/EDIT Bond Debt Service Reserve Fund City of South BendUS Bank 757 397,679.52 377.03 0.00 398,056.552015 Parks/EDIT Bond Construction Fund City of South Bend US Bank 751 4,337,198.79 3,816.79 837,080.27 3,503,935.312015 PNC Bank Vehicle/Equipment Lease City of South Bend US Bank 750 371,957.01 413.84 372,370.85 0.002016 Public-Finance.com (Lease #1) Vehicle/Equipment Lease City of South Bend US Bank 750 299,849.05 209.32 300,058.37 0.002016 PNC Equipment Finance (Lease #2) Vehicle/Equipment Lease City of South Bend US Bank 750 1,494,370.71 394.94 1,414,345.00 80,420.652016 PNC Equipment Finance (Lease #3) Vehicle/Equipment Lease City of South Bend US Bank 750 1,011,716.73 973.37 112,002.94 900,687.162017 Public-Finance.com (Lease #1) Vehicle/Equipment Lease City of South Bend US Bank 750 0.00 2,917,674.34 266,115.50 2,651,558.842016 Waterworks Bond Refunding Cost of Issuance Fund City of South Bend US Bank 620 53,250.37 0.00 53,250.37 0.00Total City of South Bend8,130,285.60$ 3,150,461.88$ 3,553,788.93$ 7,726,958.55$ 2005 Erskine Village Bonds Reserve Fund Redevelopment Authority Wells Fargo 758 561,115.03 47.43 561,162.46 0.002005 Erskine Village Bonds Principal & Interest Redevelopment Authority Wells Fargo 758 1.78 3,961,734.72 3,961,736.50 0.002008 Eddy Street Commons Sinking Fund Redevelopment Authority US Bank 752 0.00 1,463,034.38 1,463,034.38 0.002008 Eddy Street Commons Debt Service Reserve Fund Redevelopment Authority US Bank 752 60.03 0.19 0.00 60.222008 Eddy Street Commons Excess Fund Redevelopment Authority US Bank 752 0.24 0.00 0.00 0.242011 Century Center Refunding Sinking Fund Redevelopment Authority US Bank 752 598.72 495,450.79 246,098.90 249,950.612011 Century Center Refunding Operating & Reserve Fund Redevelopment Authority US Bank 752 18,000.19 958.19 0.00 18,958.382011 Century Center Refunding Reserve Fund Redevelopment Authority US Bank 752 298,354.92 944.55 443.15 298,856.322011 Hall of Fame Refunding Sinking Fund Redevelopment Authority US Bank 313 28.40 1,268,015.88 635,028.41 633,015.872011 Hall of Fame Refunding Operations & Reserve Redevelopment Authority US Bank 313 19,375.18 3,363.03 0.00 22,738.212013 Century Center Refunding Operation & Reserve Redevelopment Authority US Bank 752 174,124.41 377.58 148,389.44 26,112.552013 Century Center Refunding Sinking Fund Redevelopment Authority US Bank 752 16.78 345,934.17 345,906.25 44.702013 Century Center Refunding Reserve Fund Redevelopment Authority US Bank 752 0.00 0.00 0.00 0.002015 Eddy Street Commons Refunding Sinking Fund Redevelopment Authority US Bank 752 8,166.39 2,471,248.59 1,234,003.13 1,245,411.852015 Eddy Street Commons Refunding Operations & Reserve Redevelopment Authority US Bank 752 0.00 0.00 0.00 0.002015 Smart Streets Bond Sinking Fund Redevelopment Authority US Bank 756 1,012.82 1,252,146.42 394,784.38 858,374.862015 Smart Streets Bond Operating & Reserve Redevelopment Authority US Bank 756 0.00 0.00 0.00 0.002015 Smart Streets Bond Reserve Fund Redevelopment Authority US Bank 756 1,711,759.20 1,622.26 860.43 1,712,521.032015 Smart Streets Bond Construction Fund Redevelopment AuthorityUS Bank 753 5,929,453.38 25,827.61 4,480,777.21 1,474,503.782015 Smart Streets Bond Bond Interest Account Redevelopment Authority US Bank 756 395,668.39 83.55 394,784.38 967.562009 Morris PAC Refunding Debt Service Reserve Fund Redevelopment Authority Wells Fargo 752 721,011.86 83.42 721,095.28 0.002009 Morris PAC Refunding Operations & Reserve Redevelopment Authority Wells Fargo 752 12,435.85 1,792.54 14,228.39 0.002009 Morris PAC Refunding Sinking Fund Redevelopment Authority Wells Fargo 752 0.00 527,007.67 527,007.67 0.00Total Redevelopment Authority9,851,183.57$ 11,819,672.97$ 15,129,340.36$ 6,541,516.18$ Totals18,743,557.77$ 17,736,214.15$ 20,236,148.20$ 16,243,623.72$ Administration Finance 8/24/2017 Page 3 Entity Cash Balance Percent Building Corporation 1,975,149$ 12.16% City of South Bend 7,726,959 47.57% Redevelopment Authority 6,541,516 40.27% Total 16,243,624$ 100.00% July 31, 2017 Redevelopment Authority includes the 2015 Smart Streets bond capital fund with a balance of $1.5 million dollars remaining in the fund at July 31, 2017. City of South Bend includes the 2015 Parks/EDIT bond capital fund with a balance of $3.5 million dollars remaining in the fund at July 31, 2017. Trustee Cash Balances Building Corporation City of South Bend Redevelopment Authority Administration Finance 8/24/2017 Page 4