Park Paseo Homeowners Association Audited Forensic Report For 2017 to 2018 Revenue 505.000.01 Homeowners Association Fees $638,520.00 $193,980.00 $832,500.00 505.000.01 Homeowners Association Fees $584,628.00 $210,372.00 $795,000.00 Operating fund too high difference is $53,892.00 Replacement fund too low difference is $-16,392.00 520.000.01 Clubhouse Rental Fee $8,100.00 $0.00 $8,100.00 520.000.01 Clubhouse Rental Fee $3,840.00 $0.00 $3,840.00 Operating fund too high difference is $4,260.00 Cost too high difference is $4,260.00 540.000.04 Recovery of Bad Debt $2,888.00 $0.00 $2,888.00 540.000.04 Recovery of Bad Debt $2,000.00 $0.00 $2,000.00 Operating fund too high difference is $888.00 Cost too high difference is $888.00 540.000.10 Other Income $8,690.00 $0.00 $8,690.00 540.000.10 Other Income $5,046.00 $0.00 $5,046.00 Operating fund too high difference is $3,644.00 Cost too high difference is $3,644.00 550.000.03 Investment Income $1,342.00 $13,682.00 $15,024.00 550.000.03 Investment Income $1,153.00 $5,113.00 $6,266.00 Operating fund too high difference is $189.00 Replacement fund too high difference is $8,569.00 Cost too high difference is $8,758.00 Expense 640.000.05 General Administrative $26,984.00 $0.00 $26,984.00 640.000.05 General Administrative $17,903.00 $106.00 $18,009.00 Operating fund too high difference is $9,081.00 Replacement fund too low difference is $-106.00 Cost too high difference is $8,975.00 640.000.07 Office supplies/printing/postage $20,955.00 $0.00 $20,955.00 640.000.07 Office supplies/printing/postage $14,576.00 $0.00 $14,576.00 Operating fund too high difference is $6,379.00 Cost too high difference is $6,379.00 700.000.01 Insurance $15,909.00 $0.00 $15,909.00 700.000.01 Insurance $14,815.00 $0.00 $14,815.00 Operating fund too high difference is $1,094.00 Cost too high difference is $1,094.00 720.000.08 Landscape Expense $246,807.00 $0.00 $246,807.00 720.000.08 Landscape Expense $210,111.00 $3,698.00 $213,809.00 Operating fund too high difference is $36,696.00 Replacement fund too low difference is $-3,698.00 Cost too high difference is $32,998.00 760.000.07 Legal and collection $4,010.00 $0.00 $4,010.00 760.000.07 Legal and collection $4,881.00 $0.00 $4,881.00 Operating fund too low difference is $-871.00 Cost too low difference is $-871.00 760.000.08 Audit/tax preparation/reserve study $3,395.00 $0.00 $3,395.00 760.000.08 Audit/tax preparation/reserve study $3,395.00 $0.00 $3,395.00 Total costs unchanged 840.001.05 General Repair & Maintenance $27,844.00 $0.00 $27,844.00 840.001.05 General Repair & Maintenance $52,932.00 $0.00 $52,932.00 Operating fund too low difference is $-25,088.00 Cost too low difference is $-25,088.00 840.001.10 Other Repair & Maintenance $0.00 $15,718.00 $15,718.00 Added Asset(s) Expense 840.001.11 Common Areas $0.00 $1,065.00 $1,065.00 Added Asset(s) Expense 840.004.03 Pest Control $3,618.00 $0.00 $3,618.00 840.004.03 Pest Control $4,533.00 $3,744.00 $8,277.00 Operating fund too low difference is $-915.00 Replacement fund too low difference is $-3,744.00 Cost too low difference is $-4,659.00 840.006.03 Pool Supplies/Repair & Maintenance $41,311.00 $6,882.00 $48,173.00 840.006.03 Pool Supplies/Repair & Maintenance $42,533.00 $0.00 $42,533.00 Replacement fund too high difference is $6,882.00 Cost too high difference is $5,640.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $5,746.00 $5,746.00 Deleted Asset(s) Expense 840.007.02 Tot Lot $0.00 $4,224.00 $4,224.00 Added Asset(s) Expense 860.000.01 Electric Service $30,950.00 $0.00 $30,950.00 860.000.01 Electric Service $32,004.00 $0.00 $32,004.00 Operating fund too low difference is $-1,054.00 Cost too low difference is $-1,054.00 860.000.02 Gas Service $14,598.00 $0.00 $14,598.00 860.000.02 Gas Service $11,672.00 $0.00 $11,672.00 Operating fund too high difference is $2,926.00 Cost too high difference is $2,926.00 860.000.03 Telephone Service $4,439.00 $0.00 $4,439.00 860.000.03 Telephone Service $3,801.00 $0.00 $3,801.00 Operating fund too high difference is $638.00 Cost too high difference is $638.00 860.000.05 Water Service $63,153.00 $0.00 $63,153.00 860.000.05 Water Service $46,308.00 $0.00 $46,308.00 Operating fund too high difference is $16,845.00 Cost too high difference is $16,845.00 2017 - 2018 Analysis Summary Estimated inflation 2% Consumer Price Index 2.1% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2017 $596,667.00 $215,485.00 $812,152.00 Revenue 2018 $659,540.00 $207,662.00 $867,202.00 Expense 2017 $621,015.00 $34,301.00 $655,316.00 Expense 2018 $670,721.00 $6,882.00 $677,583.00 revenue - expense 2017 $-24,348.00 $181,184.00 $156,836.00 revenue - expense 2018 $-11,181.00 $200,780.00 $189,619.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $13,167.00 $19,596.00 $32,783.00 percent difference 45.92% 110.82% 120.90% Total Assets 22 Total Issues 82 Issues/Asset 3.73 count % Description 3 13.64% Added Asset(s) 1 4.55% Deleted Asset(s) 12 54.55% Operating fund too high 4 18.18% Operating fund too low 2 9.09% Replacement fund too high 4 18.18% Replacement fund too low 12 54.55% Cost too high 4 18.18% Cost too low 1 4.55% Total costs unchanged Park Paseo Homeowners Association UnAudited Forensic Report For 2017 to 2018 Revenue 505.000.01 Homeowners Association Fees $638,520.00 $193,980.00 $832,500.00 505.000.01 Homeowners Association Fees $584,628.00 $210,372.00 $795,000.00 Operating fund too high difference is $53,892.00 Replacement fund too low difference is $-16,392.00 520.000.01 Clubhouse Rental Fee $8,100.00 $0.00 $8,100.00 520.000.01 Clubhouse Rental Fee $3,840.00 $0.00 $3,840.00 Operating fund too high difference is $4,260.00 Cost too high difference is $4,260.00 540.000.04 Recovery of Bad Debt $2,888.00 $0.00 $2,888.00 540.000.04 Recovery of Bad Debt $2,000.00 $0.00 $2,000.00 Operating fund too high difference is $888.00 Cost too high difference is $888.00 540.000.10 Other Income $8,690.00 $0.00 $8,690.00 540.000.10 Other Income $5,046.00 $0.00 $5,046.00 Operating fund too high difference is $3,644.00 Cost too high difference is $3,644.00 550.000.03 Investment Income $1,342.00 $13,682.00 $15,024.00 550.000.03 Investment Income $1,153.00 $5,113.00 $6,266.00 Operating fund too high difference is $189.00 Replacement fund too high difference is $8,569.00 Cost too high difference is $8,758.00 Expense 640.000.05 General Administrative $26,984.00 $0.00 $26,984.00 640.000.05 General Administrative $17,903.00 $106.00 $18,009.00 Operating fund too high difference is $9,081.00 Replacement fund too low difference is $-106.00 Cost too high difference is $8,975.00 640.000.07 Office supplies/printing/postage $20,955.00 $0.00 $20,955.00 640.000.07 Office supplies/printing/postage $14,576.00 $0.00 $14,576.00 Operating fund too high difference is $6,379.00 Cost too high difference is $6,379.00 700.000.01 Insurance $15,909.00 $0.00 $15,909.00 700.000.01 Insurance $14,815.00 $0.00 $14,815.00 Operating fund too high difference is $1,094.00 Cost too high difference is $1,094.00 720.000.08 Landscape Expense $246,807.00 $0.00 $246,807.00 720.000.08 Landscape Expense $210,111.00 $3,698.00 $213,809.00 Operating fund too high difference is $36,696.00 Replacement fund too low difference is $-3,698.00 Cost too high difference is $32,998.00 760.000.07 Legal and collection $4,010.00 $0.00 $4,010.00 760.000.07 Legal and collection $4,881.00 $0.00 $4,881.00 Operating fund too low difference is $-871.00 Cost too low difference is $-871.00 760.000.08 Audit/tax preparation/reserve study $3,395.00 $0.00 $3,395.00 760.000.08 Audit/tax preparation/reserve study $3,395.00 $0.00 $3,395.00 Total costs unchanged 840.001.05 General Repair & Maintenance $27,844.00 $0.00 $27,844.00 840.001.05 General Repair & Maintenance $52,932.00 $0.00 $52,932.00 Operating fund too low difference is $-25,088.00 Cost too low difference is $-25,088.00 840.001.10 Other Repair & Maintenance $0.00 $15,718.00 $15,718.00 Added Asset(s) Expense 840.001.11 Common Areas $0.00 $1,065.00 $1,065.00 Added Asset(s) Expense 840.004.03 Pest Control $3,618.00 $0.00 $3,618.00 840.004.03 Pest Control $4,533.00 $3,744.00 $8,277.00 Operating fund too low difference is $-915.00 Replacement fund too low difference is $-3,744.00 Cost too low difference is $-4,659.00 840.006.03 Pool Supplies/Repair & Maintenance $41,311.00 $6,882.00 $48,173.00 840.006.03 Pool Supplies/Repair & Maintenance $42,533.00 $0.00 $42,533.00 Replacement fund too high difference is $6,882.00 Cost too high difference is $5,640.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $5,746.00 $5,746.00 Deleted Asset(s) Expense 840.007.02 Tot Lot $0.00 $4,224.00 $4,224.00 Added Asset(s) Expense 860.000.01 Electric Service $30,950.00 $0.00 $30,950.00 860.000.01 Electric Service $32,004.00 $0.00 $32,004.00 Operating fund too low difference is $-1,054.00 Cost too low difference is $-1,054.00 860.000.02 Gas Service $14,598.00 $0.00 $14,598.00 860.000.02 Gas Service $11,672.00 $0.00 $11,672.00 Operating fund too high difference is $2,926.00 Cost too high difference is $2,926.00 860.000.03 Telephone Service $4,439.00 $0.00 $4,439.00 860.000.03 Telephone Service $3,801.00 $0.00 $3,801.00 Operating fund too high difference is $638.00 Cost too high difference is $638.00 860.000.05 Water Service $63,153.00 $0.00 $63,153.00 860.000.05 Water Service $46,308.00 $0.00 $46,308.00 Operating fund too high difference is $16,845.00 Cost too high difference is $16,845.00 2017 - 2018 Analysis Summary Estimated inflation 2% Consumer Price Index 2.1% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2017 $596,667.00 $215,485.00 $812,152.00 Revenue 2018 $659,540.00 $207,662.00 $867,202.00 Expense 2017 $621,015.00 $34,301.00 $655,316.00 Expense 2018 $670,721.00 $6,882.00 $677,583.00 revenue - expense 2017 $-24,348.00 $181,184.00 $156,836.00 revenue - expense 2018 $-11,181.00 $200,780.00 $189,619.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $13,167.00 $19,596.00 $32,783.00 percent difference 45.92% 110.82% 120.90% Total Assets 22 Total Issues 82 Issues/Asset 3.73 count % Description 3 13.64% Added Asset(s) 1 4.55% Deleted Asset(s) 12 54.55% Operating fund too high 4 18.18% Operating fund too low 2 9.09% Replacement fund too high 4 18.18% Replacement fund too low 12 54.55% Cost too high 4 18.18% Cost too low 1 4.55% Total costs unchanged Park Paseo Homeowners Association RDA Forensic Analysis For 2017 to 2018 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 020.000.05 DaVinci Roof, Cl DaVinci Roof, Clubhouse 32 35 $50,303.00 $3,869.00 $0.00 020.000.05 DaVinci Roof, Cl DaVinci Roof, Clubhouse 31 35 $51,309.00 $5,427.00 $0.00 Fully funded value too low should be $5,863.89 No assigned value 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 44 50 $11,880.00 $1,426.00 $0.00 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 43 50 $12,109.00 $1,695.00 $0.00 No assigned value 030.001.01 Aluminum, Pools Aluminum, Pools 18 25 $10,681.00 $2,991.00 $0.00 030.001.01 Aluminum, Pools Aluminum, Pools 17 25 $10,855.00 $3,474.00 $0.00 No assigned value 030.001.04 Interior Rec Are Interior Rec Area, Clubhouse 7 7 $7,700.00 $0.00 $0.00 030.001.04 Interior Rec Are Interior Rec Area, Clubhouse 6 7 $7,700.00 $1,100.00 $1,100.00 Cost not changed 030.001.06 Stucco Stucco 5 10 $3,333.00 $1,746.00 $0.00 030.001.06 Stucco Stucco 5 10 $3,399.00 $1,921.00 $1,921.00 Remaining life not changed Fully funded value too high should be $1,699.83 Assigned value too high should be $1,699.83 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $178.00 $178.00 $178.00 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $184.00 $184.00 $184.00 Maintenance deferred 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 18 25 $147,671.00 $40,274.00 $0.00 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 17 25 $150,624.00 $47,165.00 $0.00 No assigned value 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 18 25 $52,966.00 $14,830.00 $0.00 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 17 25 $54,025.00 $17,288.00 $0.00 No assigned value 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 14 20 $978.00 $273.00 $0.00 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 13 20 $994.00 $329.00 $0.00 Fully funded value too low should be $349.15 No assigned value 040.000.04 W/I, Delamesa/Ca W/I, Delamesa/Campanero 14 20 $6,877.00 $2,063.00 $0.00 040.000.04 W/I, Delamesa/Ca W/I, Delamesa/Campanero 13 20 $7,012.00 $2,454.00 $0.00 No assigned value 040.000.05 Walls, Block, Re Walls, Block, Repairs 0 20 $5,000.00 $5,000.00 $5,000.00 040.000.05 Walls, Block, Re Walls, Block, Repairs 0 20 $5,000.00 $5,000.00 $5,000.00 Maintenance deferred Cost not changed 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 14 20 $2,500.00 $713.00 $0.00 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 13 20 $2,500.00 $840.00 $0.00 Cost not changed 050.000.01 Exterior, Pool/C Exterior, Pool/Club 3 10 $13,986.00 $12,465.00 $12,465.00 050.000.01 Exterior, Pool/C Exterior, Pool/Club 2 10 $14,186.00 $13,157.00 $13,157.00 Fully funded value too high should be $11,412.58 Assigned value too high should be $11,412.58 050.000.05 Exterior, Prosa Exterior, Prosa 3 10 $2,698.00 $2,405.00 $2,405.00 050.000.05 Exterior, Prosa Exterior, Prosa 2 10 $2,730.00 $2,532.00 $2,532.00 Fully funded value too high should be $2,201.57 Assigned value too high should be $2,201.57 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 0 15 $105,650.00 $105,650.00 $105,650.00 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 14 15 $109,829.00 $5,585.00 $0.00 Maintenance completed 050.001.02 Interior Clubhou Interior Clubhouse, 2016 25 25 $900.00 $0.00 $0.00 050.001.02 Interior Clubhou Interior Clubhouse, 2016 24 25 $917.00 $37.00 $0.00 No assigned value 060.001.02 Billiard Tables Billiard Tables 5 25 $10,102.00 $8,980.00 $0.00 060.001.02 Billiard Tables Billiard Tables 4 25 $10,272.00 $9,359.00 $9,359.00 Fully funded value too high should be $8,655.39 Assigned value too high should be $8,655.39 060.001.04 Carpet, Replace Carpet, Replace 5 8 $7,956.00 $2,531.00 $0.00 060.001.04 Carpet, Replace Carpet, Replace 4 8 $8,115.00 $3,689.00 $3,689.00 Fully funded value too low should be $4,057.56 Assigned value too low should be $4,057.56 060.001.08 Exterior Stairca Exterior Staircase 19 30 $19,091.00 $6,795.00 $0.00 060.001.08 Exterior Stairca Exterior Staircase 18 30 $19,472.00 $7,591.00 $0.00 No assigned value 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 25 25 $13,304.00 $0.00 $0.00 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 24 25 $13,570.00 $543.00 $0.00 No assigned value 060.001.10 Furnishings Furnishings 10 10 $35,000.00 $0.00 $0.00 060.001.10 Furnishings Furnishings 9 10 $35,000.00 $3,500.00 $0.00 Cost not changed 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 17 20 $28,818.00 $4,013.00 $0.00 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 16 20 $29,394.00 $5,581.00 $0.00 Fully funded value too low should be $5,878.87 No assigned value 060.001.14 Window Blinds Window Blinds 3 10 $16,258.00 $12,933.00 $12,933.00 060.001.14 Window Blinds Window Blinds 2 10 $16,583.00 $14,322.00 $14,322.00 Fully funded value too high should be $13,266.53 Assigned value too high should be $13,266.53 060.001.15 Water Heater Water Heater 14 16 $7,122.00 $724.00 $0.00 060.001.15 Water Heater Water Heater 13 16 $7,264.00 $1,204.00 $0.00 Fully funded value too low should be $1,362.08 No assigned value 060.002.02 Doors, Exterior, Doors, Exterior, Entry 13 25 $13,436.00 $6,355.00 $0.00 060.002.02 Doors, Exterior, Doors, Exterior, Entry 12 25 $13,704.00 $7,037.00 $0.00 No assigned value 060.002.03 Doors, Entry Doors, Entry 20 25 $10,668.00 $2,134.00 $0.00 060.002.03 Doors, Entry Doors, Entry 19 25 $10,880.00 $2,611.00 $0.00 No assigned value 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 6 25 $1,234.00 $1,073.00 $0.00 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 5 25 $1,254.00 $1,118.00 $1,118.00 Fully funded value too high should be $1,006.94 Assigned value too high should be $1,006.94 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 0 25 $25,000.00 $25,000.00 $25,000.00 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 0 25 $25,000.00 $25,000.00 $25,000.00 Maintenance deferred Cost not changed 060.002.08 Doors, Entry Int Doors, Entry Interior 6 25 $1,994.00 $1,631.00 $0.00 060.002.08 Doors, Entry Int Doors, Entry Interior 5 25 $2,029.00 $1,722.00 $1,722.00 Fully funded value too high should be $1,627.10 Assigned value too high should be $1,627.10 060.002.09 Doors, Kitchen Doors, Kitchen 25 25 $9,235.00 $0.00 $0.00 060.002.09 Doors, Kitchen Doors, Kitchen 24 25 $9,419.00 $377.00 $0.00 No assigned value 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 13 25 $25,266.00 $11,950.00 $0.00 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 12 25 $25,771.00 $13,234.00 $0.00 No assigned value 060.003.08 Kitchen, Sink Kitchen, Sink 13 25 $801.00 $379.00 $0.00 060.003.08 Kitchen, Sink Kitchen, Sink 12 25 $817.00 $420.00 $0.00 No assigned value 060.004.01 Office, Computer Office, Computers/Equipment 6 8 $6,500.00 $1,625.00 $0.00 060.004.01 Office, Computer Office, Computers/Equipment 5 8 $6,500.00 $2,438.00 $2,438.00 Cost not changed 060.004.09 Office, Equipmen Office, Equipment 4 8 $3,500.00 $1,750.00 $1,750.00 060.004.09 Office, Equipmen Office, Equipment 3 8 $3,500.00 $2,188.00 $2,188.00 Cost not changed 060.004.10 Office, Remodel Office, Remodel 10 20 $13,290.00 $6,589.00 $0.00 060.004.10 Office, Remodel Office, Remodel 9 20 $13,555.00 $7,404.00 $0.00 No assigned value 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 17 25 $12,062.00 $3,860.00 $0.00 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 16 25 $12,265.00 $4,416.00 $0.00 No assigned value 060.005.03 Restroom, Counte Restroom, Counters 12 20 $3,968.00 $1,587.00 $0.00 060.005.03 Restroom, Counte Restroom, Counters 11 20 $4,032.00 $1,814.00 $0.00 No assigned value 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 17 25 $2,348.00 $751.00 $0.00 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 16 25 $2,387.00 $859.00 $0.00 No assigned value 060.005.07 Restroom, Locker Restroom, Lockers/Benches 14 22 $20,000.00 $7,273.00 $0.00 060.005.07 Restroom, Locker Restroom, Lockers/Benches 13 22 $20,000.00 $8,182.00 $0.00 Cost not changed 060.005.08 Restroom, Partit Restroom, Partitions 12 20 $5,435.00 $2,174.00 $0.00 060.005.08 Restroom, Partit Restroom, Partitions 11 20 $5,525.00 $2,486.00 $0.00 No assigned value 060.005.12 Women's Shower Women's Shower 20 25 $3,502.00 $682.00 $0.00 060.005.12 Women's Shower Women's Shower 19 25 $3,572.00 $839.00 $0.00 No assigned value 060.005.13 Restroom, Fixtur Restroom, Fixtures 17 25 $7,475.00 $2,392.00 $0.00 060.005.13 Restroom, Fixtur Restroom, Fixtures 16 25 $7,596.00 $2,735.00 $0.00 No assigned value 065.001.03 Heater, Main Heater, Main 9 12 $20,212.00 $4,620.00 $0.00 065.001.03 Heater, Main Heater, Main 8 12 $20,616.00 $6,479.00 $6,479.00 Fully funded value too low should be $6,872.08 Assigned value too low should be $6,872.08 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 10 14 $77,636.00 $22,182.00 $0.00 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 9 14 $79,188.00 $28,281.00 $0.00 No assigned value 065.002.01 Spa, Filter Spa, Filter 0 10 $1,432.00 $1,432.00 $1,432.00 065.002.01 Spa, Filter Spa, Filter 0 10 $1,460.00 $1,460.00 $1,460.00 Maintenance deferred 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 10 14 $9,849.00 $2,814.00 $0.00 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 9 14 $10,045.00 $3,588.00 $0.00 No assigned value 067.001.03 Barbecues Barbecues 0 5 $4,947.00 $4,947.00 $4,947.00 067.001.03 Barbecues Barbecues 0 5 $5,045.00 $5,045.00 $5,045.00 Maintenance deferred 067.001.07 Patio/Spa Patio/Spa 3 30 $126,000.00 $117,209.00 $117,209.00 067.001.07 Patio/Spa Patio/Spa 2 30 $126,000.00 $120,140.00 $120,140.00 Cost not changed 067.001.08 Pool/Wader Pool/Wader 3 30 $161,000.00 $149,767.00 $149,767.00 067.001.08 Pool/Wader Pool/Wader 2 30 $161,000.00 $153,512.00 $153,512.00 Cost not changed 067.002.03 Deck Repairs Deck Repairs 10 10 $5,000.00 $0.00 $0.00 067.002.03 Deck Repairs Deck Repairs 10 10 $5,000.00 $0.00 $0.00 Remaining life not changed Cost not changed 067.003.04 Furniture, Repla Furniture, Replace 5 7 $62,362.00 $15,591.00 $0.00 067.003.04 Furniture, Repla Furniture, Replace 4 7 $63,609.00 $25,444.00 $25,444.00 Fully funded value too low should be $27,261.10 Assigned value too low should be $27,261.10 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 10 14 $33,926.00 $9,693.00 $0.00 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 9 14 $34,604.00 $12,359.00 $0.00 No assigned value 070.001.01 Aluminum Trellis Aluminum Trellis 23 30 $12,097.00 $2,823.00 $0.00 070.001.01 Aluminum Trellis Aluminum Trellis 22 30 $12,338.00 $3,290.00 $0.00 No assigned value 070.001.05 Furniture Furniture 5 7 $17,225.00 $4,306.00 $0.00 070.001.05 Furniture Furniture 4 7 $17,569.00 $7,028.00 $7,028.00 Fully funded value too low should be $7,529.79 Assigned value too low should be $7,529.79 070.001.08 Replace Replace 4 30 $57,000.00 $51,818.00 $10,199.00 070.001.08 Replace Replace 3 30 $57,000.00 $53,114.00 $53,114.00 Cost not changed 070.001.09 Wood, Repairs Wood, Repairs 1 5 $3,500.00 $3,000.00 $3,000.00 070.001.09 Wood, Repairs Wood, Repairs 0 5 $3,500.00 $3,500.00 $3,500.00 Cost not changed 070.004.01 Water Heater Water Heater 14 16 $4,482.00 $455.00 $0.00 070.004.01 Water Heater Water Heater 13 16 $4,571.00 $758.00 $0.00 Fully funded value too low should be $857.18 No assigned value 070.005.03 Doors, Restrooms Doors, Restrooms 6 25 $1,234.00 $1,073.00 $0.00 070.005.03 Doors, Restrooms Doors, Restrooms 5 25 $1,254.00 $1,118.00 $1,118.00 Fully funded value too high should be $1,006.94 Assigned value too high should be $1,006.94 070.005.04 Restroom, Partit Restroom, Partitions 10 10 $2,500.00 $0.00 $0.00 070.005.04 Restroom, Partit Restroom, Partitions 10 10 $2,500.00 $0.00 $0.00 Remaining life not changed Cost not changed 080.000.01 Benches Benches 9 15 $20,538.00 $8,215.00 $0.00 080.000.01 Benches Benches 8 15 $20,944.00 $9,774.00 $0.00 No assigned value 080.000.02 Chain Link Fenci Chain Link Fencing 6 30 $20,241.00 $17,601.00 $0.00 080.000.02 Chain Link Fenci Chain Link Fencing 5 30 $20,585.00 $18,348.00 $18,348.00 Fully funded value too high should be $17,204.85 Assigned value too high should be $17,204.85 085.001.02 Trash Cans Trash Cans 9 15 $11,061.00 $4,424.00 $0.00 085.001.02 Trash Cans Trash Cans 8 15 $11,277.00 $5,263.00 $1,154.00 Assigned value too low should be $5,265.04 085.002.01 Drinking Fountai Drinking Fountain, C/H 10 16 $3,053.00 $1,073.00 $0.00 085.002.01 Drinking Fountai Drinking Fountain, C/H 9 16 $3,114.00 $1,296.00 $0.00 No assigned value 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 7 10 $8,531.00 $2,133.00 $0.00 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 6 10 $8,701.00 $3,108.00 $3,108.00 Fully funded value too low should be $3,480.65 Assigned value too low should be $3,480.65 085.003.06 Wood Chips, Alba Wood Chips, Alba 9 10 $8,690.00 $310.00 $0.00 085.003.06 Wood Chips, Alba Wood Chips, Alba 8 10 $8,863.00 $1,266.00 $0.00 Fully funded value too low should be $1,772.76 No assigned value 085.004.02 Poured In Place, Poured In Place, Main 13 14 $42,378.00 $3,027.00 $0.00 085.004.02 Poured In Place, Poured In Place, Main 12 14 $43,225.00 $6,175.00 $0.00 No assigned value 090.000.02 Trellis, Clubhou Trellis, Clubhouse 24 30 $45,973.00 $8,677.00 $0.00 090.000.02 Trellis, Clubhou Trellis, Clubhouse 23 30 $46,892.00 $10,435.00 $0.00 No assigned value 095.002.01 Tree Trimming, B Tree Trimming, Blue Gum 0 2 $37,000.00 $37,000.00 $37,000.00 095.002.01 Tree Trimming, B Tree Trimming, Blue Gum 1 2 $37,000.00 $17,696.00 $17,696.00 Maintenance completed Cost not changed 095.002.02 Tree Trimming, C Tree Trimming, Common 2 3 $34,000.00 $7,677.00 $7,677.00 095.002.02 Tree Trimming, C Tree Trimming, Common 1 3 $34,000.00 $20,839.00 $20,839.00 Cost not changed 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 3 4 $15,000.00 $3,261.00 $3,261.00 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 2 4 $15,000.00 $7,174.00 $7,174.00 Cost not changed 095.002.04 Tree Trimming, R Tree Trimming, Red Ironbark 3 4 $7,500.00 $1,630.00 $1,630.00 095.002.04 Tree Trimming, R Tree Trimming, Red Ironbark 2 4 $7,500.00 $3,587.00 $3,587.00 Cost not changed 097.000.02 Irrigation, Cont Irrigation, Controllers 11 15 $31,515.00 $8,404.00 $0.00 097.000.02 Irrigation, Cont Irrigation, Controllers 10 15 $32,142.00 $10,714.00 $0.00 No assigned value 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 24 $27,414.00 $27,414.00 $27,414.00 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 24 $27,960.00 $27,960.00 $27,960.00 Maintenance deferred 100.000.01 Bulletin Board Bulletin Board 3 15 $1,129.00 $995.00 $995.00 100.000.01 Bulletin Board Bulletin Board 2 15 $1,151.00 $1,060.00 $1,060.00 Fully funded value too high should be $998.04 Assigned value too high should be $998.04 100.000.02 Monument Monument 0 30 $40,000.00 $40,000.00 $40,000.00 100.000.02 Monument Monument 0 30 $40,000.00 $40,000.00 $40,000.00 Maintenance deferred Cost not changed 105.000.01 Termite Control/ Termite Control/Fumigation 3 15 $5,161.00 $4,516.00 $4,516.00 105.000.01 Termite Control/ Termite Control/Fumigation 2 15 $5,161.00 $4,731.00 $4,731.00 Cost not changed 2017 - 2018 RDA Forensic Analysis Summary Estimated inflation 2% Consumer Price Index 2.1% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $1,983,920.00 $1,094,253.00 $774,213.00 This Year Costs $2,012,776.00 $1,099,785.00 $852,613.00 Calculated Costs $2,015,087.18 $1,101,186.42 $1,101,186.42 Comparing This Year Costs to Last Year Costs Difference $28,856.00 $5,532.00 $78,400.00 percent difference 1.45% 0.51% 10.13% Comparing This Year Costs to Calculated Costs Difference $-2,311.18 $-1,401.42 $-248,573.42 percent difference -0.11% -0.13% -29.15% 124 Total Assets 30 Total Issues $344,000.30 Unfunded Liability 0.24 Issues / Asset number % Description 35 28.23% No assigned value 10 8.06% Fully funded value too high 11 8.87% Fully funded value too low 10 8.06% Assigned value too high 6 4.84% Assigned value too low 3 2.42% Remaining life not changed 7 5.65% Maintenance deferred 2 1.61% Maintenance completed 9 7.26% Total assets to be maintained 20 16.13% Cost not changed