Park Paseo Homeowners Association Audited Forensic Report For 2015 to 2016 Revenue 505.000.01 Homeowners Association Fees $558,202.00 $221,798.00 $780,000.00 505.000.01 Homeowners Association Fees $543,483.00 $169,017.00 $712,500.00 Replacement fund too high difference is $52,781.00 Cost too high difference is $67,500.00 520.000.01 Clubhouse Rental Fee $14,350.00 $0.00 $14,350.00 520.000.01 Clubhouse Rental Fee $8,100.00 $0.00 $8,100.00 Operating fund too high difference is $6,250.00 Cost too high difference is $6,250.00 540.000.04 Recovery of Bad Debt $3,027.00 $0.00 $3,027.00 540.000.04 Recovery of Bad Debt $100.00 $0.00 $100.00 Operating fund too high difference is $2,927.00 Cost too high difference is $2,927.00 540.000.10 Other Income $18,102.00 $0.00 $18,102.00 540.000.10 Other Income $10,930.00 $0.00 $10,930.00 Operating fund too high difference is $7,172.00 Cost too high difference is $7,172.00 550.000.03 Investment Income $1,393.00 $2,837.00 $4,230.00 550.000.03 Investment Income $452.00 $3,456.00 $3,908.00 Operating fund too high difference is $941.00 Replacement fund too low difference is $-619.00 Cost too high difference is $322.00 Expense 640.000.03 Reserve Studies $2,295.00 $0.00 $2,295.00 640.000.03 Reserve Studies $1,695.00 $0.00 $1,695.00 Operating fund too high difference is $600.00 Cost too high difference is $600.00 640.000.05 General Administrative $7,837.00 $0.00 $7,837.00 640.000.05 General Administrative $9,118.00 $190.00 $9,308.00 Operating fund too low difference is $-1,281.00 Replacement fund too low difference is $-190.00 Cost too low difference is $-1,471.00 640.000.07 Office supplies/printing/postage $12,865.00 $0.00 $12,865.00 640.000.07 Office supplies/printing/postage $20,315.00 $0.00 $20,315.00 Operating fund too low difference is $-7,450.00 Cost too low difference is $-7,450.00 760.000.01 Audit & Tax Services $1,700.00 $0.00 $1,700.00 760.000.01 Audit & Tax Services $1,818.00 $0.00 $1,818.00 Operating fund too low difference is $-118.00 Cost too low difference is $-118.00 760.000.04 Management Fees $80,400.00 $0.00 $80,400.00 760.000.04 Management Fees $80,400.00 $0.00 $80,400.00 Total costs unchanged 760.000.07 Legal and collection $6,400.00 $0.00 $6,400.00 760.000.07 Legal and collection $16,886.00 $0.00 $16,886.00 Operating fund too low difference is $-10,486.00 Cost too low difference is $-10,486.00 780.000.01 Property Protection - Patrol Service $36,329.00 $0.00 $36,329.00 780.000.01 Property Protection - Patrol Service $50,210.00 $0.00 $50,210.00 Operating fund too low difference is $-13,881.00 Cost too low difference is $-13,881.00 840.001.05 General Repair & Maintenance $97,868.00 $0.00 $97,868.00 840.001.05 General Repair & Maintenance $31,255.00 $6,983.00 $38,238.00 Operating fund too high difference is $66,613.00 Replacement fund too low difference is $-6,983.00 Cost too high difference is $59,630.00 840.001.11 Common Areas $0.00 $5,250.00 $5,250.00 Deleted Asset(s) Expense 840.001.12 Deck $0.00 $2,399.00 $2,399.00 Added Asset(s) Expense 840.002.04 Janitorial Combined Costs $13,529.00 $0.00 $13,529.00 840.002.04 Janitorial Combined Costs $15,001.00 $0.00 $15,001.00 Operating fund too low difference is $-1,472.00 Cost too low difference is $-1,472.00 840.004.03 Pest Control $1,133.00 $0.00 $1,133.00 840.004.03 Pest Control $1,778.00 $0.00 $1,778.00 Operating fund too low difference is $-645.00 Cost too low difference is $-645.00 840.006.03 Pool Supplies/Repair & Maintenance $42,916.00 $39,593.00 $82,509.00 840.006.03 Pool Supplies/Repair & Maintenance $29,064.00 $71,282.00 $100,346.00 Operating fund too high difference is $13,852.00 Replacement fund too low difference is $-31,689.00 Cost too low difference is $-17,837.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $18,886.00 $18,886.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $24,665.00 $24,665.00 Replacement fund too low difference is $-5,779.00 Cost too low difference is $-5,779.00 840.007.02 Tot Lot $0.00 $44,632.00 $44,632.00 Deleted Asset(s) Expense 860.000.01 Electric Service $30,528.00 $0.00 $30,528.00 860.000.01 Electric Service $32,973.00 $0.00 $32,973.00 Operating fund too low difference is $-2,445.00 Cost too low difference is $-2,445.00 860.000.02 Gas Service $12,019.00 $0.00 $12,019.00 860.000.02 Gas Service $12,884.00 $0.00 $12,884.00 Operating fund too low difference is $-865.00 Cost too low difference is $-865.00 860.000.03 Telephone Service $3,085.00 $0.00 $3,085.00 860.000.03 Telephone Service $3,606.00 $0.00 $3,606.00 Operating fund too low difference is $-521.00 Cost too low difference is $-521.00 860.000.04 Trash and Recycling Service $1,874.00 $0.00 $1,874.00 860.000.04 Trash and Recycling Service $1,178.00 $0.00 $1,178.00 Operating fund too high difference is $696.00 Cost too high difference is $696.00 860.000.05 Water Service $40,496.00 $0.00 $40,496.00 860.000.05 Water Service $35,983.00 $0.00 $35,983.00 Operating fund too high difference is $4,513.00 Cost too high difference is $4,513.00 2015 - 2016 Analysis Summary Estimated inflation 2% Consumer Price Index 0.1% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2015 $563,065.00 $172,473.00 $735,538.00 Revenue 2016 $595,074.00 $224,635.00 $819,709.00 Expense 2015 $533,465.00 $155,401.00 $688,866.00 Expense 2016 $586,798.00 $58,479.00 $645,277.00 revenue - expense 2015 $29,600.00 $17,072.00 $46,672.00 revenue - expense 2016 $8,276.00 $166,156.00 $174,432.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $-21,324.00 $149,084.00 $127,760.00 percent difference -72.04% 973.27% 373.74% Total Assets 24 Total Issues 97 Issues/Asset 4.04 count % Description 1 4.17% Added Asset(s) 2 8.33% Deleted Asset(s) 9 37.50% Operating fund too high 10 41.67% Operating fund too low 1 4.17% Replacement fund too high 5 20.83% Replacement fund too low 9 37.50% Cost too high 12 50.00% Cost too low 1 4.17% Total costs unchanged Park Paseo Homeowners Association UnAudited Forensic Report For 2015 to 2016 Revenue 505.000.01 Homeowners Association Fees $558,202.00 $221,798.00 $780,000.00 505.000.01 Homeowners Association Fees $543,483.00 $169,017.00 $712,500.00 Replacement fund too high difference is $52,781.00 Cost too high difference is $67,500.00 520.000.01 Clubhouse Rental Fee $14,350.00 $0.00 $14,350.00 520.000.01 Clubhouse Rental Fee $8,100.00 $0.00 $8,100.00 Operating fund too high difference is $6,250.00 Cost too high difference is $6,250.00 540.000.04 Recovery of Bad Debt $3,027.00 $0.00 $3,027.00 540.000.04 Recovery of Bad Debt $100.00 $0.00 $100.00 Operating fund too high difference is $2,927.00 Cost too high difference is $2,927.00 540.000.10 Other Income $18,102.00 $0.00 $18,102.00 540.000.10 Other Income $10,930.00 $0.00 $10,930.00 Operating fund too high difference is $7,172.00 Cost too high difference is $7,172.00 550.000.03 Investment Income $1,393.00 $2,837.00 $4,230.00 550.000.03 Investment Income $452.00 $3,456.00 $3,908.00 Operating fund too high difference is $941.00 Replacement fund too low difference is $-619.00 Cost too high difference is $322.00 Expense 640.000.03 Reserve Studies $2,295.00 $0.00 $2,295.00 640.000.03 Reserve Studies $1,695.00 $0.00 $1,695.00 Operating fund too high difference is $600.00 Cost too high difference is $600.00 640.000.05 General Administrative $7,837.00 $0.00 $7,837.00 640.000.05 General Administrative $9,118.00 $190.00 $9,308.00 Operating fund too low difference is $-1,281.00 Replacement fund too low difference is $-190.00 Cost too low difference is $-1,471.00 640.000.07 Office supplies/printing/postage $12,865.00 $0.00 $12,865.00 640.000.07 Office supplies/printing/postage $20,315.00 $0.00 $20,315.00 Operating fund too low difference is $-7,450.00 Cost too low difference is $-7,450.00 760.000.01 Audit & Tax Services $1,700.00 $0.00 $1,700.00 760.000.01 Audit & Tax Services $1,818.00 $0.00 $1,818.00 Operating fund too low difference is $-118.00 Cost too low difference is $-118.00 760.000.04 Management Fees $80,400.00 $0.00 $80,400.00 760.000.04 Management Fees $80,400.00 $0.00 $80,400.00 Total costs unchanged 760.000.07 Legal and collection $6,400.00 $0.00 $6,400.00 760.000.07 Legal and collection $16,886.00 $0.00 $16,886.00 Operating fund too low difference is $-10,486.00 Cost too low difference is $-10,486.00 780.000.01 Property Protection - Patrol Service $36,329.00 $0.00 $36,329.00 780.000.01 Property Protection - Patrol Service $50,210.00 $0.00 $50,210.00 Operating fund too low difference is $-13,881.00 Cost too low difference is $-13,881.00 840.001.05 General Repair & Maintenance $97,868.00 $0.00 $97,868.00 840.001.05 General Repair & Maintenance $31,255.00 $6,983.00 $38,238.00 Operating fund too high difference is $66,613.00 Replacement fund too low difference is $-6,983.00 Cost too high difference is $59,630.00 840.001.11 Common Areas $0.00 $5,250.00 $5,250.00 Deleted Asset(s) Expense 840.001.12 Deck $0.00 $2,399.00 $2,399.00 Added Asset(s) Expense 840.002.04 Janitorial Combined Costs $13,529.00 $0.00 $13,529.00 840.002.04 Janitorial Combined Costs $15,001.00 $0.00 $15,001.00 Operating fund too low difference is $-1,472.00 Cost too low difference is $-1,472.00 840.004.03 Pest Control $1,133.00 $0.00 $1,133.00 840.004.03 Pest Control $1,778.00 $0.00 $1,778.00 Operating fund too low difference is $-645.00 Cost too low difference is $-645.00 840.006.03 Pool Supplies/Repair & Maintenance $42,916.00 $39,593.00 $82,509.00 840.006.03 Pool Supplies/Repair & Maintenance $29,064.00 $71,282.00 $100,346.00 Operating fund too high difference is $13,852.00 Replacement fund too low difference is $-31,689.00 Cost too low difference is $-17,837.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $18,886.00 $18,886.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $24,665.00 $24,665.00 Replacement fund too low difference is $-5,779.00 Cost too low difference is $-5,779.00 840.007.02 Tot Lot $0.00 $44,632.00 $44,632.00 Deleted Asset(s) Expense 860.000.01 Electric Service $30,528.00 $0.00 $30,528.00 860.000.01 Electric Service $32,973.00 $0.00 $32,973.00 Operating fund too low difference is $-2,445.00 Cost too low difference is $-2,445.00 860.000.02 Gas Service $12,019.00 $0.00 $12,019.00 860.000.02 Gas Service $12,884.00 $0.00 $12,884.00 Operating fund too low difference is $-865.00 Cost too low difference is $-865.00 860.000.03 Telephone Service $3,085.00 $0.00 $3,085.00 860.000.03 Telephone Service $3,606.00 $0.00 $3,606.00 Operating fund too low difference is $-521.00 Cost too low difference is $-521.00 860.000.04 Trash and Recycling Service $1,874.00 $0.00 $1,874.00 860.000.04 Trash and Recycling Service $1,178.00 $0.00 $1,178.00 Operating fund too high difference is $696.00 Cost too high difference is $696.00 860.000.05 Water Service $40,496.00 $0.00 $40,496.00 860.000.05 Water Service $35,983.00 $0.00 $35,983.00 Operating fund too high difference is $4,513.00 Cost too high difference is $4,513.00 2015 - 2016 Analysis Summary Estimated inflation 2% Consumer Price Index 0.1% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2015 $563,065.00 $172,473.00 $735,538.00 Revenue 2016 $595,074.00 $224,635.00 $819,709.00 Expense 2015 $533,465.00 $155,401.00 $688,866.00 Expense 2016 $586,798.00 $58,479.00 $645,277.00 revenue - expense 2015 $29,600.00 $17,072.00 $46,672.00 revenue - expense 2016 $8,276.00 $166,156.00 $174,432.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $-21,324.00 $149,084.00 $127,760.00 percent difference -72.04% 973.27% 373.74% Total Assets 24 Total Issues 97 Issues/Asset 4.04 count % Description 1 4.17% Added Asset(s) 2 8.33% Deleted Asset(s) 9 37.50% Operating fund too high 10 41.67% Operating fund too low 1 4.17% Replacement fund too high 5 20.83% Replacement fund too low 9 37.50% Cost too high 12 50.00% Cost too low 1 4.17% Total costs unchanged Park Paseo Homeowners Association RDA Forensic Analysis For 2015 to 2016 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 010.000.01 Overlay/Rehab Overlay/Rehab 3 20 $12,135.00 $10,314.62 $10,314.62 010.000.01 Overlay/Rehab Overlay/Rehab 3 20 $12,318.00 $10,599.00 $10,599.00 Remaining life not changed 010.000.03 Asphalt Repairs Asphalt Repairs 0 3 $2,593.10 $2,593.10 $2,593.10 010.000.03 Asphalt Repairs Asphalt Repairs 3 3 $2,621.00 $0.00 $0.00 Maintenance completed 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 0 3 $2,432.26 $2,432.26 $2,432.26 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 3 3 $1,875.00 $0.00 $0.00 Maintenance completed 020.000.03 Clubhouse, Tile Clubhouse, Tile 34 35 $55,080.00 $929.81 $0.00 020.000.03 Clubhouse, Tile Clubhouse, Tile 33 35 $49,317.00 $2,371.00 $0.00 Cost value too low should be $56,181.60 Fully funded value too low should be $3,210.38 No assigned value 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 46 50 $11,428.08 $913.81 $0.00 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 45 50 $11,651.00 $1,165.00 $0.00 No assigned value 030.001.03 Interior Prosa R Interior Prosa Restrooms 5 8 $1,601.40 $545.40 $545.40 030.001.03 Interior Prosa R Interior Prosa Restrooms 4 8 $1,633.00 $772.00 $772.00 Fully funded value too low should be $816.71 Assigned value too low should be $816.71 030.001.06 Stucco Stucco 6 10 $3,204.84 $1,180.42 $1,180.42 030.001.06 Stucco Stucco 5 10 $3,268.00 $1,548.00 $1,548.00 Fully funded value too low should be $1,634.47 Assigned value too low should be $1,634.47 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $165.78 $165.78 $165.78 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $172.00 $172.00 $172.00 Maintenance deferred 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 25 30 $141,938.09 $22,662.37 $310.25 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 19 25 $144,776.00 $33,635.00 $33,635.00 Remaining life decreased too much Useful life decreased 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 16 20 $942.48 $165.89 $165.89 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 15 20 $962.00 $219.00 $219.00 Fully funded value too low should be $240.33 Assigned value too low should be $240.33 040.000.05 Walls, Block, Re Walls, Block, Repairs 0 20 $5,000.00 $5,000.00 $5,000.00 New Assets 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 16 20 $2,550.00 $457.45 $457.45 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 15 20 $2,500.00 $585.00 $585.00 Fully funded value too low should be $650.25 Assigned value too low should be $650.25 050.000.01 Exterior, Pool/C Exterior, Pool/Club 0 10 $13,598.00 $13,598.00 $13,598.00 050.000.01 Exterior, Pool/C Exterior, Pool/Club 0 10 $13,786.00 $13,786.00 $13,786.00 Maintenance deferred 050.000.05 Exterior, Prosa Exterior, Prosa 0 10 $2,630.00 $2,630.00 $2,630.00 050.000.05 Exterior, Prosa Exterior, Prosa 0 10 $2,666.00 $2,666.00 $2,666.00 Maintenance deferred 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 0 15 $110,000.03 $110,000.03 $110,000.03 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 0 15 $112,200.00 $112,200.00 $112,200.00 Maintenance deferred 050.001.01 Interior Clubhou Interior Clubhouse 0 25 $15,594.00 $15,594.00 $15,594.00 050.001.01 Interior Clubhou Interior Clubhouse 0 25 $15,829.00 $15,829.00 $15,829.00 Maintenance deferred 060.001.04 Carpet, Replace Carpet, Replace 7 8 $12,005.40 $354.55 $354.55 060.001.04 Carpet, Replace Carpet, Replace 6 8 $7,956.00 $1,447.00 $1,447.00 Cost value too low should be $12,245.51 Fully funded value too low should be $3,061.38 Assigned value too low should be $3,061.38 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 19 20 $30,312.36 $1,051.78 $1,051.78 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 18 20 $28,250.00 $2,503.00 $2,503.00 Cost value too low should be $30,918.61 Fully funded value too low should be $3,091.86 Assigned value too low should be $3,091.86 060.001.15 Water Heater Water Heater 0 12 $3,501.00 $3,501.00 $3,501.00 060.001.15 Water Heater Water Heater 15 16 $6,983.00 $261.00 $261.00 Maintenance completed 060.002.03 Doors, Entry Doors, Entry 0 25 $15,432.00 $15,432.00 $15,432.00 060.002.03 Doors, Entry Doors, Entry 0 25 $15,738.00 $15,738.00 $15,738.00 Maintenance deferred 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 0 25 $6,368.00 $6,368.00 $6,368.00 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 0 25 $6,492.00 $6,492.00 $6,492.00 Maintenance deferred 060.002.08 Doors, Entry Int Doors, Entry Interior 0 25 $1,928.00 $1,928.00 $1,928.00 060.002.08 Doors, Entry Int Doors, Entry Interior 0 25 $1,964.00 $1,964.00 $1,964.00 Maintenance deferred 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 2 8 $10,000.00 $7,966.10 $7,966.10 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 1 8 $10,000.00 $8,983.00 $8,983.00 Cost not changed 065.001.01 Deck Repairs Deck Repairs 0 30 $25,000.00 $25,000.00 $25,000.00 New Assets 065.001.03 Heater, Main Heater, Main 11 12 $20,400.00 $1,110.17 $1,110.17 065.001.03 Heater, Main Heater, Main 10 12 $19,816.00 $2,831.00 $2,831.00 Fully funded value too low should be $3,468.00 Assigned value too low should be $3,468.00 065.001.04 Motor/Pump Syste Motor/Pump System 6 8 $7,140.00 $1,490.77 $1,490.77 065.001.04 Motor/Pump Syste Motor/Pump System 5 8 $7,282.00 $2,481.00 $2,481.00 Fully funded value too low should be $2,731.05 Assigned value too low should be $2,731.05 065.002.02 Spa, Heater Spa, Heater 12 10 $3,315.00 $183.45 $183.45 065.002.02 Spa, Heater Spa, Heater 8 10 $2,636.00 $509.00 $509.00 Remaining life decreased too much Cost value too low should be $3,381.30 Fully funded value too low should be $676.26 Assigned value too low should be $676.26 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 0 8 $1,122.00 $1,122.00 $1,122.00 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 0 8 $1,144.00 $1,144.00 $1,144.00 Maintenance deferred 065.002.06 Spa, Sump Pump Spa, Sump Pump 0 8 $2,869.00 $2,869.00 $2,869.00 065.002.06 Spa, Sump Pump Spa, Sump Pump 0 8 $2,926.00 $2,926.00 $2,926.00 Maintenance deferred 065.003.01 Wader, Filter Wader, Filter 0 12 $969.00 $969.00 $969.00 065.003.01 Wader, Filter Wader, Filter 0 12 $988.00 $988.00 $988.00 Maintenance deferred 067.002.02 Deck Caulking Deck Caulking 2 4 $11,816.70 $5,897.50 $5,897.50 067.002.02 Deck Caulking Deck Caulking 4 4 $8,013.00 $0.00 $0.00 Maintenance completed 067.002.03 Deck Repairs Deck Repairs 0 30 $25,000.00 $25,000.00 $25,000.00 Asset deleted 067.003.02 Furniture, 2001 Furniture, 2001 0 7 $18,981.00 $18,981.00 $18,981.00 Asset deleted 067.003.03 Furniture, 2007 Furniture, 2007 0 7 $15,581.00 $15,581.00 $15,581.00 Asset deleted 067.003.04 Furniture, Repla Furniture, Replace 6 7 $62,362.00 $6,236.00 $6,236.00 New Assets 069.001.04 Heater, Prosa Heater, Prosa 11 12 $15,300.00 $488.46 $488.46 069.001.04 Heater, Prosa Heater, Prosa 10 12 $6,477.00 $1,042.00 $1,042.00 Cost value too low should be $15,606.00 Fully funded value too low should be $2,601.00 Assigned value too low should be $2,601.00 070.001.01 Aluminum Trellis Aluminum Trellis 25 30 $11,628.00 $1,938.00 $0.00 070.001.01 Aluminum Trellis Aluminum Trellis 24 30 $11,860.00 $2,372.00 $441.00 Assigned value too low should be $2,372.11 070.001.05 Furniture Furniture 0 7 $8,865.00 $8,865.00 $8,865.00 070.001.05 Furniture Furniture 6 7 $16,888.00 $1,689.00 $1,689.00 Maintenance completed 070.002.01 Ceramic Shower Ceramic Shower 0 25 $7,099.79 $7,099.79 $7,099.79 070.002.01 Ceramic Shower Ceramic Shower 0 25 $7,222.00 $7,222.00 $7,222.00 Maintenance deferred 070.003.01 Deck, Caulking Deck, Caulking 2 4 $3,360.90 $1,679.07 $1,679.07 070.003.01 Deck, Caulking Deck, Caulking 4 4 $2,642.00 $0.00 $0.00 Maintenance completed 070.003.02 Deck, Repairs Deck, Repairs 0 30 $12,500.00 $12,500.00 $12,500.00 070.003.02 Deck, Repairs Deck, Repairs 0 30 $12,500.00 $12,500.00 $12,500.00 Maintenance deferred Cost not changed 070.004.01 Water Heater Water Heater 0 18 $3,501.00 $3,501.00 $3,501.00 070.004.01 Water Heater Water Heater 15 16 $4,395.00 $165.00 $165.00 Maintenance completed 080.000.06 Resurfacing Resurfacing 0 6 $12,240.00 $12,240.00 $12,240.00 080.000.06 Resurfacing Resurfacing 5 6 $9,504.00 $1,584.00 $1,584.00 Maintenance completed 080.000.07 Windscreen Windscreen 0 6 $3,321.36 $3,321.36 $3,321.36 080.000.07 Windscreen Windscreen 5 6 $2,847.00 $474.00 $474.00 Maintenance completed 085.002.01 Drinking Fountai Drinking Fountain, C/H 12 16 $2,936.58 $650.68 $650.68 085.002.01 Drinking Fountai Drinking Fountain, C/H 11 16 $2,994.00 $858.00 $858.00 Fully funded value too low should be $936.03 Assigned value too low should be $936.03 085.002.03 Drinking Fountai Drinking Fountain, Prosa 0 16 $1,481.00 $1,481.00 $1,481.00 085.002.03 Drinking Fountai Drinking Fountain, Prosa 0 16 $1,510.00 $1,510.00 $1,510.00 Maintenance deferred 085.003.04 Sand Repl, Alba Sand Repl, Alba 9 10 $7,140.00 $480.69 $480.69 Asset deleted 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 9 10 $2,929.00 $292.86 $292.86 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 8 10 $8,364.00 $1,195.00 $1,195.00 Cost value too high should be $2,987.58 Fully funded value too high should be $597.52 Assigned value too high should be $597.52 085.003.06 Wood Chips, Alba Wood Chips, Alba 8 10 $7,109.00 $1,226.00 $1,226.00 New Assets 085.004.02 Poured In Place, Poured In Place, Main 14 14 $41,548.00 $0.00 $0.00 New Assets 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $6,000.00 $6,000.00 $6,000.00 Asset deleted 090.000.02 Trellis, Clubhou Trellis, Clubhouse 26 30 $44,189.46 $5,352.47 $0.00 090.000.02 Trellis, Clubhou Trellis, Clubhouse 25 30 $45,072.00 $6,983.00 $0.00 Fully funded value too low should be $7,512.21 No assigned value 095.001.01 Refurbishment Refurbishment 1 1 $85,482.00 $0.00 $0.00 New Assets 095.002.06 Tree Trimming, W Tree Trimming, Windrow 2 3 $30,600.00 $9,272.73 $9,272.73 095.002.06 Tree Trimming, W Tree Trimming, Windrow 1 3 $34,000.00 $21,636.00 $21,636.00 Cost value too high should be $31,212.00 100.000.02 Monument Monument 0 30 $3,230.00 $3,230.00 $3,230.00 100.000.02 Monument Monument 0 30 $3,294.00 $3,294.00 $3,294.00 Maintenance deferred 105.000.01 Termite Control/ Termite Control/Fumigation 0 15 $5,060.00 $5,060.00 $5,060.00 105.000.01 Termite Control/ Termite Control/Fumigation 0 15 $5,060.00 $5,060.00 $5,060.00 Maintenance deferred Cost not changed 110.000.01 Golf Cart, Repla Golf Cart, Replacement 0 0 $0.00 $0.00 $0.00 Asset deleted 2015 - 2016 RDA Forensic Analysis Summary Estimated inflation 2% Consumer Price Index 0.1% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $1,470,769.77 $743,341.55 $711,855.26 This Year Costs $1,634,906.00 $768,267.00 $755,817.00 Calculated Costs $1,655,434.18 $768,823.53 $768,823.53 Comparing This Year Costs to Last Year Costs Difference $164,136.23 $24,925.45 $43,961.74 percent difference 11.16% 3.35% 6.18% exceeds CC&R limits Comparing This Year Costs to Calculated Costs Difference $-20,528.18 $-556.53 $-13,006.53 percent difference -1.26% -0.07% -1.72% 116 Total Assets 30 Total Issues $39,538.73 Unfunded Liability 0.26 Issues / Asset number % Description 6 5.17% New Assets 3 2.59% No assigned value 2 1.72% Cost value too high 5 4.31% Cost value too low 1 0.86% Fully funded value too high 13 11.21% Fully funded value too low 1 0.86% Assigned value too high 12 10.34% Assigned value too low 6 5.17% Asset deleted 1 0.86% Remaining life not changed 2 1.72% Remaining life decreased too much 1 0.86% Useful life decreased 16 13.79% Maintenance deferred 9 7.76% Maintenance completed 23 19.83% Total assets to be maintained 3 2.59% Cost not changed