HomeMy Public PortalAboutCPC FY 2020 Budget Community Preservation Committee: FY20 Forecast as of 6/25/2020
2,584,645.00$
1,032,863.00$
292,896$
3,910,404.00
50%10%10%
Open Space Housing Historical
$ 1,546,067.65 $ 170,340.31 $ 187,924.79 $ 680,312.25
$ 662,879.50 $ 132,575.90 $ 132,575.90 $ 397,727.70
$ 2,208,947.15 $ 302,916.21 $ 320,500.69 $ 1,078,039.95
Open Space Housing Historical "30%"
$ (63,600.00)
$ (62,280.00)
$ (108,640.00)
$ (51,433.00)
$ (27,490.00)
$ (424,210.00)
-$ (57,500.00)$
$ (37,000.00)
$ (7,500.00)
17,416.42 6,295.00 12,098.00 (35,809.42)
reserve fund to appropriate accounts
Copelas Property Acquisition $ (680,000.00)
$ (75,000.00)
$ (5,000.00)
$ (147,500.00) $ (352,500.00)
$ (2,500.00)
$ (15,000.00) $ (15,000.00)
$ (2,500.00)
$ (400,000.00)
Total YTD Obligations - FY20 $ (1,817,736.58) $ (268,205.00) $ 12,098.00 $ (460,809.42)
$ 391,210.57 $ 34,711.21 $ 332,598.69 $ 617,230.53
Total net available from all accounts 1,375,751.00$
[2] State Match
Revenue is actual as
spring 2020. Spring town meeting approved a 451,700 paymentof existing debt and interest on this bond.
FY 19 Actual Unreserved Fund Balance
FY-19 Estimated total balance forwarded [1]:
FY-20 Estimated local tax revenue:
FY-20 Estimated State contribution [2]:
Total FY-20 Estimated funds available:
Budgedted Reserved
for CPA
Administration Expense [3]
FY-20 Estimated revenue
FY-20 Estimated Funds available
FY-20 obligations as of 06/25/20
Jolly Whaler Bond
BBJ Property Bond #1
BBJ Property Bond #2
Bates Property Bond
Besse Cartway (Long Pond) Short Term Borrowing Interest
(4)
Besse Cartway (Long Pond) Principal Paydown [4]****
Open Space and Recreation Plan Update Admin/Legal costs
Part Time Housing Coordinator
Community Development Partnership - Housing Institute
Budget transfer of FY18 unexpended prof services/admin from 30%
FORWARD Support for Disabilities Housing
FORWARD Support for Disabilities Housing Admin/Legal Costs
Affordable Housing Trust Housing Rehab Request
Affordable Housing Trust Housing Rehab Legal Funds
Open Space and Recreation Plan Update
[3] Administrative expenses are limited by law to 5% of the total CPC budget and include primarily payroll costs, legal and other professional expenses, the annual $3,500 state
Coalition dues.
{4} Town will borrow $1,595,000 short term for the purchase. State LAND grant of $400,000 to be available at some point and remaining $75,000 BCT payment anticipated to be available
Additional principal paydown - Long Pond Note (5)
FY20 Estimated Unreserved Fund Balance as of 6/25/20 with
Adjustments
[1] Balance forwarded estimated from prior year includes all unallocated funds, including unspent amounts from projects and budgeted administrative and professional
Projected Y/E Adjustments BONDS
Community Preservation Committee: FY21 Forecast as of 6/25/2020
1,375,751.00$
1,058,000.00$
118,496.00$
2,552,247.00
50%10%10%
Open Space Housing Historical
$ 391,210.57 $ 34,711.21 $ 332,598.69 $ 617,230.53
$ 588,248.00 $ 117,649.60 $ 117,649.60 $ 352,948.80
$ 979,458.57 $ 152,360.81 $ 450,248.29 $ 970,179.33
Open Space Housing Historical "30%"
$ (61,200.00)
$ (55,080.00)
$ (105,120.00)
$ (50,295.00)
$ (5,203.18)
(58,824.80)$
Potential Items for
Spring TM
$ (49,500.00)
$ (15,000.00)
(425,000.00)$
(25,000.00)$
$ (325,500.00)
$ (400,000.00)
$ 70,000.00
$ 400,000.00
Total YTD Obligations - FY21 $ (532,398.18) $ (64,500.00) $ - $ (508,824.80)
$ 447,060.39 $ 87,860.81 $ 450,248.29 $ 461,354.53
Total net available from all accounts 1,446,524.02$
{4} Original bond amount of 1,594,900 to be paid down by 899,210 in April. Rem. Balance projected to be 695,690. 3% interest rate
Brewster Whitecaps Field Improvements
Pleasant Bay Dock Improvements
Field/Kelley Land Purchase
Coalition dues.
[3] Administrative expenses are limited by law to 5% of the total CPC budget and include primarily payroll costs, legal and other professional expenses, the annual $3,500 state
[2] State Match Revenue is projected at 11.2% of Town contribution per forecast received by the DOR on 5/4/2020
[1] Balance forwarded estimated from prior year includes all unallocated funds, including unspent amounts from projects and budgeted administrative and professional
FY21 Estimated Unreserved Fund Balance as of 6/25/2020 with
Adjustments
Water Dept Contribution for Copelas to be cred. 7/1/20
State Contribution for Long Pond O/S to be Cred. 7/1/20
Additional Principal Paydown - Besse Cartway S/T Borrowing
Part Time Housing Coordinator
Community Development Partnership - Housing Institute
BBJ Property Bond #2
Bates Property Bond
Besse Cartway (Long Pond) Short Term Borrowing Interest
(4)
Administration Expense [3]
BBJ Property Bond #1
Budgedted Reserved for
CPA
FY-20 Actual Unreserved Fund Balance
FY-21 Estimated revenue
FY-21 Estimated Funds available
FY-21 obligations as of 07/01/2020
Jolly Whaler Bond
FY-20 Estimated total balance forwarded [1]:
FY-21 Estimated local tax revenue:
FY-21 Estimated State contribution [2]:
Total FY-21 Estimated funds available:BONDS