Park Paseo Homeowners Association Audited Forensic Report For 2012 to 2013 Revenue 505.000.01 Homeowners Association Fees $501,189.00 $136,311.00 $637,500.00 505.000.01 Homeowners Association Fees $484,800.00 $152,700.00 $637,500.00 Replacement fund too low difference is $-16,389.00 Totals costs unchanged 520.000.01 Clubhouse Rental Fee $10,850.00 $0.00 $10,850.00 520.000.01 Clubhouse Rental Fee $8,875.00 $0.00 $8,875.00 Operating fund too high difference is $1,975.00 Cost too high difference is $1,975.00 540.000.10 Other Income $12,600.00 $0.00 $12,600.00 540.000.10 Other Income $7,183.00 $0.00 $7,183.00 Operating fund too high difference is $5,417.00 Cost too high difference is $5,417.00 550.000.03 Investment Income $0.00 $1,788.00 $1,788.00 550.000.03 Investment Income $0.00 $2,470.00 $2,470.00 Replacement fund too low difference is $-682.00 Cost too low difference is $-682.00 Expense 640.000.03 Reserve Studies $2,215.00 $0.00 $2,215.00 640.000.03 Reserve Studies $1,600.00 $0.00 $1,600.00 Operating fund too high difference is $615.00 Cost too high difference is $615.00 640.000.05 General Administrative $22,003.00 $95.00 $22,098.00 640.000.05 General Administrative $22,717.00 $0.00 $22,717.00 Operating fund too low difference is $-714.00 Replacement fund too high difference is $95.00 Cost too low difference is $-619.00 640.000.07 Office supplies/printing/postage $17,621.00 $0.00 $17,621.00 640.000.07 Office supplies/printing/postage $15,725.00 $0.00 $15,725.00 Operating fund too high difference is $1,896.00 Cost too high difference is $1,896.00 700.000.01 Insurance $14,710.00 $0.00 $14,710.00 700.000.01 Insurance $15,633.00 $0.00 $15,633.00 Operating fund too low difference is $-923.00 Cost too low difference is $-923.00 720.000.08 Landscape Expense $136,661.00 $35,030.00 $171,691.00 720.000.08 Landscape Expense $137,827.00 $0.00 $137,827.00 Replacement fund too high difference is $35,030.00 Cost too high difference is $33,864.00 760.000.04 Management Fees $60,000.00 $0.00 $60,000.00 760.000.04 Management Fees $60,000.00 $0.00 $60,000.00 Total costs unchanged 760.000.07 Legal and collection $5,223.00 $0.00 $5,223.00 760.000.07 Legal and collection $3,269.00 $0.00 $3,269.00 Operating fund too high difference is $1,954.00 Cost too high difference is $1,954.00 780.000.01 Property Protection - Patrol Service $41,384.00 $0.00 $41,384.00 780.000.01 Property Protection - Patrol Service $36,608.00 $0.00 $36,608.00 Operating fund too high difference is $4,776.00 Cost too high difference is $4,776.00 840.001.05 General Repair & Maintenance $51,340.00 $0.00 $51,340.00 840.001.05 General Repair & Maintenance $16,949.00 $9,120.00 $26,069.00 Operating fund too high difference is $34,391.00 Replacement fund too low difference is $-9,120.00 Cost too high difference is $25,271.00 840.001.13 Streets & Drives $0.00 $2,335.00 $2,335.00 Deleted Asset(s) Expense 840.002.04 Janitorial Combined Costs $14,314.00 $0.00 $14,314.00 840.002.04 Janitorial Combined Costs $12,168.00 $0.00 $12,168.00 Operating fund too high difference is $2,146.00 Cost too high difference is $2,146.00 840.004.03 Pest Control $1,488.00 $0.00 $1,488.00 840.004.03 Pest Control $1,209.00 $0.00 $1,209.00 Operating fund too high difference is $279.00 Cost too high difference is $279.00 840.006.03 Pool Supplies/Repair & Maintenance $45,851.00 $144,754.00 $190,605.00 840.006.03 Pool Supplies/Repair & Maintenance $33,838.00 $5,400.00 $39,238.00 Operating fund too high difference is $12,013.00 Replacement fund too high difference is $139,354.00 Cost too high difference is $151,367.00 860.000.01 Electric Service $29,153.00 $0.00 $29,153.00 860.000.01 Electric Service $26,803.00 $0.00 $26,803.00 Operating fund too high difference is $2,350.00 Cost too high difference is $2,350.00 860.000.02 Gas Service $12,106.00 $0.00 $12,106.00 860.000.02 Gas Service $9,075.00 $0.00 $9,075.00 Operating fund too high difference is $3,031.00 Cost too high difference is $3,031.00 860.000.04 Trash and Recycling Service $1,831.00 $0.00 $1,831.00 860.000.04 Trash and Recycling Service $1,499.00 $0.00 $1,499.00 Operating fund too high difference is $332.00 Cost too high difference is $332.00 880.000.01 Federal Income Tax $26.00 $483.00 $509.00 880.000.01 Federal Income Tax $0.00 $747.00 $747.00 Operating fund too high difference is $26.00 Replacement fund too low difference is $-264.00 Cost too low difference is $-238.00 900.000.05 Bad debt expense $5,729.00 $0.00 $5,729.00 900.000.05 Bad debt expense $3,849.00 $0.00 $3,849.00 Operating fund too high difference is $1,880.00 Cost too high difference is $1,880.00 2012 - 2013 Analysis Summary Estimated inflation 3% Consumer Price Index 2.1% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2012 $500,858.00 $155,170.00 $656,028.00 Revenue 2013 $524,639.00 $138,099.00 $662,738.00 Expense 2012 $432,400.00 $17,602.00 $450,002.00 Expense 2013 $496,140.00 $180,362.00 $676,502.00 revenue - expense 2012 $68,458.00 $137,568.00 $206,026.00 revenue - expense 2013 $28,499.00 $-42,263.00 $-13,764.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $-39,959.00 $-179,831.00 $-219,790.00 percent difference -58.37% -130.72% -106.68% Total Assets 24 Total Issues 91 Issues/Asset 3.79 count % Description 1 4.17% Deleted Asset(s) 15 62.50% Operating fund too high 2 8.33% Operating fund too low 3 12.50% Replacement fund too high 4 16.67% Replacement fund too low 15 62.50% Cost too high 4 16.67% Cost too low 1 4.17% Total costs unchanged 1 4.17% Totals costs unchanged Park Paseo Homeowners Association UnAudited Forensic Report For 2012 to 2013 Revenue 505.000.01 Homeowners Association Fees $501,189.00 $136,311.00 $637,500.00 505.000.01 Homeowners Association Fees $484,800.00 $152,700.00 $637,500.00 Replacement fund too low difference is $-16,389.00 Totals costs unchanged 520.000.01 Clubhouse Rental Fee $10,850.00 $0.00 $10,850.00 520.000.01 Clubhouse Rental Fee $8,875.00 $0.00 $8,875.00 Operating fund too high difference is $1,975.00 Cost too high difference is $1,975.00 540.000.10 Other Income $12,600.00 $0.00 $12,600.00 540.000.10 Other Income $7,183.00 $0.00 $7,183.00 Operating fund too high difference is $5,417.00 Cost too high difference is $5,417.00 550.000.03 Investment Income $0.00 $1,788.00 $1,788.00 550.000.03 Investment Income $0.00 $2,470.00 $2,470.00 Replacement fund too low difference is $-682.00 Cost too low difference is $-682.00 Expense 640.000.03 Reserve Studies $2,215.00 $0.00 $2,215.00 640.000.03 Reserve Studies $1,600.00 $0.00 $1,600.00 Operating fund too high difference is $615.00 Cost too high difference is $615.00 640.000.05 General Administrative $22,003.00 $95.00 $22,098.00 640.000.05 General Administrative $22,717.00 $0.00 $22,717.00 Operating fund too low difference is $-714.00 Replacement fund too high difference is $95.00 Cost too low difference is $-619.00 640.000.07 Office supplies/printing/postage $17,621.00 $0.00 $17,621.00 640.000.07 Office supplies/printing/postage $15,725.00 $0.00 $15,725.00 Operating fund too high difference is $1,896.00 Cost too high difference is $1,896.00 700.000.01 Insurance $14,710.00 $0.00 $14,710.00 700.000.01 Insurance $15,633.00 $0.00 $15,633.00 Operating fund too low difference is $-923.00 Cost too low difference is $-923.00 720.000.08 Landscape Expense $136,661.00 $35,030.00 $171,691.00 720.000.08 Landscape Expense $137,827.00 $0.00 $137,827.00 Replacement fund too high difference is $35,030.00 Cost too high difference is $33,864.00 760.000.04 Management Fees $60,000.00 $0.00 $60,000.00 760.000.04 Management Fees $60,000.00 $0.00 $60,000.00 Total costs unchanged 760.000.07 Legal and collection $5,223.00 $0.00 $5,223.00 760.000.07 Legal and collection $3,269.00 $0.00 $3,269.00 Operating fund too high difference is $1,954.00 Cost too high difference is $1,954.00 780.000.01 Property Protection - Patrol Service $41,384.00 $0.00 $41,384.00 780.000.01 Property Protection - Patrol Service $36,608.00 $0.00 $36,608.00 Operating fund too high difference is $4,776.00 Cost too high difference is $4,776.00 840.001.05 General Repair & Maintenance $51,340.00 $0.00 $51,340.00 840.001.05 General Repair & Maintenance $16,949.00 $9,120.00 $26,069.00 Operating fund too high difference is $34,391.00 Replacement fund too low difference is $-9,120.00 Cost too high difference is $25,271.00 840.001.13 Streets & Drives $0.00 $2,335.00 $2,335.00 Deleted Asset(s) Expense 840.002.04 Janitorial Combined Costs $14,314.00 $0.00 $14,314.00 840.002.04 Janitorial Combined Costs $12,168.00 $0.00 $12,168.00 Operating fund too high difference is $2,146.00 Cost too high difference is $2,146.00 840.004.03 Pest Control $1,488.00 $0.00 $1,488.00 840.004.03 Pest Control $1,209.00 $0.00 $1,209.00 Operating fund too high difference is $279.00 Cost too high difference is $279.00 840.006.03 Pool Supplies/Repair & Maintenance $45,851.00 $144,754.00 $190,605.00 840.006.03 Pool Supplies/Repair & Maintenance $33,838.00 $5,400.00 $39,238.00 Operating fund too high difference is $12,013.00 Replacement fund too high difference is $139,354.00 Cost too high difference is $151,367.00 860.000.01 Electric Service $29,153.00 $0.00 $29,153.00 860.000.01 Electric Service $26,803.00 $0.00 $26,803.00 Operating fund too high difference is $2,350.00 Cost too high difference is $2,350.00 860.000.02 Gas Service $12,106.00 $0.00 $12,106.00 860.000.02 Gas Service $9,075.00 $0.00 $9,075.00 Operating fund too high difference is $3,031.00 Cost too high difference is $3,031.00 860.000.04 Trash and Recycling Service $1,831.00 $0.00 $1,831.00 860.000.04 Trash and Recycling Service $1,499.00 $0.00 $1,499.00 Operating fund too high difference is $332.00 Cost too high difference is $332.00 880.000.01 Federal Income Tax $26.00 $483.00 $509.00 880.000.01 Federal Income Tax $0.00 $747.00 $747.00 Operating fund too high difference is $26.00 Replacement fund too low difference is $-264.00 Cost too low difference is $-238.00 900.000.05 Bad debt expense $5,729.00 $0.00 $5,729.00 900.000.05 Bad debt expense $3,849.00 $0.00 $3,849.00 Operating fund too high difference is $1,880.00 Cost too high difference is $1,880.00 2012 - 2013 Analysis Summary Estimated inflation 3% Consumer Price Index 2.1% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2012 $500,858.00 $155,170.00 $656,028.00 Revenue 2013 $524,639.00 $138,099.00 $662,738.00 Expense 2012 $432,400.00 $17,602.00 $450,002.00 Expense 2013 $496,140.00 $180,362.00 $676,502.00 revenue - expense 2012 $68,458.00 $137,568.00 $206,026.00 revenue - expense 2013 $28,499.00 $-42,263.00 $-13,764.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $-39,959.00 $-179,831.00 $-219,790.00 percent difference -58.37% -130.72% -106.68% Total Assets 24 Total Issues 91 Issues/Asset 3.79 count % Description 1 4.17% Deleted Asset(s) 15 62.50% Operating fund too high 2 8.33% Operating fund too low 3 12.50% Replacement fund too high 4 16.67% Replacement fund too low 15 62.50% Cost too high 4 16.67% Cost too low 1 4.17% Total costs unchanged 1 4.17% Totals costs unchanged Park Paseo Homeowners Association RDA Forensic Analysis For 2012 to 2013 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 010.000.01 Overlay/Rehab Overlay/Rehab 6 20 $11,455.00 $8,102.00 $0.00 010.000.01 Overlay/Rehab Overlay/Rehab 5 20 $11,691.00 $8,839.00 $0.00 No assigned value 010.000.03 Asphalt Repairs Asphalt Repairs 0 3 $2,432.00 $2,432.00 $2,432.00 010.000.03 Asphalt Repairs Asphalt Repairs 2 3 $2,495.00 $430.00 $430.00 Maintenance completed 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 0 3 $2,511.00 $2,511.00 $2,511.00 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 2 3 $2,338.00 $403.00 $403.00 Maintenance completed 020.000.03 Clubhouse, Tile Clubhouse, Tile 34 50 $24,929.00 $7,949.00 $0.00 020.000.03 Clubhouse, Tile Clubhouse, Tile 18 35 $25,528.00 $12,368.00 $0.00 Remaining life decreased too much Useful life decreased No assigned value 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 11 18 $1,248.00 $471.00 $0.00 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 10 18 $1,278.00 $555.00 $0.00 No assigned value 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 49 50 $10,696.00 $214.00 $0.00 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 48 50 $10,985.00 $439.00 $0.00 No assigned value 030.001.01 Aluminum, Pools Aluminum, Pools 13 10 $9,709.00 $1,295.00 $0.00 030.001.01 Aluminum, Pools Aluminum, Pools 22 25 $9,942.00 $1,193.00 $0.00 Remaining life increased Useful life increased No assigned value 030.001.03 Interior Prosa R Interior Prosa Restrooms 7 8 $1,500.00 $115.00 $0.00 030.001.03 Interior Prosa R Interior Prosa Restrooms 7 8 $1,540.00 $118.00 $0.00 Remaining life not changed Fully funded value too low should be $193.12 No assigned value 030.001.05 Spa Equipment Ro Spa Equipment Room 4 5 $2,618.00 $333.00 $0.00 030.001.05 Spa Equipment Ro Spa Equipment Room 3 5 $2,684.00 $927.00 $927.00 Fully funded value too low should be $1,078.62 Assigned value too low should be $1,078.62 030.001.06 Stucco Stucco 9 10 $3,000.00 $158.00 $0.00 030.001.06 Stucco Stucco 8 10 $3,081.00 $486.00 $0.00 Fully funded value too low should be $618.00 No assigned value 030.001.07 Woodwork Prosa Woodwork Prosa 4 5 $3,082.00 $392.00 $0.00 030.001.07 Woodwork Prosa Woodwork Prosa 3 5 $3,159.00 $1,091.00 $1,091.00 Fully funded value too low should be $1,269.78 Assigned value too low should be $1,269.78 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 4 5 $11,244.00 $1,431.00 $0.00 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 3 5 $11,525.00 $3,981.00 $3,981.00 Fully funded value too low should be $4,632.53 Assigned value too low should be $4,632.53 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 28 30 $132,841.00 $7,814.00 $0.00 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 27 30 $136,427.00 $12,611.00 $0.00 Fully funded value too low should be $13,682.62 No assigned value 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 23 25 $47,648.00 $3,812.00 $0.00 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 22 25 $48,934.00 $5,872.00 $0.00 No assigned value 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 19 20 $882.00 $19.00 $0.00 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 18 20 $906.00 $66.00 $0.00 Fully funded value too low should be $90.85 No assigned value 040.000.04 W/I, Delamesa/Ca W/I, Delamesa/Campanero 19 20 $6,190.00 $310.00 $0.00 040.000.04 W/I, Delamesa/Ca W/I, Delamesa/Campanero 18 20 $6,357.00 $636.00 $0.00 No assigned value 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 19 20 $2,500.00 $74.00 $0.00 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 18 20 $2,500.00 $202.00 $0.00 Cost not changed 050.000.03 Exterior, Parkin Exterior, Parking Lot 10 22 $1,335.00 $707.00 $0.00 050.000.03 Exterior, Parkin Exterior, Parking Lot 9 22 $1,371.00 $790.00 $0.00 No assigned value 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 0 15 $87,380.00 $87,380.00 $87,380.00 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 0 15 $89,675.00 $89,675.00 $89,675.00 Maintenance deferred 060.001.08 Exterior Stairca Exterior Staircase 24 30 $17,176.00 $3,202.00 $0.00 060.001.08 Exterior Stairca Exterior Staircase 23 30 $17,639.00 $3,887.00 $0.00 Fully funded value too low should be $4,127.97 No assigned value 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 18 25 $17,086.00 $4,618.00 $0.00 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 17 25 $17,547.00 $5,454.00 $0.00 No assigned value 060.001.10 Furnishings Furnishings 4 10 $30,000.00 $18,000.00 $0.00 060.001.10 Furnishings Furnishings 3 10 $30,000.00 $21,000.00 $21,000.00 Cost not changed 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 16 20 $3,265.00 $653.00 $0.00 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 15 20 $3,320.00 $830.00 $0.00 No assigned value 060.001.16 Wallpaper Wallpaper 8 15 $12,700.00 $5,773.00 $0.00 060.001.16 Wallpaper Wallpaper 7 15 $13,041.00 $6,817.00 $0.00 No assigned value 060.001.18 Carpeting Carpeting 0 8 $11,323.00 $11,323.00 $11,323.00 060.001.18 Carpeting Carpeting 0 8 $11,627.00 $11,627.00 $11,627.00 Maintenance deferred 060.002.01 Doors, Double Sl Doors, Double Slide 25 25 $6,500.00 $0.00 $0.00 060.002.01 Doors, Double Sl Doors, Double Slide 24 25 $6,675.00 $267.00 $0.00 No assigned value 060.002.02 Doors, Exterior, Doors, Exterior, Entry 18 25 $12,090.00 $3,268.00 $0.00 060.002.02 Doors, Exterior, Doors, Exterior, Entry 17 25 $12,416.00 $3,859.00 $0.00 No assigned value 060.002.03 Doors, Entry Doors, Entry 0 25 $14,448.00 $14,448.00 $14,448.00 060.002.03 Doors, Entry Doors, Entry 0 25 $14,838.00 $14,838.00 $14,838.00 Maintenance deferred 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 5 25 $2,236.00 $1,957.00 $0.00 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 4 25 $2,296.00 $2,066.00 $2,066.00 Fully funded value too high should be $1,934.59 Assigned value too high should be $1,934.59 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 18 25 $22,731.00 $6,144.00 $0.00 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 17 25 $23,344.00 $7,256.00 $0.00 No assigned value 060.003.08 Kitchen, Sink Kitchen, Sink 18 25 $723.00 $195.00 $0.00 060.003.08 Kitchen, Sink Kitchen, Sink 17 25 $742.00 $231.00 $0.00 No assigned value 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 5 8 $10,000.00 $4,915.00 $0.00 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 4 8 $10,000.00 $5,932.00 $5,932.00 Cost not changed 060.004.10 Office, Remodel Office, Remodel 15 20 $11,958.00 $2,914.00 $0.00 060.004.10 Office, Remodel Office, Remodel 14 20 $12,280.00 $3,612.00 $0.00 No assigned value 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 22 25 $10,730.00 $1,288.00 $0.00 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 21 25 $11,063.00 $1,770.00 $0.00 No assigned value 060.005.03 Restroom, Counte Restroom, Counters 17 20 $3,600.00 $540.00 $0.00 060.005.03 Restroom, Counte Restroom, Counters 16 20 $3,712.00 $742.00 $0.00 No assigned value 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 22 25 $2,136.00 $256.00 $0.00 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 21 25 $2,178.00 $348.00 $0.00 No assigned value 060.005.07 Restroom, Locker Restroom, Lockers/Benches 19 22 $20,000.00 $2,727.00 $0.00 060.005.07 Restroom, Locker Restroom, Lockers/Benches 18 22 $20,000.00 $3,636.00 $0.00 Cost not changed 060.005.08 Restroom, Partit Restroom, Partitions 17 20 $4,830.00 $725.00 $0.00 060.005.08 Restroom, Partit Restroom, Partitions 16 20 $4,935.00 $987.00 $0.00 No assigned value 060.005.10 Restroom, Shower Restroom, Shower Door 13 16 $1,816.00 $341.00 $0.00 060.005.10 Restroom, Shower Restroom, Shower Door 12 16 $1,848.00 $462.00 $0.00 No assigned value 060.005.12 Women's Shower Women's Shower 0 25 $10,500.00 $10,500.00 $10,500.00 060.005.12 Women's Shower Women's Shower 24 25 $3,237.00 $109.00 $0.00 Maintenance completed 060.005.13 Restroom, Fixtur Restroom, Fixtures 22 25 $6,636.00 $796.00 $0.00 060.005.13 Restroom, Fixtur Restroom, Fixtures 21 25 $6,845.00 $1,095.00 $0.00 No assigned value 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 1 14 $54,484.00 $51,061.00 $51,061.00 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 14 14 $71,725.00 $0.00 $0.00 Maintenance completed 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 0 8 $1,054.00 $1,054.00 $1,054.00 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 0 8 $1,082.00 $1,082.00 $1,082.00 Maintenance deferred 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 0 12 $7,196.00 $7,196.00 $7,196.00 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 12 12 $8,770.00 $0.00 $0.00 Maintenance completed 065.003.02 Wader, Heater Wader, Heater 6 12 $2,878.00 $1,376.00 $0.00 065.003.02 Wader, Heater Wader, Heater 5 12 $2,955.00 $1,670.00 $0.00 No assigned value 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 0 14 $5,140.00 $5,140.00 $5,140.00 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 14 14 $9,100.00 $0.00 $0.00 Maintenance completed 067.001.03 Barbecues Barbecues 4 5 $4,451.00 $566.00 $0.00 067.001.03 Barbecues Barbecues 3 5 $4,571.00 $1,579.00 $1,579.00 Fully funded value too low should be $1,833.81 Assigned value too low should be $1,833.81 067.001.05 Ceramic Shower Ceramic Shower 3 25 $1,976.00 $1,820.00 $1,820.00 067.001.05 Ceramic Shower Ceramic Shower 2 25 $1,976.00 $1,872.00 $1,872.00 Cost not changed 067.002.02 Deck Caulking Deck Caulking 0 4 $10,500.00 $10,500.00 $10,500.00 067.002.02 Deck Caulking Deck Caulking 4 4 $10,780.00 $0.00 $0.00 Maintenance completed 067.002.03 Deck Repairs Deck Repairs 0 30 $11,582.00 $11,582.00 $11,582.00 067.002.03 Deck Repairs Deck Repairs 0 30 $11,917.00 $11,917.00 $11,917.00 Maintenance deferred 069.001.01 Filter, Prosa Filter, Prosa 8 12 $1,491.00 $461.00 $0.00 069.001.01 Filter, Prosa Filter, Prosa 7 12 $1,531.00 $606.00 $0.00 Fully funded value too low should be $639.89 No assigned value 069.001.02 Filter, 2010 Filter, 2010 10 12 $1,491.00 $249.00 $0.00 069.001.02 Filter, 2010 Filter, 2010 9 12 $1,531.00 $383.00 $0.00 No assigned value 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 0 14 $30,840.00 $30,840.00 $30,840.00 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 14 14 $31,350.00 $0.00 $0.00 Maintenance completed 070.001.01 Aluminum Trellis Aluminum Trellis 28 30 $10,884.00 $726.00 $0.00 070.001.01 Aluminum Trellis Aluminum Trellis 27 30 $11,177.00 $1,118.00 $0.00 No assigned value 070.001.02 Barbecues Barbecues 7 8 $3,639.00 $204.00 $0.00 070.001.02 Barbecues Barbecues 6 8 $3,737.00 $714.00 $0.00 Fully funded value too low should be $937.04 No assigned value 070.001.09 Wood, Repairs Wood, Repairs 4 5 $3,500.00 $700.00 $0.00 070.001.09 Wood, Repairs Wood, Repairs 3 5 $3,500.00 $1,400.00 $1,400.00 Cost not changed 070.003.01 Deck, Caulking Deck, Caulking 0 4 $3,150.00 $3,150.00 $3,150.00 070.003.01 Deck, Caulking Deck, Caulking 4 4 $3,231.00 $0.00 $0.00 Maintenance completed 070.003.02 Deck, Repairs Deck, Repairs 0 30 $5,724.00 $5,724.00 $5,724.00 070.003.02 Deck, Repairs Deck, Repairs 0 30 $5,890.00 $5,890.00 $5,890.00 Maintenance deferred 070.004.01 Water Heater Water Heater 0 18 $3,278.00 $3,278.00 $3,278.00 070.004.01 Water Heater Water Heater 0 18 $3,366.00 $3,366.00 $3,366.00 Maintenance deferred 080.000.01 Benches Benches 14 15 $18,508.00 $1,234.00 $0.00 080.000.01 Benches Benches 13 15 $18,998.00 $2,533.00 $0.00 No assigned value 080.000.05 Lighting Lighting 5 25 $12,432.00 $10,878.00 $0.00 080.000.05 Lighting Lighting 4 25 $12,816.00 $11,534.00 $4,974.00 Fully funded value too high should be $10,756.17 Assigned value too low should be $10,756.17 080.000.06 Resurfacing Resurfacing 0 6 $11,520.00 $11,520.00 $11,520.00 080.000.06 Resurfacing Resurfacing 0 6 $11,808.00 $11,808.00 $11,808.00 Maintenance deferred 080.000.07 Windscreen Windscreen 0 6 $3,124.00 $3,124.00 $3,124.00 080.000.07 Windscreen Windscreen 0 6 $3,203.00 $3,203.00 $3,203.00 Maintenance deferred 085.001.01 Benches Benches 11 12 $10,585.00 $814.00 $0.00 085.001.01 Benches Benches 10 12 $10,870.00 $1,748.00 $0.00 No assigned value 085.001.02 Trash Cans Trash Cans 14 15 $9,972.00 $665.00 $0.00 085.001.02 Trash Cans Trash Cans 13 15 $10,233.00 $1,364.00 $0.00 No assigned value 085.002.01 Drinking Fountai Drinking Fountain, C/H 15 16 $2,749.00 $74.00 $0.00 085.002.01 Drinking Fountai Drinking Fountain, C/H 14 16 $2,823.00 $259.00 $0.00 Fully funded value too low should be $353.93 No assigned value 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $6,168.00 $6,168.00 $6,168.00 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $6,335.00 $6,335.00 $6,335.00 Maintenance deferred 090.000.02 Trellis, Clubhou Trellis, Clubhouse 29 30 $41,358.00 $816.00 $0.00 090.000.02 Trellis, Clubhou Trellis, Clubhouse 28 30 $42,474.00 $2,273.00 $0.00 Fully funded value too low should be $2,839.92 No assigned value 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 0 4 $9,000.00 $9,000.00 $9,000.00 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 3 4 $9,000.00 $1,957.00 $1,957.00 Maintenance completed Cost not changed 095.002.06 Tree Trimming, W Tree Trimming, Windrow 1 3 $30,000.00 $19,412.00 $19,412.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.03 Irrigation, Cont Irrigation, Controller Enclosures 0 24 $24,672.00 $24,672.00 $24,672.00 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 24 $25,338.00 $25,338.00 $25,338.00 Maintenance deferred 100.000.02 Monument Monument 0 30 $3,084.00 $3,084.00 $3,084.00 100.000.02 Monument Monument 0 30 $3,105.00 $3,105.00 $3,105.00 Maintenance deferred 105.000.01 Termite Control/ Termite Control/Fumigation 0 15 $4,780.00 $4,780.00 $4,780.00 105.000.01 Termite Control/ Termite Control/Fumigation 0 15 $4,889.00 $4,889.00 $4,889.00 Maintenance deferred 2012 - 2013 RDA Forensic Analysis Summary Estimated inflation 3% Consumer Price Index 2.1% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $1,335,132.00 $790,377.00 $628,863.00 This Year Costs $1,380,240.00 $746,394.00 $641,629.00 Calculated Costs $1,384,447.09 $747,102.11 $747,102.11 Comparing This Year Costs to Last Year Costs Difference $45,108.00 $-43,983.00 $12,766.00 percent difference 3.38% -5.56% 2.03% Comparing This Year Costs to Calculated Costs Difference $-4,207.09 $-708.11 $-105,473.11 percent difference -0.30% -0.09% -16.44% 118 Total Assets 26 Total Issues $230,346.16 Unfunded Liability 0.22 Issues / Asset number % Description 37 31.36% No assigned value 2 1.69% Fully funded value too high 13 11.02% Fully funded value too low 1 0.85% Assigned value too high 5 4.24% Assigned value too low 1 0.85% Remaining life not changed 1 0.85% Remaining life increased 1 0.85% Remaining life decreased too much 1 0.85% Useful life increased 1 0.85% Useful life decreased 13 11.02% Maintenance deferred 10 8.47% Maintenance completed 22 18.64% Total assets to be maintained 8 6.78% Cost not changed