Park Paseo Homeowners Association Audited Forensic Report For 2020 to 2021 Revenue 505.000.01 Homeowners Association Fees $732,000.00 $318,799.00 $1,050,799.00 505.000.01 Homeowners Association Fees $697,224.00 $412,709.00 $1,109,933.00 Replacement fund too low difference is $-93,910.00 Cost too low difference is $-59,134.00 520.000.01 Clubhouse Rental Fee $4,580.00 $0.00 $4,580.00 520.000.01 Clubhouse Rental Fee $1,800.00 $0.00 $1,800.00 Operating fund too high difference is $2,780.00 Cost too high difference is $2,780.00 540.000.04 Recovery of Bad Debt $2,399.00 $0.00 $2,399.00 Deleted Asset(s) Revenue 540.000.10 Other Income $9,992.00 $0.00 $9,992.00 540.000.10 Other Income $2,478.00 $0.00 $2,478.00 Operating fund too high difference is $7,514.00 Cost too high difference is $7,514.00 550.000.03 Investment Income $162.00 $373.00 $535.00 550.000.03 Investment Income $421.00 $9,450.00 $9,871.00 Operating fund too low difference is $-259.00 Replacement fund too low difference is $-9,077.00 Cost too low difference is $-9,336.00 Expense 640.000.05 General Administrative $19,366.00 $1,083.00 $20,449.00 640.000.05 General Administrative $53,917.00 $0.00 $53,917.00 Operating fund too low difference is $-34,551.00 Replacement fund too high difference is $1,083.00 Cost too low difference is $-33,468.00 640.000.07 Office supplies/printing/postage $1,267.00 $0.00 $1,267.00 640.000.07 Office supplies/printing/postage $3,655.00 $0.00 $3,655.00 Operating fund too low difference is $-2,388.00 Cost too low difference is $-2,388.00 720.000.08 Landscape Expense $206,833.00 $63,730.00 $270,563.00 720.000.08 Landscape Expense $244,852.00 $0.00 $244,852.00 Operating fund too low difference is $-38,019.00 Replacement fund too high difference is $63,730.00 Cost too high difference is $25,711.00 760.000.04 Management Fees $107,772.00 $0.00 $107,772.00 760.000.04 Management Fees $111,888.00 $0.00 $111,888.00 Operating fund too low difference is $-4,116.00 Cost too low difference is $-4,116.00 760.000.07 Legal and collection $3,585.00 $0.00 $3,585.00 760.000.07 Legal and collection $15,545.00 $0.00 $15,545.00 Operating fund too low difference is $-11,960.00 Cost too low difference is $-11,960.00 780.000.01 Property Protection - Patrol Service $43,435.00 $0.00 $43,435.00 Deleted Asset(s) Expense 840.001.05 General Repair & Maintenance $59,304.00 $0.00 $59,304.00 840.001.05 General Repair & Maintenance $30,437.00 $0.00 $30,437.00 Operating fund too high difference is $28,867.00 Cost too high difference is $28,867.00 840.001.10 Other Repair & Maintenance $0.00 $40.00 $40.00 Added Asset(s) Expense 840.002.04 Janitorial Combined Costs $21,097.00 $0.00 $21,097.00 840.002.04 Janitorial Combined Costs $19,130.00 $0.00 $19,130.00 Operating fund too high difference is $1,967.00 Cost too high difference is $1,967.00 840.004.03 Pest Control $1,728.00 $0.00 $1,728.00 840.004.03 Pest Control $5,725.00 $0.00 $5,725.00 Operating fund too low difference is $-3,997.00 Cost too low difference is $-3,997.00 840.006.03 Pool Supplies/Repair & Maintenance $36,017.00 $246,213.00 $282,230.00 840.006.03 Pool Supplies/Repair & Maintenance $33,519.00 $413,950.00 $447,469.00 Replacement fund too low difference is $-167,737.00 Cost too low difference is $-165,239.00 860.000.01 Electric Service $37,611.00 $0.00 $37,611.00 860.000.01 Electric Service $32,981.00 $0.00 $32,981.00 Operating fund too high difference is $4,630.00 Cost too high difference is $4,630.00 860.000.02 Gas Service $18,912.00 $0.00 $18,912.00 860.000.02 Gas Service $6,032.00 $0.00 $6,032.00 Operating fund too high difference is $12,880.00 Cost too high difference is $12,880.00 860.000.03 Telephone Service $3,471.00 $0.00 $3,471.00 860.000.03 Telephone Service $4,266.00 $0.00 $4,266.00 Operating fund too low difference is $-795.00 Cost too low difference is $-795.00 860.000.04 Trash and Recycling Service $1,375.00 $0.00 $1,375.00 860.000.04 Trash and Recycling Service $1,407.00 $0.00 $1,407.00 Operating fund too low difference is $-32.00 Cost too low difference is $-32.00 860.000.05 Water Service $41,863.00 $0.00 $41,863.00 860.000.05 Water Service $38,146.00 $0.00 $38,146.00 Operating fund too high difference is $3,717.00 Cost too high difference is $3,717.00 880.000.01 Federal Income Tax $3,273.00 $0.00 $3,273.00 Deleted Asset(s) Expense 2020 - 2021 Analysis Summary Estimated inflation 3% Consumer Price Index 1.2% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2020 $704,322.00 $422,159.00 $1,126,481.00 Revenue 2021 $746,734.00 $319,172.00 $1,065,906.00 Expense 2020 $665,817.00 $413,990.00 $1,079,807.00 Expense 2021 $577,990.00 $311,026.00 $889,016.00 revenue - expense 2020 $38,505.00 $8,169.00 $46,674.00 revenue - expense 2021 $168,744.00 $8,146.00 $176,890.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $130,239.00 $-23.00 $130,216.00 percent difference 438.24% -0.28% 378.99% Total Assets 20 Total Issues 82 Issues/Asset 4.10 count % Description 1 5.00% Added Asset(s) 3 15.00% Deleted Asset(s) 7 35.00% Operating fund too high 9 45.00% Operating fund too low 2 10.00% Replacement fund too high 3 15.00% Replacement fund too low 8 40.00% Cost too high 10 50.00% Cost too low Park Paseo Homeowners Association UnAudited Forensic Report For 2020 to 2021 Revenue 505.000.01 Homeowners Association Fees $732,000.00 $318,799.00 $1,050,799.00 505.000.01 Homeowners Association Fees $697,224.00 $412,709.00 $1,109,933.00 Replacement fund too low difference is $-93,910.00 Cost too low difference is $-59,134.00 520.000.01 Clubhouse Rental Fee $4,580.00 $0.00 $4,580.00 520.000.01 Clubhouse Rental Fee $1,800.00 $0.00 $1,800.00 Operating fund too high difference is $2,780.00 Cost too high difference is $2,780.00 540.000.04 Recovery of Bad Debt $2,399.00 $0.00 $2,399.00 Deleted Asset(s) Revenue 540.000.10 Other Income $9,992.00 $0.00 $9,992.00 540.000.10 Other Income $2,478.00 $0.00 $2,478.00 Operating fund too high difference is $7,514.00 Cost too high difference is $7,514.00 550.000.03 Investment Income $162.00 $373.00 $535.00 550.000.03 Investment Income $421.00 $9,450.00 $9,871.00 Operating fund too low difference is $-259.00 Replacement fund too low difference is $-9,077.00 Cost too low difference is $-9,336.00 Expense 640.000.05 General Administrative $19,366.00 $1,083.00 $20,449.00 640.000.05 General Administrative $53,917.00 $0.00 $53,917.00 Operating fund too low difference is $-34,551.00 Replacement fund too high difference is $1,083.00 Cost too low difference is $-33,468.00 640.000.07 Office supplies/printing/postage $1,267.00 $0.00 $1,267.00 640.000.07 Office supplies/printing/postage $3,655.00 $0.00 $3,655.00 Operating fund too low difference is $-2,388.00 Cost too low difference is $-2,388.00 720.000.08 Landscape Expense $206,833.00 $63,730.00 $270,563.00 720.000.08 Landscape Expense $244,852.00 $0.00 $244,852.00 Operating fund too low difference is $-38,019.00 Replacement fund too high difference is $63,730.00 Cost too high difference is $25,711.00 760.000.04 Management Fees $107,772.00 $0.00 $107,772.00 760.000.04 Management Fees $111,888.00 $0.00 $111,888.00 Operating fund too low difference is $-4,116.00 Cost too low difference is $-4,116.00 760.000.07 Legal and collection $3,585.00 $0.00 $3,585.00 760.000.07 Legal and collection $15,545.00 $0.00 $15,545.00 Operating fund too low difference is $-11,960.00 Cost too low difference is $-11,960.00 780.000.01 Property Protection - Patrol Service $43,435.00 $0.00 $43,435.00 Deleted Asset(s) Expense 840.001.05 General Repair & Maintenance $59,304.00 $0.00 $59,304.00 840.001.05 General Repair & Maintenance $30,437.00 $0.00 $30,437.00 Operating fund too high difference is $28,867.00 Cost too high difference is $28,867.00 840.001.10 Other Repair & Maintenance $0.00 $40.00 $40.00 Added Asset(s) Expense 840.002.04 Janitorial Combined Costs $21,097.00 $0.00 $21,097.00 840.002.04 Janitorial Combined Costs $19,130.00 $0.00 $19,130.00 Operating fund too high difference is $1,967.00 Cost too high difference is $1,967.00 840.004.03 Pest Control $1,728.00 $0.00 $1,728.00 840.004.03 Pest Control $5,725.00 $0.00 $5,725.00 Operating fund too low difference is $-3,997.00 Cost too low difference is $-3,997.00 840.006.03 Pool Supplies/Repair & Maintenance $36,017.00 $246,213.00 $282,230.00 840.006.03 Pool Supplies/Repair & Maintenance $33,519.00 $413,950.00 $447,469.00 Replacement fund too low difference is $-167,737.00 Cost too low difference is $-165,239.00 860.000.01 Electric Service $37,611.00 $0.00 $37,611.00 860.000.01 Electric Service $32,981.00 $0.00 $32,981.00 Operating fund too high difference is $4,630.00 Cost too high difference is $4,630.00 860.000.02 Gas Service $18,912.00 $0.00 $18,912.00 860.000.02 Gas Service $6,032.00 $0.00 $6,032.00 Operating fund too high difference is $12,880.00 Cost too high difference is $12,880.00 860.000.03 Telephone Service $3,471.00 $0.00 $3,471.00 860.000.03 Telephone Service $4,266.00 $0.00 $4,266.00 Operating fund too low difference is $-795.00 Cost too low difference is $-795.00 860.000.04 Trash and Recycling Service $1,375.00 $0.00 $1,375.00 860.000.04 Trash and Recycling Service $1,407.00 $0.00 $1,407.00 Operating fund too low difference is $-32.00 Cost too low difference is $-32.00 860.000.05 Water Service $41,863.00 $0.00 $41,863.00 860.000.05 Water Service $38,146.00 $0.00 $38,146.00 Operating fund too high difference is $3,717.00 Cost too high difference is $3,717.00 880.000.01 Federal Income Tax $3,273.00 $0.00 $3,273.00 Deleted Asset(s) Expense 2020 - 2021 Analysis Summary Estimated inflation 3% Consumer Price Index 1.2% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2020 $704,322.00 $422,159.00 $1,126,481.00 Revenue 2021 $746,734.00 $319,172.00 $1,065,906.00 Expense 2020 $665,817.00 $413,990.00 $1,079,807.00 Expense 2021 $577,990.00 $311,026.00 $889,016.00 revenue - expense 2020 $38,505.00 $8,169.00 $46,674.00 revenue - expense 2021 $168,744.00 $8,146.00 $176,890.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $130,239.00 $-23.00 $130,216.00 percent difference 438.24% -0.28% 378.99% Total Assets 20 Total Issues 82 Issues/Asset 4.10 count % Description 1 5.00% Added Asset(s) 3 15.00% Deleted Asset(s) 7 35.00% Operating fund too high 9 45.00% Operating fund too low 2 10.00% Replacement fund too high 3 15.00% Replacement fund too low 8 40.00% Cost too high 10 50.00% Cost too low Park Paseo Homeowners Association RDA Forensic Analysis For 2020 to 2021 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 010.000.01 Overlay/Rehab Overlay/Rehab 3 26 $13,338.20 $11,769.00 $11,769.00 010.000.01 Overlay/Rehab Overlay/Rehab 0 20 $13,730.50 $13,730.50 $13,730.50 Remaining life decreased too much Useful life decreased 010.000.03 Asphalt Repairs Asphalt Repairs 0 3 $1,897.56 $1,897.56 $1,897.56 010.000.03 Asphalt Repairs Asphalt Repairs 0 3 $1,897.56 $1,897.56 $1,897.56 Maintenance deferred Cost not changed 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 0 3 $3,766.08 $3,766.08 $3,766.08 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 0 3 $3,766.08 $3,766.08 $3,766.08 Maintenance deferred Cost not changed 020.000.03 Clubhouse, Tile Clubhouse, Tile 29 35 $53,850.00 $8,802.40 $0.00 020.000.03 Clubhouse, Tile Clubhouse, Tile 28 35 $55,195.00 $10,614.42 $0.00 No assigned value 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 12 18 $3,015.00 $1,005.00 $1,005.00 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 11 18 $3,098.75 $1,205.07 $0.00 No assigned value 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 26 35 $12,686.25 $3,262.18 $0.00 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 25 35 $12,935.00 $3,695.71 $0.00 No assigned value 030.001.03 Interior Prosa R Interior Prosa Restrooms 7 8 $2,000.00 $193.55 $193.55 030.001.03 Interior Prosa R Interior Prosa Restrooms 6 8 $2,050.00 $462.90 $462.90 Fully funded value too low should be $515.00 Assigned value too low should be $515.00 030.001.08 Interior Clubhou Interior Clubhouse, Restrooms 4 8 $7,000.00 $3,181.82 $3,181.82 030.001.08 Interior Clubhou Interior Clubhouse, Restrooms 3 8 $7,175.00 $4,239.77 $4,239.77 Fully funded value too low should be $4,506.25 Assigned value too low should be $4,506.25 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 20 30 $158,000.00 $51,781.51 $0.00 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 19 30 $161,950.00 $58,519.75 $0.00 No assigned value 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 20 30 $56,700.00 $18,900.00 $0.00 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 19 30 $58,115.00 $21,308.83 $0.00 No assigned value 040.000.05 Walls, Block, Re Walls, Block, Repairs 0 5 $5,000.00 $5,000.00 $5,000.00 040.000.05 Walls, Block, Re Walls, Block, Repairs 0 5 $5,000.00 $5,000.00 $5,000.00 Maintenance deferred Cost not changed 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 11 20 $2,500.00 $1,095.74 $1,095.74 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 10 20 $2,500.00 $1,223.40 $0.00 Cost not changed 040.000.10 Wrought Iron, St Wrought Iron, Streets 11 20 $7,600.00 $3,294.42 $3,294.42 040.000.10 Wrought Iron, St Wrought Iron, Streets 10 20 $7,800.00 $3,782.83 $0.00 No assigned value 050.000.02 Exterior, Monume Exterior, Monument 12 12 $3,200.00 $0.00 $0.00 050.000.02 Exterior, Monume Exterior, Monument 11 12 $3,200.00 $266.67 $0.00 Cost not changed 050.000.04 Exterior, Parkin Exterior, Parking/Volleyball 1 44 $9,000.00 $8,795.45 $8,795.45 050.000.04 Exterior, Parkin Exterior, Parking/Volleyball 0 25 $9,000.00 $9,000.00 $9,000.00 Useful life decreased Cost not changed 050.000.05 Exterior, Prosa Exterior, Prosa 19 20 $1,085.00 $41.20 $0.00 050.000.05 Exterior, Prosa Exterior, Prosa 18 20 $1,100.00 $97.47 $0.00 Fully funded value too low should be $111.75 No assigned value 050.000.06 Exterior, Prosa, Exterior, Prosa, Older 0 20 $3,900.00 $3,900.00 $3,900.00 050.000.06 Exterior, Prosa, Exterior, Prosa, Older 0 20 $4,140.00 $4,140.00 $4,140.00 Maintenance deferred 050.000.08 Interior Prosa C Interior Prosa Cabana 24 25 $1,760.00 $53.33 $0.00 050.000.08 Interior Prosa C Interior Prosa Cabana 23 25 $1,840.00 $130.10 $0.00 Fully funded value too low should be $145.02 No assigned value 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 17 20 $115,000.00 $16,012.66 $1,060.72 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 16 20 $117,875.00 $22,381.33 $0.00 Fully funded value too low should be $23,690.00 No assigned value 050.001.02 Interior Clubhou Interior Clubhouse, 2016 21 25 $965.00 $132.19 $0.00 050.001.02 Interior Clubhou Interior Clubhouse, 2016 20 25 $990.00 $176.30 $0.00 Fully funded value too low should be $198.79 No assigned value 060.001.02 Billiard Tables Billiard Tables 4 47 $10,700.00 $9,789.36 $9,789.36 060.001.02 Billiard Tables Billiard Tables 3 47 $10,700.00 $10,017.02 $10,017.02 Cost not changed 060.001.08 Exterior Stairca Exterior Staircase 10 24 $20,400.00 $11,719.15 $11,719.15 060.001.08 Exterior Stairca Exterior Staircase 9 24 $20,750.00 $12,803.19 $0.00 No assigned value 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 21 25 $14,250.00 $1,952.05 $0.00 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 20 25 $14,500.00 $2,582.19 $0.00 Fully funded value too low should be $2,935.50 No assigned value 060.001.10 Furnishings Furnishings 8 12 $35,000.00 $10,294.12 $10,294.12 060.001.10 Furnishings Furnishings 7 12 $35,000.00 $13,382.35 $0.00 Cost not changed 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 14 20 $30,850.00 $8,981.65 $8,981.65 060.001.11 HVAC Clubhouse O HVAC Clubhouse Office 13 20 $31,600.00 $10,800.00 $0.00 No assigned value 060.001.15 Water Heater Water Heater 11 16 $7,500.00 $2,205.88 $2,205.88 060.001.15 Water Heater Water Heater 10 16 $7,500.00 $2,687.17 $0.00 Cost not changed 060.002.02 Doors, Exterior, Doors, Exterior, Entry 10 25 $14,000.00 $8,324.32 $8,324.32 060.002.02 Doors, Exterior, Doors, Exterior, Entry 9 25 $14,000.00 $8,891.89 $0.00 Cost not changed 060.002.04 Doors, Ext, Clos Doors, Ext, Closets 6 25 $2,400.00 $2,000.00 $2,000.00 060.002.04 Doors, Ext, Clos Doors, Ext, Closets 5 25 $2,445.00 $2,105.42 $2,105.42 Fully funded value too high should be $1,977.60 Assigned value too high should be $1,977.60 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 1 44 $9,200.00 $8,990.91 $8,990.91 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 0 44 $9,200.00 $9,200.00 $9,200.00 Cost not changed 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 24 25 $15,398.00 $314.24 $0.00 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 23 25 $15,775.00 $965.82 $0.00 Fully funded value too low should be $1,268.80 No assigned value 060.002.07 Doors, Pool Acce Doors, Pool Access 1 25 $9,200.00 $8,980.95 $8,980.95 060.002.07 Doors, Pool Acce Doors, Pool Access 0 25 $9,200.00 $9,200.00 $9,200.00 Cost not changed 060.002.09 Doors, Kitchen Doors, Kitchen 21 25 $9,645.00 $1,349.64 $0.00 060.002.09 Doors, Kitchen Doors, Kitchen 20 25 $9,850.00 $1,781.74 $0.00 Fully funded value too low should be $1,986.87 No assigned value 060.003.05 Kitchen, Applian Kitchen, Appliances, Refrigerator 5 12 $1,975.00 $1,128.57 $1,128.57 060.003.05 Kitchen, Applian Kitchen, Appliances, Refrigerator 4 12 $1,975.00 $1,297.86 $1,297.86 Cost not changed 060.003.08 Kitchen, Sink Kitchen, Sink 15 30 $1,000.00 $494.38 $494.38 060.003.08 Kitchen, Sink Kitchen, Sink 14 30 $1,025.00 $541.29 $0.00 No assigned value 060.004.01 Office, Computer Office, Computers/Equipment 3 8 $6,500.00 $4,062.50 $4,062.50 060.004.01 Office, Computer Office, Computers/Equipment 2 8 $5,000.00 $3,750.00 $3,750.00 Cost value too low should be $6,695.00 Fully funded value too low should be $5,021.25 Assigned value too low should be $5,021.25 060.004.09 Office, Equipmen Office, Equipment 0 6 $1,500.00 $1,500.00 $1,500.00 New Assets 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 14 25 $15,862.00 $6,979.28 $6,979.28 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 13 25 $16,655.10 $7,994.45 $0.00 No assigned value 060.005.03 Restroom, Counte Restroom, Counters 14 25 $4,160.00 $1,830.40 $1,830.40 060.005.03 Restroom, Counte Restroom, Counters 13 25 $4,160.00 $1,996.80 $0.00 Cost not changed 060.005.07 Restroom, Locker Restroom, Lockers/Benches 14 25 $10,000.00 $4,400.00 $4,400.00 060.005.07 Restroom, Locker Restroom, Lockers/Benches 13 25 $10,000.00 $4,800.00 $0.00 Cost not changed 060.005.08 Restroom, Partit Restroom, Partitions 14 25 $8,000.00 $3,520.00 $3,520.00 060.005.08 Restroom, Partit Restroom, Partitions 13 25 $8,000.00 $3,840.00 $0.00 Cost not changed 060.005.15 Restroom, Plumbi Restroom, Plumbing Fixtures 14 25 $8,900.00 $3,916.00 $3,916.00 060.005.15 Restroom, Plumbi Restroom, Plumbing Fixtures 13 25 $8,900.00 $4,272.00 $0.00 Cost not changed 065.001.02 Filter, Main Filter, Main 0 12 $6,700.00 $6,700.00 $6,700.00 065.001.02 Filter, Main Filter, Main 0 12 $6,800.00 $6,800.00 $6,800.00 Maintenance deferred 065.001.06 Motors/Pumps Motors/Pumps 1 8 $7,800.00 $6,771.43 $6,771.43 065.001.06 Motors/Pumps Motors/Pumps 0 8 $7,800.00 $7,800.00 $7,800.00 Cost not changed 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 3 8 $1,200.00 $750.00 $750.00 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 2 8 $1,200.00 $900.00 $900.00 Cost not changed 065.002.04 Spa, Pump/Motor, Spa, Pump/Motor, Booster 3 8 $2,950.00 $1,843.75 $1,843.75 065.002.04 Spa, Pump/Motor, Spa, Pump/Motor, Booster 2 8 $2,950.00 $2,212.50 $2,212.50 Cost not changed 065.002.06 Spa, Sump Pump Spa, Sump Pump 7 8 $3,060.00 $296.13 $296.13 065.002.06 Spa, Sump Pump Spa, Sump Pump 6 8 $3,100.00 $700.00 $700.00 Fully funded value too low should be $787.95 Assigned value too low should be $787.95 065.003.01 Wader, Filter Wader, Filter 0 12 $1,100.00 $1,100.00 $1,100.00 065.003.01 Wader, Filter Wader, Filter 0 12 $1,125.00 $1,125.00 $1,125.00 Maintenance deferred 065.003.02 Wader, Heater Wader, Heater 0 12 $3,400.00 $3,400.00 $3,400.00 065.003.02 Wader, Heater Wader, Heater 0 12 $3,500.00 $3,500.00 $3,500.00 Maintenance deferred 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 1 8 $1,100.00 $959.57 $959.57 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 0 8 $1,200.00 $1,200.00 $1,200.00 Cost value too high should be $1,133.00 Fully funded value too high should be $1,133.00 Assigned value too high should be $1,133.00 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 5 12 $10,500.00 $6,125.00 $6,125.00 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 4 12 $10,500.00 $7,000.00 $7,000.00 Cost not changed 067.001.01 Aluminum Trellis Aluminum Trellis 21 30 $49,000.00 $14,216.90 $0.00 067.001.01 Aluminum Trellis Aluminum Trellis 20 30 $50,000.00 $16,197.18 $0.00 No assigned value 067.001.02 Barbecue Island Barbecue Island 6 15 $6,000.00 $3,600.00 $3,600.00 067.001.02 Barbecue Island Barbecue Island 5 15 $6,000.00 $4,000.00 $4,000.00 Cost not changed 067.001.05 Ceramic Shower Ceramic Shower 1 44 $7,000.00 $6,840.91 $6,840.91 067.001.05 Ceramic Shower Ceramic Shower 0 9 $7,250.00 $7,250.00 $7,250.00 Useful life decreased 067.002.01 Concrete Deck, R Concrete Deck, Replace 0 30 $340,000.00 $340,000.00 $340,000.00 067.002.01 Concrete Deck, R Concrete Deck, Replace 0 30 $481,655.00 $481,655.00 $481,655.00 Maintenance deferred Cost value too high should be $350,200.00 Fully funded value too high should be $350,200.00 Assigned value too high should be $350,200.00 067.002.02 Deck Caulking Deck Caulking 0 4 $7,035.00 $7,035.00 $7,035.00 Asset deleted 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 069.001.01 Filter, Prosa Filter, Prosa 2 12 $3,000.00 $2,500.00 $2,500.00 069.001.01 Filter, Prosa Filter, Prosa 11 12 $3,050.00 $254.17 $0.00 Maintenance completed 069.001.04 Heater, Prosa Heater, Prosa 10 12 $6,000.00 $782.61 $782.61 069.001.04 Heater, Prosa Heater, Prosa 9 12 $6,000.00 $1,304.35 $0.00 Cost not changed 069.001.05 Motor Motor 2 17 $2,600.00 $2,294.12 $2,294.12 069.001.05 Motor Motor 7 8 $2,600.00 $325.00 $0.00 Maintenance completed Useful life decreased Cost not changed 070.001.01 Aluminum Trellis Aluminum Trellis 20 30 $13,000.00 $4,333.33 $0.00 070.001.01 Aluminum Trellis Aluminum Trellis 19 30 $13,325.00 $4,885.83 $0.00 No assigned value 070.001.02 Barbecues Barbecues 2 11 $4,200.00 $3,393.60 $3,393.60 070.001.02 Barbecues Barbecues 1 11 $4,200.00 $3,796.80 $3,796.80 Cost not changed 070.001.04 Epoxy Floors Epoxy Floors 11 12 $4,128.00 $263.49 $263.49 070.001.04 Epoxy Floors Epoxy Floors 10 12 $4,214.00 $627.62 $0.00 Fully funded value too low should be $708.64 No assigned value 070.001.06 Plumbing Fixture Plumbing Fixtures 24 25 $6,900.00 $209.09 $0.00 070.001.06 Plumbing Fixture Plumbing Fixtures 23 25 $6,900.00 $487.88 $0.00 Cost not changed 070.001.07 Repairs Repairs 24 25 $5,600.00 $169.70 $0.00 070.001.07 Repairs Repairs 23 25 $5,600.00 $395.96 $0.00 Cost not changed 070.001.09 Wood, Repairs Wood, Repairs 5 5 $3,000.00 $0.00 $0.00 070.001.09 Wood, Repairs Wood, Repairs 4 5 $3,000.00 $600.00 $600.00 Cost not changed 070.001.10 Termite Control/ Termite Control/Fumigation 0 15 $1,350.00 $1,350.00 $1,350.00 070.001.10 Termite Control/ Termite Control/Fumigation 14 15 $1,400.00 $93.33 $0.00 Maintenance completed 070.002.02 Ceramic Tile, In Ceramic Tile, Interior 24 25 $2,669.76 $80.90 $0.00 070.002.02 Ceramic Tile, In Ceramic Tile, Interior 23 25 $2,781.00 $196.64 $0.00 Fully funded value too low should be $219.99 No assigned value 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 24 25 $14,090.40 $426.98 $0.00 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 23 25 $14,856.72 $1,050.48 $0.00 Fully funded value too low should be $1,161.05 No assigned value 070.003.01 Deck, Caulking Deck, Caulking 0 4 $3,198.00 $3,198.00 $3,198.00 Asset deleted 070.003.02 Deck, Repairs Deck, Repairs 10 10 $2,500.00 $0.00 $0.00 070.003.02 Deck, Repairs Deck, Repairs 10 10 $2,500.00 $0.00 $0.00 Remaining life not changed Cost not changed 070.003.03 Deck, Replace Deck, Replace 0 30 $70,000.00 $70,000.00 $70,000.00 Asset deleted 070.004.01 Water Heater Water Heater 11 16 $4,700.00 $1,382.35 $1,382.35 070.004.01 Water Heater Water Heater 10 16 $4,700.00 $1,683.96 $0.00 Cost not changed 070.005.01 Restroom, Counte Restroom, Counters 24 25 $3,640.00 $110.30 $0.00 070.005.01 Restroom, Counte Restroom, Counters 23 25 $3,640.00 $257.37 $0.00 Cost not changed 070.005.03 Doors, Restrooms Doors, Restrooms 19 20 $3,400.00 $129.11 $0.00 070.005.03 Doors, Restrooms Doors, Restrooms 18 20 $3,500.00 $310.13 $0.00 Fully funded value too low should be $350.20 No assigned value 080.000.01 Benches Benches 7 16 $21,700.00 $12,206.25 $12,206.25 080.000.01 Benches Benches 6 16 $21,700.00 $13,562.50 $11,218.20 Cost not changed 080.000.02 Chain Link Fenci Chain Link Fencing 12 55 $22,668.00 $17,722.25 $17,722.25 080.000.02 Chain Link Fenci Chain Link Fencing 11 55 $23,874.00 $19,099.20 $0.00 No assigned value 080.000.05 Lighting Lighting 2 45 $24,000.00 $22,933.33 $22,933.33 080.000.05 Lighting Lighting 1 45 $24,000.00 $23,466.67 $23,466.67 Cost not changed 085.001.03 Trash Receptacle Trash Receptacles 11 20 $11,655.00 $5,244.75 $5,244.75 085.001.03 Trash Receptacle Trash Receptacles 10 20 $11,700.00 $5,850.00 $0.00 No assigned value 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 4 10 $9,000.00 $5,142.86 $5,142.86 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 3 10 $9,000.00 $6,107.14 $6,107.14 Cost not changed 085.003.06 Wood Chips, Alba Wood Chips, Alba 2 6 $4,450.00 $2,781.25 $2,781.25 085.003.06 Wood Chips, Alba Wood Chips, Alba 1 6 $4,450.00 $3,615.63 $3,615.63 Cost not changed 085.004.07 Play Flooring, M Play Flooring, Main, Replace 9 14 $45,000.00 $14,433.96 $14,433.96 085.004.07 Play Flooring, M Play Flooring, Main, Replace 8 14 $45,000.00 $17,830.19 $0.00 Cost not changed 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 4 24 $6,900.00 $5,750.00 $5,750.00 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 3 24 $7,818.00 $6,840.75 $6,840.75 Cost value too high should be $7,107.00 Fully funded value too high should be $6,218.62 Assigned value too high should be $6,218.62 095.001.03 Tree Removal Tree Removal 4 5 $10,000.00 $2,000.00 $2,000.00 095.001.03 Tree Removal Tree Removal 3 5 $10,000.00 $4,000.00 $4,000.00 Cost not changed 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 0 2 $37,000.00 $37,000.00 $37,000.00 Maintenance deferred Cost not changed 095.002.02 Tree Trimming, C Tree Trimming, Common 0 3 $34,000.00 $34,000.00 $34,000.00 095.002.02 Tree Trimming, C Tree Trimming, Common 0 3 $34,000.00 $34,000.00 $34,000.00 Maintenance deferred Cost not changed 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 0 4 $15,000.00 $15,000.00 $15,000.00 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 0 4 $15,000.00 $15,000.00 $15,000.00 Maintenance deferred Cost not changed 095.002.04 Tree Trimming, R Tree Trimming, Red Ironbark 2 4 $7,500.00 $3,586.96 $3,586.96 095.002.04 Tree Trimming, R Tree Trimming, Red Ironbark 1 4 $7,500.00 $5,543.48 $5,543.48 Cost not changed 097.000.02 Irrigation, Cont Irrigation, Controllers 8 15 $33,660.00 $15,708.00 $15,708.00 097.000.02 Irrigation, Cont Irrigation, Controllers 7 15 $34,320.00 $18,304.00 $0.00 No assigned value 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 1 44 $15,600.00 $15,245.45 $15,245.45 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 30 $15,900.00 $15,900.00 $15,900.00 Useful life decreased 100.000.02 Monument Monument 24 25 $28,634.00 $867.70 $0.00 100.000.02 Monument Monument 23 25 $39,350.00 $2,782.32 $0.00 Cost value too high should be $29,493.02 Fully funded value too high should be $2,359.44 No assigned value 105.000.01 Termite Control/ Termite Control/Fumigation 1 25 $4,000.00 $3,840.00 $3,840.00 105.000.01 Termite Control/ Termite Control/Fumigation 0 15 $4,000.00 $4,000.00 $4,000.00 Useful life decreased Cost not changed 2020 - 2021 RDA Forensic Analysis Summary Estimated inflation 3% Consumer Price Index 1.2% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $2,177,097.41 $1,341,026.40 $1,218,941.71 This Year Costs $2,281,463.21 $1,518,464.39 $1,223,443.81 Calculated Costs $2,151,292.59 $1,389,897.30 $1,389,897.30 Comparing This Year Costs to Last Year Costs Difference $104,365.80 $177,437.99 $4,502.10 percent difference 4.79% 13.23% 0.37% Comparing This Year Costs to Calculated Costs Difference $130,170.62 $128,567.09 $-166,453.49 percent difference 5.71% 8.47% -13.61% 125 Total Assets 68 Total Issues $239,877.27 Unfunded Liability 0.54 Issues / Asset number % Description 1 0.80% New Assets 27 21.60% No assigned value 4 3.20% Cost value too high 1 0.80% Cost value too low 5 4.00% Fully funded value too high 15 12.00% Fully funded value too low 4 3.20% Assigned value too high 4 3.20% Assigned value too low 3 2.40% Asset deleted 2 1.60% Remaining life not changed 1 0.80% Remaining life decreased too much 6 4.80% Useful life decreased 11 8.80% Maintenance deferred 3 2.40% Maintenance completed 12 9.60% Total assets to be maintained 43 34.40% Cost not changed