The URL can be used to link to this page

310487 04/24/1 CITY OF CARMEL, INDIANA VENDOR: 071300 ONE CIVIC SQUARE C. L. COONROD&COMPANY CHECK AMOUNT: $****29,736.00' r° CARMEL, INDIANA 46032 3850 PRIORITY WAY SOUTH DRIVE CHECK NUMBER: 310487 +y SUITE 225 CHECK DATE: 04/24/17 INDIANAPOLIS IN 46240 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1160 4340303 100303 0317-E 13,723.00 ACCOUNTING SERVICES 1160 4340303 34499 0417A 4,744.00 ACCTG SERVICES FOR 20 1160 4340303 100303 0417-A 11,269.00 ACCOUNTING SERVICES w w \ C, ov O / O Lo w 0 U 2 e• J � 0 0 �o m ' r � 0 . Q w - to m m 110 a: W. o 0 2 w 0 m � \ m k E D. « 0) c Q o F 2 E v 0 o • w o 0 X27 $ 17 0 e a < / f D CD * \� \ \ \ _0 \ \ (Q § § / / \ \ Drt. » < K u u r- H. ¥_ 5 � m q 0 � / 2 �w � C C § O @ % / � u M § \ ]_ / / j ~ » Cl� � m 4 q m = o g c (D �_ \ l ° - § » k �� CD k \ § � m _. » \� $ CD rl) \ § = a . 2 / / k k = / � = CL 0 o Q CR a = o m a k » $ CL a) q ƒ N)w 0- J » @ cn 3 cr ; 2 m a INVOICE 0417-A P.O.100303 Board of Works City of Carmel Attn:Sharon Kibbe One Civic Square Carmel,IN 46032 Make check payable to: Tax ID#35-1985559 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 45240 April 18,2017 Professional services from April 1 through April 15,2017,in connection with: 2016 CAFR: Enterprise Funds 1,678 Finalize and Reconcile Statements 1,989 MD&A 1,503 Introductory Section,CAFR Prep 166 Statistical Section 440 Subtotal. 5,776 Publishing&printing - Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17,2017. ($68,000) 5,776 Work outside scope-explanation requested by CT office for difference in accounting method for R&E statements vs budgetary statements,follow up on utility statements-net investment calculation late-net position out of balance in both utilities-follow up on Water economic gain from refunding,further explanation to CT office as to need for different bases of accounting for different statements and need for disclosure of differences,utility balancing issues,respond to SBOA regarding 2015 statements updated for new Capital assets data,follow up on and receive revised 2015 Capital assets data, follow up on GAAP disclosures needed from utilities-receive revised statements from utility and inquire about treatment of utility management fees,work on utility update for items received in condition requiring edits,resume discussion of accounting for management fees in arrears,rework Capital assets ledger to include changes just received- update statements and disclosures-prepare CAFR with changes,review CAFR with revised Capital assets data and other revisions supplied by client,discussion with utility accountant regarding treatment of gain on bond renegotiation,follow up on delivery of 2015 CAFR to auditors,utility cash flow statement out of balance-problems with classification of transfers on water and sewer statement,email regarding out of balance statement,review net investment calculation in view of new cap assets data. 5,493 Total amount of this invoice. 11,269 Previous balance. 33,936 Payment received. (23,437) Total amount due. $ 21,768 Payable upon receipt. Call(317)844-4605 with questions. City of Carmel 2016 CAM Time Budget Total in CLC BWR SLL ELH Total January February March AR!2 Future Set up initial TB 240 1240 1480 956 480 1071 0 2507 0 Trust cash 960 2640 620 4220 276 4641 2964 0 7881 0 AR-property tax 240 700 940 0 599 419 0 1018 AR-income tax 240 220 700 1160 0 473 1125 0 1598 AR-ambulance 240 220 460 0 140 464 0 604 AR-medicaid supplemental 240 220 460 0 396 433 0 829 Capital assets 240 1400 1640 0 1483 280 0 1763 Capital leases 240 700 940 0 0 244 0 244 Accounts payable 240 220 1240 1700 388 3346 290 0 4024 Accrued wage 240 220 775 1235 0 469 35 0 504 Compensated absenses 240 220 620 1080 84 272 490 0 846 Bond premium,deferred rev 240 2100 2340 0 1003 1219 0 2222 Bond principal,debt disclosure 240 2100 2340 0 0 2177 0 2177 2016 bond issues 1920 2800 4720 132 1628 4611 0 6371 Local pensions 720 1050 1770 0 787 1397 0 2184 PERS pensions 720 1400 2120 36 1564 2776 0 4376 OPEB 720 2100 2820 48 148 2615 0 2811 Enterprise funds 3840 3840 60 0 849 1678 2587 GASB 77 0 0 0 0 0 348 888 1331 0 2567 Net investment in capital assets 480 1050 1530 0 84 312 0 396 MDBA 480 1400 1880 0 814 446 1503 2763 Budgetary statements 240 2480 2720 0 101 2875 0 2976 Finalize and reconcile statements 2880 700 3580 0 0 7376 1989 9365 GFOA checklist 1440 350 1790 0 0 155 0 155 Introductory section,CAM prep 240 1050 1290 0 376 901 166 1443 Statistical section 480 2100 2580 140 1075 193 440 1848 Responses to Auditors 3840 440 2800 310 7390 96 1147 552 0 1795 Total 21840 4400 24500 7285 58025 2564 21914 37600 5776 67854 Work outside of Scope 0 0 0 0 0 180 1849 8888 5493 16410 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 2744 23763 46488 11269 84264 Rates 250 230 175 155 197.71 192.56 243.35 197.40 198.75 208.52 Hours 104.83 22.96 168.00 56.40 352.19 14.25 97.65 235.50 56.70 404.10 INVOICE 0317-E P.O.100303 Board of Works City of Carmel Attn:Sharon Kibbe One Civic Square Carmel,IN 46032 Make check payable to: Tax ID#35-1985559 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 April 6,2017 Professional services from March 27 through March 31,2017,in connection with: 2016 CAFR: 2016 Bonds $ 551 Accounts Payable 105 AR-Medicaid Supplemental 151 Bond Principal,Debt Disclosure 1,147 Budgetary Statements 963 Capital Leases 120 Enterprise Funds 163 Finalize and Reconcile Statements 6,296 Local Pensions 560 Introductory Section,CAFR Prep 315 Net Investment in Capital Assets 312 Response to Auditors 240 Setup Trial Balance 54 Trust Cash 77 Subtotal. 11,054 Out of pocket expense-mileage - Subtotal,work within the scope of our engagement letter dated January 17,2017. ($68,000) 11,054 Work outside scope-public records requests for bank statements and capital leases,CT questions regarding transmittal letter and 4CDC statements,adjustment for Art Fund transfers-in in General Fund,CT request for enterprise fund documents,update capital assets for data revisions,adjust capital assets worksheet,make CAFR adjustments and disclosure for change in capital asset data. 2,669 Total amount of this invoice. 13,723 Previous balance. 33,936 Payment received. - Total amount due. $ 47,659 Payable upon receipt. Call(317)844-4605 with questions. City of Carmel 2016 CAFR Time Budget Total in CLC BWR SLL ELH Total January February March Future Set up initial TB 240 1240 1480 956 480 1071 2507 0 Trust cash 960 2640 620 4220 276 4641 2964 7881 0 AR-property tax 240 700 940 0 599 419 1018 AR-income tax 240 220 700 1160 0 473 1125 1598 AR-ambulance 240 220 460 0 140 464 604 AR-medicaid supplemental 240 220 460 0 396 433 829 Capital assets 240 1400 1640 0 1483 280 1763 Capital leases 240 700 940 0 0 244 244 Accounts payable 240 220 1240 1700 388 3346 290 4024 Accrued wage 240 220 775 1235 0 469 35 504 Compensated absenses 240 220 620 1080 84 272 490 846 Bond premium,deferred rev 240 2100 2340 0 1003 1219 2222 Bond principal,debt disclosure 240 2100 2340 0 0 2176 2176 2016 bond issues 1920 2800 4720 132 1628 4611 6371 Local pensions 720 1050 1770 0 787 1397 2184 PERS pensions 720 1400 2120 36 1564 2776 4376 OPEB 720 2100 2820 48 148 2615 2811 Enterprise funds 3840 3840 60 0 849 909 GASB 77 0 0 0 0 0 348 888 1331 2567 Net investment in capital assets 480 1050 1530 0 84 312 396 MDBA 480 1400 1880 0 814 446 1260 Budgetary statements 240 2480 2720 0 101 2875 2976 Finalize and reconcile statements 2880 700 3580 0 0 7375 7375 GFOA checklist 1440 350 1790 0 0 155 155 Introductory section,CAFR prep 240 1050 1290 0 376 901 1277 Statistical section 480 2100 2580 140 1075 193 1408 Responses to Auditors 3840 440 2800 310 7390 96 1147 552 1795 Total 21840 4400 24500 7285 58025 2564 21914 37598 62076 Work outside of Scope 0 0 0 0 0 180 1849 8890 10919 20%contingency 4368 880 4900 1457 11605 Total with contingency 26208 5280 29400 8742 69630 2744 23763 46488 72995 Rates 250 230 175 155 197.71 192.56 243.35 197.40 210.12 Hours 104.83 22.96 168.00 56.40 352.19 14.25 97.65 235.50 347.40 2 � n $ « 2 - / M3 O o g r CL 0 2 � � > $ 2 \ 2 { p o g 2 o K k o O g 2 » o \ � c & o > w k . ; C T f c > CP -n > 2 ] O O » L CD _0 S > k D CL �_ # 2 2 z 2 / f K -n p j k § | # § K §_ E � f f & r / / k k E = o m x ƒ e j ; s ; o / / k _ 3 z § e B CL » 7 + - C J @ $ CD q CD k CD = _ a ■ _5 o Ea ° R7 CD [\ CL t(D guog B 2 k CL $ ■ i G ° ƒ § k E k/ _ qQ ? 7 l -4 § m / ) i E D / : 5 0 $ 0 E CD § _/ Co a � 8 \ 2 § Q - S0 k � � mƒ k � C i 0D f Z =rI 8 KE k# 7 \ r al , ® 0 D ` ° o - �2 £ S / §' 0 D 02 >a ) / ° M % q 0 \ n / / j c \ r 0 E ¥ § ¢ F e c IT ( / C ) / % p � OL - CD M / . 8 CD ƒ ¢ ] § k 2 ° 0 , Q E $ 2 D i \ 0CD ƒ \ \ INVOICE 0417a P.O.34499 Hon.James C.Brainard Mayor,City of Carmel Attn:Sharon Kibbe One Civic Square Carmel,IN 46032 Make check payable to: Tax ID#35-1985559 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 April 17,2017 Professional services from April 1 through April 15,2017,in connection with: Bond/Lease-review Parkwood surplus. $ 13 Budget Consultation-reviewing of files for next year's budget. 612 Cumulative Fund-rate discussion,re-establish,Cumulative Fund follow up,request 589 sponsor for CCD ordinance. LOIT-COIT update 165 Other Consulting-meetings with seinor staff members regarding reference Engery 2,925 Center,and personnel matters,emails,phone calls,meeting on Energy Center billings and transition matters. Plan-plan updates,and cumulative fund items. 440 Out of pocket expense-mileage - Total amount of this invoice. 4,744 Previous balance. 20,282 Payment received. (11,196) Total amount due. $ 13,830 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL April 17,2017 Professional services from April 1 through April 15,2017, in connection with: Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor. Performing Service Service Date Services Provided Hourly Rate Total Coonrod 4/11/2017 Bond/Lease 240 0.05 13 Bond/Lease Total 13 Lilly 4/6/2017 Budget Consultation 175 1.75 306 Lilly 4/13/2017 Budget Consultation 175 1.75 306 Budget Consultation Total 612 Roeger 4/3/2017 Cumulative Fund 220 0.35 77 Coonrod 4/3/2017 Cumulative Fund 240 0.15 36 Roeger 4/3/2017 Cumulative Fund 220 0.10 22 Roeger 4/4/2017 Cumulative Fund 220 1.65 363 Coonrod 4/11/2017 Cumulative Fund 240 0.15 36 Roeger 4/12/2017 Cumulative Fund 220 0.25 55 Cumulative Fund Total 589 Roeger 4/12/2017 LOIT 220 0.75 165 LOIT Total 165 Engelking 4/3/2017 Other Consulting 150 3.00 450 Engelking 4/4/2017 Other Consulting 150 1.50 225 Engelking 4/5/2017 Other Consulting 150 1.00 150 Engelking 4/6/2017 Other Consulting 150 3.00 450 Engelking 4/7/2017 Other Consulting 150 1.50 225 Engelking 4/10/2017 Other Consulting 150 2.50 375 Engelking 4/11/2017 Other Consulting 150 2.50 375 Engelking 4/12/2017 Other Consulting 150 1.50 225 Engelking 4/13/2017 Other Consulting 150 1.50 225 Engelking 4/14/2017 Other Consulting 150 1.50 225 Other Consulting Total 2,925 Roeger 4/3/2017 Plan 220 1.05 231 Roeger 4/5/2017 Plan 220 0.95 209 Plan Total 440 Publishing&printing 0 Mileage 0 TOTAL invoice amount 4,744 02 $ n « « k V,m O Q 7 r § O g kOL C § 2> z % q 0 k -0 0 z m O E 3 o - $ o k b O ■ e ° z k 90 o E0 q # © -n 7 -0 §A q / 2 S -n > � q / ƒ § $ k \ � m m < 3 ? � 5L za 2 < f ® CD \ \ o r | � at 3 F - 2 r, k g § ¥ § PL & E CL § ƒ / 0 ) § k K / @ 0 2 E (DCL ® < $ f 2 7 § k CD _ - / $ �_ 3 \ \ ° mCD m \ r g ± _ « § k % « CL E E CL - 2 0) CD • S f § rl) f Z £ § o m ; . - 2 ƒ E� - qo = - U� -4 § m \ \ @ _/$ 0 D / ) /}- o = 0 ° } � \ 4tM ƒ \ k C \ ) / © \ 0 Z ( k _� \ C C/) \ �� 0/ \ # 2 e_- aQ 7 � §o � > & £ « > \ M � 0 / / } CD \ a \ R f ® E k &Q 0 m � / A n 2. m 2 M � § m \ § \ \ 0 © \ \ C? E 40 > \Kg g CD 9) § 8 ¥ A INVOICE 0317b P.O.34499 Hon.James C.Brainard Mayor,City of Carmel Attn:Sharon Kibbe One Civic Square Carmel,IN 46032 Make check payable to: Tax ID#35-1985559 C.L.Coonrod&Company 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 April 6,2017 Professional services from March 16 through March 31,2017,in connection with: Annexation-respond to request for copy of fiscal plan. $ 60 Bookkeeping-emailed client regarding pass due invoices. 24 Bond/Lease-work on matters related to bond issuance,bond matters,respond to financial 3,332 advisor questions about future cash flow,follow up to meeting updates of fiscal projection,adjust fiscal plan for bond issue planning,plan to financial advisors. Budget Consultation-work paper for bond payments and totals,IWC refinancing 2,429 proposal,respond to question from Council member,drafting of letter for IWC payments. Other Consulting-emails,phone calls,correspondence,proclamations,meetings with 2,925 senior staff and administrative staff,meeting with Mayor and senior staff,Energy Center matters. Pensions,PERF-review pension funding. 24 Project-debt payment schedule. 275 Out of pocket expense-mileage 17 Total amount of this invoice. 9,086 Previous balance. 31,015 Payment received. (19,819) Total amount due. $ 20,282 Payable upon receipt. Call(317)844-4605 with questions. CITY OF CARMEL April 6,2017 Professional services from March 16 through March 31,2017, in connection with: Rates in accordance with Section 5.1 of the contract and our October 5,2012,letter to the Mayor. Performing Service Service Date Services Provided Hourly Rate Total Coonrod 3/26/2017 Annexation 240 0.25 60 Annexation Total 60 Roeger 3/20/2017 Bond/Lease 220 0.50 110 Roeger 3/22/2017 Bond/Lease 220 2.85 627 Coonrod 3/22/2017 Bond/Lease 240 1.00 240 Roeger 3/22/2017 Bond/Lease 220 0.95 209 Roeger 3/27/2017 Bond/Lease 220 2.20 484 Coonrod 3/27/2017 Bond/Lease 240 0.30 72 Roeger 3/27/2017 Bond/Lease 220 0.60 132 Roeger 3/29/2017 Bond/Lease 220 4.00 880 Roeger 3/30/2017 Bond/Lease 220 1.00 220 Coonrod 3/30/2017 Bond/Lease 240 0.30 72 Roeger 3/31/2017 Bond/Lease 220 1.30 286 Bond/Lease Total 3,332 Hibler 3/24/2017 Bookkeeping 155 0.15 24 Bookkeeping Total 24 Lilly 3/16/2017 Budget Consultation 175 1.75 306 Hibler 3/16/2017 Budget Consultation 155 0.25 39 Coonrod 3/16/2017 Budget Consultation 240 1.75 420 Coonrod 3/17/2017 Budget Consultation 240 3.30 792 Coonrod 3/17/2017 Budget Consultation 240 0.50 120 Hibler 3/17/2017 Budget Consultation 155 0.90 140 Lilly 3/23/2017 Budget Consultation 175 1.75 306 Lilly 3/30/2017 Budget Consultation 175 1.75 306 Budget Consultation Total 2,429 Engelking 3/16/2017 Other Consulting 150 2.50 375 Engelking 3/17/2017 Other Consulting 150 1.50 225 Engelking 3/20/2017 Other Consulting 150 1.00 150 Engelking 3/21/2017 Other Consulting 150 1.00 150 Engelking 3/22/2017 Other Consulting 150 3.00 450 Engelking 3/23/2017 Other Consulting 150 1.00 150 Engelking 3/24/2017 Other Consulting 150 1.00 150 Engelking 3/27/2017 Other Consulting 150 1.00 150 Engelking 3/28/2017 Other Consulting 150 1.00 150 Engelking 3/29/2017 Other Consulting 150 1.00 150 Engelking 3/30/2017 Other Consulting 150 4.00 600 Engelking 3/31/2017 Other Consulting 150 1.50 225 Other Consulting Total 2,925 Coonrod 3/20/2017 Pensions, PERF 240 0.10 24 Pensions,PERF Total 24 Roeger 3/17/2017 Project 220 1.25 275 Project Total 275 Publishing&printing 0 Mileage 5 TOTAL invoice amount 9,074 INVOICE 0317b P.O.34499 Hon.James C.Brainard Mayor,City of Carmel Attn:Sharon Kibbe One Civic Square Carmel,IN 46032 Make check payable to: Tax ID#35-1985559 C.L Coonrod&Company 3850 Priority Way South Drive,Suite 225 Indianapolis,Indiana 46240 April 6,2017 Professional services from March 16 through March 31,2017,in connection with: Annexation-respond to request for copy of fiscal plan. $ 60 Bookkeeping-emailed client regarding pass due invoices. 24 Bond/Lease-work on matters related to bond issuance,bond matters,respond to financial 3,332 advisor questions about future cash flow,follow up to meeting updates of fiscal projection,adjust fiscal plan for bond issue planning,plan to financial advisors. Budget Consultation-work paper for bond payments and totals,IWC refinancing 2,429 proposal,respond to question from Council member,drafting of letter for IWC payments. Other Consulting-emails,phone calls,correspondence,proclamations,meetings with 2,925 senior staff and administrative staff,meeting with Mayor and senior staff,Energy Center matters. Pensions,PERF-review pension funding. 24 Project-debt payment schedule. 275 Out of pocket expense-mileage 17 Total amount of this invoice. 9,086 Previous balance. 31,015 Payment received. (19,819) Total amount due. $ 20,282 Payable upon receipt. Call(317)8444605 with questions.