The URL can be used to link to this page

Home My Public Portal AboutResolution 2018-40, Approving & Adopting Annual City Street Financial Report July 1, 2017 To June 30, 2018 For Iowa Department Of Transportation WITH CORRECTIONS SEE EXPLANATION RESOLUTION NO. 2018-40 A RESOLUTION APPROVING AND ADOPTING THE ANNUAL CITY STREET FINANCIAL REPORT FROM JULY 1, 2017 TO JUNE 30, 2018 FOR THE IOWA DEPARTMENT OF TRANSPORTATION WHEREAS,the City Council of the City of Riverdale ("City") acknowledges that it is the recipient of State of Iowa Road Use Tax Funds for use in maintaining its roads and streets, pursuant to the Iowa Code Chapter 312; and, WHEREAS, the City is annually required to prepare and file a City Street Financial Report showing receipts, uses and balances; and, WHEREAS, the City Clerk has prepared the online filing of said report and pending approval by the City Council will file it electronically under this Resolution number. NOW THEREFORE, BE IT RESOLVED, BY THE CITY COUNCIL OF THE CITY OF RIVERDALE, SCOTT COUNTY, IN THE STATE OF IOWA: SECTION I: That the City Street Financial Report, form 517001 (5-2018) from the Office of Local Systems for the City of Riverdale, City Number 6492 for fiscal year 2018, electronically posted at 11/06/2018 at 4:01 p.m. is attached to and hereafter made a part of this Resolution. SECTION II: That the City Council does hereby approve and adopt this annual report effective with the passage and approval of this Resolution. PASSED AND APPROVED this (/ day of ' 't46 2018. Michael Bawdenr ayor ATTEST: onald Fullerlove, City Clerk Prepared by City Administrator Tim Long November 8, 2018 :14 it,hi umDOT City Street Financial Report Form 517007 {5-2018} 11/14/2018 12:54 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 1 of 8 Cover Sheet Now therefore let it be resolved that the city council RIVERDALE ,Iowa (City Name) On 11/13/2018 did hereby approve and adopt the annual (month/day/year) City Street Financial Report from July 1, 2017 to June 30, 2018 (Year) (Year) Contact Information Name E-mail Address Street Address city ZIP Code Ronald Fullerlove clerk@riverdaleia.org 110 Manor Dr Riverdale 52722-5726 Hours Phone Extension Phone(Altenative) 10am-5pm Tues,Weds,&Thurs 563-355-2511 563-355-2511 Preparer Information Name E-mail Address Phone Extension Ronald Fullerlove clerk@riverdaleia.org 563-355-2511 Mayor Information Name E-mail Address Street Address- city ZIP Code Michael Bawden mayor@riverdaleia.org 110 Manor Drive Riverdale 52722 Phone Extension 563-355-2511 Resolution Number 2018-40 Michael Bawden Ronald Fullerlove Signature Mayor Signature City Clerk GillUVVADOT City Street Financial Report Form 517007 {5-2018} 11/6/2018 4:01 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 2 of 8 Summary Statement Sheet Column 1 Column 2 Column 3 Column 4 Column 1 Column 2 Column 3 Column 4 Road use Other Street Street Debt Totals Road use Other Street Street Debt Totals Tax Fund Monies Tax Fund Monies Round Figures to Nearest Dollars Round Figures to Nearest Dollars A.BEGINNING BALANCE EXPENSES 1.July 1 Balance $77,193 $50,278 $288,618 $416,089 D.Maintenance 2.Adjustments $0 $0 -$287,879 -$287,879 1.RoadWay Maintenance $28,205 $48,779 $0 $76,984 (Note on Explanation 2.Snow and Ice Removal $3,583 $0 $0 $3,583 Sheet) 3.Adjusted Balance $77,193 $50,278 $739 $128,210 E.Construction, Reconstruction and Improvements B. REVENUES 1.Engineering $0 $0 $0 $0 1.Road Use Tax $51,674 $51,674 2.Right of Way $0 $0 $0 $0 Purchased 2.Property Taxes $48,779 $342,198 $390,977 3.Street/Bridge $0 $0 $0 $0 3.Special $0 $0 $0 Construction Assessments • 4.Traffic Services $0 $0 $0 $0 4.Miscellaneous $0 $0 $0 F.Administration $269 $0 $2,000 $2,269 5.Proceeds from $0 $0 $0 G.Equipment $0 $0 $0 $0 Bonds,Notes,and Loans 6.Interest Earned $85 $110 $195 H.Miscellaneous $0 $0 $0 7.Total Revenues $51,674 $48,864 $342,308 $442,846 J.street Debt (Lines B1 thru B6) 1.Bonds,Notes and $0 $0 $280,000 $0 Loans-Principal Paid C.Total Funds $128,867 $99,142 $343,047 $571,056 2.Bonds,Notes and $0 $0 $37,000 $0 Available Loans-Interest Paid (Line A3+Line B7) TOTALS K.Total Expenses $32,057 $48,779 $319,000 $399,836 (Lines D thru J) L.Ending Balance $96,810 $50,363 $24,047 $171,220 (Line C-K) M.Total Funds $128,867 $99,142 $343,047 $571,056 Accounted For(K+L=C) .i C3W DOT City Street Financial Report Form 517007(5-2018) 11/6/2018 4:01 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 3 of 8 Miscellaneous Revenues and Expenses Sheet Code Number and Itemization of Miscellaneous Revenues(Line B4 on the Summary Column 2 Column 3 Statement Sheet)(See Instructions) Other Street Monies Street Debt Line B4 Totals Code Number and Itemization of Miscellaneous Expenses(Line H on the Summary Column 2 Column 3 Statement Sheet)"On street"parking expenses,street maintenance,buildings,insurance, Other Street Monies Street Debt administrative costs for printing,legal fees,bond fees etc.(See Instructions) Line H Totals 111U 'ADOT City Street Financial Report Form 517007{5-2018} 11/6/2018 4:01 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 4 of 8 Bonds, Notes and Loans Sheet New Debt Type Debt Purpose DOT Issue Issue %Related Year Principal Total Total Principal Interest Principal Bond? Use Only Date Amount to Street Due Balance Principal Interest Roads Roads Balance as as of 7/1 Paid Paid of 6/30 ❑ General Obligation Street 101 03/01/2012 $2,700,000 85 2022 $960,000 $0 $0 $0 $0 $960,000 Improvements New Bond Totals $0 $0 Totals $960,000 $0 $0 $0 $0 $960,000 ,cilitAitiADOT City Street Financial Report 11/6/20184:01 PM Form 517007 {5-2018} Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 5 of 8 Project Final Costs Sheet For construction,reconstruction,and improvement projects with costs equal to or greater than 90%of the bid threshold in effect as the beginning of the fiscal year. Check here if there are no entities for this year j Project Final Costs Sheet (Section A) 1.Project Number 2.Estimated Cost 3.Project Type 4.Public Letting? 5.Location/Project Description(limits,length,size of structure) Project Final Costs Sheet (Section B) 1.Project Number 6.Contractor Name 7.Contract 8.Additions/ 9.Labor 10.Equipment 11.Materials 12.Overhead 13.Total Price Deductions 1irDOT City Street Financial Report Form 517007 {5-2018} 11/6/20184:01 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 6 of 8 Road/Street Equipment Inventory Sheet 1. 2. 3. 4. 5. 6. 7.Used On 8. Local Class Model Description Purchase Lease /Unit Rental /Unit Project Status I.D.# Year Cost - Cost Cost this FY? 401i&' MDOT City Street Financial Report Form 517007 (5-2018) 11/6/2018 4:01 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 7 of 8 Explanation Sheet Comments Column 2,Other Street Monies,Beginning balance of$50,278 was in error. Previous office personnel listed it on the 2017 report as Interest. No such item can be found to justify this entry. Adjustment of this amount is needed to correct the balances. Column 3,Street Debt. Beginning balance of$288,618 was in error. It reflected balance plus revenue of a previous period. Actual balance as of July 1,2017 was $739.39. Adjustment of$287,879 is needed to correct the previous report. • IOWADOT City Street Financial Report Form 517007 (5-2018) 11/6/2018 4:01 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 7 of 8 Explanation Sheet Comments Column 2,Other Street Monies,Beginning balance of$50,278 was in error. Previous office personnel listed it on the 2017 report as Interest. No such item can be found to justify this entry. Adjustment of this amount is needed to correct the balances. c�Act. }cal) c, 6 be%. y� La'R ()it 'e Lf/to)L 0 ►�'1 b nT Column 3,Street Debt. Beginning balance of$288,618 was in error. It reflected balance plus revenue of a previous period. Actual balance as of July 1,2017 was $739.39. Adjustment of$287,879 is needed to correct the previous report. l!-l 4--02o14 OIOWADDT City Street Financial Report Form 517007 {5-2018} 11/14/2018 2:34 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 8of8 Monthly Payment Sheet Month Road Use tax Payments July $5,247.09 August $5,422.87 September $5,295.05 October $3,481.24 November $4,677.93 December $4,056.39 January $3,378.64 February $5,693.69 March $3,606.83 April $1,969.65 May $4,864.65 June $3,979.97 Totals $51,674.00 { 10INWADDT City Street Financial Report Form 517007 {5-2018} 11/14/2018 2:34 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 1 of 8 Cover Sheet Now therefore let it be resolved that the city council RIVERDALE ,Iowa (City Name) On 11/13/2018 did hereby approve and adopt the annual (month/day/year) City Street Financial Report from July 1, 2017 to June 30, 2018 (Year) (Year) Contact Information Name E-mail Address Street Address city ZIP Code Ronald Fullerlove clerk@riverdaleia.org 110 Manor Drive Riverdale 52722-5726 Hours Phone Extension Phone(Altenative) 10am-5pm Tues,Weds,&Thurs 563-355-2511 563-355-2511 Preparer Information Name E-mail Address Phone Extension Ronald Fullerlove clerk@riverdaleia.org 563-355-2511 Mayor Information Name E-mail Address Street Address city ZIP Code Michael Bawden mayor@riverdaleia.org 110 Manor Drive Riverdale 52722 Phone Extension 563-355-2511 Resolution Number 2018-40 Michael Bawden Ronald Fullerlove Signature Mayor Signature City Clerk C iiCANADOT City Street Financial Report Form 517007 {5-2018} 11/14/2018 2:34 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 2 of 8 Summary Statement Sheet Column 1 Column 2 Column 3 Column 4 Column 1 Column 2 Column 3 Column 4 Road use Other Street Street Debt Totals Road use Other Street Street Debt Totals Tax Fund Monies Tax Fund Monies Round Figures to Nearest Dollars Round Figures to Nearest Dollars A.BEGINNING BALANCE EXPENSES 1.July 1 Balance $77,193 $50,278 $288,618 $416,089 D. Maintenance 2.Adjustments $0 $0 -$287,879 -$287,879 1.RoadWay Maintenance $28,205 $48,779 $0 $76,984 (Note on Explanation Sheet) 2.Snow and Ice Removal $3,583 $0 $0 $3,583 3.Adjusted Balance $77,193 $50,278 $739 $128,210 E.Construction, Reconstruction and Improvements B. REVENUES 1.Engineering $0 $0 $0 $0 1.Road Use Tax $51,674 $51,674 2.Right of Way $0 $0 $0 $0 Purchased 2.Property Taxes $48,779 $342,198 $390,977 3.Street/Bridge $0 $0 $0 $0 3.Special $0 $0 $0 Construction Assessments 4.Traffic Services $0 $0 $0 $0 4.Miscellaneous $0 $0 $0 F.Administration $269 $0 $2,000 $2,269 5.Proceeds from $0 $0 $0 G.Equipment $0 $0 $0 $0 Bonds,Notes,and Loans 6.Interest Earned $85 $110 $195 H.Miscellaneous $0 $0 $0 7.Total Revenues $51,674 $48,864 $342,308 $442,846 J.street Debt (Lines B1 thru B6) 1.Bonds,Notes and $0 $0 $280,000 $280,000 Loans-Principal Paid C.Total Funds $128,867 $99,142 $343,047 $571,056 2.Bonds,Notes and $0 $0 $37,000 $37,000 Available Loans-Interest Paid (Line A3+Line B7) TOTALS K.Total Expenses $32,057 $48,779 $319,000 $399,836 (Lines D thru J) L.Ending Balance $96,810 $50,363 $24,047 $171,220 (Line C-K) M.Total Funds $128,867 $99,142 $343,047 $571,056 Accounted For(K+L=C) C4 MI DOT City Street Financial Report Form 517007 ;5-2018} 11/14/2018 2:34 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name R1VFRDALF 3 of 8 Miscellaneous Revenues and Expenses Sheet Code Number and Itemization of Miscellaneous Revenues(Line B4 on the Summary Column 2 Column 3 Statement Sheet)(See Instructions) Other Street Monies Street Debt Line 84 Totals Code Number and Itemization of Miscellaneous Expenses(Line H on the Summary Column 2 Column 3 Statement Sheet)"On street"parking expenses,street maintenance,buildings,insurance, Other Street Monies Street Debt administrative costs for printing,legal fees,bond fees etc.(See Instructions) Line H Totals iltitiir= DOT City Street Financial Report Form 517007 {5-2018} 11/14/2018 2:34 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 4 of 8 Bonds, Notes and Loans Sheet New Debt Type Debt Purpose DOT Issue Issue %Related Year Principal Total Total Principal Interest Principal Bond? Use Only Date Amount to Street Due Balance Principal Interest Roads Roads Balance as as of 7/1 Paid Paid of 6/30 0 General Obligation Street 101 03/01/2012 $2,700,000 100 2022 $960,000 $280,000 $37,000 $280,000 $37,000 $680,000 Improvements New Bond Totals $0 $0 Totals $960,000 $280,000 $37,000 $280,000 $37,000 $680,000 i CSR k?EGIE--1) TRI.C.Vitt g C:". --> EIoeYi, B 1 DoT d!- 1i. c" 1OWADOT City Street Financial Report Form 517007 {5-2018} 11/14/2018 2:34 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 5 of 8 Project Final Costs Sheet For construction,reconstruction,and improvement projects with costs equal to or greater than 90%of the bid threshold in effect as the beginning of the fiscal year. Check here if there are no entities for this year Project Final Costs Sheet (Section A) 1.Project Number 2.Estimated Cost 3.Project Type 4.Public Letting? 5.Location/Project Description(limits,length,size of structure) Project Final Costs Sheet (Section B) 1.Project Number 6.Contractor Name 7.Contract 8.Additions/ 9.Labor 10.Equipment 11.Materials 12.Overhead 13.Total Price Deductions iOWADOT City Street Financial Report Form 517007 {5-2018} 11/14/2018 2:34 PM Office of Local Systems Fiscal Year Ames,IA 50010 Y018 City Name RIVERDALE 6 of 8 Road/Street Equipment Inventory Sheet 1. 2. 3. 4. 5. 6. 7.Used On 8. Local Class Model Description Purchase Lease /Unit Rental /Unit Project Status I.D.# Year Cost Cost Cost this FY? • ilOWADOT City Street Financial Report Form 517007 {5-2018} 11/14/2018 2:34 PM Office of Local Systems Fiscal Year Ames,IA 50010 Y018 City Name RIVERDALE 7 of 8 Explanation Sheet Comments Column 3,Street Debt. Beginning balance of$288,618 was in error. It reflected balance plus revenue of a previous period. Actual balance as of July 1,2017 was $739.39. Adjustment of$287,879 is needed to correct the previous report. IUWADOT City Street Financial Report — Form 517007 {5-2018} 11/6/2018 4:01 PM Office of Local Systems Fiscal Year Ames,IA 50010 2018 City Name RIVERDALE 8 of 8 Monthly Payment Sheet Month Road Use tax Payments July $5,247.09 August $5,422.87 September $5,295.05 October $3,481.24 November $4,677.93 December $4,056.39 January $3,378.64 February $5,693.69 March $3,606.83 April $1,969.65 May $4,864.65 June $3,979.97 Totals $51,674.00 Tue Nov 6,2018 4:09 PM BALANCE SHEET Page 1 CALENDAR 6/2018, FISCAL 12/2018 MTD YTD ACCOUNT NUMBER ACCOUNT TITLE BALANCE BALANCE 001-000-1110 CHECKING - GENERAL 18,055.51- 466,119.25 110-000-1110 CHECKING - ROAD USE 1,545.70 96,810.05 111-000-1110 CHECKING - I-JOBS .00 .00 121-000-1110 CHECKING - LOCAL OPTION 9,715.36 219,927.77 125-000-1110 CHECKING - TIF URBAN RENEWAL 56,998.91- 85,206.24- 150-000-1110 CHECKING - FIRE AWARD .00 96.32 200-000-1110 CHECKING - DEBT SERVICE 750.47- 24,047.13 300-000-1110 CHECKING - CAPITAL IMPROV LEVY 32.50 12,351.43 301-000-1110 CHECKING - CAPITAL RESERVE 37.44 155,521.46 301-000-1111 CHECKING - CAPITAL IMP LEVY .00 114,575.95 302-000-1110 CHECKING - ROAD REPLACEMENT .00 3,562.41 303-000-1110 CHECKING - FIRE EQUIP/REPLACE .00 3,562.41 304-000-1110 CHECKING - 2011 CAP PROJECT .00 .00 610-000-1110 CHECKING - SEWER 7,759.49- 37,703.95 611-000-1110 CHECKING - SEWER CAP. PROJECTS 26,217.65- 27,814.23- CHECKING TOTAL 98,451.03- 1,021,257.66 150-000-1150 IPAIT - FIRE AWARDS FUND .00 .00 200-000-1150 IPAIT - DEBT SERVICE .00 .00 300-000-1150 IPAIT - CIP LEVY .00 .00 300-000-1151 IPAIT - CIP LEVY .00 .00 301-000-1150 IPAIT - CAPITAL IMPROVEMENT .00 .00 301-000-1151 IPAIT LEVY - CAPITAL IMPROVMNT 128.92 102,338.08 304-000-1150 IPAIT .00 .00 610-000-1150 IPAIT - SEWER 106.20 84,305.12 IPAIT TOTAL 235.12 186,643.20 001-000-1160 SAVINGS-IHMVCU .00 5.00 SAVINGS-IHMVCU TOTAL .00 5.00 001-000-1170 CD #183956 - GENERAL .00 .00 001-000-1172 CD #910000001413 GENERAL CD .00 .00 001-000-1173 CD #910000001294 - MAINTENANCE .00 .00 150-000-1170 CD #183940 - FIRE AWARDS .00 .00 301-000-1170 CD #182633 - CAPITAL RESERVE .00 .00 301-000-1171 CD #187541 - CAPITAL RESERVE .00 .00 301-000-1172 CD #910000001414 CAP. RESERVE .00 .00 301-000-1173 CD #183736 - CAPITAL IMPROVE .00 .00 302-000-1170 CD #910000001296 RD REPLACEMTN .00 .00 303-000-1170 CD #910000001297 FDEQUIP TRUCK .00 .00 CD'S TOTAL .00 .00 001-000-1174 CD-IHMVCU-#42 MAINTENANCE 37.30 30,326.92 GLBLCERP 05/11/18 OPER: REF CITY OF RIVERDALE Statement Writer:00 Report Format:CASH Tue Nov 6,2018 4:09 PM BALANCE SHEET Page 2 CALENDAR 6/2018, FISCAL 12/2018 MTD YTD ACCOUNT NUMBER ACCOUNT TITLE BALANCE BALANCE CD-IHMVCU-MAINTENANCE TOTAL 37.30 30,326.92 001-000-1175 CD-IHMVCU-#43 GENERAL 61.95 50,362.61 CD-MVCD # 8888 General TOTAL 61.95 50,362.61 301-000-1176 CD-IHMVCU-#44 CAPITAL RESERVE 123.89 100,725.19 CD TOTAL 123.89 100,725.19 302-000-1177 CD-IHMVCU-#45 ROAD REPLACE 61.95 50,362.61 CD TOTAL 61.95 50,362.61 303-000-1178 CD-IHMVCU-#46 FD EQUIP REPLACE 61.95 50,362.61 CD TOTAL 61.95 50,362.61 TOTAL OF ALL CASH 97,868.87- 1,490,045.80 GLBLCERP 05/11/18 OPER: REF CITY OF RIVERDALE Statement Writer:00 Report Format:CASH