Dynasys Technical Services

Capital Reserves Analysis Worksheet

Association: Pebble Brook SEPT 30, 2012 YEAR: 2012 For 2013

Insurance Deductible = $2500. 2% Wind and Hail Deductible. Renew Date: DEC 31st

Property Value = 4.4Mil

Current Dues: $235 ($ per unit per month) Total Units 48

Emergency Reserves Level $20,000

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

Cash/Checking $3878.35 $44392.23

Liquid Savings $0 $0

Non-Liquid Savings $32700.19 $32872.52

Accounts Receivable $5512.90 $5678.35

Other $0 $0

Likely Bad Debt $0 $0

TOTAL $42091.44 $82943.10

INCOME Prior Year As of CRA Date Est Remaining

HOA Dues $132480.00 $101520.00 $33840.00

Interest $323.77 $172.33 $60.00

Fees & Fines $2728.64 $1596.21 $350.00

Annual (Storage) $420.00 $315.00 $105.00

Annual (Laundry) $4317.00 $4099.14 $1500.00

Non-Annual $0 $ 13544.22 (CSU Refund) $0

TOTAL $140269.41 $121246.90 $35855.00

EXPENSES Prior Year As of CRA Date Est Remaining

Annual $125614.33 $79712.66 $35260.39

Non-Annual $15783.00 (Concrete) $702.00 $6600.00*

Bad Debt Write Off $22840.13 $0 $0

TOTAL $164237.46 $80414.66 $41860.39

*Bldg 6605: Foundation Resealing ~ $2500; Bldg 6617 Sewage Backup Remediation. ~ $3300; Exterior Lighting O/haul ~ $800

Out Year Maintenance Schedule

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

1)Roofing 88,521.00 Sept 10 30 2040 2010

2)Painting 10,650.00 Sept 10 7 2017 2010

3) Concrete Stoops 8400.00 2009 50 2059 2009 (for budgeting)

4)Landscape Rockwork 18,000(total) Sept 08 2010 (Wish List) Unknown

Total of 6 Buildings. One building per year; none complete – On HOLD until Board decide what it wants.

5)Front Doors 28,000.00(total) Sept 08 50 2010 Unknown

(Would like to do one door per year for a total of 12 doors. ON HOLD – painted in 2010)

6)Boilers 9,784.00 Sept 08 30 ?

* Board decided to replace the boilers as needed

7) Insulation 10,000 Sept 2008 2012-13 (if Possible)

The insulation project was put on hold due to Concrete Stoops and sidewalk replacement in 2011

Anticipated Changes to Annual Expenses

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

1)Management 9350.00 9,724.00 4% Increase

2) Janitorial 9956.54 10354.80 4% Increase

2)CPA Tax Preparation 381.00 381.00 No Increase

-CPA Review 1600.00 1600.00

CPA Review to be done every other year, was supposed to start in 2009 – did/has not. Will probably not be done in 2013 – Board Decision.

3)Landscape Contract 6220.00 6468.80 (4%)

4)Fertilization/Weed Control 554.00 581.70 (5%)

5)Water 22601.60 24635.74 (9%)

6)Sewer 8244.60 8244.60 (0%)

7)Electricity 5473.78 5638.00 (3%)

8)Gas 19774.00 19971.74 (1%)

9)Boiler Inspection 00.00 (2012) 250.00 (2013)

Boiler Inspection to be done every other year starting in 2009

10)Insurance 7329.00 10993.50 (50%)

11)Brookwood Dues 13536.00 ? (Pending Brookwood CRA)