CLPOIA 2020 Budget CLPOIA 2020 Budget Budget: An informed - - PowerPoint PPT Presentation

▶

Jan 16, 2024 236 likes •351 views

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

SLIDE 1

CLPOIA

2020 Budget

SLIDE 2

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.

SLIDE 3

CLPOIA 2020 Budget

In Other words:

A Guess?????

SLIDE 4

CLPOIA 2020 Budget

SLIDE 5

CLPOIA 2020 Budget

Budgets are Always Wrong.

SLIDE 6

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.

SLIDE 7

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

SLIDE 8

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)

21,312.00 4,011.00 19% Total Income 213,174.77 184,790.00 (28,384.77)

180,777.00 4,013.00 2% Expenditures: Community Center 1,666.74 1,715.00 48.26 3% 2,265.00 (550.00)

Sanitation 23,249.51 23,947.00 697.49 3% 26,159.00 (2,212.00)

Insurance 8,859.55 9,126.00 266.45 3% 9,175.00 (49.00)

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)

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)

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)

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%

SLIDE 9

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

SLIDE 10

CLPOIA 2020 Budget Questions