Park Paseo Homeowners Association Audited Forensic Report For 2014 to 2015 Revenue 505.000.01 Homeowners Association Fees $543,483.00 $169,017.00 $712,500.00 505.000.01 Homeowners Association Fees $523,524.00 $143,976.00 $667,500.00 Replacement fund too high difference is $25,041.00 520.000.01 Clubhouse Rental Fee $8,100.00 $0.00 $8,100.00 520.000.01 Clubhouse Rental Fee $8,625.00 $0.00 $8,625.00 Operating fund too low difference is $-525.00 Cost too low difference is $-525.00 540.000.04 Recovery of Bad Debt $100.00 $0.00 $100.00 Added Asset(s) Revenue 540.000.05 Miscellaneous Income $850.00 $0.00 $850.00 Deleted Asset(s) Revenue 540.000.10 Other Income $10,930.00 $0.00 $10,930.00 540.000.10 Other Income $9,212.00 $9,330.00 $18,542.00 Operating fund too high difference is $1,718.00 Replacement fund too low difference is $-9,330.00 Cost too low difference is $-7,612.00 550.000.03 Investment Income $452.00 $3,456.00 $3,908.00 550.000.03 Investment Income $0.00 $2,201.00 $2,201.00 Operating fund too high difference is $452.00 Replacement fund too high difference is $1,255.00 Cost too high difference is $1,707.00 Expense 640.000.03 Reserve Studies $1,695.00 $0.00 $1,695.00 640.000.03 Reserve Studies $1,695.00 $0.00 $1,695.00 Total costs unchanged 640.000.05 General Administrative $9,118.00 $190.00 $9,308.00 640.000.05 General Administrative $11,347.00 $0.00 $11,347.00 Operating fund too low difference is $-2,229.00 Replacement fund too high difference is $190.00 Cost too low difference is $-2,039.00 640.000.07 Office supplies/printing/postage $20,315.00 $0.00 $20,315.00 640.000.07 Office supplies/printing/postage $13,283.00 $0.00 $13,283.00 Operating fund too high difference is $7,032.00 Cost too high difference is $7,032.00 720.000.08 Landscape Expense $173,868.00 $0.00 $173,868.00 720.000.08 Landscape Expense $158,714.00 $43,104.00 $201,818.00 Operating fund too high difference is $15,154.00 Replacement fund too low difference is $-43,104.00 Cost too low difference is $-27,950.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 $16,886.00 $0.00 $16,886.00 760.000.07 Legal and collection $13,747.00 $0.00 $13,747.00 Operating fund too high difference is $3,139.00 Cost too high difference is $3,139.00 780.000.01 Property Protection - Patrol Service $50,210.00 $0.00 $50,210.00 780.000.01 Property Protection - Patrol Service $34,427.00 $0.00 $34,427.00 Operating fund too high difference is $15,783.00 Cost too high difference is $15,783.00 840.001.05 General Repair & Maintenance $31,255.00 $6,983.00 $38,238.00 840.001.05 General Repair & Maintenance $26,458.00 $0.00 $26,458.00 Operating fund too high difference is $4,797.00 Replacement fund too high difference is $6,983.00 Cost too high difference is $11,780.00 840.001.11 Common Areas $0.00 $5,250.00 $5,250.00 Added Asset(s) Expense 840.002.04 Janitorial Combined Costs $15,001.00 $0.00 $15,001.00 840.002.04 Janitorial Combined Costs $13,729.00 $0.00 $13,729.00 Operating fund too high difference is $1,272.00 Cost too high difference is $1,272.00 840.004.03 Pest Control $1,778.00 $0.00 $1,778.00 840.004.03 Pest Control $5,708.00 $0.00 $5,708.00 Operating fund too low difference is $-3,930.00 Cost too low difference is $-3,930.00 840.006.03 Pool Supplies/Repair & Maintenance $29,064.00 $71,282.00 $100,346.00 840.006.03 Pool Supplies/Repair & Maintenance $33,071.00 $51,999.00 $85,070.00 Operating fund too low difference is $-4,007.00 Replacement fund too high difference is $19,283.00 Cost too high difference is $15,276.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $24,665.00 $24,665.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $6,970.00 $6,970.00 Replacement fund too high difference is $17,695.00 Cost too high difference is $17,695.00 840.007.02 Tot Lot $0.00 $44,632.00 $44,632.00 Added Asset(s) Expense 860.000.02 Gas Service $12,884.00 $0.00 $12,884.00 860.000.02 Gas Service $13,838.00 $0.00 $13,838.00 Operating fund too low difference is $-954.00 Cost too low difference is $-954.00 860.000.03 Telephone Service $3,606.00 $0.00 $3,606.00 860.000.03 Telephone Service $4,096.00 $0.00 $4,096.00 Operating fund too low difference is $-490.00 Cost too low difference is $-490.00 860.000.04 Trash and Recycling Service $1,178.00 $0.00 $1,178.00 860.000.04 Trash and Recycling Service $2,261.00 $0.00 $2,261.00 Operating fund too low difference is $-1,083.00 Cost too low difference is $-1,083.00 860.000.05 Water Service $35,983.00 $0.00 $35,983.00 860.000.05 Water Service $37,530.00 $0.00 $37,530.00 Operating fund too low difference is $-1,547.00 Cost too low difference is $-1,547.00 880.000.01 Federal Income Tax $10.00 $1,204.00 $1,214.00 880.000.01 Federal Income Tax $10.00 $609.00 $619.00 Operating costs unchanged Replacement fund too high difference is $595.00 Cost too high difference is $595.00 900.000.05 Bad debt expense $2,879.00 $0.00 $2,879.00 Added Asset(s) Expense 920.000.02 Lighting $0.00 $3,465.00 $3,465.00 Added Asset(s) Expense 2014 - 2015 Analysis Summary Estimated inflation 2% Consumer Price Index 1.6% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2014 $542,311.00 $155,507.00 $697,818.00 Revenue 2015 $562,965.00 $172,473.00 $735,438.00 Expense 2014 $498,522.00 $152,564.00 $651,086.00 Expense 2015 $536,354.00 $107,789.00 $644,143.00 revenue - expense 2014 $43,789.00 $2,943.00 $46,732.00 revenue - expense 2015 $26,611.00 $64,684.00 $91,295.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $-17,178.00 $61,741.00 $44,563.00 percent difference -39.23% 2197.89% 195.36% Total Assets 24 Total Issues 98 Issues/Asset 4.08 count % Description 5 20.83% Added Asset(s) 1 4.17% Deleted Asset(s) 8 33.33% Operating fund too high 8 33.33% Operating fund too low 7 29.17% Replacement fund too high 2 8.33% Replacement fund too low 9 37.50% Cost too high 9 37.50% Cost too low 2 8.33% Total costs unchanged 1 4.17% Operating costs unchanged Park Paseo Homeowners Association UnAudited Forensic Report For 2014 to 2015 Revenue 505.000.01 Homeowners Association Fees $543,483.00 $169,017.00 $712,500.00 505.000.01 Homeowners Association Fees $523,524.00 $143,976.00 $667,500.00 Replacement fund too high difference is $25,041.00 520.000.01 Clubhouse Rental Fee $8,100.00 $0.00 $8,100.00 520.000.01 Clubhouse Rental Fee $8,625.00 $0.00 $8,625.00 Operating fund too low difference is $-525.00 Cost too low difference is $-525.00 540.000.04 Recovery of Bad Debt $100.00 $0.00 $100.00 Added Asset(s) Revenue 540.000.05 Miscellaneous Income $850.00 $0.00 $850.00 Deleted Asset(s) Revenue 540.000.10 Other Income $10,930.00 $0.00 $10,930.00 540.000.10 Other Income $9,212.00 $9,330.00 $18,542.00 Operating fund too high difference is $1,718.00 Replacement fund too low difference is $-9,330.00 Cost too low difference is $-7,612.00 550.000.03 Investment Income $452.00 $3,456.00 $3,908.00 550.000.03 Investment Income $0.00 $2,201.00 $2,201.00 Operating fund too high difference is $452.00 Replacement fund too high difference is $1,255.00 Cost too high difference is $1,707.00 Expense 640.000.03 Reserve Studies $1,695.00 $0.00 $1,695.00 640.000.03 Reserve Studies $1,695.00 $0.00 $1,695.00 Total costs unchanged 640.000.05 General Administrative $9,118.00 $190.00 $9,308.00 640.000.05 General Administrative $11,347.00 $0.00 $11,347.00 Operating fund too low difference is $-2,229.00 Replacement fund too high difference is $190.00 Cost too low difference is $-2,039.00 640.000.07 Office supplies/printing/postage $20,315.00 $0.00 $20,315.00 640.000.07 Office supplies/printing/postage $13,283.00 $0.00 $13,283.00 Operating fund too high difference is $7,032.00 Cost too high difference is $7,032.00 720.000.08 Landscape Expense $173,868.00 $0.00 $173,868.00 720.000.08 Landscape Expense $158,714.00 $43,104.00 $201,818.00 Operating fund too high difference is $15,154.00 Replacement fund too low difference is $-43,104.00 Cost too low difference is $-27,950.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 $16,886.00 $0.00 $16,886.00 760.000.07 Legal and collection $13,747.00 $0.00 $13,747.00 Operating fund too high difference is $3,139.00 Cost too high difference is $3,139.00 780.000.01 Property Protection - Patrol Service $50,210.00 $0.00 $50,210.00 780.000.01 Property Protection - Patrol Service $34,427.00 $0.00 $34,427.00 Operating fund too high difference is $15,783.00 Cost too high difference is $15,783.00 840.001.05 General Repair & Maintenance $31,255.00 $6,983.00 $38,238.00 840.001.05 General Repair & Maintenance $26,458.00 $0.00 $26,458.00 Operating fund too high difference is $4,797.00 Replacement fund too high difference is $6,983.00 Cost too high difference is $11,780.00 840.001.11 Common Areas $0.00 $5,250.00 $5,250.00 Added Asset(s) Expense 840.002.04 Janitorial Combined Costs $15,001.00 $0.00 $15,001.00 840.002.04 Janitorial Combined Costs $13,729.00 $0.00 $13,729.00 Operating fund too high difference is $1,272.00 Cost too high difference is $1,272.00 840.004.03 Pest Control $1,778.00 $0.00 $1,778.00 840.004.03 Pest Control $5,708.00 $0.00 $5,708.00 Operating fund too low difference is $-3,930.00 Cost too low difference is $-3,930.00 840.006.03 Pool Supplies/Repair & Maintenance $29,064.00 $71,282.00 $100,346.00 840.006.03 Pool Supplies/Repair & Maintenance $33,071.00 $51,999.00 $85,070.00 Operating fund too low difference is $-4,007.00 Replacement fund too high difference is $19,283.00 Cost too high difference is $15,276.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $24,665.00 $24,665.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $6,970.00 $6,970.00 Replacement fund too high difference is $17,695.00 Cost too high difference is $17,695.00 840.007.02 Tot Lot $0.00 $44,632.00 $44,632.00 Added Asset(s) Expense 860.000.02 Gas Service $12,884.00 $0.00 $12,884.00 860.000.02 Gas Service $13,838.00 $0.00 $13,838.00 Operating fund too low difference is $-954.00 Cost too low difference is $-954.00 860.000.03 Telephone Service $3,606.00 $0.00 $3,606.00 860.000.03 Telephone Service $4,096.00 $0.00 $4,096.00 Operating fund too low difference is $-490.00 Cost too low difference is $-490.00 860.000.04 Trash and Recycling Service $1,178.00 $0.00 $1,178.00 860.000.04 Trash and Recycling Service $2,261.00 $0.00 $2,261.00 Operating fund too low difference is $-1,083.00 Cost too low difference is $-1,083.00 860.000.05 Water Service $35,983.00 $0.00 $35,983.00 860.000.05 Water Service $37,530.00 $0.00 $37,530.00 Operating fund too low difference is $-1,547.00 Cost too low difference is $-1,547.00 880.000.01 Federal Income Tax $10.00 $1,204.00 $1,214.00 880.000.01 Federal Income Tax $10.00 $609.00 $619.00 Operating costs unchanged Replacement fund too high difference is $595.00 Cost too high difference is $595.00 900.000.05 Bad debt expense $2,879.00 $0.00 $2,879.00 Added Asset(s) Expense 920.000.02 Lighting $0.00 $3,465.00 $3,465.00 Added Asset(s) Expense 2014 - 2015 Analysis Summary Estimated inflation 2% Consumer Price Index 1.6% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2014 $542,311.00 $155,507.00 $697,818.00 Revenue 2015 $562,965.00 $172,473.00 $735,438.00 Expense 2014 $498,522.00 $152,564.00 $651,086.00 Expense 2015 $536,354.00 $107,789.00 $644,143.00 revenue - expense 2014 $43,789.00 $2,943.00 $46,732.00 revenue - expense 2015 $26,611.00 $64,684.00 $91,295.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $-17,178.00 $61,741.00 $44,563.00 percent difference -39.23% 2197.89% 195.36% Total Assets 24 Total Issues 98 Issues/Asset 4.08 count % Description 5 20.83% Added Asset(s) 1 4.17% Deleted Asset(s) 8 33.33% Operating fund too high 8 33.33% Operating fund too low 7 29.17% Replacement fund too high 2 8.33% Replacement fund too low 9 37.50% Cost too high 9 37.50% Cost too low 2 8.33% Total costs unchanged 1 4.17% Operating costs unchanged Park Paseo Homeowners Association RDA Forensic Analysis For 2014 to 2015 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 020.000.03 Clubhouse, Tile Clubhouse, Tile 0 35 $54,000.00 $54,000.00 $54,000.00 020.000.03 Clubhouse, Tile Clubhouse, Tile 34 35 $55,080.00 $929.81 $0.00 Maintenance completed 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 47 50 $11,204.00 $672.00 $0.00 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 46 50 $11,428.08 $913.81 $0.00 No assigned value 030.001.03 Interior Prosa R Interior Prosa Restrooms 6 8 $1,570.00 $328.00 $328.00 030.001.03 Interior Prosa R Interior Prosa Restrooms 5 8 $1,601.40 $545.40 $545.40 Fully funded value too low should be $600.53 Assigned value too low should be $600.53 030.001.06 Stucco Stucco 7 10 $3,142.00 $827.00 $827.00 030.001.06 Stucco Stucco 6 10 $3,204.84 $1,180.42 $1,180.42 Fully funded value too low should be $1,281.94 Assigned value too low should be $1,281.94 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $166.00 $166.00 $166.00 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $165.78 $165.78 $165.78 Maintenance deferred 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 26 30 $139,155.00 $17,540.00 $0.00 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 25 30 $141,938.09 $22,662.37 $310.25 Assigned value too low should be $23,656.35 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 17 20 $924.00 $115.00 $0.00 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 16 20 $942.48 $165.89 $165.89 Fully funded value too low should be $188.50 Assigned value too low should be $188.50 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 17 20 $2,500.00 $330.00 $0.00 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 16 20 $2,550.00 $457.45 $457.45 Fully funded value too low should be $510.00 Assigned value too low should be $510.00 050.000.01 Exterior, Pool/C Exterior, Pool/Club 0 10 $13,350.00 $13,350.00 $13,350.00 050.000.01 Exterior, Pool/C Exterior, Pool/Club 0 10 $13,598.00 $13,598.00 $13,598.00 Maintenance deferred 050.000.05 Exterior, Prosa Exterior, Prosa 0 10 $2,580.00 $2,580.00 $2,580.00 050.000.05 Exterior, Prosa Exterior, Prosa 0 10 $2,630.00 $2,630.00 $2,630.00 Maintenance deferred 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 0 15 $110,000.00 $110,000.00 $110,000.00 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 0 15 $110,000.03 $110,000.03 $110,000.03 Maintenance deferred 060.001.04 Carpet, Replace Carpet, Replace 0 8 $11,770.00 $11,770.00 $11,770.00 060.001.04 Carpet, Replace Carpet, Replace 7 8 $12,005.40 $354.55 $354.55 Maintenance completed 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 14 20 $3,386.00 $1,016.00 $0.00 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 19 20 $30,312.36 $1,051.78 $1,051.78 Maintenance completed 060.001.13 HVAC Heat/Air, C HVAC Heat/Air, Clubhouse 0 20 $29,718.00 $29,718.00 $29,718.00 Asset deleted 060.001.15 Water Heater Water Heater 0 12 $3,433.00 $3,433.00 $3,433.00 060.001.15 Water Heater Water Heater 0 12 $3,501.00 $3,501.00 $3,501.00 Maintenance deferred 060.002.03 Doors, Entry Doors, Entry 0 25 $15,132.00 $15,132.00 $15,132.00 060.002.03 Doors, Entry Doors, Entry 0 25 $15,432.00 $15,432.00 $15,432.00 Maintenance deferred 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 0 25 $6,244.00 $6,244.00 $6,244.00 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 0 25 $6,368.00 $6,368.00 $6,368.00 Maintenance deferred 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 3 8 $10,000.00 $6,949.00 $6,949.00 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 2 8 $10,000.00 $7,966.10 $7,966.10 Cost not changed 065.001.03 Heater, Main Heater, Main 2 12 $20,000.00 $17,433.00 $17,433.00 065.001.03 Heater, Main Heater, Main 11 12 $20,400.00 $1,110.17 $1,110.17 Maintenance completed 065.001.04 Motor/Pump Syste Motor/Pump System 7 8 $7,000.00 $538.00 $538.00 065.001.04 Motor/Pump Syste Motor/Pump System 6 8 $7,140.00 $1,490.77 $1,490.77 Fully funded value too low should be $1,785.00 Assigned value too low should be $1,785.00 065.002.02 Spa, Heater Spa, Heater 1 10 $3,250.00 $3,000.00 $3,000.00 065.002.02 Spa, Heater Spa, Heater 12 10 $3,315.00 $183.45 $183.45 Maintenance completed 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 0 8 $1,100.00 $1,100.00 $1,100.00 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 0 8 $1,122.00 $1,122.00 $1,122.00 Maintenance deferred 065.002.04 Spa, Pump/Motor, Spa, Pump/Motor, Booster 2 8 $2,600.00 $2,229.00 $2,229.00 065.002.04 Spa, Pump/Motor, Spa, Pump/Motor, Booster 1 8 $2,652.00 $2,462.57 $2,462.57 Fully funded value too high should be $2,320.50 Assigned value too high should be $2,320.50 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 7 8 $950.00 $101.00 $101.00 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 6 8 $969.00 $226.79 $226.79 Fully funded value too low should be $242.25 Assigned value too low should be $242.25 067.002.03 Deck Repairs Deck Repairs 0 30 $25,000.00 $25,000.00 $25,000.00 067.002.03 Deck Repairs Deck Repairs 0 30 $25,000.00 $25,000.00 $25,000.00 Maintenance deferred Cost not changed 067.003.02 Furniture, 2001 Furniture, 2001 0 7 $18,625.00 $18,625.00 $18,625.00 067.003.02 Furniture, 2001 Furniture, 2001 0 7 $18,981.00 $18,981.00 $18,981.00 Maintenance deferred 067.003.03 Furniture, 2007 Furniture, 2007 0 7 $15,276.00 $15,276.00 $15,276.00 067.003.03 Furniture, 2007 Furniture, 2007 0 7 $15,581.00 $15,581.00 $15,581.00 Maintenance deferred 069.001.04 Heater, Prosa Heater, Prosa 0 12 $15,000.00 $15,000.00 $15,000.00 069.001.04 Heater, Prosa Heater, Prosa 11 12 $15,300.00 $488.46 $488.46 Maintenance completed 070.001.01 Aluminum Trellis Aluminum Trellis 26 30 $11,400.00 $1,520.00 $0.00 070.001.01 Aluminum Trellis Aluminum Trellis 25 30 $11,628.00 $1,938.00 $0.00 No assigned value 070.001.02 Barbecues Barbecues 5 8 $3,811.00 $1,242.00 $1,242.00 070.001.02 Barbecues Barbecues 4 8 $3,887.22 $1,790.64 $1,790.64 Fully funded value too low should be $1,943.61 Assigned value too low should be $1,943.61 070.001.05 Furniture Furniture 0 7 $8,705.00 $8,705.00 $8,705.00 070.001.05 Furniture Furniture 0 7 $8,865.00 $8,865.00 $8,865.00 Maintenance deferred 070.002.01 Ceramic Shower Ceramic Shower 0 25 $6,978.00 $6,978.00 $6,978.00 070.002.01 Ceramic Shower Ceramic Shower 0 25 $7,099.79 $7,099.79 $7,099.79 Maintenance deferred 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 5 25 $8,913.00 $7,708.00 $7,708.00 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 4 25 $9,091.26 $8,088.70 $8,088.70 Fully funded value too high should be $7,636.66 Assigned value too high should be $7,636.66 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,433.00 $3,433.00 $3,433.00 070.004.01 Water Heater Water Heater 0 18 $3,501.00 $3,501.00 $3,501.00 Maintenance deferred 080.000.02 Chain Link Fenci Chain Link Fencing 6 30 $19,336.00 $16,638.00 $16,638.00 080.000.02 Chain Link Fenci Chain Link Fencing 5 30 $19,722.72 $17,327.12 $17,327.12 Fully funded value too high should be $16,435.60 Assigned value too high should be $16,435.60 085.002.01 Drinking Fountai Drinking Fountain, C/H 13 16 $2,879.00 $451.00 $0.00 085.002.01 Drinking Fountai Drinking Fountain, C/H 12 16 $2,936.58 $650.68 $650.68 Fully funded value too low should be $734.14 Assigned value too low should be $734.14 085.002.03 Drinking Fountai Drinking Fountain, Prosa 0 16 $1,452.00 $1,452.00 $1,452.00 085.002.03 Drinking Fountai Drinking Fountain, Prosa 0 16 $1,481.00 $1,481.00 $1,481.00 Maintenance deferred 085.003.04 Sand Repl, Alba Sand Repl, Alba 0 10 $7,000.00 $7,000.00 $7,000.00 085.003.04 Sand Repl, Alba Sand Repl, Alba 9 10 $7,140.00 $480.69 $480.69 Maintenance completed 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 0 10 $6,000.00 $6,000.00 $6,000.00 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 9 10 $2,929.00 $292.86 $292.86 Maintenance completed 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $6,000.00 $6,000.00 $6,000.00 085.004.04 Sand Repl, Main Sand Repl, Main 0 10 $6,000.00 $6,000.00 $6,000.00 Maintenance deferred Cost not changed 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 3 12 $4,634.00 $3,816.00 $3,816.00 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 2 12 $4,726.68 $4,170.88 $4,170.88 Fully funded value too high should be $3,938.90 Assigned value too high should be $3,938.90 090.000.02 Trellis, Clubhou Trellis, Clubhouse 27 30 $43,323.00 $3,783.00 $0.00 090.000.02 Trellis, Clubhou Trellis, Clubhouse 26 30 $44,189.46 $5,352.47 $0.00 Fully funded value too low should be $5,891.93 No assigned value 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 2 3 $30,600.00 $9,272.73 $9,272.73 Maintenance completed 100.000.02 Monument Monument 0 30 $3,167.00 $3,167.00 $3,167.00 100.000.02 Monument Monument 0 30 $3,230.00 $3,230.00 $3,230.00 Maintenance deferred 2014 - 2015 RDA Forensic Analysis Summary Estimated inflation 2% Consumer Price Index 1.6% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $1,452,112.00 $830,196.20 $737,418.20 This Year Costs $1,470,769.77 $743,341.55 $711,855.26 Calculated Costs $1,474,309.52 $746,489.77 $746,489.77 Comparing This Year Costs to Last Year Costs Difference $18,657.77 $-86,854.65 $-25,562.94 percent difference 1.28% -10.46% -3.47% Comparing This Year Costs to Calculated Costs Difference $-3,539.75 $-3,148.22 $-34,634.51 percent difference -0.24% -0.42% -4.87% 115 Total Assets 22 Total Issues $87,948.20 Unfunded Liability 0.19 Issues / Asset number % Description 3 2.61% No assigned value 4 3.48% Fully funded value too high 9 7.83% Fully funded value too low 4 3.48% Assigned value too high 9 7.83% Assigned value too low 1 0.87% Asset deleted 18 15.65% Maintenance deferred 9 7.83% Maintenance completed 24 20.87% Total assets to be maintained 4 3.48% Cost not changed