Financial Report
January 2020
| Balance Sheet by Fund January 31, 2020 | ||||||
|---|---|---|---|---|---|---|
| GENERAL FUND | WATER AND SEWER FUND | TOTAL | ||||
| ASSETS | ||||||
| Current Assets | ||||||
| Cash | 126900.53 | 66400.58 | 193301.11 | |||
| Assessments Receivable – GF | 72057.31 | 0 | 72057.31 | |||
| Allowance-Doubtful Collections | -72057.31 | 0 | -72057.31 | |||
| Accounts Receivable | 0 | 1272.1 | 1272.1 | |||
| Assessments Receivable – W/S Fund | 0 | 218214.89 | 218214.89 | |||
| Allowance-Doubtful Collections | 0 | -218214.89 | -218214.89 | |||
| Due To/From 001/202 | -488263.05 | 0 | -488263.05 | |||
| Due To/From 001/202 | 0 | 488273.05 | 488273.05 | |||
| Investments – Money Market Account | 1377091.24 | 0 | 1377091.24 | |||
| Prepaid Items | 5449.7 | 0 | 5449.7 | |||
| Prepaid Items | 0 | 5449.66 | 5449.66 | |||
| Deferred Amount of Refunding | 0 | 36369.65 | 36369.65 | |||
| Total Current Assets | 1021178.42 | 597765.04 | 1618943.46 | |||
| Noncurrent Assets | ||||||
| Land | 0 | 599674.85 | 599674.85 | |||
| Infrastructure | 0 | 15474044.33 | 15474044.33 | |||
| Accum Depr – Infrastructure | 0 | -6417606.99 | -6417606.99 | |||
| Equipment and Furniture | 0 | 287662.07 | 287662.07 | |||
| Accum Depr – Equip/Furniture | 0 | -125655.39 | -125655.39 | |||
| Total Noncurrent Assets | 0 | 9818118.87 | 9818118.87 | |||
| TOTAL ASSETS | 1021178.42 | 10415883.91 | 11437062.33 | |||
| LIABILITIES | ||||||
| Current Liabilities | ||||||
| Accounts Payable | 2061.57 | 0 | 2061.57 | |||
| Accounts Payable | 0 | 7297 | 7297 | |||
| Revenue Bonds Payable-Current | 0 | 478500 | 478500 | |||
| Accrued Interest Payable | 0 | 18232.82 | 18232.82 | |||
| Other Current Liabilities | 0 | 9644.85 | 9644.85 | |||
| Deposits | 10 | 0 | 10 | |||
| Deposits | 0 | 26139.98 | 26139.98 | |||
| Total Current Liabilities | 2071.57 | 539814.65 | 541886.22 | |||
| Long-Term Liabilities | ||||||
| Revenue Bonds Payable-LY | 0 | 957000 | 957000 | |||
| Total Long-Term Liabilities | 0 | 957000 | 957000 | |||
| TOTAL LIABILITIES | 2071.57 | 1496814.65 | 1498886.22 | |||
| FUND BALANCES/NET ASSETS | ||||||
| Fund Balances | ||||||
| Nonspendable | ||||||
| Prepaid Items | 5449.7 | 0 | 5449.7 | |||
| Prepaid Items | 0 | 5449.66 | 5449.66 | |||
| Assigned | ||||||
| Operating Reserves | 103762 | 0 | 103762 | |||
| Unassigned | ||||||
| Unassigned | 909895.15 | -5449.66 | 904445.49 | |||
| Net Assets | ||||||
| Invested in capital assets, net of related debt | ||||||
| 0 | 8372974.02 | 8372974.02 | ||||
| Unrestricted/Unreserved | ||||||
| 0 | 546095.24 | 546095.24 | ||||
| TOTAL FUND BALANCES/NET ASSETS | 1019106.85 | 8919069.26 | 9938176.11 | |||
| TOTAL LIABILITIES & FUND BALANCES/NET ASSETS | 1021178.42 | 10415883.91 | 11437062.33 |
| PORT OF THE ISLANDS | PORT OF THE ISLANDS | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| COMMUNITY IMPROVEMENT DISTRICT | COMMUNITY IMPROVEMENT DISTRICT | |||||||||
| Non-Ad Valorem Special Assessments | Net Assessment Revenue | |||||||||
| (Collier County Tax Collector – Monthly Collection Distributions) | 2019-09-30 00:00:00 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 | |||||||
| Fiscal Year Ending September 30, 2020 | ||||||||||
| GROSS ASSESSMENTS LEVIED | 360524 | 1261242 | ||||||||
| 0.2223 | 0.7777 | |||||||||
| ALLOCATION | ALLOCATION (net amt) | |||||||||
| Distribution | Gross Amount Received | Discounts/ (Penalties) | Collection Cost | Net Amount Received | General Fund | W/S Fund | General Fund | W/S Fund | Water/Sewer Total | |
| October | 12006.28 | -633.58 | -227.45 | 11145.25 | 2668.996044 | 9337.283956 | 0 | 0 | 0 | |
| November | 129261.69 | -5170.43 | -2481.83 | 121609.43 | 28734.873687 | 100526.816313 | 27033.776289 | 94575.653711 | 94575.653711 | |
| 255508.23 | -10220.2 | -4905.77 | 240382.26 | 56799.479529 | 198708.750471 | 53436.976398 | 186945.283602 | 186945.283602 | ||
| December | 883465.86 | -35249.32 | -16964.32 | 831252.22 | 196394.460678 | 687071.399322 | 184787.368506 | 646464.851494 | #REF! | |
| 33741.96 | -1065.01 | -653.54 | 32023.41 | 7500.837708 | 26241.122292 | 7118.804043 | 24904.605957 | #REF! | ||
| January | 96633.82 | -2668.06 | -1879.31 | 92086.45 | 21481.698186 | 75152.121814 | 20470.817835 | 71615.632165 | #REF! | |
| February | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #REF! | |
| March | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #REF! | |
| April | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #REF! | |
| May | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #REF! | |
| June | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #REF! | |
| July | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| August | 0 | 0 | 0 | 0 | 0 | 0 | ||||
| September | ||||||||||
| 292847.743071 | 1024506.026929 | |||||||||
| TOTAL | 1410617.84 | -55006.6 | -27112.22 | 1328499.02 | 313580.345832 | 1097037.494168 | PREVIOUSLY TRANSFERRED | 500513.22 | ||
| BALANCE REMAINING | 46943.654168 | 164204.505832 | BALANCE REMAINING | #REF! | ||||||
| TOTAL ASSESSMENTS | 1621766 | PERCENT COLLECTED | 0.86980355982306 | |||||||
| PORT OF THE ISLANDS | ||||||||
|---|---|---|---|---|---|---|---|---|
| COMMUNITY IMPROVEMENT DISTRICT | ||||||||
| Cash and Investment Report | ||||||||
| 2020-01-31 00:00:00 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 | |||||
| Account Name | Bank | Yield | Balance | |||||
| GENERAL FUND | ||||||||
| Checking (GF) 9580 | Valley | 0 | 131769.23 | |||||
| Money Market (GF) 1572 | Valley | 0.02 | 1377091.24 | |||||
| Subtotal | 1508860.47 | |||||||
| WATER & SEWER FUND | ||||||||
| Checking (WSF) 8933 | Valley | 0.0194 | 66573.97 | |||||
| Subtotal | 66573.97 | |||||||
| Total | 1575434.44 | |||||||
