(this report was created 4/13/12 13:43)

Gulfstream Resort

Input array: MV

MV[ 6] Rate/Year to Increase Sales Price or Revenues COSTMV[ 4]  
MV[11] Interest Rate on Line of Credit Financing CSF[;2]  
MV[18] Periods/Year for Development (12=monthly projection,4 COSTMV[ 3] 1
MV[24] Periods of History or Budgeted Cost (forego COSTREF & COSTMV[ 2] 1
MV[25] Premium on Land Value to Add for IROR Calculation 14078109
MV[29] Date these inputs were saved (‘id[2]) (saveDate) 50282
MV[35] Tax Rate  
MV[57] Force basis codes -1 & -3 to include 5 or 6 selected COSTMV[ 8] 1

(this report was created 4/13/12 13:43)

Gulfstream Resort

Input array: PACE

Periods are Annual Total Total To Date 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994
Res: SFD 438 219   55 51 51 51 11            
Res: Patio Apartment 7308 3654   330 328 328 328 208 208 208 208 208 208 1092
Res: Mixed Product 10254 5127   121 121 121 121 276 292 292 292 292 292 2907
Resort Shops 30000 15000     15000                  
Restaurant 60000 30000   10000           20000        
Village Center Commerical 180000 90000               90000        
Neighborhood Center 40000 20000   10000     10000              
Marina Related Commercial 72000 36000   12000   24000                
Boat Sales 14000 7000     7000                  
Dry Marina 12 6   2       4            
Hotel 1200 600       300               300
Golf Club 60000 30000           20000           10000
Racquet Club 30000 15000         15000              
Yacht Club 80000 40000       20000   20000            
Amenity Administration 12000 6000     6000                  
Marina Slips 624 312   57 39     53         28 135
Golf Course(s) 144 72           18           54
Open Space/Recreation 447 224   224                    
Environmentally Sens. 22 11   11                    
Roads 116 58   47       11            
TOTAL 598565 299283   32847 28539 44800 25500 40581 500 110500 500 500 528 14488

(this report was created 4/13/12 13:43)

Gulfstream Resort

Input array: PRICE

Periods are Annual 1
Res: SFD 67945
Res: Patio Apartment 20000
Res: Mixed Product 27428
Resort Shops 10
Restaurant 20
Village Center Commerical 13
Neighborhood Center 24
Marina Related Commercial 10
Boat Sales 12
Dry Marina 44000
Hotel 10000
Golf Club  
Racquet Club  
Yacht Club  
Amenity Administration  
Marina Slips 23125
Golf Course(s) 167500
Open Space/Recreation  
Environmentally Sens.  
Roads  

(this report was created 4/13/12 13:43)

Gulfstream Resort

Input array: LUTTLS

1 Res: SFD
2 Res: Patio Apartment
3 Res: Mixed Product
4 Resort Shops
5 Restaurant
6 Village Center Commerical
7 Neighborhood Center
8 Marina Related Commercial
9 Boat Sales
10 Dry Marina
11 Hotel
12 Golf Club
13 Racquet Club
14 Yacht Club
15 Amenity Administration
16 Marina Slips
17 Golf Course(s)
18 Open Space/Recreation
19 Environmentally Sens.
20 Roads

(this report was created 4/13/12 13:43)

Gulfstream Resort

Input array: COSTREF

  Total 1 2 3 4 5 6 7 8 9 10 11
1 1455 319       132       1005   -1
2 1604 600               1005   -1
3 1804 800               1005   -1
4 849 840 1             6 1 1

(this report was created 4/13/12 13:43)

Gulfstream Resort

Input array: COSTS

Periods are Annual COA# Total Total To Date 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994
Rough Grading 141 24778174 12389087 11968253 420834                    
Street Paving 141 10391726 5195863 1112176 1744128 296927   418392 917840     625800     80600
Water 142 5319210 2659605 671881 371450 17068     637355     137075   58192 766584
Electricity 142 660340 330170 77450 150720 10800   14400 55200     21600      
Security System 147 1800000 900000   627300       272700            
Landscaping & Stabilization 145 1876768 938384 12244 294062 44838   63180 429560     94500      
Fences 147 976000 488000   272000                   216000
Unit Site Work 142 433418 216709   216709                    
Engineering 134 4104940 2052470 965377 465659 44356   59517 277519     105477   6983 127582
Contingency 150 2029240 1014620   434615 41399   55549 259017     98445   6518 119077
Other Amenity 148 1880746 940373 938445   1928                  
Offsite: Water & Water Treatment 149 309302 154651 154651                      
Outlay for Utility Deposits 161 16004604 8002302 48133 1024929 94743 393625 104100 1425936 159620   659590 271350 927596 2892680
Recover Utility Deposits 162 -16004604 -8002302   -48133 -1024929 -94743 -393625 -104100 -1425936 -159620   -659590 -271350 -3820276
Bridges & Culverts 141 10640000 5320000   4700000             320000     300000
Golf Course Construction 147 5400000 2700000           1200000           1500000
Tennis Site Prep & Courts 147 360000 180000   60000       60000           60000
Swim Pool Construction 147 600000 300000   100000       100000           100000
Marina 148 11098630 5549315 1783656 2345100       1420559            
Engineering 134 3053340 1526670 54560 864612 231     333667     38400     235200
Contingency 150 2747940 1373970   806971 216     311423     35840     219520
Clubhouse w/FF&E 147 6800000 3400000           3000000           400000
Racquet Club 147 1800000 900000                       900000
Harbormaster Facility 148 816000 408000                       408000
Yacht Club 148 7200000 3600000           1800000           1800000
Entrances 146 1400000 700000   200000       200000           300000
Engineering 134 2161920 1080960   24000       600000           456960
Contingency 150 2017792 1008896   22400       560000           426496
Maintenance Expense 145 360000 180000   45000 45000                 90000
TOTAL   111015486 55507743 17786826 15142356 -427423 298882 321513 13756676 -1266316 -159620 2136727 -388240 727939 7578423

(this report was created 4/13/12 13:43)

Gulfstream Resort

Input array: GANDA

Periods are Annual COA# Total Total 1 2 3 4 5 6 7 8 9 10 11 12
Income Taxes 9000 36818211 36818211   2149453 2057993 2450389 2069606 2674958 1983802 2318393 2140052 2204547 2392045 14376973

(this report was created 4/13/12 13:43)

Gulfstream Resort

Input array: pRINST

1.Max.width row titles left side of page (to fit 1 page) 1
2.Min.width row titles left side of page (formats same)  
3.Minimal column width desired (to force = col widths)  

(this report was created 4/13/12 13:43)

Gulfstream Resort

Input array: LAND

1. 25921891

(this report was created 4/13/12 13:43)

Gulfstream Resort:1316200 50282 19 (5)

Detail of Financing Sources & Interest

  Total Total To Date 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994
6200 Const Loan Interest                            
6201 Interest Finance A -60893975 -30446988   -5495460 -5679465 -4841313 -3935067 -3639490 -3314028 -2188844 -1074108 -279212    
                             
6300 Borrowing                            
6301 Finance A     43708717 8624737 -6232486 -8465479 -7228045 2623218 -8910555 -10758326 -8505913 -4855868    
                             
OTHER                            
9000 Income Taxes -73636422 -36818211   -2149453 -2057993 -2450389 -2069606 -2674958 -1983802 -2318393 -2140052 -2204547 -2392045 -14376973
                             
FINANCING BALANCES                            
6201 Interest Finance A 31818538   43708717 46837994 34926043 21619251 10456139 9439867 -2784716 -15731886 -25311907 -30446988 -30446988 -30446988