Park Paseo Homeowners Association Audited Forensic Report For 2011 to 2012 Revenue 505.000.01 Homeowners Association Fees $484,800.00 $152,700.00 $637,500.00 505.000.01 Homeowners Association Fees $481,020.00 $141,480.00 $622,500.00 Replacement fund too high difference is $11,220.00 520.000.01 Clubhouse Rental Fee $8,875.00 $0.00 $8,875.00 Added Asset(s) Revenue 540.000.05 Miscellaneous Income $6,476.00 $0.00 $6,476.00 Deleted Asset(s) Revenue 540.000.10 Other Income $7,183.00 $0.00 $7,183.00 540.000.10 Other Income $25,324.00 $0.00 $25,324.00 Operating fund too low difference is $-18,141.00 Cost too low difference is $-18,141.00 550.000.03 Investment Income $0.00 $2,470.00 $2,470.00 550.000.03 Investment Income $0.00 $3,422.00 $3,422.00 Replacement fund too low difference is $-952.00 Cost too low difference is $-952.00 Expense 640.000.03 Reserve Studies $1,600.00 $0.00 $1,600.00 640.000.03 Reserve Studies $1,700.00 $0.00 $1,700.00 Operating fund too low difference is $-100.00 Cost too low difference is $-100.00 640.000.05 General Administrative $22,717.00 $0.00 $22,717.00 640.000.05 General Administrative $7,521.00 $0.00 $7,521.00 Operating fund too high difference is $15,196.00 Cost too high difference is $15,196.00 640.000.07 Office supplies/printing/postage $15,725.00 $0.00 $15,725.00 640.000.07 Office supplies/printing/postage $8,989.00 $0.00 $8,989.00 Operating fund too high difference is $6,736.00 Cost too high difference is $6,736.00 700.000.01 Insurance $15,633.00 $0.00 $15,633.00 700.000.01 Insurance $17,240.00 $0.00 $17,240.00 Operating fund too low difference is $-1,607.00 Cost too low difference is $-1,607.00 720.000.05 Landscape Repair & Maintenance $164,289.00 $0.00 $164,289.00 Deleted Asset(s) Expense 720.000.08 Landscape Expense $137,827.00 $0.00 $137,827.00 Added Asset(s) Expense 760.000.01 Audit & Tax Services $1,750.00 $0.00 $1,750.00 760.000.01 Audit & Tax Services $2,810.00 $0.00 $2,810.00 Operating fund too low difference is $-1,060.00 Cost too low difference is $-1,060.00 760.000.04 Management Fees $60,000.00 $0.00 $60,000.00 760.000.04 Management Fees $34,330.00 $0.00 $34,330.00 Operating fund too high difference is $25,670.00 Cost too high difference is $25,670.00 760.000.06 Salaries & Related $64,634.00 $0.00 $64,634.00 Deleted Asset(s) Expense 760.000.07 Legal and collection $3,269.00 $0.00 $3,269.00 760.000.07 Legal and collection $3,378.00 $0.00 $3,378.00 Operating fund too low difference is $-109.00 Cost too low difference is $-109.00 780.000.01 Property Protection - Patrol Service $36,608.00 $0.00 $36,608.00 780.000.01 Property Protection - Patrol Service $51,484.00 $0.00 $51,484.00 Operating fund too low difference is $-14,876.00 Cost too low difference is $-14,876.00 840.001.05 General Repair & Maintenance $16,949.00 $9,120.00 $26,069.00 840.001.05 General Repair & Maintenance $46,811.00 $0.00 $46,811.00 Operating fund too low difference is $-29,862.00 Replacement fund too high difference is $9,120.00 Cost too low difference is $-20,742.00 840.001.11 Common Areas $0.00 $4,170.00 $4,170.00 Deleted Asset(s) Expense 840.001.13 Streets & Drives $0.00 $2,335.00 $2,335.00 Added Asset(s) Expense 840.002.00 Janitorial $8,027.00 $0.00 $8,027.00 Deleted Asset(s) Expense 840.002.04 Janitorial Combined Costs $12,168.00 $0.00 $12,168.00 Added Asset(s) Expense 840.004.03 Pest Control $1,209.00 $0.00 $1,209.00 840.004.03 Pest Control $957.00 $0.00 $957.00 Operating fund too high difference is $252.00 Cost too high difference is $252.00 840.006.03 Pool Supplies/Repair & Maintenance $33,838.00 $5,400.00 $39,238.00 840.006.03 Pool Supplies/Repair & Maintenance $35,206.00 $1,232.00 $36,438.00 Operating fund too low difference is $-1,368.00 Replacement fund too high difference is $4,168.00 Cost too high difference is $2,800.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $18,527.00 $18,527.00 Deleted Asset(s) Expense 860.000.02 Gas Service $9,075.00 $0.00 $9,075.00 860.000.02 Gas Service $11,635.00 $0.00 $11,635.00 Operating fund too low difference is $-2,560.00 Cost too low difference is $-2,560.00 2011 - 2012 Analysis Summary Estimated inflation 2% Consumer Price Index 3.2% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2011 $521,695.00 $144,902.00 $666,597.00 Revenue 2012 $491,983.00 $155,170.00 $647,153.00 Expense 2011 $635,859.00 $26,264.00 $662,123.00 Expense 2012 $245,176.00 $14,520.00 $259,696.00 revenue - expense 2011 $-114,164.00 $118,638.00 $4,474.00 revenue - expense 2012 $246,807.00 $140,650.00 $387,457.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $360,971.00 $22,012.00 $382,983.00 percent difference -216.19% 118.55% 8660.19% Total Assets 16 Total Issues 72 Issues/Asset 4.50 count % Description 4 25.00% Added Asset(s) 6 37.50% Deleted Asset(s) 4 25.00% Operating fund too high 9 56.25% Operating fund too low 3 18.75% Replacement fund too high 1 6.25% Replacement fund too low 5 31.25% Cost too high 9 56.25% Cost too low Park Paseo Homeowners Association UnAudited Forensic Report For 2011 to 2012 Revenue 505.000.01 Homeowners Association Fees $484,800.00 $152,700.00 $637,500.00 505.000.01 Homeowners Association Fees $481,020.00 $141,480.00 $622,500.00 Replacement fund too high difference is $11,220.00 520.000.01 Clubhouse Rental Fee $8,875.00 $0.00 $8,875.00 Added Asset(s) Revenue 540.000.05 Miscellaneous Income $6,476.00 $0.00 $6,476.00 Deleted Asset(s) Revenue 540.000.10 Other Income $7,183.00 $0.00 $7,183.00 540.000.10 Other Income $25,324.00 $0.00 $25,324.00 Operating fund too low difference is $-18,141.00 Cost too low difference is $-18,141.00 550.000.03 Investment Income $0.00 $2,470.00 $2,470.00 550.000.03 Investment Income $0.00 $3,422.00 $3,422.00 Replacement fund too low difference is $-952.00 Cost too low difference is $-952.00 Expense 640.000.03 Reserve Studies $1,600.00 $0.00 $1,600.00 640.000.03 Reserve Studies $1,700.00 $0.00 $1,700.00 Operating fund too low difference is $-100.00 Cost too low difference is $-100.00 640.000.05 General Administrative $22,717.00 $0.00 $22,717.00 640.000.05 General Administrative $7,521.00 $0.00 $7,521.00 Operating fund too high difference is $15,196.00 Cost too high difference is $15,196.00 640.000.07 Office supplies/printing/postage $15,725.00 $0.00 $15,725.00 640.000.07 Office supplies/printing/postage $8,989.00 $0.00 $8,989.00 Operating fund too high difference is $6,736.00 Cost too high difference is $6,736.00 700.000.01 Insurance $15,633.00 $0.00 $15,633.00 700.000.01 Insurance $17,240.00 $0.00 $17,240.00 Operating fund too low difference is $-1,607.00 Cost too low difference is $-1,607.00 720.000.05 Landscape Repair & Maintenance $164,289.00 $0.00 $164,289.00 Deleted Asset(s) Expense 720.000.08 Landscape Expense $137,827.00 $0.00 $137,827.00 Added Asset(s) Expense 760.000.01 Audit & Tax Services $1,750.00 $0.00 $1,750.00 760.000.01 Audit & Tax Services $2,810.00 $0.00 $2,810.00 Operating fund too low difference is $-1,060.00 Cost too low difference is $-1,060.00 760.000.04 Management Fees $60,000.00 $0.00 $60,000.00 760.000.04 Management Fees $34,330.00 $0.00 $34,330.00 Operating fund too high difference is $25,670.00 Cost too high difference is $25,670.00 760.000.06 Salaries & Related $64,634.00 $0.00 $64,634.00 Deleted Asset(s) Expense 760.000.07 Legal and collection $3,269.00 $0.00 $3,269.00 760.000.07 Legal and collection $3,378.00 $0.00 $3,378.00 Operating fund too low difference is $-109.00 Cost too low difference is $-109.00 780.000.01 Property Protection - Patrol Service $36,608.00 $0.00 $36,608.00 780.000.01 Property Protection - Patrol Service $51,484.00 $0.00 $51,484.00 Operating fund too low difference is $-14,876.00 Cost too low difference is $-14,876.00 840.001.05 General Repair & Maintenance $16,949.00 $9,120.00 $26,069.00 840.001.05 General Repair & Maintenance $46,811.00 $0.00 $46,811.00 Operating fund too low difference is $-29,862.00 Replacement fund too high difference is $9,120.00 Cost too low difference is $-20,742.00 840.001.11 Common Areas $0.00 $4,170.00 $4,170.00 Deleted Asset(s) Expense 840.001.13 Streets & Drives $0.00 $2,335.00 $2,335.00 Added Asset(s) Expense 840.002.00 Janitorial $8,027.00 $0.00 $8,027.00 Deleted Asset(s) Expense 840.002.04 Janitorial Combined Costs $12,168.00 $0.00 $12,168.00 Added Asset(s) Expense 840.004.03 Pest Control $1,209.00 $0.00 $1,209.00 840.004.03 Pest Control $957.00 $0.00 $957.00 Operating fund too high difference is $252.00 Cost too high difference is $252.00 840.006.03 Pool Supplies/Repair & Maintenance $33,838.00 $5,400.00 $39,238.00 840.006.03 Pool Supplies/Repair & Maintenance $35,206.00 $1,232.00 $36,438.00 Operating fund too low difference is $-1,368.00 Replacement fund too high difference is $4,168.00 Cost too high difference is $2,800.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $18,527.00 $18,527.00 Deleted Asset(s) Expense 860.000.02 Gas Service $9,075.00 $0.00 $9,075.00 860.000.02 Gas Service $11,635.00 $0.00 $11,635.00 Operating fund too low difference is $-2,560.00 Cost too low difference is $-2,560.00 2011 - 2012 Analysis Summary Estimated inflation 2% Consumer Price Index 3.2% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2011 $521,695.00 $144,902.00 $666,597.00 Revenue 2012 $491,983.00 $155,170.00 $647,153.00 Expense 2011 $635,859.00 $26,264.00 $662,123.00 Expense 2012 $245,176.00 $14,520.00 $259,696.00 revenue - expense 2011 $-114,164.00 $118,638.00 $4,474.00 revenue - expense 2012 $246,807.00 $140,650.00 $387,457.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $360,971.00 $22,012.00 $382,983.00 percent difference -216.19% 118.55% 8660.19% Total Assets 16 Total Issues 72 Issues/Asset 4.50 count % Description 4 25.00% Added Asset(s) 6 37.50% Deleted Asset(s) 4 25.00% Operating fund too high 9 56.25% Operating fund too low 3 18.75% Replacement fund too high 1 6.25% Replacement fund too low 5 31.25% Cost too high 9 56.25% Cost too low Park Paseo Homeowners Association RDA Forensic Analysis For 2011 to 2012 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 010.000.01 Overlay/Rehab Overlay/Rehab 7 20 $11,287.65 $7,336.97 $0.00 010.000.01 Overlay/Rehab Overlay/Rehab 6 20 $11,455.00 $8,102.00 $0.00 No assigned value 010.000.03 Asphalt Repairs Asphalt Repairs 1 4 $1,933.16 $1,449.87 $1,449.87 010.000.03 Asphalt Repairs Asphalt Repairs 0 3 $2,432.00 $2,432.00 $2,432.00 Useful life decreased Cost value too high should be $1,971.82 Fully funded value too high should be $1,971.82 Assigned value too high should be $1,971.82 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 1 4 $1,945.81 $1,459.36 $1,459.36 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 0 3 $2,511.00 $2,511.00 $2,511.00 Useful life decreased Cost value too high should be $1,984.73 Fully funded value too high should be $1,984.73 Assigned value too high should be $1,984.73 020.000.01 Prosa Cabana Prosa Cabana 24 25 $10,298.25 $411.93 $0.00 Asset deleted 020.000.03 Clubhouse, Tile Clubhouse, Tile 35 50 $24,452.30 $7,334.69 $0.00 020.000.03 Clubhouse, Tile Clubhouse, Tile 34 50 $24,929.00 $7,949.00 $0.00 No assigned value 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 12 18 $1,167.99 $389.33 $0.00 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 11 18 $1,248.00 $471.00 $0.00 No assigned value 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 49 50 $10,696.00 $214.00 $0.00 New Assets 030.001.01 Aluminum, Pools Aluminum, Pools 9 10 $9,476.80 $947.68 $0.00 030.001.01 Aluminum, Pools Aluminum, Pools 13 10 $9,709.00 $1,295.00 $0.00 Maintenance completed 030.001.02 Interior Clubhou Interior Clubhouse 6 8 $3,963.96 $990.99 $0.00 030.001.02 Interior Clubhou Interior Clubhouse 5 8 $4,029.00 $1,511.00 $0.00 No assigned value 030.001.03 Interior Prosa R Interior Prosa Restrooms 0 8 $1,810.26 $1,810.26 $1,810.26 030.001.03 Interior Prosa R Interior Prosa Restrooms 7 8 $1,500.00 $115.00 $0.00 Maintenance completed 030.001.05 Spa Equipment Ro Spa Equipment Room 0 5 $2,486.00 $2,486.00 $2,486.00 030.001.05 Spa Equipment Ro Spa Equipment Room 4 5 $2,618.00 $333.00 $0.00 Maintenance completed 030.001.06 Stucco Stucco 0 10 $3,000.00 $3,000.00 $3,000.00 030.001.06 Stucco Stucco 9 10 $3,000.00 $158.00 $0.00 Maintenance completed Cost not changed 030.001.07 Woodwork Prosa Woodwork Prosa 0 5 $2,927.52 $2,927.52 $2,927.52 030.001.07 Woodwork Prosa Woodwork Prosa 4 5 $3,082.00 $392.00 $0.00 Maintenance completed 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $945.56 $945.56 $945.56 030.002.04 Wrought Iron, St Wrought Iron, Streets 2 3 $154.00 $51.00 $51.00 Maintenance completed 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 0 5 $10,681.80 $10,681.80 $10,681.80 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 4 5 $11,244.00 $1,431.00 $0.00 Maintenance completed 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 29 30 $97,731.60 $3,257.72 $0.00 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 28 30 $132,841.00 $7,814.00 $0.00 Cost value too high should be $99,686.23 Fully funded value too high should be $6,645.75 No assigned value 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 24 25 $46,350.00 $1,854.00 $0.00 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 23 25 $47,648.00 $3,812.00 $0.00 No assigned value 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 19 20 $882.00 $19.00 $0.00 New Assets 040.000.04 W/I, Delamesa/Ca W/I, Delamesa/Campanero 19 20 $6,190.00 $310.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 19 20 $2,500.00 $74.00 $0.00 Maintenance completed 040.000.10 Wrought Iron, St Wrought Iron, Streets 13 20 $3,150.49 $1,102.67 $0.00 Asset deleted 040.000.11 Wrought Iron, St Wrought Iron, Street 0 20 $854.00 $854.00 $854.00 Asset deleted 050.000.01 Exterior, Pool/C Exterior, Pool/Club 2 10 $14,199.25 $11,359.40 $11,359.40 050.000.01 Exterior, Pool/C Exterior, Pool/Club 1 10 $12,826.00 $12,203.00 $12,203.00 Cost value too low should be $14,483.24 Fully funded value too low should be $13,034.91 Assigned value too low should be $13,034.91 050.000.03 Exterior, Parkin Exterior, Parking Lot 11 22 $1,253.16 $626.58 $0.00 050.000.03 Exterior, Parkin Exterior, Parking Lot 10 22 $1,335.00 $707.00 $0.00 No assigned value 050.000.05 Exterior, Prosa Exterior, Prosa 2 10 $2,746.88 $2,197.50 $2,197.50 050.000.05 Exterior, Prosa Exterior, Prosa 1 10 $2,478.00 $2,358.00 $2,358.00 Cost value too low should be $2,801.82 Fully funded value too low should be $2,521.64 Assigned value too low should be $2,521.64 050.000.07 Parking Lot, Ori Parking Lot, Original 3 22 $6,910.76 $5,968.38 $5,968.38 050.000.07 Parking Lot, Ori Parking Lot, Original 2 22 $6,675.00 $6,314.00 $6,314.00 Cost value too low should be $7,048.97 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 3 15 $92,441.34 $73,953.07 $73,953.07 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 0 15 $87,380.00 $87,380.00 $87,380.00 Remaining life decreased too much Cost value too low should be $94,290.17 Fully funded value too low should be $94,290.17 Assigned value too low should be $94,290.17 060.001.08 Exterior Stairca Exterior Staircase 25 30 $15,292.08 $2,548.68 $0.00 060.001.08 Exterior Stairca Exterior Staircase 24 30 $17,176.00 $3,202.00 $0.00 Cost value too high should be $15,597.92 No assigned value 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 19 25 $15,909.75 $3,818.34 $0.00 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 18 25 $17,086.00 $4,618.00 $0.00 Cost value too high should be $16,227.94 No assigned value 060.001.10 Furnishings Furnishings 5 10 $30,000.00 $15,000.00 $0.00 060.001.10 Furnishings Furnishings 4 10 $30,000.00 $18,000.00 $0.00 Cost not changed 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 17 20 $3,176.00 $476.40 $0.00 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 16 20 $3,265.00 $653.00 $0.00 No assigned value 060.001.13 HVAC Heat/Air, C HVAC Heat/Air, Clubhouse 2 20 $26,894.63 $24,205.17 $24,205.17 060.001.13 HVAC Heat/Air, C HVAC Heat/Air, Clubhouse 1 20 $28,565.00 $27,772.00 $27,772.00 Fully funded value too high should be $26,060.90 Assigned value too high should be $26,060.90 060.001.15 Water Heater Water Heater 3 12 $3,454.75 $2,591.06 $2,591.06 060.001.15 Water Heater Water Heater 2 12 $3,278.00 $2,868.00 $2,868.00 Cost value too low should be $3,523.85 060.001.16 Wallpaper Wallpaper 9 15 $11,938.08 $4,775.23 $0.00 060.001.16 Wallpaper Wallpaper 8 15 $12,700.00 $5,773.00 $0.00 No assigned value 060.001.18 Carpeting Carpeting 0 8 $10,981.53 $10,981.53 $10,981.53 060.001.18 Carpeting Carpeting 0 8 $11,323.00 $11,323.00 $11,323.00 Maintenance deferred 060.002.01 Doors, Double Sl Doors, Double Slide 2 25 $7,442.63 $6,847.22 $6,847.22 060.002.01 Doors, Double Sl Doors, Double Slide 25 25 $6,500.00 $0.00 $0.00 Maintenance completed 060.002.02 Doors, Exterior, Doors, Exterior, Entry 19 25 $11,256.75 $2,701.62 $0.00 060.002.02 Doors, Exterior, Doors, Exterior, Entry 18 25 $12,090.00 $3,268.00 $0.00 Cost value too high should be $11,481.89 No assigned value 060.002.03 Doors, Entry Doors, Entry 0 25 $13,950.00 $13,950.00 $13,950.00 060.002.03 Doors, Entry Doors, Entry 0 25 $14,448.00 $14,448.00 $14,448.00 Maintenance deferred 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 6 25 $2,393.42 $1,819.00 $0.00 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 5 25 $2,236.00 $1,957.00 $0.00 Cost value too low should be $2,441.29 No assigned value 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 1 25 $5,964.00 $5,798.00 $5,798.00 New Assets 060.002.08 Doors, Entry Int Doors, Entry Interior 6 25 $1,729.53 $1,314.44 $0.00 060.002.08 Doors, Entry Int Doors, Entry Interior 5 25 $1,811.00 $1,476.00 $0.00 No assigned value 060.003.01 Kitchen, Applian Kitchen, Appliances 6 12 $4,639.54 $2,319.77 $0.00 060.003.01 Kitchen, Applian Kitchen, Appliances 5 12 $4,910.00 $2,806.00 $0.00 No assigned value 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 19 25 $21,165.75 $5,079.78 $0.00 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 18 25 $22,731.00 $6,144.00 $0.00 Cost value too high should be $21,589.06 No assigned value 060.003.08 Kitchen, Sink Kitchen, Sink 19 25 $672.92 $161.50 $0.00 060.003.08 Kitchen, Sink Kitchen, Sink 18 25 $723.00 $195.00 $0.00 Cost value too high should be $686.38 No assigned value 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 6 8 $15,593.24 $3,898.31 $0.00 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 5 8 $10,000.00 $4,915.00 $0.00 Cost value too low should be $15,905.11 Fully funded value too low should be $5,964.41 No assigned value 060.004.10 Office, Remodel Office, Remodel 16 20 $11,240.00 $2,248.00 $0.00 060.004.10 Office, Remodel Office, Remodel 15 20 $11,958.00 $2,914.00 $0.00 No assigned value 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 23 25 $14,745.38 $1,179.63 $0.00 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 22 25 $10,730.00 $1,288.00 $0.00 Cost value too low should be $15,040.29 Fully funded value too low should be $1,804.83 No assigned value 060.005.03 Restroom, Counte Restroom, Counters 18 20 $3,536.00 $353.60 $0.00 060.005.03 Restroom, Counte Restroom, Counters 17 20 $3,600.00 $540.00 $0.00 No assigned value 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 23 25 $2,077.50 $166.29 $0.00 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 22 25 $2,136.00 $256.00 $0.00 No assigned value 060.005.07 Restroom, Locker Restroom, Lockers/Benches 20 22 $19,999.98 $1,818.18 $0.00 060.005.07 Restroom, Locker Restroom, Lockers/Benches 19 22 $20,000.00 $2,727.00 $0.00 No assigned value 060.005.08 Restroom, Partit Restroom, Partitions 18 20 $4,755.00 $475.50 $0.00 060.005.08 Restroom, Partit Restroom, Partitions 17 20 $4,830.00 $725.00 $0.00 No assigned value 060.005.10 Restroom, Shower Restroom, Shower Door 14 16 $1,768.00 $221.00 $0.00 060.005.10 Restroom, Shower Restroom, Shower Door 13 16 $1,816.00 $341.00 $0.00 No assigned value 060.005.12 Women's Shower Women's Shower 0 25 $10,500.00 $10,500.00 $10,500.00 New Assets 060.005.13 Restroom, Fixtur Restroom, Fixtures 23 25 $6,397.00 $511.76 $0.00 060.005.13 Restroom, Fixtur Restroom, Fixtures 22 25 $6,636.00 $796.00 $0.00 No assigned value 065.001.04 Motor/Pump Syste Motor/Pump System 2 8 $1,610.71 $1,208.33 $1,208.33 065.001.04 Motor/Pump Syste Motor/Pump System 1 8 $1,491.00 $1,367.00 $1,367.00 Cost value too low should be $1,642.92 065.002.02 Spa, Heater Spa, Heater 3 10 $3,910.71 $2,737.50 $2,737.50 065.002.02 Spa, Heater Spa, Heater 2 10 $3,752.00 $3,127.00 $3,127.00 Cost value too low should be $3,988.92 065.002.04 Spa, Pump/Motor, Spa, Pump/Motor, Booster 2 8 $2,672.67 $2,004.55 $2,004.55 065.002.04 Spa, Pump/Motor, Spa, Pump/Motor, Booster 1 8 $2,518.00 $2,289.00 $2,289.00 Cost value too low should be $2,726.12 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 2 12 $7,344.50 $6,120.42 $6,120.42 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 0 12 $7,196.00 $7,196.00 $7,196.00 Remaining life decreased too much 065.002.06 Spa, Sump Pump Spa, Sump Pump 4 8 $2,469.42 $1,234.71 $0.00 065.002.06 Spa, Sump Pump Spa, Sump Pump 3 8 $2,686.00 $1,623.00 $1,623.00 Cost value too high should be $2,518.81 065.003.02 Wader, Heater Wader, Heater 7 12 $2,629.56 $1,095.65 $0.00 065.003.02 Wader, Heater Wader, Heater 6 12 $2,878.00 $1,376.00 $0.00 Cost value too high should be $2,682.15 No assigned value 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 2 8 $844.16 $633.12 $633.12 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 1 8 $771.00 $711.00 $711.00 Cost value too low should be $861.04 Fully funded value too low should be $753.41 Assigned value too low should be $753.41 067.001.03 Barbecues Barbecues 0 14 $7,513.00 $7,513.00 $7,513.00 067.001.03 Barbecues Barbecues 4 5 $4,451.00 $566.00 $0.00 Maintenance completed 067.001.04 Barbecues, Main, Barbecues, Main, 1994 0 10 $707.00 $707.00 $707.00 Asset deleted 067.001.05 Ceramic Shower Ceramic Shower 4 25 $2,070.81 $1,739.48 $0.00 067.001.05 Ceramic Shower Ceramic Shower 3 25 $1,976.00 $1,820.00 $1,820.00 Cost value too low should be $2,112.23 067.002.02 Deck Caulking Deck Caulking 0 4 $9,292.50 $9,292.50 $9,292.50 067.002.02 Deck Caulking Deck Caulking 0 4 $10,500.00 $10,500.00 $10,500.00 Maintenance deferred Cost value too high should be $9,478.35 Fully funded value too high should be $9,478.35 Assigned value too high should be $9,478.35 067.002.03 Deck Repairs Deck Repairs 0 30 $11,407.53 $11,407.53 $11,407.53 067.002.03 Deck Repairs Deck Repairs 0 30 $11,582.00 $11,582.00 $11,582.00 Maintenance deferred 067.003.02 Furniture, 2001 Furniture, 2001 2 7 $20,258.00 $14,470.00 $14,470.00 067.003.02 Furniture, 2001 Furniture, 2001 1 7 $17,821.00 $16,336.00 $16,336.00 Cost value too low should be $20,663.16 Fully funded value too low should be $17,711.28 Assigned value too low should be $17,711.28 067.003.03 Furniture, 2007 Furniture, 2007 3 7 $13,513.57 $7,722.04 $1,287.65 067.003.03 Furniture, 2007 Furniture, 2007 2 7 $14,584.00 $10,153.00 $10,153.00 Cost value too high should be $13,783.84 069.001.01 Filter, Prosa Filter, Prosa 9 12 $1,293.52 $323.38 $0.00 069.001.01 Filter, Prosa Filter, Prosa 8 12 $1,491.00 $461.00 $0.00 Cost value too high should be $1,319.39 No assigned value 069.001.02 Filter, 2010 Filter, 2010 11 12 $1,449.96 $120.83 $0.00 069.001.02 Filter, 2010 Filter, 2010 10 12 $1,491.00 $249.00 $0.00 No assigned value 069.001.04 Heater, Prosa Heater, Prosa 2 12 $13,090.91 $10,909.09 $10,909.09 069.001.04 Heater, Prosa Heater, Prosa 1 12 $12,336.00 $11,775.00 $11,775.00 Cost value too low should be $13,352.73 069.001.05 Motor Motor 1 8 $2,108.00 $1,845.00 $1,845.00 New Assets 069.001.06 Pump Pump 2 8 $2,050.00 $1,537.50 $1,537.50 Asset deleted 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 2 14 $30,307.26 $25,977.65 $25,977.65 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 0 14 $30,840.00 $30,840.00 $30,840.00 Remaining life decreased too much 070.001.01 Aluminum Trellis Aluminum Trellis 29 30 $10,587.90 $352.93 $0.00 070.001.01 Aluminum Trellis Aluminum Trellis 28 30 $10,884.00 $726.00 $0.00 No assigned value 070.001.02 Barbecues Barbecues 2 10 $1,636.25 $1,309.26 $1,309.26 070.001.02 Barbecues Barbecues 7 8 $3,639.00 $204.00 $0.00 Maintenance completed Useful life decreased 070.001.05 Furniture Furniture 2 7 $9,478.00 $6,770.00 $6,770.00 070.001.05 Furniture Furniture 1 7 $8,337.00 $7,642.00 $7,642.00 Cost value too low should be $9,667.56 Fully funded value too low should be $8,286.48 Assigned value too low should be $8,286.48 070.001.07 Repairs Repairs 4 20 $3,130.69 $2,504.55 $0.00 070.001.07 Repairs Repairs 3 20 $2,895.00 $2,632.00 $2,632.00 Cost value too low should be $3,193.30 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 4 5 $3,500.00 $700.00 $0.00 Maintenance completed Cost not changed 070.004.01 Water Heater Water Heater 0 18 $3,189.00 $3,189.00 $3,189.00 070.004.01 Water Heater Water Heater 0 18 $3,278.00 $3,278.00 $3,278.00 Maintenance deferred 070.005.01 Restroom, Counte Restroom, Counters 4 20 $1,076.51 $861.21 $0.00 070.005.01 Restroom, Counte Restroom, Counters 3 20 $1,008.00 $916.00 $916.00 Cost value too low should be $1,098.04 080.000.01 Benches Benches 15 15 $0.00 $0.00 $0.00 080.000.01 Benches Benches 14 15 $18,508.00 $1,234.00 $0.00 Asset changed to funded 080.000.02 Chain Link Fenci Chain Link Fencing 6 25 $19,583.55 $14,883.50 $0.00 080.000.02 Chain Link Fenci Chain Link Fencing 5 30 $18,603.00 $16,278.00 $0.00 Useful life increased Cost value too low should be $19,975.22 No assigned value 080.000.05 Lighting Lighting 6 25 $13,689.47 $10,404.00 $0.00 080.000.05 Lighting Lighting 5 25 $12,432.00 $10,878.00 $0.00 Cost value too low should be $13,963.26 No assigned value 080.000.07 Windscreen Windscreen 1 6 $3,400.08 $2,833.40 $2,833.40 080.000.07 Windscreen Windscreen 0 6 $3,124.00 $3,124.00 $3,124.00 Cost value too low should be $3,468.08 Fully funded value too low should be $3,468.08 Assigned value too low should be $3,468.08 085.001.01 Benches Benches 11 12 $10,585.00 $814.00 $0.00 New Assets 085.001.02 Trash Cans Trash Cans 15 15 $0.00 $0.00 $0.00 085.001.02 Trash Cans Trash Cans 14 15 $9,972.00 $665.00 $0.00 Asset changed to funded 085.002.01 Drinking Fountai Drinking Fountain, C/H 2 16 $2,931.54 $2,565.10 $2,565.10 085.002.01 Drinking Fountai Drinking Fountain, C/H 15 16 $2,749.00 $74.00 $0.00 Maintenance completed 085.002.02 Drinking Fntns, Drinking Fntns, Concrete 3 30 $5,707.78 $5,136.76 $0.00 Asset deleted 085.002.03 Drinking Fountai Drinking Fountain, Prosa 1 16 $1,380.00 $1,335.00 $1,335.00 New Assets 085.003.01 Play Equipment, Play Equipment, Alba 6 18 $20,241.00 $13,494.00 $0.00 085.003.01 Play Equipment, Play Equipment, Alba 5 18 $20,808.00 $15,028.00 $0.00 No assigned value 085.003.03 Sand Repl, Prosa Sand Repl, Prosa/Alba 2 10 $7,718.75 $6,174.64 $6,174.64 085.003.03 Sand Repl, Prosa Sand Repl, Prosa/Alba 1 10 $6,964.00 $6,656.00 $6,656.00 Cost value too low should be $7,873.12 Fully funded value too low should be $7,085.81 Assigned value too low should be $7,085.81 085.004.01 Play Equip, Main Play Equip, Main, Prosa 4 18 $45,656.23 $35,510.40 $0.00 085.004.01 Play Equip, Main Play Equip, Main, Prosa 3 18 $47,321.00 $39,209.00 $25,065.00 Assigned value too low should be $38,807.80 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $6,000.36 $6,000.36 $6,000.36 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $6,168.00 $6,168.00 $6,168.00 Maintenance deferred 090.000.02 Trellis, Clubhou Trellis, Clubhouse 29 30 $41,358.00 $816.00 $0.00 New Assets 090.000.05 Trellis, Wood, R Trellis, Wood, Repairs 0 12 $35,000.00 $35,000.00 $35,000.00 Asset deleted 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 2 3 $26,470.59 $8,823.53 $8,823.53 095.002.06 Tree Trimming, W Tree Trimming, Windrow 1 3 $30,000.00 $19,412.00 $19,412.00 Cost value too high should be $27,000.00 Fully funded value too high should be $18,000.00 Assigned value too high should be $18,000.00 097.000.02 Irrigation, Cont Irrigation, Controllers 2 12 $47,520.00 $39,600.00 $39,600.00 097.000.02 Irrigation, Cont Irrigation, Controllers 1 12 $45,232.00 $42,970.00 $42,970.00 Cost value too low should be $48,470.40 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 24 $24,000.00 $24,000.00 $24,000.00 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 24 $24,672.00 $24,672.00 $24,672.00 Maintenance deferred 100.000.01 Bulletin Board Bulletin Board 3 12 $1,114.28 $835.71 $0.00 100.000.01 Bulletin Board Bulletin Board 2 12 $1,018.00 $912.00 $912.00 Cost value too low should be $1,136.57 100.000.02 Monument Monument 0 30 $3,000.00 $3,000.00 $3,000.00 100.000.02 Monument Monument 0 30 $3,084.00 $3,084.00 $3,084.00 Maintenance deferred 105.000.01 Termite Control/ Termite Control/Fumigation 0 15 $4,650.00 $4,650.00 $4,650.00 105.000.01 Termite Control/ Termite Control/Fumigation 0 15 $4,780.00 $4,780.00 $4,780.00 Maintenance deferred 110.000.01 Golf Cart, Repla Golf Cart, Replacement 3 12 $5,757.57 $4,318.18 $4,318.18 110.000.01 Golf Cart, Repla Golf Cart, Replacement 0 12 $0.00 $0.00 $0.00 Assets changed to unfunded 2011 - 2012 RDA Forensic Analysis Summary Estimated inflation 2% Consumer Price Index 3.2% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $1,253,066.55 $762,163.57 $559,309.75 This Year Costs $1,335,132.00 $790,377.00 $628,863.00 Calculated Costs $1,324,982.90 $788,922.34 $788,922.34 Comparing This Year Costs to Last Year Costs Difference $82,065.45 $28,213.43 $69,553.25 percent difference 6.55% 3.70% 12.44% exceeds CC&R limits Comparing This Year Costs to Calculated Costs Difference $10,149.10 $1,454.66 $-160,059.34 percent difference 0.76% 0.18% -25.45% 118 Total Assets 60 Total Issues $197,680.53 Unfunded Liability 0.51 Issues / Asset number % Description 9 7.63% New Assets 33 27.97% No assigned value 14 11.86% Cost value too high 24 20.34% Cost value too low 6 5.08% Fully funded value too high 10 8.47% Fully funded value too low 5 4.24% Assigned value too high 9 7.63% Assigned value too low 7 5.93% Asset deleted 3 2.54% Remaining life decreased too much 2 1.69% Asset changed to funded 1 0.85% Useful life increased 3 2.54% Useful life decreased 10 8.47% Maintenance deferred 13 11.02% Maintenance completed 19 16.10% Total assets to be maintained 4 3.39% Cost not changed 1 0.85% Assets changed to unfunded