Park Paseo Homeowners Association Audited Forensic Report For 2005 to 2006 Revenue 530.000.01 Late Fees & Interest $5,815.00 $0.00 $5,815.00 530.000.01 Late Fees & Interest $5,230.00 $0.00 $5,230.00 Operating fund too high difference is $585.00 Cost too high difference is $585.00 540.000.09 Other Charges to Owners $5,968.00 $0.00 $5,968.00 540.000.09 Other Charges to Owners $7,300.00 $0.00 $7,300.00 Operating fund too low difference is $-1,332.00 Cost too low difference is $-1,332.00 540.000.10 Other Income $16,967.00 $0.00 $16,967.00 540.000.10 Other Income $9,521.00 $0.00 $9,521.00 Operating fund too high difference is $7,446.00 Cost too high difference is $7,446.00 550.000.03 Investment Income $25,473.00 $0.00 $25,473.00 550.000.03 Investment Income $16,478.00 $0.00 $16,478.00 Operating fund too high difference is $8,995.00 Cost too high difference is $8,995.00 Expense 640.000.07 Office supplies/printing/postage $10,718.00 $0.00 $10,718.00 640.000.07 Office supplies/printing/postage $8,823.00 $0.00 $8,823.00 Operating fund too high difference is $1,895.00 Cost too high difference is $1,895.00 680.001.02 Newsletters/Mailouts/Extras $2,988.00 $0.00 $2,988.00 680.001.02 Newsletters/Mailouts/Extras $2,733.00 $0.00 $2,733.00 Operating fund too high difference is $255.00 Cost too high difference is $255.00 700.000.01 Insurance $17,685.00 $0.00 $17,685.00 700.000.01 Insurance $19,105.00 $0.00 $19,105.00 Operating fund too low difference is $-1,420.00 Cost too low difference is $-1,420.00 720.000.08 Landscape Expense $140,982.00 $44,660.00 $185,642.00 720.000.08 Landscape Expense $143,832.00 $0.00 $143,832.00 Replacement fund too high difference is $44,660.00 Cost too high difference is $41,810.00 840.001.11 Common Areas $41,306.00 $0.00 $41,306.00 840.001.11 Common Areas $34,626.00 $0.00 $34,626.00 Operating fund too high difference is $6,680.00 Cost too high difference is $6,680.00 840.006.05 Pool Monitor $18,059.00 $0.00 $18,059.00 840.006.05 Pool Monitor $25,787.00 $0.00 $25,787.00 Operating fund too low difference is $-7,728.00 Cost too low difference is $-7,728.00 860.000.06 Utilities $66,544.00 $0.00 $66,544.00 860.000.06 Utilities $57,327.00 $0.00 $57,327.00 Operating fund too high difference is $9,217.00 Cost too high difference is $9,217.00 880.000.01 Federal Income Tax $8,373.00 $0.00 $8,373.00 880.000.01 Federal Income Tax $4,996.00 $0.00 $4,996.00 Operating fund too high difference is $3,377.00 Cost too high difference is $3,377.00 900.000.03 Loss on sale of investment $8,102.00 $0.00 $8,102.00 Added Asset(s) Expense 900.000.04 Miscellaneous $10,843.00 $0.00 $10,843.00 900.000.04 Miscellaneous $11,950.00 $0.00 $11,950.00 Operating fund too low difference is $-1,107.00 Cost too low difference is $-1,107.00 920.000.07 Clubhouse Reserve $0.00 $22,728.00 $22,728.00 920.000.07 Clubhouse Reserve $146,369.00 $33,255.00 $179,644.00 Operating fund too low difference is $-146,369.00 Replacement fund too low difference is $-10,527.00 Cost too low difference is $-156,916.00 920.000.10 Pool/Spa $17,499.00 $3,716.00 $21,215.00 Added Asset(s) Expense 2005 - 2006 Analysis Summary Estimated inflation 3% Consumer Price Index 3.4% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2005 $426,606.00 $76,923.00 $503,529.00 Revenue 2006 $460,248.00 $81,475.00 $541,723.00 Expense 2005 $573,805.00 $33,255.00 $607,080.00 Expense 2006 $448,251.00 $71,104.00 $519,355.00 revenue - expense 2005 $-147,199.00 $43,668.00 $-103,551.00 revenue - expense 2006 $11,997.00 $10,371.00 $22,368.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $159,196.00 $-33,297.00 $125,919.00 percent difference -8.15% -76.25% -21.60% Total Assets 18 Total Issues 60 Issues/Asset 3.33 count % Description 2 11.11% Added Asset(s) 8 44.44% Operating fund too high 5 27.78% Operating fund too low 1 5.56% Replacement fund too high 1 5.56% Replacement fund too low 9 50.00% Cost too high 5 27.78% Cost too low Park Paseo Homeowners Association UnAudited Forensic Report For 2005 to 2006 Revenue 530.000.01 Late Fees & Interest $5,815.00 $0.00 $5,815.00 530.000.01 Late Fees & Interest $5,230.00 $0.00 $5,230.00 Operating fund too high difference is $585.00 Cost too high difference is $585.00 540.000.09 Other Charges to Owners $5,968.00 $0.00 $5,968.00 540.000.09 Other Charges to Owners $7,300.00 $0.00 $7,300.00 Operating fund too low difference is $-1,332.00 Cost too low difference is $-1,332.00 540.000.10 Other Income $16,967.00 $0.00 $16,967.00 540.000.10 Other Income $9,521.00 $0.00 $9,521.00 Operating fund too high difference is $7,446.00 Cost too high difference is $7,446.00 550.000.03 Investment Income $25,473.00 $0.00 $25,473.00 550.000.03 Investment Income $16,478.00 $0.00 $16,478.00 Operating fund too high difference is $8,995.00 Cost too high difference is $8,995.00 Expense 640.000.07 Office supplies/printing/postage $10,718.00 $0.00 $10,718.00 640.000.07 Office supplies/printing/postage $8,823.00 $0.00 $8,823.00 Operating fund too high difference is $1,895.00 Cost too high difference is $1,895.00 680.001.02 Newsletters/Mailouts/Extras $2,988.00 $0.00 $2,988.00 680.001.02 Newsletters/Mailouts/Extras $2,733.00 $0.00 $2,733.00 Operating fund too high difference is $255.00 Cost too high difference is $255.00 700.000.01 Insurance $17,685.00 $0.00 $17,685.00 700.000.01 Insurance $19,105.00 $0.00 $19,105.00 Operating fund too low difference is $-1,420.00 Cost too low difference is $-1,420.00 720.000.08 Landscape Expense $140,982.00 $44,660.00 $185,642.00 720.000.08 Landscape Expense $143,832.00 $0.00 $143,832.00 Replacement fund too high difference is $44,660.00 Cost too high difference is $41,810.00 840.001.11 Common Areas $41,306.00 $0.00 $41,306.00 840.001.11 Common Areas $34,626.00 $0.00 $34,626.00 Operating fund too high difference is $6,680.00 Cost too high difference is $6,680.00 840.006.05 Pool Monitor $18,059.00 $0.00 $18,059.00 840.006.05 Pool Monitor $25,787.00 $0.00 $25,787.00 Operating fund too low difference is $-7,728.00 Cost too low difference is $-7,728.00 860.000.06 Utilities $66,544.00 $0.00 $66,544.00 860.000.06 Utilities $57,327.00 $0.00 $57,327.00 Operating fund too high difference is $9,217.00 Cost too high difference is $9,217.00 880.000.01 Federal Income Tax $8,373.00 $0.00 $8,373.00 880.000.01 Federal Income Tax $4,996.00 $0.00 $4,996.00 Operating fund too high difference is $3,377.00 Cost too high difference is $3,377.00 900.000.03 Loss on sale of investment $8,102.00 $0.00 $8,102.00 Added Asset(s) Expense 900.000.04 Miscellaneous $10,843.00 $0.00 $10,843.00 900.000.04 Miscellaneous $11,950.00 $0.00 $11,950.00 Operating fund too low difference is $-1,107.00 Cost too low difference is $-1,107.00 920.000.07 Clubhouse Reserve $0.00 $22,728.00 $22,728.00 920.000.07 Clubhouse Reserve $146,369.00 $33,255.00 $179,644.00 Operating fund too low difference is $-146,369.00 Replacement fund too low difference is $-10,527.00 Cost too low difference is $-156,916.00 920.000.10 Pool/Spa $17,499.00 $3,716.00 $21,215.00 Added Asset(s) Expense 2005 - 2006 Analysis Summary Estimated inflation 3% Consumer Price Index 3.4% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2005 $426,606.00 $76,923.00 $503,529.00 Revenue 2006 $460,248.00 $81,475.00 $541,723.00 Expense 2005 $573,805.00 $33,255.00 $607,080.00 Expense 2006 $448,251.00 $71,104.00 $519,355.00 revenue - expense 2005 $-147,199.00 $43,668.00 $-103,551.00 revenue - expense 2006 $11,997.00 $10,371.00 $22,368.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $159,196.00 $-33,297.00 $125,919.00 percent difference -8.15% -76.25% -21.60% Total Assets 18 Total Issues 60 Issues/Asset 3.33 count % Description 2 11.11% Added Asset(s) 8 44.44% Operating fund too high 5 27.78% Operating fund too low 1 5.56% Replacement fund too high 1 5.56% Replacement fund too low 9 50.00% Cost too high 5 27.78% Cost too low Park Paseo Homeowners Association RDA Forensic Analysis For 2005 to 2006 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 005.000.01 Concrete - Repai Concrete - Repairs 8 10 $56,550.00 $11,310.00 $11,310.00 New Assets 010.000.01 Overlay/Rehab Overlay/Rehab 14 20 $5,257.00 $1,834.00 $0.00 010.000.01 Overlay/Rehab Overlay/Rehab 13 20 $5,414.00 $2,140.00 $0.00 Fully funded value too high should be $1,895.15 No assigned value 020.000.01 Prosa Cabana Prosa Cabana 0 25 $4,577.00 $4,577.00 $4,577.00 020.000.01 Prosa Cabana Prosa Cabana 3 25 $4,716.00 $4,274.00 $4,274.00 Maintenance deferred Remaining life increased 020.000.03 Clubhouse, Tile Clubhouse, Tile 90 99 $0.00 $0.00 $0.00 020.000.03 Clubhouse, Tile Clubhouse, Tile 5 5 $1,717.00 $0.00 $0.00 Asset changed to funded 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 0 15 $609.00 $609.00 $609.00 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 2 18 $918.00 $859.00 $859.00 Maintenance deferred Remaining life increased Cost value too high should be $627.27 Fully funded value too high should be $557.57 Assigned value too high should be $557.57 030.001.02 Interior Clubhou Interior Clubhouse 0 8 $1,933.00 $1,933.00 $1,933.00 030.001.02 Interior Clubhou Interior Clubhouse 0 8 $3,309.00 $3,309.00 $3,309.00 Maintenance deferred Cost value too high should be $1,990.99 Fully funded value too high should be $1,990.99 Assigned value too high should be $1,990.99 030.001.03 Interior Prosa R Interior Prosa Restrooms 0 8 $883.00 $883.00 $883.00 030.001.03 Interior Prosa R Interior Prosa Restrooms 0 8 $1,511.00 $1,511.00 $1,511.00 Maintenance deferred Cost value too high should be $909.49 Fully funded value too high should be $909.49 Assigned value too high should be $909.49 030.001.05 Spa Equipment Ro Spa Equipment Room 0 5 $1,980.00 $1,980.00 $1,980.00 030.001.05 Spa Equipment Ro Spa Equipment Room 1 5 $2,134.00 $1,806.00 $1,806.00 Maintenance deferred Remaining life increased Fully funded value too high should be $1,631.52 Assigned value too high should be $1,631.52 030.001.06 Stucco Stucco 71 99 $0.00 $0.00 $0.00 030.001.06 Stucco Stucco 1 10 $2,000.00 $1,810.00 $1,810.00 Asset changed to funded 030.001.07 Woodwork Prosa Woodwork Prosa 2 7 $2,337.00 $1,618.00 $1,618.00 030.001.07 Woodwork Prosa Woodwork Prosa 1 5 $2,491.00 $2,108.00 $2,108.00 Useful life decreased Fully funded value too high should be $1,925.69 Assigned value too high should be $1,925.69 030.002.01 Wrought Iron Cl Wrought Iron Clubhouse 2 3 $1,528.00 $345.00 $345.00 030.002.01 Wrought Iron Cl Wrought Iron Clubhouse 0 3 $4,141.00 $4,141.00 $4,141.00 Remaining life decreased too much Cost value too high should be $1,573.84 Fully funded value too high should be $1,573.84 Assigned value too high should be $1,573.84 030.002.03 Wrought Iron Pr Wrought Iron Prosa 1 3 $678.00 $452.00 $452.00 030.002.03 Wrought Iron Pr Wrought Iron Prosa 0 3 $1,839.00 $1,839.00 $1,839.00 Cost value too high should be $698.34 Fully funded value too high should be $698.34 Assigned value too high should be $698.34 030.002.04 Wrought Iron, St Wrought Iron, Streets 2 3 $700.00 $158.00 $158.00 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $632.00 $632.00 $632.00 Remaining life decreased too much Cost value too low should be $721.00 Fully funded value too low should be $721.00 Assigned value too low should be $721.00 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 1 6 $8,527.00 $6,976.00 $6,976.00 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 1 5 $9,089.00 $7,691.00 $7,691.00 Remaining life not changed Useful life decreased Fully funded value too high should be $7,026.25 Assigned value too high should be $7,026.25 040.000.08 Wrought Iron, Ma Wrought Iron, Main Pool 7 10 $30,338.00 $19,720.00 $19,720.00 040.000.08 Wrought Iron, Ma Wrought Iron, Main Pool 3 10 $60,111.00 $49,503.00 $49,503.00 Remaining life decreased too much Cost value too high should be $31,248.14 Fully funded value too high should be $21,873.70 Assigned value too high should be $21,873.70 040.000.09 Wrought Iron, Pr Wrought Iron, Prosa Pool 6 10 $14,598.00 $10,219.00 $10,219.00 040.000.09 Wrought Iron, Pr Wrought Iron, Prosa Pool 3 10 $17,420.00 $14,517.00 $14,517.00 Remaining life decreased too much Cost value too high should be $15,035.94 Fully funded value too high should be $10,525.16 Assigned value too high should be $10,525.16 040.000.10 Wrought Iron, St Wrought Iron, Streets 19 20 $2,780.00 $83.00 $0.00 040.000.10 Wrought Iron, St Wrought Iron, Streets 18 20 $2,864.00 $198.00 $0.00 Fully funded value too low should be $286.34 No assigned value 050.000.01 Exterior, Pool/C Exterior, Pool/Club 1 10 $9,644.00 $8,934.00 $8,934.00 050.000.01 Exterior, Pool/C Exterior, Pool/Club 3 10 $10,756.00 $8,810.00 $8,810.00 Remaining life increased Cost value too high should be $9,933.32 Fully funded value too high should be $6,953.32 Assigned value too high should be $6,953.32 050.000.03 Exterior, Parkin Exterior, Parking Lot 17 22 $1,070.00 $214.00 $0.00 050.000.03 Exterior, Parkin Exterior, Parking Lot 16 22 $1,102.00 $272.00 $0.00 Fully funded value too low should be $300.57 No assigned value 050.000.05 Exterior, Prosa Exterior, Prosa 1 10 $1,886.00 $1,747.00 $1,747.00 050.000.05 Exterior, Prosa Exterior, Prosa 3 10 $2,086.00 $1,709.00 $1,709.00 Remaining life increased Cost value too high should be $1,942.58 Fully funded value too high should be $1,359.81 Assigned value too high should be $1,359.81 050.000.07 Parking Lot, Ori Parking Lot, Original 2 22 $5,350.00 $4,993.00 $4,993.00 050.000.07 Parking Lot, Ori Parking Lot, Original 3 22 $5,510.00 $4,993.00 $4,993.00 Remaining life increased 050.000.08 Interior Prosa C Interior Prosa Cabana 1 20 $1,256.00 $1,204.00 $1,204.00 050.000.08 Interior Prosa C Interior Prosa Cabana 6 25 $1,334.00 $1,067.00 $1,067.00 Remaining life increased Useful life increased Fully funded value too high should be $983.20 Assigned value too high should be $983.20 050.000.10 Walkway, 1990 Walkway, 1990 0 15 $6,864.00 $6,864.00 $6,864.00 050.000.10 Walkway, 1990 Walkway, 1990 3 15 $7,260.00 $6,056.00 $6,056.00 Maintenance deferred Remaining life increased Fully funded value too high should be $5,655.94 Assigned value too high should be $5,655.94 050.001.01 Interior Clubhou Interior Clubhouse 0 25 $12,066.00 $12,066.00 $12,066.00 050.001.01 Interior Clubhou Interior Clubhouse 6 25 $11,997.00 $9,940.00 $9,940.00 Maintenance deferred Remaining life increased Fully funded value too high should be $9,445.26 Assigned value too high should be $9,445.26 060.001.01 Addition Addition 98 99 $0.00 $0.00 $0.00 Asset deleted 060.001.02 Billiard Tables Billiard Tables 0 25 $7,518.00 $7,518.00 $7,518.00 060.001.02 Billiard Tables Billiard Tables 4 25 $7,740.00 $6,802.00 $6,802.00 Maintenance deferred Remaining life increased 060.001.03 Carpet, 2005 Carpet, 2005 7 8 $4,311.00 $375.00 $375.00 New Assets 060.001.05 Ceramic Tile, Co Ceramic Tile, Counters 3 20 $2,288.00 $1,830.00 $1,830.00 Asset deleted 060.001.06 Ceramic Tile, Sh Ceramic Tile, Shower 2 20 $1,646.00 $1,537.00 $1,537.00 Asset deleted 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 6 15 $420.00 $252.00 $252.00 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 24 25 $14,133.00 $382.00 $0.00 Maintenance completed Useful life increased 060.001.10 Furnishings Furnishings 0 10 $25,000.00 $25,000.00 $25,000.00 060.001.10 Furnishings Furnishings 10 10 $30,000.00 $0.00 $0.00 Maintenance completed 060.001.13 HVAC Heat/Air, C HVAC Heat/Air, Clubhouse 0 18 $21,379.00 $21,379.00 $21,379.00 060.001.13 HVAC Heat/Air, C HVAC Heat/Air, Clubhouse 3 20 $21,940.00 $19,883.00 $19,883.00 Maintenance deferred Remaining life increased Fully funded value too high should be $18,717.31 Assigned value too high should be $18,717.31 060.001.14 Window Blinds Window Blinds 0 12 $6,462.00 $6,462.00 $6,462.00 060.001.14 Window Blinds Window Blinds 9 10 $12,100.00 $834.00 $834.00 Maintenance completed 060.001.15 Water Heater Water Heater 0 12 $4,304.00 $4,304.00 $4,304.00 060.001.15 Water Heater Water Heater 4 12 $2,769.00 $1,846.00 $1,846.00 Maintenance deferred Remaining life increased Cost value too low should be $4,433.12 Fully funded value too low should be $2,955.41 Assigned value too low should be $2,955.41 060.001.16 Wallpaper Wallpaper 0 15 $7,372.00 $7,372.00 $7,372.00 060.001.16 Wallpaper Wallpaper 14 15 $10,594.00 $462.00 $0.00 Maintenance completed 060.001.18 Carpeting Carpeting 0 8 $6,312.00 $6,312.00 $6,312.00 060.001.18 Carpeting Carpeting 0 8 $9,340.00 $9,340.00 $9,340.00 Maintenance deferred Cost value too high should be $6,501.36 Fully funded value too high should be $6,501.36 Assigned value too high should be $6,501.36 060.002.02 Doors, Exterior, Doors, Exterior, Entry 24 25 $10,000.00 $270.00 $0.00 New Assets 060.002.03 Doors, Entry Doors, Entry 6 25 $8,000.00 $6,629.00 $6,629.00 New Assets 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 6 25 $1,836.00 $1,521.00 $1,521.00 New Assets 060.002.08 Doors, Entry Int Doors, Entry Interior 9 25 $1,448.00 $927.00 $927.00 New Assets 060.003.01 Kitchen, Applian Kitchen, Appliances 11 12 $4,061.00 $232.00 $232.00 New Assets 060.003.02 Appliances, 1977 Appliances, 1977 0 15 $564.00 $564.00 $564.00 Asset deleted 060.003.03 Appliances, 1991 Appliances, 1991 1 15 $1,137.00 $1,061.00 $1,061.00 Asset deleted 060.003.04 Appliances, 1998 Appliances, 1998 8 15 $1,377.00 $630.00 $630.00 Asset deleted 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 0 20 $2,390.00 $2,390.00 $2,390.00 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 24 25 $18,800.00 $508.00 $0.00 Maintenance completed 060.003.08 Kitchen, Sink Kitchen, Sink 8 20 $768.00 $457.00 $457.00 060.003.08 Kitchen, Sink Kitchen, Sink 24 25 $600.00 $16.00 $0.00 Maintenance completed Useful life increased 060.004.01 Office, Computer Office, Computers/Equipment 0 5 $4,455.00 $4,455.00 $4,455.00 Asset deleted 060.004.03 Office, Copier Office, Copier 0 5 $2,381.00 $2,381.00 $2,381.00 Asset deleted 060.004.07 Office, Fax Mach Office, Fax Machine 0 6 $1,143.00 $1,143.00 $1,143.00 Asset deleted 060.004.08 Office, Furnishi Office, Furnishings 0 4 $2,614.00 $2,614.00 $2,614.00 Asset deleted 060.004.10 Office, Remodel Office, Remodel 0 20 $15,000.00 $15,000.00 $15,000.00 New Assets 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 5 20 $14,844.00 $11,070.00 $11,070.00 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 9 25 $15,285.00 $9,783.00 $9,783.00 Remaining life increased Useful life increased 060.005.03 Restroom, Counte Restroom, Counters 5 16 $944.00 $704.00 $704.00 060.005.03 Restroom, Counte Restroom, Counters 4 20 $960.00 $765.00 $765.00 Useful life increased 060.005.05 Restroom, Locker Restroom, Lockers 0 15 $4,393.00 $4,393.00 $4,393.00 060.005.05 Restroom, Locker Restroom, Lockers 6 22 $4,524.00 $3,290.00 $3,290.00 Maintenance deferred Remaining life increased 060.005.08 Restroom, Partit Restroom, Partitions 1 15 $3,190.00 $2,990.00 $2,990.00 060.005.08 Restroom, Partit Restroom, Partitions 4 20 $3,285.00 $2,625.00 $2,625.00 Remaining life increased Useful life increased 060.005.13 Restroom, Fixtur Restroom, Fixtures 10 25 $5,952.00 $3,539.00 $3,539.00 060.005.13 Restroom, Fixtur Restroom, Fixtures 9 25 $5,716.00 $3,658.00 $3,658.00 Cost value too low should be $6,130.56 Fully funded value too low should be $3,923.56 Assigned value too low should be $3,923.56 065.001.05 Pump Pump 0 8 $3,765.00 $3,765.00 $3,765.00 065.001.05 Pump Pump 7 8 $3,877.00 $485.00 $485.00 Maintenance completed 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 2 10 $40,524.00 $32,351.00 $32,351.00 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 5 14 $41,722.00 $26,732.00 $26,732.00 Remaining life increased Useful life increased 065.002.01 Spa, Filter Spa, Filter 0 10 $742.00 $742.00 $742.00 065.002.01 Spa, Filter Spa, Filter 2 10 $764.00 $665.00 $665.00 Maintenance deferred Remaining life increased Fully funded value too high should be $611.41 Assigned value too high should be $611.41 065.002.02 Spa, Heater Spa, Heater 4 10 $2,413.00 $1,609.00 $1,609.00 065.002.02 Spa, Heater Spa, Heater 3 10 $2,485.00 $1,864.00 $1,864.00 Fully funded value too high should be $1,739.77 Assigned value too high should be $1,739.77 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 2 10 $4,033.00 $3,220.00 $3,220.00 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 3 12 $4,154.00 $3,108.00 $3,108.00 Remaining life increased Useful life increased 065.003.01 Wader, Filter Wader, Filter 4 9 $582.00 $305.00 $305.00 065.003.01 Wader, Filter Wader, Filter 6 12 $599.00 $284.00 $284.00 Remaining life increased Useful life increased Fully funded value too low should be $299.73 Assigned value too low should be $299.73 065.003.02 Wader, Heater Wader, Heater 0 10 $1,659.00 $1,659.00 $1,659.00 065.003.02 Wader, Heater Wader, Heater 2 12 $1,708.00 $1,492.00 $1,492.00 Maintenance deferred Remaining life increased 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 4 12 $3,529.00 $2,344.00 $2,344.00 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 5 14 $3,635.00 $2,329.00 $2,329.00 Remaining life increased Useful life increased 067.001.03 Barbecues Barbecues 11 14 $6,204.00 $1,211.00 $1,211.00 067.001.03 Barbecues Barbecues 10 14 $6,390.00 $1,714.00 $1,714.00 Fully funded value too low should be $1,825.75 Assigned value too low should be $1,825.75 067.001.04 Barbecues, Main, Barbecues, Main, 1994 0 10 $585.00 $585.00 $585.00 067.001.04 Barbecues, Main, Barbecues, Main, 1994 2 10 $602.00 $512.00 $512.00 Maintenance deferred Remaining life increased Fully funded value too high should be $482.04 Assigned value too high should be $482.04 067.001.05 Ceramic Shower Ceramic Shower 6 25 $1,695.00 $1,405.00 $1,405.00 New Assets 067.001.06 Diving Board, Ma Diving Board, Main 5 18 $1,627.00 $1,028.00 $1,028.00 Asset deleted 067.002.02 Deck Caulking Deck Caulking 2 4 $5,180.00 $2,590.00 $2,590.00 067.002.02 Deck Caulking Deck Caulking 1 4 $7,368.00 $5,526.00 $5,526.00 Cost value too high should be $5,335.40 Fully funded value too high should be $4,001.55 Assigned value too high should be $4,001.55 067.003.01 Furniture Furniture 0 7 $23,718.00 $23,718.00 $23,718.00 067.003.01 Furniture Furniture 2 7 $24,277.00 $17,341.00 $17,341.00 Maintenance deferred Remaining life increased 069.001.01 Filter, Prosa Filter, Prosa 1 12 $742.00 $685.00 $685.00 069.001.01 Filter, Prosa Filter, Prosa 2 12 $764.00 $662.00 $662.00 Remaining life increased 069.001.04 Heater, Prosa Heater, Prosa 1 12 $2,413.00 $2,252.00 $2,252.00 069.001.04 Heater, Prosa Heater, Prosa 2 12 $2,485.00 $2,193.00 $2,193.00 Remaining life increased Fully funded value too high should be $2,071.16 Assigned value too high should be $2,071.16 069.001.05 Motor Motor 0 8 $609.00 $609.00 $609.00 069.001.05 Motor Motor 0 8 $627.00 $627.00 $627.00 Maintenance deferred 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 3 10 $22,429.00 $15,644.00 $15,644.00 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 6 14 $23,102.00 $13,142.00 $13,142.00 Remaining life increased Useful life increased 070.001.02 Barbecues Barbecues 0 10 $1,170.00 $1,170.00 $1,170.00 070.001.02 Barbecues Barbecues 2 10 $1,204.00 $1,095.00 $1,095.00 Maintenance deferred Remaining life increased Fully funded value too high should be $964.08 Assigned value too high should be $964.08 070.001.05 Furniture Furniture 0 7 $5,740.00 $5,740.00 $5,740.00 070.001.05 Furniture Furniture 2 7 $5,876.00 $4,197.00 $4,197.00 Maintenance deferred Remaining life increased 070.001.06 Plumbing Fixture Plumbing Fixtures 2 25 $4,662.00 $4,289.00 $4,289.00 070.001.06 Plumbing Fixture Plumbing Fixtures 3 25 $4,388.00 $3,900.00 $3,900.00 Remaining life increased Cost value too low should be $4,801.86 Fully funded value too low should be $4,225.64 Assigned value too low should be $4,225.64 070.001.07 Repairs Repairs 1 15 $2,402.00 $2,302.00 $2,302.00 070.001.07 Repairs Repairs 6 20 $2,473.00 $1,978.00 $1,978.00 Remaining life increased Useful life increased Fully funded value too high should be $1,731.84 Assigned value too high should be $1,731.84 070.002.01 Ceramic Shower Ceramic Shower 2 25 $5,440.00 $5,005.00 $5,005.00 070.002.01 Ceramic Shower Ceramic Shower 6 25 $5,602.00 $4,482.00 $4,482.00 Remaining life increased Fully funded value too high should be $4,258.43 Assigned value too high should be $4,258.43 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 4 25 $6,997.00 $5,960.00 $5,960.00 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 6 25 $7,205.00 $5,764.00 $5,764.00 Remaining life increased Fully funded value too high should be $5,477.25 Assigned value too high should be $5,477.25 070.004.01 Water Heater Water Heater 5 18 $2,769.00 $2,292.00 $2,292.00 New Assets 070.004.02 Water Heater Pro Water Heater Prosa 0 10 $4,304.00 $4,304.00 $4,304.00 Asset deleted 070.005.01 Restroom, Counte Restroom, Counters 1 20 $826.00 $792.00 $792.00 070.005.01 Restroom, Counte Restroom, Counters 3 20 $850.00 $756.00 $756.00 Remaining life increased 080.000.01 Benches Benches 0 15 $2,895.00 $2,895.00 $2,895.00 080.000.01 Benches Benches 2 15 $4,768.00 $4,291.00 $4,291.00 Maintenance deferred Remaining life increased Cost value too high should be $2,981.85 Fully funded value too high should be $2,584.27 Assigned value too high should be $2,584.27 080.000.02 Chain Link Fenci Chain Link Fencing 2 25 $14,557.00 $13,587.00 $13,587.00 080.000.02 Chain Link Fenci Chain Link Fencing 8 25 $14,993.00 $11,751.00 $11,751.00 Remaining life increased Fully funded value too high should be $10,195.72 Assigned value too high should be $10,195.72 080.000.03 Concrete, Replac Concrete, Replacement 9 10 $61,800.00 $6,180.00 $6,180.00 Asset deleted 080.000.05 Lighting Lighting 4 25 $10,384.00 $9,086.00 $9,086.00 080.000.05 Lighting Lighting 8 25 $10,688.00 $8,377.00 $8,377.00 Remaining life increased Fully funded value too high should be $7,272.95 Assigned value too high should be $7,272.95 080.000.06 Resurfacing Resurfacing 5 6 $9,216.00 $1,536.00 $1,536.00 080.000.06 Resurfacing Resurfacing 6 8 $9,504.00 $1,901.00 $1,901.00 Remaining life increased Useful life increased Fully funded value too low should be $2,373.12 Assigned value too low should be $2,373.12 080.000.07 Windscreen Windscreen 0 6 $2,531.00 $2,531.00 $2,531.00 080.000.07 Windscreen Windscreen 1 6 $2,570.00 $2,297.00 $2,297.00 Maintenance deferred Remaining life increased Fully funded value too high should be $2,172.44 Assigned value too high should be $2,172.44 085.002.01 Drinking Fountai Drinking Fountain, C/H 0 12 $2,308.00 $2,308.00 $2,308.00 085.002.01 Drinking Fountai Drinking Fountain, C/H 3 16 $2,308.00 $2,052.00 $2,052.00 Maintenance deferred Remaining life increased Cost not changed 085.002.02 Drinking Fntns, Drinking Fntns, Concrete 5 30 $4,745.00 $4,026.00 $4,026.00 085.002.02 Drinking Fntns, Drinking Fntns, Concrete 1 30 $4,875.00 $4,713.00 $4,713.00 Remaining life decreased too much 085.003.01 Play Equipment, Play Equipment, Alba 14 20 $16,709.00 $5,013.00 $0.00 085.003.01 Play Equipment, Play Equipment, Alba 13 20 $17,210.00 $6,024.00 $0.00 No assigned value 085.003.03 Sand Repl, Prosa Sand Repl, Prosa/Alba 0 10 $2,801.00 $2,801.00 $2,801.00 085.003.03 Sand Repl, Prosa Sand Repl, Prosa/Alba 1 10 $2,885.00 $2,711.00 $2,711.00 Maintenance deferred Remaining life increased 085.004.01 Play Equip, Main Play Equip, Main, Prosa 12 20 $37,999.00 $14,615.00 $10,833.00 085.004.01 Play Equip, Main Play Equip, Main, Prosa 11 20 $39,138.00 $17,060.00 $15,131.00 Assigned value too low should be $17,612.54 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $2,481.00 $2,481.00 $2,481.00 085.004.04 Sand Repl, Main Sand Repl, Main 1 10 $2,555.00 $2,401.00 $2,401.00 Maintenance deferred Remaining life increased 090.000.04 Trellis, Wood, P Trellis, Wood, Patio Cover 13 15 $10,000.00 $1,333.00 $0.00 Asset deleted 090.000.05 Trellis, Wood, R Trellis, Wood, Repairs 1 30 $15,000.00 $14,500.00 $14,500.00 New Assets 095.002.05 Tree Trimming Tree Trimming 1 3 $25,536.00 $16,250.00 $16,250.00 095.002.05 Tree Trimming Tree Trimming 0 1 $4,000.00 $4,000.00 $4,000.00 Useful life decreased Cost value too low should be $26,302.08 Fully funded value too low should be $26,302.08 Assigned value too low should be $26,302.08 095.002.06 Tree Trimming, W Tree Trimming, Windrow 0 3 $27,000.00 $27,000.00 $27,000.00 New Assets 097.000.01 Backflow Devices Backflow Devices 3 24 $8,400.00 $7,613.00 $7,613.00 New Assets 097.000.02 Irrigation, Cont Irrigation, Controllers 1 12 $29,160.00 $26,917.00 $26,917.00 097.000.02 Irrigation, Cont Irrigation, Controllers 3 12 $34,704.00 $28,197.00 $28,197.00 Remaining life increased Cost value too high should be $30,034.80 Fully funded value too high should be $22,526.10 Assigned value too high should be $22,526.10 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 25 $9,100.00 $9,100.00 $9,100.00 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 3 24 $13,923.00 $12,618.00 $12,618.00 Maintenance deferred Remaining life increased Cost value too high should be $9,373.00 Fully funded value too high should be $8,201.38 Assigned value too high should be $8,201.38 100.000.01 Bulletin Board Bulletin Board 1 10 $820.00 $747.00 $747.00 100.000.01 Bulletin Board Bulletin Board 3 12 $844.00 $666.00 $666.00 Remaining life increased Useful life increased Fully funded value too high should be $633.45 Assigned value too high should be $633.45 100.000.02 Monument Monument 5 30 $3,182.00 $2,700.00 $2,700.00 100.000.02 Monument Monument 1 30 $3,300.00 $3,190.00 $3,190.00 Remaining life decreased too much 105.000.01 Termite Control/ Termite Control/Fumigation 5 15 $4,000.00 $2,667.00 $2,667.00 New Assets 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 5 12 $5,000.00 $3,684.00 $3,684.00 Maintenance deferred Remaining life increased Cost value too high should be $2,060.00 Fully funded value too high should be $1,201.67 Assigned value too high should be $1,201.67 2005 - 2006 RDA Forensic Analysis Summary Estimated inflation 3% Consumer Price Index 3.4% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $683,256.00 $476,952.00 $464,693.00 This Year Costs $843,830.00 $522,240.00 $510,039.00 Calculated Costs $811,886.29 $532,432.71 $532,432.71 Comparing This Year Costs to Last Year Costs Difference $160,574.00 $45,288.00 $45,346.00 percent difference 23.50% 9.50% 9.76% exceeds CC&R limits Comparing This Year Costs to Calculated Costs Difference $31,943.71 $-10,192.71 $-22,393.71 percent difference 3.79% -1.95% -4.39% 104 Total Assets 116 Total Issues $72,706.98 Unfunded Liability 1.12 Issues / Asset number % Description 14 13.46% New Assets 4 3.85% No assigned value 15 14.42% Cost value too high 5 4.81% Cost value too low 35 33.65% Fully funded value too high 10 9.62% Fully funded value too low 34 32.69% Assigned value too high 9 8.65% Assigned value too low 14 13.46% Asset deleted 1 0.96% Remaining life not changed 45 43.27% Remaining life increased 6 5.77% Remaining life decreased too much 2 1.92% Asset changed to funded 14 13.46% Useful life increased 3 2.88% Useful life decreased 26 25.00% Maintenance deferred 7 6.73% Maintenance completed 31 29.81% Total assets to be maintained 1 0.96% Cost not changed