CLPOIA May 2020 Financial Presentation CLPOIA May 2020 Monthly - PowerPoint PPT Presentation

CLPOIA May 2020 Financial Presentation

CLPOIA May 2020 Monthly Reports • Cash Balance Report • Profit & Loss Budget Performance • Profit & Loss Budget vs. Actual (Month) • Profit & Loss Budget vs. Actual (YTD) • Profit & Loss Previous Year Comparison (Month) • Profit & Loss Previous Year Comparison (YTD) • Reconciliation Detail (Month)

CLPOIA May 2020 Presentation Method Cash Basis vs Accrual Basis

CLPOIA May 2020 Summary Financial Information Cash Balance Report Cash Resources: Dec‐19 Jan 2020 Feb‐20 Mar‐20 Apr‐20 May‐20 Checking $120,694.98 $151,321.99 $104,123.09 $94,636.05 $65,043.70 $52,756.68 New Money Market $102,210.90 $102,239.32 $102,271.67 $102,300.11 $102,328.56 $102,359.96 Petty Cash $70.07 $70.07 $63.22 $62.02 $62.02 $62.02 Resale $6,872.75 $6,872.75 $7,101.25 $7,519.55 $7,519.55 $8,453.15 Recreation $1,505.20 $1,505.20 $1,415.59 $1,341.16 $1,341.16 $1,341.16 New CD 32617 ** $26,315.16 $26,315.16 $76,315.16 $76,315.16 $76,315.16 $76,315.16 Total $257,669.06 $288,324.49 $291,289.98 $282,174.05 $252,610.15 $241,288.13 Budgeted Revenues Remaninder of Year $148,800.70 $128,645.10 $118,045.00 $97,389.00 $93,624.00 Budgeted Expenditures Remainder of Year ‐$184,048.90 ‐$165,636.14 ‐$143,170.91 ‐$107,122.32 ‐$90,041.26 Estimated Cash Balance at December 2020 $253,076.29 $254,298.94 $257,048.14 $242,876.83 $244,870.87 Estimated 6 months of Expenditures Emergency Funds ‐$92,024.45 ‐$92,024.45 ‐$92,024.45 ‐$92,024.45 ‐$92,024.45 Budgeted Maintenance Fee Income Nov/Dec 2020 ‐$72,373.00 ‐$72,373.00 ‐$72,373.00 ‐$72,373.00 ‐$72,373.00 Estimated Remainder For Large Expenditures $88,678.84 $89,901.49 $92,650.69 $78,479.38 $80,473.42

CLPOIA May 2020 Summary Financial Information Profit & Loss Budget Performance May 20 Budget Jan - May 20 YTD Budget Annual Budget Ordinary Income/Expense Income Total Income 5,847.63 3,765.00 78,206.81 91,150.00 184,774.00 Gross Profit 5,847.63 3,765.00 78,206.81 91,150.00 184,774.00 Expense Total 4085 ꞏ COMMUNITY CENTER 0.00 99.00 463.97 828.00 1,715.00 Total 5000 ꞏ SANITATION 3,311.53 1,518.00 8,572.51 8,687.00 23,947.00 Total 5100 ꞏ INSURANCE 0.00 0.00 9,323.40 9,023.00 9,126.00 Total 5200 ꞏ PUBLIC AREA/RECREATION 4,121.65 816.00 14,629.49 4,669.00 15,122.00 Total 5300 ꞏ ROAD MAINTENANCE -239.79 0.00 12,243.34 990.00 2,066.00 Total 5400 ꞏ SECURITY/GATE 4,040.00 1,518.00 16,701.16 9,293.00 41,619.00 Total 5500 ꞏ ADMINISTRATION 2,753.31 5,305.00 27,297.26 19,857.06 34,248.06 5526 ꞏ A/R BUSINESS FEES 8.26 22.00 384.09 489.00 654.00 5530 ꞏ MISC. 0.00 0.00 0.00 0.00 0.00 Total 5550 ꞏ CLPOIA EMPLOYEES 2,050.03 3,298.00 10,418.73 15,955.00 40,472.00 Total 5700 ꞏ CAPITAL IMPROVEMENTS 0.00 25,000.00 0.00 25,000.00 50,000.00 Total 5800 ꞏ TAXES 0.00 0.00 251.49 69.00 138.00 Total 6100 ꞏ DAM MAINTENANCE 1,000.00 0.00 1,066.42 2,000.00 2,550.00 6400 ꞏ PAYROLL EXPENSES 0.00 0.00 0.00 187.00 187.00 6550 ꞏ FISH & WILDLIFE 0.00 0.00 0.00 0.00 13,900.00 69810 ꞏ Bank Service Charges 0.00 5.00 Total 7300 ꞏ CD,SAVINGS&EXTRACURRICULARACCT 0.00 80.00 242.57 1,051.00 5,654.00 Total Expense 17,081.06 37,724.00 101,863.80 98,568.06 241,905.06 Net Income -11,218.43 -33,959.00 -23,641.99 -7,418.06 -57,131.06

