Loading...
HomeMy WebLinkAbout06-2014 Century Center Bank Account Cash Summary$ou TH Period Ending: June 30, 2014 ITC�E Jx d Issued BY: Controller City of South Bend Century Center Bank Account Cash Summary Page Numbers Contents 2 -7 Cash Summary Detail 8 Cash Summary - Bar Chart Trends 9 Cash Summary - Line Chart Trends 10 Cash Summary - Bar Chart - June 30, 2007 to June 30, 2014 Distribution Century Center Board of Managers Century Center Management Deputy Mayor Chief of Staff Deputy Chief of Staff City Controller Deputy City Controller City Finance Director Financial Officer Mark Neal Kathryn Roos Brian Pawlowski John Murphy Jennifer Hockenhull Rahman Johnson Cecil Eastman Cash Trends Summary 7/22/2014 1 Century Center Bank Statement Cash Summary September 30, 2006 through June 30, 2014 Updated - July 21, 2014 Key Bank Key Bank Key Bank Key Bank Certificate Capital Operating (1) A/P - Payroll Event of Deposit Old National Month Account Account Account Account Capital Loan Net Notes Ending Balance - September 30, 2006 $165,398.35 $276,400.17 $61,104.48 $14,869.85 $1,036,692.21 ($460,500.00) $1,093,965.06 Key Bank CD $1,036,692.21 Receipts 60.28 171,258.11 300,000.00 6,140.00 0.00 0.00 477,458.39 Disbursements 0.00 (300,316.85) (254,091.79) (17,003.50) 0.00 0.00 (571,412.14) Ending Balance- October 31, 2006 165,458.63 147,341.43 107,012.69 4,006.35 1,036,692.21 (460,500.00) 1,000,011.31 Receipts 54.40 180,752.84 250,000.00 3,840.00 0.00 0.00 434,647.24 Disbursements 0.00 (251,436.91) (201,234.53) (6.28) 0.00 17,875.00 (434,802.72) Ending Balance - November 30, 2006 165,513.03 76,657.36 155,778.16 7,840.07 1,036,692.21 (442,625.00) 999,855.83 Receipts 100,079.26 245,169.61 250,000.00 17,280.00 0.00 0.00 612,528.87 $100,000 PSDA Fund 377 2006 Disbursements 0.00 (300,126.17) (379,053.86) (20,009.19) 0.00 0.00 (699,189.22) Ending Balance - December 31, 2006 265,592.29 21,700.80 26,724.30 51110.88 1,036,692.21 (442,625.00) 913,195.48 Receipts 90.24 833,624.36 200,000.00 5,260.00 0.00 0.00 1,038,974.60 Disbursements 0.00 (100,083.35) (16 ,721 66 (3.44) 0.00 0.00 (265,808.45) Ending Balance - January 31, 2007 265,682.53 755,241.81 61,002.64 10,367.44 1,036,692.21 (442,625.00) 1,686,361.63 Receipts 81.54 203,966.17 250,000.00 14,960.00 0.00 0.00 469,007.71 Disbursements 0.00 (201,074.63) (206,130.22) (14,004.29) 0.00 17,875.00 (403,334.14) Ending Balance - February 28, 2007 265,764.07 758,133.35 104,872.42 11,323.15 1,036,692.21 (424,750.00) 1,752,035.20 Receipts 90.30 106,391.23 225,000.00 7,640.00 0.00 0.00 339,121.53 Disbursements 0.00 (297,852.43) (222,892.18) 0.00 0.00 0.00 ,744 61 Ending Balance - March 31, 2007 265,854.37 566,672.15 106,980.24 18,963.15 1,036,692.21 (424,750.00) 1,570,412.12 Receipts 87.42 154,893.81 325,343.53 0.00 0.00 0.00 480,324.76 Disbursements 0.00 (375,681.54) (319,596.54) 0.00 0.00 0.00 (695,278.08) Ending Balance - April 30, 2007 265,941.79 345,884.42 112,727.23 18,963.15 1,036,692.21 (424,750.00) 1,355,458.80 Receipts 302,012.32 157,100.11 175,000.00 0.00 0.00 0.00 634,112.43 $300,000 Center Plate Disbursements 0.00 (300,301.48) (251,397.99) 0.00 0.00 17,875.00 (533,824.47) Ending Balance - May 31, 2007 567,954.11 202,683.05 36,329.24 18,963.15 1,036,692.21 (406,875.00) 1,455,746.76 Receipts 2,052.88 258,319.99 235,000.00 0.00 0.00 0.00 495,372.87 Disbursements 0.00 (175,451.80) (222,927.07) 0.00 0.00 0.00 (398,378.87) Ending Balance - June 30, 2007 570,006.99 285,551.24 48,402.17 18,963.15 1,036,692.21 (406,875.00) 1,552,740.76 Receipts 2,129.11 894,611.53 250,512.40 0.00 0.00 0.00 1,147,253.04 Disbursements 0.00 (360,506.98) (263,607.64) 0.00 0.00 17,875.00 (606,239.62) Ending Balance - July 31, 2007 572,136.10 819,655.79 35,306.93 18,963.15 1,036,692.21 (389,000.00) 2,093,754.18 Receipts 2,137.06 127,461.17 326,366.73 0.00 0.00 0.00 455,964.96 Disbursements 0.00 (326,326.45) (277,937.15) 0.00 0.00 0.00 (604,263.60) Ending Balance - August 31, 2007 574,273.16 620,790.51 83,736.51 18,963.15 1,036,692.21 (389,000.00) 1,945,455.54 Receipts 2,006.36 242,924.75 262,000.00 0.00 0.00 0.00 506,931.11 Disbursements 0.00 (262,541.70) (282,765.77) (4.78) 0.00 0.00 (545,312.25) Ending Balance - September 30, 2007 576,279.52 601,173.56 62,970.74 18,958.37 1,036,692.21 (389,000.00) 1,907,074.40 Receipts 102,183.73 123,262.63 270,318.50 35,112.90 11,674.13 0.00 542,551.89 $100,000 PSDA Fund 377 2007 Investment Transfers 0.00 0.00 1,044,101.45 0.00 0.00 0.00 1,044,101.45 Key Bank CD $1,044,101.45 Investment Transfers 1,048,366.34 (270,265.24) (1,044,101.45) 0.00 (1,048,366.34) 0.00 (1,314,366.69) Disbursements 0.00 0.00 (292,668.17) (40.49) 0.00 0.00 (292,708.66) Ending Balance - October 31, 2007 1,726,829.59 454,170.95 40,621.07 54,030.78 0.00 (389,000.00) 1,886,652.39 Receipts 2,939.77 167,386.49 261,000.00 23,417.40 0.00 0.00 454,743.66 Investment Transfers (1,100,000.00) (261,578.41) 0.00 0.00 1,100,000.00 0.00 (261,578.41) Horizon CD $1,100,000.00 Disbursements 0.00 0.00 (234,437.82) 0.00 0.00 17,875.00 (216,562.82) Ending Balance - November 30, 2007 629,769.36 359,979.03 67,183.25 77,448.18 111001000.00 (371,125.00) 1,863,254.82 Receipts 12,080.28 184,489.44 205,000.00 11,525.30 0.00 0.00 413,095.02 Disbursements (664.37) (205,461.54) (237,033.27) 0.00 0.00 0.00 (443,15918) Ending Balance - December 31, 2007 641,185.27 339,006.93 35,149.98 88,973.48 11100,000.00 (371,125.00) 1,833,190.66 Receipts 2,166.80 900,191.68 443,740.82 20,197.50 0.00 0.00 1,366,296.80 Hotel/Motel Tax - $748,695 Disbursements (41,347.52) (403,043.27) (424,469.01) 0.00 0.00 17,875.00 (850,984.80) $40,740.82 capital transfer Ending Balance - January 31, 2008 1 602,004.55 1 836,155.34 1 54,421.79 1 109,170.98 1 1,100,000.00 1 (353,250.00) 2,348,502.66 11 st Source CD - $1,100,000 - 2/6/08 - 3.00 Century Center Cash Summary 7/22/2014 Century Center Bank Statement Cash Summary September 30, 2006 through June 30, 2014 Updated - July 21, 2014 Key Bank Key Bank Key Bank Key Bank Certificate Capital Operating (1) A/P - Payroll Event of Deposit Old National Month Account Account Account Account Capital Loan Net Notes Receipts 14,530.36 52,843.23 265,000.00 40,438.15 0.00 0.00 372,811.74 Disbursements (447.00) (265,466.76) (205,035.48) 0.00 0.00 0.00 (470,949.24) Ending Balance - February 29, 2008 616,087.91 623,531.81 114,386.31 149,609.13 111001000.00 (353,250.00) 2,250,365.16 Receipts 13,573.68 94,605.35 238,000.00 11,246.70 0.00 0.00 357,425.73 Capital - IRS Refund $12,489.00 Transfers (2) (210,000.00) (10,000.00) 220,000.00 0.00 0.00 0.00 0.00 Transfers - reversed in April, 2008 Disbursements 0.00 (18,380.17) (315,114.71) 0.00 0.00 0.00 (23 ,494 88 Ending Balance - March 31, 2008 419,661.59 689,756.99 257,271.60 160,855.83 111001000.00 (353,250.00) 2,274,296.01 Receipts 8,497.67 165,321.94 311,356.47 27,327.20 0.00 0.00 512,503.28 Transfers - Correction (2) 210,000.00 10,000.00 (220,000.00) 0.00 0.00 0.00 0.00 Correction of March transfer Disbursements (28,011.54) (486,818.77) (309,048.09) (6,714.63) 0.00 17,875.00 (812,718.03) $28,011.54 capital expenditures approved Ending Balance - April 30, 2008 610,147.72 378,260.16 39,579.98 181,468.40 11100,000.00 (335,375.00) 1,974,081.26 Receipts 1,024.08 120,875.07 212,000.00 23,508.45 0.00 0.00 357,407.60 Disbursements 0.00 (213,314.67) (223,602.47) (24,349.20) 0.00 0.00 (461,266.34) Ending Balance - May 31, 2008 611,171.80 285,820.56 27,977.51 180,627.65 111001000.00 (335,375.00) 1,870,222.52 Receipts 1,770.34 215,496.95 311,617.65 15,706.20 0.00 0.00 544,591.14 Disbursements (68,617.65) (244,802.41) (329,142.18) (53,623.35) 0.00 0.00 (696,185.59) $68,617.65 capital expenditures approved Ending Balance - June 30, 2008 544,324.49 256,515.10 10,452.98 142,710.50 11100,000.00 (335,375.00) 1,718,628.07 Receipts 2,144.71 868,146.31 400,000.00 29,762.40 0.00 0.00 1,300,053.42 Hotel/Motel Tax - $748,695 Disbursements 0.00 (400,241.67) (366,533.00) (17,118.70) 0.00 17,875.00 (766,018.37) Ending Balance - July 31, 2008 546,469.20 724,419.74 43,919.98 155,354.20 111001000.00 (317,500.00) 2,252,663.12 Receipts 3,472.76 125,562.52 185,000.00 8,968.70 0.00 0.00 323,003.98 Disbursements 0.00 (185,491.70) (214,917.14) (30,146.15) 0.00 0.00 (430,554.99) Ending Balance - August 31, 2008 549,941.96 664,490.56 14,002.84 134,176.75 11100,000.00 (317,500.00) 2,145,112.11 Receipts 834.66 148,171.26 362,535.70 45,602.00 0.00 0.00 557,143.62 Disbursements (53,535.78) (309,261.13) (349,229.46) (460.00) 0.00 0.00 (712,486.37) $53,535.78 capital expenditures approved Ending Balance - September 30, 2008 497,240.84 503,400.69 27,309.08 179,318.75 111001000.00 (317,500.00) 1,989,769.36 Receipts 2,927.32 236,872.73 288,000.08 30,218.90 0.00 0.00 558,019.03 Disbursements 0.00 (289,939.90) (282,452.66) (91,368.80) 0.00 17,875.00 (645,886.36) Ending Balance - October 31, 2008 500,168.16 450,333.52 32,856.50 118,168.85 11100,000.00 (299,625.00) 1,901,902.03 Receipts 100,528.17 206,151.16 304,100.55 26,576.25 0.00 0.00 637,356.13 2008 PSDA - $100,000 to Capital Account Disbursements (78,100.55) (227,829.62) (324,888.93) (5,691.90) 0.00 0.00 (636,511.00) Ending Balance - November 30, 2008 522,595.78 428,655.06 12,068.12 139,053.20 111001000.00 (299,625.00) 1,902,747.16 Receipts 7,316.14 181,691.28 302,000.00 34,830.20 0.00 0.00 525,837.62 Disbursements 0.00 (303,937.55) (270,853.18) (18,162.25) 0.00 0.00 (592,952.98) Ending Balance - December 31, 2008 529,911.92 306,408.79 43,214.94 155,721.15 11100,000.00 (299,625.00) 1,835,631.80 Receipts 5,070.16 799,829.07 214,000.00 38,901.25 0.00 17,875.00 1,075,675.48 $672,825.50 Hotel /Motel Tax Receipt Disbursements 0.00 (219,083.50) (242,544.92) (12,573.10) 0.00 0.00 (474,201.52) Ending Balance - January 31, 2009 534,982.08 887,154.36 14,670.02 182,049.30 111001000.00 (281,750.00) 2,437,105.76 Receipts 200.98 89,255.74 261,171.50 28,603.45 0.00 0.00 379,231.67 Disbursements (19,171.50) (242,650.16) (206,458.94) (38,158.30) 0.00 0.00 (506,438.90) $19,171.50 capital expenditures approved Ending Balance - February 28, 2009 516,011.56 733,759.94 69,382.58 172,494.45 11100,000.00 (281,750.00) 2,309,898.53 Receipts 146.15 110,657.99 219,150.00 47,424.19 0.00 0.00 377,378.33 Disbursements 0.00 (220,996.87) (273,203.76) (31,295.39) 0.00 0.00 (525,496.02) Ending Balance - March 31, 2009 516,157.71 623,421.06 15,328.82 188,623.25 111001000.00 (281,750.00) 2,161,780.84 Receipts 1,160.14 181,943.23 232,000.00 33,953.99 0.00 0.00 449,057.36 Disbursements 0.00 (232,797.68) (232,637.50) (76,484.45) 0.00 17,875.00 (524,044.63) Ending Balance - April 30, 2009 517,317.85 572,566.61 14,691.32 146,092.79 11100,000.00 (263,875.00) 2,086,793.57 Receipts 4,470.41 120,500.63 214,000.00 32,573.95 0.00 0.00 371,544.99 Disbursements 0.00 (214,534.50) (200,700.91) (51,069.29) 0.00 0.00 (466,304.70) Ending Balance - May 31, 2009 521,788.26 478,532.74 27,990.41 127,597.45 111001000.00 (263,875.00) 1,992,033.86 Receipts 107.23 838,011.57 198,000.00 11,305.35 0.00 0.00 1,047,424.15 $672,825.50 Hotel /Motel Tax Receipt Disbursements 0.00 (198,094.97) (205,067.55) (48,984.70) 0.00 0.00 (452,147.22) Ending Balance - June 30, 2009 521,895.49 1,118,449.34 20,922.86 89,918.10 1,100,000.00 263,875.00 2,587,310.79 Century Center Cash Summary 7/22/2014 Century Center Bank Statement Cash Summary September 30, 2006 through June 30, 2014 Updated - July 21, 2014 Key Bank Key Bank Key Bank Key Bank Certificate Capital Operating (1) A/P - Payroll Event of Deposit Old National Month Account Account Account Account Capital Loan Net Notes Receipts 818.49 107,274.56 266,000.00 12,923.50 0.00 0.00 387,016.55 Disbursements (15.00) (266,401.35) (269,480.09) (14,642.10) 0.00 17,875.00 (532,663.54) Ending Balance - July 31, 2009 522,698.98 959,322.55 17,442.77 88,199.50 111001000.00 (246,000.00) 2,441,663.80 Receipts 100,336.88 163,609.70 206,000.00 5,405.60 0.00 0.00 475,352.18 2009 PSDA - $100,000 to Capital Account Disbursements 0.00 (306,188.77) (173,884.21) (5,603.50) 0.00 0.00 (485,676.48) Ending Balance - August 31, 2009 623,035.86 816,743.48 49,558.56 88,001.60 111001000.00 (246,000.00) 2,431,339.50 Receipts 128.03 95,099.71 215,000.00 16,372.78 0.00 0.00 326,600.52 Disbursements 0.00 (215,715.07) (228,978.30) (24,674.50) 0.00 0.00 (469,367.87) Ending Balance- September 30, 2009 623,163.89 696,128.12 35,580.26 79,699.88 11100,000.00 (246,000.00) 2,288,572.15 Receipts 57,523.63 107,260.11 299,000.00 20,296.50 0.00 0.00 484,080.24 Capital Account - $53,875 CD's redeemed and Disbursements (53,976.75) (299,998.96) (316,787.74) 0.00 0.00 17,875.00 (652,888.45) reinvested Ending Balance - October 31, 2009 626,710.77 503,389.27 17,792.52 99,996.38 111001000.00 (228,125.00) 2,119,763.94 Receipts 303,664.11 141,350.41 212,000.00 24,936.76 0.00 0.00 681,951.28 Disbursements (300,000.00) (212,577.28) (189,068.36) 0.00 0.00 0.00 (701,645.64) $300,000 capital CD redeemed & reinvested Ending Balance - November 30, 2009 630,374.88 432,162.40 40,724.16 124,933.14 11100,000.00 (228,125.00) 2,100,069.58 Receipts 24.66 183,157.13 267,449.14 8,272.60 0.00 0.00 458,903.53 Investment Transfers (200,000.00) 0.00 0.00 0.00 200,000.00 0.00 0.00 $200,000 transferred to 1st Source CD Disbursements (32,481.04) (235,780.68) (284,351.55) (24,495.19) 0.00 0.00 (577,108.46) Ending Balance - December 31, 2009 397,918.50 379,538.85 23,821.75 108,710.55 1,300,000.00 (228,125.00) 1,981,864.65 Receipts 2,784.66 764,226.99 250,268.80 39,036.30 0.00 0.00 1,056,316.75 Hotel/Motel Tax - $656,576.00 Disbursements (33,273.30) (218,206.45) (247,022.60) (14,007.19) 0.00 17,875.00 (494,634.54) $33.268.80 - Capital Transfer Ending Balance - January 31, 2010 367,429.86 925,559.39 27,067.95 133,739.66 1,300,000.00 (210,250.00) 2,543,546.86 Receipts 850.67 65,279.35 357,065.78 23,028.50 0.00 0.00 446,224.30 Disbursements (13 ,068 52 (226,875.32) (315,994.54) (16,806.60) 0.00 0.00 (690,744.98) $131,065.78 - Capital Transfer 215/10 Ending Balance - February 28, 2010 237,212.01 763,963.42 68,139.19 139,961.56 1,300,000.00 (210,250.00) 2,299,026.18 Receipts 10.03 80,917.11 234,196.00 101,695.55 0.00 0.00 416,818.69 Disbursements (27,198.80) (208,189.92) (236,495.07) (9,330.50) 0.00 0.00 (481,214.29) $27,196.00 Capital Transfer 3/31/10 Ending Balance - March 31, 2010 210,023.24 636,690.61 65,840.12 232,326.61 1,300,000.00 (210,250.00) 2,234,630.58 Receipts 1,545.78 189,164.13 227,798.01 32,611.03 0.00 0.00 451,118.95 CD's Redeemed 1,107,875.00 0.00 0.00 0.00 (1,107,875.00) 0.00 0.00 CD's redeemed in April, 2010 - $1,107,875.00 Disbursements (8.23) (227,740.92) (240,549.92) (134,287.70) 0.00 17,875.00 (584,711.77) Ending Balance - April 30, 2010 1,319,435.79 598,113.82 53,088.21 130,649.94 192,125.00 (192,375.00) 2,101,037.76 Receipts 38.63 102,526.72 222,000.00 32,113.56 0.00 0.00 356,678.91 CD's Purchased (907,625.00) 0.00 0.00 0.00 907,625.00 0.00 0.00 CD's purchased - Horizon Bank Disbursements (75.81) (222,336.15) (211,101.02) (41,315.50 0.00 0.00 (474,828.48) Ending Balance - May 31, 2010 411,773.61 478,304.39 63,987.19 121,448.00 1,099,750.00 (192,375.00) 1,982,888.19 Receipts 15.58 151,204.34 222,741.68 13,866.32 0.00 0.00 387,827.92 Disbursements (33,746.04) (18 ,247 41 (264,784.72) (46,753.75) 0.00 0.00 (534,531.92) $33,741.68 Capital Transfer 6/2/10 Ending Balance - June 30, 2010 378,043.15 440,261.32 21,944.15 88,560.57 1,099,750.00 (192,375.00) 1,836,184.19 Receipts 100,650.05 757,013.78 282,000.00 11,909.30 0.00 0.00 1,151,573.13 2010PSDA- $100,OOO, Hotel/Motel - $656,576 CD's Redeemed 925,625.00 0.00 0.00 0.00 (925,625.00) 0.00 0.00 Horizon Bank - $907,625, Old Nat - $18,000 Disbursements 0.00 (282,438.20) (266,741.43) (10,725.95) 0.00 17,875.00 (542,030.58) Ending Balance - July 31, 2010 1,404,318.20 914,836.90 37,202.72 89,743.92 174,125.00 (174,500.00) 2,445,726.74 Receipts 59.23 96,122.97 210,492.30 11,469.64 0.00 0.00 318,144.14 Disbursements (10,492.30) (200,298.17) (222,383.37) (24,262.60) 0.00 0.00 (457,436.44) $10,492.30 Capital Transfer 8/5/10 Ending Balance - August 31, 2010 1,393,885.13 810,661.70 25,311.65 76,950.96 174,125.00 (174,500.00) 2,306,434.44 Receipts 57.22 88,729.87 203,087.00 17,491.10 0.00 0.00 309,365.19 Disbursements (22,087.00) (181,595.16) (192,026.74) (17,305.19) 0.00 0.00 (413,014.09) $22,087.00 Capital Transfer 9/29/10 Ending Balance - September 30, 2010 1,371,855.35 717,796.41 36,371.91 77,136.87 174,125.00 (174,500.00) 2,202,785.54 Receipts 58.26 89,504.01 239,000.00 15,021.00 0.00 0.00 343,583.27 Disbursements 0.00 (239,317.99) (237,116.09) (6,536.65) 0.00 17,875.00 (465,095.73) Ending Balance- October 31, 2010 1,371,913.61 567,982.43 38,255.82 85,621.22 174,125.00 (156,625.00) 2,081,273.08 Receipts 2,017.52 146,698.31 236,870.83 47,833.25 0.00 0.00 433,419.91 Century Center Cash Summary 7/22/2014 4 Century Center Bank Statement Cash Summary September 30, 2006 through June 30, 2014 Updated - July 21, 2014 Key Bank Key Bank Key Bank Key Bank Certificate Capital Operating (1) A/P - Payroll Event of Deposit Old National Month Account Account Account Account Capital Loan Net Notes Disbursements (28,870.83) (208,352.08) (224,845.02) 0.00 0.00 0.00 (462,067.93) $28,870.83 Capital Transfer 11/09/10 Ending Balance - November 30, 2010 1,345,060.30 506,328.66 50,281.63 133,454.47 174,125.00 (156,625.00) 2,052,625.06 Receipts 54.94 212,311.22 586,680.61 77,888.89 0.00 0.00 876,935.66 $31,385.27 Capital Transfer 12123/10 Disbursements (81,680.61) (505,946.70) (556,062.71) (107,700.05) 0.00 156,625.00 (1,094,765.07) $50,295.34 Capital Transfer 12/06/10 Ending Balance - December 31, 2010 1,263,434.63 212,693.18 80,899.53 103,643.31 174,125.00 0.00 1,834,795.65 $157,147.73 Old National loan payoff Receipts 139.50 804,986.04 261,063.37 25,880.50 0.00 0.00 1,092,069.41 $656,718.00 hotel /motel tax revenue (50%) Investment Transfers 174,125.00 0.00 0.00 0.00 (174,125.00) 0.00 0.00 Old National CD matured, deposited to capital Disbursements (70,592.98) (218,344.99) (314,202.24) (24,997.99) 0.00 0.00 (628,138.20) $70,592.98 Capital Transfer 1/12/11 Ending Balance - January 31, 2011 1,367,106.15 799,334.23 27,760.66 104,525.82 0.00 0.00 2,298,726.86 Receipts 52.35 110,294.40 252,386.25 42,266.88 0.00 0.00 404,999.88 Disbursements (3,386.25) (249,497.36) (223,989.90) (22,568.30) 0.00 0.00 (499,441.81) $3,386.25 Capital Transfer 2/11/11 Ending Balance - February 28, 2011 1,363,772.25 660,131.27 56,157.01 124,224.40 0.00 0.00 2,204,284.93 Receipts 56.78 111,966.43 244,821.41 96,706.95 0.00 0.00 453,551.57 Disbursements (40,821.41) (205,261.45) (266,186.20) (21,487.28) 0.00 0.00 (533,756.34) Capital transfers - $35,297.78 & $5,523.63 Ending Balance - March 31, 2011 1,323,007.62 566,836.25 34,792.22 199,444.07 0.00 0.00 2,124,080.16 Receipts 100,056.01 63,543.60 193,288.98 34,825.80 0.00 0.00 391,714.39 2011 PSDA - $100,000 - deposited 4/18/11 Disbursements 0.00 (194,061.62) (198,892.31) 0.00 0.00 0.00 (392,953.93) Ending Balance - April 30, 2011 1,423,063.63 436,318.23 29,188.89 234,269.87 0.00 0.00 2,122,840.62 Receipts 60.22 212,075.93 206,931.25 13,586.50 0.00 0.00 432,653.90 Disbursements (7,931.25) (199,547.31) (215,943.26) (159,803.20) 0.00 0.00 (583,225.02) Capital transfers - $7,931.25 - 5/12/11 Ending Balance - May 31, 2011 1,415,192.60 448,846.85 20,176.88 88,053.17 0.00 0.00 1,972,269.50 Receipts 56.61 836,264.15 321,615.92 67,678.93 0.00 0.00 1,225,615.61 $656,718 hotel /motel tax - 6/8/11 Disbursements (53,615.92) (268,432.99) (243,021.25) (75,856.42) 0.00 0.00 (640,926.58) Capital transfers - $53,615.92 - 6/10/11 Ending Balance - June 30, 2011 1,361,633.29 1,016,678.01 98,771.55 79,875.68 0.00 0.00 2,556,958.53 Receipts 57.76 103,808.62 167,036.15 12,561.05 0.00 0.00 283,463.58 Disbursements (3,036.15) (166,013.92) (252,968.25) (18,560.10) 0.00 0.00 (440,578.42) Capital transfers - $3,036.15 - 7/15/11 Ending Balance - July 31, 2011 1,358,654.90 954,472.71 12,839.45 73,876.63 0.00 0.00 2,399,843.69 Receipts 31.75 61,175.27 210,190.51 6,620.35 0.00 0.00 278,017.88 Investment Transfers (900,000.00) 0.00 0.00 0.00 900,000.00 0.00 0.00 Lake City CD - matures 12110/11 Disbursements (1,215.51) (210,105.60) (198,767.67) (5,663.42) 0.00 0.00 (415,752.20) Capital transfer- $1,190.51 - 8/2/11 Ending Balance - August 31, 2011 457,471.14 805,542.38 24,262.29 74,833.56 900,000.00 0.00 2,262,109.37 Receipts 18.64 71,780.30 201,008.14 15,151.95 0.00 0.00 287,959.03 Disbursements (8,008.14) (193,715.52) (201,436.83) (11,245.17) 0.00 0.00 (414,405.66) Capital transfer - $8,008.14 - 9/16/11 Ending Balance - September 30, 2011 449,481.64 683,607.16 23,833.60 78,740.34 900,000.00 0.00 2,135,662.74 Receipts 19.09 149,592.64 203,600.00 22,647.75 0.00 0.00 375,859.48 Disbursements 0.00 (204,242.35) (211,921.44) (19,379.19) 0.00 0.00 (435,542.98) Ending Balance - October 31, 2011 449,500.73 628,957.45 15,512.16 82,008.90 900,000.00 0.00 2,075,979.24 Receipts 18.47 156,769.60 205,000.00 41,863.35 0.00 0.00 403,651.42 Disbursements 0.00 (205,818.96) (181,251.02) (24,013.58) 0.00 0.00 (411,083.56) Ending Balance - November 30, 2011 449,519.20 579,908.09 39,261.14 99,858.67 900,000.00 0.00 2,068,547.10 Receipts 926.24 177,985.33 273,388.24 117,472.32 0.00 0.00 569,772.13 Investment Transfers 900,000.00 0.00 0.00 0.00 (900,000.00) 0.00 0.00 Lake City CD - matured 12/10/11 Disbursements (6,388.24) (267,671.45) (280,715.26) (111,129.50) 0.00 0.00 (665,904.45) Capital transfer - $6,388.24 - 12/02/11 Ending Balance - December 31, 2011 1,344,057.20 490,221.97 31,934.12 106,201.49 0.00 0.00 1,972,414.78 Receipts 56.92 748,591.32 172,000.00 25,630.50 0.00 0.00 946,278.74 Hotel /Motel - $656,718.00 - 1/20112 Disbursements 0.00 (172,135.09) (193,998.20) (19,725.60) 0.00 0.00 (385,858.89) Ending Balance - January 31, 2012 1,344,114.12 1,066,678.20 9,935.92 112,106.39 0.00 0.00 2,532,834.63 Receipts 53.26 94,841.79 218,000.00 27,732.20 0.00 0.00 340,627.25 Disbursements 0.00 (218,436.80) (208,693.39) (13,840.57) 0.00 0.00 (440,970.76) Ending Balance - February 29, 2012 1,344,167.38 943,083.19 19,242.53 125,998.02 0.00 0.00 2,432,491.12 Receipts 53.98 124,814.80 218,500.00 64,115.26 0.00 0.00 407,484.04 Disbursements 0.00 (218,936.30) (199,140.56) (13,187.92) 0.00 0.00 (431,264.78) Ending Balance - March 31, 2012 1,344,221.36 848,961.69 38,601.97 176,925.36 0.00 0.00 2,408,710.38 Century Center Cash Summary 7/22/2014 Century Center Bank Statement Cash Summary September 30, 2006 through June 30, 2014 Updated - July 21, 2014 Key Bank Key Bank Key Bank Key Bank Certificate Capital Operating (1) A/P - Payroll Event of Deposit Old National Month Account Account Account Account Capital Loan Net Notes Receipts 100,028.03 157,841.38 338,485.00 33,473.60 0.00 0.00 629,828.01 2012 PSDA revenue - $100,000.00 - 4/3/12 Disbursements (134,485.00) (205,585.18) (354,223.14) (87,879.79) 0.00 0.00 (782,173.11) Capital transfer - $134,485.00 - 4/4112 - chairs Ending Balance - April 30, 2012 1,309,764.39 801,217.89 22,863.83 122,519.17 0.00 0.00 2,256,365.28 Receipts 22.19 201,886.20 290,000.00 13,339.00 0.00 0.00 505,247.39 Disbursements 0.00 (290,751.68) (287,972.27) (36,602.85) 0.00 0.00 (615,326.80) Ending Balance - May 31, 2012 1,309,786.58 712,352.41 24,891.56 99,255.32 0.00 0.00 2,146,285.87 Receipts 21.47 770,352.87 209,764.00 17,927.81 0.00 0.00 998,066.15 $656,718 hotel /motel tax - 6/29/12 Disbursements 0.00 (211,016.95) (213,349.61) (28,270.25) 0.00 0.00 (452,636.81) Ending Balance - June 30, 2012 1,309,808.05 1,271,688.33 21,305.95 88,912.88 0.00 0.00 2,691,715.21 Receipts 22.12 112,499.33 210,340.00 9,324.80 0.00 0.00 332,186.25 Disbursements (21,340.00) (18 ,928 86 (223,919.06) (24,495.80) 0.00 0.00 (459,683.72) Capital transfer - $21,340.00 - 7131/12 - lighting Ending Balance - July 31, 2012 1,288,490.17 1,194,258.80 7,726.89 73,741.88 0.00 0.00 2,564,217.74 Receipts 21.82 77,230.81 209,550.00 33,826.25 0.00 0.00 320,628.88 Disbursements 0.00 (209,703.83) (201,170.60) (14,478.05) 0.00 0.00 (425,352.48) Ending Balance - August 31, 2012 1,288,511.99 1,061,785.78 16,106.29 93,090.08 0.00 0.00 2,459,494.14 Receipts 21.01 114,360.28 195,508.45 16,459.19 0.00 0.00 326,348.93 Disbursements (8,508.45) (18 ,788 34 (202,181.55) (22,227.87) 0.00 0.00 (420,706.21) Capital transfer - $8,508.45- 9/07/12 - lighting Ending Balance - September 30, 2012 1,280,024.55 988,357.72 9,433.19 87,321.40 0.00 0.00 2,365,136.86 Receipts 21.65 108,825.26 209,811.25 30,082.70 0.00 0.00 348,740.86 Disbursements (5,211.25) (204,769.72) (209,988.03) 0.00 0.00 0.00 (419,969.00) Capital transfer - $5,211.25 - 10/18/12 - lighting Ending Balance - October 31, 2012 1,274,834.95 892,413.26 9,256.41 117,404.10 0.00 0.00 2,293,908.72 Receipts 20.90 222,529.99 243,000.00 17,760.05 0.00 0.00 483,310.94 Disbursements 0.00 (246,026.22) (210,661.06) (51,049.11) 0.00 0.00 (507,736.39) Ending Balance - November 30, 2012 1,274,855.85 868,917.03 41,595.35 84,115.04 0.00 0.00 2,269,483.27 Receipts 21.59 95,550.24 183,500.00 30,937.30 0.00 0.00 310,009.13 Disbursements 0.00 (184,731.83) (213,843.32) (29.76) 0.00 0.00 (398,604.91) Ending Balance - December 31, 2012 1,274,877.44 779,735.44 11,252.03 115,022.58 0.00 0.00 2,180,887.49 Receipts 100,022.04 799,825.99 189,000.00 51,115.09 0.00 0.00 1,139,963.12 $100,000 PSDA, $656,718 hotel /motel tax Disbursements 0.00 (190,829.54) (192,998.52) (21,746.26) 0.00 0.00 (405,574.32) Ending Balance - January 31, 2013 1,374,899.48 1,388,731.89 7,253.51 144,391.41 0.00 0.00 2,915,276.29 Receipts 21.10 127,932.61 246,289.06 35,551.14 0.00 0.00 409,793.91 Disbursements 0.00 (247,801.41) (236,543.51) (19,120.50) 0.00 0.00 (503,465.42) Ending Balance - February 28, 2013 1,374,920.58 1,268,863.09 16,999.06 160,822.05 0.00 0.00 2,821,604.78 Receipts 23.35 115,846.35 248,600.00 59,648.57 0.00 0.00 424,118.27 Disbursements 0.00 (249,167.84) (249,478.81) (20,481.65) 0.00 0.00 (519,128.30) Ending Balance - March 31, 2013 1,374,943.93 1,135,541.60 16,120.25 199,988.97 0.00 0.00 2,726,594.75 Receipts 22.60 75,931.20 225,000.00 20,852.20 0.00 0.00 321,806.00 Disbursements 0.00 (226,584.81) (227,394.04) 0.00 0.00 0.00 (453,978.85) Ending Balance - April 30, 2013 1,374,966.53 984,887.99 13,726.21 220,841.17 0.00 0.00 2,594,421.90 Receipts 23.36 111,302.34 267,047.12 24,893.68 0.00 0.00 403,266.50 Disbursements 0.00 (267,861.87) (234,882.39) 0.00 0.00 0.00 (502,744.26) Ending Balance - May 31, 2013 1,374,989.89 828,328.46 45,890.94 245,734.85 0.00 0.00 2,494,944.14 Receipts 22.60 748,674.23 331,000.00 15,904.40 0.00 0.00 1,095,601.23 $656,718 hotel /motel tax rcd 6/21/2013 Disbursements 0.00 (332,662.04) (287,565.49) 0.00 0.00 0.00 (620,227.53) Ending Balance - June 30, 2013 1,375,012.49 1,244,340.65 89,325.45 261,639.25 0.00 0.00 2,970,317.84 SMG New manager 7/1/2013 Receipts 23.36 140,163.94 133,000.00 50,996.02 0.00 0.00 324,183.32 Disbursements 0.00 (149,636.54) (213,956.14) (11.87) 0.00 0.00 (363,604.55) Ending Balance - July 31, 2013 1,375,035.85 1,234,868.05 8,369.31 312,623.40 0.00 0.00 2,930,896.61 Receipts 575,029.02 95,176.24 412,248.40 48,802.09 0.00 0.00 1,131,255.75 SMG Capital Contribution - $575,000 - 8/13/13 Disbursements 0.00 (412,189.60) (347,913.30) (21.75) 0.00 0.00 (16q, 124 65) Ending Balance - August 31, 2013 1,950,064.87 917,854.69 72,704.41 361,403.74 0.00 0.00 3,302,027.71 Receipts 32.06 384,542.90 266,000.00 81,812.63 0.00 0.00 732,387.59 Disbursements 0.00 (266,363.77) (282,771.45) (300,050.50) 0.00 0.00 (849,185.72) Century Center Cash Summary 7/22/2014 Century Center Bank Statement Cash Summary September 30, 2006 through June 30, 2014 Updated - July 21, 2014 Key Bank Key Bank Key Bank Key Bank Certificate Capital Operating (1) A/P - Payroll Event of Deposit Old National Month Account Account Account Account Capital Loan Net Notes Ending Balance - September 30, 2013 1,950,096.93 1,036,033.82 55,932.96 143,165.87 0.00 0.00 3,185,229.58 Receipts 32.66 188,426.94 498,570.14 193,864.57 0.00 0.00 880,894.31 Disbursements (30,636.59) (456,462.97) (540,304.89) (1,545.90) 0.00 0.00 (1,028,950.35) Capital account transfers - $30,636.59 Ending Balance - October 31, 2013 1,919,493.00 767,997.79 14,198.21 335,484.54 0.00 0.00 3,037,173.54 Receipts 31.55 157,548.98 356,000.00 48,097.51 0.00 0.00 561,678.04 Disbursements 0.00 (356,898.51) (348,837.55) (11.60) 0.00 0.00 (705,747.66) Ending Balance - November 30, 2013 1,919,524.55 568,648.26 21,360.66 383,570.45 0.00 0.00 2,893,103.92 Receipts 31.68 410,792.35 428,631.87 109,427.83 0.00 0.00 948,883.73 Disbursements (161,858.87) (266,201.40) (319,690.06) (300,384.45) 0.00 0.00 (1,048,134.78) Three Capital account transfers - $161,858.87 Ending Balance - December 31, 2013 1,757,697.36 713,239.21 130,302.47 192,613.83 0.00 0.00 2,793,852.87 Receipts 29.85 101,422.67 421,423.70 40,495.71 0.00 0.00 563,371.93 Disbursements 0.00 (419,737.72) (464,453.06) (25.20) 0.00 0.00 (884,215.98) Ending Balance - January 31, 2014 1,757,727.21 394,924.16 87,273.11 233,084.34 0.00 0.00 2,473,008.82 Receipts 26.97 774,640.47 461,284.83 114,336.46 0.00 0.00 1,350,288.73 Hotel /Motel tax deposit of $656,725.00 Disbursements 0.00 (460,415.80) (466,553.59) (24.40) 0.00 0.00 (926,993.79) Ending Balance- February 28, 2014 1,757,754.18 709,148.83 82,004.35 347,396.40 0.00 0.00 2,896,303.76 Receipts 29.86 464,972.72 340,184.60 47,070.34 0.00 0.00 852,257.52 Disbursements 0.00 (341,087.20) (359,076.67) (300,022.60) 0.00 0.00 (1,000,186.47) Event accounttransferto Operating account Ending Balance - March 31, 2014 1,757,784.04 833,034.35 63,112.28 94,444.14 0.00 0.00 2,748,374.81 Receipts 28.89 112,506.06 302,388.81 23,158.01 0.00 0.00 438,081.77 Disbursements 0.00 (301,144.90) (309,555.81) (130.45) 0.00 0.00 ( 610, 831.16) Operating account transfer to Payroll /AP account Ending Balance - April 30, 2014 1,757,812.93 644,395.51 55,945.28 117,471.70 0.00 0.00 2,575,625.42 Receipts 29.86 409,269.06 572,096.86 97,304.13 0.00 0.00 1,078,699.91 Disbursements 0.00 (573,580.19) (526,323.86) (200,011.00) 0.00 0.00 (1,299,915.05) Operating account transfer to Payroll /AP account Ending Balance - May 31, 2014 1,757,842.79 480,084.38 101,718.28 14,764.83 0.00 0.00 2,354,410.28 Receipts 28.90 149,402.06 443,434.70 97,800.47 0.00 0.00 690,666.13 Disbursements 0.00 (443,788.17) (372,049.93) (554.18) 0.00 0.00 (816,392.28) Operating account transfer to Payroll /AP account Ending Balance - June 30, 2014 1,757,871.69 185,698.27 173,103.05 112,011.12 0.00 0.00 2,228,684.13 (1) Set up new account during March 31, 2008. Transfer from old account. (2) Errors in account transfers between bank accounts. Net effect is zero. These have been reversed in April, 2008. Century Center Cash Summary 7/22/2014 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $0 Century Center Bank Balances Net of Old National Loan 9/30/06 to 6/30/14 - Bar Chart O�000\oo X01 ^�01'110�010�014� �O� boo �oo0\O�D\000 �oo000\000\0000 ^O OD\�OD\ ^O N �,^��^ ^flj ^rV r� �,r�D\ ,r�D\�� Century Center Cash Summary 7/22/2014 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $0 ,0, N�6' N� ", I P" N�Z) N��� 0��0 N�Z5 N��� 0�' ���� �� ^� (P �� ^^ ���^ Off^^ N�' �� O� ^� N,!) � O� ^� � � Century Center Bank Balances Net of Old National Loan 9/30/06 to 6130/14 - Line Chart Century Center Cash Summary 7/22/2014 $3,500,000.00 $3,000,000.00 $2,500,000.00 $2,000,000.00 $1,500,000.00 $1,000,000.00 $500,000.00 $0.00 Bank Statement Balances Net of Old National Loan June 30, 2007 - June 30, 2014 06/30/2007 06/30/2008 06/30/2009 06/30/2010 06/30/2011 06/30/2012 06/30/2013 06/30/2014 Bank Statement Cash Balances less outstanding Old National Loan principal: Note: Hotel /motel tax revenue was received in June during 2009, 2011, 2012 and 2013. Hotel /motel tax revenue was received in July during 2007, 2008, 2010 and 2014. Hotel /motel tax revenue is usually received in January but was received in February 2014. Century Center Cash Summary 7/22/2014 10 Annual Cumulative Percent Percent Amount Change Change 06/30/2007 $1,552,740.76 - - 06/30/2008 1,718,628.07 10.68% 10.68% 06/30/2009 2,587,310.79 50.55% 66.63% 06/30/2010 1,836,184.19 - 29.03% 18.25% 06/30/2011 2,556,958.53 39.25% 64.67% 06/30/2012 2,691,715.21 5.27% 73.35% 06/30/2013 2,970,317.84 10.35% 91.30% 06/30/2014 2,228,684.13 - 24.97% 43.53% Note: Hotel /motel tax revenue was received in June during 2009, 2011, 2012 and 2013. Hotel /motel tax revenue was received in July during 2007, 2008, 2010 and 2014. Hotel /motel tax revenue is usually received in January but was received in February 2014. Century Center Cash Summary 7/22/2014 10