CLPOIA 2020 Budget
CLPOIA 2020 Budget Budget: An informed estimate of the financial impact of future events, both known and unknown, on the financial health of a business. Based on historical fact and assumptions as to the future, used as a guide for managing a business.
CLPOIA 2020 Budget In Other words: A Guess?????
CLPOIA 2020 Budget
CLPOIA 2020 Budget Budgets are Always Wrong.
CLPOIA 2020 Budget Budget Assumptions: • Income and expense timing will be consistent with prior years. • No increase is expected for Maintenance Fee Income. • Inflation impact on expenses is expected to be 3%. • $50,000 from savings is expected to be available for Capital expenditures.
CLPOIA 2020 Budget Cash Balance Trend 2019 Cash Resources: December 31, 2018 Jan 2019 Feb 2019 Mar 2019 Apr 2019 May-19 Jun-19 Jul-19 Aug-19 Checking $186,281.30 $94,473.26 $108,907.00 $106,791.06 $106,241.73 $104,852.12 $98,878.13 $92,661.11 $90,285.97 New Money Market $0.00 $100,000.00 $100,025.89 $100,052.75 $100,082.49 $100,109.36 $100,141.04 $100,169.85 $102,091.68 Petty Cash $98.70 $98.70 $98.70 $85.94 $85.94 $85.94 $2,108.30 $2,108.30 $85.94 Resale $4,956.60 $4,956.60 $5,241.05 $5,370.25 $5,207.15 $5,207.15 $5,477.65 $5,477.65 $5,477.65 Recreation $1,473.73 $1,430.79 $1,410.79 $1,375.50 $1,295.50 $1,295.50 $1,212.79 $1,337.12 $1,317.14 Fish & Wildlife $1,847.30 $1,847.30 $1,935.30 $1,936.48 $1,936.48 $1,936.48 $1,937.69 $1,937.69 $45.64 New CD 32511 ** $1,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 $25,000.00 Total $195,657.63 $227,806.65 $242,618.73 $240,611.98 $239,849.29 $238,486.55 $234,755.60 $228,691.72 $224,304.02 Budgeted Revenues Remaninder of Year $134,644.00 $124,664.00 $93,666.36 $82,135.00 $74,668.46 $65,730.35 $61,615.90 $74,453.70 Budgeted Expenditures Remainder of Year -$154,662.00 -$141,170.00 -$126,583.66 -$116,503.87 -$107,632.60 -$93,429.83 -$82,590.83 -$72,606.22 Estimated Cash Balance at December 2019 $207,788.65 $226,112.73 $207,694.68 $205,480.42 $205,522.41 $207,056.12 $207,716.79 $226,151.50 Estimated 6 months of Expenditures Emergency Funds -$84,077.00 -$84,077.00 -$84,077.00 -$84,077.00 -$84,077.00 -$84,077.00 -$84,077.00 -$84,077.00 Budgeted Maintenance Fee Income Nov/Dec 2019 -$72,095.00 -$72,095.00 -$72,095.00 -$72,095.00 -$72,095.00 -$72,095.00 -$72,095.00 -$72,095.00 Estimated Remainder For Large Expenditures $51,616.65 $69,940.73 $51,522.68 $49,308.42 $49,350.41 $50,884.12 $51,544.79 $69,979.50
CLPOIA 2020 Budget Trailing 12 Months 2020 $ Increase/ % Increase 2019 $ Increase/ % Increase Actual Proposed Budget (Decrease) (Decrease) Budget (Decrease) (Decrease) Income: Maintenance Fee Income 160,130.52 159,467.00 (663.52) 0% 159,465.00 2.00 0% Other Income 53,044.25 25,323.00 (27,721.25) -52% 21,312.00 4,011.00 19% Total Income 213,174.77 184,790.00 (28,384.77) -13% 180,777.00 4,013.00 2% Expenditures: Community Center 1,666.74 1,715.00 48.26 3% 2,265.00 (550.00) -24% Sanitation 23,249.51 23,947.00 697.49 3% 26,159.00 (2,212.00) -8% Insurance 8,859.55 9,126.00 266.45 3% 9,175.00 (49.00) -1% Public Area/Recreation 14,840.22 15,122.00 281.78 2% 14,062.00 1,060.00 8% Road Maintenance 2,005.86 2,066.00 60.14 3% 5,035.00 (2,969.00) -59% Security/Gate 25,527.84 41,619.00 16,091.16 63% 37,392.00 4,227.00 11% Administration 27,278.95 34,755.00 7,476.05 27% 32,825.67 1,929.33 6% A/R Business Fees 634.87 654.00 19.13 3% 329.00 325.00 99% Miscellaneous - - - 48.00 (48.00) -100% CLPOIA Employees 32,466.33 40,472.00 8,005.67 25% 33,402.00 7,070.00 21% Taxes 134.47 138.00 3.53 3% 248.00 (110.00) -44% Dam Maintenance 1,154.20 2,550.00 1,395.80 121% 1,941.33 608.67 31% Contingent Liability - - - - - Payroll Expenses 182.00 187.00 5.00 3% 489.00 (302.00) -62% Publicity - - - 264.00 (264.00) -100% Fish and Wildlife 929.86 13,900.00 12,970.14 - 13,900.00 CD, Savings and Extracurricular 4,560.32 5,654.00 1,093.68 24% 4,519.00 1,135.00 25% Total Expense/Expenditures 143,490.72 191,905.00 48,414.28 34% 168,154.00 23,751.00 14% Net Ordinary Income 69,684.05 (7,115.00) (76,799.05) -110% 12,623.00 (19,738.00) -156% Other Income/Expense 61.54 - (61.54) -100% - - Net Income 69,745.59 (7,115.00) (76,860.59) -110% 12,623.00 (19,738.00) -156% Capital Improvements 49,988.00 50,000.00 12.00 0% - 50,000.00 Cash Flow 19,757.59 (57,115.00) (76,872.59) -389% 12,623.00 (69,738.00) -552%
CLPOIA 2020 Budget Cash Position Cash Projected at 12/31/2019: Checking 92,211.72 New Money Market 100,141.04 Petty Cash 2,108.30 Resale 5,477.65 Recreation 1,212.79 New CD 32511 ** 25,000.00 226,151.50 Add Cash Flow (57,115.00) Cash at 12/31/2020: 169,036.50 Cash at 12/31/2020: Checking 62,236.50 New Money Market 50,000.00 Petty Cash 100.00 Resale 5,500.00 Recreation 1,200.00 New CD 50,000.00 Total Cash 169,036.50 Estimated 6 months of Expenditures Emergency Funds 89,002.50 Budgeted Maintenance Fee Income Nov/Dec 2020 72,095.00 Cash balance Required at 12/31/2020 161,097.50
CLPOIA 2020 Budget Questions
Recommend
More recommend
