Park Paseo Homeowners Association Audited Forensic Report For 2013 to 2014 Revenue 520.000.01 Clubhouse Rental Fee $8,625.00 $0.00 $8,625.00 520.000.01 Clubhouse Rental Fee $10,850.00 $0.00 $10,850.00 Operating fund too low difference is $-2,225.00 Cost too low difference is $-2,225.00 540.000.05 Miscellaneous Income $850.00 $0.00 $850.00 Added Asset(s) Revenue 540.000.10 Other Income $9,212.00 $9,330.00 $18,542.00 540.000.10 Other Income $12,600.00 $0.00 $12,600.00 Operating fund too low difference is $-3,388.00 Replacement fund too high difference is $9,330.00 Cost too high difference is $5,942.00 550.000.03 Investment Income $0.00 $2,201.00 $2,201.00 550.000.03 Investment Income $0.00 $1,788.00 $1,788.00 Replacement fund too high difference is $413.00 Cost too high difference is $413.00 Expense 640.000.03 Reserve Studies $1,695.00 $0.00 $1,695.00 640.000.03 Reserve Studies $2,215.00 $0.00 $2,215.00 Operating fund too low difference is $-520.00 Cost too low difference is $-520.00 640.000.05 General Administrative $11,347.00 $0.00 $11,347.00 640.000.05 General Administrative $22,003.00 $95.00 $22,098.00 Operating fund too low difference is $-10,656.00 Replacement fund too low difference is $-95.00 Cost too low difference is $-10,751.00 640.000.07 Office supplies/printing/postage $13,283.00 $0.00 $13,283.00 640.000.07 Office supplies/printing/postage $17,621.00 $0.00 $17,621.00 Operating fund too low difference is $-4,338.00 Cost too low difference is $-4,338.00 720.000.08 Landscape Expense $158,714.00 $43,104.00 $201,818.00 720.000.08 Landscape Expense $136,661.00 $35,030.00 $171,691.00 Operating fund too high difference is $22,053.00 Replacement fund too high difference is $8,074.00 Cost too high difference is $30,127.00 760.000.01 Audit & Tax Services $1,800.00 $0.00 $1,800.00 760.000.01 Audit & Tax Services $1,800.00 $0.00 $1,800.00 Total costs unchanged 760.000.04 Management Fees $80,400.00 $0.00 $80,400.00 760.000.04 Management Fees $60,000.00 $0.00 $60,000.00 Operating fund too high difference is $20,400.00 Cost too high difference is $20,400.00 760.000.07 Legal and collection $13,747.00 $0.00 $13,747.00 760.000.07 Legal and collection $5,223.00 $0.00 $5,223.00 Operating fund too high difference is $8,524.00 Cost too high difference is $8,524.00 780.000.01 Property Protection - Patrol Service $34,427.00 $0.00 $34,427.00 780.000.01 Property Protection - Patrol Service $41,384.00 $0.00 $41,384.00 Operating fund too low difference is $-6,957.00 Cost too low difference is $-6,957.00 840.001.05 General Repair & Maintenance $26,458.00 $0.00 $26,458.00 840.001.05 General Repair & Maintenance $51,340.00 $0.00 $51,340.00 Operating fund too low difference is $-24,882.00 Cost too low difference is $-24,882.00 840.002.04 Janitorial Combined Costs $13,729.00 $0.00 $13,729.00 840.002.04 Janitorial Combined Costs $14,314.00 $0.00 $14,314.00 Operating fund too low difference is $-585.00 Cost too low difference is $-585.00 840.004.03 Pest Control $5,708.00 $0.00 $5,708.00 840.004.03 Pest Control $1,488.00 $0.00 $1,488.00 Operating fund too high difference is $4,220.00 Cost too high difference is $4,220.00 840.006.03 Pool Supplies/Repair & Maintenance $33,071.00 $51,999.00 $85,070.00 840.006.03 Pool Supplies/Repair & Maintenance $45,851.00 $144,754.00 $190,605.00 Operating fund too low difference is $-12,780.00 Replacement fund too low difference is $-92,755.00 Cost too low difference is $-105,535.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $6,970.00 $6,970.00 Added Asset(s) Expense 860.000.02 Gas Service $13,838.00 $0.00 $13,838.00 860.000.02 Gas Service $12,106.00 $0.00 $12,106.00 Operating fund too high difference is $1,732.00 Cost too high difference is $1,732.00 860.000.04 Trash and Recycling Service $2,261.00 $0.00 $2,261.00 860.000.04 Trash and Recycling Service $1,831.00 $0.00 $1,831.00 Operating fund too high difference is $430.00 Cost too high difference is $430.00 860.000.05 Water Service $37,530.00 $0.00 $37,530.00 860.000.05 Water Service $28,825.00 $0.00 $28,825.00 Operating fund too high difference is $8,705.00 Cost too high difference is $8,705.00 880.000.01 Federal Income Tax $10.00 $609.00 $619.00 880.000.01 Federal Income Tax $26.00 $483.00 $509.00 Operating fund too low difference is $-16.00 Replacement fund too high difference is $126.00 Cost too high difference is $110.00 900.000.05 Bad debt expense $7,569.00 $0.00 $7,569.00 Added Asset(s) Expense 920.000.07 Clubhouse Reserve $0.00 $35,497.00 $35,497.00 Added Asset(s) Expense 920.000.14 Roof Building $0.00 $32,970.00 $32,970.00 Added Asset(s) Expense 2013 - 2014 Analysis Summary Estimated inflation 2.7% Consumer Price Index 1.5% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2013 $525,489.00 $138,099.00 $663,588.00 Revenue 2014 $541,361.00 $155,507.00 $696,868.00 Expense 2013 $490,411.00 $187,332.00 $677,743.00 Expense 2014 $506,091.00 $164,179.00 $670,270.00 revenue - expense 2013 $35,078.00 $-49,233.00 $-14,155.00 revenue - expense 2014 $35,270.00 $-8,672.00 $26,598.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $192.00 $40,561.00 $40,753.00 percent difference 100.55% 17.61% -187.91% Total Assets 23 Total Issues 89 Issues/Asset 3.87 count % Description 5 21.74% Added Asset(s) 7 30.43% Operating fund too high 10 43.48% Operating fund too low 4 17.39% Replacement fund too high 2 8.70% Replacement fund too low 10 43.48% Cost too high 8 34.78% Cost too low 1 4.35% Total costs unchanged Park Paseo Homeowners Association UnAudited Forensic Report For 2013 to 2014 Revenue 520.000.01 Clubhouse Rental Fee $8,625.00 $0.00 $8,625.00 520.000.01 Clubhouse Rental Fee $10,850.00 $0.00 $10,850.00 Operating fund too low difference is $-2,225.00 Cost too low difference is $-2,225.00 540.000.05 Miscellaneous Income $850.00 $0.00 $850.00 Added Asset(s) Revenue 540.000.10 Other Income $9,212.00 $9,330.00 $18,542.00 540.000.10 Other Income $12,600.00 $0.00 $12,600.00 Operating fund too low difference is $-3,388.00 Replacement fund too high difference is $9,330.00 Cost too high difference is $5,942.00 550.000.03 Investment Income $0.00 $2,201.00 $2,201.00 550.000.03 Investment Income $0.00 $1,788.00 $1,788.00 Replacement fund too high difference is $413.00 Cost too high difference is $413.00 Expense 640.000.03 Reserve Studies $1,695.00 $0.00 $1,695.00 640.000.03 Reserve Studies $2,215.00 $0.00 $2,215.00 Operating fund too low difference is $-520.00 Cost too low difference is $-520.00 640.000.05 General Administrative $11,347.00 $0.00 $11,347.00 640.000.05 General Administrative $22,003.00 $95.00 $22,098.00 Operating fund too low difference is $-10,656.00 Replacement fund too low difference is $-95.00 Cost too low difference is $-10,751.00 640.000.07 Office supplies/printing/postage $13,283.00 $0.00 $13,283.00 640.000.07 Office supplies/printing/postage $17,621.00 $0.00 $17,621.00 Operating fund too low difference is $-4,338.00 Cost too low difference is $-4,338.00 720.000.08 Landscape Expense $158,714.00 $43,104.00 $201,818.00 720.000.08 Landscape Expense $136,661.00 $35,030.00 $171,691.00 Operating fund too high difference is $22,053.00 Replacement fund too high difference is $8,074.00 Cost too high difference is $30,127.00 760.000.01 Audit & Tax Services $1,800.00 $0.00 $1,800.00 760.000.01 Audit & Tax Services $1,800.00 $0.00 $1,800.00 Total costs unchanged 760.000.04 Management Fees $80,400.00 $0.00 $80,400.00 760.000.04 Management Fees $60,000.00 $0.00 $60,000.00 Operating fund too high difference is $20,400.00 Cost too high difference is $20,400.00 760.000.07 Legal and collection $13,747.00 $0.00 $13,747.00 760.000.07 Legal and collection $5,223.00 $0.00 $5,223.00 Operating fund too high difference is $8,524.00 Cost too high difference is $8,524.00 780.000.01 Property Protection - Patrol Service $34,427.00 $0.00 $34,427.00 780.000.01 Property Protection - Patrol Service $41,384.00 $0.00 $41,384.00 Operating fund too low difference is $-6,957.00 Cost too low difference is $-6,957.00 840.001.05 General Repair & Maintenance $26,458.00 $0.00 $26,458.00 840.001.05 General Repair & Maintenance $51,340.00 $0.00 $51,340.00 Operating fund too low difference is $-24,882.00 Cost too low difference is $-24,882.00 840.002.04 Janitorial Combined Costs $13,729.00 $0.00 $13,729.00 840.002.04 Janitorial Combined Costs $14,314.00 $0.00 $14,314.00 Operating fund too low difference is $-585.00 Cost too low difference is $-585.00 840.004.03 Pest Control $5,708.00 $0.00 $5,708.00 840.004.03 Pest Control $1,488.00 $0.00 $1,488.00 Operating fund too high difference is $4,220.00 Cost too high difference is $4,220.00 840.006.03 Pool Supplies/Repair & Maintenance $33,071.00 $51,999.00 $85,070.00 840.006.03 Pool Supplies/Repair & Maintenance $45,851.00 $144,754.00 $190,605.00 Operating fund too low difference is $-12,780.00 Replacement fund too low difference is $-92,755.00 Cost too low difference is $-105,535.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $6,970.00 $6,970.00 Added Asset(s) Expense 860.000.02 Gas Service $13,838.00 $0.00 $13,838.00 860.000.02 Gas Service $12,106.00 $0.00 $12,106.00 Operating fund too high difference is $1,732.00 Cost too high difference is $1,732.00 860.000.04 Trash and Recycling Service $2,261.00 $0.00 $2,261.00 860.000.04 Trash and Recycling Service $1,831.00 $0.00 $1,831.00 Operating fund too high difference is $430.00 Cost too high difference is $430.00 860.000.05 Water Service $37,530.00 $0.00 $37,530.00 860.000.05 Water Service $28,825.00 $0.00 $28,825.00 Operating fund too high difference is $8,705.00 Cost too high difference is $8,705.00 880.000.01 Federal Income Tax $10.00 $609.00 $619.00 880.000.01 Federal Income Tax $26.00 $483.00 $509.00 Operating fund too low difference is $-16.00 Replacement fund too high difference is $126.00 Cost too high difference is $110.00 900.000.05 Bad debt expense $7,569.00 $0.00 $7,569.00 Added Asset(s) Expense 920.000.07 Clubhouse Reserve $0.00 $35,497.00 $35,497.00 Added Asset(s) Expense 920.000.14 Roof Building $0.00 $32,970.00 $32,970.00 Added Asset(s) Expense 2013 - 2014 Analysis Summary Estimated inflation 2.7% Consumer Price Index 1.5% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2013 $525,489.00 $138,099.00 $663,588.00 Revenue 2014 $541,361.00 $155,507.00 $696,868.00 Expense 2013 $490,411.00 $187,332.00 $677,743.00 Expense 2014 $506,091.00 $164,179.00 $670,270.00 revenue - expense 2013 $35,078.00 $-49,233.00 $-14,155.00 revenue - expense 2014 $35,270.00 $-8,672.00 $26,598.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $192.00 $40,561.00 $40,753.00 percent difference 100.55% 17.61% -187.91% Total Assets 23 Total Issues 89 Issues/Asset 3.87 count % Description 5 21.74% Added Asset(s) 7 30.43% Operating fund too high 10 43.48% Operating fund too low 4 17.39% Replacement fund too high 2 8.70% Replacement fund too low 10 43.48% Cost too high 8 34.78% Cost too low 1 4.35% Total costs unchanged Park Paseo Homeowners Association RDA Forensic Analysis For 2013 to 2014 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 010.000.03 Asphalt Repairs Asphalt Repairs 2 3 $2,495.00 $430.00 $430.00 010.000.03 Asphalt Repairs Asphalt Repairs 1 3 $2,542.00 $1,490.20 $1,490.20 Fully funded value too low should be $1,708.24 Assigned value too low should be $1,708.24 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 2 3 $2,338.00 $403.00 $403.00 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 1 3 $2,377.00 $1,394.00 $1,394.00 Fully funded value too low should be $1,600.75 Assigned value too low should be $1,600.75 020.000.03 Clubhouse, Tile Clubhouse, Tile 18 35 $25,528.00 $12,368.00 $0.00 020.000.03 Clubhouse, Tile Clubhouse, Tile 0 35 $54,000.00 $54,000.00 $54,000.00 Remaining life decreased too much Cost value too high should be $26,217.26 Fully funded value too high should be $26,217.26 Assigned value too high should be $26,217.26 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 48 50 $10,985.00 $439.00 $0.00 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 47 50 $11,204.00 $672.00 $0.00 No assigned value 030.001.01 Aluminum, Pools Aluminum, Pools 22 25 $9,942.00 $1,193.00 $0.00 030.001.01 Aluminum, Pools Aluminum, Pools 21 25 $10,116.00 $1,619.00 $0.00 No assigned value 030.001.03 Interior Prosa R Interior Prosa Restrooms 7 8 $1,540.00 $118.00 $0.00 030.001.03 Interior Prosa R Interior Prosa Restrooms 6 8 $1,570.00 $328.00 $328.00 Fully funded value too low should be $395.39 Assigned value too low should be $395.39 030.001.05 Spa Equipment Ro Spa Equipment Room 3 5 $2,684.00 $927.00 $927.00 030.001.05 Spa Equipment Ro Spa Equipment Room 2 5 $2,728.00 $1,538.00 $1,538.00 Fully funded value too low should be $1,653.88 Assigned value too low should be $1,653.88 030.001.06 Stucco Stucco 8 10 $3,081.00 $486.00 $0.00 030.001.06 Stucco Stucco 7 10 $3,142.00 $827.00 $827.00 Fully funded value too low should be $949.26 Assigned value too low should be $949.26 030.001.07 Woodwork Prosa Woodwork Prosa 3 5 $3,159.00 $1,091.00 $1,091.00 030.001.07 Woodwork Prosa Woodwork Prosa 2 5 $3,210.00 $1,809.00 $1,809.00 Fully funded value too low should be $1,946.58 Assigned value too low should be $1,946.58 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 3 5 $11,525.00 $3,981.00 $3,981.00 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 2 5 $11,713.00 $6,602.00 $6,602.00 Fully funded value too low should be $7,101.70 Assigned value too low should be $7,101.70 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 27 30 $136,427.00 $12,611.00 $0.00 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 26 30 $139,155.00 $17,540.00 $0.00 Fully funded value too low should be $18,681.40 No assigned value 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 22 25 $48,934.00 $5,872.00 $0.00 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 21 25 $49,912.00 $7,986.00 $0.00 No assigned value 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 18 20 $906.00 $66.00 $0.00 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 17 20 $924.00 $115.00 $0.00 Fully funded value too low should be $139.57 No assigned value 040.000.04 W/I, Delamesa/Ca W/I, Delamesa/Campanero 18 20 $6,357.00 $636.00 $0.00 040.000.04 W/I, Delamesa/Ca W/I, Delamesa/Campanero 17 20 $6,483.00 $972.00 $0.00 No assigned value 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 18 20 $2,500.00 $202.00 $0.00 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 17 20 $2,500.00 $330.00 $0.00 Cost not changed 050.000.01 Exterior, Pool/C Exterior, Pool/Club 0 10 $13,120.00 $13,120.00 $13,120.00 050.000.01 Exterior, Pool/C Exterior, Pool/Club 0 10 $13,350.00 $13,350.00 $13,350.00 Maintenance deferred 050.000.05 Exterior, Prosa Exterior, Prosa 0 10 $2,530.00 $2,530.00 $2,530.00 050.000.05 Exterior, Prosa Exterior, Prosa 0 10 $2,580.00 $2,580.00 $2,580.00 Maintenance deferred 050.000.07 Parking Lot, Ori Parking Lot, Original 1 22 $6,855.00 $6,670.00 $6,670.00 050.000.07 Parking Lot, Ori Parking Lot, Original 2 22 $6,990.00 $6,632.00 $6,632.00 Remaining life increased 050.000.08 Interior Prosa C Interior Prosa Cabana 1 25 $1,678.00 $1,626.00 $1,626.00 050.000.08 Interior Prosa C Interior Prosa Cabana 3 25 $1,704.00 $1,558.00 $1,558.00 Remaining life increased 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 0 15 $89,675.00 $89,675.00 $89,675.00 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 0 15 $110,000.00 $110,000.00 $110,000.00 Maintenance deferred Cost value too high should be $92,096.22 Fully funded value too high should be $92,096.22 Assigned value too high should be $92,096.22 060.001.02 Billiard Tables Billiard Tables 1 25 $9,458.00 $9,202.00 $9,202.00 060.001.02 Billiard Tables Billiard Tables 3 25 $9,598.00 $8,878.00 $8,878.00 Remaining life increased 060.001.03 Carpet, 2005 Carpet, 2005 0 8 $5,350.00 $5,350.00 $5,350.00 Asset deleted 060.001.04 Carpet, Replace Carpet, Replace 0 8 $11,770.00 $11,770.00 $11,770.00 New Assets 060.001.08 Exterior Stairca Exterior Staircase 23 30 $17,639.00 $3,887.00 $0.00 060.001.08 Exterior Stairca Exterior Staircase 22 30 $17,991.00 $4,574.00 $0.00 Fully funded value too low should be $4,830.73 No assigned value 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 17 25 $17,547.00 $5,454.00 $0.00 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 16 25 $17,897.00 $6,288.00 $0.00 No assigned value 060.001.10 Furnishings Furnishings 3 10 $30,000.00 $21,000.00 $21,000.00 060.001.10 Furnishings Furnishings 2 10 $30,000.00 $24,000.00 $24,000.00 Cost not changed 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 15 20 $3,320.00 $830.00 $0.00 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 14 20 $3,386.00 $1,016.00 $0.00 No assigned value 060.001.13 HVAC Heat/Air, C HVAC Heat/Air, Clubhouse 0 20 $29,136.00 $29,136.00 $29,136.00 060.001.13 HVAC Heat/Air, C HVAC Heat/Air, Clubhouse 0 20 $29,718.00 $29,718.00 $29,718.00 Maintenance deferred 060.001.14 Window Blinds Window Blinds 2 10 $15,022.00 $11,914.00 $11,914.00 060.001.14 Window Blinds Window Blinds 3 10 $15,322.00 $11,382.00 $11,382.00 Remaining life increased Fully funded value too high should be $10,799.32 Assigned value too high should be $10,799.32 060.001.16 Wallpaper Wallpaper 7 15 $13,041.00 $6,817.00 $0.00 060.001.16 Wallpaper Wallpaper 3 15 $13,289.00 $9,872.00 $9,872.00 Remaining life decreased too much Fully funded value too low should be $10,714.49 Assigned value too low should be $10,714.49 060.001.18 Carpeting Carpeting 0 8 $11,627.00 $11,627.00 $11,627.00 Asset deleted 060.002.01 Doors, Double Sl Doors, Double Slide 24 25 $6,675.00 $267.00 $0.00 060.002.01 Doors, Double Sl Doors, Double Slide 23 25 $6,808.00 $545.00 $0.00 No assigned value 060.002.02 Doors, Exterior, Doors, Exterior, Entry 17 25 $12,416.00 $3,859.00 $0.00 060.002.02 Doors, Exterior, Doors, Exterior, Entry 16 25 $12,664.00 $4,450.00 $0.00 No assigned value 060.002.03 Doors, Entry Doors, Entry 0 25 $14,838.00 $14,838.00 $14,838.00 060.002.03 Doors, Entry Doors, Entry 0 25 $15,132.00 $15,132.00 $15,132.00 Maintenance deferred 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 0 25 $6,124.00 $6,124.00 $6,124.00 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 0 25 $6,244.00 $6,244.00 $6,244.00 Maintenance deferred 060.002.08 Doors, Entry Int Doors, Entry Interior 4 25 $1,857.00 $1,582.00 $1,582.00 060.002.08 Doors, Entry Int Doors, Entry Interior 1 25 $1,892.00 $1,816.00 $1,816.00 Remaining life decreased too much 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 17 25 $23,344.00 $7,256.00 $0.00 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 16 25 $23,810.00 $8,366.00 $0.00 No assigned value 060.003.08 Kitchen, Sink Kitchen, Sink 17 25 $742.00 $231.00 $0.00 060.003.08 Kitchen, Sink Kitchen, Sink 16 25 $756.00 $266.00 $0.00 No assigned value 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 4 8 $10,000.00 $5,932.00 $5,932.00 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 3 8 $10,000.00 $6,949.00 $6,949.00 Cost not changed 060.004.10 Office, Remodel Office, Remodel 14 20 $12,280.00 $3,612.00 $0.00 060.004.10 Office, Remodel Office, Remodel 13 20 $12,525.00 $4,315.00 $0.00 No assigned value 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 21 25 $11,063.00 $1,770.00 $0.00 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 20 25 $11,464.00 $2,293.00 $0.00 No assigned value 060.005.03 Restroom, Counte Restroom, Counters 16 20 $3,712.00 $742.00 $0.00 060.005.03 Restroom, Counte Restroom, Counters 15 20 $3,776.00 $944.00 $0.00 No assigned value 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 21 25 $2,178.00 $348.00 $0.00 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 20 25 $2,221.00 $444.00 $0.00 No assigned value 060.005.07 Restroom, Locker Restroom, Lockers/Benches 18 22 $20,000.00 $3,636.00 $0.00 060.005.07 Restroom, Locker Restroom, Lockers/Benches 17 22 $20,000.00 $4,545.00 $0.00 Cost not changed 060.005.08 Restroom, Partit Restroom, Partitions 16 20 $4,935.00 $987.00 $0.00 060.005.08 Restroom, Partit Restroom, Partitions 15 20 $5,165.00 $1,291.00 $0.00 No assigned value 060.005.12 Women's Shower Women's Shower 24 25 $3,237.00 $109.00 $0.00 060.005.12 Women's Shower Women's Shower 23 25 $3,301.00 $244.00 $0.00 Fully funded value too low should be $265.95 No assigned value 060.005.13 Restroom, Fixtur Restroom, Fixtures 21 25 $6,845.00 $1,095.00 $0.00 060.005.13 Restroom, Fixtur Restroom, Fixtures 20 25 $7,090.00 $1,418.00 $0.00 No assigned value 065.001.02 Filter, Main Filter, Main 0 12 $6,332.00 $6,332.00 $6,332.00 065.001.02 Filter, Main Filter, Main 2 12 $6,000.00 $5,077.00 $5,077.00 Maintenance deferred Remaining life increased Cost value too low should be $6,502.96 Fully funded value too low should be $5,419.14 Assigned value too low should be $5,419.14 065.001.03 Heater, Main Heater, Main 1 12 $22,170.00 $20,538.00 $20,538.00 065.001.03 Heater, Main Heater, Main 2 12 $20,000.00 $17,433.00 $17,433.00 Remaining life increased Cost value too low should be $22,768.59 Fully funded value too low should be $18,973.82 Assigned value too low should be $18,973.82 065.001.04 Motor/Pump Syste Motor/Pump System 0 8 $1,531.00 $1,531.00 $1,531.00 065.001.04 Motor/Pump Syste Motor/Pump System 7 8 $7,000.00 $538.00 $538.00 Maintenance completed 065.001.05 Pump Pump 0 8 $5,806.00 $5,806.00 $5,806.00 Asset deleted 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 14 14 $71,725.00 $0.00 $0.00 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 13 14 $73,159.00 $5,226.00 $0.00 No assigned value 065.002.01 Spa, Filter Spa, Filter 1 10 $1,531.00 $1,370.00 $1,370.00 065.002.01 Spa, Filter Spa, Filter 2 10 $1,350.00 $1,186.00 $1,186.00 Remaining life increased Cost value too low should be $1,572.34 Fully funded value too low should be $1,257.87 Assigned value too low should be $1,257.87 065.002.02 Spa, Heater Spa, Heater 1 10 $3,853.00 $3,532.00 $3,532.00 065.002.02 Spa, Heater Spa, Heater 1 10 $3,250.00 $3,000.00 $3,000.00 Remaining life not changed Cost value too low should be $3,957.03 Fully funded value too low should be $3,561.33 Assigned value too low should be $3,561.33 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 0 8 $1,082.00 $1,082.00 $1,082.00 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 0 8 $1,100.00 $1,100.00 $1,100.00 Maintenance deferred 065.002.04 Spa, Pump/Motor, Spa, Pump/Motor, Booster 0 8 $2,584.00 $2,584.00 $2,584.00 065.002.04 Spa, Pump/Motor, Spa, Pump/Motor, Booster 2 8 $2,600.00 $2,229.00 $2,229.00 Maintenance deferred Remaining life increased Fully funded value too high should be $1,990.33 Assigned value too high should be $1,990.33 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 12 12 $8,770.00 $0.00 $0.00 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 11 12 $8,945.00 $745.00 $68.00 Assigned value too low should be $750.57 065.003.01 Wader, Filter Wader, Filter 0 12 $1,213.00 $1,213.00 $1,213.00 065.003.01 Wader, Filter Wader, Filter 1 12 $950.00 $884.00 $884.00 Maintenance deferred Remaining life increased Cost value too low should be $1,245.75 Fully funded value too low should be $1,141.94 Assigned value too low should be $1,141.94 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 0 8 $791.00 $791.00 $791.00 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 7 8 $950.00 $101.00 $101.00 Maintenance completed 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 14 14 $9,100.00 $0.00 $0.00 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 13 14 $9,282.00 $663.00 $0.00 No assigned value 067.001.03 Barbecues Barbecues 3 5 $4,571.00 $1,579.00 $1,579.00 067.001.03 Barbecues Barbecues 2 5 $4,662.00 $2,628.00 $2,628.00 Fully funded value too low should be $2,816.65 Assigned value too low should be $2,816.65 067.001.05 Ceramic Shower Ceramic Shower 2 25 $1,976.00 $1,872.00 $1,872.00 067.001.05 Ceramic Shower Ceramic Shower 3 25 $2,110.00 $1,952.00 $1,952.00 Remaining life increased Fully funded value too high should be $1,785.83 Assigned value too high should be $1,785.83 067.002.03 Deck Repairs Deck Repairs 0 30 $11,917.00 $11,917.00 $11,917.00 067.002.03 Deck Repairs Deck Repairs 0 30 $25,000.00 $25,000.00 $25,000.00 Maintenance deferred Cost value too high should be $12,238.76 Fully funded value too high should be $12,238.76 Assigned value too high should be $12,238.76 067.003.02 Furniture, 2001 Furniture, 2001 0 7 $18,269.00 $18,269.00 $18,269.00 067.003.02 Furniture, 2001 Furniture, 2001 0 7 $18,625.00 $18,625.00 $18,625.00 Maintenance deferred 069.001.01 Filter, Prosa Filter, Prosa 7 12 $1,531.00 $606.00 $0.00 069.001.01 Filter, Prosa Filter, Prosa 6 12 $2,700.00 $1,301.00 $1,301.00 Cost value too high should be $1,572.34 Fully funded value too high should be $786.17 Assigned value too high should be $786.17 069.001.02 Filter, 2010 Filter, 2010 9 12 $1,531.00 $383.00 $0.00 Asset deleted 069.001.04 Heater, Prosa Heater, Prosa 0 12 $12,669.00 $12,669.00 $12,669.00 069.001.04 Heater, Prosa Heater, Prosa 0 12 $15,000.00 $15,000.00 $15,000.00 Maintenance deferred Cost value too high should be $13,011.06 Fully funded value too high should be $13,011.06 Assigned value too high should be $13,011.06 069.001.05 Motor Motor 0 8 $2,164.00 $2,164.00 $2,164.00 069.001.05 Motor Motor 2 8 $2,200.00 $1,800.00 $1,800.00 Maintenance deferred Remaining life increased Fully funded value too high should be $1,666.82 Assigned value too high should be $1,666.82 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 14 14 $31,350.00 $0.00 $0.00 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 13 14 $31,970.00 $2,284.00 $0.00 No assigned value 070.001.01 Aluminum Trellis Aluminum Trellis 27 30 $11,177.00 $1,118.00 $0.00 070.001.01 Aluminum Trellis Aluminum Trellis 26 30 $11,400.00 $1,520.00 $0.00 No assigned value 070.001.02 Barbecues Barbecues 6 8 $3,737.00 $714.00 $0.00 070.001.02 Barbecues Barbecues 5 8 $3,811.00 $1,242.00 $1,242.00 Fully funded value too low should be $1,439.21 Assigned value too low should be $1,439.21 070.001.05 Furniture Furniture 0 7 $8,545.00 $8,545.00 $8,545.00 070.001.05 Furniture Furniture 0 7 $8,705.00 $8,705.00 $8,705.00 Maintenance deferred 070.001.06 Plumbing Fixture Plumbing Fixtures 2 25 $5,255.00 $4,937.00 $4,937.00 070.001.06 Plumbing Fixture Plumbing Fixtures 2 25 $5,444.00 $5,124.00 $5,124.00 Remaining life not changed 070.001.07 Repairs Repairs 2 20 $2,986.00 $2,805.00 $2,805.00 070.001.07 Repairs Repairs 2 20 $3,095.00 $2,913.00 $2,913.00 Remaining life not changed Fully funded value too high should be $2,759.96 Assigned value too high should be $2,759.96 070.001.09 Wood, Repairs Wood, Repairs 3 5 $3,500.00 $1,400.00 $1,400.00 070.001.09 Wood, Repairs Wood, Repairs 2 5 $3,500.00 $2,100.00 $2,100.00 Cost not changed 070.002.01 Ceramic Shower Ceramic Shower 0 25 $6,734.00 $6,734.00 $6,734.00 070.002.01 Ceramic Shower Ceramic Shower 0 25 $6,978.00 $6,978.00 $6,978.00 Maintenance deferred 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 1 25 $8,605.00 $8,336.00 $8,336.00 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 5 25 $8,913.00 $7,708.00 $7,708.00 Remaining life increased Fully funded value too high should be $7,069.87 Assigned value too high should be $7,069.87 070.003.02 Deck, Repairs Deck, Repairs 0 30 $5,890.00 $5,890.00 $5,890.00 070.003.02 Deck, Repairs Deck, Repairs 0 30 $12,500.00 $12,500.00 $12,500.00 Maintenance deferred Cost value too high should be $6,049.03 Fully funded value too high should be $6,049.03 Assigned value too high should be $6,049.03 070.004.01 Water Heater Water Heater 0 18 $3,366.00 $3,366.00 $3,366.00 070.004.01 Water Heater Water Heater 0 18 $3,433.00 $3,433.00 $3,433.00 Maintenance deferred 070.005.01 Restroom, Counte Restroom, Counters 2 20 $1,034.00 $971.00 $971.00 070.005.01 Restroom, Counte Restroom, Counters 2 20 $1,054.00 $992.00 $992.00 Remaining life not changed 080.000.01 Benches Benches 13 15 $18,998.00 $2,533.00 $0.00 080.000.01 Benches Benches 12 15 $19,376.00 $3,875.00 $0.00 No assigned value 080.000.02 Chain Link Fenci Chain Link Fencing 4 30 $18,955.00 $17,060.00 $17,060.00 080.000.02 Chain Link Fenci Chain Link Fencing 6 30 $19,336.00 $16,638.00 $16,638.00 Remaining life increased Fully funded value too high should be $15,573.43 Assigned value too high should be $15,573.43 080.000.05 Lighting Lighting 4 25 $12,816.00 $11,534.00 $4,974.00 080.000.05 Lighting Lighting 3 25 $13,280.00 $12,284.00 $12,284.00 Fully funded value too high should be $11,582.59 Assigned value too high should be $11,582.59 080.000.06 Resurfacing Resurfacing 0 6 $11,808.00 $11,808.00 $11,808.00 080.000.06 Resurfacing Resurfacing 1 6 $12,096.00 $10,996.00 $10,996.00 Maintenance deferred Remaining life increased Fully funded value too high should be $10,105.68 Assigned value too high should be $10,105.68 080.000.07 Windscreen Windscreen 0 6 $3,203.00 $3,203.00 $3,203.00 080.000.07 Windscreen Windscreen 1 6 $3,282.00 $3,093.00 $3,093.00 Maintenance deferred Remaining life increased Fully funded value too high should be $2,741.23 Assigned value too high should be $2,741.23 085.001.02 Trash Cans Trash Cans 13 15 $10,233.00 $1,364.00 $0.00 085.001.02 Trash Cans Trash Cans 12 15 $10,431.00 $2,086.00 $0.00 No assigned value 085.002.01 Drinking Fountai Drinking Fountain, C/H 14 16 $2,823.00 $259.00 $0.00 085.002.01 Drinking Fountai Drinking Fountain, C/H 13 16 $2,879.00 $451.00 $0.00 Fully funded value too low should be $543.60 No assigned value 085.002.03 Drinking Fountai Drinking Fountain, Prosa 0 16 $1,424.00 $1,424.00 $1,424.00 085.002.03 Drinking Fountai Drinking Fountain, Prosa 0 16 $1,452.00 $1,452.00 $1,452.00 Maintenance deferred 085.003.03 Sand Repl, Prosa Sand Repl, Prosa/Alba 0 10 $7,152.00 $7,152.00 $7,152.00 Asset deleted 085.003.04 Sand Repl, Alba Sand Repl, Alba 0 10 $7,000.00 $7,000.00 $7,000.00 New Assets 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 0 10 $6,000.00 $6,000.00 $6,000.00 New Assets 085.004.01 Play Equip, Main Play Equip, Main, Prosa 2 18 $48,598.00 $43,044.00 $43,044.00 085.004.01 Play Equip, Main Play Equip, Main, Prosa 3 18 $49,569.00 $41,943.00 $41,943.00 Remaining life increased 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $6,335.00 $6,335.00 $6,335.00 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $6,000.00 $6,000.00 $6,000.00 Maintenance deferred Cost value too low should be $6,506.04 Fully funded value too low should be $6,506.04 Assigned value too low should be $6,506.04 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 1 12 $4,544.00 $4,219.00 $4,219.00 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 3 12 $4,634.00 $3,816.00 $3,816.00 Remaining life increased Fully funded value too high should be $3,500.02 Assigned value too high should be $3,500.02 090.000.02 Trellis, Clubhou Trellis, Clubhouse 28 30 $42,474.00 $2,273.00 $0.00 090.000.02 Trellis, Clubhou Trellis, Clubhouse 27 30 $43,323.00 $3,783.00 $0.00 Fully funded value too low should be $4,362.08 No assigned value 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 3 4 $9,000.00 $1,957.00 $1,957.00 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 2 4 $9,000.00 $4,304.00 $4,304.00 Cost not changed 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 097.000.02 Irrigation, Cont Irrigation, Controllers 0 12 $46,453.00 $46,453.00 $46,453.00 097.000.02 Irrigation, Cont Irrigation, Controllers 14 15 $29,700.00 $1,980.00 $0.00 Maintenance completed 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 24 $25,338.00 $25,338.00 $25,338.00 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 2 24 $25,842.00 $24,517.00 $24,517.00 Maintenance deferred Remaining life increased 100.000.01 Bulletin Board Bulletin Board 1 12 $1,045.00 $991.00 $991.00 100.000.01 Bulletin Board Bulletin Board 3 15 $1,065.00 $921.00 $921.00 Remaining life increased Useful life increased Fully funded value too high should be $858.57 Assigned value too high should be $858.57 100.000.02 Monument Monument 0 30 $3,105.00 $3,105.00 $3,105.00 100.000.02 Monument Monument 0 30 $3,167.00 $3,167.00 $3,167.00 Maintenance deferred 105.000.01 Termite Control/ Termite Control/Fumigation 0 15 $4,889.00 $4,889.00 $4,889.00 105.000.01 Termite Control/ Termite Control/Fumigation 1 15 $4,986.00 $4,724.00 $4,724.00 Maintenance deferred Remaining life increased 2013 - 2014 RDA Forensic Analysis Summary Estimated inflation 2.7% Consumer Price Index 1.5% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $1,380,240.00 $746,394.00 $641,629.00 This Year Costs $1,452,112.00 $830,196.20 $737,418.20 Calculated Costs $1,395,493.97 $798,884.03 $798,884.03 Comparing This Year Costs to Last Year Costs Difference $71,872.00 $83,802.20 $95,789.20 percent difference 5.21% 11.23% 14.93% exceeds CC&R limits Comparing This Year Costs to Calculated Costs Difference $56,618.03 $31,312.17 $-61,465.83 percent difference 3.90% 3.77% -8.34% 116 Total Assets 73 Total Issues $142,497.46 Unfunded Liability 0.63 Issues / Asset number % Description 3 2.59% New Assets 28 24.14% No assigned value 6 5.17% Cost value too high 6 5.17% Cost value too low 18 15.52% Fully funded value too high 22 18.97% Fully funded value too low 18 15.52% Assigned value too high 17 14.66% Assigned value too low 5 4.31% Asset deleted 4 3.45% Remaining life not changed 20 17.24% Remaining life increased 3 2.59% Remaining life decreased too much 1 0.86% Useful life increased 26 22.41% Maintenance deferred 3 2.59% Maintenance completed 29 25.00% Total assets to be maintained 7 6.03% Cost not changed