Park Paseo Homeowners Association Audited Forensic Report For 2004 to 2005 Revenue 540.000.10 Other Income $9,521.00 $0.00 $9,521.00 540.000.10 Other Income $7,712.00 $0.00 $7,712.00 Operating fund too high difference is $1,809.00 Cost too high difference is $1,809.00 550.000.03 Investment Income $16,478.00 $0.00 $16,478.00 550.000.03 Investment Income $13,170.00 $0.00 $13,170.00 Operating fund too high difference is $3,308.00 Cost too high difference is $3,308.00 Expense 640.000.07 Office supplies/printing/postage $8,823.00 $0.00 $8,823.00 640.000.07 Office supplies/printing/postage $9,735.00 $0.00 $9,735.00 Operating fund too low difference is $-912.00 Cost too low difference is $-912.00 680.001.02 Newsletters/Mailouts/Extras $2,733.00 $0.00 $2,733.00 680.001.02 Newsletters/Mailouts/Extras $3,085.00 $0.00 $3,085.00 Operating fund too low difference is $-352.00 Cost too low difference is $-352.00 700.000.01 Insurance $19,105.00 $0.00 $19,105.00 700.000.01 Insurance $17,354.00 $0.00 $17,354.00 Operating fund too high difference is $1,751.00 Cost too high difference is $1,751.00 780.000.01 Property Protection - Patrol Service $45,715.00 $0.00 $45,715.00 780.000.01 Property Protection - Patrol Service $53,685.00 $0.00 $53,685.00 Operating fund too low difference is $-7,970.00 Cost too low difference is $-7,970.00 840.001.11 Common Areas $34,626.00 $0.00 $34,626.00 840.001.11 Common Areas $34,345.00 $50,173.00 $84,518.00 Replacement fund too low difference is $-50,173.00 Cost too low difference is $-49,892.00 840.006.05 Pool Monitor $25,787.00 $0.00 $25,787.00 840.006.05 Pool Monitor $29,629.00 $0.00 $29,629.00 Operating fund too low difference is $-3,842.00 Cost too low difference is $-3,842.00 860.000.04 Trash and Recycling Service $55,775.00 $0.00 $55,775.00 860.000.04 Trash and Recycling Service $59,170.00 $0.00 $59,170.00 Operating fund too low difference is $-3,395.00 Cost too low difference is $-3,395.00 880.000.01 Federal Income Tax $4,996.00 $0.00 $4,996.00 880.000.01 Federal Income Tax $4,151.00 $0.00 $4,151.00 Operating fund too high difference is $845.00 Cost too high difference is $845.00 920.000.07 Clubhouse Reserve $146,369.00 $33,255.00 $179,644.00 Added Asset(s) Expense 920.000.10 Pool/Spa $22,652.00 $1,447.00 $24,099.00 Added Asset(s) Expense 2004 - 2005 Analysis Summary Estimated inflation 3% Consumer Price Index 2.7% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2004 $418,974.00 $71,479.00 $490,453.00 Revenue 2005 $426,606.00 $76,923.00 $503,529.00 Expense 2004 $576,615.00 $83,428.00 $660,063.00 Expense 2005 $441,986.00 $1,447.00 $443,433.00 revenue - expense 2004 $-157,641.00 $-11,949.00 $-169,610.00 revenue - expense 2005 $-15,380.00 $75,476.00 $60,096.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $142,261.00 $87,425.00 $229,706.00 percent difference 9.76% -631.65% -35.43% Total Assets 17 Total Issues 42 Issues/Asset 2.47 count % Description 2 11.76% Added Asset(s) 4 23.53% Operating fund too high 5 29.41% Operating fund too low 1 5.88% Replacement fund too low 4 23.53% Cost too high 6 35.29% Cost too low Park Paseo Homeowners Association UnAudited Forensic Report For 2004 to 2005 Revenue 540.000.10 Other Income $9,521.00 $0.00 $9,521.00 540.000.10 Other Income $7,712.00 $0.00 $7,712.00 Operating fund too high difference is $1,809.00 Cost too high difference is $1,809.00 550.000.03 Investment Income $16,478.00 $0.00 $16,478.00 550.000.03 Investment Income $13,170.00 $0.00 $13,170.00 Operating fund too high difference is $3,308.00 Cost too high difference is $3,308.00 Expense 640.000.07 Office supplies/printing/postage $8,823.00 $0.00 $8,823.00 640.000.07 Office supplies/printing/postage $9,735.00 $0.00 $9,735.00 Operating fund too low difference is $-912.00 Cost too low difference is $-912.00 680.001.02 Newsletters/Mailouts/Extras $2,733.00 $0.00 $2,733.00 680.001.02 Newsletters/Mailouts/Extras $3,085.00 $0.00 $3,085.00 Operating fund too low difference is $-352.00 Cost too low difference is $-352.00 700.000.01 Insurance $19,105.00 $0.00 $19,105.00 700.000.01 Insurance $17,354.00 $0.00 $17,354.00 Operating fund too high difference is $1,751.00 Cost too high difference is $1,751.00 780.000.01 Property Protection - Patrol Service $45,715.00 $0.00 $45,715.00 780.000.01 Property Protection - Patrol Service $53,685.00 $0.00 $53,685.00 Operating fund too low difference is $-7,970.00 Cost too low difference is $-7,970.00 840.001.11 Common Areas $34,626.00 $0.00 $34,626.00 840.001.11 Common Areas $34,345.00 $50,173.00 $84,518.00 Replacement fund too low difference is $-50,173.00 Cost too low difference is $-49,892.00 840.006.05 Pool Monitor $25,787.00 $0.00 $25,787.00 840.006.05 Pool Monitor $29,629.00 $0.00 $29,629.00 Operating fund too low difference is $-3,842.00 Cost too low difference is $-3,842.00 860.000.04 Trash and Recycling Service $55,775.00 $0.00 $55,775.00 860.000.04 Trash and Recycling Service $59,170.00 $0.00 $59,170.00 Operating fund too low difference is $-3,395.00 Cost too low difference is $-3,395.00 880.000.01 Federal Income Tax $4,996.00 $0.00 $4,996.00 880.000.01 Federal Income Tax $4,151.00 $0.00 $4,151.00 Operating fund too high difference is $845.00 Cost too high difference is $845.00 920.000.07 Clubhouse Reserve $146,369.00 $33,255.00 $179,644.00 Added Asset(s) Expense 920.000.10 Pool/Spa $22,652.00 $1,447.00 $24,099.00 Added Asset(s) Expense 2004 - 2005 Analysis Summary Estimated inflation 3% Consumer Price Index 2.7% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2004 $418,974.00 $71,479.00 $490,453.00 Revenue 2005 $426,606.00 $76,923.00 $503,529.00 Expense 2004 $576,615.00 $83,428.00 $660,063.00 Expense 2005 $441,986.00 $1,447.00 $443,433.00 revenue - expense 2004 $-157,641.00 $-11,949.00 $-169,610.00 revenue - expense 2005 $-15,380.00 $75,476.00 $60,096.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $142,261.00 $87,425.00 $229,706.00 percent difference 9.76% -631.65% -35.43% Total Assets 17 Total Issues 42 Issues/Asset 2.47 count % Description 2 11.76% Added Asset(s) 4 23.53% Operating fund too high 5 29.41% Operating fund too low 1 5.88% Replacement fund too low 4 23.53% Cost too high 6 35.29% Cost too low Park Paseo Homeowners Association RDA Forensic Analysis For 2004 to 2005 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 010.000.01 Overlay/Rehab Overlay/Rehab 15 20 $6,167.00 $1,541.83 $0.00 010.000.01 Overlay/Rehab Overlay/Rehab 14 20 $5,257.00 $1,834.00 $0.00 Cost value too low should be $6,352.01 No assigned value 020.000.01 Prosa Cabana Prosa Cabana 0 25 $4,149.00 $4,149.15 $4,149.15 020.000.01 Prosa Cabana Prosa Cabana 0 25 $4,577.00 $4,577.00 $4,577.00 Maintenance deferred Cost value too high should be $4,273.47 Fully funded value too high should be $4,273.47 Assigned value too high should be $4,273.47 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 0 15 $591.60 $591.60 $591.60 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 0 15 $609.00 $609.00 $609.00 Maintenance deferred 030.001.02 Interior Clubhou Interior Clubhouse 0 8 $1,867.00 $1,867.32 $1,867.32 030.001.02 Interior Clubhou Interior Clubhouse 0 8 $1,933.00 $1,933.00 $1,933.00 Maintenance deferred 030.001.03 Interior Prosa R Interior Prosa Restrooms 0 8 $852.72 $852.72 $852.72 030.001.03 Interior Prosa R Interior Prosa Restrooms 0 8 $883.00 $883.00 $883.00 Maintenance deferred 030.001.07 Woodwork Prosa Woodwork Prosa 3 7 $2,105.00 $1,203.01 $1,203.01 030.001.07 Woodwork Prosa Woodwork Prosa 2 7 $2,337.00 $1,618.00 $1,618.00 Cost value too high should be $2,168.15 030.002.01 Wrought Iron Cl Wrought Iron Clubhouse 0 3 $1,487.00 $1,487.40 $1,487.40 030.002.01 Wrought Iron Cl Wrought Iron Clubhouse 2 3 $1,528.00 $345.00 $345.00 Maintenance completed 030.002.03 Wrought Iron Pr Wrought Iron Prosa 0 3 $660.00 $660.45 $660.45 030.002.03 Wrought Iron Pr Wrought Iron Prosa 1 3 $678.00 $452.00 $452.00 Maintenance deferred Remaining life increased 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $675.00 $675.40 $675.40 030.002.04 Wrought Iron, St Wrought Iron, Streets 2 3 $700.00 $158.00 $158.00 Maintenance completed 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 2 6 $7,781.00 $5,187.57 $5,187.57 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 1 6 $8,527.00 $6,976.00 $6,976.00 Cost value too high should be $8,014.43 040.000.08 Wrought Iron, Ma Wrought Iron, Main Pool 5 10 $27,222.00 $20,455.76 $20,455.76 040.000.08 Wrought Iron, Ma Wrought Iron, Main Pool 7 10 $30,338.00 $19,720.00 $19,720.00 Remaining life increased Cost value too high should be $28,038.66 Fully funded value too high should be $8,411.60 Assigned value too high should be $8,411.60 040.000.09 Wrought Iron, Pr Wrought Iron, Prosa Pool 5 10 $12,787.00 $9,831.61 $9,831.61 040.000.09 Wrought Iron, Pr Wrought Iron, Prosa Pool 6 10 $14,598.00 $10,219.00 $10,219.00 Remaining life increased Cost value too high should be $13,170.61 Fully funded value too high should be $5,268.24 Assigned value too high should be $5,268.24 040.000.10 Wrought Iron, St Wrought Iron, Streets 2 20 $2,953.00 $2,829.74 $2,829.74 040.000.10 Wrought Iron, St Wrought Iron, Streets 19 20 $2,780.00 $83.00 $0.00 Maintenance completed 040.000.11 Wrought Iron, St Wrought Iron, Street 6 20 $515.00 $379.36 $379.36 040.000.11 Wrought Iron, St Wrought Iron, Street 5 20 $624.00 $464.00 $464.00 Cost value too high should be $530.45 Fully funded value too high should be $397.84 Assigned value too high should be $397.84 050.000.01 Exterior, Pool/C Exterior, Pool/Club 2 10 $9,996.00 $7,997.19 $7,997.19 050.000.01 Exterior, Pool/C Exterior, Pool/Club 1 10 $9,644.00 $8,934.00 $8,934.00 Cost value too low should be $10,295.88 050.000.03 Exterior, Parkin Exterior, Parking Lot 18 22 $874.00 $158.91 $0.00 050.000.03 Exterior, Parkin Exterior, Parking Lot 17 22 $1,070.00 $214.00 $0.00 Cost value too high should be $900.22 No assigned value 050.000.05 Exterior, Prosa Exterior, Prosa 2 10 $1,959.00 $1,567.37 $1,567.37 050.000.05 Exterior, Prosa Exterior, Prosa 1 10 $1,886.00 $1,747.00 $1,747.00 Cost value too low should be $2,017.77 050.001.01 Interior Clubhou Interior Clubhouse 0 25 $11,723.00 $11,723.00 $11,723.00 050.001.01 Interior Clubhou Interior Clubhouse 0 25 $12,066.00 $12,066.00 $12,066.00 Maintenance deferred 060.001.01 Addition Addition 98 99 $0.00 $0.00 $0.00 New Assets 060.001.05 Ceramic Tile, Co Ceramic Tile, Counters 4 20 $1,859.00 $1,487.20 $1,487.20 060.001.05 Ceramic Tile, Co Ceramic Tile, Counters 3 20 $2,288.00 $1,830.00 $1,830.00 Cost value too high should be $1,914.77 Fully funded value too high should be $1,627.55 Assigned value too high should be $1,627.55 060.001.06 Ceramic Tile, Sh Ceramic Tile, Shower 3 20 $1,570.00 $1,334.77 $1,334.77 060.001.06 Ceramic Tile, Sh Ceramic Tile, Shower 2 20 $1,646.00 $1,537.00 $1,537.00 Fully funded value too high should be $1,455.39 Assigned value too high should be $1,455.39 060.001.10 Furnishings Furnishings 0 10 $25,000.00 $25,000.00 $25,000.00 060.001.10 Furnishings Furnishings 0 10 $25,000.00 $25,000.00 $25,000.00 Maintenance deferred Cost not changed 060.001.13 HVAC Heat/Air, C HVAC Heat/Air, Clubhouse 0 18 $20,777.00 $20,777.00 $20,777.00 060.001.13 HVAC Heat/Air, C HVAC Heat/Air, Clubhouse 0 18 $21,379.00 $21,379.00 $21,379.00 Maintenance deferred 060.001.14 Window Blinds Window Blinds 0 12 $6,343.00 $6,343.16 $6,343.16 060.001.14 Window Blinds Window Blinds 0 12 $6,462.00 $6,462.00 $6,462.00 Maintenance deferred 060.001.15 Water Heater Water Heater 0 12 $4,179.00 $4,179.00 $4,179.00 060.001.15 Water Heater Water Heater 0 12 $4,304.00 $4,304.00 $4,304.00 Maintenance deferred 060.001.16 Wallpaper Wallpaper 0 15 $7,217.41 $7,217.41 $7,217.41 060.001.16 Wallpaper Wallpaper 0 15 $7,372.00 $7,372.00 $7,372.00 Maintenance deferred 060.001.18 Carpeting Carpeting 0 8 $6,182.00 $6,182.46 $6,182.46 060.001.18 Carpeting Carpeting 0 8 $6,312.00 $6,312.00 $6,312.00 Maintenance deferred 060.003.02 Appliances, 1977 Appliances, 1977 0 15 $550.00 $550.00 $550.00 060.003.02 Appliances, 1977 Appliances, 1977 0 15 $564.00 $564.00 $564.00 Maintenance deferred 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 1 20 $2,148.00 $2,040.43 $2,040.43 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 0 20 $2,390.00 $2,390.00 $2,390.00 Cost value too high should be $2,212.44 Fully funded value too high should be $2,212.44 Assigned value too high should be $2,212.44 060.004.01 Office, Computer Office, Computers/Equipment 0 5 $4,326.00 $4,326.00 $4,326.00 060.004.01 Office, Computer Office, Computers/Equipment 0 5 $4,455.00 $4,455.00 $4,455.00 Maintenance deferred 060.004.03 Office, Copier Office, Copier 0 5 $2,312.00 $2,312.00 $2,312.00 060.004.03 Office, Copier Office, Copier 0 5 $2,381.00 $2,381.00 $2,381.00 Maintenance deferred 060.004.07 Office, Fax Mach Office, Fax Machine 0 6 $1,110.00 $1,110.00 $1,110.00 060.004.07 Office, Fax Mach Office, Fax Machine 0 6 $1,143.00 $1,143.00 $1,143.00 Maintenance deferred 060.004.08 Office, Furnishi Office, Furnishings 0 4 $2,530.00 $2,530.00 $2,530.00 060.004.08 Office, Furnishi Office, Furnishings 0 4 $2,614.00 $2,614.00 $2,614.00 Maintenance deferred 060.005.01 Restroom Restroom 1 15 $4,297.00 $4,010.55 $4,010.55 Asset deleted 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 6 20 $13,293.00 $9,304.89 $9,304.89 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 5 20 $14,844.00 $11,070.00 $11,070.00 Cost value too high should be $13,691.79 Fully funded value too high should be $10,268.84 Assigned value too high should be $10,268.84 060.005.03 Restroom, Counte Restroom, Counters 6 16 $925.00 $578.17 $578.17 060.005.03 Restroom, Counte Restroom, Counters 5 16 $944.00 $704.00 $704.00 Fully funded value too high should be $655.02 Assigned value too high should be $655.02 060.005.05 Restroom, Locker Restroom, Lockers 0 15 $4,393.00 $4,393.00 $4,393.00 New Assets 060.005.08 Restroom, Partit Restroom, Partitions 2 15 $2,820.00 $2,443.80 $2,443.80 060.005.08 Restroom, Partit Restroom, Partitions 1 15 $3,190.00 $2,990.00 $2,990.00 Cost value too high should be $2,904.60 Fully funded value too high should be $2,710.96 Assigned value too high should be $2,710.96 060.005.10 Restroom, Shower Restroom, Shower Door 11 16 $1,094.00 $341.96 $341.96 060.005.10 Restroom, Shower Restroom, Shower Door 10 16 $1,228.00 $444.00 $444.00 Cost value too high should be $1,126.82 Fully funded value too high should be $422.56 Assigned value too high should be $422.56 065.001.03 Heater, Main Heater, Main 8 12 $17,684.00 $5,894.71 $5,894.71 065.001.03 Heater, Main Heater, Main 7 12 $19,626.00 $7,766.00 $7,766.00 Cost value too high should be $18,214.52 065.001.05 Pump Pump 1 8 $3,933.00 $3,440.94 $3,440.94 065.001.05 Pump Pump 0 8 $3,765.00 $3,765.00 $3,765.00 Cost value too low should be $4,050.99 Fully funded value too low should be $4,050.99 Assigned value too low should be $4,050.99 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 3 10 $37,195.00 $26,036.19 $26,036.19 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 2 10 $40,524.00 $32,351.00 $32,351.00 Cost value too high should be $38,310.85 Fully funded value too high should be $30,648.68 Assigned value too high should be $30,648.68 065.002.02 Spa, Heater Spa, Heater 5 10 $2,734.00 $1,366.75 $1,366.75 065.002.02 Spa, Heater Spa, Heater 4 10 $2,413.00 $1,609.00 $1,609.00 Cost value too low should be $2,816.02 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 3 8 $4,300.00 $2,687.39 $2,687.39 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 2 10 $4,033.00 $3,220.00 $3,220.00 Useful life increased Cost value too low should be $4,429.00 Fully funded value too low should be $3,543.20 Assigned value too low should be $3,543.20 065.003.01 Wader, Filter Wader, Filter 5 9 $517.00 $229.76 $229.76 065.003.01 Wader, Filter Wader, Filter 4 9 $582.00 $305.00 $305.00 Cost value too high should be $532.51 067.001.03 Barbecues Barbecues 12 14 $5,142.00 $734.63 $734.63 067.001.03 Barbecues Barbecues 11 14 $6,204.00 $1,211.00 $1,211.00 Cost value too high should be $5,296.26 Fully funded value too high should be $1,134.91 Assigned value too high should be $1,134.91 067.001.06 Diving Board, Ma Diving Board, Main 6 18 $1,323.00 $882.09 $882.09 067.001.06 Diving Board, Ma Diving Board, Main 5 18 $1,627.00 $1,028.00 $1,028.00 Cost value too high should be $1,362.69 067.003.01 Furniture Furniture 1 7 $25,409.00 $21,779.06 $21,779.06 067.003.01 Furniture Furniture 0 7 $23,718.00 $23,718.00 $23,718.00 Cost value too low should be $26,171.27 Fully funded value too low should be $26,171.27 Assigned value too low should be $26,171.27 069.001.05 Motor Motor 1 8 $625.00 $546.46 $546.46 069.001.05 Motor Motor 0 8 $609.00 $609.00 $609.00 Cost value too low should be $643.75 Fully funded value too low should be $643.75 Assigned value too low should be $643.75 070.001.02 Barbecues Barbecues 0 10 $1,136.00 $1,136.00 $1,136.00 070.001.02 Barbecues Barbecues 0 10 $1,170.00 $1,170.00 $1,170.00 Maintenance deferred 070.001.05 Furniture Furniture 1 7 $6,149.00 $5,270.64 $5,270.64 070.001.05 Furniture Furniture 0 7 $5,740.00 $5,740.00 $5,740.00 Cost value too low should be $6,333.47 Fully funded value too low should be $6,333.47 Assigned value too low should be $6,333.47 070.001.07 Repairs Repairs 2 15 $2,222.00 $1,925.92 $1,925.92 070.001.07 Repairs Repairs 1 15 $2,402.00 $2,302.00 $2,302.00 Fully funded value too high should be $2,136.08 Assigned value too high should be $2,136.08 070.002.01 Ceramic Shower Ceramic Shower 3 25 $4,902.00 $4,314.46 $4,314.46 070.002.01 Ceramic Shower Ceramic Shower 2 25 $5,440.00 $5,005.00 $5,005.00 Cost value too high should be $5,049.06 Fully funded value too high should be $4,645.14 Assigned value too high should be $4,645.14 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 5 25 $6,380.00 $5,104.37 $5,104.37 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 4 25 $6,997.00 $5,960.00 $5,960.00 Cost value too high should be $6,571.40 Fully funded value too high should be $5,519.98 Assigned value too high should be $5,519.98 070.003.01 Deck, Caulking Deck, Caulking 2 4 $2,024.00 $1,012.17 $1,012.17 070.003.01 Deck, Caulking Deck, Caulking 1 4 $2,360.00 $1,701.00 $1,701.00 Cost value too high should be $2,084.72 Fully funded value too high should be $1,563.54 Assigned value too high should be $1,563.54 070.004.02 Water Heater Pro Water Heater Prosa 0 10 $4,179.00 $4,179.00 $4,179.00 070.004.02 Water Heater Pro Water Heater Prosa 0 10 $4,304.00 $4,304.00 $4,304.00 Maintenance deferred 070.005.01 Restroom, Counte Restroom, Counters 2 20 $741.00 $667.33 $667.33 070.005.01 Restroom, Counte Restroom, Counters 1 20 $826.00 $792.00 $792.00 Cost value too high should be $763.23 Fully funded value too high should be $725.07 Assigned value too high should be $725.07 080.000.03 Concrete, Replac Concrete, Replacement 10 10 $0.00 $0.00 $0.00 080.000.03 Concrete, Replac Concrete, Replacement 9 10 $61,800.00 $6,180.00 $6,180.00 Asset changed to funded 080.000.06 Resurfacing Resurfacing 6 6 $0.00 $0.00 $0.00 080.000.06 Resurfacing Resurfacing 5 6 $9,216.00 $1,536.00 $1,536.00 Asset changed to funded 080.000.07 Windscreen Windscreen 0 6 $2,451.00 $2,451.48 $2,451.48 080.000.07 Windscreen Windscreen 0 6 $2,531.00 $2,531.00 $2,531.00 Maintenance deferred 085.002.01 Drinking Fountai Drinking Fountain, C/H 0 12 $21,623.60 $2,162.00 $2,162.00 085.002.01 Drinking Fountai Drinking Fountain, C/H 0 12 $2,308.00 $2,308.00 $2,308.00 Maintenance deferred Cost value too low should be $22,272.31 Fully funded value too low should be $22,272.31 Assigned value too low should be $22,272.31 085.003.01 Play Equipment, Play Equipment, Alba 15 20 $16,223.00 $4,055.75 $0.00 085.003.01 Play Equipment, Play Equipment, Alba 14 20 $16,709.00 $5,013.00 $0.00 No assigned value 085.003.03 Sand Repl, Prosa Sand Repl, Prosa/Alba 0 10 $2,623.60 $2,623.60 $2,623.60 085.003.03 Sand Repl, Prosa Sand Repl, Prosa/Alba 0 10 $2,801.00 $2,801.00 $2,801.00 Maintenance deferred 085.004.01 Play Equip, Main Play Equip, Main, Prosa 13 20 $35,136.00 $12,297.67 $10,002.78 085.004.01 Play Equip, Main Play Equip, Main, Prosa 12 20 $37,999.00 $14,615.00 $10,833.00 Assigned value too low should be $14,476.03 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $2,323.76 $2,323.76 $2,323.76 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $2,481.00 $2,481.00 $2,481.00 Maintenance deferred 090.000.04 Trellis, Wood, P Trellis, Wood, Patio Cover 14 15 $10,000.00 $666.67 $0.00 090.000.04 Trellis, Wood, P Trellis, Wood, Patio Cover 13 15 $10,000.00 $1,333.00 $0.00 Cost not changed 095.002.05 Tree Trimming Tree Trimming 2 3 $20,455.00 $6,818.24 $6,818.24 095.002.05 Tree Trimming Tree Trimming 1 3 $25,536.00 $16,250.00 $16,250.00 Cost value too high should be $21,068.65 Fully funded value too high should be $14,045.77 Assigned value too high should be $14,045.77 097.000.02 Irrigation, Cont Irrigation, Controllers 2 12 $27,133.00 $22,610.92 $22,610.82 097.000.02 Irrigation, Cont Irrigation, Controllers 1 12 $29,160.00 $26,917.00 $26,917.00 Fully funded value too high should be $25,618.07 Assigned value too high should be $25,618.07 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 25 $8,750.00 $8,750.00 $8,750.00 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 25 $9,100.00 $9,100.00 $9,100.00 Maintenance deferred 110.000.01 Golf Cart, Repla Golf Cart, Replacement 0 12 $2,000.00 $2,000.00 $2,000.00 110.000.01 Golf Cart, Repla Golf Cart, Replacement 0 12 $2,000.00 $2,000.00 $2,000.00 Maintenance deferred Cost not changed 2004 - 2005 RDA Forensic Analysis Summary Estimated inflation 3% Consumer Price Index 2.7% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $600,851.69 $417,258.83 $408,540.68 This Year Costs $683,256.00 $476,952.00 $464,693.00 Calculated Costs $689,299.88 $497,571.39 $497,571.39 Comparing This Year Costs to Last Year Costs Difference $82,404.31 $59,693.17 $56,152.32 percent difference 13.71% 14.31% 13.74% exceeds CC&R limits Comparing This Year Costs to Calculated Costs Difference $-6,043.88 $-20,619.39 $-32,878.39 percent difference -0.88% -4.32% -7.08% 104 Total Assets 64 Total Issues $37,462.72 Unfunded Liability 0.62 Issues / Asset number % Description 2 1.92% New Assets 3 2.88% No assigned value 22 21.15% Cost value too high 10 9.62% Cost value too low 20 19.23% Fully funded value too high 6 5.77% Fully funded value too low 20 19.23% Assigned value too high 7 6.73% Assigned value too low 1 0.96% Asset deleted 3 2.88% Remaining life increased 2 1.92% Asset changed to funded 1 0.96% Useful life increased 25 24.04% Maintenance deferred 3 2.88% Maintenance completed 27 25.96% Total assets to be maintained 3 2.88% Cost not changed