Park Paseo Homeowners Association Audited Forensic Report For 2019 to 2020 Revenue 505.000.01 Homeowners Association Fees $697,224.00 $412,709.00 $1,109,933.00 505.000.01 Homeowners Association Fees $672,271.00 $123,440.00 $795,711.00 Replacement fund too high difference is $289,269.00 Cost too high difference is $314,222.00 520.000.01 Clubhouse Rental Fee $1,800.00 $0.00 $1,800.00 520.000.01 Clubhouse Rental Fee $3,625.00 $0.00 $3,625.00 Operating fund too low difference is $-1,825.00 Cost too low difference is $-1,825.00 540.000.04 Recovery of Bad Debt $2,399.00 $0.00 $2,399.00 540.000.04 Recovery of Bad Debt $4,997.00 $0.00 $4,997.00 Operating fund too low difference is $-2,598.00 Cost too low difference is $-2,598.00 540.000.10 Other Income $2,478.00 $0.00 $2,478.00 540.000.10 Other Income $2,977.00 $0.00 $2,977.00 Operating fund too low difference is $-499.00 Cost too low difference is $-499.00 550.000.03 Investment Income $421.00 $9,450.00 $9,871.00 550.000.03 Investment Income $1,784.00 $24,126.00 $25,910.00 Operating fund too low difference is $-1,363.00 Replacement fund too low difference is $-14,676.00 Cost too low difference is $-16,039.00 Expense 640.000.05 General Administrative $53,917.00 $0.00 $53,917.00 640.000.05 General Administrative $11,060.00 $0.00 $11,060.00 Operating fund too high difference is $42,857.00 Cost too high difference is $42,857.00 640.000.07 Office supplies/printing/postage $3,655.00 $0.00 $3,655.00 640.000.07 Office supplies/printing/postage $20,213.00 $0.00 $20,213.00 Operating fund too low difference is $-16,558.00 Cost too low difference is $-16,558.00 720.000.08 Landscape Expense $244,852.00 $0.00 $244,852.00 720.000.08 Landscape Expense $280,506.00 $0.00 $280,506.00 Operating fund too low difference is $-35,654.00 Cost too low difference is $-35,654.00 760.000.07 Legal and collection $15,545.00 $0.00 $15,545.00 760.000.07 Legal and collection $2,898.00 $0.00 $2,898.00 Operating fund too high difference is $12,647.00 Cost too high difference is $12,647.00 760.000.08 Audit/tax preparation/reserve study $2,715.00 $0.00 $2,715.00 760.000.08 Audit/tax preparation/reserve study $3,850.00 $0.00 $3,850.00 Operating fund too low difference is $-1,135.00 Cost too low difference is $-1,135.00 780.000.01 Property Protection - Patrol Service $43,435.00 $0.00 $43,435.00 780.000.01 Property Protection - Patrol Service $37,900.00 $0.00 $37,900.00 Operating fund too high difference is $5,535.00 Cost too high difference is $5,535.00 840.001.05 General Repair & Maintenance $30,437.00 $0.00 $30,437.00 840.001.05 General Repair & Maintenance $47,022.00 $0.00 $47,022.00 Operating fund too low difference is $-16,585.00 Cost too low difference is $-16,585.00 840.001.10 Other Repair & Maintenance $0.00 $6,133.00 $6,133.00 Deleted Asset(s) Expense 840.001.11 Common Areas $0.00 $12,590.00 $12,590.00 Deleted Asset(s) Expense 840.004.03 Pest Control $5,725.00 $0.00 $5,725.00 840.004.03 Pest Control $3,173.00 $0.00 $3,173.00 Operating fund too high difference is $2,552.00 Cost too high difference is $2,552.00 840.006.03 Pool Supplies/Repair & Maintenance $33,519.00 $413,950.00 $447,469.00 840.006.03 Pool Supplies/Repair & Maintenance $39,023.00 $3,060.00 $42,083.00 Operating fund too low difference is $-5,504.00 Replacement fund too high difference is $410,890.00 Cost too high difference is $405,386.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $124,163.00 $124,163.00 Deleted Asset(s) Expense 840.007.02 Tot Lot $0.00 $950.00 $950.00 Deleted Asset(s) Expense 860.000.01 Electric Service $32,981.00 $0.00 $32,981.00 860.000.01 Electric Service $35,486.00 $0.00 $35,486.00 Operating fund too low difference is $-2,505.00 Cost too low difference is $-2,505.00 860.000.02 Gas Service $6,032.00 $0.00 $6,032.00 860.000.02 Gas Service $12,741.00 $0.00 $12,741.00 Operating fund too low difference is $-6,709.00 Cost too low difference is $-6,709.00 860.000.03 Telephone Service $4,266.00 $0.00 $4,266.00 860.000.03 Telephone Service $4,449.00 $0.00 $4,449.00 Operating fund too low difference is $-183.00 Cost too low difference is $-183.00 2019 - 2020 Analysis Summary Estimated inflation 2.4% Consumer Price Index 1.8% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2019 $685,654.00 $147,566.00 $833,220.00 Revenue 2020 $704,322.00 $422,159.00 $1,126,481.00 Expense 2019 $642,290.00 $146,896.00 $789,186.00 Expense 2020 $624,398.00 $413,950.00 $1,038,348.00 revenue - expense 2019 $43,364.00 $670.00 $44,034.00 revenue - expense 2020 $79,924.00 $8,209.00 $88,133.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $36,560.00 $7,539.00 $44,099.00 percent difference 184.31% 1225.22% 200.15% Total Assets 21 Total Issues 76 Issues/Asset 3.62 count % Description 4 19.05% Deleted Asset(s) 4 19.05% Operating fund too high 12 57.14% Operating fund too low 2 9.52% Replacement fund too high 1 4.76% Replacement fund too low 6 28.57% Cost too high 11 52.38% Cost too low Park Paseo Homeowners Association UnAudited Forensic Report For 2019 to 2020 Revenue 505.000.01 Homeowners Association Fees $697,224.00 $412,709.00 $1,109,933.00 505.000.01 Homeowners Association Fees $672,271.00 $123,440.00 $795,711.00 Replacement fund too high difference is $289,269.00 Cost too high difference is $314,222.00 520.000.01 Clubhouse Rental Fee $1,800.00 $0.00 $1,800.00 520.000.01 Clubhouse Rental Fee $3,625.00 $0.00 $3,625.00 Operating fund too low difference is $-1,825.00 Cost too low difference is $-1,825.00 540.000.04 Recovery of Bad Debt $2,399.00 $0.00 $2,399.00 540.000.04 Recovery of Bad Debt $4,997.00 $0.00 $4,997.00 Operating fund too low difference is $-2,598.00 Cost too low difference is $-2,598.00 540.000.10 Other Income $2,478.00 $0.00 $2,478.00 540.000.10 Other Income $2,977.00 $0.00 $2,977.00 Operating fund too low difference is $-499.00 Cost too low difference is $-499.00 550.000.03 Investment Income $421.00 $9,450.00 $9,871.00 550.000.03 Investment Income $1,784.00 $24,126.00 $25,910.00 Operating fund too low difference is $-1,363.00 Replacement fund too low difference is $-14,676.00 Cost too low difference is $-16,039.00 Expense 640.000.05 General Administrative $53,917.00 $0.00 $53,917.00 640.000.05 General Administrative $11,060.00 $0.00 $11,060.00 Operating fund too high difference is $42,857.00 Cost too high difference is $42,857.00 640.000.07 Office supplies/printing/postage $3,655.00 $0.00 $3,655.00 640.000.07 Office supplies/printing/postage $20,213.00 $0.00 $20,213.00 Operating fund too low difference is $-16,558.00 Cost too low difference is $-16,558.00 720.000.08 Landscape Expense $244,852.00 $0.00 $244,852.00 720.000.08 Landscape Expense $280,506.00 $0.00 $280,506.00 Operating fund too low difference is $-35,654.00 Cost too low difference is $-35,654.00 760.000.07 Legal and collection $15,545.00 $0.00 $15,545.00 760.000.07 Legal and collection $2,898.00 $0.00 $2,898.00 Operating fund too high difference is $12,647.00 Cost too high difference is $12,647.00 760.000.08 Audit/tax preparation/reserve study $2,715.00 $0.00 $2,715.00 760.000.08 Audit/tax preparation/reserve study $3,850.00 $0.00 $3,850.00 Operating fund too low difference is $-1,135.00 Cost too low difference is $-1,135.00 780.000.01 Property Protection - Patrol Service $43,435.00 $0.00 $43,435.00 780.000.01 Property Protection - Patrol Service $37,900.00 $0.00 $37,900.00 Operating fund too high difference is $5,535.00 Cost too high difference is $5,535.00 840.001.05 General Repair & Maintenance $30,437.00 $0.00 $30,437.00 840.001.05 General Repair & Maintenance $47,022.00 $0.00 $47,022.00 Operating fund too low difference is $-16,585.00 Cost too low difference is $-16,585.00 840.001.10 Other Repair & Maintenance $0.00 $6,133.00 $6,133.00 Deleted Asset(s) Expense 840.001.11 Common Areas $0.00 $12,590.00 $12,590.00 Deleted Asset(s) Expense 840.004.03 Pest Control $5,725.00 $0.00 $5,725.00 840.004.03 Pest Control $3,173.00 $0.00 $3,173.00 Operating fund too high difference is $2,552.00 Cost too high difference is $2,552.00 840.006.03 Pool Supplies/Repair & Maintenance $33,519.00 $413,950.00 $447,469.00 840.006.03 Pool Supplies/Repair & Maintenance $39,023.00 $3,060.00 $42,083.00 Operating fund too low difference is $-5,504.00 Replacement fund too high difference is $410,890.00 Cost too high difference is $405,386.00 840.007.01 Recreation Supplies/Repair & Maintenance $0.00 $124,163.00 $124,163.00 Deleted Asset(s) Expense 840.007.02 Tot Lot $0.00 $950.00 $950.00 Deleted Asset(s) Expense 860.000.01 Electric Service $32,981.00 $0.00 $32,981.00 860.000.01 Electric Service $35,486.00 $0.00 $35,486.00 Operating fund too low difference is $-2,505.00 Cost too low difference is $-2,505.00 860.000.02 Gas Service $6,032.00 $0.00 $6,032.00 860.000.02 Gas Service $12,741.00 $0.00 $12,741.00 Operating fund too low difference is $-6,709.00 Cost too low difference is $-6,709.00 860.000.03 Telephone Service $4,266.00 $0.00 $4,266.00 860.000.03 Telephone Service $4,449.00 $0.00 $4,449.00 Operating fund too low difference is $-183.00 Cost too low difference is $-183.00 2019 - 2020 Analysis Summary Estimated inflation 2.4% Consumer Price Index 1.8% Error band +/- 5% Operating Replacement Fund Fund Total Revenue 2019 $685,654.00 $147,566.00 $833,220.00 Revenue 2020 $704,322.00 $422,159.00 $1,126,481.00 Expense 2019 $642,290.00 $146,896.00 $789,186.00 Expense 2020 $624,398.00 $413,950.00 $1,038,348.00 revenue - expense 2019 $43,364.00 $670.00 $44,034.00 revenue - expense 2020 $79,924.00 $8,209.00 $88,133.00 Comparing revenue - expense Operating Replacement Fund Fund Total Difference $36,560.00 $7,539.00 $44,099.00 percent difference 184.31% 1225.22% 200.15% Total Assets 21 Total Issues 76 Issues/Asset 3.62 count % Description 4 19.05% Deleted Asset(s) 4 19.05% Operating fund too high 12 57.14% Operating fund too low 2 9.52% Replacement fund too high 1 4.76% Replacement fund too low 6 28.57% Cost too high 11 52.38% Cost too low Park Paseo Homeowners Association RDA Forensic Analysis For 2019 to 2020 Current Fully Funded Assigned Asset ID Category Asset Name rem life Cost Resereves Reserves 010.000.01 Overlay/Rehab Overlay/Rehab 1 20 $13,103.00 $12,520.00 $12,520.00 010.000.01 Overlay/Rehab Overlay/Rehab 3 26 $13,338.20 $11,769.00 $11,769.00 Remaining life increased Useful life increased 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 1 3 $1,962.00 $1,307.67 $1,307.67 010.000.04 Slurry Sealing & Slurry Sealing & Stripping 0 3 $3,766.08 $3,766.08 $3,766.08 Cost value too high should be $2,009.09 Fully funded value too high should be $2,009.09 Assigned value too high should be $2,009.09 020.000.03 Clubhouse, Tile Clubhouse, Tile 29 35 $53,850.00 $8,802.40 $0.00 New Assets 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 4 18 $1,421.00 $1,099.42 $1,099.42 020.000.04 Clubhouse, Built Clubhouse, Built Up, HVAC 12 18 $3,015.00 $1,005.00 $1,005.00 Remaining life increased Cost value too high should be $1,455.10 Fully funded value too high should be $485.03 Assigned value too high should be $485.03 020.000.05 DaVinci Roof, Cl DaVinci Roof, Clubhouse 30 35 $52,540.00 $7,072.69 $3,149.21 Asset deleted 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 42 50 $12,398.00 $1,983.63 $0.00 020.000.06 DaVinci Roof, Pr DaVinci Roof, Prosa 26 35 $12,686.25 $3,262.18 $0.00 Remaining life decreased too much Useful life decreased No assigned value 020.000.07 Clubhouse, Built Clubhouse, Built Up, Flat Entry 3 18 $3,060.00 $2,540.38 $2,540.38 New Assets 030.001.01 Aluminum, Pools Aluminum, Pools 16 25 $11,088.00 $3,991.52 $3,991.52 030.001.01 Aluminum, Pools Aluminum, Pools 0 0 $0.00 $0.00 $0.00 Assets changed to unfunded 030.001.02 Interior Clubhou Interior Clubhouse 6 8 $4,554.00 $1,138.41 $1,138.41 030.001.02 Interior Clubhou Interior Clubhouse 4 8 $4,586.40 $2,084.73 $2,084.73 Remaining life decreased too much Fully funded value too low should be $2,331.65 Assigned value too low should be $2,331.65 030.001.03 Interior Prosa R Interior Prosa Restrooms 0 8 $1,738.00 $1,738.00 $1,738.00 030.001.03 Interior Prosa R Interior Prosa Restrooms 7 8 $2,000.00 $193.55 $193.55 Maintenance completed 030.001.04 Interior Rec Are Interior Rec Area, Clubhouse 5 7 $7,700.00 $2,200.00 $2,200.00 Asset deleted 030.001.05 Spa Equipment Ro Spa Equipment Room 0 5 $2,970.00 $2,970.00 $2,970.00 030.001.05 Spa Equipment Ro Spa Equipment Room 1 10 $3,080.00 $2,758.61 $2,758.61 Maintenance deferred Remaining life increased 030.001.06 Stucco Stucco 5 10 $3,480.00 $2,088.00 $2,088.00 030.001.06 Stucco Stucco 1 10 $3,600.00 $3,221.05 $3,221.05 Remaining life decreased too much 030.001.07 Woodwork Prosa Woodwork Prosa 0 5 $3,492.00 $3,492.00 $3,492.00 030.001.07 Woodwork Prosa Woodwork Prosa 5 5 $3,004.56 $0.00 $0.00 Maintenance completed 030.001.08 Interior Clubhou Interior Clubhouse, Restrooms 4 8 $7,000.00 $3,181.82 $3,181.82 New Assets 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 3 $190.00 $190.34 $190.34 030.002.04 Wrought Iron, St Wrought Iron, Streets 0 0 $0.00 $0.00 $0.00 Assets changed to unfunded 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 0 5 $12,743.00 $12,743.20 $12,743.20 030.003.01 Wood/Trim, Clubh Wood/Trim, Clubhouse 1 10 $13,118.00 $11,749.17 $11,749.17 Maintenance deferred Remaining life increased 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 16 25 $154,238.00 $54,528.59 $54,528.59 040.000.01 Anodized Aluminu Anodized Aluminum, Main Pool 20 30 $158,000.00 $51,781.51 $0.00 Remaining life increased Useful life increased No assigned value 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 16 25 $55,321.00 $19,915.56 $19,915.56 040.000.02 Anodized Aluminu Anodized Aluminum, Prosa Pool 20 30 $56,700.00 $18,900.00 $0.00 Remaining life increased Useful life increased No assigned value 040.000.03 W/I, Alba West/E W/I, Alba West/Entrada 12 20 $1,013.00 $386.96 $386.96 Asset deleted 040.000.04 W/I, Delamesa/Ca W/I, Delamesa/Campanero 12 20 $7,179.00 $2,871.71 $2,871.71 Asset deleted 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 5 $5,000.00 $5,000.00 $5,000.00 Maintenance deferred Cost not changed 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 12 20 $2,500.00 $968.09 $968.09 040.000.06 Walls, Stucco, R Walls, Stucco, Repairs 11 20 $2,500.00 $1,095.74 $1,095.74 Cost not changed 040.000.10 Wrought Iron, St Wrought Iron, Streets 11 20 $7,600.00 $3,294.42 $3,294.42 New Assets 050.000.01 Exterior, Pool/C Exterior, Pool/Club 1 10 $14,434.00 $13,910.71 $13,910.71 050.000.01 Exterior, Pool/C Exterior, Pool/Club 1 29 $15,300.00 $14,764.72 $14,764.72 Remaining life not changed Useful life increased 050.000.02 Exterior, Monume Exterior, Monument 12 12 $3,200.00 $0.00 $0.00 New Assets 050.000.03 Exterior, Parkin Exterior, Parking Lot 3 22 $1,547.00 $1,328.60 $1,328.60 Asset deleted 050.000.04 Exterior, Parkin Exterior, Parking/Volleyball 1 44 $9,000.00 $8,795.45 $8,795.45 New Assets 050.000.05 Exterior, Prosa Exterior, Prosa 1 10 $2,780.00 $2,679.21 $2,679.21 050.000.05 Exterior, Prosa Exterior, Prosa 19 20 $1,085.00 $41.20 $0.00 Maintenance completed Useful life increased 050.000.06 Exterior, Prosa, Exterior, Prosa, Older 0 20 $3,900.00 $3,900.00 $3,900.00 New Assets 050.000.07 Parking Lot, Ori Parking Lot, Original 1 22 $7,735.00 $7,555.12 $7,555.12 Asset deleted 050.000.08 Interior Prosa C Interior Prosa Cabana 1 25 $1,828.00 $1,779.89 $1,779.89 050.000.08 Interior Prosa C Interior Prosa Cabana 24 25 $1,760.00 $53.33 $0.00 Maintenance completed 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 13 15 $112,464.00 $13,343.19 $13,343.19 050.000.09 Exterior, Walkwa Exterior, Walkway, Bollards 17 20 $115,000.00 $16,012.66 $1,060.72 Remaining life increased Useful life increased Fully funded value too low should be $17,274.47 Assigned value too low should be $17,274.47 050.001.01 Interior Clubhou Interior Clubhouse 1 25 $16,005.00 $15,632.79 $15,632.79 Asset deleted 050.001.02 Interior Clubhou Interior Clubhouse, 2016 23 25 $938.00 $75.04 $75.04 050.001.02 Interior Clubhou Interior Clubhouse, 2016 21 25 $965.00 $132.19 $0.00 Remaining life decreased too much Fully funded value too low should be $153.68 No assigned value 050.001.04 Interior Clubhou Interior Clubhouse, Original 4 47 $16,700.00 $15,278.72 $15,278.72 New Assets 060.001.02 Billiard Tables Billiard Tables 3 25 $10,466.00 $9,768.27 $9,768.27 060.001.02 Billiard Tables Billiard Tables 4 47 $10,700.00 $9,789.36 $9,789.36 Remaining life increased Useful life increased 060.001.04 Carpet, Replace Carpet, Replace 3 8 $8,309.00 $4,909.86 $4,909.86 Asset deleted 060.001.07 Drinking Fountai Drinking Fountain 7 16 $3,250.00 $1,774.32 $1,774.32 New Assets 060.001.08 Exterior Stairca Exterior Staircase 17 30 $19,939.00 $8,448.73 $8,448.73 060.001.08 Exterior Stairca Exterior Staircase 10 24 $20,400.00 $11,719.15 $11,719.15 Remaining life decreased too much Useful life decreased 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 23 25 $13,895.00 $1,111.60 $1,111.60 060.001.09 Floor Tile Kitch Floor Tile Kitchen/Rec 21 25 $14,250.00 $1,952.05 $0.00 Remaining life decreased too much Fully funded value too low should be $2,276.56 No assigned value 060.001.10 Furnishings Furnishings 8 10 $35,000.00 $7,000.00 $7,000.00 060.001.10 Furnishings Furnishings 8 12 $35,000.00 $10,294.12 $10,294.12 Remaining life not changed Useful life increased Cost not changed 060.001.14 Window Blinds Window Blinds 1 10 $16,980.00 $15,822.27 $15,822.27 060.001.14 Window Blinds Window Blinds 4 19 $17,000.00 $13,357.14 $13,357.14 Remaining life increased Useful life increased 060.001.15 Water Heater Water Heater 12 16 $7,438.00 $1,710.34 $1,710.34 060.001.15 Water Heater Water Heater 11 16 $7,500.00 $2,205.88 $2,205.88 Fully funded value too low should be $2,380.16 Assigned value too low should be $2,380.16 060.001.17 Sliding Glass Do Sliding Glass Doors 0 25 $25,000.00 $25,000.00 $25,000.00 Asset deleted 060.001.18 Carpeting Carpeting 2 8 $8,510.00 $6,189.09 $6,189.09 New Assets 060.002.04 Doors, Ext, Clos Doors, Ext, Closets 4 25 $3,701.00 $3,252.39 $3,252.39 060.002.04 Doors, Ext, Clos Doors, Ext, Closets 6 25 $2,400.00 $2,000.00 $2,000.00 Remaining life increased Cost value too low should be $3,789.82 Fully funded value too low should be $2,880.27 Assigned value too low should be $2,880.27 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 4 25 $1,276.00 $1,165.04 $1,165.04 060.002.05 Doors, Exterior, Doors, Exterior, Restrooms 1 44 $9,200.00 $8,990.91 $8,990.91 Remaining life decreased too much Useful life increased Cost value too high should be $1,306.62 Fully funded value too high should be $1,276.93 Assigned value too high should be $1,276.93 060.002.06 Doors, Exterior, Doors, Exterior, Pool Access 24 25 $15,398.00 $314.24 $0.00 New Assets 060.002.07 Doors, Pool Acce Doors, Pool Access 0 25 $5,542.00 $5,542.00 $5,542.00 060.002.07 Doors, Pool Acce Doors, Pool Access 1 25 $9,200.00 $8,980.95 $8,980.95 Maintenance deferred Remaining life increased Cost value too high should be $5,675.01 Fully funded value too high should be $5,448.01 Assigned value too high should be $5,448.01 060.002.09 Doors, Kitchen Doors, Kitchen 23 25 $9,645.00 $771.60 $771.60 060.002.09 Doors, Kitchen Doors, Kitchen 21 25 $9,645.00 $1,349.64 $0.00 Remaining life decreased too much Cost not changed 060.003.01 Kitchen, Applian Kitchen, Appliances 1 12 $5,696.00 $5,307.64 $5,307.64 060.003.01 Kitchen, Applian Kitchen, Appliances 4 19 $4,500.00 $3,535.71 $3,535.71 Remaining life increased Useful life increased Cost value too low should be $5,832.70 Fully funded value too low should be $4,604.77 Assigned value too low should be $4,604.77 060.003.05 Kitchen, Applian Kitchen, Appliances, Refrigerator 5 12 $1,975.00 $1,128.57 $1,128.57 New Assets 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 11 25 $26,389.00 $14,621.00 $14,621.00 060.003.06 Kitchen, Cabinet Kitchen, Cabinets/Counters 5 20 $27,000.00 $20,135.59 $20,135.59 Remaining life decreased too much Useful life decreased 060.003.07 Kitchen, Refrige Kitchen, Refrigerator 6 12 $1,975.00 $959.29 $959.29 Asset deleted 060.003.08 Kitchen, Sink Kitchen, Sink 11 25 $836.00 $463.19 $463.19 060.003.08 Kitchen, Sink Kitchen, Sink 15 30 $1,000.00 $494.38 $494.38 Remaining life increased Useful life increased Cost value too high should be $856.06 Fully funded value too high should be $428.03 Assigned value too high should be $428.03 060.004.01 Office, Computer Office, Computers/Equipment 4 8 $6,500.00 $3,250.00 $3,250.00 060.004.01 Office, Computer Office, Computers/Equipment 3 8 $6,500.00 $4,062.50 $4,062.50 Cost not changed 060.004.09 Office, Equipmen Office, Equipment 2 8 $3,500.00 $2,625.00 $2,625.00 Asset deleted 060.005.01 Restroom Restroom 15 25 $0.00 $0.00 $0.00 Asset deleted 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 15 25 $12,497.00 $4,998.68 $4,998.68 060.005.02 Restroom, Cerami Restroom, Ceramic Tile 14 25 $15,862.00 $6,979.28 $6,979.28 Cost value too high should be $12,796.93 Fully funded value too high should be $5,630.65 Assigned value too high should be $5,630.65 060.005.03 Restroom, Counte Restroom, Counters 10 20 $4,096.00 $2,048.00 $2,048.00 060.005.03 Restroom, Counte Restroom, Counters 14 25 $4,160.00 $1,830.40 $1,830.40 Remaining life increased Useful life increased 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 15 25 $2,432.00 $972.70 $972.70 060.005.04 Restroom, Epoxy Restroom, Epoxy Floor 1 12 $4,800.00 $4,400.00 $4,400.00 Remaining life decreased too much Useful life decreased Cost value too high should be $2,490.37 Fully funded value too high should be $2,282.84 Assigned value too high should be $2,282.84 060.005.07 Restroom, Locker Restroom, Lockers/Benches 12 22 $20,000.00 $9,090.91 $9,090.91 060.005.07 Restroom, Locker Restroom, Lockers/Benches 14 25 $10,000.00 $4,400.00 $4,400.00 Remaining life increased Useful life increased Cost value too low should be $20,480.00 Fully funded value too low should be $9,011.20 Assigned value too low should be $9,011.20 060.005.08 Restroom, Partit Restroom, Partitions 10 20 $5,625.00 $2,812.50 $2,812.50 060.005.08 Restroom, Partit Restroom, Partitions 14 25 $8,000.00 $3,520.00 $3,520.00 Remaining life increased Useful life increased Cost value too high should be $5,760.00 Fully funded value too high should be $2,534.40 Assigned value too high should be $2,534.40 060.005.10 Restroom, Shower Restroom, Shower Door 6 16 $2,124.00 $1,327.50 $1,327.50 060.005.10 Restroom, Shower Restroom, Shower Door 4 15 $2,200.00 $1,613.33 $1,613.33 Remaining life decreased too much Useful life decreased 060.005.12 Women's Shower Women's Shower 18 25 $3,657.00 $1,006.29 $1,006.29 Asset deleted 060.005.13 Restroom, Fixtur Restroom, Fixtures 15 25 $7,734.00 $3,093.60 $3,093.60 Asset deleted 060.005.15 Restroom, Plumbi Restroom, Plumbing Fixtures 14 25 $8,900.00 $3,916.00 $3,916.00 New Assets 065.001.02 Filter, Main Filter, Main 0 12 $6,640.00 $6,640.00 $6,640.00 065.001.02 Filter, Main Filter, Main 0 12 $6,700.00 $6,700.00 $6,700.00 Maintenance deferred 065.001.04 Motor/Pump Syste Motor/Pump System 2 8 $7,754.00 $5,708.99 $5,708.99 Asset deleted 065.001.06 Motors/Pumps Motors/Pumps 1 8 $7,800.00 $6,771.43 $6,771.43 New Assets 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 8 14 $81,088.00 $34,752.00 $34,752.00 065.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Main 5 12 $82,000.00 $47,833.33 $47,833.33 Remaining life decreased too much Useful life decreased 065.002.01 Spa, Filter Spa, Filter 0 10 $1,495.00 $1,495.00 $1,495.00 065.002.01 Spa, Filter Spa, Filter 5 10 $1,500.00 $750.00 $750.00 Maintenance deferred Remaining life increased 065.002.02 Spa, Heater Spa, Heater 5 10 $2,806.00 $1,391.21 $1,391.21 065.002.02 Spa, Heater Spa, Heater 4 10 $3,800.00 $2,267.23 $2,267.23 Cost value too high should be $2,873.34 Fully funded value too high should be $1,724.01 Assigned value too high should be $1,724.01 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 0 8 $1,217.00 $1,217.00 $1,217.00 065.002.03 Spa, Pump/Motor Spa, Pump/Motor 3 8 $1,200.00 $750.00 $750.00 Maintenance deferred Remaining life increased 065.002.04 Spa, Pump/Motor, Spa, Pump/Motor, Booster 0 8 $2,878.00 $2,878.00 $2,878.00 065.002.04 Spa, Pump/Motor, Spa, Pump/Motor, Booster 3 8 $2,950.00 $1,843.75 $1,843.75 Maintenance deferred Remaining life increased 065.002.06 Spa, Sump Pump Spa, Sump Pump 0 8 $3,116.00 $3,116.00 $3,116.00 065.002.06 Spa, Sump Pump Spa, Sump Pump 7 8 $3,060.00 $296.13 $296.13 Maintenance completed 065.003.01 Wader, Filter Wader, Filter 0 12 $1,072.00 $1,072.00 $1,072.00 065.003.01 Wader, Filter Wader, Filter 0 12 $1,100.00 $1,100.00 $1,100.00 Maintenance deferred 065.003.02 Wader, Heater Wader, Heater 0 12 $3,323.00 $3,323.00 $3,323.00 065.003.02 Wader, Heater Wader, Heater 0 12 $3,400.00 $3,400.00 $3,400.00 Maintenance deferred 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 8 14 $10,286.00 $4,408.29 $4,408.29 065.003.04 Wader, Refibergl Wader, Refiberglass/Replaster & Tile 5 12 $10,500.00 $6,125.00 $6,125.00 Remaining life decreased too much Useful life decreased 067.001.01 Aluminum Trellis Aluminum Trellis 21 30 $49,000.00 $14,216.90 $0.00 New Assets 067.001.02 Barbecue Island Barbecue Island 6 15 $6,000.00 $3,600.00 $3,600.00 New Assets 067.001.03 Barbecues Barbecues 0 5 $5,166.00 $5,166.00 $5,166.00 067.001.03 Barbecues Barbecues 2 11 $6,600.00 $5,352.76 $5,352.76 Maintenance deferred Remaining life increased Cost value too high should be $5,289.98 Fully funded value too high should be $4,328.17 Assigned value too high should be $4,328.17 067.001.05 Ceramic Shower Ceramic Shower 1 25 $6,925.00 $6,763.74 $6,763.74 067.001.05 Ceramic Shower Ceramic Shower 1 44 $7,000.00 $6,840.91 $6,840.91 Remaining life not changed Useful life increased 067.001.07 Patio/Spa Patio/Spa 1 30 $126,000.00 $123,070.00 $123,070.00 Asset deleted 067.001.08 Pool/Wader Pool/Wader 1 30 $161,000.00 $157,256.00 $157,256.00 Asset deleted 067.002.01 Concrete Deck, R Concrete Deck, Replace 0 30 $340,000.00 $340,000.00 $340,000.00 New Assets 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 1 12 $2,990.00 $2,731.87 $2,731.87 069.001.01 Filter, Prosa Filter, Prosa 2 12 $3,000.00 $2,500.00 $2,500.00 Remaining life increased 069.001.04 Heater, Prosa Heater, Prosa 11 12 $6,000.00 $261.00 $261.00 069.001.04 Heater, Prosa Heater, Prosa 10 12 $6,000.00 $782.61 $782.61 Cost not changed 069.001.05 Motor Motor 3 8 $2,434.00 $2,004.47 $2,004.47 069.001.05 Motor Motor 2 17 $2,600.00 $2,294.12 $2,294.12 Useful life increased 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 8 14 $35,434.00 $15,186.00 $15,186.00 069.001.07 Refiberglass/Rep Refiberglass/Replaster & Tile, Prosa 5 12 $36,300.00 $21,175.00 $21,175.00 Remaining life decreased too much Useful life decreased 070.001.01 Aluminum Trellis Aluminum Trellis 21 30 $12,634.00 $3,790.20 $3,790.20 070.001.01 Aluminum Trellis Aluminum Trellis 20 30 $13,000.00 $4,333.33 $0.00 No assigned value 070.001.02 Barbecues Barbecues 0 8 $4,221.00 $4,221.00 $4,221.00 070.001.02 Barbecues Barbecues 2 11 $4,200.00 $3,393.60 $3,393.60 Maintenance deferred Remaining life increased 070.001.03 Drinking Fountai Drinking Fountain 1 39 $1,675.00 $1,632.05 $1,632.05 New Assets 070.001.04 Epoxy Floors Epoxy Floors 11 12 $4,128.00 $263.49 $263.49 New Assets 070.001.06 Plumbing Fixture Plumbing Fixtures 0 25 $5,938.00 $5,938.00 $5,938.00 070.001.06 Plumbing Fixture Plumbing Fixtures 24 25 $6,900.00 $209.09 $0.00 Maintenance completed 070.001.07 Repairs Repairs 0 20 $3,367.00 $3,367.00 $3,367.00 070.001.07 Repairs Repairs 24 25 $5,600.00 $169.70 $0.00 Maintenance completed 070.001.08 Replace Replace 2 30 $57,000.00 $54,409.09 $54,409.09 Asset deleted 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 5 5 $3,000.00 $0.00 $0.00 Maintenance completed 070.001.10 Termite Control/ Termite Control/Fumigation 0 15 $1,350.00 $1,350.00 $1,350.00 New Assets 070.002.01 Ceramic Shower Ceramic Shower 0 25 $7,610.67 $7,610.67 $7,610.67 Asset deleted 070.002.02 Ceramic Tile, In Ceramic Tile, Interior 24 25 $2,669.76 $80.90 $0.00 New Assets 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 0 25 $9,720.00 $9,720.11 $9,720.11 070.002.03 Ceramic Tile, Sh Ceramic Tile, Shower 24 25 $14,090.40 $426.98 $0.00 Maintenance completed 070.003.02 Deck, Repairs Deck, Repairs 10 10 $2,500.00 $0.00 $0.00 New Assets 070.003.03 Deck, Replace Deck, Replace 0 30 $70,000.00 $70,000.00 $70,000.00 New Assets 070.004.01 Water Heater Water Heater 12 16 $4,680.00 $1,076.00 $1,076.00 070.004.01 Water Heater Water Heater 11 16 $4,700.00 $1,382.35 $1,382.35 Fully funded value too low should be $1,497.60 Assigned value too low should be $1,497.60 070.005.01 Restroom, Counte Restroom, Counters 0 20 $1,150.00 $1,150.00 $1,150.00 070.005.01 Restroom, Counte Restroom, Counters 24 25 $3,640.00 $110.30 $0.00 Maintenance completed 070.005.03 Doors, Restrooms Doors, Restrooms 0 21 $1,276.00 $1,276.00 $1,276.00 070.005.03 Doors, Restrooms Doors, Restrooms 19 20 $3,400.00 $129.11 $0.00 Maintenance completed 070.005.04 Restroom, Partit Restroom, Partitions 10 10 $2,500.00 $0.00 $0.00 Asset deleted 080.000.01 Benches Benches 7 15 $21,434.00 $11,431.47 $11,431.47 080.000.01 Benches Benches 7 16 $21,700.00 $12,206.25 $12,206.25 Remaining life not changed Useful life increased 080.000.02 Chain Link Fenci Chain Link Fencing 4 30 $20,978.00 $19,153.83 $19,153.83 080.000.02 Chain Link Fenci Chain Link Fencing 12 55 $22,668.00 $17,722.25 $17,722.25 Remaining life increased Useful life increased Cost value too high should be $21,481.47 Fully funded value too high should be $16,794.61 Assigned value too high should be $16,794.61 080.000.05 Lighting Lighting 1 25 $14,368.00 $14,033.86 $14,033.86 080.000.05 Lighting Lighting 2 45 $24,000.00 $22,933.33 $22,933.33 Remaining life increased Useful life increased Cost value too high should be $14,712.83 Fully funded value too high should be $14,058.93 Assigned value too high should be $14,058.93 080.000.06 Resurfacing Resurfacing 2 6 $10,080.00 $6,720.00 $6,720.00 080.000.06 Resurfacing Resurfacing 2 7 $9,360.00 $6,685.71 $6,685.71 Remaining life not changed Useful life increased Cost value too low should be $10,321.92 Fully funded value too low should be $7,372.80 Assigned value too low should be $7,372.80 080.000.07 Windscreen Windscreen 2 6 $3,005.00 $2,003.36 $2,003.36 080.000.07 Windscreen Windscreen 2 7 $3,954.00 $2,824.29 $2,824.29 Remaining life not changed Useful life increased Cost value too high should be $3,077.12 Fully funded value too high should be $2,197.94 Assigned value too high should be $2,197.94 085.001.01 Benches Benches 4 12 $12,286.00 $8,162.03 $8,162.03 085.001.01 Benches Benches 7 16 $12,600.00 $7,058.64 $7,058.64 Remaining life increased Useful life increased 085.001.02 Trash Cans Trash Cans 7 15 $11,547.00 $6,158.40 $6,158.40 Asset deleted 085.001.03 Trash Receptacle Trash Receptacles 11 20 $11,655.00 $5,244.75 $5,244.75 New Assets 085.002.01 Drinking Fountai Drinking Fountain, C/H 8 16 $3,188.00 $1,533.69 $1,533.69 Asset deleted 085.002.03 Drinking Fountai Drinking Fountain, Prosa 0 16 $1,590.00 $1,590.00 $1,590.00 Asset deleted 085.003.01 Play Equipment, Play Equipment, Alba 1 18 $24,085.00 $22,938.10 $22,938.10 085.003.01 Play Equipment, Play Equipment, Alba 2 23 $40,000.00 $36,521.74 $36,521.74 Remaining life increased Useful life increased Cost value too high should be $24,663.04 Fully funded value too high should be $22,518.43 Assigned value too high should be $22,518.43 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 5 10 $8,909.00 $4,136.32 $4,136.32 085.003.05 Sand Repl, Prosa Sand Repl, Prosa 4 10 $9,000.00 $5,142.86 $5,142.86 Fully funded value too low should be $5,473.69 Assigned value too low should be $5,473.69 085.003.06 Wood Chips, Alba Wood Chips, Alba 7 10 $9,075.00 $2,268.75 $2,268.75 085.003.06 Wood Chips, Alba Wood Chips, Alba 2 6 $4,450.00 $2,781.25 $2,781.25 Remaining life decreased too much Useful life decreased Cost value too low should be $9,292.80 Fully funded value too low should be $6,195.20 Assigned value too low should be $6,195.20 085.003.07 Play Equipment, Play Equipment, Prosa 2 25 $25,000.00 $22,959.18 $22,959.18 New Assets 085.004.01 Play Equip, Main Play Equip, Main, Prosa 1 18 $54,941.00 $52,499.18 $52,499.18 Asset deleted 085.004.02 Poured In Place, Poured In Place, Main 11 14 $44,262.00 $9,484.71 $9,484.71 Asset deleted 085.004.05 Play Equipment, Play Equipment, Main 4 27 $55,000.00 $46,698.11 $46,698.11 New Assets 085.004.07 Play Flooring, M Play Flooring, Main, Replace 9 14 $45,000.00 $14,433.96 $14,433.96 New Assets 085.004.08 Play Flooring, M Play Flooring, Main, Seal 1 2 $2,520.00 $1,080.00 $1,080.00 New Assets 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 1 15 $5,082.00 $4,827.90 $4,827.90 090.000.01 Deck Railing, Wo Deck Railing, Wood, Clubhouse 4 24 $6,900.00 $5,750.00 $5,750.00 Remaining life increased Useful life increased Cost value too high should be $5,203.97 Fully funded value too high should be $4,336.64 Assigned value too high should be $4,336.64 090.000.02 Trellis, Clubhou Trellis, Clubhouse 22 30 $48,017.00 $12,308.58 $12,308.58 Asset deleted 095.001.03 Tree Removal Tree Removal 4 5 $10,000.00 $2,000.00 $2,000.00 New Assets 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 1 4 $15,000.00 $11,086.96 $11,086.96 095.002.03 Tree Trimming, J Tree Trimming, Jacaranda 0 4 $15,000.00 $15,000.00 $15,000.00 Cost not changed 095.002.04 Tree Trimming, R Tree Trimming, Red Ironbark 3 4 $7,500.00 $1,630.43 $1,630.43 095.002.04 Tree Trimming, R Tree Trimming, Red Ironbark 2 4 $7,500.00 $3,586.96 $3,586.96 Cost not changed 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 0 24 $28,626.00 $28,626.00 $28,626.00 097.000.03 Irrigation, Cont Irrigation, Controller Enclosures 1 44 $15,600.00 $15,245.45 $15,245.45 Maintenance deferred Remaining life increased Cost value too low should be $29,313.02 Fully funded value too low should be $28,646.82 Assigned value too low should be $28,646.82 100.000.01 Bulletin Board Bulletin Board 1 15 $1,178.00 $1,131.35 $1,131.35 100.000.01 Bulletin Board Bulletin Board 0 0 $0.00 $0.00 $0.00 Assets changed to unfunded 100.000.02 Monument Monument 25 25 $28,000.00 $0.00 $0.00 100.000.02 Monument Monument 24 25 $28,634.00 $867.70 $0.00 Fully funded value too low should be $1,146.88 No assigned value 105.000.01 Termite Control/ Termite Control/Fumigation 1 15 $5,259.00 $5,040.00 $5,040.00 105.000.01 Termite Control/ Termite Control/Fumigation 1 25 $4,000.00 $3,840.00 $3,840.00 Remaining life not changed Useful life increased Cost value too low should be $5,385.22 Fully funded value too low should be $5,169.81 Assigned value too low should be $5,169.81 2019 - 2020 RDA Forensic Analysis Summary Estimated inflation 2.4% Consumer Price Index 1.8% Error band +/- 5% Funded Assigned Total Cost value Value Last Year Costs $2,028,760.67 $1,210,191.22 $1,204,284.11 This Year Costs $2,177,097.41 $1,341,026.40 $1,218,941.71 Calculated Costs $2,162,603.54 $1,358,540.54 $1,358,540.54 Comparing This Year Costs to Last Year Costs Difference $148,336.74 $130,835.18 $14,657.60 percent difference 7.31% 10.81% 1.22% exceeds CC&R limits Comparing This Year Costs to Calculated Costs Difference $14,493.87 $-17,514.14 $-139,598.83 percent difference 0.67% -1.31% -11.45% 127 Total Assets 137 Total Issues $159,001.56 Unfunded Liability 1.08 Issues / Asset number % Description 29 22.83% New Assets 7 5.51% No assigned value 15 11.81% Cost value too high 7 5.51% Cost value too low 15 11.81% Fully funded value too high 15 11.81% Fully funded value too low 15 11.81% Assigned value too high 12 9.45% Assigned value too low 26 20.47% Asset deleted 8 6.30% Remaining life not changed 28 22.05% Remaining life increased 15 11.81% Remaining life decreased too much 26 20.47% Useful life increased 9 7.09% Useful life decreased 15 11.81% Maintenance deferred 11 8.66% Maintenance completed 24 18.90% Total assets to be maintained 11 8.66% Cost not changed 3 2.36% Assets changed to unfunded