And Excel test regarding home value.
The directions are:
| Use as few hard codes as possible |
| Use “$” to lock in rows/columns where appropriate |
| Use formulas as appropriate |
| Use any resources available (Excel Help, Google, etc.) |
GUIDELINES
You will have 30 minutes to complete as much of the test as possible.
Use as few hard codes as possible
Use “$” to lock in rows/columns where appropriate
Use formulas as appropriate
Use any resources available (Excel Help, Google, etc.)
DIRECTIONS
Assessed Value Tab
Escalate the home price for each phase by 5% above the previous phase (Yellow Box)
Calculate the total assessed value for each phase by Lot Type (Blue Box)
Calculate the total assessed value for each phase and each Lot Type (Green Boxes)
Calculate the total assessed value for the entire project (Orange Box)
Calculate the Weighted Average home price by Phase (Grey Box)
Put the sheet in “Page Break Preview”
Format the sheet Landscape, make it fit on a single page for printing, and center horizontally on page
Assessment Roll Tab
Use “Freeze Panes” to freeze the top 4 rows
Calculate the number of Lots by Lot Type (Yellow Box)
Calculate the total assessment and installment (columns H – O) for each lot type (Green Boxes)
Format the sheet Landscape, make it print on as many sheets as necessary to make it easily readable. Headers sh
GUIDELINES
You will have 30 minutes to complete as much of the test as possible.
Use as few hard codes as possible
Use “$” to lock in rows/columns where appropriate
Use formulas as appropriate
Use any resources available (Excel Help, Google, etc.)
DIRECTIONS
Assessed Value Tab
Escalate the home price for each phase by 5% above the previous phase (Yellow Box)
Calculate the total assessed value for each phase by Lot Type (Blue Box)
Calculate the total assessed value for each phase and each Lot Type (Green Boxes)
Calculate the total assessed value for the entire project (Orange Box)
Calculate the Weighted Average home price by Phase (Grey Box)
Put the sheet in “Page Break Preview”
Format the sheet Landscape, make it fit on a single page for printing, and center horizontally on page
Assessment Roll Tab
Use “Freeze Panes” to freeze the top 4 rows
Calculate the number of Lots by Lot Type (Yellow Box)
Calculate the total assessment and installment (columns H – O) for each lot type (Green Boxes)
Format the sheet Landscape, make it print on as many sheets as necessary to make it easily readable. Headers should repeat
Unit Count
Lot Width (Ft)
Phase 1 Phase 2 Phase 3
30
55
20
40
30
60
50
50
25
20
50
60
10
30
30
70
40
20
Weighted Average Value Per Phase
Phase 4
70
75
–
Phase 1
180.000
240.000
300.000
360.000
420.000
Assessed Value Per Unit
Phase 2
Assessed Value Per Unit
Phase 3 Phase 4
Phase 1
Total Assessed Value
Phase 2 Phase 3
Phase 4
Tax ID
R143375
R143374
R143373
R143372
R143371
R120197
R143368
R143367
R18169
R19065
R143364
R13142
R143365
R159385
R159386
R159387
R159388
R159389
R159390
R159391
R159392
R159393
R159394
R159395
R159396
R159397
R159398
R159399
R159400
R159401
R159402
R159403
R159404
R159405
R159406
R159407
R159408
R159409
R159410
R159411
R159412
R159413
R159414
R159415
R159416
R159417
R159418
R159419
R159420
R159421
R159422
R159423
R159424
R159425
R159426
R159427
R159428
R159429
R159430
R159431
R159432
R159433
R159434
R159435
R159436
R159437
R159438
R159439
R159440
R159441
R159442
R159443
R159444
R159445
R159446
R159447
R159448
R159449
R159450
R159451
R159452
R159453
R159454
R159455
R159456
R159457
R159458
R159459
R159460
R159461
R159462
R159463
R159464
R159465
R159466
R159467
R159468
R159469
R159470
R159471
R159472
R159473
R159474
R159475
R159476
R159477
R159478
R159479
R159480
R159481
R159482
R159483
R159484
R159485
R159486
R159487
R159488
R159489
R159490
R159491
R159492
R159493
R159494
R159495
R159496
R159497
R159498
R159499
R159500
R159501
R159502
R159503
R159504
R159505
R159506
R159507
R159508
R159509
R159510
R159511
R159512
R159513
R159514
R159515
R159516
R159517
R159518
R159519
R159520
R159521
R159522
R159523
R159524
R143369
Total # of Lots
# of “Lot Type 1” Lots
# of “Lot Type 2” Lots
# of “Open Space” Lots
# of “MIA” Lots
Total For Lot Type 1
Total For Lot Type 2
Total For Open Space Lots
Total For MIA Lots
Lot Type (a)
MIA
MIA
MIA
MIA
MIA
MIA
MIA
MIA
MIA
MIA
MIA
MIA
MIA
1
1
1
1
Open Space
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
Open Space
2
2
2
2
2
2
2
1
1
1
1
1
Open Space
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Open Space
2
2
2
2
2
2
2
2
2
2
2
1
1
1
1
1
1
1
1
Open Space
2
2
2
2
2
2
2
2
2
Open Space
1
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
Open Space
Open Space
Open Space
Open Space
MIA
Parcel Description
Major Public Improvement PID Bonds
Major Public Improvement PID Bonds
Major Public Improvement PID Bonds
Major Public Improvement PID Bonds
Major Public Improvement PID Bonds
Major Public Improvement PID Bonds
Major Public Improvement PID Bonds
Major Public Improvement PID Bonds
Major Public Improvement PID Bonds
Major Public Improvement PID Bonds
Major Public Improvement PID Bonds
Major Public Improvement PID Bonds
Major Public Improvement PID Bonds
Block A Lot 1 La Cima Phase 1, Section 1
Block A Lot 2 La Cima Phase 1, Section 1
Block A Lot 3 La Cima Phase 1, Section 1
Block A Lot 4 La Cima Phase 1, Section 1
Block A Lot 5 La Cima Phase 1, Section 1
Block A Lot 6 La Cima Phase 1, Section 1
Block A Lot 7 La Cima Phase 1, Section 1
Block A Lot 8 La Cima Phase 1, Section 1
Block A Lot 9 La Cima Phase 1, Section 1
Block A Lot 10 La Cima Phase 1, Section 1
Block A Lot 11 La Cima Phase 1, Section 1
Block A Lot 12 La Cima Phase 1, Section 1
Block A Lot 13 La Cima Phase 1, Section 1
Block A Lot 14 La Cima Phase 1, Section 1
Block A Lot 15 La Cima Phase 1, Section 1
Block A Lot 16 La Cima Phase 1, Section 1
Block A Lot 17 La Cima Phase 1, Section 1
Block A Lot 18 La Cima Phase 1, Section 1
Block A Lot 19 La Cima Phase 1, Section 1
Block A Lot 20 La Cima Phase 1, Section 1
Block B Lot 1 La Cima Phase 1, Section 1
Block B Lot 2 La Cima Phase 1, Section 1
Block B Lot 3 La Cima Phase 1, Section 1
Block B Lot 4 La Cima Phase 1, Section 1
Block B Lot 5 La Cima Phase 1, Section 1
Block B Lot 6 La Cima Phase 1, Section 1
Block B Lot 7 La Cima Phase 1, Section 1
Block B Lot 8 La Cima Phase 1, Section 1
Block B Lot 9 La Cima Phase 1, Section 1
Block B Lot 10 La Cima Phase 1, Section 1
Block B Lot 11 La Cima Phase 1, Section 1
Block B Lot 12 La Cima Phase 1, Section 1
Block B Lot 13 La Cima Phase 1, Section 1
Block C Lot 1 La Cima Phase 1, Section 1
Block C Lot 2 La Cima Phase 1, Section 1
Block C Lot 3 La Cima Phase 1, Section 1
Block C Lot 4 La Cima Phase 1, Section 1
Block C Lot 5 La Cima Phase 1, Section 1
Block C Lot 6 La Cima Phase 1, Section 1
Block C Lot 7 La Cima Phase 1, Section 1
Block C Lot 8 La Cima Phase 1, Section 1
Block C Lot 9 La Cima Phase 1, Section 1
Block C Lot 10 La Cima Phase 1, Section 1
Block C Lot 11 La Cima Phase 1, Section 1
Block C Lot 12 La Cima Phase 1, Section 1
Block C Lot 13 La Cima Phase 1, Section 1
Block C Lot 14 La Cima Phase 1, Section 1
Block C Lot 15 La Cima Phase 1, Section 1
Block C Lot 16 La Cima Phase 1, Section 1
Block C Lot 17 La Cima Phase 1, Section 1
Block C Lot 18 La Cima Phase 1, Section 1
Block C Lot 19 La Cima Phase 1, Section 1
Block C Lot 20 La Cima Phase 1, Section 1
Block C Lot 21 La Cima Phase 1, Section 1
Block C Lot 22 La Cima Phase 1, Section 1
Block C Lot 23 La Cima Phase 1, Section 1
Block C Lot 24 La Cima Phase 1, Section 1
Block C Lot 25 La Cima Phase 1, Section 1
Block C Lot 26 La Cima Phase 1, Section 1
Block C Lot 27 La Cima Phase 1, Section 1
Block C Lot 28 La Cima Phase 1, Section 1
Block C Lot 29 La Cima Phase 1, Section 1
Block C Lot 30 La Cima Phase 1, Section 1
Block C Lot 31 La Cima Phase 1, Section 1
Block C Lot 32 La Cima Phase 1, Section 1
Block C Lot 33 La Cima Phase 1, Section 1
Block C Lot 34 La Cima Phase 1, Section 1
Block D Lot 1 La Cima Phase 1, Section 1
Block D Lot 2 La Cima Phase 1, Section 1
Block D Lot 3 La Cima Phase 1, Section 1
Block D Lot 4 La Cima Phase 1, Section 1
Block D Lot 5 La Cima Phase 1, Section 1
Block D Lot 6 La Cima Phase 1, Section 1
Block D Lot 7 La Cima Phase 1, Section 1
Block D Lot 8 La Cima Phase 1, Section 1
Block D Lot 9 La Cima Phase 1, Section 1
Block D Lot 10 La Cima Phase 1, Section 1
Block D Lot 11 La Cima Phase 1, Section 1
Block D Lot 12 La Cima Phase 1, Section 1
Block D Lot 13 La Cima Phase 1, Section 1
Block D Lot 14 La Cima Phase 1, Section 1
Block D Lot 15 La Cima Phase 1, Section 1
Block D Lot 16 La Cima Phase 1, Section 1
Block D Lot 17 La Cima Phase 1, Section 1
Block D Lot 18 La Cima Phase 1, Section 1
Block D Lot 19 La Cima Phase 1, Section 1
Block D Lot 20 La Cima Phase 1, Section 1
Block E Lot 1 La Cima Phase 1, Section 1
Block E Lot 2 La Cima Phase 1, Section 1
Block E Lot 3 La Cima Phase 1, Section 1
Block E Lot 4 La Cima Phase 1, Section 1
Block E Lot 5 La Cima Phase 1, Section 1
Block E Lot 6 La Cima Phase 1, Section 1
Block E Lot 7 La Cima Phase 1, Section 1
Block E Lot 8 La Cima Phase 1, Section 1
Block E Lot 9 La Cima Phase 1, Section 1
Block E Lot 10 La Cima Phase 1, Section 1
Block E Lot 11 La Cima Phase 1, Section 1
Block E Lot 12 La Cima Phase 1, Section 1
Block E Lot 13 La Cima Phase 1, Section 1
Block E Lot 14 La Cima Phase 1, Section 1
Block E Lot 15 La Cima Phase 1, Section 1
Block E Lot 16 La Cima Phase 1, Section 1
Block E Lot 17 La Cima Phase 1, Section 1
Block E Lot 18 La Cima Phase 1, Section 1
Block E Lot 19 La Cima Phase 1, Section 1
Block E Lot 20 La Cima Phase 1, Section 1
Block E Lot 21 La Cima Phase 1, Section 1
Block E Lot 22 La Cima Phase 1, Section 1
Block E Lot 23 La Cima Phase 1, Section 1
Block E Lot 24 La Cima Phase 1, Section 1
Block E Lot 25 La Cima Phase 1, Section 1
Block E Lot 26 La Cima Phase 1, Section 1
Block E Lot 27 La Cima Phase 1, Section 1
Block E Lot 28 La Cima Phase 1, Section 1
Block E Lot 29 La Cima Phase 1, Section 1
Block E Lot 30 La Cima Phase 1, Section 1
Block E Lot 31 La Cima Phase 1, Section 1
Block E Lot 32 La Cima Phase 1, Section 1
Block E Lot 33 La Cima Phase 1, Section 1
Block E Lot 34 La Cima Phase 1, Section 1
Block E Lot 35 La Cima Phase 1, Section 1
Block E Lot 36 La Cima Phase 1, Section 1
Block E Lot 37 La Cima Phase 1, Section 1
Block E Lot 38 La Cima Phase 1, Section 1
Block E Lot 39 La Cima Phase 1, Section 1
Block E Lot 40 La Cima Phase 1, Section 1
Block E Lot 41 La Cima Phase 1, Section 1
Block E Lot 42 La Cima Phase 1, Section 1
Block E Lot 43 La Cima Phase 1, Section 1
Block E Lot 44 La Cima Phase 1, Section 1
Block E Lot 45 La Cima Phase 1, Section 1
Block E Lot 46 La Cima Phase 1, Section 1
Block E Lot 47 La Cima Phase 1, Section 1
Block E Lot 48 La Cima Phase 1, Section 1
Block E Lot 49 La Cima Phase 1, Section 1
Block E Lot 50 La Cima Phase 1, Section 1
Block E Lot 51 La Cima Phase 1, Section 1
Block F Lot 1 La Cima Phase 1, Section 1
Block G Lot 1 La Cima Phase 1, Section 1
Future Lot Type 3 and Lot Type 4
Total
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
Major Public Improvements
Outstanding
Assessment
Annual Installment
1.120.812,50 $
99.934,27
873.937,50 $
77.922,32
1.194.875,00 $
106.537,86
1.234.375,00 $
110.059,77
553.000,00 $
49.306,78
$
1.836.750,00 $
163.768,94
1.229.437,50 $
109.619,53
1.886.125,00 $
168.171,33
1.565.187,50 $
139.555,79
506.912,67 $
45.197,52
3.689.962,33 $
329.005,71
928.250,00 $
82.764,95
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
$
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
$
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
$
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
$
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
$
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
$
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
8.811,54 $
785,66
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
10.786,54 $
961,75
$
$
$
$
1.066.500,00 $
95.091,64
18.960.000,00 $
1.690.518,12
Neighborhood Improvement Area #1
Outstanding
Assessment
Annual Installment
$
$
$
$
$
$
$
$
$
$
$
$
$
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
$
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
$
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
$
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
$
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
$
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
$
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
12.347,05 $
878,58
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
15.114,49 $
1.075,50
$
$
$
$
2.215.000,00 $
159.266,43
4.000.000,00 $
286.281,88
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
Total Special Assessments
Outstanding
Total Annual
Assessment
Installment
1.120.812,50 $
99.934,27
873.937,50 $
77.922,32
1.194.875,00 $
106.537,86
1.234.375,00 $
110.059,77
553.000,00 $
49.306,78
$
1.836.750,00 $
163.768,94
1.229.437,50 $
109.619,53
1.886.125,00 $
168.171,33
1.565.187,50 $
139.555,79
506.912,67 $
45.197,52
3.689.962,33 $
329.005,71
928.250,00 $
82.764,95
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
$
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
$
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
$
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
$
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
$
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
$
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
21.158,59 $
1.664,24
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
25.901,03 $
2.037,26
$
$
$
$
3.281.500,00 $
254.358,07
22.960.000,00 $
1.976.800,00