St. Lucie West Warehouse (condo-sens.test):1319400 102389 39 (5)

Cash Flow Projection

Monthly County-wide ??

  Total Total Nov'89 Dec'89 Jan'90 Feb'90 Mar'90 Apr'90 May'90 Jun'90 Jul'90 Aug'90 Sep'90 Oct'90
Number of Settlements       2450 2450 2450 2450 2450 2450 1880        
Average Price       43 43 43 43 43 43 43        
300 Sales 712940 712940           105350 105350 105350 105350 105350 105350 80840
132.9 Land Cost -132000 -132000 -132000                      
143 Direct Construction Costs -249825 -249825   -62456 -62457 -62456 -62456              
143.65 Tenant Improvements -45000 -45000           -6650 -6650 -6650 -6650 -6650 -6650 -5103
Subtotal -294825 -294825   -62456 -62457 -62456 -62456 -6650 -6650 -6650 -6650 -6650 -6650 -5103
144.13 Architecture (product) -3000 -3000 -3000                      
141.21 Engineering -4200 -4200 -4200                      
148.6 Bonds & Permits -2825 -2825 -2825                      
148.7 Impact Fees -3788 -3788 -3788                      
148.9 Legal -5000 -5000 -5000                      
149.9 Contingency -5000.103802 -5000 -119 -1034 -1034 -1034 -1034 -110 -110 -110 -110 -110 -110 -84
Subtotal -16613.1038 -16613 -11732 -1034 -1034 -1034 -1034 -110 -110 -110 -110 -110 -110 -84
560 Closing Costs Paid for Customers -20250 -20250           -2992 -2992 -2992 -2992 -2992 -2992 -2296
610 Salaries & Commissions -42776.4 -42776           -6321 -6321 -6321 -6321 -6321 -6321 -4850
620 Advertising -9000 -9000 -1000 -1000 -1000 -1000 -1000 -1000 -1000 -1000 -1000      
Subtotal -72026.4 -72026 -1000 -1000 -1000 -1000 -1000 -10313 -10313 -10313 -10313 -9313 -9313 -7147
850 Insurance -2700 -2700 -300 -300 -300 -300 -300 -300 -300 -300 -300      
890 Other G&A -2700 -2700 -300 -300 -300 -300 -300 -300 -300 -300 -300      
Subtotal -5400 -5400 -600 -600 -600 -600 -600 -600 -600 -600 -600      
Monthly DEBT FREE CASH FLOW 184875.4962 184875 -152532 -65090 -65091 -65090 -65090 87677 87677 87677 87677 89277 89277 68506
Cumulative DEBT FREE CASH FLOW     -152532 -217622 -282713 -347803 -412893 -325216 -237539 -149862 -62185 27092 116369 184875
6201 Interest Finance A                            
6202 Interest Finance B -23466.4726 -23466 -779 -1905 -2593 -3287 -3989 -3918 -3058 -2190 -1313 -435    
Subtotal -23466.4726 -23466 -779 -1905 -2593 -3287 -3989 -3918 -3058 -2190 -1313 -435    
6301 Finance A                            
6302 Finance B     153311 66995 67684 68377 69079 -83759 -84619 -85487 -86364 -85217    
6401 Repay Finance A                            
Subtotal     153311 66995 67684 68377 69079 -83759 -84619 -85487 -86364 -85217    
Monthly PRE-TAX CASH FLOW 161409.0236 161409                   3625 89277 68506
Cumulative PRE-TAX CASH FLOW             1 1 1     3626 92903 161409