Title: CRN Amended Final Budget 2018-2019.xlsx
Author: JWalker

Coronado Community Development District

Amended Final Budget For Fiscal Year 2018/2019
October 1, 2018 - September 30, 2019

CONTENTS

AMENDED FINAL OPERATING FUND BUDGET

AMENDED FINAL DEBT SERVICE FUND BUDGET

AMENDED FINAL BUDGET
CORONADO COMMUNITY DEVELOPMENT DISTRICT OPERATING FUND
FISCAL YEAR 2018/2019 OCTOBER 1, 2018 - SEPTEMBER 30, 2019

REVENUES

FISCAL YEAR 2018/2019 BUDGET 10/1/18 - 9/30/19

AMENDED FINAL BUDGET
10/1/18 - 9/30/19

YEAR TO DATE ACTUAL
10/1/18 - 9/29/19

Administrative Assessments | 79,081 | 80,297 | 80,297
Maintenance Assessments | 120,895 | 120,895 | 120,895
Debt Assessments | 252,625 | 252,625 | 252,625
Master Association Contributions | 66,300 | 69,411 | 69,411
Interest Income | 240 | 670 | 656
TOTAL REVENUES | $	519,141 | $	523,898 | $	523,884
EXPENDITURES | | |
ADMINISTRATIVE EXPENDITURES | | |
Supervisor Fees | 7,000 | 4,000 | 4,000
Payroll Taxes | 735 | 306 | 306
Management | 34,632 | 34,632 | 34,632
Field Operations Management | 1,500 | 1,500 | 1,500
Legal | 10,000 | 3,500 | 2,196
Assessment Roll | 3,000 | 3,000 | 3,000
Audit Fees | 3,500 | 3,500 | 3,500
Insurance | 7,200 | 5,000 | 5,000
Legal Advertisements | 1,800 | 1,000 | 472
Miscellaneous | 2,000 | 1,500 | 1,157
Postage | 550 | 225 | 217
Office Supplies | 800 | 475 | 420
Dues & Subscriptions | 175 | 175 | 175
Trustee Fee | 4,600 | 3,165 | 3,165
Continuing Disclosure Fee | 500 | 350 | 350
Website Management | 1,500 | 1,500 | 1,500
Operating Reserve | 4,200 | 1,000 | 0
TOTAL ADMINISTRATIVE EXPENDITURES | $	83,692 | $	64,828 | $	61,590
MAINTENANCE EXPENDITURES | | |
Security Services | 132,600 | 138,726 | 138,726
Aquatic Maintenance/Midgefly Control | 4,750 | 2,500 | 1,705
Fountain Maintenance/Power - FPL | 2,400 | 1,500 | 808
Storm Drainage Maintenance | 2,400 | 250 | 0
Engineering | 2,400 | 2,400 | 1,689
Roadway/Street Maintenance | 6,000 | 2,500 | 350
Soft Gates & Security Cameras Maintenance | 4,200 | 0 | 0
Soft Gates Control/Power - FPL | 3,000 | 0 | 0
Security Camera Monitoring | 14,400 | 1,500 | 750
Contingency | 6,000 | 2,000 | 0
Maintenance Reserve | 3,000 | 1,000 | 420
TOTAL MAINTENANCE EXPENDITURES | $	181,150 | $	152,376 | $	144,448
TOTAL EXPENDITURES | $	264,842 | $	217,204 | $	206,038
REVENUES LESS EXPENDITURES | $	254,299 | $	306,694 | $	317,846
Bond Payments | (239,994) | (241,673) | (241,673)
BALANCE | $	14,305 | $	65,021 | $	76,173
County Appraiser & Tax Collector Fee | (4,526) | (4,382) | (4,382)
Discounts For Early Payments | (18,104) | (15,244) | (15,244)
EXCESS/ (SHORTFALL) | $	(8,325) | $	45,395 | $	56,547
Carryover From Prior Year | 8,325 | 8,325 | 0
NET EXCESS/ (SHORTFALL) | $	- | $	53,720 | $	56,547
Notes
Carryover From Prior Year Of $8,325 used to reduce Fiscal Year 2018/2019 Assessments Carryover From Prior Year Of $4,800 to be used to reduce Fiscal Year 2019/2020 Assessments

FUND BALANCE AS OF 9/30/18
FY 2018/2019 ACTIVITY
FUND BALANCE AS OF 9/30/19

$241,697
$45,395
$287,092

10/9/2019 10:56 AM	^I

AMENDED FINAL BUDGET
CORONADO COMMUNITY DEVELOPMENT DISTRICT DEBT SERVICE FUND
FISCAL YEAR 2018/2019 OCTOBER 1, 2018 - SEPTEMBER 30, 2019

REVENUES

FISCAL YEAR 2018/2019 BUDGET 10/1/18 - 9/30/19

AMENDED FINAL BUDGET
10/1/18 - 9/30/19

YEAR TO DATE ACTUAL
10/1/18 - 9/29/19

Interest Income | 100 | 1,025 | 1,009
NAV Tax Collection | 239,994 | 241,673 | 241,673
Total Revenues | $	240,094 | $	242,698 | $	242,682
EXPENDITURES | | |
Principal Payments (2017) | 117,000 | 117,000 | 117,000
Interest Payments (2017) | 122,891 | 124,134 | 124,134
Bond Redemption | 203 | 0 | 0
Total Expenditures | $	240,094 | $	241,134 | $	241,134
Excess/ (Shortfall) | $	- | $	1,564 | $	1,548

FUND BALANCE AS OF 9/30/18
FY 2018/2019 ACTIVITY
FUND BALANCE AS OF 9/30/19

$193,816
$1,564
$195,380

Notes
Reserve Fund Balance = $120,968*. Revenue Fund Balance = $74,412*.
Revenue Fund Balances To Be Used To Make 11/1/2018 Interest Payment Of $60,824.
* Approximate Amounts

As Of 9/30/2019 - Construction Account Balance = $196,859. Fiscal Year 2018/2019 Capital Outlays = $42,011.

Series 2017 Bond Refunding Information
Original Par Amount = | $3,399,000 | Annual Principal Payments Due:
Interest Rate = | 2.125% - 4.25% | May 1st
Issue Date = | April 2017 | Annual Interest Payments Due:

Maturity Date =

Par Amount As Of 9/30/19 =

May 2038

$3,168,000

May 1st & November 1st

10/9/2019 10:56 AM	^II