CLPOIA May 2020 Primary Variances Income Month YTD Income Variance May 20 Budget Jan - May 20 YTD Budget Annual Budget Variance Variance MAINTENANCE FEE INCOME 1,858.14 1,912.00 61,053.47 79,871.00 159,467.00 -53.86 -18,817.53 ALL OTHER INCOME 3,989.49 1,853.00 17,153.34 11,279.00 25,307.00 2,136.49 5,874.34 TOTAL INCOME 5,847.63 3,765.00 78,206.81 91,150.00 184,774.00 2,082.63 -12,943.19 MAINTENANCE FEE INCOME NOVEMBER 2019 26,251.97 20,307.00 5,944.97 MAINTENANCE FEE INCOME DECEMBER 2019 60,742.74 51,788.00 8,954.74 86,994.71 72,095.00 14,899.71

CLPOIA May 2020 Primary Variances Expense Month YTD Expense Variance May 20 Budget Jan - May 20 YTD Budget Annual Budget Variance Variance PUBLIC AREA/RECREATION 4,121.65 816.00 14,629.49 4,669.00 15,122.00 -3,305.65 -9,960.49 ROAD MAINTENANCE -239.79 0.00 12,243.34 990.00 2,066.00 239.79 -11,253.34 SECURITY/GATE 4,040.00 1,518.00 16,701.16 9,293.00 41,619.00 -2,522.00 -7,408.16 ADMINISTRATION 2,753.31 5,305.00 27,297.26 19,857.06 34,248.06 2,551.69 -7,440.20 CLPOIA EMPLOYEES 2,050.03 3,298.00 10,418.73 15,955.00 40,472.00 1,247.97 5,536.27 12,725.20 10,937.00 81,289.98 50,764.06 133,527.06 -1,788.20 -30,525.92 ALL OTHER EXPENSES 4,355.86 1,787.00 20,573.82 22,804.00 58,378.00 -2,568.86 2,230.18 TOTAL EXPENSES 17,081.06 12,724.00 101,863.80 73,568.06 191,905.06 -4,357.06 -28,295.74 PUBLIC AREA/RECREATION - Contract mowing ($3,525), Dock Children’s Park Dock ($2,400), Contract Maintenance ($4,342.50) ROAD MAINTENANCE - Culvert Repair ($6,670), Wetland Report ($4,800). SECURITY/GATE - Contract Patrol ($10,553). Timing of expense. ADMINISTRATION - Attorney/Legal Fees ($9,356). Delayed billing from attorney for 2019 expenses. Two actions currently in process against homeowners. CLPOIA EMPLOYEES - Employee wages ($5,536). Terminated Maintenance person. Now using contract mowing. Savings offset by mowing expense in Public Areas.

CLPOIA May 2020 Financial Presentation Final Items If you have any suggestions for improved information, please let us know and we will see what we can do to address your request. If you have specific questions that have not been addressed regarding the information, let me know and we can meet at the office to go over any specific numbers. Would you like to see more presentations like this?

CLPOIA 2020 Budget Questions