Park Paseo Homeowners Association Audited Forensic Report For 2016 to 2017 Revenue 505.000.01 Homeowners Association Fees $584,628.00 $210,372.00 $795,000.00 505.000.01 Homeowners Association Fees $558,202.00 $221,798.00 $780,000.00 Replacement fund too low difference is $-11,426.00 520.000.01 Clubhouse Rental Fee $3,840.00 $0.00 $3,840.00 520.000.01 Clubhouse Rental Fee $14,350.00 $0.00 $14,350.00 Operating fund too low difference is $-10,510.00 Cost too low difference is $-10,510.00 540.000.04 Recovery of Bad Debt $2,000.00 $0.00 $2,000.00 540.000.04 Recovery of Bad Debt $3,027.00 $0.00 $3,027.00 Operating fund too low difference is $-1,027.00 Cost too low difference is $-1,027.00 540.000.10 Other Income $5,046.00 $0.00 $5,046.00 540.000.10 Other Income $18,102.00 $0.00 $18,102.00 Operating fund too low difference is $-13,056.00 Cost too low difference is $-13,056.00 550.000.03 Investment Income $1,153.00 $5,113.00 $6,266.00 550.000.03 Investment Income $1,393.00 $2,837.00 $4,230.00 Operating fund too low difference is $-240.00 Replacement fund too high difference is $2,276.00 Cost too high difference is $2,036.00 640.000.03 Reserve Studies $2,295.00 $0.00 $2,295.00 Deleted Asset(s) Expense Expense 640.000.05 General Administrative $17,903.00 $106.00 $18,009.00 640.000.05 General Administrative $7,837.00 $0.00 $7,837.00 Operating fund too high difference is $10,066.00 Replacement fund too high difference is $106.00 Cost too high difference is $10,172.00 640.000.07 Office supplies/printing/postage $14,576.00 $0.00 $14,576.00 640.000.07 Office supplies/printing/postage $12,865.00 $0.00 $12,865.00 Operating fund too high difference is $1,711.00 Cost too high difference is $1,711.00 700.000.01 Insurance $14,815.00 $0.00 $14,815.00 700.000.01 Insurance $16,428.00 $0.00 $16,428.00 Operating fund too low difference is $-1,613.00 Cost too low difference is $-1,613.00 720.000.08 Landscape Expense $210,111.00 $3,698.00 $213,809.00 720.000.08 Landscape Expense $179,096.00 $0.00 $179,096.00 Operating fund too high difference is $31,015.00 Replacement fund too high difference is $3,698.00 Cost too high difference is $34,713.00 760.000.01 Audit & Tax Services $1,700.00 $0.00 $1,700.00 Deleted Asset(s) Expense 760.000.04 Management Fees $103,900.00 $0.00 $103,900.00 760.000.04 Management Fees $80,400.00 $0.00 $80,400.00 Operating fund too high difference is $23,500.00 Cost too high difference is $23,500.00 760.000.07 Legal and collection $4,881.00 $0.00 $4,881.00 760.000.07 Legal and collection $6,400.00 $0.00 $6,400.00 Operating fund too low difference is $-1,519.00 Cost too low difference is $-1,519.00 760.000.08 Audit/tax preparation/reserve study $3,395.00 $0.00 $3,395.00 Added Asset(s) Expense 840.001.05 General Repair & Maintenance $52,932.00 $0.00 $52,932.00 840.001.05 General Repair & Maintenance $97,868.00 $0.00 $97,868.00 Operating fund too low difference is $-44,936.00 Cost too low difference is $-44,936.00 840.001.12 Deck $0.00 $2,399.00 $2,399.00 Deleted Asset(s) Expense 840.002.04 Janitorial Combined Costs $17,473.00 $0.00 $17,473.00 840.002.04 Janitorial Combined Costs $13,529.00 $0.00 $13,529.00 Operating fund too high difference is $3,944.00 Cost too high difference is $3,944.00 840.004.03 Pest Control $4,533.00 $3,744.00 $8,277.00 840.004.03 Pest Control $1,133.00 $0.00 $1,133.00 Operating fund too high difference is $3,400.00 Replacement fund too high difference is $3,744.00 Cost too high difference is $7,144.00 840.006.03 Pool Supplies/Repair & Maintenance $42,533.00 $0.00 $42,533.00 840.006.03 Pool Supplies/Repair & Maintenance $42,916.00 $39,593.00 $82,509.00 Replacement fund too low difference is $-39,593.00 Cost too low difference is $-39,976.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $5,746.00 $5,746.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $18,886.00 $18,886.00 Replacement fund too low difference is $-13,140.00 Cost too low difference is $-13,140.00 860.000.03 Telephone Service $3,801.00 $0.00 $3,801.00 860.000.03 Telephone Service $3,085.00 $0.00 $3,085.00 Operating fund too high difference is $716.00 Cost too high difference is $716.00 860.000.05 Water Service $46,308.00 $0.00 $46,308.00 860.000.05 Water Service $40,496.00 $0.00 $40,496.00 Operating fund too high difference is $5,812.00 Cost too high difference is $5,812.00 2016 - 2017 Analysis Summary Estimated inflation 2% Consumer Price Index 1.3% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2016 $595,074.00 $224,635.00 $819,709.00 Revenue 2017 $596,667.00 $215,485.00 $812,152.00 Expense 2016 $590,193.00 $60,878.00 $651,071.00 Expense 2017 $617,620.00 $13,294.00 $630,914.00 revenue - expense 2016 $4,881.00 $163,757.00 $168,638.00 revenue - expense 2017 $-20,953.00 $202,191.00 $181,238.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $-25,834.00 $38,434.00 $12,600.00 percent difference -529.28% 123.47% 107.47% Total Assets 22 Total Issues 82 Issues/Asset 3.73 count % Description 1 4.55% Added Asset(s) 3 13.64% Deleted Asset(s) 8 36.36% Operating fund too high 7 31.82% Operating fund too low 4 18.18% Replacement fund too high 3 13.64% Replacement fund too low 9 40.91% Cost too high 8 36.36% Cost too low Park Paseo Homeowners Association UnAudited Forensic Report For 2016 to 2017 Revenue 505.000.01 Homeowners Association Fees $584,628.00 $210,372.00 $795,000.00 505.000.01 Homeowners Association Fees $558,202.00 $221,798.00 $780,000.00 Replacement fund too low difference is $-11,426.00 520.000.01 Clubhouse Rental Fee $3,840.00 $0.00 $3,840.00 520.000.01 Clubhouse Rental Fee $14,350.00 $0.00 $14,350.00 Operating fund too low difference is $-10,510.00 Cost too low difference is $-10,510.00 540.000.04 Recovery of Bad Debt $2,000.00 $0.00 $2,000.00 540.000.04 Recovery of Bad Debt $3,027.00 $0.00 $3,027.00 Operating fund too low difference is $-1,027.00 Cost too low difference is $-1,027.00 540.000.10 Other Income $5,046.00 $0.00 $5,046.00 540.000.10 Other Income $18,102.00 $0.00 $18,102.00 Operating fund too low difference is $-13,056.00 Cost too low difference is $-13,056.00 550.000.03 Investment Income $1,153.00 $5,113.00 $6,266.00 550.000.03 Investment Income $1,393.00 $2,837.00 $4,230.00 Operating fund too low difference is $-240.00 Replacement fund too high difference is $2,276.00 Cost too high difference is $2,036.00 640.000.03 Reserve Studies $2,295.00 $0.00 $2,295.00 Deleted Asset(s) Expense Expense 640.000.05 General Administrative $17,903.00 $106.00 $18,009.00 640.000.05 General Administrative $7,837.00 $0.00 $7,837.00 Operating fund too high difference is $10,066.00 Replacement fund too high difference is $106.00 Cost too high difference is $10,172.00 640.000.07 Office supplies/printing/postage $14,576.00 $0.00 $14,576.00 640.000.07 Office supplies/printing/postage $12,865.00 $0.00 $12,865.00 Operating fund too high difference is $1,711.00 Cost too high difference is $1,711.00 700.000.01 Insurance $14,815.00 $0.00 $14,815.00 700.000.01 Insurance $16,428.00 $0.00 $16,428.00 Operating fund too low difference is $-1,613.00 Cost too low difference is $-1,613.00 720.000.08 Landscape Expense $210,111.00 $3,698.00 $213,809.00 720.000.08 Landscape Expense $179,096.00 $0.00 $179,096.00 Operating fund too high difference is $31,015.00 Replacement fund too high difference is $3,698.00 Cost too high difference is $34,713.00 760.000.01 Audit & Tax Services $1,700.00 $0.00 $1,700.00 Deleted Asset(s) Expense 760.000.04 Management Fees $103,900.00 $0.00 $103,900.00 760.000.04 Management Fees $80,400.00 $0.00 $80,400.00 Operating fund too high difference is $23,500.00 Cost too high difference is $23,500.00 760.000.07 Legal and collection $4,881.00 $0.00 $4,881.00 760.000.07 Legal and collection $6,400.00 $0.00 $6,400.00 Operating fund too low difference is $-1,519.00 Cost too low difference is $-1,519.00 760.000.08 Audit/tax preparation/reserve study $3,395.00 $0.00 $3,395.00 Added Asset(s) Expense 840.001.05 General Repair & Maintenance $52,932.00 $0.00 $52,932.00 840.001.05 General Repair & Maintenance $97,868.00 $0.00 $97,868.00 Operating fund too low difference is $-44,936.00 Cost too low difference is $-44,936.00 840.001.12 Deck $0.00 $2,399.00 $2,399.00 Deleted Asset(s) Expense 840.002.04 Janitorial Combined Costs $17,473.00 $0.00 $17,473.00 840.002.04 Janitorial Combined Costs $13,529.00 $0.00 $13,529.00 Operating fund too high difference is $3,944.00 Cost too high difference is $3,944.00 840.004.03 Pest Control $4,533.00 $3,744.00 $8,277.00 840.004.03 Pest Control $1,133.00 $0.00 $1,133.00 Operating fund too high difference is $3,400.00 Replacement fund too high difference is $3,744.00 Cost too high difference is $7,144.00 840.006.03 Pool Supplies/Repair & Maintenance $42,533.00 $0.00 $42,533.00 840.006.03 Pool Supplies/Repair & Maintenance $42,916.00 $39,593.00 $82,509.00 Replacement fund too low difference is $-39,593.00 Cost too low difference is $-39,976.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $5,746.00 $5,746.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $18,886.00 $18,886.00 Replacement fund too low difference is $-13,140.00 Cost too low difference is $-13,140.00 860.000.03 Telephone Service $3,801.00 $0.00 $3,801.00 860.000.03 Telephone Service $3,085.00 $0.00 $3,085.00 Operating fund too high difference is $716.00 Cost too high difference is $716.00 860.000.05 Water Service $46,308.00 $0.00 $46,308.00 860.000.05 Water Service $40,496.00 $0.00 $40,496.00 Operating fund too high difference is $5,812.00 Cost too high difference is $5,812.00 2016 - 2017 Analysis Summary Estimated inflation 2% Consumer Price Index 1.3% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2016 $595,074.00 $224,635.00 $819,709.00 Revenue 2017 $596,667.00 $215,485.00 $812,152.00 Expense 2016 $590,193.00 $60,878.00 $651,071.00 Expense 2017 $617,620.00 $13,294.00 $630,914.00 revenue - expense 2016 $4,881.00 $163,757.00 $168,638.00 revenue - expense 2017 $-20,953.00 $202,191.00 $181,238.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $-25,834.00 $38,434.00 $12,600.00 percent difference -529.28% 123.47% 107.47% Total Assets 22 Total Issues 82 Issues/Asset 3.73 count % Description 1 4.55% Added Asset(s) 3 13.64% Deleted Asset(s) 8 36.36% Operating fund too high 7 31.82% Operating fund too low 4 18.18% Replacement fund too high 3 13.64% Replacement fund too low 9 40.91% Cost too high 8 36.36% Cost too low Park Paseo Homeowners Association RDA Forensic Analysis For 2016 to 2017 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 010.000.01 Overlay/Rehab Overlay/Rehab 3 20 $12,318.00 $10,599.00 $10,599.00 010.000.01 Overlay/Rehab Overlay/Rehab 3 20 $12,554.00 $10,880.00 $10,880.00 Remaining life not changed 010.000.03 Asphalt Repairs Asphalt Repairs 3 3 $2,621.00 $0.00 $0.00 010.000.03 Asphalt Repairs Asphalt Repairs 3 3 $1,818.00 $0.00 $0.00 Remaining life not changed Cost value too low should be $2,673.42 No assigned value 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 3 3 $1,875.00 $0.00 $0.00 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 3 3 $1,883.00 $0.00 $0.00 Remaining life not changed No assigned value 020.000.03 Clubhouse, Tile Clubhouse, Tile 33 35 $49,317.00 $2,371.00 $0.00 Asset deleted 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 7 18 $1,350.00 $815.00 $815.00 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 6 18 $1,377.00 $909.00 $0.00 No assigned value 020.000.05 DaVinci Roof, Cl DaVinci Roof, Clubhouse 32 35 $50,303.00 $3,869.00 $0.00 New Assets 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 45 50 $11,651.00 $1,165.00 $0.00 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 44 50 $11,880.00 $1,426.00 $0.00 No assigned value 030.001.01 Aluminum, Pools Aluminum, Pools 19 25 $10,507.00 $2,522.00 $2,522.00 030.001.01 Aluminum, Pools Aluminum, Pools 18 25 $10,681.00 $2,991.00 $0.00 No assigned value 030.001.02 Interior Clubhou Interior Clubhouse 1 8 $4,357.00 $3,812.00 $3,812.00 030.001.02 Interior Clubhou Interior Clubhouse 8 8 $4,423.00 $0.00 $0.00 Maintenance completed 030.001.03 Interior Prosa R Interior Prosa Restrooms 4 8 $1,633.00 $772.00 $772.00 030.001.03 Interior Prosa R Interior Prosa Restrooms 1 8 $1,665.00 $1,367.00 $1,367.00 Remaining life decreased too much Fully funded value too low should be $1,457.45 Assigned value too low should be $1,457.45 030.001.04 Interior Rec Are Interior Rec Area, Clubhouse 7 7 $7,700.00 $0.00 $0.00 New Assets 030.001.05 Spa Equipment Ro Spa Equipment Room 0 5 $2,816.00 $2,816.00 $2,816.00 030.001.05 Spa Equipment Ro Spa Equipment Room 1 5 $2,860.00 $2,426.00 $2,426.00 Maintenance deferred Remaining life increased Fully funded value too high should be $2,297.86 Assigned value too high should be $2,297.86 030.001.06 Stucco Stucco 5 10 $3,268.00 $1,548.00 $1,548.00 030.001.06 Stucco Stucco 5 10 $3,333.00 $1,746.00 $0.00 Remaining life not changed No assigned value 030.001.07 Woodwork Prosa Woodwork Prosa 0 5 $3,313.00 $3,313.00 $3,313.00 030.001.07 Woodwork Prosa Woodwork Prosa 1 5 $3,364.00 $2,853.00 $2,853.00 Maintenance deferred Remaining life increased Fully funded value too high should be $2,703.41 Assigned value too high should be $2,703.41 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $172.00 $172.00 $172.00 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $178.00 $178.00 $178.00 Maintenance deferred 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 0 5 $12,087.00 $12,087.00 $12,087.00 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 1 5 $12,275.00 $10,410.00 $10,410.00 Maintenance deferred Remaining life increased Fully funded value too high should be $9,862.99 Assigned value too high should be $9,862.99 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 19 25 $144,776.00 $33,635.00 $33,635.00 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 18 25 $147,671.00 $40,274.00 $0.00 No assigned value 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 19 25 $51,928.00 $12,463.00 $12,463.00 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 18 25 $52,966.00 $14,830.00 $0.00 No assigned value 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 15 20 $962.00 $219.00 $219.00 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 14 20 $978.00 $273.00 $0.00 Fully funded value too low should be $294.37 No assigned value 040.000.04 W/I, Delamesa/Ca W/I, Delamesa/Campanero 15 20 $6,742.00 $1,686.00 $1,686.00 040.000.04 W/I, Delamesa/Ca W/I, Delamesa/Campanero 14 20 $6,877.00 $2,063.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 15 20 $2,500.00 $585.00 $585.00 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 14 20 $2,500.00 $713.00 $0.00 Cost not changed 050.000.01 Exterior, Pool/C Exterior, Pool/Club 0 10 $13,786.00 $13,786.00 $13,786.00 050.000.01 Exterior, Pool/C Exterior, Pool/Club 3 10 $13,986.00 $12,465.00 $12,465.00 Maintenance deferred Remaining life increased Fully funded value too high should be $9,843.20 Assigned value too high should be $9,843.20 050.000.03 Exterior, Parkin Exterior, Parking Lot 6 22 $1,453.00 $1,043.00 $1,043.00 050.000.03 Exterior, Parkin Exterior, Parking Lot 5 22 $1,482.00 $1,133.00 $0.00 No assigned value 050.000.05 Exterior, Prosa Exterior, Prosa 0 10 $2,666.00 $2,666.00 $2,666.00 050.000.05 Exterior, Prosa Exterior, Prosa 3 10 $2,698.00 $2,405.00 $2,405.00 Maintenance deferred Remaining life increased Fully funded value too high should be $1,903.52 Assigned value too high should be $1,903.52 050.000.07 Parking Lot, Ori Parking Lot, Original 0 22 $7,265.00 $7,265.00 $7,265.00 050.000.07 Parking Lot, Ori Parking Lot, Original 3 22 $7,410.00 $6,893.00 $6,893.00 Maintenance deferred Remaining life increased Fully funded value too high should be $6,399.80 Assigned value too high should be $6,399.80 050.000.08 Interior Prosa C Interior Prosa Cabana 1 25 $1,754.00 $1,704.00 $1,704.00 050.000.08 Interior Prosa C Interior Prosa Cabana 3 25 $1,778.00 $1,638.00 $1,638.00 Remaining life increased 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 0 15 $112,200.00 $112,200.00 $112,200.00 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 0 15 $105,650.00 $105,650.00 $105,650.00 Maintenance deferred Cost value too low should be $114,444.00 Fully funded value too low should be $114,444.00 Assigned value too low should be $114,444.00 050.001.01 Interior Clubhou Interior Clubhouse 0 25 $15,829.00 $15,829.00 $15,829.00 050.001.01 Interior Clubhou Interior Clubhouse 3 25 $15,524.00 $14,441.00 $14,441.00 Maintenance deferred Remaining life increased 050.001.02 Interior Clubhou Interior Clubhouse, 2016 25 25 $900.00 $0.00 $0.00 New Assets 060.001.02 Billiard Tables Billiard Tables 1 25 $9,934.00 $9,686.00 $9,686.00 060.001.02 Billiard Tables Billiard Tables 5 25 $10,102.00 $8,980.00 $0.00 Remaining life increased Fully funded value too high should be $8,106.14 No assigned value 060.001.04 Carpet, Replace Carpet, Replace 6 8 $7,956.00 $1,447.00 $1,447.00 060.001.04 Carpet, Replace Carpet, Replace 5 8 $7,956.00 $2,531.00 $0.00 Cost not changed 060.001.08 Exterior Stairca Exterior Staircase 20 30 $18,717.00 $6,028.00 $6,028.00 060.001.08 Exterior Stairca Exterior Staircase 19 30 $19,091.00 $6,795.00 $0.00 No assigned value 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 14 25 $18,619.00 $8,051.00 $8,051.00 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 25 25 $13,304.00 $0.00 $0.00 Maintenance completed 060.001.10 Furnishings Furnishings 0 10 $30,000.00 $30,000.00 $30,000.00 060.001.10 Furnishings Furnishings 10 10 $35,000.00 $0.00 $0.00 Maintenance completed 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 18 20 $28,250.00 $2,503.00 $2,503.00 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 17 20 $28,818.00 $4,013.00 $0.00 Fully funded value too low should be $4,322.25 No assigned value 060.001.14 Window Blinds Window Blinds 1 10 $15,940.00 $14,574.00 $14,574.00 060.001.14 Window Blinds Window Blinds 3 10 $16,258.00 $12,933.00 $12,933.00 Remaining life increased Fully funded value too high should be $11,381.16 Assigned value too high should be $11,381.16 060.001.15 Water Heater Water Heater 15 16 $6,983.00 $261.00 $261.00 060.001.15 Water Heater Water Heater 14 16 $7,122.00 $724.00 $0.00 Fully funded value too low should be $890.33 No assigned value 060.001.16 Wallpaper Wallpaper 1 15 $13,784.00 $12,603.00 $12,603.00 Asset deleted 060.002.01 Doors, Double Sl Doors, Double Slide 21 25 $7,082.00 $1,133.00 $1,133.00 Asset deleted 060.002.02 Doors, Exterior, Doors, Exterior, Entry 14 25 $13,174.00 $5,697.00 $5,697.00 060.002.02 Doors, Exterior, Doors, Exterior, Entry 13 25 $13,436.00 $6,355.00 $0.00 No assigned value 060.002.03 Doors, Entry Doors, Entry 0 25 $15,738.00 $15,738.00 $15,738.00 060.002.03 Doors, Entry Doors, Entry 20 25 $10,668.00 $2,134.00 $0.00 Maintenance deferred Remaining life increased Cost value too low should be $16,052.76 Fully funded value too low should be $3,210.55 No assigned value 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 1 25 $2,428.00 $2,367.00 $2,367.00 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 6 25 $1,234.00 $1,073.00 $0.00 Remaining life increased Cost value too low should be $2,476.56 Fully funded value too low should be $1,882.19 No assigned value 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 0 25 $6,492.00 $6,492.00 $6,492.00 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 0 25 $25,000.00 $25,000.00 $25,000.00 Maintenance deferred Cost value too high should be $6,621.84 Fully funded value too high should be $6,621.84 Assigned value too high should be $6,621.84 060.002.08 Doors, Entry Int Doors, Entry Interior 0 25 $1,964.00 $1,964.00 $1,964.00 060.002.08 Doors, Entry Int Doors, Entry Interior 6 25 $1,994.00 $1,631.00 $0.00 Maintenance deferred Remaining life increased Fully funded value too high should be $1,522.49 No assigned value 060.002.09 Doors, Kitchen Doors, Kitchen 25 25 $9,235.00 $0.00 $0.00 New Assets 060.003.01 Kitchen, Applian Kitchen, Appliances 1 12 $5,348.00 $4,890.00 $4,890.00 060.003.01 Kitchen, Applian Kitchen, Appliances 3 12 $5,454.00 $4,338.00 $4,338.00 Remaining life increased Fully funded value too high should be $4,091.22 Assigned value too high should be $4,091.22 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 14 25 $24,771.00 $10,712.00 $10,712.00 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 13 25 $25,266.00 $11,950.00 $0.00 No assigned value 060.003.07 Kitchen, Refrige Kitchen, Refrigerator 8 12 $1,892.00 $595.00 $0.00 New Assets 060.003.08 Kitchen, Sink Kitchen, Sink 14 25 $786.00 $340.00 $340.00 060.003.08 Kitchen, Sink Kitchen, Sink 13 25 $801.00 $379.00 $0.00 No assigned value 060.004.01 Office, Computer Office, Computers/Equipment 6 8 $6,500.00 $1,625.00 $0.00 New Assets 060.004.04 Office, Equip, C Office, Equip, Comp/Monitor, Printer 1 8 $10,000.00 $8,983.00 $8,983.00 Asset deleted 060.004.09 Office, Equipmen Office, Equipment 4 8 $3,500.00 $1,750.00 $1,750.00 New Assets 060.004.10 Office, Remodel Office, Remodel 11 20 $13,030.00 $5,803.00 $5,803.00 060.004.10 Office, Remodel Office, Remodel 10 20 $13,290.00 $6,589.00 $0.00 No assigned value 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 18 25 $11,865.00 $3,322.00 $3,322.00 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 17 25 $12,062.00 $3,860.00 $0.00 No assigned value 060.005.03 Restroom, Counte Restroom, Counters 13 20 $3,904.00 $1,366.00 $1,366.00 060.005.03 Restroom, Counte Restroom, Counters 12 20 $3,968.00 $1,587.00 $0.00 No assigned value 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 18 25 $2,309.00 $646.00 $646.00 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 17 25 $2,348.00 $751.00 $0.00 No assigned value 060.005.07 Restroom, Locker Restroom, Lockers/Benches 15 22 $20,000.00 $6,364.00 $6,364.00 060.005.07 Restroom, Locker Restroom, Lockers/Benches 14 22 $20,000.00 $7,273.00 $0.00 Cost not changed 060.005.08 Restroom, Partit Restroom, Partitions 13 20 $5,345.00 $1,871.00 $1,871.00 060.005.08 Restroom, Partit Restroom, Partitions 12 20 $5,435.00 $2,174.00 $0.00 No assigned value 060.005.10 Restroom, Shower Restroom, Shower Door 9 16 $2,024.00 $886.00 $886.00 060.005.10 Restroom, Shower Restroom, Shower Door 8 16 $2,056.00 $1,028.00 $0.00 No assigned value 060.005.12 Women's Shower Women's Shower 21 25 $3,434.00 $530.00 $530.00 060.005.12 Women's Shower Women's Shower 20 25 $3,502.00 $682.00 $0.00 No assigned value 060.005.13 Restroom, Fixtur Restroom, Fixtures 18 25 $7,354.00 $2,059.00 $2,059.00 060.005.13 Restroom, Fixtur Restroom, Fixtures 17 25 $7,475.00 $2,392.00 $0.00 No assigned value 065.001.01 Deck Repairs Deck Repairs 0 30 $25,000.00 $25,000.00 $25,000.00 Asset deleted 065.001.02 Filter, Main Filter, Main 0 12 $6,240.00 $6,240.00 $6,240.00 065.001.02 Filter, Main Filter, Main 1 12 $6,364.00 $5,940.00 $5,940.00 Maintenance deferred Remaining life increased 065.001.03 Heater, Main Heater, Main 10 12 $19,816.00 $2,831.00 $2,831.00 065.001.03 Heater, Main Heater, Main 9 12 $20,212.00 $4,620.00 $0.00 Fully funded value too low should be $5,053.08 No assigned value 065.001.04 Motor/Pump Syste Motor/Pump System 5 8 $7,282.00 $2,481.00 $2,481.00 065.001.04 Motor/Pump Syste Motor/Pump System 4 8 $7,426.00 $3,509.00 $3,509.00 Fully funded value too low should be $3,713.82 Assigned value too low should be $3,713.82 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 11 14 $76,114.00 $16,310.00 $16,310.00 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 10 14 $77,636.00 $22,182.00 $0.00 No assigned value 065.002.01 Spa, Filter Spa, Filter 0 10 $1,404.00 $1,404.00 $1,404.00 065.002.01 Spa, Filter Spa, Filter 0 10 $1,432.00 $1,432.00 $1,432.00 Maintenance deferred 065.002.02 Spa, Heater Spa, Heater 8 10 $2,636.00 $509.00 $509.00 065.002.02 Spa, Heater Spa, Heater 7 10 $2,688.00 $791.00 $0.00 No assigned value 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 0 8 $1,144.00 $1,144.00 $1,144.00 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 1 8 $1,166.00 $1,097.00 $1,097.00 Maintenance deferred Remaining life increased Fully funded value too high should be $1,021.02 Assigned value too high should be $1,021.02 065.002.04 Spa, Pump/Motor, Spa, Pump/Motor, Booster 0 8 $2,704.00 $2,704.00 $2,704.00 065.002.04 Spa, Pump/Motor, Spa, Pump/Motor, Booster 1 8 $2,758.00 $2,586.00 $2,586.00 Maintenance deferred Remaining life increased Fully funded value too high should be $2,413.32 Assigned value too high should be $2,413.32 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 9 12 $9,305.00 $2,326.00 $2,326.00 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 8 12 $9,491.00 $3,164.00 $0.00 No assigned value 065.002.06 Spa, Sump Pump Spa, Sump Pump 0 8 $2,926.00 $2,926.00 $2,926.00 065.002.06 Spa, Sump Pump Spa, Sump Pump 1 8 $2,984.00 $2,702.00 $2,702.00 Maintenance deferred Remaining life increased 065.003.01 Wader, Filter Wader, Filter 0 12 $988.00 $988.00 $988.00 065.003.01 Wader, Filter Wader, Filter 1 12 $1,027.00 $968.00 $968.00 Maintenance deferred Remaining life increased 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 11 14 $9,656.00 $2,069.00 $2,069.00 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 10 14 $9,849.00 $2,814.00 $0.00 No assigned value 067.001.03 Barbecues Barbecues 0 5 $4,850.00 $4,850.00 $4,850.00 067.001.03 Barbecues Barbecues 0 5 $4,947.00 $4,947.00 $4,947.00 Maintenance deferred 067.001.05 Ceramic Shower Ceramic Shower 1 25 $2,184.00 $2,129.00 $2,129.00 067.001.05 Ceramic Shower Ceramic Shower 3 25 $6,630.00 $6,167.00 $6,167.00 Remaining life increased Cost value too high should be $2,227.68 Fully funded value too high should be $1,960.36 Assigned value too high should be $1,960.36 067.001.07 Patio/Spa Patio/Spa 3 30 $126,000.00 $117,209.00 $117,209.00 New Assets 067.001.08 Pool/Wader Pool/Wader 3 30 $161,000.00 $149,767.00 $149,767.00 New Assets 067.002.02 Deck Caulking Deck Caulking 4 4 $8,013.00 $0.00 $0.00 067.002.02 Deck Caulking Deck Caulking 3 4 $6,571.00 $1,643.00 $1,643.00 Cost value too low should be $8,173.26 Fully funded value too low should be $2,043.32 Assigned value too low should be $2,043.32 067.002.03 Deck Repairs Deck Repairs 10 10 $5,000.00 $0.00 $0.00 New Assets 067.003.04 Furniture, Repla Furniture, Replace 6 7 $62,362.00 $6,236.00 $6,236.00 067.003.04 Furniture, Repla Furniture, Replace 5 7 $62,362.00 $15,591.00 $0.00 Cost not changed 069.001.04 Heater, Prosa Heater, Prosa 10 12 $6,477.00 $1,042.00 $1,042.00 069.001.04 Heater, Prosa Heater, Prosa 9 12 $6,606.00 $1,617.00 $0.00 No assigned value 069.001.05 Motor Motor 0 8 $2,288.00 $2,288.00 $2,288.00 069.001.05 Motor Motor 1 8 $2,332.00 $2,153.00 $2,153.00 Maintenance deferred Remaining life increased Fully funded value too high should be $2,042.04 Assigned value too high should be $2,042.04 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 11 14 $33,261.00 $7,127.00 $7,127.00 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 10 14 $33,926.00 $9,693.00 $0.00 No assigned value 070.001.01 Aluminum Trellis Aluminum Trellis 24 30 $11,860.00 $2,372.00 $441.00 070.001.01 Aluminum Trellis Aluminum Trellis 23 30 $12,097.00 $2,823.00 $0.00 No assigned value 070.001.05 Furniture Furniture 6 7 $16,888.00 $1,689.00 $1,689.00 070.001.05 Furniture Furniture 5 7 $17,225.00 $4,306.00 $0.00 Fully funded value too low should be $4,921.65 No assigned value 070.001.06 Plumbing Fixture Plumbing Fixtures 0 25 $5,646.00 $5,646.00 $5,646.00 070.001.06 Plumbing Fixture Plumbing Fixtures 3 25 $5,739.00 $5,286.00 $5,286.00 Maintenance deferred Remaining life increased 070.001.07 Repairs Repairs 0 20 $3,201.00 $3,201.00 $3,201.00 070.001.07 Repairs Repairs 3 20 $3,254.00 $2,997.00 $2,997.00 Maintenance deferred Remaining life increased Fully funded value too high should be $2,775.27 Assigned value too high should be $2,775.27 070.001.08 Replace Replace 4 30 $57,000.00 $51,818.00 $10,199.00 New Assets 070.001.09 Wood, Repairs Wood, Repairs 0 5 $3,500.00 $3,500.00 $3,500.00 070.001.09 Wood, Repairs Wood, Repairs 1 5 $3,500.00 $3,000.00 $3,000.00 Maintenance deferred Remaining life increased Cost not changed 070.002.01 Ceramic Shower Ceramic Shower 0 25 $7,222.00 $7,222.00 $7,222.00 070.002.01 Ceramic Shower Ceramic Shower 3 25 $7,346.00 $6,766.00 $6,766.00 Maintenance deferred Remaining life increased 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 3 25 $9,223.00 $8,475.00 $8,475.00 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 3 25 $9,379.00 $8,639.00 $8,639.00 Remaining life not changed 070.003.01 Deck, Caulking Deck, Caulking 4 4 $2,642.00 $0.00 $0.00 070.003.01 Deck, Caulking Deck, Caulking 3 4 $3,011.00 $655.00 $655.00 Cost value too high should be $2,694.84 070.003.02 Deck, Repairs Deck, Repairs 0 30 $12,500.00 $12,500.00 $12,500.00 Asset deleted 070.004.01 Water Heater Water Heater 15 16 $4,395.00 $165.00 $165.00 070.004.01 Water Heater Water Heater 14 16 $4,482.00 $455.00 $0.00 Fully funded value too low should be $560.36 No assigned value 070.005.01 Restroom, Counte Restroom, Counters 0 20 $1,094.00 $1,094.00 $1,094.00 070.005.01 Restroom, Counte Restroom, Counters 3 20 $1,112.00 $1,024.00 $1,024.00 Maintenance deferred Remaining life increased Fully funded value too high should be $948.50 Assigned value too high should be $948.50 070.005.03 Doors, Restrooms Doors, Restrooms 6 25 $1,234.00 $1,073.00 $0.00 New Assets 070.005.04 Restroom, Partit Restroom, Partitions 10 10 $2,500.00 $0.00 $0.00 New Assets 080.000.01 Benches Benches 10 15 $20,146.00 $6,715.00 $6,715.00 080.000.01 Benches Benches 9 15 $20,538.00 $8,215.00 $0.00 No assigned value 080.000.02 Chain Link Fenci Chain Link Fencing 4 30 $19,900.00 $18,049.00 $18,049.00 080.000.02 Chain Link Fenci Chain Link Fencing 6 30 $20,241.00 $17,601.00 $0.00 Remaining life increased Fully funded value too high should be $16,238.40 No assigned value 080.000.04 Deck Caulking Deck Caulking 4 4 $2,401.00 $0.00 $0.00 New Assets 080.000.05 Lighting Lighting 1 25 $13,664.00 $13,322.00 $13,322.00 080.000.05 Lighting Lighting 3 25 $13,888.00 $12,919.00 $12,919.00 Remaining life increased Fully funded value too high should be $12,264.81 Assigned value too high should be $12,264.81 080.000.06 Resurfacing Resurfacing 5 6 $9,504.00 $1,584.00 $1,584.00 080.000.06 Resurfacing Resurfacing 4 6 $9,792.00 $3,264.00 $0.00 No assigned value 080.000.07 Windscreen Windscreen 5 6 $2,847.00 $474.00 $474.00 080.000.07 Windscreen Windscreen 4 6 $2,926.00 $975.00 $0.00 No assigned value 085.001.01 Benches Benches 7 12 $11,534.00 $4,759.00 $4,759.00 085.001.01 Benches Benches 6 12 $11,764.00 $5,841.00 $0.00 No assigned value 085.001.02 Trash Cans Trash Cans 10 15 $10,845.00 $3,615.00 $3,615.00 085.001.02 Trash Cans Trash Cans 9 15 $11,061.00 $4,424.00 $0.00 No assigned value 085.002.01 Drinking Fountai Drinking Fountain, C/H 11 16 $2,994.00 $858.00 $858.00 085.002.01 Drinking Fountai Drinking Fountain, C/H 10 16 $3,053.00 $1,073.00 $0.00 Fully funded value too low should be $1,145.20 No assigned value 085.002.03 Drinking Fountai Drinking Fountain, Prosa 0 16 $1,510.00 $1,510.00 $1,510.00 085.002.03 Drinking Fountai Drinking Fountain, Prosa 1 16 $1,535.00 $1,492.00 $1,492.00 Maintenance deferred Remaining life increased 085.003.01 Play Equipment, Play Equipment, Alba 1 18 $22,675.00 $21,415.00 $21,415.00 085.003.01 Play Equipment, Play Equipment, Alba 3 18 $23,060.00 $19,766.00 $19,766.00 Remaining life increased 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 8 10 $8,364.00 $1,195.00 $1,195.00 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 7 10 $8,531.00 $2,133.00 $0.00 Fully funded value too low should be $2,559.38 No assigned value 085.003.06 Wood Chips, Alba Wood Chips, Alba 8 10 $7,109.00 $1,226.00 $1,226.00 085.003.06 Wood Chips, Alba Wood Chips, Alba 9 10 $8,690.00 $310.00 $0.00 Maintenance completed 085.004.01 Play Equip, Main Play Equip, Main, Prosa 1 18 $51,571.00 $48,926.00 $48,926.00 085.004.01 Play Equip, Main Play Equip, Main, Prosa 3 18 $52,602.00 $45,588.00 $45,588.00 Remaining life increased 085.004.02 Poured In Place, Poured In Place, Main 14 14 $41,548.00 $0.00 $0.00 085.004.02 Poured In Place, Poured In Place, Main 13 14 $42,378.00 $3,027.00 $0.00 No assigned value 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 1 12 $4,822.00 $4,538.00 $4,538.00 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 3 15 $4,904.00 $4,168.00 $4,168.00 Remaining life increased Useful life increased Fully funded value too high should be $3,934.75 Assigned value too high should be $3,934.75 090.000.02 Trellis, Clubhou Trellis, Clubhouse 25 30 $45,072.00 $6,983.00 $0.00 090.000.02 Trellis, Clubhou Trellis, Clubhouse 24 30 $45,973.00 $8,677.00 $0.00 Fully funded value too low should be $9,194.69 No assigned value 095.001.01 Refurbishment Refurbishment 1 1 $85,482.00 $0.00 $0.00 Asset deleted 095.002.01 Tree Trimming, B Tree Trimming, Blue Gum 0 2 $37,000.00 $37,000.00 $37,000.00 New Assets 095.002.02 Tree Trimming, C Tree Trimming, Common 2 3 $34,000.00 $7,677.00 $7,677.00 New Assets 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 0 4 $9,000.00 $9,000.00 $9,000.00 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 3 4 $15,000.00 $3,261.00 $3,261.00 Maintenance completed 095.002.04 Tree Trimming, R Tree Trimming, Red Ironbark 3 4 $7,500.00 $1,630.00 $1,630.00 New Assets 095.002.06 Tree Trimming, W Tree Trimming, Windrow 1 3 $34,000.00 $21,636.00 $21,636.00 Asset deleted 097.000.02 Irrigation, Cont Irrigation, Controllers 12 15 $30,899.00 $6,180.00 $6,180.00 097.000.02 Irrigation, Cont Irrigation, Controllers 11 15 $31,515.00 $8,404.00 $0.00 No assigned value 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 24 $26,880.00 $26,880.00 $26,880.00 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 24 $27,414.00 $27,414.00 $27,414.00 Maintenance deferred 100.000.01 Bulletin Board Bulletin Board 1 15 $1,107.00 $1,057.00 $1,057.00 100.000.01 Bulletin Board Bulletin Board 3 15 $1,129.00 $995.00 $995.00 Remaining life increased Fully funded value too high should be $903.31 Assigned value too high should be $903.31 100.000.02 Monument Monument 0 30 $3,294.00 $3,294.00 $3,294.00 100.000.02 Monument Monument 0 30 $40,000.00 $40,000.00 $40,000.00 Maintenance deferred Cost value too high should be $3,359.88 Fully funded value too high should be $3,359.88 Assigned value too high should be $3,359.88 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 3 15 $5,161.00 $4,516.00 $4,516.00 Maintenance deferred Remaining life increased Fully funded value too high should be $4,128.96 Assigned value too high should be $4,128.96 2016 - 2017 RDA Forensic Analysis Summary Estimated inflation 2% Consumer Price Index 1.3% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $1,634,906.00 $768,267.00 $755,817.00 This Year Costs $1,983,920.00 $1,094,253.00 $774,213.00 Calculated Costs $1,943,454.76 $1,073,311.58 $1,073,311.58 Comparing This Year Costs to Last Year Costs Difference $349,014.00 $325,986.00 $18,396.00 percent difference 21.35% 42.43% 2.43% exceeds CC&R limits Comparing This Year Costs to Calculated Costs Difference $40,465.24 $20,941.42 $-299,098.58 percent difference 2.04% 1.91% -38.63% 124 Total Assets 86 Total Issues $319,508.42 Unfunded Liability 0.69 Issues / Asset number % Description 17 13.71% New Assets 50 40.32% No assigned value 4 3.23% Cost value too high 5 4.03% Cost value too low 23 18.55% Fully funded value too high 15 12.10% Fully funded value too low 20 16.13% Assigned value too high 4 3.23% Assigned value too low 8 6.45% Asset deleted 5 4.03% Remaining life not changed 34 27.42% Remaining life increased 1 0.81% Remaining life decreased too much 1 0.81% Useful life increased 30 24.19% Maintenance deferred 5 4.03% Maintenance completed 32 25.81% Total assets to be maintained 6 4.84% Cost not changed