Loading...
HomeMy WebLinkAboutPACKET Audit Committee 2017-12-141 Thursday, December 14, 2017 8:00 a.m. ,(+Qa Administration Conf. Room E 1. CALL TO ORDER 2. NEW BUSINESS a) Review Swanhorst & Company LLC Reference Checks. b) Discuss Selection of Swanhorst & Company LL. 3. ADJOURN Town of Estes Park Audit Committee Meeting Packet Dec 14, 2017, 8:00 AM Index of Contents 1. Audit Proposal Summary Sheet 2. Swanhorst and Company a) References b) Auditor Interview Questions 3. Haynie & Company a) Audit Committee Presentation b) Auditor Interview Questions 4. Anton Collins Mitchell LLP a) Audit Committee Presentation b) Auditor Interview Questions Town of Estes Park Audit Proposal Summary Sheet 2017 - 2021 Audit Proposals Selected for Interviews McGee Possible Anton, Collins Haynie & Swanhorst & Hearne & RubinBrown Points Mitchell LLP Company Company LLC Paiz, LLP LLP Mandatory Elements The audit firm is independent and licensed to practice in Colorado Y or N y y y y y The firm does not have a conflict of interest with regard to any other work performed by the firm for the Town Y or N y y y y y Firm followed RFP instructions Y or N y y y y y Firm submitted last external quality control review report Y or N y y y y y Technical Quality (Max 60 points) Expertise and Experience The firm has past experience on comparable government engagements. 20 18.0 16.5 18.0 16,3 18.3 The firm has proposed quality and experienced personnel to the engagement. 15 13.3 12.5 13.8 12.8 13.5 The firm has proposed quality management support personnel for technical consultation as needed 5 4.5 4,3 4.8 4.3 4.8 The degree to which the proposal meets or exceeds the terms of this RFP 5 4.8 4.8 4.5 4.3 5.0 0.0 0.0 0.0 0.0 0.0 Audit Approach 0.0 0.0 0.0 0.0 0.0 Adequacy of proposed staffing plan for the various segments of the engagement. 5 3.8 2.8 3.8 2.8 3.8 Adequacy of sampling techniques 5 3.8 3.8 2.8 2.8 3.5 Adequacy of analytical procedures 5 2.5 3.8 3.3 3.3 3.3 Total Technical Quality Price (Max 40 points) 1 point lost per 2,000 over low bid Total 2017 Town 2017 VEP 2017 Hours 60 50.7 48.5 51.0 46.6 52.2 40 37.0 40.0 39.5 38.0 29.5 100 87.7 88.5 90.5 84.6 81.7 $ $ 42,500 $ 37,000 $ 38,000 $ 40,970 $ 58,000 4,000 $ 3,000 $ 6,000 $ 12,000 $ 11,000 364 286 360 530 450 ots ',N401 015 1/" rd a) 0 • 11°11•••• a) '14z rd 0 e aft 4) a) E a) E rn 4J E 0 a) -C3 locations a Tho 4.1 • ccS mn CT 73 CU rn C3) CY) a) mi 4—# rn 0 a) 0 en 0 O NMIElita tr) ma)d u - 4.0 (3) aeZ 73 C 0 rn a) E a) rn en E 73 fts 7-/I C c • 4.4 0 • MINN u L.) rt$ rcS ▪ MUM Our services tax. cons a) . 0 r L. N c ccS C 0 2 m CZS (1) 4- v) c 4® '— 0 v) 4-, vi 47; . • O cTS a--+ E 8 a2 a) c 4-0 tin = v) -To a$ v) a) cm 0 r% 2.) 0 rz a) ..0 t • — C:71 4_,a) ft) cu L- cV c •1‘11 v9 rlz$ c V � 472 'i 71.5 .O u > W E aci 4"' u O v9 a=+ .. 4.0 u 01 L u aJ E 0 cu i .® i u u 21. 2._ E O > E E ccS 0 -0 i 0 01 `n aJ cU L.... E a aJ = I kJ •— LA -0 a) 0 v) 0 ctj 0 c N • — I '�' C ate+ a 0 _� c a� '® 0 2 cu ® uv) 5 .47,› ow 0 '5 ,O o a� u N cz ! .-r! o E " ki rj .. = > > ti'i c " EX a 0) .,� 0 Lki a) eer Review Qualified U II MOM ._ 0 4J a% U Tzs Or vernment dam•+ • moss Cy a) a) a) a) O U cvi a) UrrrrJJflrmf Resources • ccS .=MI 0 '� 13 L L 0 O ® rIS I , <.t�QZev) N UMa.0 c CZ • 4-0 ate.+ .+ +-' V u ® u u d V u LA C u <C Q 0 <t a_ Q) u u V • u V u. 13 0 � _O a) aJ ▪ -0 73 : u a-+ 0 '- ii a) U au a a) m V 4-UU'it U =0 a) 0 OI 0 E rsQ v a) 0 O au N 0 ;.�, c 'u .7 'L) > • 'v'v O � ® � cn u .2 V) • a) 1 0 <t C 0 in 0 •els 0 Ci" (IS -0 0 v) c -O c 0 aJ = 'aJ Ls� c� � Ls • In as V) E 0 a--, aJ • ctS 0 a) �-+ C UDF-UU U A w a) 47.5 +� 0 V r , a) u +4 V w 4- 0 0 0 s O cu =U oU c m V • 'c m • u a O 4n E 2'V O a; c.cs +� V) Z N N TES 0 .rn rn a) 4- U 4- 0 a-+ 0 N 0 rn Z Service Team olman, CPA - Audit Partner ick, CPA - Engagement Quality Review Partner 1101161 C7 co co 2 Christine McLeod, CPA - Audi Shannon Fuller - Senior Auditor L 0 O V as c Q. as E O a) U V W a1 to aJ a) c ca L �L 'E Q O _c as — >. X 'tn V aJ r >` a) 0) ��.J >; at i 4- _ _ Z > a 4.44 CC O cd •� C1O 4_) to aJ V to -0it.a) a •= as c� -0 0 5— Vat cp c aRi O D Ol 'E_ aJ c H rz$ C1 E Q L to . in 76 C a S1 LA tic a) co J a) ac vi m c" M L V _= O Q_ to Vas a1 aJ 1- >.0 O . — c: » >O 0 cm c to Oj a=+ Zi � � 1. = ai L. V rd Benefits from our audit — In 0.) 4-,=-§=—B° moTvc c .0 4"+ O -00M 0 -0CWU a) a--+ 04: CDCS51 m E• N >`1.4 ftS v, — 4_+ 0 . rn v as=�a--' . co mricsL-cu c 4J'MsLu '-Mca'-p•Mw -> crn0-CSCE5-2 •- c 0 c < 8.- • cenl-cu • >,w w E a)4-+4J �,> a.) � � u (J ° a r D) c -a CC Q = aJ O -Ca) sa)0r_ LE 73 WCCW >,•- •- 17t;EC om1-N =how '��00 <m m d Client acceptance Identify key processes and transactions Establish engagement dates Determine materiality Entrance conference t14) C CO Review policies and procedures Review internal control documentation Perform walkthroughs of key processes Interview client personnel Review prior -year and interim financial data Review preliminary financial data Develop targeted audit procedures bI VI 411 C ea E aa c a 0 E co t 4.1 15 C a) Coordinate audit fieldwork with management 4.1 • IMO INC m 0. 2 O Q. a)C2. > < a) .L. Ne 0 „▪ (7) U- Substantive testing Analytical testing Review of audit results with management Progress report to management a) • -o Prepare/Review draft financial statements Issue final opinions btj o. cc Meet with audit committee and management w .-1 cCf V L.)— m CI r� rES `• (I) 0 7:28c10) ,— CW a)a L) v) ��/'�C=tea—"r�W= rt$ 4-# Ld CV.U0C1-115 �v��Z3 rt$0O MECUUUa�aJ w ' v7 " E ri rcs+-' a S t f) uL_wcwom O0a)r�w ..•cu �,,0��C0.c_ .�.—.N OLD c� i— v' 'rd V s r N aJ r- °4-'EI'm"EN(ti(' _ �r��n0 0Ww.foo� ��a) V .-.E v V k.1&9-.,"..,J.. aJ _c , aa- 0 4--+ 0 C w7_4A Q EEo. rs '—.c3L-0cc3 •Q' .mcuom -1-7 nw=wa)uLnc-com comc (:).. mi—u ', a) � r v0OVO'r�a) Z3 (./) CD >- v) CO CO ba O CU 0 U Q o2S -� 4-0 co a) >- co vi co +-J O co +_+ CU a) Q n tr) � O � Q c O CU E 0 > •CU C 4-1 cn E 2 U D = 0._C = 73 i 0_V CD O0 CU +—P N co O C � - _C 4-1 -§ - 0 +-0 O N .N N ICU L O •U a) - }' - >► 73 4A O a) n3 CD CI) L O H 4 :owe r CO L. 0C>1 ,'''v'''','-: V 0 w ix .— l 0,) _ 4) c � �„�:a R IC [ o111111111111 8 r/ :1111111,11,111 11111111111111111111111111111111H, II?11111111111111111111y111'1' 'A1 °lulu 11101111111)))11111111111111111011111111111.1.1111.1i111111111111111,v,v,v,v,v„1,11,111,1,1.1iii01(:, (1) tot e o of stes ar U m with an offi c e _c Ea) t Z u 0 o 0-0 0 c 4--P 0 c •— -,-, 4- -, .I__c c ()) u; 0 > • 4 E > C .L;.. L. C o E >,.. 0 u ._ o ca. c as o a) ._."-' CL t_ 0 0 4--# _.4' 0'''‘ U (t C -C ecl C 4-' V Ce ai 6 >. co L >,.. Tv to c 7") o ia) c -1-, E 0 L. • 7; ttzi cu 0 0 r1.0 CL Q.9 U 15 U 0 7:7 0 L . 0 ca. X 7viu 0 -0 C a) ocal office, ioca C a) b.° c cu 0 v.0 CcL< 0 E L 4-- E c, t- = 1.r) L. c E cu o 0 (a▪ ) 12) CO F— I-- 0 4.i 0 a) C C rzt 0 4=5 c ment to serving exempt organizations. to the Town of Estes Park s_ 0 ave the Town L a) a) C ci s— C a) U CY C C L ci) < a-- U U 0 <U LU < 0 o u 4-1 L.; 7:3 E (7i cr) 4J4— s- -C 0 vs cts N (1) _c L— C 4—) L.. CL E < 7:1 ri L ar so there are no 4—) 0 U 0_ E E E u E a. a) c c E 1„11111,,,c,,,11,111,11,11,11,11,1,11 1'1,1 a) 0 a.. (4= uj 0 U ta) - u _C Fair and Reason -a) crl nvestment 0 H a) E L. 4- L cr cu L 0 4-• C "CI bp w aif ) CL 0 0 12 (T$ L. -C 1:1.- E c) .— E (1) ai a) u 0 cc > E 0 (1) 4-1 c 7 •r) — a) ,0CrS 4-• 0 T.j. ci).0 LCD )._ 0LCD -ICI -ct 4.) E c c o a) tx0 C _C C 4-) . al 0 4-j -C .4J 0 4-•• 4-• al _C L. a)L". >CDL0 L. © • 57) « z •••••••• •• „. • ••• • • ••• • • • . ,„: ••••• • „,.. ..•,•• • •• .• • . • , „. • • .....•••• • •••• • .• .,....• • • • • • • ... • .. •, . • • ...• •• • • ••• • •. ..... • ••••• •• • .. • , • •••• " •""'" •••• •• •• •" '". •••••••••••••••••••••"""- •"•"'"'""'" """' • ••• ••••;,•••" • •••.:,":;• • • E U It evant educational 110 0 ment to meet the E 0 b.° L 0 z 0 0 L 4-) 0 0 L a) C tri L 4-1 ACM has received a) a) L -0 C rd C 0 a) C) 0 E c rts 0 coU L 0 o, > 0 = eL c co' L 01 a; f 1 1 i 0 -0 06- 4- L.- al U 0 E L. c4= L tab L.. O 0 0 u• m L. = u Imi 0 mt) C CD CL LU CD .0 a. -a o to) 11 1111111:1"" ......... ''''111,1,4111111111,1„ C rri ru b 5 Ei t11111 00000000010010 11111111111111111 171' 1,10110.;:ii D co C 0 a) . _a 0 0 _c u) X (I) > 0 -0 Co C -0 -0 0 Co 0 • •• ••••• •• ••••••-••• •.;•••;••••.•.••.,„,' • • • • • ••••• • •• co _c (/) 2 co co C E E c o (13 Co _c c.) 02 co 0. JLL U)E CO o -o • o c c c c c co ci i i i i i i a) i i i E a) tko boo a) cd C cd a) O z Z U Q ors from each o 0 a U 11,'P1iouumuin 0, 20% of ACM • — X CL CL U CY a) 4- 0 n the Governm Member Firm 0 cn 4-) 4-) 0 cc:JD L 0 4- V) a) E MOMIONIMIt 0 0 0 *(.7) a) b.() U 0 (I L._ a) c o c 0 • =•., (1) > CL bOQ L ci L Cn L. cvj 7:1 „d,'11111 BDO USA, LLP illy 0 ohooloo ilill'111111'111'11111111111111111111111111111111111111111111111111111111111111LIIIIIIIIIIIIIIIIIIth. fill11111 1111 1111111 111111111111111,1,111j,11, „111.111111111111111111111110 0 0 0 0 011111111111111111111 111111111111,1,1,(1,1,viviviv,((((11111111111111111111111,P1,1,1„ '1,11,11,111,1111111111111111)111111111111""lo, 1,1 ''''11,01:111:111:111.1.11,10,1) 111'11,1, 1111„g11, fp,11:111:11111(11011,1,1, ir I o ol111111111p 11111111111111111P1110 IA' „A *kr ,d,d11 fir 1111,1,,,,I),,1„1111 1111111111111111111111111111111 r‘ • • 0 1r ito • • OiNetl"11/' '1114 414 vv42,7vvv fi00 a Ln 5 nn co il v A r 1001,00440,,0 .,.41 .._.,, r 1,3 .5. (11 P. it..; Li 77 ill C 0 ,VV1 viv3 . 0 111 41 0 E -5 43 .,„,-6,,,,$ it, ,-; 43 tt, CU g ,k 4 1,1),(11,,V,VVV 111111111111111111111111 oral rassoli O tant Superintendent of Busin C 0 4J C Q 0 -C V 1" cl) >%. ni E 0— = (1) 0 w CL 0 0 CU C 4-1 0 a) r— (1) > L 0 oloilloill'1,11111::11111111111 Town of Estes Park RFP-SMP-FI-002 Proposals for Professional Audit services Years Ending Dec 31, 2017, 2018, 2019, 2020, 2021 Proposal Tabulation The following firms (presented in alphabetical order) have submitted proposals by the Oct 30, 2017 5:00 PM deadline and are eligible for consideration. 1) Anton Collins Mitchell LLP 303 East 17th Ave, Ste 600 Denver, CO 80203 2) Haynie & Company 873 North Cleveland Ave Loveland, CO 80537 3) McGee, Hearne & Paiz, LLP 155 East Boardwalk Dr, Ste 320 Fort Collins, CO 80525 4) RubinBrown LLP 1900 16th St, Ste 300 Denver CO 80202 5) Swanhorst & Company LLC 8400 E. Crescent Parkway, Ste 600 Greenwood Village, CO 80111 Town of Estes Park Audit Proposal Bid Tabulation Swanhorst & Company LIC FYE 2017 - 2021 # Hours 2017 2018 2019 2020 2021 Total 360 360 360 360 360 1800 All Inclusive Bid, including Single Audit $ 38,000 $ 38,000 $ 38,000 $ 39,000 $ 39,000 $ 192,000 Alternate - Separate Audit for VEP Town 34,500 34,500 34,500 35,500 35,500 174,500 VEP 6,000 6,000 6,000 6,000 6,000 30,000 Total $ 40,500 $ 40,500 $ 40,500 $ 41,500 $ 41,500 $ 204,500 Town of Estes Park Audit Proposal Bid Tabulation Haynie & Company FYE 2017 - 2021 # Hours 2017 2018 2019 2020 2021 Total 286 277 277 277 277 1394 All Inclusive Bid, including Single Audit $ 39,000 $ 39,000 $ 41,000 $ 41,000 $ 43,000 $ 203,000 Alternate - Separate Audit for VEP Town * ? ? ? ? ? VEP 3,000 3,000 3,200 3,200 3,400 15,800 Total $ 3,000 $ 3,000 $ 3,200 $ 3,200 $ 3,400 $ 15,800 * Firm may have misunderstood rate quote form. This amount is expected to be less than the all inclusive bid. If selected, this needs to be clarified before signing the contract. Town of Estes Park Audit Proposal Bid Tabulation Swanhorst & Company LLC FYE 2017 - 2021 # Hours 2017 2018 2019 2020 2021 Total 364 364 364 364 364 1820 All Inclusive Bid, including Single Audit $ 42,500 $ 46,000 $ 48,000 $ 50,000 $ 52,500 $ 239,000 Alternate - Separate Audit for VEP Town * ? ? ? ? ? VEP 4,000 4,200 4,400 4,600 4,900 22,100 Total $ 4,000 $ 4,200 $ 4,400 $ 4,600 $ 4,900 $ 22,100 * Firm may have misunderstood rate quote form. This amount is expected to be less than the all inclusive bid. If selected, this needs to be clarified before signing the contract.