Park Paseo Homeowners Association Audited Forensic Report For 2009 to 2010 Revenue 505.000.01 Homeowners Association Fees $426,100.00 $181,400.00 $607,500.00 505.000.01 Homeowners Association Fees $415,220.00 $154,780.00 $570,000.00 Replacement fund too high difference is $26,620.00 530.000.01 Late Fees & Interest $4,100.00 $0.00 $4,100.00 530.000.01 Late Fees & Interest $4,390.00 $0.00 $4,390.00 Operating fund too low difference is $-290.00 Cost too low difference is $-290.00 540.000.09 Other Charges to Owners $27,861.00 $0.00 $27,861.00 540.000.09 Other Charges to Owners $21,119.00 $0.00 $21,119.00 Operating fund too high difference is $6,742.00 Cost too high difference is $6,742.00 550.000.03 Investment Income $0.00 $6,518.00 $6,518.00 550.000.03 Investment Income $6,958.00 $0.00 $6,958.00 Operating fund too low difference is $-6,958.00 Replacement fund too high difference is $6,518.00 Cost too low difference is $-440.00 Expense 640.000.07 Office supplies/printing/postage $2,709.00 $0.00 $2,709.00 640.000.07 Office supplies/printing/postage $2,814.00 $0.00 $2,814.00 Operating fund too low difference is $-105.00 Cost too low difference is $-105.00 680.001.02 Newsletters/Mailouts/Extras $250.00 $0.00 $250.00 Deleted Asset(s) Expense 720.000.08 Landscape Expense $168,874.00 $34,680.00 $203,554.00 720.000.08 Landscape Expense $140,993.00 $0.00 $140,993.00 Operating fund too high difference is $27,881.00 Replacement fund too high difference is $34,680.00 Cost too high difference is $62,561.00 780.000.01 Property Protection - Patrol Service $47,658.00 $0.00 $47,658.00 780.000.01 Property Protection - Patrol Service $41,178.00 $0.00 $41,178.00 Operating fund too high difference is $6,480.00 Cost too high difference is $6,480.00 840.001.11 Common Areas $58,270.00 $140,452.00 $198,722.00 840.001.11 Common Areas $29,022.00 $82,577.00 $111,599.00 Operating fund too high difference is $29,248.00 Replacement fund too high difference is $57,875.00 Cost too high difference is $87,123.00 840.006.05 Pool Monitor $11,915.00 $0.00 $11,915.00 840.006.05 Pool Monitor $14,486.00 $0.00 $14,486.00 Operating fund too low difference is $-2,571.00 Cost too low difference is $-2,571.00 860.000.04 Trash and Recycling Service $71,075.00 $0.00 $71,075.00 860.000.04 Trash and Recycling Service $75,799.00 $0.00 $75,799.00 Operating fund too low difference is $-4,724.00 Cost too low difference is $-4,724.00 880.000.01 Federal Income Tax $3,280.00 $0.00 $3,280.00 880.000.01 Federal Income Tax $1,362.00 $0.00 $1,362.00 Operating fund too high difference is $1,918.00 Cost too high difference is $1,918.00 900.000.04 Miscellaneous $6,430.00 $0.00 $6,430.00 900.000.04 Miscellaneous $6,182.00 $14,221.00 $20,403.00 Replacement fund too low difference is $-14,221.00 Cost too low difference is $-13,973.00 900.000.05 Bad debt expense $1,335.00 $0.00 $1,335.00 900.000.05 Bad debt expense $13,850.00 $0.00 $13,850.00 Operating fund too low difference is $-12,515.00 Cost too low difference is $-12,515.00 2009 - 2010 Analysis Summary Estimated inflation 3.5% Consumer Price Index -0.4% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2009 $447,687.00 $154,780.00 $602,467.00 Revenue 2010 $458,061.00 $187,918.00 $645,979.00 Expense 2009 $433,507.00 $96,798.00 $530,305.00 Expense 2010 $485,603.00 $175,132.00 $660,735.00 revenue - expense 2009 $14,180.00 $57,982.00 $72,162.00 revenue - expense 2010 $-27,542.00 $12,786.00 $-14,756.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $-41,722.00 $-45,196.00 $-86,918.00 percent difference -294.23% -77.95% -120.45% Total Assets 16 Total Issues 57 Issues/Asset 3.56 count % Description 1 6.25% Deleted Asset(s) 5 31.25% Operating fund too high 6 37.50% Operating fund too low 4 25.00% Replacement fund too high 1 6.25% Replacement fund too low 5 31.25% Cost too high 7 43.75% Cost too low Park Paseo Homeowners Association UnAudited Forensic Report For 2009 to 2010 Revenue 505.000.01 Homeowners Association Fees $426,100.00 $181,400.00 $607,500.00 505.000.01 Homeowners Association Fees $415,220.00 $154,780.00 $570,000.00 Replacement fund too high difference is $26,620.00 530.000.01 Late Fees & Interest $4,100.00 $0.00 $4,100.00 530.000.01 Late Fees & Interest $4,390.00 $0.00 $4,390.00 Operating fund too low difference is $-290.00 Cost too low difference is $-290.00 540.000.09 Other Charges to Owners $27,861.00 $0.00 $27,861.00 540.000.09 Other Charges to Owners $21,119.00 $0.00 $21,119.00 Operating fund too high difference is $6,742.00 Cost too high difference is $6,742.00 550.000.03 Investment Income $0.00 $6,518.00 $6,518.00 550.000.03 Investment Income $6,958.00 $0.00 $6,958.00 Operating fund too low difference is $-6,958.00 Replacement fund too high difference is $6,518.00 Cost too low difference is $-440.00 Expense 640.000.07 Office supplies/printing/postage $2,709.00 $0.00 $2,709.00 640.000.07 Office supplies/printing/postage $2,814.00 $0.00 $2,814.00 Operating fund too low difference is $-105.00 Cost too low difference is $-105.00 680.001.02 Newsletters/Mailouts/Extras $250.00 $0.00 $250.00 Deleted Asset(s) Expense 720.000.08 Landscape Expense $168,874.00 $34,680.00 $203,554.00 720.000.08 Landscape Expense $140,993.00 $0.00 $140,993.00 Operating fund too high difference is $27,881.00 Replacement fund too high difference is $34,680.00 Cost too high difference is $62,561.00 780.000.01 Property Protection - Patrol Service $47,658.00 $0.00 $47,658.00 780.000.01 Property Protection - Patrol Service $41,178.00 $0.00 $41,178.00 Operating fund too high difference is $6,480.00 Cost too high difference is $6,480.00 840.001.11 Common Areas $58,270.00 $140,452.00 $198,722.00 840.001.11 Common Areas $29,022.00 $82,577.00 $111,599.00 Operating fund too high difference is $29,248.00 Replacement fund too high difference is $57,875.00 Cost too high difference is $87,123.00 840.006.05 Pool Monitor $11,915.00 $0.00 $11,915.00 840.006.05 Pool Monitor $14,486.00 $0.00 $14,486.00 Operating fund too low difference is $-2,571.00 Cost too low difference is $-2,571.00 860.000.04 Trash and Recycling Service $71,075.00 $0.00 $71,075.00 860.000.04 Trash and Recycling Service $75,799.00 $0.00 $75,799.00 Operating fund too low difference is $-4,724.00 Cost too low difference is $-4,724.00 880.000.01 Federal Income Tax $3,280.00 $0.00 $3,280.00 880.000.01 Federal Income Tax $1,362.00 $0.00 $1,362.00 Operating fund too high difference is $1,918.00 Cost too high difference is $1,918.00 900.000.04 Miscellaneous $6,430.00 $0.00 $6,430.00 900.000.04 Miscellaneous $6,182.00 $14,221.00 $20,403.00 Replacement fund too low difference is $-14,221.00 Cost too low difference is $-13,973.00 900.000.05 Bad debt expense $1,335.00 $0.00 $1,335.00 900.000.05 Bad debt expense $13,850.00 $0.00 $13,850.00 Operating fund too low difference is $-12,515.00 Cost too low difference is $-12,515.00 2009 - 2010 Analysis Summary Estimated inflation 3.5% Consumer Price Index -0.4% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2009 $447,687.00 $154,780.00 $602,467.00 Revenue 2010 $458,061.00 $187,918.00 $645,979.00 Expense 2009 $433,507.00 $96,798.00 $530,305.00 Expense 2010 $485,603.00 $175,132.00 $660,735.00 revenue - expense 2009 $14,180.00 $57,982.00 $72,162.00 revenue - expense 2010 $-27,542.00 $12,786.00 $-14,756.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $-41,722.00 $-45,196.00 $-86,918.00 percent difference -294.23% -77.95% -120.45% Total Assets 16 Total Issues 57 Issues/Asset 3.56 count % Description 1 6.25% Deleted Asset(s) 5 31.25% Operating fund too high 6 37.50% Operating fund too low 4 25.00% Replacement fund too high 1 6.25% Replacement fund too low 5 31.25% Cost too high 7 43.75% Cost too low Park Paseo Homeowners Association RDA Forensic Analysis For 2009 to 2010 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 005.000.01 Concrete - Repai Concrete - Repairs 0 1 $5,000.00 $5,000.00 $5,000.00 Asset deleted 010.000.01 Overlay/Rehab Overlay/Rehab 8 20 $10,435.00 $6,154.00 $0.00 010.000.01 Overlay/Rehab Overlay/Rehab 7 20 $10,749.00 $6,890.00 $0.00 No assigned value 010.000.03 Asphalt Repairs Asphalt Repairs 0 4 $3,923.00 $3,923.00 $3,923.00 010.000.03 Asphalt Repairs Asphalt Repairs 3 4 $2,299.00 $374.00 $0.00 Maintenance completed 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 0 4 $2,118.00 $2,118.00 $2,118.00 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 3 4 $2,354.00 $336.00 $0.00 Maintenance completed 020.000.01 Prosa Cabana Prosa Cabana 0 25 $5,274.00 $5,274.00 $5,274.00 020.000.01 Prosa Cabana Prosa Cabana 25 25 $10,001.00 $0.00 $0.00 Maintenance completed 020.000.03 Clubhouse, Tile Clubhouse, Tile 37 50 $23,090.00 $5,975.00 $0.00 020.000.03 Clubhouse, Tile Clubhouse, Tile 36 50 $24,159.00 $6,736.00 $0.00 No assigned value 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 0 18 $1,136.00 $1,136.00 $1,136.00 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 13 18 $1,180.00 $312.00 $0.00 Maintenance deferred Remaining life increased No assigned value 030.001.02 Interior Clubhou Interior Clubhouse 8 8 $3,767.00 $0.00 $0.00 030.001.02 Interior Clubhou Interior Clubhouse 7 8 $3,866.00 $483.00 $0.00 No assigned value 030.001.03 Interior Prosa R Interior Prosa Restrooms 0 8 $1,720.00 $1,720.00 $1,720.00 030.001.03 Interior Prosa R Interior Prosa Restrooms 0 8 $1,765.00 $1,765.00 $1,765.00 Maintenance deferred 030.001.05 Spa Equipment Ro Spa Equipment Room 0 5 $2,332.00 $2,332.00 $2,332.00 030.001.05 Spa Equipment Ro Spa Equipment Room 0 5 $2,420.00 $2,420.00 $2,420.00 Maintenance deferred 030.001.06 Stucco Stucco 1 10 $2,500.00 $2,315.00 $2,315.00 030.001.06 Stucco Stucco 0 10 $2,500.00 $2,500.00 $2,500.00 Cost not changed 030.001.07 Woodwork Prosa Woodwork Prosa 0 5 $2,748.00 $2,748.00 $2,748.00 030.001.07 Woodwork Prosa Woodwork Prosa 0 5 $2,850.00 $2,850.00 $2,850.00 Maintenance deferred 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $872.00 $872.00 $872.00 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $921.00 $921.00 $921.00 Maintenance deferred 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 0 25 $5,000.00 $5,000.00 $5,000.00 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 0 25 $5,000.00 $5,000.00 $5,000.00 Maintenance deferred Cost not changed 040.000.08 Wrought Iron, Ma Wrought Iron, Main Pool 0 25 $95,000.00 $95,000.00 $95,000.00 040.000.08 Wrought Iron, Ma Wrought Iron, Main Pool 25 25 $115,000.00 $0.00 $0.00 Maintenance completed 040.000.09 Wrought Iron, Pr Wrought Iron, Prosa Pool 25 25 $35,000.00 $0.00 $0.00 040.000.09 Wrought Iron, Pr Wrought Iron, Prosa Pool 25 25 $45,000.00 $0.00 $0.00 Remaining life not changed Cost value too high should be $36,225.00 No assigned value 040.000.10 Wrought Iron, St Wrought Iron, Streets 15 20 $3,173.00 $711.00 $0.00 040.000.10 Wrought Iron, St Wrought Iron, Streets 14 20 $3,268.00 $902.00 $0.00 Fully funded value too low should be $985.22 No assigned value 050.000.03 Exterior, Parkin Exterior, Parking Lot 13 22 $1,220.00 $474.00 $0.00 050.000.03 Exterior, Parkin Exterior, Parking Lot 12 22 $1,262.00 $549.00 $0.00 No assigned value 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 4 15 $49,725.00 $40,718.00 $0.00 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 3 15 $51,425.00 $44,439.00 $0.00 Fully funded value too high should be $41,172.30 No assigned value 050.001.01 Interior Clubhou Interior Clubhouse 6 25 $13,245.00 $11,154.00 $0.00 050.001.01 Interior Clubhou Interior Clubhouse 5 25 $13,677.00 $11,877.00 $0.00 Fully funded value too high should be $10,966.86 No assigned value 060.001.03 Carpet, 2005 Carpet, 2005 4 8 $4,779.00 $2,285.00 $0.00 060.001.03 Carpet, 2005 Carpet, 2005 3 8 $4,921.00 $2,995.00 $0.00 No assigned value 060.001.08 Exterior Stairca Exterior Staircase 27 30 $15,750.00 $1,335.00 $0.00 060.001.08 Exterior Stairca Exterior Staircase 26 30 $16,222.00 $1,925.00 $0.00 Fully funded value too low should be $2,173.50 No assigned value 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 21 25 $15,667.00 $2,329.00 $0.00 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 20 25 $16,137.00 $3,053.00 $0.00 Fully funded value too low should be $3,243.07 No assigned value 060.001.10 Furnishings Furnishings 7 10 $30,000.00 $9,000.00 $0.00 060.001.10 Furnishings Furnishings 6 10 $30,000.00 $12,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 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 18 20 $3,084.00 $308.00 $0.00 No assigned value 060.001.13 HVAC Heat/Air, C HVAC Heat/Air, Clubhouse 0 20 $24,159.00 $24,159.00 $24,159.00 060.001.13 HVAC Heat/Air, C HVAC Heat/Air, Clubhouse 0 20 $24,883.00 $24,883.00 $24,883.00 Maintenance deferred 060.001.14 Window Blinds Window Blinds 6 10 $13,414.00 $5,088.00 $0.00 060.001.14 Window Blinds Window Blinds 5 10 $13,816.00 $6,670.00 $0.00 No assigned value 060.001.16 Wallpaper Wallpaper 11 15 $11,678.00 $2,919.00 $0.00 060.001.16 Wallpaper Wallpaper 10 15 $12,019.00 $3,824.00 $0.00 Fully funded value too low should be $4,028.91 No assigned value 060.001.18 Carpeting Carpeting 3 8 $10,353.00 $9,243.00 $9,243.00 060.001.18 Carpeting Carpeting 2 8 $10,662.00 $9,900.00 $9,900.00 Fully funded value too high should be $8,036.52 Assigned value too high should be $8,036.52 060.002.02 Doors, Exterior, Doors, Exterior, Entry 21 25 $11,086.00 $1,648.00 $0.00 060.002.02 Doors, Exterior, Doors, Exterior, Entry 20 25 $11,418.00 $2,160.00 $0.00 Fully funded value too low should be $2,294.80 No assigned value 060.002.03 Doors, Entry Doors, Entry 0 25 $8,772.00 $8,772.00 $8,772.00 060.002.03 Doors, Entry Doors, Entry 0 25 $9,032.00 $9,032.00 $9,032.00 Maintenance deferred 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 6 25 $2,020.00 $1,701.00 $0.00 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 5 25 $2,080.00 $1,806.00 $0.00 Fully funded value too high should be $1,672.56 No assigned value 060.002.08 Doors, Entry Int Doors, Entry Interior 6 25 $1,593.00 $1,211.00 $0.00 060.002.08 Doors, Entry Int Doors, Entry Interior 5 25 $1,639.00 $1,311.00 $0.00 No assigned value 060.003.01 Kitchen, Applian Kitchen, Appliances 8 12 $4,502.00 $1,415.00 $0.00 060.003.01 Kitchen, Applian Kitchen, Appliances 7 12 $4,637.00 $1,855.00 $0.00 No assigned value 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 21 25 $20,843.00 $3,098.00 $0.00 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 20 25 $21,468.00 $4,062.00 $0.00 Fully funded value too low should be $4,314.50 No assigned value 060.003.08 Kitchen, Sink Kitchen, Sink 21 25 $664.00 $99.00 $0.00 060.003.08 Kitchen, Sink Kitchen, Sink 20 25 $683.00 $129.00 $0.00 Fully funded value too low should be $137.45 No assigned value 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 6 8 $10,000.00 $2,340.00 $0.00 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 5 8 $10,000.00 $3,617.00 $0.00 Cost not changed 060.004.10 Office, Remodel Office, Remodel 18 20 $10,966.00 $1,014.00 $0.00 060.004.10 Office, Remodel Office, Remodel 17 20 $11,294.00 $1,613.00 $0.00 Fully funded value too low should be $1,702.47 No assigned value 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 25 25 $16,712.00 $0.00 $0.00 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 24 25 $17,134.00 $685.00 $0.00 No assigned value 060.005.03 Restroom, Counte Restroom, Counters 20 20 $1,072.00 $0.00 $0.00 060.005.03 Restroom, Counte Restroom, Counters 19 20 $1,088.00 $54.00 $0.00 No assigned value 060.005.07 Restroom, Locker Restroom, Lockers/Benches 22 22 $20,000.00 $0.00 $0.00 060.005.07 Restroom, Locker Restroom, Lockers/Benches 21 22 $20,000.00 $909.00 $0.00 Cost not changed 060.005.08 Restroom, Partit Restroom, Partitions 20 20 $4,525.00 $0.00 $0.00 060.005.08 Restroom, Partit Restroom, Partitions 19 20 $4,660.00 $233.00 $0.00 No assigned value 060.005.10 Restroom, Shower Restroom, Shower Door 10 10 $1,672.00 $0.00 $0.00 060.005.10 Restroom, Shower Restroom, Shower Door 9 10 $1,720.00 $172.00 $0.00 No assigned value 060.005.13 Restroom, Fixtur Restroom, Fixtures 25 25 $6,216.00 $0.00 $0.00 060.005.13 Restroom, Fixtur Restroom, Fixtures 24 25 $6,397.00 $256.00 $0.00 No assigned value 065.001.05 Pump Pump 4 8 $4,297.00 $2,149.00 $0.00 065.001.05 Pump Pump 3 8 $4,425.00 $2,766.00 $0.00 No assigned value 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 0 12 $6,383.00 $6,383.00 $6,383.00 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 0 12 $6,586.00 $6,586.00 $6,586.00 Maintenance deferred 065.002.06 Spa, Sump Pump Spa, Sump Pump 6 8 $2,464.00 $514.00 $0.00 065.002.06 Spa, Sump Pump Spa, Sump Pump 5 8 $2,537.00 $864.00 $0.00 Fully funded value too low should be $956.34 No assigned value 065.003.02 Wader, Heater Wader, Heater 9 12 $2,758.00 $600.00 $0.00 065.003.02 Wader, Heater Wader, Heater 8 12 $2,840.00 $864.00 $0.00 Fully funded value too low should be $951.51 No assigned value 067.001.03 Barbecues Barbecues 0 14 $7,083.00 $7,083.00 $7,083.00 067.001.03 Barbecues Barbecues 0 14 $7,295.00 $7,295.00 $7,295.00 Maintenance deferred 067.001.05 Ceramic Shower Ceramic Shower 6 25 $1,850.00 $1,558.00 $0.00 067.001.05 Ceramic Shower Ceramic Shower 5 25 $1,897.00 $1,648.00 $0.00 Fully funded value too high should be $1,531.80 No assigned value 067.002.02 Deck Caulking Deck Caulking 0 4 $8,750.00 $8,750.00 $8,750.00 067.002.02 Deck Caulking Deck Caulking 0 4 $9,013.00 $9,013.00 $9,013.00 Maintenance deferred 067.003.03 Furniture, 2007 Furniture, 2007 5 7 $13,373.00 $3,216.00 $0.00 067.003.03 Furniture, 2007 Furniture, 2007 4 7 $13,774.00 $5,405.00 $0.00 Fully funded value too low should be $5,931.88 No assigned value 069.001.01 Filter, Prosa Filter, Prosa 11 12 $1,297.00 $65.00 $0.00 069.001.01 Filter, Prosa Filter, Prosa 10 12 $1,335.00 $182.00 $0.00 Fully funded value too low should be $223.73 No assigned value 069.001.04 Heater, Prosa Heater, Prosa 0 12 $2,753.00 $2,753.00 $2,753.00 069.001.04 Heater, Prosa Heater, Prosa 0 12 $2,835.00 $2,835.00 $2,835.00 Maintenance deferred 069.001.05 Motor Motor 0 8 $693.00 $693.00 $693.00 069.001.05 Motor Motor 0 8 $713.00 $713.00 $713.00 Maintenance deferred 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 3 14 $26,348.00 $20,668.00 $20,668.00 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 2 14 $27,113.00 $23,217.00 $17,260.00 Assigned value too low should be $23,374.44 070.001.02 Barbecues Barbecues 2 10 $1,334.00 $1,227.00 $1,227.00 070.001.02 Barbecues Barbecues 1 10 $1,374.00 $1,319.00 $1,319.00 Fully funded value too high should be $1,242.62 Assigned value too high should be $1,242.62 070.001.07 Repairs Repairs 3 20 $2,714.00 $2,443.00 $2,443.00 070.001.07 Repairs Repairs 2 20 $2,793.00 $2,607.00 $0.00 No assigned value 070.001.09 Wood, Repairs Wood, Repairs 0 5 $3,500.00 $3,500.00 $3,500.00 070.001.09 Wood, Repairs Wood, Repairs 0 5 $3,500.00 $3,500.00 $3,500.00 Maintenance deferred Cost not changed 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 3 25 $7,817.00 $7,035.00 $3,213.00 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 2 25 $8,012.00 $7,478.00 $0.00 No assigned value 070.003.01 Deck, Caulking Deck, Caulking 3 4 $2,885.00 $627.00 $627.00 070.003.01 Deck, Caulking Deck, Caulking 2 4 $2,972.00 $1,421.00 $0.00 No assigned value 070.003.02 Deck, Repairs Deck, Repairs 3 30 $5,364.00 $4,828.00 $4,828.00 070.003.02 Deck, Repairs Deck, Repairs 2 30 $5,522.00 $5,154.00 $0.00 No assigned value 080.000.02 Chain Link Fenci Chain Link Fencing 5 25 $16,553.00 $14,316.00 $0.00 080.000.02 Chain Link Fenci Chain Link Fencing 4 25 $16,999.00 $15,161.00 $0.00 Fully funded value too high should be $14,391.18 No assigned value 080.000.05 Lighting Lighting 5 25 $11,649.00 $10,074.00 $0.00 080.000.05 Lighting Lighting 4 25 $12,048.00 $10,746.00 $0.00 Fully funded value too high should be $10,127.64 No assigned value 080.000.07 Windscreen Windscreen 0 6 $2,847.00 $2,847.00 $2,847.00 080.000.07 Windscreen Windscreen 0 6 $2,926.00 $2,926.00 $2,926.00 Maintenance deferred 085.002.01 Drinking Fountai Drinking Fountain, C/H 0 16 $2,588.00 $2,588.00 $2,588.00 085.002.01 Drinking Fountai Drinking Fountain, C/H 0 16 $2,664.00 $2,664.00 $2,664.00 Maintenance deferred 085.003.01 Play Equipment, Play Equipment, Alba 8 18 $19,080.00 $10,600.00 $0.00 085.003.01 Play Equipment, Play Equipment, Alba 7 18 $19,652.00 $12,010.00 $0.00 No assigned value 085.003.03 Sand Repl, Prosa Sand Repl, Prosa/Alba 0 10 $3,140.00 $3,140.00 $3,140.00 085.003.03 Sand Repl, Prosa Sand Repl, Prosa/Alba 0 10 $3,219.00 $3,219.00 $3,219.00 Maintenance deferred 085.004.01 Play Equip, Main Play Equip, Main, Prosa 6 18 $43,391.00 $28,514.00 $0.00 085.004.01 Play Equip, Main Play Equip, Main, Prosa 5 18 $44,692.00 $31,923.00 $0.00 No assigned value 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $2,781.00 $2,781.00 $2,781.00 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $2,851.00 $2,851.00 $2,851.00 Maintenance deferred 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 4 12 $4,086.00 $2,829.00 $0.00 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 3 12 $4,201.00 $3,232.00 $0.00 No assigned value 090.000.05 Trellis, Wood, R Trellis, Wood, Repairs 0 30 $35,000.00 $35,000.00 $35,000.00 090.000.05 Trellis, Wood, R Trellis, Wood, Repairs 0 30 $35,000.00 $35,000.00 $35,000.00 Maintenance deferred Cost not changed 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 1 4 $9,000.00 $6,488.00 $6,488.00 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 0 4 $9,000.00 $9,000.00 $9,000.00 Cost not changed 095.002.04 Tree Trimming, R Tree Trimming, Red Ironbark 2 2 $4,500.00 $0.00 $0.00 Asset deleted 095.002.05 Tree Trimming Tree Trimming 0 1 $4,000.00 $4,000.00 $4,000.00 Asset deleted 095.002.06 Tree Trimming, W Tree Trimming, Windrow 0 3 $30,000.00 $30,000.00 $30,000.00 095.002.06 Tree Trimming, W Tree Trimming, Windrow 0 3 $30,000.00 $30,000.00 $30,000.00 Maintenance deferred Cost not changed 100.000.01 Bulletin Board Bulletin Board 3 12 $934.00 $772.00 $0.00 100.000.01 Bulletin Board Bulletin Board 2 12 $962.00 $850.00 $0.00 Fully funded value too high should be $805.57 No assigned value 100.000.02 Monument Monument 0 30 $12,000.00 $12,000.00 $12,000.00 100.000.02 Monument Monument 0 30 $3,000.00 $3,000.00 $3,000.00 Maintenance deferred Cost value too low should be $12,420.00 Fully funded value too low should be $12,420.00 Assigned value too low should be $12,420.00 110.000.01 Golf Cart, Repla Golf Cart, Replacement 3 12 $5,000.00 $4,250.00 $4,250.00 110.000.01 Golf Cart, Repla Golf Cart, Replacement 2 12 $5,000.00 $4,500.00 $4,500.00 Cost not changed 2009 - 2010 RDA Forensic Analysis Summary Estimated inflation 3.5% Consumer Price Index -0.4% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $1,102,140.00 $755,767.00 $575,920.00 This Year Costs $1,136,350.00 $698,054.00 $467,251.00 Calculated Costs $1,143,682.88 $711,275.00 $711,275.00 Comparing This Year Costs to Last Year Costs Difference $34,210.00 $-57,713.00 $-108,669.00 percent difference 3.10% -7.64% -18.87% Comparing This Year Costs to Calculated Costs Difference $-7,332.88 $-13,221.00 $-244,024.00 percent difference -0.65% -1.89% -52.23% 112 Total Assets 35 Total Issues $330,397.67 Unfunded Liability 0.31 Issues / Asset number % Description 43 38.39% No assigned value 1 0.89% Cost value too high 1 0.89% Cost value too low 9 8.04% Fully funded value too high 13 11.61% Fully funded value too low 2 1.79% Assigned value too high 2 1.79% Assigned value too low 3 2.68% Asset deleted 1 0.89% Remaining life not changed 1 0.89% Remaining life increased 21 18.75% Maintenance deferred 4 3.57% Maintenance completed 25 22.32% Total assets to be maintained 10 8.93% Cost not changed