Loading...
HomeMy WebLinkAbout325346 05/23/16 +ur.C4Nb �f. CITY OF CARMEL, INDIANA VENDOR: 00351669 .: r . .. ONE CIVIC SQUARE H J"UMBAUGH &ASSOCIATES CHECK AMOUNT: $****62,222.50* r a CARMEL, INDIANA 46032 8365 KEYSTONE CROSSING STE 300 CHECK NUMBER: 325346 INDIANAPOLIS IN 46240 CHECK DATE: 05/23/18 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 902 4340300 153098 4,817.50 ACCOUNTING FEES 902 4340300 153100 32,027.50 ACCOUNTING FEES 902 4340300 153101 25,377.50 ACCOUNTING FEES VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) Vendor# 00351669 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER H J UMBAUGH &ASSOCIATES IN SUM OF$ CITY OF CARMEL 8365 KEYSTONE CROSSING STE 300 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. INDIANAPOLIS, IN 46240 Payee $62,222.50 ON ACCOUNT OF APPROPRIATION FOR Purchase Order# Redevelopment Commission Terms Date Due PO# ACCT# DATE INVOICE# DESCRIPTION DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 153098 43-403.00 $4,817.50 1 hereby certify that the attached invoice(s),or 5/3/18 153098 TIF financing feasibility-111th and Penn $4,817.50 902 902 902 902 153100 43-403.00 $32,027.50 bill(s)is(are)true and correct and that the 5/3/18 153100 Economic development-TIF financing $32,027.50 902 1 1 902 materials or services itemized thereon for 902 1 902 1 feasibility 153101 43-403.00 $25,377.50 5/3/18 153101 TIF management services $25,377.50 902 902 which charge is made were ordered and 902 I 902 I received except Tuesday, May 22,2018 Mestetsky, Henry I hereby certify that the attached invoice(s),or bill(s),is(are)true and correct and I have audited same in accordance with IC 5-11-10-1.6 ,20 Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer H. J. Umbaugh & Associates Certified Public Accountants,LLP 8365 Keystone Crossing, Suite 300 Indianapolis,IN 46240-2687 (317)465-1500 Mr. Henry Mestetsky, Executive Director Mr. Mike Lee, Finance Director Carmel Redevelopment Commission 30 West Main Street, Suite 220 Carmel, IN 46032 hmestetsky@carmel.in.gov mlee@carmel.in.gov Re: Municipal Advisory Services- TIF Financing Feasibility- 111 th&Penn(Browning) Invoice No. 153098 Please Include Invoice Number with Remittance Date 05/03/2018 Client No. C00600.RED20 For professional services rendered from December 20, 2017 through April 15, 2018 in connection with financial planning of the proposed 111th & Penn Project. Services to-date include: review of developer's tax increment(TIF) projections and financial feasibility analyses related to 3 parking options; discussions and analysis related to the funding of one or two parking garages and Developer/CRC TIF split, comparison to BIG TIF Report assumptions; meetings/calls with developer, Mayor and CRC Director; and other related services. See attached detail of services. Current Amount Due $ 4.817.50 WIRING INSTRUCTIONS H J Umbaugh&Associates Certified Public Accountants, LLP Key Bank, N.A. 202 S. Michigan Street South Bend, IN 46601 Account Number- 12155-04838 Routing Number-041001039 Carmel Redevelopment Commission Municipal Advisory Services-TIF Financing Feasibility-111th&Penn(Browning) Invoice Supporting Hourly Detail Date Service Description Employee Memo Hours Fees 12/20/2017 Meeting Matthes discuss Browning proposals and BIG TIF assumptions with Henry and staff 0.25 $ 100.00 12/20/2017 Teleconference Matthes Mayor Brainard 0.25 100.00 12/20/2017 Financial Development-Prep Matthes review schedules from Jamie Browning(3 scenarios)and also compare to assumptions for BIG TIF in 2017 TIF report;impact of extending TIF area etc.- with Andy and Courtland 1.50 600.00 12/20/2017 Financial Development-Prep Mouser 111th&Penn 2.00 480.00 12/28/2017 Correspondence Matthes email to Jamie re:TIF split financing feasibility analysis 0.50 200.00 1/2/2018 Financial Development-Prep Matthes compare Browning TIF est and the BIG TIF report,timing,etc.in prep for call 0.50 210.00 1/2/2018 Teleconference Matthes call Jamie Browning 0.50 210.00 1/2/2018 Teleconference Jackson,Jr. Call with Jaime Browning. 1.50 210.00 1/2/2018 Financial Development-Prep Mouser discuss w/Loren,review developer info,call w/Jamie Browning,discuss w/ Loren&Courtland 1.50 375.00 1/4/2018 Financial Development-Prep Matthes Jamie re:KAR TIF and BIG TIF 0.25 105.00 1/4/2018 Correspondence Mouser KAR&Big TIF 0.50 125.00 1/8/2018 Financial Development-Prep Amspaugh Project discussion 0.50 145.00 1/9/2018 Correspondence Matthes respond to Jamie re:fee estimate 0.25 105.00 1/16/2018 Meeting Matthes meeting with Jamie Browning to discuss development prospects,garage cost,TIF splits,BIG TIF,etc. 0.50 210.00 1/16/2018 Financial Development-Prep Matthes planning/discussing analysis to prepare for 111th&Penn vs BIG TIF Future Devt Stream for this site,and 2018 TIF Report assumptions w Andy in prep for meeting w Henry;in light of meeting with Jamie Browning re:M&M and 111th&Penn etc 0.50 210.00 1/16/2018 Financial Development-Prep Mouser call from Jamie,mtg.w/Jamie w/Loren 2.00 500.00 2/7/2018 Teleconference Matthes Henry regarding the bond assumptions in Jamie's schedule. 0.25 105.00 2/7/2018 Financial Development-Prep Matthes reviewing Browning's bond schedule options and assumptions to respond to Henry's questions;resend and draft email comparing Meridian and Heights TIF and assumptions and 111th and Penn TIF and assumptions 0.75 315.00 2/8/2018 Financial Development-Revie%Amspaugh Review Jamie's TIF Estimate 0.25 72.50 2/8/2018 Financial Development-Prep Mouser various 0.50 125.00 2/15/2018 Teleconference Matthes Mayor Brainard re:111th&Penn TIF estimate in the BIG TIF report and estimated TIF from Jamie's proposed development 0.25 105.00 3/23/2018 Correspondence Matthes correspondence with Jamie Browning re:financing feasibility,reimbursemt agreement needed,financing gap etc.(checking most recent file notes and analysis)to answer questions 0.50 210.00 Total 15.50 $ 4,817.50 H. J. Umbaugh & Associates Certified Public Accountants,LLP 8365 Keystone Crossing, Suite 300 Indianapolis,IN 46240-2687 (317)465-1500 Mr. Henry Mestetsky, Executive Director Mr. Mike Lee, Finance Director Carmel Redevelopment Commission 30 West Main Street, Suite 220 Carmel, IN 46032 hmestetsky@carmeLin.gov mlee@carmel.in.gov Re: Municipal Advisory Services- Economic Development- TIF Financing Feasibility Invoice No. 153100 Please Include Invoice Number with Remittance Date 05/0312018 Client No. COO600.RED3 For professional services rendered from November 15, 2017 through April 30, 2018 relating to various economic development projects including Project Sycamore TIF financing feasibility and incentives; discussions and information related to the City Center Phase 2 developments, TIF, PIATTs and developer guarantees; development of a TIF Feasibility model for CRC staff; financial planning for various City capital projects and private developer projects with Mayor and Council members; responding to various information requests; and other related services in accordance with an Engagement Letter dated February 16,2018. See attached detail of services. Current Amount Due $ 32.027.50 WIRING INSTRUCTIONS H J Umbaugh&Associates Certified Public Accountants, LLP Key Bank, N.A. 202 S. Michigan Street South Bend, IN 46601 Account Number- 12155-04838 Routing Number-041001039 Carmel Redevelopment Commission Municipal Advisory Services-Economic Development-TIF Financing Feasibility(REDS; Invoice Supporting Hourly Detail Date, Service Description Employee Memo Hours Fees 11/15/2017 Teleconference Amspaugh Call w Michael Garvey re hotel and garage project 0.50 $ 137.50 1/8/2018 Financial Development-Prep Matthes internal discussion and financial planning re: Proscenium, 111th&Penn,KAR,Valentina,etc. 0.50 210.00 1/12/2018 Financial Development-Prep Matthes 2018 ED FS-126th&Grey and other projects-emails and financial information related to question about concept of CRC-CDC grants for 126th&Grey;discussion of impact on CRC budget,hotel loan timing,BIG TIF and other potential losses due to M&M,MISO appeal etc. 1.00 420.00 1/19/2018 Financial Development-Prep Matthes draft revised email to Henry re:126th&Grey and BIG TIF back-up,etc.to share with Mayor 1.00 420.00 2/9/2018 Financial Development-Prep Matthes discussing Henry's request regarding TIF FS excel model 2.00 840.00 2/13/2018 Correspondence Mouser Project Sycamore 0.50 125.00 2/13/2018 Financial Development-Prep Jackson,Jr. Delphi HQ FS. 3.00 420.00 2/13/2018 Umbaugh Reports-Prep Matthes Project Sycamore(Delphi)Incentive/TIF Feasibility-plan FS TIF and Bond assumptions and options with Courtland(and limited info from Henry);review and summarize and send to Henry 3.00 1,260.00 2/14/2018 Financial Development-Prep Mouser Project Sycamore-Delphi 0.50 125.00 2/14/2018 Legal Documents Matthes emails re:Mohawk Place Allocation Area/EDA and price 0.50 210.00 2/15/2018 Financial Development-Prep Mouser feasibility model for Henry 6.25 1,562.50 2/16/2018 Financial Development-Prep Mouser feasibility model for Henry 2.75 687.50 2/19/2018 Financial Development-Prep Matthes Henry-questions/discussion related to new St.V's hospital 96th and Spring Mill;TIF,PILOT Agreement,negotiations, etc. 0.50 210.00 2/26/2018 Correspondence Matthes Aptiv Incentive-emails-Mayor Brainard and Chris Gibson, Corydon Group 0.25 105.00 2/28/2018 Financial Development-Prep Matthes reviewing and revising model with Andy 1.00 420.00 2/28/2018 Financial Development-Prep Mouser feasibility model for Henry 6.00 1,500.00 3/1/2018 Financial Development-Prep Mouser Aptiv Incentive 0.50 125.00 3/1/2018 Financial Development-Prep Matthes Aptiv Incentive(aka Project Sycamore and Delphi HQ)- discussions with Mayor and researching info related to site and Meridian Heights TIF estimate,comparison,feasibility etc. 1.50 630.00 3/2/2018 Financial Development-Prep Matthes Aptiv incentive discussion with Mayor Brainard and Bruce Donaldson;emails with Chris Gibson,Corydon Group 1.00 420.00 3/5/2018 Financial Development-Review Matthes revised ED FS model from Andy 0.50 210.00 3/5/2018 Financial Development-Prep Mouser Henry FS model 2.00 500.00 3/6/2018 Financial Development-Prep Matthes prep for call 0.25 105.00 3/7/2018 Teleconference Amspaugh Aptiv call w Wkg Group 0.75 217.50 3/7/2018 Teleconference Matthes Aptiv call with Company rep's;and separate call with Bruce D. 1.00 420.00 3/7/2018 Financial Development-Prep Matthes revised ED FS model for Henry 1.00 420.00 3/7/2018 Teleconference Jackson,Jr. Delphi HQ(Aptiv)project call. 1.25 175.00 3/7/2018 Financial Development-Prep Mouser Henry feasibility model-distribute to CRC,call w/Mike Lee; Aptiv autonomous vehicle project-review info&conf call 3.00 750.00 3/12/2018 Financial Development-Prep Matthes discussing assumptions related to Aptiv TIF and incentives; reviewing investment info from Cheryl from the Company, call Cheryl with questions; 1.00 420.00 3/12/2018 Engagement Planning Jackson,Jr. Internal call with Heidi about assumotions for Aptiv HQ FS. 1.50 210.00 3/12/2018 Financial Development-Prep Amspaugh Project Aptiv/Delphi:Feasibility 2.50 725.00 3/13/2018 Financial Development-Prep Matthes discussing Aptiv TIF and bond assumptions with HLA;check notes on TIF split etc 1.00 420.00 3/13/2018 Financial Development-Prep Jackson,Jr. Aptiv HQ FS. 9.00 1,260.00 3/13/2018 Financial Development-Prep Amspaugh Project Aptiv/Sycamore FS emails w Courtland 0.25 72.50 3/13/2018 Financial Development-Review Ko Proofing Aptiv Parcels 1.00 90.00 3/14/2018 Umbaugh Reports-Prep Matthes Aptiv TIF incentive feasibility analysis-review TIF,personal property,bonds,options and assumptions,editing,add option,review revised report;HLA transmittal;additional comments to Mayor and Henry 2.50 1,050.00 3/14/2018 Financial Development-Prep Jackson,Jr. Project Sycamore FS. 3.00 420.00 3/14/2018 Financial Development-Review Amspaugh Project Aptiv/Sycamore Review FS 4.50 1,305.00 3/15/2018 Teleconference Matthes Mayor Brainard call-questions re:Michigan Rd TIF and Thomson TIF;request staff assist with TIF info;discuss with Colton-Hamilton County control/uses 0.50 210.00 3/16/2018 Teleconference Matthes call from Councilman Rider re:finance meeting with Mayor Brainard and advisors and 2 Councilmen-scheduling 0.50 210.00 3/16/2018 Financial Development-Prep Amspaugh Project Sycamore finalize FS;Emails w Loren 1.50 435.00 3/16/2018 Financial Development-Prep Matthes Aptiv: finalize incentive offer and send FS with transmittal email explanation to Tim Monger,Chris and Cheryl; communicate with Mayor and Henry 1.50 630.00 3/19/2018 Financial Development-Prep Matthes respond to Henry and Sue Finkham re:TIF growth history, first bonds,etc. 0.50 210.00 3/19/2018 Financial Development-Prep Matthes info and requests for Rider/Worrell in prep for finance meeting with Mayor on Tuesday morning;info from Coonrod,CRC etc 1.50 630.00 3/20/2018 Travel Matthes 0.25 105.00 3/20/2018 Meeting Matthes Meeting with Mayor and 2 Council members re:City finances,capital projects,HB 1104-LIT,etc. 3.00 1,260.00 3/26/2018 Financial Development-Prep Matthes Aptiv-responding to questions from Dan McFeeley,Nancy Heck and Henry re:Carmel Incentive offer and#'s 1.00 420.00 3/27/2018 Financial Development-Prep Matthes Project Sycamore(Aptiv):discussing incentives with Dan McFeeley and Nancy Heck(emails from Mayor),responses to/from Aasif from Ambrose,request re:TIF investment and bond assumptions from Chris S from Pure Development; discuss with Nancy,draft email,email to Chris;call with Tim Monger 4.50 1,890.00 3/28/2018 Correspondence Matthes Henry and Ryan questions re:CC2 TIF and Windsor assumptions 0.25 105.00 3/28/2018 Financial Development-Prep Matthes Aptiv-bring HLA up to speed on discussions on 3/27 with Nancy,Dan,and Mayor 0.25 105.00 3/29/2018 Legal Documents Matthes Review Ryan-WSH Summary Memo re:CC2,Windsor Building,etc.;comments from Bruce/Ryan 0.50 210.00 3/29/2018 Teleconference Matthes Call with Henry,Ryan-WSH and Bruce Donaldson re; Windsor Building-potential office HQ and potential TIF availability-discuss CC2 TIF,PIATTS,guaranty,2016 Bonds, Windsor Building exclusion for Museum and BIG TIF replacement,etc. 1.00 420.00 3/29/2018 Teleconference Jackson,Jr. City Center 11 conversation. 1.25 175.00 3/29/2018 Financial Development-Prep Matthes reviewing financial and legal info related to CC2 TIF,PIATTS, guaranty,2016 Bonds and Accounting Report,Windsor Building exclusion for Museum and BIG TIF replacement, etc.;compare PIATTs and TIF estimates to actual database and building progress,review summary 2.00 840.00 3/30/2018 Correspondence Matthes Aptiv: Mayor's email withdrawing incentive offer;call from Cheryl Morphew;follow-up with Nancy Heck 0.50 210.00 4/2/2018 Legal Documents Matthes review Taxpayer Agreement Guaranty for CC2 0.25 105.00 4/2/2018 Correspondence Matthes Henry re: Lauth project at ADT site;other 0.50 210.00 4/3/2018 Teleconference Matthes call with Henry and Mike re:various projects-ALO 4th and Rangeline,ADT-Lauth,Proscenium,etc. 0.25 105.00 4/3/2018 Financial Development-Prep Matthes review/discussion of ALO 4th&Rangeline pro forma with HLA 0.25 105.00 4/3/2018 Financial Development-Prep Matthes reviewing/discussing CC2#'s with Andy,Heidi and post-call PIATTs,Taxpayer Guaranty,discuss Windsor assumptions and PIATT,Eastern Motorcourt PIATT,Hotel,TIF,etc. 0.75 315.00 4/3/2018 Teleconference Matthes call(with Henry,attorneys and HJU)re:CC2#'s,Eastern Motorcourt,Hotel overlap,Wren North and Wren South, PIATTs,Taxpayer Guaranty,2016 Bonds,etc. 1.00 420.00 4/4/2018 Legal Documents Matthes additional email discussion(with Henry,attorneys)re:CC2 #'s,Eastern Motorcourt,Hotel overlap,Wren North and Wren South, PIATTs,Taxpayer Guaranty,2016 Bonds,etc.; respond to Laurie Siler,Pedcor,email related to meeting with Ralph McGinley on 4/12 1.00 420.00 4/16/2018 Financial Development-Prep Mouser Aptiv&Meridian Heights-maps for Loren 0.50 125.00 find and send maps to Henry comparing proposed Aptiv HQ 4/16/2018 Financial Development-Prep Matthes site and Meridian Heights Proposed Browning development 0.50 210.00 list of questions from Jandra @ Stifel from Wells Fargo analyst re:TIF and LIT revenue and outstanding CBB QO's- 4/19/2018 Financial Development-Prep Matthes 2016 Bonds 0.25 105.00 Legacy TIF analysis per Council Finance Committee-discuss with HLA,call Paul Rioux Platinum Properties re:future 4/19/2018 Financial Development-Prep Matthes developments and TIF estimate 0.50 210.00 Coonrod needs outstanding advance refunded bond info for City Audit-discuss with Courtland;emails from/to Henry re: questions from Stifel from Wells Fargo analyst re:TIF/LIT 4/20/2018 Financial Development-Prep Matthes revenue and outstanding CBB QC's-2016 Bonds;other 0.50 210.00 4/30/2018 Travel Matthes 0.50 210.00 4/30/2018 Financial Development-Prep Amspaugh Discuss w Loren 1.00 290.00 4/30/2018 Meeting Amspaugh Mtg w Carmel;Drive to/from 1.50 435.00 Meeting with Mayor and 2 Councilmen re:various projects 4/30/2018 Meeting Matthes and funding 1.50 630.00 Prep for afternoon meeting with Mayor and 2 Councilmen; review CRC Dashboard schedules,fiscal plan capital plan, prior talking points and notes,gather info to bring-CC2, M&M and Aptiv,TIF report etc;post meeting notes for file 4/30/2018 Financial Development-Prep Matthes and follow-up 3.00 1,260.00 Total 102.50 $32,027.50 H. J. Umbaugh & Associates Certibed Public Accountants,LLP 8365 Keystone Crossing, Suite 300 Indianapolis,IN 46240-2687 (317)465-1500 Mr. Henry Mestetsky, Executive Director Mr. Mike Lee, Finance Director Carmel Redevelopment Commission 30 West Main Street, Suite 220 Carmel, IN 46032 hmestetsky@carmel.in.gov mlee@carmel.in.gov Re: Municipal Advisory Services- TIF Management Assistance Invoice No. 153101 Please Include Invoice Number with Remittance Date 05/03/2018 Client No. C00600.RED28 For professional services rendered from December 15, 2017 through April 30, 2018 relating to tax increment financing (TIF): assistance with TIF monitoring for approximately 30 TIF Areas; preparation of Legacy TIF, 2017 LIT Bond Lease Rental and TIF Surplus Report, attend Council and Council Finance Committee meetings; assistance with Moody's surveillance bond rating; assistance with Gateway debt reporting; responding to various information requests; and other related services in accordance with an Engagement Letter dated February 16,2018. See attached detail of services. Current Amount Due $ 25.377.50 WIRING INSTRUCTIONS H J Umbaugh&Associates Certified Public Accountants, LLP Key Bank, N.A. 202 S. Michigan Street South Bend, IN 46601 Account Number-12155-04838 Routing Number-041001039 Carmel Redevelopment Commission Municipal Advisory Services-TIF Management Assistance(RED 28) Invoice Supporting Hourly Detail Date Service Description Employee Memo Hours Fees 12/15/2017 Correspondence Mouser TISs to Mike Lee 0.50 $ 120.00 12/20/2017 Financial Development-Prep Jackson,Jr. Legacy allocation and comparison. 0.25 33.75 12/21/2017 Financial Development-Prep Jackson,Jr. Legacy allocation and TIF surplus analysis. 2.25 303.75 12/22/2017 Financial Development-Prep Jackson,Jr. Confirming Proscenium and Monon and Main TIF database setup. 0.50 67.50 1/2/2018 Financial Development-Prep Mouser verify TIF database 0.75 187.50 1/2/2018 Financial Development-Prep Mouser various-discuss w/Loren 1.00 250.00 1/2/2018 Correspondence Matthes Henry's 12/29 emails re:excess Legacy TIF and BIG TIF proposal; find/review schedules and begin drafting response 1.00 420.00 1/3/2018 Financial Development-Prep Jackson,Jr. Pulling Legacy TIF Form 22s for Loren. 0.25 35.00 1/3/2018 Financial Development-Prep Matthes Explanation/response to Henry about Legacy TIF and BIG TIF. Review and provide Reimbursement Agreement regarding partial LR payments on CBB 2017 COIT Bonds and Excess Legacy TIF; resend Umbaugh 12/21/17 Excess Legacy TIF Report;estimated Excess Legacy TIF in 2017,2018 and future years;details and questions to Mike Lee re:2017 Legacy TIF used to pay 7/15/17 D/S/ payment on 2013A EDC Bonds,check actual distributions 1.50 630.00 1/5/2018 Financial Development-Prep Jackson,Jr. Comparing actual 2017 TIF settlement vs.Umbaugh estimated TIF; prepare Comparison schedule for all TIF Areas. 4.25 595.00 1/8/2018 Financial Development-Prep Amspaugh Settlement and TIF Mapping discussion;201713-1 bonds variances re 1.25 362.50 1/8/2018 Financial Development-Prep Jackson,Jr. 2017 Principal Paid schedule. 3.50 490.00 1/9/2018 Financial Development-Prep Matthes additional communication from/to Mike Lee re:2017 Legacy TIF funds sent to Trustee and ending balance etc.;check settlement records 0.50 210.00 1/9/2018 Financial Development-Review Amspaugh Review settlement vs estimate comparison;Disc w Courtland 1.75 507.50 1/9/2018 Financial Development-Prep Jackson,Jr. 2017 Principal Paid schedule. 3.50 490.00 1/10/2018 Financial Development-Review Amspaugh Review 2017 principal pmts info for Mayor;Request TIF Databases for 2018 TIF Report 1.50 435.00 1/10/2018 Financial Development-Prep Jackson,Jr. TIF collections vs estimate comparison. 1.75 245.00 1/11/2018 Financial Development-Prep Amspaugh 2017 Principal payment review;Send to Mayor and NH 0.75 217.50 1/12/2018 Financial Development-Prep Matthes Debt info for Mayor Brainard and Heck article-principal paid down in 2017;review schedules;emails,etc 0.50 210.00 1/12/2018 Financial Development-Prep Jackson,Jr. Carmel Principal paid in 2017. 1.50 210.00 1/18/2018 Financial Development-Prep Amspaugh KRG AV decrease review 0.50 145.00 1/25/2018 Financial Development-Prep Jackson,Jr. Debt limit talc update. 1.00 140.00 1/25/2018 Financial Development-Prep Amspaugh Settlement vs Estimate TIF Comparison review 1.00 290.00 1/25/2018 Financial Development-Prep Matthes Checking on CC2 Pedcor buildings,actual TIF compared to TIF projections(PIATTS and Bonds); 1.25 525.00 1/26/2018 Financial Development-Prep Jackson,Jr. 2017 TIF Actual vs Estimated comparison. 0.50 70.00 1/26/2018 Financial Development-Prep Matthes respond to Clerk Treasurer question re:2004A TIF Bonds(Illinois St: Clarian)placed with Nuveen;5/3 Bank info re:potential refunding; reasons City cannot refund-threatened loss of IU Health bond guarantees,PILOT and agreement not to appeal below certain amount;touch base with Andy. 1.00 420.00 1/29/2018 Financial Development-Prep Jackson,Jr. Carmel Debt Limit Calc. 0.25 35.00 1/31/2018 Financial Development-Prep Matthes Moody's surveillance rating;Mayor re:MI5O appeal withdrawal 0.25 105.00 1/31/2018 Financial Development-Prep Jackson,Jr. Confirming City Center parcels Incremental value. 0.50 70.00 2/5/2018 Legal Documents Matthes Resolution from B&T re:Integration of Legacy TIF Area into BIG TIF 0.25 105.00 2/5/2018 Financial Development-Prep Amspaugh Arts Lofts 2011B bonds email w Regions;Review existing Financing agreement;Moody's surveillance call coordination 0.75 217.50 2/7/2018 Financial Development-Prep Jackson,Jr. Carmel Comparable Properties. 0.75 105.00 2/8/2018 Correspondence Amspaugh Disc w Loren and Andy re:Henry's pruning request 0.25 72.50 2/8/2018 Correspondence Matthes emails with Henry and Heidi re:TIF PRUNING-timing and effective date 0.25 105.00 2/8/2018 Correspondence Matthes email to Henry re:office assessments and variance in Carmel 0.50 210.00 2/8/2018 Financial Development-Prep Matthes TIF PRUNING-planning with HLA-discuss residential,commercial losses;GIS map overlay of list timing and effective date,time needed to review and analyze;HLA correspondence with Kevin Poors re:new assessments for 2018 0.75 315.00 2/9/2018 Financial Development-Prep Amspaugh Disc w Loren re FS model;Emails w Lee re pruning analysis;Emails w Kevin Poore re new development AV assumpts. 1.25 362.50 2/12/2018 Umbaugh Reports-Prep Ko Updating carmel comps for AV per sq ft for building types 1.50 135.00 2/13/2018 Financial Development-Prep Matthes Moody's surveillance questions;discuss with HLA,email responses to Christine 1.00 420.00 2/13/2018 Financial Development-Prep Amspaugh Moody's Surveillance rating call prep 1.25 362.50 2/13/2018 Umbaugh Reports-Prep Ko Updating Carmel AV per sq ft comparables 4.00 360.00 2/14/2018 Teleconference Matthes Moody's surveillance call 1.00 420.00 2/14/2018 Financial Development-Prep Matthes Moody's surveillance questions and schedules,prep.call with City; questions from Lily at Coonrod re:CAFR and Legacy Bonds refunding 4.00 1,680.00 2/14/2018 Financial Development-Prep Amspaugh Moody's Surveillance Rating call prep;Prep Call;Call w Moody's 5.75 1,667.50 2/19/2018 Financial Development-Prep Jackson,Jr. Carmel Comps Update. 2.25 315.00 2/27/2018 Financial Development-Prep Amspaugh DLGF Debt Confirmation reminder emails w CT 0.25 72.50 2/28/2018 Financial Development-Prep Amspaugh TIF Model Review w Andy and Loren;RDC Mtg prep 1.50 435.00 2/28/2018 Meeting Amspaugh RDC Mtg;Travel to/from 1.75 507.50 3/2/2018 Financial Development-Prep Amspaugh Email w Kevin Poore re The Olivia assessment and ALO project assessment 0.50 145.00 3/2/2018 Financial Development-Prep Matthes request from Coonrod to gather 12-31-2017 outstanding principal on advance-refunded Carmel Bonds-needed for 2017 GAAP Financials;instructions to staff 0.50 210.00 3/2/2018 Financial Development-Prep Matthes Inquiry from Salin Bank regarding Keystone EDC Bonds for Olivia on Main. potential purchase.Conf.call with bank-brief discuss TIF status,risks,bond security,bond terms,etc.(review bond doc's and closing letter ahead of call);discuss with Tim and Heidi 1.00 420.00 3/2/2018 Financial Development-Prep Jackson,Jr. Finding principal amounts of Refunded debt. 1.75 245.00 3/6/2018 Financial Development-Prep Jackson,Jr. Refunded debt outstanding principal calc. 0.75 105.00 3/19/2018 Travel Matthes 0.50 210.00 3/19/2018 Meeting Matthes Council Meeting re:Legacy TIF and repayment of 2017 Bonds LR and excess to Big TIF;prep for meeting;file documents,etc. 2.00 840.00 3/20/2018 Correspondence Matthes respond to Henry re:Market District-no minimum assessment agreements;email from Kevin Poore,etc. 0.25 105.00 3/20/2018 Financial Development-Prep Matthes respond to questions from Coonrod and Ben re:Legacy TIF,2017 LIT Bonds,refunding and audit notes,and fiscal plan 0.50 210.00 4/3/2018 Regulatory Report-Prep Ko Gateway Debt Report for 4/15 Report 3.00 270.00 4/3/2018 Financial Development-Prep Amspaugh Assist with 4/15 TIF Mgmt Rpt Debt section;Correspond w DLGF 4.00 1,160.00 4/3/2018 Correspondence Mouser 4/15 related info/questions-debt Ann Bingman,TIF expirations Mike Lee;discuss various w/Loren;City Center 2 call 4.50 1,125.00 4/4/2018 Regulatory Report-Prep Ko Gateway Debt Report for 4/15 Report 0.50 45.00 4/4/2018 Financial Development-Review Amspaugh Review Debt Mgmt Reports for 4/15 Rpt 1.25 362.50 4/5/2018 Financial Development-Prep Mouser Gateway&4/15 report assistance 0.75 187.50 4/9/2018 Umbaugh Reports-Prep Matthes find and send Legacy TIF-LIT Bond Allocation Report to Jacob Quinn (per request)in advance of the Council Finance Committee meeting 0.25 105.00 4/10/2018 Financial Development-Prep Matthes Olivia on Main-tax bill and TIF questions from Chris Carrierre- potential sale of bonds 0.50 210.00 4/11/2018 Financial Development-Prep Matthes reviewing parcel 2018 tax bill detail and 2019 TIF estimate with Courtland;formulating questions for Lee at the County Auditor's office regarding the 2018 tax bill TIF amount based on gross rate, which does not separate out the School Referendum piece 1.00 420.00 4/11/2018 Financial Development-Prep Jackson,Jr. Analyzing the Tax Bill. 5.00 700.00 4/12/2018 Travel Matthes to/from City Hall for Council Finance Committee 0.50 210.00 4/12/2018 Financial Development-Prep Matthes prep for Council Finance Committee meeting re:Legacy TIF and amendment to allow excess for BIG TIF;supporting info and report; post-meeting notes for file and follow-up info for Committee; 1.00 420.00 4/12/2018 Meeting Matthes Council Finance Committee meeting re:Legacy TIF and amendment to allow excess for BIG TIF;discussion of LIT and City finances,CRC hotel loan and CRC Big TIF coverage,etc.;post- meeting discussion 1.25 525.00 4/19/2018 Financial Development-Prep Mouser Gateway,other 0.50 125.00 4/25/2018 Financial Development-Prep Jackson,Jr. Advanced refunding outstanding principal analysis. 1.75 245.00 4/26/2018 Financial Development-Prep Amspaugh Disc w Loren re 2016 Bond Bank Bond questions from Wells Fargo 0.50 145.00 4/26/2018 Financial Development-Prep Matthes questions from Wells Fargo and Stifel;review and prep answers to questions on TIF,LIT,stormwater revenues,circuit breaker,etc.; call with Analysts from Wells and Stifel 2.00 840.00 4/30/2018 Financial Development-Prep Matthes outstanding principal of advance refunded bonds-review info with Courtland;question re:IWC lines etc. 0.25 105.00 Total 100.25 $25,377.50