Park Paseo Homeowners Association Audited Forensic Report For 2010 to 2011 Revenue 505.000.01 Homeowners Association Fees $481,020.00 $141,480.00 $622,500.00 505.000.01 Homeowners Association Fees $426,100.00 $181,400.00 $607,500.00 Operating fund too high difference is $54,920.00 Replacement fund too low difference is $-39,920.00 530.000.01 Late Fees & Interest $4,100.00 $0.00 $4,100.00 Deleted Asset(s) Revenue 540.000.05 Miscellaneous Income $6,476.00 $0.00 $6,476.00 Added Asset(s) Revenue 540.000.09 Other Charges to Owners $27,861.00 $0.00 $27,861.00 Deleted Asset(s) Revenue 540.000.10 Other Income $25,324.00 $0.00 $25,324.00 Added Asset(s) Revenue 550.000.03 Investment Income $0.00 $3,422.00 $3,422.00 550.000.03 Investment Income $0.00 $6,518.00 $6,518.00 Replacement fund too low difference is $-3,096.00 Cost too low difference is $-3,096.00 640.000.03 Reserve Studies $1,700.00 $0.00 $1,700.00 Added Asset(s) Expense 640.000.05 General Administrative $7,521.00 $0.00 $7,521.00 Added Asset(s) Expense Expense 640.000.07 Office supplies/printing/postage $8,989.00 $0.00 $8,989.00 640.000.07 Office supplies/printing/postage $2,709.00 $0.00 $2,709.00 Operating fund too high difference is $6,280.00 Cost too high difference is $6,280.00 700.000.01 Insurance $17,240.00 $0.00 $17,240.00 700.000.01 Insurance $18,253.00 $0.00 $18,253.00 Operating fund too low difference is $-1,013.00 Cost too low difference is $-1,013.00 720.000.05 Landscape Repair & Maintenance $164,289.00 $0.00 $164,289.00 Added Asset(s) Expense 720.000.08 Landscape Expense $168,874.00 $34,680.00 $203,554.00 Deleted Asset(s) Expense 760.000.01 Audit & Tax Services $2,810.00 $0.00 $2,810.00 Added Asset(s) Expense 760.000.02 Legal Services $28,653.00 $0.00 $28,653.00 Deleted Asset(s) Expense 760.000.04 Management Fees $34,330.00 $0.00 $34,330.00 Added Asset(s) Expense 760.000.06 Salaries & Related $64,634.00 $0.00 $64,634.00 Added Asset(s) Expense 760.000.07 Legal and collection $3,378.00 $0.00 $3,378.00 Added Asset(s) Expense 780.000.01 Property Protection - Patrol Service $51,484.00 $0.00 $51,484.00 Added Asset(s) Expense 840.001.05 General Repair & Maintenance $46,811.00 $0.00 $46,811.00 Added Asset(s) Expense 840.001.11 Common Areas $0.00 $4,170.00 $4,170.00 Added Asset(s) Expense 840.002.00 Janitorial $8,027.00 $0.00 $8,027.00 Added Asset(s) Expense 840.004.03 Pest Control $957.00 $0.00 $957.00 Added Asset(s) Expense 840.006.03 Pool Supplies/Repair & Maintenance $35,206.00 $1,232.00 $36,438.00 Added Asset(s) Expense 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $18,527.00 $18,527.00 Added Asset(s) Expense 860.000.01 Electric Service $26,853.00 $0.00 $26,853.00 Added Asset(s) Expense 860.000.02 Gas Service $11,635.00 $0.00 $11,635.00 Added Asset(s) Expense 860.000.04 Trash and Recycling Service $1,357.00 $0.00 $1,357.00 Added Asset(s) Expense 2010 - 2011 Analysis Summary Estimated inflation 3% Consumer Price Index 1.6% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2010 $489,861.00 $187,918.00 $677,779.00 Revenue 2011 $481,020.00 $144,902.00 $625,922.00 Expense 2010 $497,151.00 $34,680.00 $531,831.00 Expense 2011 $208,559.00 $23,929.00 $232,488.00 revenue - expense 2010 $-7,290.00 $153,238.00 $145,948.00 revenue - expense 2011 $272,461.00 $120,973.00 $393,434.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $279,751.00 $-32,265.00 $247,486.00 percent difference -3737.46% -21.06% 269.57% Total Assets 4 Total Issues 39 Issues/Asset 9.75 count % Description 19 475.00% Added Asset(s) 4 100.00% Deleted Asset(s) 2 50.00% Operating fund too high 1 25.00% Operating fund too low 2 50.00% Replacement fund too low 1 25.00% Cost too high 2 50.00% Cost too low Park Paseo Homeowners Association UnAudited Forensic Report For 2010 to 2011 Revenue 505.000.01 Homeowners Association Fees $481,020.00 $141,480.00 $622,500.00 505.000.01 Homeowners Association Fees $426,100.00 $181,400.00 $607,500.00 Operating fund too high difference is $54,920.00 Replacement fund too low difference is $-39,920.00 530.000.01 Late Fees & Interest $4,100.00 $0.00 $4,100.00 Deleted Asset(s) Revenue 540.000.05 Miscellaneous Income $6,476.00 $0.00 $6,476.00 Added Asset(s) Revenue 540.000.09 Other Charges to Owners $27,861.00 $0.00 $27,861.00 Deleted Asset(s) Revenue 540.000.10 Other Income $25,324.00 $0.00 $25,324.00 Added Asset(s) Revenue 550.000.03 Investment Income $0.00 $3,422.00 $3,422.00 550.000.03 Investment Income $0.00 $6,518.00 $6,518.00 Replacement fund too low difference is $-3,096.00 Cost too low difference is $-3,096.00 640.000.03 Reserve Studies $1,700.00 $0.00 $1,700.00 Added Asset(s) Expense 640.000.05 General Administrative $7,521.00 $0.00 $7,521.00 Added Asset(s) Expense Expense 640.000.07 Office supplies/printing/postage $8,989.00 $0.00 $8,989.00 640.000.07 Office supplies/printing/postage $2,709.00 $0.00 $2,709.00 Operating fund too high difference is $6,280.00 Cost too high difference is $6,280.00 700.000.01 Insurance $17,240.00 $0.00 $17,240.00 700.000.01 Insurance $18,253.00 $0.00 $18,253.00 Operating fund too low difference is $-1,013.00 Cost too low difference is $-1,013.00 720.000.05 Landscape Repair & Maintenance $164,289.00 $0.00 $164,289.00 Added Asset(s) Expense 720.000.08 Landscape Expense $168,874.00 $34,680.00 $203,554.00 Deleted Asset(s) Expense 760.000.01 Audit & Tax Services $2,810.00 $0.00 $2,810.00 Added Asset(s) Expense 760.000.02 Legal Services $28,653.00 $0.00 $28,653.00 Deleted Asset(s) Expense 760.000.04 Management Fees $34,330.00 $0.00 $34,330.00 Added Asset(s) Expense 760.000.06 Salaries & Related $64,634.00 $0.00 $64,634.00 Added Asset(s) Expense 760.000.07 Legal and collection $3,378.00 $0.00 $3,378.00 Added Asset(s) Expense 780.000.01 Property Protection - Patrol Service $51,484.00 $0.00 $51,484.00 Added Asset(s) Expense 840.001.05 General Repair & Maintenance $46,811.00 $0.00 $46,811.00 Added Asset(s) Expense 840.001.11 Common Areas $0.00 $4,170.00 $4,170.00 Added Asset(s) Expense 840.002.00 Janitorial $8,027.00 $0.00 $8,027.00 Added Asset(s) Expense 840.004.03 Pest Control $957.00 $0.00 $957.00 Added Asset(s) Expense 840.006.03 Pool Supplies/Repair & Maintenance $35,206.00 $1,232.00 $36,438.00 Added Asset(s) Expense 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $18,527.00 $18,527.00 Added Asset(s) Expense 860.000.01 Electric Service $26,853.00 $0.00 $26,853.00 Added Asset(s) Expense 860.000.02 Gas Service $11,635.00 $0.00 $11,635.00 Added Asset(s) Expense 860.000.04 Trash and Recycling Service $1,357.00 $0.00 $1,357.00 Added Asset(s) Expense 2010 - 2011 Analysis Summary Estimated inflation 3% Consumer Price Index 1.6% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2010 $489,861.00 $187,918.00 $677,779.00 Revenue 2011 $481,020.00 $144,902.00 $625,922.00 Expense 2010 $497,151.00 $34,680.00 $531,831.00 Expense 2011 $208,559.00 $23,929.00 $232,488.00 revenue - expense 2010 $-7,290.00 $153,238.00 $145,948.00 revenue - expense 2011 $272,461.00 $120,973.00 $393,434.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $279,751.00 $-32,265.00 $247,486.00 percent difference -3737.46% -21.06% 269.57% Total Assets 4 Total Issues 39 Issues/Asset 9.75 count % Description 19 475.00% Added Asset(s) 4 100.00% Deleted Asset(s) 2 50.00% Operating fund too high 1 25.00% Operating fund too low 2 50.00% Replacement fund too low 1 25.00% Cost too high 2 50.00% Cost too low Park Paseo Homeowners Association RDA Forensic Analysis For 2010 to 2011 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 010.000.01 Overlay/Rehab Overlay/Rehab 7 20 $10,749.00 $6,890.00 $0.00 010.000.01 Overlay/Rehab Overlay/Rehab 7 20 $11,287.65 $7,336.97 $0.00 Remaining life not changed No assigned value 010.000.03 Asphalt Repairs Asphalt Repairs 3 4 $2,299.00 $374.00 $0.00 010.000.03 Asphalt Repairs Asphalt Repairs 1 4 $1,933.16 $1,449.87 $1,449.87 Remaining life decreased too much Cost value too low should be $2,367.97 Fully funded value too low should be $1,775.98 Assigned value too low should be $1,775.98 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 3 4 $2,354.00 $336.00 $0.00 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 1 4 $1,945.81 $1,459.36 $1,459.36 Remaining life decreased too much Cost value too low should be $2,424.62 Fully funded value too low should be $1,818.46 Assigned value too low should be $1,818.46 020.000.01 Prosa Cabana Prosa Cabana 25 25 $10,001.00 $0.00 $0.00 020.000.01 Prosa Cabana Prosa Cabana 24 25 $10,298.25 $411.93 $0.00 No assigned value 020.000.03 Clubhouse, Tile Clubhouse, Tile 36 50 $24,159.00 $6,736.00 $0.00 020.000.03 Clubhouse, Tile Clubhouse, Tile 35 50 $24,452.30 $7,334.69 $0.00 No assigned value 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 13 18 $1,180.00 $312.00 $0.00 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 12 18 $1,167.99 $389.33 $0.00 No assigned value 030.001.01 Aluminum, Pools Aluminum, Pools 9 10 $9,476.80 $947.68 $0.00 New Assets 030.001.02 Interior Clubhou Interior Clubhouse 7 8 $3,866.00 $483.00 $0.00 030.001.02 Interior Clubhou Interior Clubhouse 6 8 $3,963.96 $990.99 $0.00 No assigned value 030.001.03 Interior Prosa R Interior Prosa Restrooms 0 8 $1,765.00 $1,765.00 $1,765.00 030.001.03 Interior Prosa R Interior Prosa Restrooms 0 8 $1,810.26 $1,810.26 $1,810.26 Maintenance deferred 030.001.05 Spa Equipment Ro Spa Equipment Room 0 5 $2,420.00 $2,420.00 $2,420.00 030.001.05 Spa Equipment Ro Spa Equipment Room 0 5 $2,486.00 $2,486.00 $2,486.00 Maintenance deferred 030.001.06 Stucco Stucco 0 10 $2,500.00 $2,500.00 $2,500.00 030.001.06 Stucco Stucco 0 10 $3,000.00 $3,000.00 $3,000.00 Maintenance deferred Cost value too high should be $2,575.00 Fully funded value too high should be $2,575.00 Assigned value too high should be $2,575.00 030.001.07 Woodwork Prosa Woodwork Prosa 0 5 $2,850.00 $2,850.00 $2,850.00 030.001.07 Woodwork Prosa Woodwork Prosa 0 5 $2,927.52 $2,927.52 $2,927.52 Maintenance deferred 030.002.02 Wrought Iron Po Wrought Iron Pools Unfunded 9 10 $0.00 $0.00 $0.00 Asset deleted 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $921.00 $921.00 $921.00 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $945.56 $945.56 $945.56 Maintenance deferred 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 0 5 $10,401.00 $10,401.00 $10,401.00 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 0 5 $10,681.80 $10,681.80 $10,681.80 Maintenance deferred 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 29 30 $97,731.60 $3,257.72 $0.00 New Assets 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 24 25 $46,350.00 $1,854.00 $0.00 New Assets 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 0 25 $5,000.00 $5,000.00 $5,000.00 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 0 25 $5,000.00 $5,000.00 $5,000.00 Maintenance deferred Cost not changed 040.000.08 Wrought Iron, Ma Wrought Iron, Main Pool 25 25 $115,000.00 $0.00 $0.00 Asset deleted 040.000.09 Wrought Iron, Pr Wrought Iron, Prosa Pool 25 25 $45,000.00 $0.00 $0.00 Asset deleted 040.000.10 Wrought Iron, St Wrought Iron, Streets 14 20 $3,268.00 $902.00 $0.00 040.000.10 Wrought Iron, St Wrought Iron, Streets 13 20 $3,150.49 $1,102.67 $0.00 Cost value too low should be $3,366.04 Fully funded value too low should be $1,178.11 No assigned value 040.000.11 Wrought Iron, St Wrought Iron, Street 0 20 $829.00 $829.00 $829.00 040.000.11 Wrought Iron, St Wrought Iron, Street 0 20 $854.00 $854.00 $854.00 Maintenance deferred 050.000.01 Exterior, Pool/C Exterior, Pool/Club 1 10 $12,246.00 $11,587.00 $11,587.00 050.000.01 Exterior, Pool/C Exterior, Pool/Club 2 10 $14,199.25 $11,359.40 $11,359.40 Remaining life increased Cost value too high should be $12,613.38 Fully funded value too high should be $10,090.70 Assigned value too high should be $10,090.70 050.000.03 Exterior, Parkin Exterior, Parking Lot 12 22 $1,262.00 $549.00 $0.00 050.000.03 Exterior, Parkin Exterior, Parking Lot 11 22 $1,253.16 $626.58 $0.00 No assigned value 050.000.05 Exterior, Prosa Exterior, Prosa 1 10 $2,370.00 $2,242.00 $2,242.00 050.000.05 Exterior, Prosa Exterior, Prosa 2 10 $2,746.88 $2,197.50 $2,197.50 Remaining life increased Cost value too high should be $2,441.10 Fully funded value too high should be $1,952.88 Assigned value too high should be $1,952.88 050.000.07 Parking Lot, Ori Parking Lot, Original 1 22 $6,310.00 $6,124.00 $6,124.00 050.000.07 Parking Lot, Ori Parking Lot, Original 3 22 $6,910.76 $5,968.38 $5,968.38 Remaining life increased Cost value too high should be $6,499.30 Fully funded value too high should be $5,613.03 Assigned value too high should be $5,613.03 050.000.08 Interior Prosa C Interior Prosa Cabana 2 25 $1,514.00 $1,413.00 $1,413.00 050.000.08 Interior Prosa C Interior Prosa Cabana 3 25 $1,600.35 $1,408.31 $1,408.31 Remaining life increased 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 3 15 $51,425.00 $44,439.00 $0.00 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 3 15 $92,441.34 $73,953.07 $73,953.07 Remaining life not changed Cost value too high should be $52,967.75 Fully funded value too high should be $42,374.20 Assigned value too high should be $42,374.20 050.001.01 Interior Clubhou Interior Clubhouse 5 25 $13,677.00 $11,877.00 $0.00 050.001.01 Interior Clubhou Interior Clubhouse 4 25 $14,991.11 $12,592.53 $0.00 Cost value too high should be $14,087.31 Fully funded value too high should be $11,833.34 No assigned value 060.001.02 Billiard Tables Billiard Tables 2 25 $8,750.00 $8,250.00 $8,250.00 060.001.02 Billiard Tables Billiard Tables 3 25 $9,410.57 $8,281.30 $8,281.30 Remaining life increased 060.001.08 Exterior Stairca Exterior Staircase 26 30 $16,222.00 $1,925.00 $0.00 060.001.08 Exterior Stairca Exterior Staircase 25 30 $15,292.08 $2,548.68 $0.00 Cost value too low should be $16,708.66 Fully funded value too low should be $2,784.78 No assigned value 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 20 25 $16,137.00 $3,053.00 $0.00 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 19 25 $15,909.75 $3,818.34 $0.00 No assigned value 060.001.10 Furnishings Furnishings 6 10 $30,000.00 $12,000.00 $0.00 060.001.10 Furnishings Furnishings 5 10 $30,000.00 $15,000.00 $0.00 Cost not changed 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 18 20 $3,084.00 $308.00 $0.00 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 17 20 $3,176.00 $476.40 $0.00 No assigned value 060.001.13 HVAC Heat/Air, C HVAC Heat/Air, Clubhouse 0 20 $24,883.00 $24,883.00 $24,883.00 060.001.13 HVAC Heat/Air, C HVAC Heat/Air, Clubhouse 2 20 $26,894.63 $24,205.17 $24,205.17 Maintenance deferred Remaining life increased 060.001.14 Window Blinds Window Blinds 5 10 $13,816.00 $6,670.00 $0.00 060.001.14 Window Blinds Window Blinds 4 10 $13,902.87 $8,341.72 $0.00 No assigned value 060.001.15 Water Heater Water Heater 1 12 $3,097.00 $2,859.00 $2,859.00 060.001.15 Water Heater Water Heater 3 12 $3,454.75 $2,591.06 $2,591.06 Remaining life increased Cost value too high should be $3,189.91 Fully funded value too high should be $2,392.43 Assigned value too high should be $2,392.43 060.001.16 Wallpaper Wallpaper 10 15 $12,019.00 $3,824.00 $0.00 060.001.16 Wallpaper Wallpaper 9 15 $11,938.08 $4,775.23 $0.00 No assigned value 060.001.18 Carpeting Carpeting 2 8 $10,662.00 $9,900.00 $9,900.00 060.001.18 Carpeting Carpeting 0 8 $10,981.53 $10,981.53 $10,981.53 Remaining life decreased too much 060.002.01 Doors, Double Sl Doors, Double Slide 2 25 $7,442.63 $6,847.22 $6,847.22 New Assets 060.002.02 Doors, Exterior, Doors, Exterior, Entry 20 25 $11,418.00 $2,160.00 $0.00 060.002.02 Doors, Exterior, Doors, Exterior, Entry 19 25 $11,256.75 $2,701.62 $0.00 No assigned value 060.002.03 Doors, Entry Doors, Entry 0 25 $9,032.00 $9,032.00 $9,032.00 060.002.03 Doors, Entry Doors, Entry 0 25 $13,950.00 $13,950.00 $13,950.00 Maintenance deferred Cost value too high should be $9,302.96 Fully funded value too high should be $9,302.96 Assigned value too high should be $9,302.96 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 5 25 $2,080.00 $1,806.00 $0.00 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 6 25 $2,393.42 $1,819.00 $0.00 Remaining life increased Cost value too high should be $2,142.40 Fully funded value too high should be $1,628.22 No assigned value 060.002.08 Doors, Entry Int Doors, Entry Interior 5 25 $1,639.00 $1,311.00 $0.00 060.002.08 Doors, Entry Int Doors, Entry Interior 6 25 $1,729.53 $1,314.44 $0.00 Remaining life increased No assigned value 060.003.01 Kitchen, Applian Kitchen, Appliances 7 12 $4,637.00 $1,855.00 $0.00 060.003.01 Kitchen, Applian Kitchen, Appliances 6 12 $4,639.54 $2,319.77 $0.00 No assigned value 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 20 25 $21,468.00 $4,062.00 $0.00 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 19 25 $21,165.75 $5,079.78 $0.00 No assigned value 060.003.08 Kitchen, Sink Kitchen, Sink 20 25 $683.00 $129.00 $0.00 060.003.08 Kitchen, Sink Kitchen, Sink 19 25 $672.92 $161.50 $0.00 No assigned value 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 5 8 $10,000.00 $3,617.00 $0.00 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 6 8 $15,593.24 $3,898.31 $0.00 Remaining life increased Cost value too high should be $10,300.00 Fully funded value too high should be $2,575.00 No assigned value 060.004.10 Office, Remodel Office, Remodel 17 20 $11,294.00 $1,613.00 $0.00 060.004.10 Office, Remodel Office, Remodel 16 20 $11,240.00 $2,248.00 $0.00 No assigned value 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 24 25 $17,134.00 $685.00 $0.00 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 23 25 $14,745.38 $1,179.63 $0.00 Cost value too low should be $17,648.02 Fully funded value too low should be $1,411.84 No assigned value 060.005.03 Restroom, Counte Restroom, Counters 19 20 $1,088.00 $54.00 $0.00 060.005.03 Restroom, Counte Restroom, Counters 18 20 $3,536.00 $353.60 $0.00 Cost value too high should be $1,120.64 Fully funded value too high should be $112.06 No assigned value 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 23 25 $2,077.50 $166.29 $0.00 New Assets 060.005.07 Restroom, Locker Restroom, Lockers/Benches 21 22 $20,000.00 $909.00 $0.00 060.005.07 Restroom, Locker Restroom, Lockers/Benches 20 22 $19,999.98 $1,818.18 $0.00 No assigned value 060.005.08 Restroom, Partit Restroom, Partitions 19 20 $4,660.00 $233.00 $0.00 060.005.08 Restroom, Partit Restroom, Partitions 18 20 $4,755.00 $475.50 $0.00 No assigned value 060.005.10 Restroom, Shower Restroom, Shower Door 9 10 $1,720.00 $172.00 $0.00 060.005.10 Restroom, Shower Restroom, Shower Door 14 16 $1,768.00 $221.00 $0.00 Remaining life increased Useful life increased No assigned value 060.005.13 Restroom, Fixtur Restroom, Fixtures 24 25 $6,397.00 $256.00 $0.00 060.005.13 Restroom, Fixtur Restroom, Fixtures 23 25 $6,397.00 $511.76 $0.00 Cost not changed 065.001.02 Filter, Main Filter, Main 1 12 $4,892.00 $4,566.00 $4,566.00 065.001.02 Filter, Main Filter, Main 2 12 $6,352.94 $5,294.12 $5,294.12 Remaining life increased Cost value too high should be $5,038.76 Fully funded value too high should be $4,198.97 Assigned value too high should be $4,198.97 065.001.03 Heater, Main Heater, Main 2 12 $23,082.00 $19,097.00 $19,097.00 065.001.03 Heater, Main Heater, Main 3 12 $21,815.95 $16,361.96 $16,361.96 Remaining life increased Cost value too low should be $23,774.46 Fully funded value too low should be $17,830.85 Assigned value too low should be $17,830.85 065.001.04 Motor/Pump Syste Motor/Pump System 0 8 $2,030.00 $2,030.00 $2,030.00 065.001.04 Motor/Pump Syste Motor/Pump System 2 8 $1,610.71 $1,208.33 $1,208.33 Maintenance deferred Remaining life increased Cost value too low should be $2,090.90 Fully funded value too low should be $1,568.18 Assigned value too low should be $1,568.18 065.001.05 Pump Pump 3 8 $4,425.00 $2,766.00 $0.00 065.001.05 Pump Pump 2 8 $5,500.00 $4,125.00 $4,125.00 Cost value too high should be $4,557.75 Fully funded value too high should be $3,418.31 Assigned value too high should be $3,418.31 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 1 14 $51,704.00 $47,989.00 $47,989.00 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 2 14 $54,063.70 $46,340.31 $46,340.31 Remaining life increased 065.002.01 Spa, Filter Spa, Filter 0 10 $870.00 $870.00 $870.00 065.002.01 Spa, Filter Spa, Filter 3 10 $1,417.30 $992.11 $992.11 Maintenance deferred Remaining life increased Cost value too high should be $896.10 Fully funded value too high should be $627.27 Assigned value too high should be $627.27 065.002.02 Spa, Heater Spa, Heater 0 10 $2,835.00 $2,835.00 $2,835.00 065.002.02 Spa, Heater Spa, Heater 3 10 $3,910.71 $2,737.50 $2,737.50 Maintenance deferred Remaining life increased Cost value too high should be $2,920.05 Fully funded value too high should be $2,044.04 Assigned value too high should be $2,044.04 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 1 8 $1,014.00 $913.00 $913.00 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 1 8 $1,064.94 $931.82 $931.82 Remaining life not changed 065.002.04 Spa, Pump/Motor, Spa, Pump/Motor, Booster 2 8 $2,672.67 $2,004.55 $2,004.55 New Assets 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 0 12 $6,586.00 $6,586.00 $6,586.00 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 2 12 $7,344.50 $6,120.42 $6,120.42 Maintenance deferred Remaining life increased Cost value too high should be $6,783.58 Fully funded value too high should be $5,652.98 Assigned value too high should be $5,652.98 065.002.06 Spa, Sump Pump Spa, Sump Pump 5 8 $2,537.00 $864.00 $0.00 065.002.06 Spa, Sump Pump Spa, Sump Pump 4 8 $2,469.42 $1,234.71 $0.00 Cost value too low should be $2,613.11 Fully funded value too low should be $1,306.56 No assigned value 065.003.01 Wader, Filter Wader, Filter 2 12 $681.00 $562.00 $562.00 065.003.01 Wader, Filter Wader, Filter 2 12 $1,157.72 $964.77 $964.77 Remaining life not changed Cost value too high should be $701.43 Fully funded value too high should be $584.53 Assigned value too high should be $584.53 065.003.02 Wader, Heater Wader, Heater 8 12 $2,840.00 $864.00 $0.00 065.003.02 Wader, Heater Wader, Heater 7 12 $2,629.56 $1,095.65 $0.00 Cost value too low should be $2,925.20 Fully funded value too low should be $1,218.83 No assigned value 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 0 8 $639.00 $639.00 $639.00 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 2 8 $844.16 $633.12 $633.12 Maintenance deferred Remaining life increased Cost value too high should be $658.17 Fully funded value too high should be $493.63 Assigned value too high should be $493.63 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 1 14 $5,869.00 $5,447.00 $5,447.00 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 1 14 $5,023.63 $4,664.80 $4,664.80 Remaining life not changed Cost value too low should be $6,045.07 Fully funded value too low should be $5,613.28 Assigned value too low should be $5,613.28 067.001.03 Barbecues Barbecues 0 14 $7,295.00 $7,295.00 $7,295.00 067.001.03 Barbecues Barbecues 0 14 $7,513.00 $7,513.00 $7,513.00 Maintenance deferred 067.001.05 Ceramic Shower Ceramic Shower 5 25 $1,897.00 $1,648.00 $0.00 067.001.05 Ceramic Shower Ceramic Shower 4 25 $2,070.81 $1,739.48 $0.00 Cost value too high should be $1,953.91 Fully funded value too high should be $1,641.28 No assigned value 067.002.02 Deck Caulking Deck Caulking 0 4 $9,013.00 $9,013.00 $9,013.00 067.002.02 Deck Caulking Deck Caulking 0 4 $9,292.50 $9,292.50 $9,292.50 Maintenance deferred 067.002.03 Deck Repairs Deck Repairs 0 30 $11,174.00 $11,174.00 $11,174.00 067.002.03 Deck Repairs Deck Repairs 0 30 $11,407.53 $11,407.53 $11,407.53 Maintenance deferred 067.003.02 Furniture, 2001 Furniture, 2001 1 7 $16,903.00 $15,213.00 $15,213.00 067.003.02 Furniture, 2001 Furniture, 2001 2 7 $20,258.00 $14,470.00 $14,470.00 Remaining life increased Cost value too high should be $17,410.09 Fully funded value too high should be $12,435.78 Assigned value too high should be $12,435.78 067.003.03 Furniture, 2007 Furniture, 2007 4 7 $13,774.00 $5,405.00 $0.00 067.003.03 Furniture, 2007 Furniture, 2007 3 7 $13,513.57 $7,722.04 $1,287.65 Assigned value too low should be $8,106.98 069.001.01 Filter, Prosa Filter, Prosa 10 12 $1,335.00 $182.00 $0.00 069.001.01 Filter, Prosa Filter, Prosa 9 12 $1,293.52 $323.38 $0.00 Cost value too low should be $1,375.05 Fully funded value too low should be $343.76 No assigned value 069.001.02 Filter, 2010 Filter, 2010 11 12 $1,449.96 $120.83 $0.00 New Assets 069.001.04 Heater, Prosa Heater, Prosa 0 12 $2,835.00 $2,835.00 $2,835.00 069.001.04 Heater, Prosa Heater, Prosa 2 12 $13,090.91 $10,909.09 $10,909.09 Maintenance deferred Remaining life increased Cost value too high should be $2,920.05 Fully funded value too high should be $2,433.38 Assigned value too high should be $2,433.38 069.001.05 Motor Motor 0 8 $713.00 $713.00 $713.00 Asset deleted 069.001.06 Pump Pump 0 8 $371.00 $371.00 $371.00 069.001.06 Pump Pump 2 8 $2,050.00 $1,537.50 $1,537.50 Maintenance deferred Remaining life increased Cost value too high should be $382.13 Fully funded value too high should be $286.60 Assigned value too high should be $286.60 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 2 14 $27,113.00 $23,217.00 $17,260.00 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 2 14 $30,307.26 $25,977.65 $25,977.65 Remaining life not changed Cost value too high should be $27,926.39 Fully funded value too high should be $23,936.91 Assigned value too high should be $23,936.91 070.001.01 Aluminum Trellis Aluminum Trellis 29 30 $10,587.90 $352.93 $0.00 New Assets 070.001.02 Barbecues Barbecues 1 10 $1,374.00 $1,319.00 $1,319.00 070.001.02 Barbecues Barbecues 2 10 $1,636.25 $1,309.26 $1,309.26 Remaining life increased Cost value too high should be $1,415.22 Fully funded value too high should be $1,132.18 Assigned value too high should be $1,132.18 070.001.05 Furniture Furniture 1 7 $7,913.00 $7,122.00 $7,122.00 070.001.05 Furniture Furniture 2 7 $9,478.00 $6,770.00 $6,770.00 Remaining life increased Cost value too high should be $8,150.39 Fully funded value too high should be $5,821.71 Assigned value too high should be $5,821.71 070.001.06 Plumbing Fixture Plumbing Fixtures 1 25 $4,911.00 $4,742.00 $4,742.00 070.001.06 Plumbing Fixture Plumbing Fixtures 4 25 $5,246.57 $4,407.12 $0.00 Remaining life increased No assigned value 070.001.07 Repairs Repairs 2 20 $2,793.00 $2,607.00 $0.00 070.001.07 Repairs Repairs 4 20 $3,130.69 $2,504.55 $0.00 Remaining life increased Cost value too high should be $2,876.79 Fully funded value too high should be $2,301.43 No assigned value 070.001.09 Wood, Repairs Wood, Repairs 0 5 $3,500.00 $3,500.00 $3,500.00 070.001.09 Wood, Repairs Wood, Repairs 0 5 $3,500.00 $3,500.00 $3,500.00 Maintenance deferred Cost not changed 070.002.01 Ceramic Shower Ceramic Shower 0 25 $6,274.00 $6,274.00 $6,274.00 070.002.01 Ceramic Shower Ceramic Shower 2 25 $6,537.47 $6,014.47 $6,014.47 Maintenance deferred Remaining life increased 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 2 25 $8,012.00 $7,478.00 $0.00 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 3 25 $8,456.09 $7,441.36 $0.00 Remaining life increased No assigned value 070.005.01 Restroom, Counte Restroom, Counters 1 20 $952.00 $919.00 $919.00 070.005.01 Restroom, Counte Restroom, Counters 4 20 $1,076.51 $861.21 $0.00 Remaining life increased Cost value too high should be $980.56 Fully funded value too high should be $784.45 No assigned value 080.000.01 Benches Benches 1 15 $6,003.00 $5,742.00 $5,742.00 080.000.01 Benches Benches 15 15 $0.00 $0.00 $0.00 Assets changed to unfunded 080.000.02 Chain Link Fenci Chain Link Fencing 4 25 $16,999.00 $15,161.00 $0.00 080.000.02 Chain Link Fenci Chain Link Fencing 6 25 $19,583.55 $14,883.50 $0.00 Remaining life increased Cost value too high should be $17,508.97 Fully funded value too high should be $13,306.82 No assigned value 080.000.05 Lighting Lighting 4 25 $12,048.00 $10,746.00 $0.00 080.000.05 Lighting Lighting 6 25 $13,689.47 $10,404.00 $0.00 Remaining life increased Cost value too high should be $12,409.44 Fully funded value too high should be $9,431.17 No assigned value 080.000.06 Resurfacing Resurfacing 1 6 $10,944.00 $9,381.00 $9,381.00 080.000.06 Resurfacing Resurfacing 1 6 $11,793.60 $9,828.00 $9,828.00 Remaining life not changed 080.000.07 Windscreen Windscreen 0 6 $2,926.00 $2,926.00 $2,926.00 080.000.07 Windscreen Windscreen 1 6 $3,400.08 $2,833.40 $2,833.40 Maintenance deferred Remaining life increased Cost value too high should be $3,013.78 Fully funded value too high should be $2,511.48 Assigned value too high should be $2,511.48 085.001.02 Trash Cans Trash Cans 15 15 $0.00 $0.00 $0.00 New Assets 085.002.01 Drinking Fountai Drinking Fountain, C/H 0 16 $2,664.00 $2,664.00 $2,664.00 085.002.01 Drinking Fountai Drinking Fountain, C/H 2 16 $2,931.54 $2,565.10 $2,565.10 Maintenance deferred Remaining life increased Cost value too high should be $2,743.92 Fully funded value too high should be $2,400.93 Assigned value too high should be $2,400.93 085.002.02 Drinking Fntns, Drinking Fntns, Concrete 1 30 $5,430.00 $5,270.00 $5,270.00 085.002.02 Drinking Fntns, Drinking Fntns, Concrete 3 30 $5,707.78 $5,136.76 $0.00 Remaining life increased No assigned value 085.003.01 Play Equipment, Play Equipment, Alba 7 18 $19,652.00 $12,010.00 $0.00 085.003.01 Play Equipment, Play Equipment, Alba 6 18 $20,241.00 $13,494.00 $0.00 No assigned value 085.003.03 Sand Repl, Prosa Sand Repl, Prosa/Alba 0 10 $3,219.00 $3,219.00 $3,219.00 085.003.03 Sand Repl, Prosa Sand Repl, Prosa/Alba 2 10 $7,718.75 $6,174.64 $6,174.64 Maintenance deferred Remaining life increased Cost value too high should be $3,315.57 Fully funded value too high should be $2,652.46 Assigned value too high should be $2,652.46 085.004.01 Play Equip, Main Play Equip, Main, Prosa 5 18 $44,692.00 $31,923.00 $0.00 085.004.01 Play Equip, Main Play Equip, Main, Prosa 4 18 $45,656.23 $35,510.40 $0.00 No assigned value 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $2,851.00 $2,851.00 $2,851.00 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $6,000.36 $6,000.36 $6,000.36 Maintenance deferred Cost value too high should be $2,936.53 Fully funded value too high should be $2,936.53 Assigned value too high should be $2,936.53 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 3 12 $4,201.00 $3,232.00 $0.00 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 3 12 $4,581.24 $3,435.93 $3,435.93 Remaining life not changed Cost value too high should be $4,327.03 Fully funded value too high should be $3,245.27 Assigned value too high should be $3,245.27 090.000.05 Trellis, Wood, R Trellis, Wood, Repairs 0 30 $35,000.00 $35,000.00 $35,000.00 090.000.05 Trellis, Wood, R Trellis, Wood, Repairs 0 12 $35,000.00 $35,000.00 $35,000.00 Maintenance deferred Cost not changed 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 0 4 $9,000.00 $9,000.00 $9,000.00 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 0 4 $9,000.00 $9,000.00 $9,000.00 Maintenance deferred Cost not changed 095.002.06 Tree Trimming, W Tree Trimming, Windrow 0 3 $30,000.00 $30,000.00 $30,000.00 095.002.06 Tree Trimming, W Tree Trimming, Windrow 2 3 $26,470.59 $8,823.53 $8,823.53 Maintenance completed 097.000.01 Backflow Devices Backflow Devices 1 24 $9,128.00 $8,860.00 $8,860.00 Asset deleted 097.000.02 Irrigation, Cont Irrigation, Controllers 1 12 $40,197.00 $37,964.00 $37,964.00 097.000.02 Irrigation, Cont Irrigation, Controllers 2 12 $47,520.00 $39,600.00 $39,600.00 Remaining life increased Cost value too high should be $41,402.91 Fully funded value too high should be $34,502.43 Assigned value too high should be $34,502.43 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 1 24 $17,143.00 $16,639.00 $16,639.00 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 24 $24,000.00 $24,000.00 $24,000.00 Cost value too high should be $17,657.29 Fully funded value too high should be $17,657.29 Assigned value too high should be $17,657.29 100.000.01 Bulletin Board Bulletin Board 2 12 $962.00 $850.00 $0.00 100.000.01 Bulletin Board Bulletin Board 3 12 $1,114.28 $835.71 $0.00 Remaining life increased Cost value too high should be $990.86 Fully funded value too high should be $743.14 No assigned value 100.000.02 Monument Monument 0 30 $3,000.00 $3,000.00 $3,000.00 100.000.02 Monument Monument 0 30 $3,000.00 $3,000.00 $3,000.00 Maintenance deferred Cost not changed 105.000.01 Termite Control/ Termite Control/Fumigation 1 15 $4,650.00 $4,340.00 $4,340.00 105.000.01 Termite Control/ Termite Control/Fumigation 0 15 $4,650.00 $4,650.00 $4,650.00 Cost not changed 110.000.01 Golf Cart, Repla Golf Cart, Replacement 2 12 $5,000.00 $4,500.00 $4,500.00 110.000.01 Golf Cart, Repla Golf Cart, Replacement 3 12 $5,757.57 $4,318.18 $4,318.18 Remaining life increased Cost value too high should be $5,150.00 Fully funded value too high should be $3,862.50 Assigned value too high should be $3,862.50 2010 - 2011 RDA Forensic Analysis Summary Estimated inflation 3% Consumer Price Index 1.6% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $1,136,350.00 $698,054.00 $467,251.00 This Year Costs $1,253,066.55 $762,163.57 $559,309.75 Calculated Costs $1,161,449.42 $747,727.68 $747,727.68 Comparing This Year Costs to Last Year Costs Difference $116,716.55 $64,109.57 $92,058.75 percent difference 10.27% 9.18% 19.70% exceeds CC&R limits Comparing This Year Costs to Calculated Costs Difference $91,617.13 $14,435.89 $-188,417.93 percent difference 7.31% 1.89% -33.69% 116 Total Assets 137 Total Issues $180,674.77 Unfunded Liability 1.18 Issues / Asset number % Description 9 7.76% New Assets 40 34.48% No assigned value 38 32.76% Cost value too high 11 9.48% Cost value too low 38 32.76% Fully funded value too high 11 9.48% Fully funded value too low 28 24.14% Assigned value too high 6 5.17% Assigned value too low 5 4.31% Asset deleted 8 6.90% Remaining life not changed 38 32.76% Remaining life increased 3 2.59% Remaining life decreased too much 1 0.86% Useful life increased 29 25.00% Maintenance deferred 1 0.86% Maintenance completed 30 25.86% Total assets to be maintained 8 6.90% Cost not changed 1 0.86% Assets changed to unfunded