Park Paseo Homeowners Association Audited Forensic Report For 2021 to 2022 Revenue 505.000.01 Homeowners Association Fees $769,344.00 $122,423.00 $891,767.00 505.000.01 Homeowners Association Fees $732,000.00 $318,799.00 $1,050,799.00 Replacement fund too low difference is $-196,376.00 Cost too low difference is $-159,032.00 520.000.01 Clubhouse Rental Fee $6,766.00 $0.00 $6,766.00 520.000.01 Clubhouse Rental Fee $4,580.00 $0.00 $4,580.00 Operating fund too high difference is $2,186.00 Cost too high difference is $2,186.00 540.000.10 Other Income $16,162.00 $0.00 $16,162.00 540.000.10 Other Income $9,992.00 $0.00 $9,992.00 Operating fund too high difference is $6,170.00 Cost too high difference is $6,170.00 550.000.03 Investment Income $823.00 $8,671.00 $9,494.00 550.000.03 Investment Income $162.00 $373.00 $535.00 Operating fund too high difference is $661.00 Replacement fund too high difference is $8,298.00 Cost too high difference is $8,959.00 Expense 640.000.05 General Administrative $3,181.00 $325.00 $3,506.00 640.000.05 General Administrative $19,366.00 $1,083.00 $20,449.00 Operating fund too low difference is $-16,185.00 Replacement fund too low difference is $-758.00 Cost too low difference is $-16,943.00 640.000.07 Office supplies/printing/postage $1,951.00 $0.00 $1,951.00 640.000.07 Office supplies/printing/postage $1,267.00 $0.00 $1,267.00 Operating fund too high difference is $684.00 Cost too high difference is $684.00 700.000.01 Insurance $13,785.00 $0.00 $13,785.00 700.000.01 Insurance $14,939.00 $0.00 $14,939.00 Operating fund too low difference is $-1,154.00 Cost too low difference is $-1,154.00 720.000.08 Landscape Expense $202,092.00 $53,628.00 $255,720.00 720.000.08 Landscape Expense $206,833.00 $63,730.00 $270,563.00 Replacement fund too low difference is $-10,102.00 Cost too low difference is $-14,843.00 760.000.04 Management Fees $127,200.00 $0.00 $127,200.00 760.000.04 Management Fees $107,772.00 $0.00 $107,772.00 Operating fund too high difference is $19,428.00 Cost too high difference is $19,428.00 760.000.07 Legal and collection $15,521.00 $0.00 $15,521.00 760.000.07 Legal and collection $3,585.00 $0.00 $3,585.00 Operating fund too high difference is $11,936.00 Cost too high difference is $11,936.00 760.000.08 Audit/tax preparation/reserve study $3,525.00 $0.00 $3,525.00 760.000.08 Audit/tax preparation/reserve study $2,850.00 $0.00 $2,850.00 Operating fund too high difference is $675.00 Cost too high difference is $675.00 840.001.05 General Repair & Maintenance $67,169.00 $4,714.00 $71,883.00 840.001.05 General Repair & Maintenance $59,304.00 $0.00 $59,304.00 Operating fund too high difference is $7,865.00 Replacement fund too high difference is $4,714.00 Cost too high difference is $12,579.00 840.001.10 Other Repair & Maintenance $0.00 $40.00 $40.00 Deleted Asset(s) Expense 840.001.11 Common Areas $324.00 $0.00 $324.00 Added Asset(s) Expense 840.004.03 Pest Control $1,592.00 $0.00 $1,592.00 840.004.03 Pest Control $1,728.00 $0.00 $1,728.00 Operating fund too low difference is $-136.00 Cost too low difference is $-136.00 840.006.03 Pool Supplies/Repair & Maintenance $63,775.00 $51,312.00 $115,087.00 840.006.03 Pool Supplies/Repair & Maintenance $36,017.00 $246,213.00 $282,230.00 Operating fund too high difference is $27,758.00 Replacement fund too low difference is $-194,901.00 Cost too low difference is $-167,143.00 840.007.02 Tot Lot $1,814.00 $0.00 $1,814.00 Added Asset(s) Expense 860.000.02 Gas Service $27,419.00 $0.00 $27,419.00 860.000.02 Gas Service $18,912.00 $0.00 $18,912.00 Operating fund too high difference is $8,507.00 Cost too high difference is $8,507.00 860.000.03 Telephone Service $3,946.00 $0.00 $3,946.00 860.000.03 Telephone Service $3,471.00 $0.00 $3,471.00 Operating fund too high difference is $475.00 Cost too high difference is $475.00 860.000.04 Trash and Recycling Service $1,567.00 $0.00 $1,567.00 860.000.04 Trash and Recycling Service $1,375.00 $0.00 $1,375.00 Operating fund too high difference is $192.00 Cost too high difference is $192.00 860.000.05 Water Service $88,452.00 $0.00 $88,452.00 860.000.05 Water Service $41,863.00 $0.00 $41,863.00 Operating fund too high difference is $46,589.00 Cost too high difference is $46,589.00 880.000.01 Federal Income Tax $1,330.00 $0.00 $1,330.00 Added Asset(s) Expense 920.000.02 Lighting $16,833.00 $0.00 $16,833.00 Added Asset(s) Expense 2021 - 2022 Analysis Summary Estimated inflation 2.5% Consumer Price Index 4.7% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2021 $746,734.00 $319,172.00 $1,065,906.00 Revenue 2022 $793,095.00 $131,094.00 $924,189.00 Expense 2021 $581,458.00 $311,066.00 $892,524.00 Expense 2022 $698,065.00 $109,979.00 $808,044.00 revenue - expense 2021 $165,276.00 $8,106.00 $173,382.00 revenue - expense 2022 $95,030.00 $21,115.00 $116,145.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $-70,246.00 $13,009.00 $-57,237.00 percent difference -42.50% 260.49% -33.01% Total Assets 20 Total Issues 85 Issues/Asset 4.25 count % Description 4 20.00% Added Asset(s) 1 5.00% Deleted Asset(s) 13 65.00% Operating fund too high 3 15.00% Operating fund too low 2 10.00% Replacement fund too high 4 20.00% Replacement fund too low 12 60.00% Cost too high 6 30.00% Cost too low Park Paseo Homeowners Association UnAudited Forensic Report For 2021 to 2022 Revenue 505.000.01 Homeowners Association Fees $769,344.00 $122,423.00 $891,767.00 505.000.01 Homeowners Association Fees $732,000.00 $318,799.00 $1,050,799.00 Replacement fund too low difference is $-196,376.00 Cost too low difference is $-159,032.00 520.000.01 Clubhouse Rental Fee $6,766.00 $0.00 $6,766.00 520.000.01 Clubhouse Rental Fee $4,580.00 $0.00 $4,580.00 Operating fund too high difference is $2,186.00 Cost too high difference is $2,186.00 540.000.10 Other Income $16,162.00 $0.00 $16,162.00 540.000.10 Other Income $9,992.00 $0.00 $9,992.00 Operating fund too high difference is $6,170.00 Cost too high difference is $6,170.00 550.000.03 Investment Income $823.00 $8,671.00 $9,494.00 550.000.03 Investment Income $162.00 $373.00 $535.00 Operating fund too high difference is $661.00 Replacement fund too high difference is $8,298.00 Cost too high difference is $8,959.00 Expense 640.000.05 General Administrative $3,181.00 $325.00 $3,506.00 640.000.05 General Administrative $19,366.00 $1,083.00 $20,449.00 Operating fund too low difference is $-16,185.00 Replacement fund too low difference is $-758.00 Cost too low difference is $-16,943.00 640.000.07 Office supplies/printing/postage $1,951.00 $0.00 $1,951.00 640.000.07 Office supplies/printing/postage $1,267.00 $0.00 $1,267.00 Operating fund too high difference is $684.00 Cost too high difference is $684.00 700.000.01 Insurance $13,785.00 $0.00 $13,785.00 700.000.01 Insurance $14,939.00 $0.00 $14,939.00 Operating fund too low difference is $-1,154.00 Cost too low difference is $-1,154.00 720.000.08 Landscape Expense $202,092.00 $53,628.00 $255,720.00 720.000.08 Landscape Expense $206,833.00 $63,730.00 $270,563.00 Replacement fund too low difference is $-10,102.00 Cost too low difference is $-14,843.00 760.000.04 Management Fees $127,200.00 $0.00 $127,200.00 760.000.04 Management Fees $107,772.00 $0.00 $107,772.00 Operating fund too high difference is $19,428.00 Cost too high difference is $19,428.00 760.000.07 Legal and collection $15,521.00 $0.00 $15,521.00 760.000.07 Legal and collection $3,585.00 $0.00 $3,585.00 Operating fund too high difference is $11,936.00 Cost too high difference is $11,936.00 760.000.08 Audit/tax preparation/reserve study $3,525.00 $0.00 $3,525.00 760.000.08 Audit/tax preparation/reserve study $2,850.00 $0.00 $2,850.00 Operating fund too high difference is $675.00 Cost too high difference is $675.00 840.001.05 General Repair & Maintenance $67,169.00 $4,714.00 $71,883.00 840.001.05 General Repair & Maintenance $59,304.00 $0.00 $59,304.00 Operating fund too high difference is $7,865.00 Replacement fund too high difference is $4,714.00 Cost too high difference is $12,579.00 840.001.10 Other Repair & Maintenance $0.00 $40.00 $40.00 Deleted Asset(s) Expense 840.001.11 Common Areas $324.00 $0.00 $324.00 Added Asset(s) Expense 840.004.03 Pest Control $1,592.00 $0.00 $1,592.00 840.004.03 Pest Control $1,728.00 $0.00 $1,728.00 Operating fund too low difference is $-136.00 Cost too low difference is $-136.00 840.006.03 Pool Supplies/Repair & Maintenance $63,775.00 $51,312.00 $115,087.00 840.006.03 Pool Supplies/Repair & Maintenance $36,017.00 $246,213.00 $282,230.00 Operating fund too high difference is $27,758.00 Replacement fund too low difference is $-194,901.00 Cost too low difference is $-167,143.00 840.007.02 Tot Lot $1,814.00 $0.00 $1,814.00 Added Asset(s) Expense 860.000.02 Gas Service $27,419.00 $0.00 $27,419.00 860.000.02 Gas Service $18,912.00 $0.00 $18,912.00 Operating fund too high difference is $8,507.00 Cost too high difference is $8,507.00 860.000.03 Telephone Service $3,946.00 $0.00 $3,946.00 860.000.03 Telephone Service $3,471.00 $0.00 $3,471.00 Operating fund too high difference is $475.00 Cost too high difference is $475.00 860.000.04 Trash and Recycling Service $1,567.00 $0.00 $1,567.00 860.000.04 Trash and Recycling Service $1,375.00 $0.00 $1,375.00 Operating fund too high difference is $192.00 Cost too high difference is $192.00 860.000.05 Water Service $88,452.00 $0.00 $88,452.00 860.000.05 Water Service $41,863.00 $0.00 $41,863.00 Operating fund too high difference is $46,589.00 Cost too high difference is $46,589.00 880.000.01 Federal Income Tax $1,330.00 $0.00 $1,330.00 Added Asset(s) Expense 920.000.02 Lighting $16,833.00 $0.00 $16,833.00 Added Asset(s) Expense 2021 - 2022 Analysis Summary Estimated inflation 2.5% Consumer Price Index 4.7% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2021 $746,734.00 $319,172.00 $1,065,906.00 Revenue 2022 $793,095.00 $131,094.00 $924,189.00 Expense 2021 $581,458.00 $311,066.00 $892,524.00 Expense 2022 $698,065.00 $109,979.00 $808,044.00 revenue - expense 2021 $165,276.00 $8,106.00 $173,382.00 revenue - expense 2022 $95,030.00 $21,115.00 $116,145.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $-70,246.00 $13,009.00 $-57,237.00 percent difference -42.50% 260.49% -33.01% Total Assets 20 Total Issues 85 Issues/Asset 4.25 count % Description 4 20.00% Added Asset(s) 1 5.00% Deleted Asset(s) 13 65.00% Operating fund too high 3 15.00% Operating fund too low 2 10.00% Replacement fund too high 4 20.00% Replacement fund too low 12 60.00% Cost too high 6 30.00% Cost too low Park Paseo Homeowners Association RDA Forensic Analysis For 2021 to 2022 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 010.000.01 Overlay/Rehab Overlay/Rehab 0 20 $13,730.50 $13,730.50 $13,730.50 010.000.01 Overlay/Rehab Overlay/Rehab 0 20 $14,122.80 $14,122.80 $14,122.80 Maintenance deferred 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,908.54 $1,908.54 $1,908.54 Maintenance deferred 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,923.00 $3,923.00 $3,923.00 Maintenance deferred 020.000.01 Prosa Cabana Prosa Cabana 24 35 $13,432.50 $4,221.64 $0.00 New Assets 020.000.03 Clubhouse, Tile Clubhouse, Tile 28 35 $55,195.00 $10,614.42 $0.00 020.000.03 Clubhouse, Tile Clubhouse, Tile 27 35 $56,850.00 $12,572.60 $0.00 No assigned value 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 11 18 $3,098.75 $1,205.07 $0.00 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 10 18 $3,350.00 $1,488.89 $1,488.89 Cost value too high should be $3,176.22 Fully funded value too high should be $1,411.65 Assigned value too high should be $1,411.65 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 25 35 $12,935.00 $3,695.71 $0.00 Asset deleted 020.000.07 Clubhouse, Built Clubhouse, Built Up, Flat Entry 2 18 $3,145.00 $2,788.96 $2,788.96 020.000.07 Clubhouse, Built Clubhouse, Built Up, Flat Entry 1 18 $3,400.00 $3,207.55 $3,207.55 Cost value too high should be $3,223.62 Fully funded value too high should be $3,044.53 Assigned value too high should be $3,044.53 030.001.02 Interior Clubhou Interior Clubhouse 3 8 $4,750.20 $2,806.94 $2,806.94 030.001.02 Interior Clubhou Interior Clubhouse 2 8 $7,375.00 $5,363.64 $5,363.64 Cost value too high should be $4,868.96 Fully funded value too high should be $3,651.72 Assigned value too high should be $3,651.72 030.001.03 Interior Prosa R Interior Prosa Restrooms 6 8 $2,050.00 $462.90 $462.90 030.001.03 Interior Prosa R Interior Prosa Restrooms 5 8 $2,100.00 $745.16 $745.16 Fully funded value too low should be $787.97 Assigned value too low should be $787.97 030.001.05 Spa Equipment Ro Spa Equipment Room 0 10 $3,190.00 $3,190.00 $3,190.00 030.001.05 Spa Equipment Ro Spa Equipment Room 1 12 $3,300.00 $3,015.11 $3,015.11 Maintenance deferred Remaining life increased 030.001.06 Stucco Stucco 0 10 $3,700.00 $3,700.00 $3,700.00 030.001.06 Stucco Stucco 1 12 $3,800.00 $3,469.57 $3,469.57 Maintenance deferred Remaining life increased 030.001.08 Interior Clubhou Interior Clubhouse, Restrooms 3 8 $7,175.00 $4,239.77 $4,239.77 030.001.08 Interior Clubhou Interior Clubhouse, Restrooms 2 8 $4,914.00 $3,573.82 $3,573.82 Cost value too low should be $7,354.37 Fully funded value too low should be $5,515.78 Assigned value too low should be $5,515.78 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 0 10 $13,586.50 $13,586.50 $13,586.60 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 1 12 $14,055.00 $12,841.62 $12,841.62 Maintenance deferred Remaining life increased 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 $50,000.00 $50,000.00 $50,000.00 Maintenance deferred Cost value too high should be $5,125.00 Fully funded value too high should be $5,125.00 Assigned value too high should be $5,125.00 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 10 20 $2,500.00 $1,223.40 $0.00 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 9 20 $2,500.00 $1,351.06 $1,351.06 Cost not changed 050.000.01 Exterior, Pool/C Exterior, Pool/Club 0 29 $15,860.00 $15,860.00 $15,860.00 050.000.01 Exterior, Pool/C Exterior, Pool/Club 1 31 $16,680.00 $16,134.60 $16,134.60 Maintenance deferred Remaining life increased 050.000.02 Exterior, Monume Exterior, Monument 11 12 $3,200.00 $266.67 $0.00 050.000.02 Exterior, Monume Exterior, Monument 10 12 $3,200.00 $533.33 $533.33 Cost not changed 050.000.04 Exterior, Parkin Exterior, Parking/Volleyball 0 25 $9,000.00 $9,000.00 $9,000.00 050.000.04 Exterior, Parkin Exterior, Parking/Volleyball 1 46 $9,150.00 $8,951.09 $8,951.09 Maintenance deferred Remaining life increased 050.000.05 Exterior, Prosa Exterior, Prosa 18 20 $1,100.00 $97.47 $0.00 050.000.05 Exterior, Prosa Exterior, Prosa 17 20 $1,130.00 $157.34 $157.34 Fully funded value too low should be $169.12 Assigned value too low should be $169.12 050.000.06 Exterior, Prosa, Exterior, Prosa, Older 0 20 $4,140.00 $4,140.00 $4,140.00 050.000.06 Exterior, Prosa, Exterior, Prosa, Older 1 31 $4,440.00 $4,294.82 $4,294.82 Maintenance deferred Remaining life increased 050.000.08 Interior Prosa C Interior Prosa Cabana 23 25 $1,840.00 $130.10 $0.00 050.000.08 Interior Prosa C Interior Prosa Cabana 22 25 $1,920.00 $213.33 $0.00 Fully funded value too low should be $226.32 No assigned value 050.001.02 Interior Clubhou Interior Clubhouse, 2016 20 25 $990.00 $176.30 $0.00 Asset deleted 050.001.03 Interior Clubhou Interior Clubhouse, 2017 19 25 $1,025.00 $224.66 $224.66 New Assets 060.001.02 Billiard Tables Billiard Tables 3 47 $10,700.00 $10,017.02 $10,017.02 060.001.02 Billiard Tables Billiard Tables 2 47 $10,700.00 $10,244.68 $10,244.68 Cost not changed 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 20 25 $14,500.00 $2,582.19 $0.00 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 19 25 $14,800.00 $3,243.84 $3,243.84 Fully funded value too low should be $3,567.00 Assigned value too low should be $3,567.00 060.001.10 Furnishings Furnishings 7 12 $35,000.00 $13,382.35 $0.00 060.001.10 Furnishings Furnishings 6 12 $35,000.00 $16,470.59 $16,470.59 Cost not changed 060.001.18 Carpeting Carpeting 1 8 $8,695.00 $7,509.32 $7,509.32 060.001.18 Carpeting Carpeting 2 10 $8,880.00 $6,977.14 $6,977.14 Remaining life increased Useful life increased 060.002.04 Doors, Ext, Clos Doors, Ext, Closets 5 25 $2,445.00 $2,105.42 $2,105.42 060.002.04 Doors, Ext, Clos Doors, Ext, Closets 4 36 $2,475.00 $2,200.00 $2,200.00 Useful life increased 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 0 44 $9,200.00 $9,200.00 $9,200.00 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 2 47 $9,300.00 $8,904.26 $8,904.26 Maintenance deferred Remaining life increased 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 23 25 $15,775.00 $965.82 $0.00 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 22 25 $16,000.00 $1,632.65 $0.00 Fully funded value too low should be $1,940.32 No assigned value 060.002.07 Doors, Pool Acce Doors, Pool Access 0 25 $9,200.00 $9,200.00 $9,200.00 060.002.07 Doors, Pool Acce Doors, Pool Access 2 45 $9,300.00 $8,886.67 $8,886.67 Maintenance deferred Remaining life increased 060.002.09 Doors, Kitchen Doors, Kitchen 20 25 $9,850.00 $1,781.74 $0.00 060.002.09 Doors, Kitchen Doors, Kitchen 19 25 $10,000.00 $2,218.43 $2,218.43 Fully funded value too low should be $2,423.10 Assigned value too low should be $2,423.10 060.003.05 Kitchen, Applian Kitchen, Appliances, Refrigerator 4 12 $1,975.00 $1,297.86 $1,297.86 060.003.05 Kitchen, Applian Kitchen, Appliances, Refrigerator 3 12 $1,975.00 $1,467.14 $1,467.14 Cost not changed 060.004.01 Office, Computer Office, Computers/Equipment 2 8 $5,000.00 $3,750.00 $3,750.00 060.004.01 Office, Computer Office, Computers/Equipment 1 8 $5,000.00 $4,375.00 $4,375.00 Cost not changed 060.004.09 Office, Equipmen Office, Equipment 0 6 $1,500.00 $1,500.00 $1,500.00 060.004.09 Office, Equipmen Office, Equipment 1 8 $500.00 $437.50 $437.50 Maintenance deferred Remaining life increased Cost value too low should be $1,537.50 Fully funded value too low should be $1,345.31 Assigned value too low should be $1,345.31 060.004.10 Office, Remodel Office, Remodel 6 20 $14,500.00 $10,113.45 $10,113.45 060.004.10 Office, Remodel Office, Remodel 5 20 $14,500.00 $10,844.54 $10,844.54 Cost not changed 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 0 12 $4,900.00 $4,900.00 $4,900.00 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 0 12 $5,000.00 $5,000.00 $5,000.00 Maintenance deferred 060.005.07 Restroom, Locker Restroom, Lockers/Benches 13 25 $10,000.00 $4,800.00 $0.00 060.005.07 Restroom, Locker Restroom, Lockers/Benches 12 25 $10,000.00 $5,200.00 $5,200.00 Cost not changed 060.005.15 Restroom, Plumbi Restroom, Plumbing Fixtures 13 25 $8,900.00 $4,272.00 $0.00 060.005.15 Restroom, Plumbi Restroom, Plumbing Fixtures 12 25 $8,900.00 $4,628.00 $4,628.00 Cost not changed 065.001.02 Filter, Main Filter, Main 0 12 $6,800.00 $6,800.00 $6,800.00 065.001.02 Filter, Main Filter, Main 11 12 $6,800.00 $566.67 $566.67 Maintenance completed Cost not changed 065.001.06 Motors/Pumps Motors/Pumps 0 8 $7,800.00 $7,800.00 $7,800.00 065.001.06 Motors/Pumps Motors/Pumps 1 10 $7,800.00 $6,986.09 $6,986.09 Maintenance deferred Remaining life increased Cost not changed 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 2 8 $1,200.00 $900.00 $900.00 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 1 8 $1,300.00 $1,137.50 $1,137.50 Cost value too high should be $1,230.00 Fully funded value too high should be $1,076.25 Assigned value too high should be $1,076.25 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 4 12 $10,250.00 $6,833.33 $6,833.33 065.002.05 Spa, Refiberglas Spa, Refiberglass/Replaster & Tile 11 12 $11,000.00 $916.67 $916.67 Maintenance completed 065.002.06 Spa, Sump Pump Spa, Sump Pump 6 8 $3,100.00 $700.00 $700.00 065.002.06 Spa, Sump Pump Spa, Sump Pump 5 8 $3,100.00 $1,100.00 $1,100.00 Cost not changed 065.003.01 Wader, Filter Wader, Filter 0 12 $1,125.00 $1,125.00 $1,125.00 065.003.01 Wader, Filter Wader, Filter 0 12 $1,175.00 $1,175.00 $1,175.00 Maintenance deferred 065.003.02 Wader, Heater Wader, Heater 0 12 $3,500.00 $3,500.00 $3,500.00 065.003.02 Wader, Heater Wader, Heater 0 12 $3,700.00 $3,700.00 $3,700.00 Maintenance deferred 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 0 8 $1,200.00 $1,200.00 $1,200.00 065.003.03 Wader, Pump/Moto Wader, Pump/Motor 0 8 $1,300.00 $1,300.00 $1,300.00 Maintenance deferred Cost value too high should be $1,230.00 Fully funded value too high should be $1,230.00 Assigned value too high should be $1,230.00 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 4 12 $10,500.00 $7,000.00 $7,000.00 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 3 12 $11,500.00 $8,625.00 $8,625.00 Cost value too high should be $10,762.50 Fully funded value too high should be $8,071.87 Assigned value too high should be $8,071.87 067.001.01 Aluminum Trellis Aluminum Trellis 20 30 $50,000.00 $16,197.18 $0.00 067.001.01 Aluminum Trellis Aluminum Trellis 19 30 $51,000.00 $18,245.07 $309.27 Assigned value too low should be $18,791.67 067.001.02 Barbecue Island Barbecue Island 5 15 $6,000.00 $4,000.00 $4,000.00 067.001.02 Barbecue Island Barbecue Island 15 16 $10,000.00 $625.00 $625.00 Maintenance completed Useful life increased 067.001.03 Barbecues Barbecues 1 11 $6,700.00 $6,066.93 $6,066.93 067.001.03 Barbecues Barbecues 7 8 $9,625.00 $1,203.13 $1,203.13 Maintenance completed Useful life decreased 067.001.05 Ceramic Shower Ceramic Shower 0 9 $7,250.00 $7,250.00 $7,250.00 067.001.05 Ceramic Shower Ceramic Shower 19 20 $8,500.00 $425.00 $425.00 Maintenance completed 067.002.01 Concrete Deck, R Concrete Deck, Replace 0 30 $481,655.00 $481,655.00 $481,655.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 9 10 $5,000.00 $500.00 $500.00 Cost not changed 067.002.04 Deck Pavers Deck Pavers 99 99 $0.00 $0.00 $0.00 New Assets 067.003.04 Furniture, Repla Furniture, Replace 1 7 $68,000.00 $57,800.00 $57,800.00 067.003.04 Furniture, Repla Furniture, Replace 1 8 $70,000.00 $60,869.57 $60,869.57 Remaining life not changed Useful life increased 069.001.04 Heater, Prosa Heater, Prosa 9 12 $6,000.00 $1,304.35 $0.00 069.001.04 Heater, Prosa Heater, Prosa 8 12 $6,000.00 $1,826.09 $1,826.09 Cost not changed 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 4 12 $37,000.00 $24,666.67 $24,666.67 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 3 12 $40,000.00 $30,000.00 $30,000.00 Cost value too high should be $37,925.00 Fully funded value too high should be $28,443.75 Assigned value too high should be $28,443.75 070.001.02 Barbecues Barbecues 1 11 $4,200.00 $3,796.80 $3,796.80 070.001.02 Barbecues Barbecues 1 12 $4,400.00 $4,014.60 $4,014.60 Remaining life not changed Useful life increased 070.001.03 Drinking Fountai Drinking Fountain 0 39 $1,700.00 $1,700.00 $1,700.00 070.001.03 Drinking Fountai Drinking Fountain 2 42 $1,750.00 $1,666.67 $1,666.67 Maintenance deferred Remaining life increased 070.001.04 Epoxy Floors Epoxy Floors 10 12 $4,214.00 $627.62 $0.00 070.001.04 Epoxy Floors Epoxy Floors 9 12 $4,300.00 $1,006.38 $1,006.38 Fully funded value too low should be $1,079.84 Assigned value too low should be $1,079.84 070.001.05 Furniture Furniture 1 7 $18,750.00 $15,937.50 $15,937.50 070.001.05 Furniture Furniture 1 8 $19,000.00 $16,521.74 $16,521.74 Remaining life not changed Useful life increased 070.001.06 Plumbing Fixture Plumbing Fixtures 23 25 $6,900.00 $487.88 $0.00 070.001.06 Plumbing Fixture Plumbing Fixtures 22 25 $6,900.00 $766.67 $0.00 Cost not changed 070.001.07 Repairs Repairs 23 25 $5,600.00 $395.96 $0.00 Asset deleted 070.001.09 Wood, Repairs Wood, Repairs 4 5 $3,000.00 $600.00 $600.00 070.001.09 Wood, Repairs Wood, Repairs 3 5 $3,000.00 $1,200.00 $1,200.00 Cost not changed 070.001.10 Termite Control/ Termite Control/Fumigation 14 15 $1,400.00 $93.33 $0.00 070.001.10 Termite Control/ Termite Control/Fumigation 13 15 $1,400.00 $186.67 $186.67 Cost not changed 070.002.02 Ceramic Tile, In Ceramic Tile, Interior 23 25 $2,781.00 $196.64 $0.00 070.002.02 Ceramic Tile, In Ceramic Tile, Interior 22 25 $3,114.72 $346.08 $0.00 Cost value too high should be $2,850.52 No assigned value 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 23 25 $14,856.72 $1,050.48 $0.00 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 22 25 $15,573.60 $1,730.40 $0.00 Fully funded value too low should be $1,827.38 No assigned value 070.003.02 Deck, Repairs Deck, Repairs 10 10 $2,500.00 $0.00 $0.00 070.003.02 Deck, Repairs Deck, Repairs 9 10 $2,500.00 $250.00 $250.00 Cost not changed 070.005.01 Restroom, Counte Restroom, Counters 23 25 $3,640.00 $257.37 $0.00 070.005.01 Restroom, Counte Restroom, Counters 22 25 $3,780.00 $420.00 $0.00 Fully funded value too low should be $447.72 No assigned value 070.005.03 Doors, Restrooms Doors, Restrooms 18 20 $3,500.00 $310.13 $0.00 070.005.03 Doors, Restrooms Doors, Restrooms 17 20 $3,500.00 $487.34 $487.34 Cost not changed 070.005.04 Restroom, Partit Restroom, Partitions 22 25 $5,775.00 $641.67 $0.00 New Assets 080.000.01 Benches Benches 6 16 $21,700.00 $13,562.50 $11,218.20 080.000.01 Benches Benches 5 16 $21,700.00 $14,918.75 $14,918.75 Cost not changed 080.000.04 Deck Caulking Deck Caulking 0 4 $2,572.50 $2,572.50 $2,572.50 080.000.04 Deck Caulking Deck Caulking 0 4 $2,572.50 $2,572.50 $2,572.50 Maintenance deferred Cost not changed 080.000.05 Lighting Lighting 1 45 $24,000.00 $23,466.67 $23,466.67 080.000.05 Lighting Lighting 1 46 $24,400.00 $23,869.57 $23,869.57 Remaining life not changed Useful life increased 080.000.06 Resurfacing Resurfacing 1 7 $9,504.00 $8,146.29 $8,146.29 080.000.06 Resurfacing Resurfacing 0 6 $10,080.00 $10,080.00 $10,080.00 Useful life decreased 080.000.07 Windscreen Windscreen 1 7 $4,151.70 $3,558.60 $3,558.60 080.000.07 Windscreen Windscreen 1 8 $4,744.80 $4,151.70 $4,151.70 Remaining life not changed Useful life increased Cost value too high should be $4,255.49 Fully funded value too high should be $3,723.56 Assigned value too high should be $3,723.56 085.001.01 Benches Benches 6 16 $12,850.00 $8,006.02 $8,006.02 085.001.01 Benches Benches 5 16 $12,850.00 $8,813.35 $8,813.35 Cost not changed 085.001.03 Trash Receptacle Trash Receptacles 10 20 $11,700.00 $5,850.00 $0.00 085.001.03 Trash Receptacle Trash Receptacles 9 20 $11,700.00 $6,435.00 $6,435.00 Cost not changed 085.003.01 Play Equipment, Play Equipment, Alba 1 23 $41,000.00 $39,217.39 $39,217.39 085.003.01 Play Equipment, Play Equipment, Alba 1 24 $42,000.00 $40,250.00 $40,250.00 Remaining life not changed Useful life increased 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 3 10 $9,000.00 $6,107.14 $6,107.14 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 2 10 $9,000.00 $7,071.43 $7,071.43 Cost not changed 085.003.06 Wood Chips, Alba Wood Chips, Alba 1 6 $4,450.00 $3,615.63 $3,615.63 085.003.06 Wood Chips, Alba Wood Chips, Alba 0 6 $4,450.00 $4,450.00 $4,450.00 Cost not changed 085.003.07 Play Equipment, Play Equipment, Prosa 1 25 $25,500.00 $24,459.18 $24,459.18 085.003.07 Play Equipment, Play Equipment, Prosa 1 26 $26,500.00 $25,460.78 $25,460.78 Remaining life not changed Useful life increased 085.004.07 Play Flooring, M Play Flooring, Main, Replace 8 14 $45,000.00 $17,830.19 $0.00 085.004.07 Play Flooring, M Play Flooring, Main, Replace 7 14 $45,000.00 $21,226.42 $21,226.42 Cost not changed 085.004.08 Play Flooring, M Play Flooring, Main, Seal 0 2 $2,575.00 $2,575.00 $2,575.00 085.004.08 Play Flooring, M Play Flooring, Main, Seal 0 2 $2,575.00 $2,575.00 $2,575.00 Maintenance deferred Cost not changed 095.001.03 Tree Removal Tree Removal 3 5 $10,000.00 $4,000.00 $4,000.00 095.001.03 Tree Removal Tree Removal 2 5 $100,000.00 $60,000.00 $60,000.00 Cost value too high should be $10,250.00 Fully funded value too high should be $6,150.00 Assigned value too high should be $6,150.00 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 2 4 $15,000.00 $7,500.00 $7,500.00 Maintenance deferred Remaining life increased Cost not changed 095.002.04 Tree Trimming, R Tree Trimming, Red Ironbark 1 4 $7,500.00 $5,543.48 $5,543.48 095.002.04 Tree Trimming, R Tree Trimming, Red Ironbark 3 4 $7,500.00 $1,875.00 $1,875.00 Maintenance completed Cost not changed 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 30 $15,900.00 $15,900.00 $15,900.00 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 30 $16,050.00 $16,050.00 $16,050.00 Maintenance deferred 100.000.02 Monument Monument 23 25 $39,350.00 $2,782.32 $0.00 100.000.02 Monument Monument 22 25 $39,350.00 $4,372.22 $0.00 Cost not changed 105.000.01 Termite Control/ Termite Control/Fumigation 0 15 $4,000.00 $4,000.00 $4,000.00 105.000.01 Termite Control/ Termite Control/Fumigation 1 27 $4,000.00 $3,851.85 $3,851.85 Maintenance deferred Remaining life increased Cost not changed 2021 - 2022 RDA Forensic Analysis Summary Estimated inflation 2.5% Consumer Price Index 4.7% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $2,281,463.21 $1,518,464.39 $1,223,443.81 This Year Costs $1,981,921.66 $1,191,152.14 $1,146,299.08 Calculated Costs $1,846,154.67 $1,161,554.67 $1,161,554.67 Comparing This Year Costs to Last Year Costs Difference $-299,541.55 $-327,312.25 $-77,144.73 percent difference -13.13% -21.56% -6.31% Comparing This Year Costs to Calculated Costs Difference $135,766.99 $29,597.47 $-15,255.59 percent difference 6.85% 2.48% -1.33% 125 Total Assets 105 Total Issues $39,703.26 Unfunded Liability 0.84 Issues / Asset number % Description 4 3.20% New Assets 6 4.80% No assigned value 11 8.80% Cost value too high 2 1.60% Cost value too low 10 8.00% Fully funded value too high 11 8.80% Fully funded value too low 10 8.00% Assigned value too high 8 6.40% Assigned value too low 4 3.20% Asset deleted 7 5.60% Remaining life not changed 14 11.20% Remaining life increased 10 8.00% Useful life increased 2 1.60% Useful life decreased 26 20.80% Maintenance deferred 6 4.80% Maintenance completed 28 22.40% Total assets to be maintained 33 26.40% Cost not changed