The URL can be used to link to this page

Home My WebLink AboutLONDON WITTE GROUP- 002831- 4/19/2012 CARMEL REDEVELOPMENT COMMISSION 0 0 2 8 31 London Witte Group Check: 2831 1776 N Meridian Street Date: 4/19/2012 Suite 500 Vendor: LONDONW1 Indianapolis, IN 46202 Prior invoice P.O. Num.. Invoice Amt Balance Retention Discount Amt. Paid 24804 10,784.25 10,784.25 0.00 0.00 10,784.25 March 2012 services . 10,784.25 10,784.25 0.00 0.00 ,. 10,784.25 I :=r THE,KEXTO DOCLI ENT SECURITY HEATtACT *.TED THUMB F'RINT4tADDITIONAL SECURITYFFE'A RES 1qCLUDED SEE[ElA61O ORtDETAILS At4V* ' P".``"`°E*, Carmel Redevelopment Commission „ p ,� 'a 30 West Main Street REGIONS 0 0:2 8 31 }^� � -20-1421/740 (� Suite 220 c ' S Carmel; IN 46032. 1 2831 DATE AMOUNT 4/19/2012 **********10,784.25 PAY THE.SUM'OF:.TEN-THOUSAND-SEVEN HUNDRED EIGHTY FOUR DOLLARS AND 25 CENTS*,******* TO THE - ORDER OF London Witte Groups _ 1'776"N:Meridian Street Suite 500 �zssENS,� Indianapolis, IN 46202 000 28 3 LI)' 1:0 7110 14 2 b 31: 008 7 SOLI L / Ir)i° CARMEL REDEVELOPMENT COMMISSION .0 0 2 8 3.1 London Witte Group Check: 2831 1776 N Meridian Street Date: 4/19/2012 Suite 500 Vendor: LONDONW1 Indianapolis, IN 46202 Prior Invoice P.O. Num. Invoice Amt Balance R etention. Discount Amt. Paid 24804 10,784.25 10,784.25 0.00 0.00 10,784:25 March 2012 services 10,784.25 1.0,784.25 0.00 . 0.09' 10,784.25 i .. ;-11-52 COMPUTEREASE FORMS DIVISION(877)577-5791 T-37228 �..y1 LONDON T MTG WITTE GROUP Carmel Redevelopment Commission Client No: 1002.004 30 W.Main Street Date: 03/31/2012 Suite 220 Invoice No: 24804 Carmel,IN 46032 • For services rendered as detailed in the attached summary. Operating $ 8,690.50 Non-Operating 2,093.75 Current Amount Due $, 10,784.25 P/i2" Certified Public Accountants 1776 N.Meridian Street,Suite 500 Indianapolis,Indiana 46202 Telephone 1 317-634-4747 Facsimile 1 317-632-2727 Web 1LondonWitteGroup.com London Witte Group, LLC March 2012 Billing Detail 1 of 4 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Higgins 03/01/2012 0.25 325.00 81.25 Call with Rick Coad(Morgan Keegan) re: follow-up on restructuring proposal- refer to Lauren Mathis(Umbaugh) Higgins 03/19/2012 0.50 325.00 162.50 Return call (message)and subsequent conversation with Dave Bowers re:various CRC matters; follow-up conversation re: follow-up with representative of marine Bank and inquiry from Dave concerning a comprehensive debt summary and related • matters Higgins 03/20/2012 0.50 325.00 162.50 Call with Mike Lee re: scheduling the next finance committee meeting and attendance at the March 21st Commission Meetings; follow-up with Bob Reynolds re: same Reynolds 03/21/2012 2.50 75.00 187.50 Commission Meeting -Attended 3/21 commission meeting(also includes executive session) Higgins 03/26/2012 0.25 325.00 81.25 Follow-up email with Mike Lee re: confirming availability for Thursday's Finance Committee Meeting Reynolds 03/29/2012 2.50 75.00 187.50 Finance Committee Meeting-Attended the 4-29 Finance Committee Meeting Higgins 03/29/2012 3.00 325.00 975.00 Prepare for and meet with the members of the CRC Finance Committee Reynolds 03/30/2012 1.25 75.00 93.75 Refunding Debt-Reviewed information sent to me from Ryan to start putting together a debt refunding spreadsheet for Dave Higgins 03/30/2012 1.00 325.00 325.00 Conversations with Bob Reynolds re: follow-ups with Umbaugh (Heide/Lauren) and Ryan Wimmering re: information needed for Dave Bowers 11.75 2,256.25 Subtotal -Financial Advisory-Finance Committee Higgins 03/12/2012 0.25 325.00 81.25 Return email to Ryan and Karl re: attendance at the March 14th 4CDC meeting and related matters Higgins 03/13/2012 0.25 325.00 81.25 Retrieve message and return call to Mike Lee in advance of tomorrow morning's 4CDC meeting 0.50 162.50 Subtotal -Financial Advisory-4CDC Higgins 03/05/2012 0.50 325.00 162.50 Follow-up with an email from Lori Danford (State Board of Accounts) re: start of the 2011 audit; review preliminary list of information requested and forward same to Bob and Mike Higgins 03/05/2012 0.50 325.00 162.50 Meeting with Bob Reynolds to review information requested by the SBOA for the 2011 audit and related matters Higgins 03/05/2012 0.50 325.00 162.50 Forward additional audit information to the SBOA Examiner (2011 Claim dockets and check numbers); follow-up with Bob on vendor histories and related matters Kalman 03/05/2012 3.50 45,00 157.50 Review 2011 check register for audit presentation Reynolds 03/05/2012 0.75 75.00 56.25 Audit-Met with Jim to discuss we need to prepare for the upcoming Audit and other general CRC projects Kalman 03/06/2012 8.00 45.00 360.00 Prepare TIF register and related documents for audit Reynolds 03/06/2012 0.75 75.00 56.25 TIF Register- Reviewed TIF Register to ensure the numbers flowing the register tied out for the upcoming SBOA audit London Witte Group, LLC March 2012 Billing Detail 2 of 4 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Reynolds 03/06/2012 1.50 75.00 112.50 Audit Debt Information -Discussed with Mike information needed to tie all debt amounts paid to the amortization schedule. Updated spreadsheet to show the actual debt paid vs the expected amounts to be paid Kalman 03/07/2012 3.75 45.00 168.75 Additional audit preparation work Reynolds 03/07/2012 3.00 75.00 225.00 Audit Ledger-Reviewed and updated General Ledger for Audit Higgins 03/07/2012 0.50 325.00 162.50 Meeting with Bob Reynolds re: status of items requested for the 2011 audit and related matters Reynolds 03/08/2012 6.00 75.00 450.00 General Ledger-Finished updated and tying General Ledger to tie to the Financial Forecast Reynolds 03/09/2012 1.00 75.00 75.00 Check Register- Reviewed and made final changes to the check register for the 2011 Audit Reynolds 03/09/2012 3.00 75.00 225.00 Vendor Ledger- Prepared the Vendor ledger for the Audit, reviewed the ledger and made sure it tied to the Financial Summary and the General Ledger Reynolds 03/12/2012 1.00 75.00 75.00 Harris Bank-Created Bank Reconciliation for Harris Bank Account. Also added the December deposit to the Ledger and vendor ledger Reynolds 03/12/2012 1.00 75.00 75.00 Check Register- Finished tying out the Check Register to the General Ledger and Bank Reconciliation for the upcoming 2011 Audit Reynolds 03/12/2012 1.50 75.00 112.50 TIF Register- Reviewed and prepared the 2011 TIF Register to be sent to the auditor Higgins 03/12/2012 0.25 325.00 81.25 Meeting with Bob Reynolds to review status of information request for the audit and related matters; follow-up with Lori Danford (SBOA) re: information request Higgins 03/13/2012 0.50 325.00 162.50 Follow-up with the SBOA Auditor re: information request and related matters. Reynolds 03/19/2012 0.25 75.00 18.75 Met with Jim to discuss items needed for 2011 audit Higgins 03/19/2012 0.25 325.00 81.25 Follow-up meeting with Bob Reynolds to review items pertaining the request by the SBOA Examiner Higgins 03/20/2012 0.25 325.00 81.25 Review and forward the SBOA internal control questionnaire to Mike and Bob for their review and comment Reynolds 03/21/2012 0.50 75.00 37.50 Control Form -Filled out Control Form for 2011 Audit Higgins 03/27/2012 0.25 325.00 81.25 Follow-up emails with the SBOA representative on status of the information request and related matters 39.00 3,342.50 Subtotal -Financial Advisory-Audit Higgins 03/06/2012 0.25 325.00 81.25 Meeting with Bob Reynolds re: 2013 forecast and coverage analysis Higgins 03/07/2012 0.50 325.00 162.50 Follow-up with Mike Lee re: 2013 forecast and related matters; follow-up with Bob Reynolds re: same Reynolds 03/15/2012 0.50 75.00 37.50 March Packet- Reviewed Jacqueline's work for the financial summary, bank rec, and the check register Reynolds 03/16/2012 3.00 75.00 225.00 Financial Dashboard-Updated all items in the dashboard for the 3/21 commissioners meeting Reynolds 03/16/2012 3.00 75.00 225.00 3/21 Packets- Reviewed and went over all changes with Mike for the Forecast and other items for the 3/21/2012 Packets Reynolds 03/19/2012 0.25 75.00 18.75 Financial Dashboard-Sent email to Bill Kennedy at Marine Bank answering questions regarding the CRC Financial Dashboard London Witte Group, LLC March 2012 Billing Detail 3 of 4 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Reynolds 03/20/2012 1.75 75.00 131.25 Carmel- Updated and prepared the debt sheet to send Umbaugh 9.25 881.25 Financial Advisory-Financial Dashboard Higgins 03/01/2012 0.75 325.00 243.75 Call with Terry Runyon (Star Bank) re: accounts and depository relationships and related matters Parson 03/02/2012 0.90 Postage Higgins 03/03/2012 0.50 325.00 162.50 File administration and organization -banking and other transactional documents to Bob Reynolds Higgins 03/05/2012 0.25 325.00 81.25 Call with Mike Lee to review open and outstanding projects and related matters Kremer 03/08/2012 1.50 75.00 112.50 Worked on February bank reconciliation and updated 2012 account activity file. Higgins 03/10/2012 1.35 Postage- Utility Bills Higgins 03/10/2012 0.25 325.00 81.25 Review and sign claims and checks for utility bills(mailed from Don Cleveland) Reynolds 03/14/2012 1.50 75.00 112.50 Certificate of Compliance-Completed the Harris Bank Ration for the Certificate of Compliance Higgins 03/16/2012 0.45 Postage Higgins 03/21/2012 0.50 325.00 162.50 Follow-ups with Mike Lee and Bob Reynolds in advance of this evening's Commission Meeting Higgins 03/21/2012 0.25 325.00 81.25 Email to the Commissioners and staff re: this evening's Commission Meetings; reschedule time to review claims and sign checks Higgins 03/22/2012 1.00 325.00 325.00 Go to CRC Offices to meet with Don Cleveland to review and approve claims and sign checks Higgins 03/22/2012 0.75 325.00 243.75 Conference call with Mike Lee and Ben Reoger re: line of credit draw and clean up matters; review and concur with the e-mail request as presented by Mike Lee Higgins 03/22/2012 0.25 325.00 81.25 Email to Karl Haas re: potential need fora formal CRC policy re: public information requests and related matters Higgins 03/27/2012 0.25 325.00 81.25 Follow-up with Mike Lee re: questions on funds available from the Mercantile line of credit and Hall Parson 03/30/2012 0.45 Postage Parson 03/30/2012 1.10 Postage 7.75 1,773.00 Subtotal -Financial Advisory-General Reynolds 03/01/2012 1.75 75.00 131.25 TIF Register-Completed Tying out values in the TIF Register so all values flowed through each TIF area correctly Reynolds 03/01/2012 0.50 75.00 37.50 Compliance Debt Service Coverage-Updated and sent the Compliance debt service coverage calculation to Jim Higgins 03/03/2012 1.00 325.00 325.00 Review initial revised draft of the Umbaugh TIF Report Higgins 03/05/2012 0.50 325.00 162.50 2011 Debt Service Coverage Compliance-follow-up with Bob on items to be included in the calculation of the debt service coverage to be included in the compliance certificates requested by the installment purchase contract providers • London Witte Group, LLC March 2012 Billing Detail 4 of 4 Carmel Redevelopment Commission 1002.004 Hourly Employee Date Hours Rate Invoice Memo Reynolds 03/05/2012 2.25 75.00 168.75 Compliance Ratio's- Reviewed and made sure the Compliance Ratio tied to all CRC documents. Created workpapers to show what Check Numbers and items were included in the Ratio. Discussed with Jim and finalized the document Reynolds 03/05/2012 4.00 75.00 300.00 2012 Annualized Debt Coverage- Updated the 2012 Annualized Debt Coverage analysis to show the new updated Umbaugh TIF projections Reynolds 03/06/2012 1.25 75.00 93.75 2012 Annualized Debt Service Coverage-Completed going over Reynolds 03/07/2012 1.50 75.00 112.50 Certificate of Compliance- Updated certificate per Ryan's request. Reynolds 03/08/2012 1.50 75,00 112.50 Certificate of Compliance-Updated Certificate of compliance to include LOC interest expense and created ratio's not to include operating expenses Higgins 03/19/2012 0.50 325.00 162.50 Follow-ups with Bob Reynolds; Jim Rush and Ryan Wimmering re:2011 CRC Compliance Certificates and related matters Reynolds 03/19/2012 1.00 75.00 75.00 Certificates of Compliance-Assisted Ryan in answering questions needed in order to send out all needed Certificates of Compliance Reynolds 03/20/2012 0.50 75.00 37.50 Certificate of Compliance- Email Perrette Russel at BNY Mellon regarding the request letter sent for a compliance certificate/report for the CRC COIT Lease Rental Revenue Refunding Bonds of 2004. Also looked up the covenants stated in the OS document for possible certificate calculations. Reynolds 03/20/2012 2.25 75.00 168.75 TIF Register- Updated TIF Register for the month of February Reynolds 03/23/2012 1.50 75.00 112.50 Marine Bank-Spoke with Marine Bank to answer questions regarding the dashboard items. Also followed up with Ryan regarding if they should receive a certified certificate Reynolds 03/30/2012 1.25 75.00 93.75 Certificates of Compliance-Highlighted and developed a workpaper to help Katie Smith at Regions tie out all numbers for the certificates 21.25 2,093.75 Subtotal -Financial Advisory-TIF Reynolds 03/09/2012 1.50 75.00 112.50 2013 Forecast- Has a conference call with Jim and Mike and then reviewed and updated the 2013 Forecast to be distributed Higgins 03/09/2012 0.50 325.00 162.50 Conference call with Bob Reynolds and Mike Lee re: 2013 Forecast and related matters 2.00 275.00 Subtotal -Financial Advisory-Budgets 91.50 10,784.25 Total Invoice Summary Operating 8,690.50 All categories except TIF Non-operating 2,093.75 TIF Total 10,784.25 Prescribed by State Board of Accounts City Form No.201(Rev.1995) ACCOUNTS PAYABLE VOUCHER CITY OF CARMEL An invoice or bill to be properly itemized must show: kind of service, where performed, dates service rendered, by whom, rates per day, number of hours, rate per hour, number of units, price per unit, etc. Payee Lour/oH Purchase Order No. /776 //1 // I f0.1,O<>_574,,,,,-74 Ste,'/P 5 ' Terms // ‘4�9.r,,/ ">, / '11'20 2 Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) 3/31 f/2 2`/ O 717;7'1--e-// 5 v/ 'ri /D 7R9.2s- t v t: t2a Total /67- /7(_2-.-5 I hereby certify that the attached invoice(s), or bill(s), is (are) true and correct and I h. - _.:.ui.-s• ame in accor- dance with IC 5-11-10-1.6. , 20 t'L- `L "- - reasurer VOUCHER NO. WARRANT NO. ALLOWED 20 v et o/ay l� P c'eie IN SUM OF $ ///7 7 6 __ q�/� S iLY /4 / (ii 20 2_ • $ /C': 7,3�q.2 5 ON ACCOUNT OF APPROPRIATION FOR 702 Board Members Po#or INVOICE NO. ACCT#/TITLE AMOUNT hereby certify invoice(s), DEPT.# I hereb certi that the attached invoices , 92 2yFlOy e”)(73OG /a7 '/,ZS or bill(s) is (are) true and correct and that the materials or services itemized thereon for which charge is made were ordered and received except 171— // 20/2 ExeciNgSirector Title Cost distribution ledger classification if Cancel Redevelopment Commission claim paid motor vehicle highway fund