Embed
Email

2011 CRA Worksheet - CR

Document Sample

Shared by: xiaoyounan
Categories
Tags
Stats
views:
1
posted:
12/26/2011
language:
pages:
2
Dynasys Technical Services

Capital Reserves Analysis Worksheet

Association:..........Country Ridge Estates YEAR: 2011 For 2012. DATE: SEPT 30, 2011



Insurance Deductible = $2500. 2% Wind and Hail Deductible. Renew Date: August 1st

Value = 3.4Mil

Current Dues: .......$197.00 ________($ per unit per month) Total Units .....36__________

CRA Date: ............September 30, 2011 Emergency Reserves Level ....$20,000 _____





CASH SITUATION As of End of Prior Year APR As of CRA Date APR

Cash/Checking ..................... $7,169.15 _____ $15,142.45__________ _____

Liquid Savings ..................... $21,999.40 _____ $22,201.48__________ _____

Non-Liquid Savings ............. $ 0 ______ _____ $0_________________ _____

Accts Receivable .................. $ 401.34 _ _____ $212.93 ____________ _____

Other ................................... $0 ______ _____ $0_________________ _____

Likely Bad Debt ................... $0 ______ _____ $0_________________ _____





TOTAL...........................................$29,569.89 _____ $37,457.86__________ _____



INCOME Prior Year As of CRA Date Est Remaining

Annual ........................$79,920.00____________ $63,828.00 ___________ $21,276.00____________

Interest........................$213.73 ______________ $103.08______________ $30.00 _______________

Fees & Fines ..............$810.00 ______________ $90.00_______________ $30.00 _______________

Other Annual ..............$201.76 ______________ $21.56_______________ $6.00 ________________

Non-Annual................$0___________________ $0 __________________ $0___________________





TOTAL ......................$81,145.49____________ $64,042.64 ___________ $21,342.00____________





EXPENSES Prior Year As of CRA Date Est Remaining

Annual ........................$55,706.75____________ $37,599.26 ___________ $14,110.48____________

Non-Annual................$29,165.00____________ $18,845.22 ___________ $19,600.00*___________

Bad Debt Write Off ....$4,629.77_____________ $0 __________________ $0

TOTAL ......................$89,501.52____________ $56,444.48 ___________ $33,710.48____________





*$3,000 is included for stairs and deck stain. This may or may not happen depending on finances and weather.

Dynasys Technical Services

Capital Reserves Analysis Worksheet





Out Year Maintenance Schedule

Description Bid Amount Bid Date Freq (yrs) Next Scheduled Last Performed

1)Roofing ____ $103,000____ Sept 11 __ _40_______ 2041 __________ 2001___________

2)Painting ____ $7,921 _____ Sept 10 __ _5________ 2012 __________ 2007 ______

As Blds are being stucco’d, the only required painting will be the sofit, facia, stairs and landings. Above

price is for all 6 buildings.

3)Asphalt Sealcoat $6,036.97 ___ Sept 11 __ _5________ 2016 __________ 2011___________

4)Asphalt 2” O/lay $58,221 ____ Sept 11 __ _50_______ 2021 __________ Unknown _______

5)Asphalt R/R _ $140,000____ Sept 09 __ _50_______ 2046? _________ Unknown _______

6)*Stucco 1 bldg $20,000_____ Sept 11 __ __________ 2012? _________ _______________

* Again the Board is still trying to stucco one building per year (or as funds permit). One building was completed in

2011. We now have four bldgs stucco’d in total - 2 to go.









Anticipated Changes to Annual Expenses

Description (Estimated) Present Year Total Amount Next Year Expected Amount

1)Management _________ 9074.00 __________________ 9074 No Increase __________

2) CPA Tax Prep ________ 380.88 ___________________ 380.88

3)CPA Review* ________ 1500.00 __________________ 1600.00 __________________

4)Landscape Contract ____ 5640.00 __________________ 5809.20 (3%)______________

5)Fertilization/Weed Control 433.00 ___________________ 446.55 (3%)_______________

6)Water _______________ 10410.00 _________________ 12.905.00 ** ______________

7)Electricity____________ 1082.00 __________________ 1157.00 (7%)______________

8)Insurance ____________ 9943.00 __________________ 10937.00 (10% min) ________

9)Trash Removal ________ 3440.00*** _______________ 3956.00 (15%)_____________





*CPA Review to be done every other year starting in 2009. But will probably not be done in 2012.

**Woodmore Water has introduced a monthly “Renewable Water Fee” plus a 3% increase in water.

***trash company quoted a 5% increase for 2011. Turned out to be 15%. Went out for bids – they were

still cheaper.



Related docs
Other docs by xiaoyounan
uses chart
Views: 2  |  Downloads: 0
least_squares_fit_manual
Views: 0  |  Downloads: 0
ENTERING_THE_ROADWAY_AND_BACKING_NOTES
Views: 0  |  Downloads: 0
FFaith presentation
Views: 0  |  Downloads: 0
Ward_Nutritioin
Views: 1  |  Downloads: 0
0604477_Goldburg
Views: 0  |  Downloads: 0
salary-delegation-authority-summary-temporary
Views: 0  |  Downloads: 0
August 2011 _excel format_
Views: 19  |  Downloads: 0
1350 Tally FINANCE
Views: 1  |  Downloads: 0
Ch. 6.3.Martinez
Views: 0  |  Downloads: 0
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!