Park Paseo Homeowners Association Audited Forensic Report For 2008 to 2009 Revenue 505.000.01 Homeowners Association Fees $415,220.00 $154,780.00 $570,000.00 505.000.01 Homeowners Association Fees $410,509.00 $114,491.00 $525,000.00 Replacement fund too high difference is $40,289.00 530.000.01 Late Fees & Interest $4,390.00 $0.00 $4,390.00 530.000.01 Late Fees & Interest $4,570.00 $0.00 $4,570.00 Operating fund too low difference is $-180.00 Cost too low difference is $-180.00 540.000.09 Other Charges to Owners $21,119.00 $0.00 $21,119.00 540.000.09 Other Charges to Owners $9,973.00 $0.00 $9,973.00 Operating fund too high difference is $11,146.00 Cost too high difference is $11,146.00 550.000.03 Investment Income $6,958.00 $0.00 $6,958.00 550.000.03 Investment Income $25,284.00 $0.00 $25,284.00 Operating fund too low difference is $-18,326.00 Cost too low difference is $-18,326.00 Expense 640.000.07 Office supplies/printing/postage $2,814.00 $0.00 $2,814.00 640.000.07 Office supplies/printing/postage $9,842.00 $0.00 $9,842.00 Operating fund too low difference is $-7,028.00 Cost too low difference is $-7,028.00 680.001.02 Newsletters/Mailouts/Extras $250.00 $0.00 $250.00 680.001.02 Newsletters/Mailouts/Extras $4,223.00 $0.00 $4,223.00 Operating fund too low difference is $-3,973.00 Cost too low difference is $-3,973.00 700.000.01 Insurance $17,249.00 $0.00 $17,249.00 700.000.01 Insurance $18,109.00 $0.00 $18,109.00 Operating fund too low difference is $-860.00 Cost too low difference is $-860.00 760.000.02 Legal Services $27,727.00 $0.00 $27,727.00 760.000.02 Legal Services $10,626.00 $0.00 $10,626.00 Operating fund too high difference is $17,101.00 Cost too high difference is $17,101.00 780.000.01 Property Protection - Patrol Service $41,178.00 $0.00 $41,178.00 780.000.01 Property Protection - Patrol Service $50,534.00 $0.00 $50,534.00 Operating fund too low difference is $-9,356.00 Cost too low difference is $-9,356.00 840.001.11 Common Areas $29,022.00 $82,577.00 $111,599.00 840.001.11 Common Areas $30,315.00 $1,000.00 $31,315.00 Operating fund too low difference is $-1,293.00 Replacement fund too high difference is $81,577.00 Cost too high difference is $80,284.00 840.006.05 Pool Monitor $14,486.00 $0.00 $14,486.00 840.006.05 Pool Monitor $15,176.00 $0.00 $15,176.00 Operating fund too low difference is $-690.00 Cost too low difference is $-690.00 860.000.04 Trash and Recycling Service $75,799.00 $0.00 $75,799.00 860.000.04 Trash and Recycling Service $65,029.00 $0.00 $65,029.00 Operating fund too high difference is $10,770.00 Cost too high difference is $10,770.00 860.000.06 Utilities $62,595.00 $0.00 $62,595.00 860.000.06 Utilities $72,775.00 $0.00 $72,775.00 Operating fund too low difference is $-10,180.00 Cost too low difference is $-10,180.00 880.000.01 Federal Income Tax $1,362.00 $0.00 $1,362.00 880.000.01 Federal Income Tax $7,414.00 $0.00 $7,414.00 Operating fund too low difference is $-6,052.00 Cost too low difference is $-6,052.00 900.000.04 Miscellaneous $6,182.00 $14,221.00 $20,403.00 900.000.04 Miscellaneous $17,544.00 $0.00 $17,544.00 Operating fund too low difference is $-11,362.00 Replacement fund too high difference is $14,221.00 Cost too high difference is $2,859.00 900.000.05 Bad debt expense $13,850.00 $0.00 $13,850.00 Added Asset(s) Expense 920.000.07 Clubhouse Reserve $0.00 $114,927.00 $114,927.00 Deleted Asset(s) Expense 2008 - 2009 Analysis Summary Estimated inflation 3.5% Consumer Price Index 3.8% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2008 $450,336.00 $114,491.00 $564,827.00 Revenue 2009 $447,687.00 $154,780.00 $602,467.00 Expense 2008 $456,767.00 $115,927.00 $572,694.00 Expense 2009 $419,657.00 $96,798.00 $516,455.00 revenue - expense 2008 $-6,431.00 $-1,436.00 $-7,867.00 revenue - expense 2009 $28,030.00 $57,982.00 $86,012.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $34,461.00 $59,418.00 $93,879.00 percent difference -435.86% -4037.74% -1093.33% Total Assets 16 Total Issues 64 Issues/Asset 4.00 count % Description 1 6.25% Added Asset(s) 1 6.25% Deleted Asset(s) 3 18.75% Operating fund too high 11 68.75% Operating fund too low 3 18.75% Replacement fund too high 5 31.25% Cost too high 9 56.25% Cost too low Park Paseo Homeowners Association UnAudited Forensic Report For 2008 to 2009 Revenue 505.000.01 Homeowners Association Fees $415,220.00 $154,780.00 $570,000.00 505.000.01 Homeowners Association Fees $410,509.00 $114,491.00 $525,000.00 Replacement fund too high difference is $40,289.00 530.000.01 Late Fees & Interest $4,390.00 $0.00 $4,390.00 530.000.01 Late Fees & Interest $4,570.00 $0.00 $4,570.00 Operating fund too low difference is $-180.00 Cost too low difference is $-180.00 540.000.09 Other Charges to Owners $21,119.00 $0.00 $21,119.00 540.000.09 Other Charges to Owners $9,973.00 $0.00 $9,973.00 Operating fund too high difference is $11,146.00 Cost too high difference is $11,146.00 550.000.03 Investment Income $6,958.00 $0.00 $6,958.00 550.000.03 Investment Income $25,284.00 $0.00 $25,284.00 Operating fund too low difference is $-18,326.00 Cost too low difference is $-18,326.00 Expense 640.000.07 Office supplies/printing/postage $2,814.00 $0.00 $2,814.00 640.000.07 Office supplies/printing/postage $9,842.00 $0.00 $9,842.00 Operating fund too low difference is $-7,028.00 Cost too low difference is $-7,028.00 680.001.02 Newsletters/Mailouts/Extras $250.00 $0.00 $250.00 680.001.02 Newsletters/Mailouts/Extras $4,223.00 $0.00 $4,223.00 Operating fund too low difference is $-3,973.00 Cost too low difference is $-3,973.00 700.000.01 Insurance $17,249.00 $0.00 $17,249.00 700.000.01 Insurance $18,109.00 $0.00 $18,109.00 Operating fund too low difference is $-860.00 Cost too low difference is $-860.00 760.000.02 Legal Services $27,727.00 $0.00 $27,727.00 760.000.02 Legal Services $10,626.00 $0.00 $10,626.00 Operating fund too high difference is $17,101.00 Cost too high difference is $17,101.00 780.000.01 Property Protection - Patrol Service $41,178.00 $0.00 $41,178.00 780.000.01 Property Protection - Patrol Service $50,534.00 $0.00 $50,534.00 Operating fund too low difference is $-9,356.00 Cost too low difference is $-9,356.00 840.001.11 Common Areas $29,022.00 $82,577.00 $111,599.00 840.001.11 Common Areas $30,315.00 $1,000.00 $31,315.00 Operating fund too low difference is $-1,293.00 Replacement fund too high difference is $81,577.00 Cost too high difference is $80,284.00 840.006.05 Pool Monitor $14,486.00 $0.00 $14,486.00 840.006.05 Pool Monitor $15,176.00 $0.00 $15,176.00 Operating fund too low difference is $-690.00 Cost too low difference is $-690.00 860.000.04 Trash and Recycling Service $75,799.00 $0.00 $75,799.00 860.000.04 Trash and Recycling Service $65,029.00 $0.00 $65,029.00 Operating fund too high difference is $10,770.00 Cost too high difference is $10,770.00 860.000.06 Utilities $62,595.00 $0.00 $62,595.00 860.000.06 Utilities $72,775.00 $0.00 $72,775.00 Operating fund too low difference is $-10,180.00 Cost too low difference is $-10,180.00 880.000.01 Federal Income Tax $1,362.00 $0.00 $1,362.00 880.000.01 Federal Income Tax $7,414.00 $0.00 $7,414.00 Operating fund too low difference is $-6,052.00 Cost too low difference is $-6,052.00 900.000.04 Miscellaneous $6,182.00 $14,221.00 $20,403.00 900.000.04 Miscellaneous $17,544.00 $0.00 $17,544.00 Operating fund too low difference is $-11,362.00 Replacement fund too high difference is $14,221.00 Cost too high difference is $2,859.00 900.000.05 Bad debt expense $13,850.00 $0.00 $13,850.00 Added Asset(s) Expense 920.000.07 Clubhouse Reserve $0.00 $114,927.00 $114,927.00 Deleted Asset(s) Expense 2008 - 2009 Analysis Summary Estimated inflation 3.5% Consumer Price Index 3.8% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2008 $450,336.00 $114,491.00 $564,827.00 Revenue 2009 $447,687.00 $154,780.00 $602,467.00 Expense 2008 $456,767.00 $115,927.00 $572,694.00 Expense 2009 $419,657.00 $96,798.00 $516,455.00 revenue - expense 2008 $-6,431.00 $-1,436.00 $-7,867.00 revenue - expense 2009 $28,030.00 $57,982.00 $86,012.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $34,461.00 $59,418.00 $93,879.00 percent difference -435.86% -4037.74% -1093.33% Total Assets 16 Total Issues 64 Issues/Asset 4.00 count % Description 1 6.25% Added Asset(s) 1 6.25% Deleted Asset(s) 3 18.75% Operating fund too high 11 68.75% Operating fund too low 3 18.75% Replacement fund too high 5 31.25% Cost too high 9 56.25% Cost too low Park Paseo Homeowners Association RDA Forensic Analysis For 2008 to 2009 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 005.000.01 Concrete - Repai Concrete - Repairs 6 10 $56,550.00 $22,620.00 $22,620.00 005.000.01 Concrete - Repai Concrete - Repairs 0 1 $5,000.00 $5,000.00 $5,000.00 Remaining life decreased too much Useful life decreased Cost value too low should be $58,529.25 Fully funded value too low should be $58,529.25 Assigned value too low should be $58,529.25 010.000.01 Overlay/Rehab Overlay/Rehab 12 20 $5,885.00 $2,746.00 $0.00 010.000.01 Overlay/Rehab Overlay/Rehab 8 20 $10,435.00 $6,154.00 $0.00 Remaining life decreased too much Cost value too high should be $6,090.97 Fully funded value too high should be $3,654.58 No assigned value 010.000.03 Asphalt Repairs Asphalt Repairs 0 4 $1,844.00 $1,844.00 $1,844.00 010.000.03 Asphalt Repairs Asphalt Repairs 0 4 $3,923.00 $3,923.00 $3,923.00 Maintenance deferred Cost value too high should be $1,908.54 Fully funded value too high should be $1,908.54 Assigned value too high should be $1,908.54 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 0 4 $2,040.00 $2,040.00 $2,040.00 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 0 4 $2,118.00 $2,118.00 $2,118.00 Maintenance deferred 020.000.03 Clubhouse, Tile Clubhouse, Tile 3 5 $3,750.00 $1,500.00 $1,500.00 020.000.03 Clubhouse, Tile Clubhouse, Tile 37 50 $23,090.00 $5,975.00 $0.00 Remaining life increased Useful life increased Cost value too high should be $3,881.25 Fully funded value too high should be $1,009.12 No assigned value 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 0 18 $1,105.00 $1,105.00 $1,105.00 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 0 18 $1,136.00 $1,136.00 $1,136.00 Maintenance deferred 030.001.02 Interior Clubhou Interior Clubhouse 0 8 $3,669.00 $3,669.00 $3,669.00 030.001.02 Interior Clubhou Interior Clubhouse 8 8 $3,767.00 $0.00 $0.00 Maintenance completed 030.001.03 Interior Prosa R Interior Prosa Restrooms 0 8 $1,676.00 $1,676.00 $1,676.00 030.001.03 Interior Prosa R Interior Prosa Restrooms 0 8 $1,720.00 $1,720.00 $1,720.00 Maintenance deferred 030.001.05 Spa Equipment Ro Spa Equipment Room 0 5 $2,266.00 $2,266.00 $2,266.00 030.001.05 Spa Equipment Ro Spa Equipment Room 0 5 $2,332.00 $2,332.00 $2,332.00 Maintenance deferred 030.001.06 Stucco Stucco 0 10 $2,000.00 $2,000.00 $2,000.00 030.001.06 Stucco Stucco 1 10 $2,500.00 $2,315.00 $2,315.00 Maintenance deferred Remaining life increased Cost value too high should be $2,070.00 Fully funded value too high should be $1,863.00 Assigned value too high should be $1,863.00 030.001.07 Woodwork Prosa Woodwork Prosa 0 5 $2,645.00 $2,645.00 $2,645.00 030.001.07 Woodwork Prosa Woodwork Prosa 0 5 $2,748.00 $2,748.00 $2,748.00 Maintenance deferred 030.002.01 Wrought Iron Cl Wrought Iron Clubhouse 0 3 $4,985.00 $4,985.00 $4,985.00 Asset deleted 030.002.02 Wrought Iron Po Wrought Iron Pools Unfunded 10 10 $0.00 $0.00 $0.00 New Assets 030.002.03 Wrought Iron Pr Wrought Iron Prosa 0 3 $2,213.00 $2,213.00 $2,213.00 Asset deleted 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $761.00 $761.00 $761.00 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $872.00 $872.00 $872.00 Maintenance deferred Cost value too high should be $787.63 Fully funded value too high should be $787.63 Assigned value too high should be $787.63 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 0 5 $9,651.00 $9,651.00 $9,651.00 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 1 5 $10,026.00 $8,971.00 $8,971.00 Maintenance deferred Remaining life increased Fully funded value too high should be $7,991.03 Assigned value too high should be $7,991.03 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 0 25 $5,000.00 $5,000.00 $5,000.00 New Assets 040.000.08 Wrought Iron, Ma Wrought Iron, Main Pool 1 10 $64,029.00 $60,263.00 $60,263.00 040.000.08 Wrought Iron, Ma Wrought Iron, Main Pool 0 25 $95,000.00 $95,000.00 $95,000.00 Useful life increased Cost value too high should be $66,270.01 Fully funded value too high should be $66,270.01 Assigned value too high should be $66,270.01 040.000.09 Wrought Iron, Pr Wrought Iron, Prosa Pool 1 10 $30,010.00 $28,343.00 $28,343.00 040.000.09 Wrought Iron, Pr Wrought Iron, Prosa Pool 25 25 $35,000.00 $0.00 $0.00 Maintenance completed Useful life increased 040.000.10 Wrought Iron, St Wrought Iron, Streets 16 20 $3,067.00 $529.00 $0.00 040.000.10 Wrought Iron, St Wrought Iron, Streets 15 20 $3,173.00 $711.00 $0.00 Fully funded value too low should be $793.59 No assigned value 050.000.01 Exterior, Pool/C Exterior, Pool/Club 1 10 $11,522.00 $10,827.00 $10,827.00 050.000.01 Exterior, Pool/C Exterior, Pool/Club 2 10 $11,884.00 $10,605.00 $10,605.00 Remaining life increased Fully funded value too high should be $9,540.22 Assigned value too high should be $9,540.22 050.000.03 Exterior, Parkin Exterior, Parking Lot 14 22 $1,179.00 $402.00 $0.00 050.000.03 Exterior, Parkin Exterior, Parking Lot 13 22 $1,220.00 $474.00 $0.00 Fully funded value too low should be $499.20 No assigned value 050.000.05 Exterior, Prosa Exterior, Prosa 1 10 $2,232.00 $2,097.00 $2,097.00 050.000.05 Exterior, Prosa Exterior, Prosa 2 10 $2,300.00 $2,052.00 $2,052.00 Remaining life increased Fully funded value too high should be $1,848.10 Assigned value too high should be $1,848.10 050.000.07 Parking Lot, Ori Parking Lot, Original 1 22 $5,895.00 $5,711.00 $5,711.00 050.000.07 Parking Lot, Ori Parking Lot, Original 2 22 $6,100.00 $5,741.00 $5,741.00 Remaining life increased 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 4 15 $49,725.00 $40,718.00 $0.00 New Assets 050.000.10 Walkway, 1990 Walkway, 1990 1 15 $7,744.00 $7,316.00 $7,316.00 Asset deleted 050.000.11 Walkway, Prosa 1 Walkway, Prosa 1997 4 15 $4,552.00 $3,303.00 $3,303.00 Asset deleted 050.001.01 Interior Clubhou Interior Clubhouse 4 25 $12,850.00 $11,381.00 $11,381.00 050.001.01 Interior Clubhou Interior Clubhouse 6 25 $13,245.00 $11,154.00 $0.00 Remaining life increased Fully funded value too high should be $10,107.81 No assigned value 060.001.02 Billiard Tables Billiard Tables 2 25 $8,234.00 $7,735.00 $7,735.00 060.001.02 Billiard Tables Billiard Tables 3 25 $8,496.00 $7,768.00 $7,768.00 Remaining life increased 060.001.03 Carpet, 2005 Carpet, 2005 5 8 $4,617.00 $1,606.00 $1,606.00 060.001.03 Carpet, 2005 Carpet, 2005 4 8 $4,779.00 $2,285.00 $0.00 No assigned value 060.001.08 Exterior Stairca Exterior Staircase 28 30 $15,218.00 $774.00 $0.00 060.001.08 Exterior Stairca Exterior Staircase 27 30 $15,750.00 $1,335.00 $0.00 Fully funded value too low should be $1,575.06 No assigned value 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 22 25 $15,138.00 $1,637.00 $0.00 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 21 25 $15,667.00 $2,329.00 $0.00 Fully funded value too low should be $2,506.85 No assigned value 060.001.10 Furnishings Furnishings 8 10 $30,000.00 $6,000.00 $0.00 060.001.10 Furnishings Furnishings 7 10 $30,000.00 $9,000.00 $0.00 Cost not changed 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 19 20 $3,000.00 $150.00 $0.00 New Assets 060.001.14 Window Blinds Window Blinds 7 10 $12,961.00 $3,575.00 $0.00 060.001.14 Window Blinds Window Blinds 6 10 $13,414.00 $5,088.00 $0.00 Fully funded value too low should be $5,365.85 No assigned value 060.001.15 Water Heater Water Heater 2 12 $2,914.00 $2,428.00 $2,428.00 060.001.15 Water Heater Water Heater 2 12 $3,007.00 $2,544.00 $2,544.00 Remaining life not changed 060.001.16 Wallpaper Wallpaper 12 15 $11,306.00 $2,056.00 $0.00 060.001.16 Wallpaper Wallpaper 11 15 $11,678.00 $2,919.00 $0.00 Fully funded value too low should be $3,120.46 No assigned value 060.001.18 Carpeting Carpeting 2 8 $10,004.00 $9,234.00 $9,234.00 060.001.18 Carpeting Carpeting 3 8 $10,353.00 $9,243.00 $9,243.00 Remaining life increased Fully funded value too high should be $6,471.34 Assigned value too high should be $6,471.34 060.002.02 Doors, Exterior, Doors, Exterior, Entry 22 25 $10,712.00 $1,158.00 $0.00 060.002.02 Doors, Exterior, Doors, Exterior, Entry 21 25 $11,086.00 $1,648.00 $0.00 Fully funded value too low should be $1,773.91 No assigned value 060.002.03 Doors, Entry Doors, Entry 4 25 $8,500.00 $7,529.00 $7,529.00 060.002.03 Doors, Entry Doors, Entry 0 25 $8,772.00 $8,772.00 $8,772.00 Remaining life decreased too much 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 4 25 $1,960.00 $1,736.00 $1,736.00 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 6 25 $2,020.00 $1,701.00 $0.00 Remaining life increased Fully funded value too high should be $1,541.74 No assigned value 060.002.08 Doors, Entry Int Doors, Entry Interior 7 25 $1,542.00 $1,110.00 $1,110.00 060.002.08 Doors, Entry Int Doors, Entry Interior 6 25 $1,593.00 $1,211.00 $0.00 No assigned value 060.003.01 Kitchen, Applian Kitchen, Appliances 9 12 $4,350.00 $994.00 $0.00 060.003.01 Kitchen, Applian Kitchen, Appliances 8 12 $4,502.00 $1,415.00 $0.00 Fully funded value too low should be $1,500.75 No assigned value 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 22 25 $20,139.00 $2,177.00 $0.00 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 21 25 $20,843.00 $3,098.00 $0.00 Fully funded value too low should be $3,335.02 No assigned value 060.003.08 Kitchen, Sink Kitchen, Sink 22 25 $642.00 $69.00 $0.00 060.003.08 Kitchen, Sink Kitchen, Sink 21 25 $664.00 $99.00 $0.00 Fully funded value too low should be $106.32 No assigned value 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 6 8 $10,000.00 $2,340.00 $0.00 New Assets 060.004.10 Office, Remodel Office, Remodel 19 20 $10,596.00 $445.00 $0.00 060.004.10 Office, Remodel Office, Remodel 18 20 $10,966.00 $1,014.00 $0.00 Fully funded value too low should be $1,096.69 No assigned value 060.005.01 Restroom Restroom 25 25 $0.00 $0.00 $0.00 New Assets 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 7 25 $16,036.00 $11,546.00 $3,784.00 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 25 25 $16,712.00 $0.00 $0.00 Maintenance completed 060.005.03 Restroom, Counte Restroom, Counters 2 20 $1,048.00 $942.00 $942.00 060.005.03 Restroom, Counte Restroom, Counters 20 20 $1,072.00 $0.00 $0.00 Maintenance completed 060.005.05 Restroom, Locker Restroom, Lockers 4 22 $4,802.00 $3,929.00 $3,929.00 Asset deleted 060.005.07 Restroom, Locker Restroom, Lockers/Benches 22 22 $20,000.00 $0.00 $0.00 New Assets 060.005.08 Restroom, Partit Restroom, Partitions 2 20 $3,500.00 $3,149.00 $3,149.00 060.005.08 Restroom, Partit Restroom, Partitions 20 20 $4,525.00 $0.00 $0.00 Maintenance completed 060.005.10 Restroom, Shower Restroom, Shower Door 9 10 $1,616.00 $98.00 $0.00 060.005.10 Restroom, Shower Restroom, Shower Door 10 10 $1,672.00 $0.00 $0.00 Maintenance completed 060.005.13 Restroom, Fixtur Restroom, Fixtures 7 25 $6,061.00 $4,364.00 $0.00 060.005.13 Restroom, Fixtur Restroom, Fixtures 25 25 $6,216.00 $0.00 $0.00 Maintenance completed 065.001.02 Filter, Main Filter, Main 0 12 $4,440.00 $4,440.00 $4,440.00 065.001.02 Filter, Main Filter, Main 2 12 $4,752.00 $4,118.00 $4,118.00 Maintenance deferred Remaining life increased Fully funded value too high should be $3,829.50 Assigned value too high should be $3,829.50 065.001.04 Motor/Pump Syste Motor/Pump System 1 8 $1,905.00 $1,667.00 $1,667.00 065.001.04 Motor/Pump Syste Motor/Pump System 1 8 $1,971.00 $1,752.00 $1,752.00 Remaining life not changed 065.001.05 Pump Pump 5 8 $4,152.00 $1,557.00 $1,557.00 065.001.05 Pump Pump 4 8 $4,297.00 $2,149.00 $0.00 No assigned value 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 3 14 $44,887.00 $35,211.00 $35,211.00 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 2 14 $50,483.00 $43,228.00 $43,228.00 Cost value too high should be $46,458.04 Fully funded value too high should be $39,821.18 Assigned value too high should be $39,821.18 065.002.01 Spa, Filter Spa, Filter 0 10 $817.00 $817.00 $817.00 065.002.01 Spa, Filter Spa, Filter 1 10 $845.00 $797.00 $797.00 Maintenance deferred Remaining life increased 065.002.02 Spa, Heater Spa, Heater 1 10 $2,660.00 $2,438.00 $2,438.00 065.002.02 Spa, Heater Spa, Heater 1 10 $2,753.00 $2,541.00 $2,541.00 Remaining life not changed 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 1 8 $952.00 $833.00 $833.00 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 2 8 $985.00 $788.00 $788.00 Remaining life increased Fully funded value too high should be $738.99 Assigned value too high should be $738.99 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 1 12 $5,533.00 $5,069.00 $5,069.00 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 0 12 $6,383.00 $6,383.00 $6,383.00 Cost value too high should be $5,726.65 Fully funded value too high should be $5,726.65 Assigned value too high should be $5,726.65 065.002.06 Spa, Sump Pump Spa, Sump Pump 7 8 $2,381.00 $183.00 $0.00 065.002.06 Spa, Sump Pump Spa, Sump Pump 6 8 $2,464.00 $514.00 $0.00 Fully funded value too low should be $616.08 No assigned value 065.003.02 Wader, Heater Wader, Heater 10 12 $2,665.00 $348.00 $0.00 065.003.02 Wader, Heater Wader, Heater 9 12 $2,758.00 $600.00 $0.00 Fully funded value too low should be $689.57 No assigned value 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 0 8 $600.00 $600.00 $600.00 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 1 8 $621.00 $558.00 $558.00 Maintenance deferred Remaining life increased 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 3 14 $4,922.00 $3,861.00 $3,861.00 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 2 14 $5,725.00 $4,902.00 $4,902.00 Cost value too high should be $5,094.27 Fully funded value too high should be $4,366.52 Assigned value too high should be $4,366.52 067.001.03 Barbecues Barbecues 8 14 $6,844.00 $2,838.00 $0.00 067.001.03 Barbecues Barbecues 0 14 $7,083.00 $7,083.00 $7,083.00 Remaining life decreased too much 067.001.04 Barbecues, Main, Barbecues, Main, 1994 0 10 $644.00 $644.00 $644.00 067.001.04 Barbecues, Main, Barbecues, Main, 1994 2 10 $667.00 $585.00 $585.00 Maintenance deferred Remaining life increased Fully funded value too high should be $533.23 Assigned value too high should be $533.23 067.001.05 Ceramic Shower Ceramic Shower 4 25 $1,804.00 $1,598.00 $1,598.00 067.001.05 Ceramic Shower Ceramic Shower 6 25 $1,850.00 $1,558.00 $0.00 Remaining life increased Fully funded value too high should be $1,419.03 No assigned value 067.002.02 Deck Caulking Deck Caulking 0 4 $7,910.00 $7,910.00 $7,910.00 067.002.02 Deck Caulking Deck Caulking 0 4 $8,750.00 $8,750.00 $8,750.00 Maintenance deferred Cost value too high should be $8,186.85 Fully funded value too high should be $8,186.85 Assigned value too high should be $8,186.85 067.002.03 Deck Repairs Deck Repairs 1 30 $10,854.00 $10,525.00 $10,525.00 New Assets 067.003.02 Furniture, 2001 Furniture, 2001 0 7 $15,098.00 $15,098.00 $15,098.00 067.003.02 Furniture, 2001 Furniture, 2001 2 7 $16,446.00 $13,157.00 $13,157.00 Maintenance deferred Remaining life increased Cost value too high should be $15,626.43 Fully funded value too high should be $11,161.74 Assigned value too high should be $11,161.74 067.003.03 Furniture, 2007 Furniture, 2007 6 7 $12,921.00 $1,145.00 $1,145.00 067.003.03 Furniture, 2007 Furniture, 2007 5 7 $13,373.00 $3,216.00 $0.00 Fully funded value too low should be $3,820.92 No assigned value 069.001.01 Filter, Prosa Filter, Prosa 0 12 $817.00 $817.00 $817.00 069.001.01 Filter, Prosa Filter, Prosa 11 12 $1,297.00 $65.00 $0.00 Maintenance completed 069.001.04 Heater, Prosa Heater, Prosa 0 12 $2,660.00 $2,660.00 $2,660.00 069.001.04 Heater, Prosa Heater, Prosa 0 12 $2,753.00 $2,753.00 $2,753.00 Maintenance deferred 069.001.05 Motor Motor 0 8 $670.00 $670.00 $670.00 069.001.05 Motor Motor 0 8 $693.00 $693.00 $693.00 Maintenance deferred 069.001.06 Pump Pump 0 8 $349.00 $349.00 $349.00 069.001.06 Pump Pump 1 8 $361.00 $328.00 $328.00 Maintenance deferred Remaining life increased 070.001.02 Barbecues Barbecues 0 10 $1,288.00 $1,288.00 $1,288.00 070.001.02 Barbecues Barbecues 2 10 $1,334.00 $1,227.00 $1,227.00 Maintenance deferred Remaining life increased Fully funded value too high should be $1,066.46 Assigned value too high should be $1,066.46 070.001.05 Furniture Furniture 0 7 $6,312.00 $6,312.00 $6,312.00 070.001.05 Furniture Furniture 2 7 $7,698.00 $6,158.00 $6,158.00 Maintenance deferred Remaining life increased Cost value too high should be $6,532.92 Fully funded value too high should be $4,666.37 Assigned value too high should be $4,666.37 070.001.06 Plumbing Fixture Plumbing Fixtures 1 25 $4,653.00 $4,481.00 $4,481.00 070.001.06 Plumbing Fixture Plumbing Fixtures 2 25 $4,772.00 $4,443.00 $4,443.00 Remaining life increased 070.001.07 Repairs Repairs 4 20 $2,642.00 $2,290.00 $2,290.00 070.001.07 Repairs Repairs 3 20 $2,714.00 $2,443.00 $2,443.00 Fully funded value too high should be $2,324.30 Assigned value too high should be $2,324.30 070.001.09 Wood, Repairs Wood, Repairs 0 5 $3,500.00 $3,500.00 $3,500.00 New Assets 070.002.01 Ceramic Shower Ceramic Shower 4 25 $5,965.00 $5,169.00 $5,169.00 070.002.01 Ceramic Shower Ceramic Shower 1 25 $6,119.00 $5,901.00 $5,901.00 Remaining life decreased too much 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 4 25 $7,622.00 $6,606.00 $6,606.00 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 3 25 $7,817.00 $7,035.00 $3,213.00 Assigned value too low should be $6,942.12 070.003.01 Deck, Caulking Deck, Caulking 0 4 $2,608.00 $2,608.00 $2,608.00 070.003.01 Deck, Caulking Deck, Caulking 3 4 $2,885.00 $627.00 $627.00 Maintenance completed 070.003.02 Deck, Repairs Deck, Repairs 3 30 $5,364.00 $4,828.00 $4,828.00 New Assets 070.005.01 Restroom, Counte Restroom, Counters 1 20 $916.00 $882.00 $882.00 070.005.01 Restroom, Counte Restroom, Counters 2 20 $944.00 $879.00 $879.00 Remaining life increased 080.000.01 Benches Benches 0 15 $5,056.00 $5,056.00 $5,056.00 080.000.01 Benches Benches 2 15 $5,859.00 $5,350.00 $5,350.00 Maintenance deferred Remaining life increased Cost value too high should be $5,232.96 Fully funded value too high should be $4,535.23 Assigned value too high should be $4,535.23 080.000.02 Chain Link Fenci Chain Link Fencing 6 25 $15,997.00 $13,403.00 $13,403.00 080.000.02 Chain Link Fenci Chain Link Fencing 5 25 $16,553.00 $14,316.00 $0.00 Fully funded value too high should be $13,245.52 No assigned value 080.000.05 Lighting Lighting 6 25 $11,344.00 $9,504.00 $9,504.00 080.000.05 Lighting Lighting 5 25 $11,649.00 $10,074.00 $0.00 Fully funded value too high should be $9,392.83 No assigned value 080.000.06 Resurfacing Resurfacing 6 6 $10,224.00 $4,090.00 $4,090.00 080.000.06 Resurfacing Resurfacing 2 6 $10,656.00 $7,611.00 $7,611.00 Remaining life decreased too much Fully funded value too high should be $7,054.56 Assigned value too high should be $7,054.56 080.000.07 Windscreen Windscreen 0 6 $2,728.00 $2,728.00 $2,728.00 080.000.07 Windscreen Windscreen 0 6 $2,847.00 $2,847.00 $2,847.00 Maintenance deferred 085.002.02 Drinking Fntns, Drinking Fntns, Concrete 0 30 $5,115.00 $5,115.00 $5,115.00 085.002.02 Drinking Fntns, Drinking Fntns, Concrete 2 30 $5,275.00 $4,965.00 $4,965.00 Maintenance deferred Remaining life increased 085.003.01 Play Equipment, Play Equipment, Alba 11 20 $18,435.00 $8,296.00 $0.00 085.003.01 Play Equipment, Play Equipment, Alba 8 18 $19,080.00 $10,600.00 $0.00 Remaining life decreased too much Useful life decreased No assigned value 085.003.03 Sand Repl, Prosa Sand Repl, Prosa/Alba 0 10 $3,061.00 $3,061.00 $3,061.00 085.003.03 Sand Repl, Prosa Sand Repl, Prosa/Alba 0 10 $3,140.00 $3,140.00 $3,140.00 Maintenance deferred 085.004.01 Play Equip, Main Play Equip, Main, Prosa 9 20 $41,924.00 $22,574.00 $0.00 085.004.01 Play Equip, Main Play Equip, Main, Prosa 6 18 $43,391.00 $28,514.00 $0.00 Remaining life decreased too much Useful life decreased No assigned value 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $2,711.00 $2,711.00 $2,711.00 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $2,781.00 $2,781.00 $2,781.00 Maintenance deferred 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 4 12 $4,086.00 $2,829.00 $0.00 New Assets 090.000.05 Trellis, Wood, R Trellis, Wood, Repairs 0 10 $15,000.00 $15,000.00 $15,000.00 090.000.05 Trellis, Wood, R Trellis, Wood, Repairs 0 30 $35,000.00 $35,000.00 $35,000.00 Maintenance deferred Cost value too high should be $15,525.00 Fully funded value too high should be $15,525.00 Assigned value too high should be $15,525.00 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 2 4 $9,000.00 $3,977.00 $3,977.00 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 1 4 $9,000.00 $6,488.00 $6,488.00 Cost not changed 095.002.04 Tree Trimming, R Tree Trimming, Red Ironbark 2 2 $4,500.00 $0.00 $0.00 New Assets 095.002.05 Tree Trimming Tree Trimming 0 1 $4,000.00 $4,000.00 $4,000.00 095.002.05 Tree Trimming Tree Trimming 0 1 $4,000.00 $4,000.00 $4,000.00 Maintenance deferred Cost not changed 095.002.06 Tree Trimming, W Tree Trimming, Windrow 1 3 $30,000.00 $18,387.00 $18,387.00 095.002.06 Tree Trimming, W Tree Trimming, Windrow 0 3 $30,000.00 $30,000.00 $30,000.00 Cost not changed 097.000.01 Backflow Devices Backflow Devices 1 24 $8,736.00 $8,463.00 $8,463.00 097.000.01 Backflow Devices Backflow Devices 2 24 $8,890.00 $8,367.00 $8,367.00 Remaining life increased 097.000.02 Irrigation, Cont Irrigation, Controllers 1 12 $37,869.00 $35,502.00 $35,502.00 097.000.02 Irrigation, Cont Irrigation, Controllers 2 12 $39,150.00 $34,800.00 $34,800.00 Remaining life increased Fully funded value too high should be $32,662.01 Assigned value too high should be $32,662.01 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 1 24 $15,337.00 $14,858.00 $14,858.00 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 2 24 $16,716.00 $15,733.00 $15,733.00 Remaining life increased Cost value too high should be $15,873.79 Fully funded value too high should be $14,550.98 Assigned value too high should be $14,550.98 100.000.01 Bulletin Board Bulletin Board 1 12 $903.00 $840.00 $840.00 100.000.01 Bulletin Board Bulletin Board 3 12 $934.00 $772.00 $0.00 Remaining life increased Fully funded value too high should be $700.95 No assigned value 100.000.02 Monument Monument 0 30 $3,540.00 $3,540.00 $3,540.00 100.000.02 Monument Monument 0 30 $12,000.00 $12,000.00 $12,000.00 Maintenance deferred Cost value too high should be $3,663.90 Fully funded value too high should be $3,663.90 Assigned value too high should be $3,663.90 105.000.01 Termite Control/ Termite Control/Fumigation 3 15 $4,000.00 $3,200.00 $3,200.00 105.000.01 Termite Control/ Termite Control/Fumigation 2 15 $4,500.00 $3,900.00 $3,900.00 Cost value too high should be $4,140.00 Fully funded value too high should be $3,588.00 Assigned value too high should be $3,588.00 110.000.01 Golf Cart, Repla Golf Cart, Replacement 3 12 $5,000.00 $4,211.00 $4,211.00 110.000.01 Golf Cart, Repla Golf Cart, Replacement 3 12 $5,000.00 $4,250.00 $4,250.00 Remaining life not changed Cost not changed 2008 - 2009 RDA Forensic Analysis Summary Estimated inflation 3.5% Consumer Price Index 3.8% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $937,233.00 $642,210.00 $573,185.00 This Year Costs $1,102,140.00 $755,767.00 $575,920.00 Calculated Costs $1,063,822.02 $730,121.55 $730,121.55 Comparing This Year Costs to Last Year Costs Difference $164,907.00 $113,557.00 $2,735.00 percent difference 17.60% 17.68% 0.48% exceeds CC&R limits Comparing This Year Costs to Calculated Costs Difference $38,317.98 $25,645.45 $-154,201.55 percent difference 3.48% 3.39% -26.77% 115 Total Assets 97 Total Issues $235,362.29 Unfunded Liability 0.84 Issues / Asset number % Description 12 10.43% New Assets 27 23.48% No assigned value 17 14.78% Cost value too high 1 0.87% Cost value too low 34 29.57% Fully funded value too high 15 13.04% Fully funded value too low 26 22.61% Assigned value too high 2 1.74% Assigned value too low 5 4.35% Asset deleted 4 3.48% Remaining life not changed 28 24.35% Remaining life increased 8 6.96% Remaining life decreased too much 3 2.61% Useful life increased 3 2.61% Useful life decreased 28 24.35% Maintenance deferred 9 7.83% Maintenance completed 31 26.96% Total assets to be maintained 5 4.35% Cost not changed