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

Covenant Village

Input array: MV

MV[ 6] Rate/Year to Increase Sales Price or Revenues COSTMV[ 4]  
MV[ 7] Rate/Year to Increase Costs (& Revenues if 0=) COSTMV[ 5]  
MV[ 8] Months to Forego Cost Increase (effects MV[6],MV[7], COSTMV[ 6] 6
MV[11] Interest Rate on Line of Credit Financing CSF[;2]  
MV[18] Periods/Year for Development (12=monthly projection,4 COSTMV[ 3] 4
MV[23] Level of Detail to Print (1000 = in 000's) PRINST[14] 1
MV[24] Periods of History or Budgeted Cost (forego COSTREF & COSTMV[ 2] 2
MV[26] Residual(0=none)(ˆ.2=Cap.Cash Flow)(ˆ1=% of net cost)(>1=value) 3015000
MV[27] Do not extend with last column COSTMV[12] 1
MV[29] Date these inputs were saved (‘id[2]) (saveDate) 22685
MV[44] DCF Valuation Rate °  
MV[57] Force basis codes -1 & -3 to include 5 or 6 selected COSTMV[ 8] 1

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

Covenant Village

Input array: PACE

Periods are Quarterly Total Total AMJ'85 JAS'85 OND'85 JFM'86 AMJ'86 JAS'86 OND'86 JFM'87 AMJ'87 JAS'87
SALES 128 64           16 24 24    
RENTALS 134 67           27 24 16    
TOTAL 262 131           43 48 40    

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

Covenant Village

Input array: PRICE

Periods are Quarterly Total 1 2 3
SALES 45000     45000
RENTALS        

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

Covenant Village

Input array: LUTTLS

1 SALES
2 RENTALS

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

Covenant Village

Input array: COSTREF

  Total 1 2 3 4 5 6 7 8 9 10 11 12
1 139 141               -1   -1  
2 1283 143 35 1000 3         101   1  
3 1281 143 35 1000           102   1  
4 100286 144               100143   -1  
5 153 145               6 1 1  
6 154 150       6       -1   -1  
7 163 162               1   1 -1
8 319 320               1   -1 -1
9 1556 550               1005   1  
10 1604 600               1005   -1  
11 1614 610               1005   -1  
12 1624 620               1005   -1  
13 1634 630               1005   -1  
14 1804 800               1005   -1  
15 898 840 50             6 1 1  
16 1864 860               1005   -1  
17 1894 890               1005   -1  
18 31423 910 500 1           30002 12 -1 -1
19 954 930 10 1           3 12 -1 -1
20 101858 950               100910   -1 -1

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

Covenant Village

Input array: COSTS

Periods are Quarterly COA# Total Total AMJ'85 JAS'85 OND'85 JFM'86 AMJ'86 JAS'86 OND'86 JFM'87 AMJ'87 JAS'87
Land Dev. Cost 141                        
Land Planning 141                        
Street Paving 141 400000 200000       40000 40000 40000 40000 40000    
Storm Sewers 142                        
Sanitary Sewers 142                        
Water 142                        
Electricity 142                        
Landscaping & Stabilization 145 140000 70000           35000     35000  
Amenity Structures 148 120000 60000       15000 15000   15000 15000    
Offsite: Other Utilities 150                        
Offsite - Impact Fees (see 149.6) 150                        
Direct Construction Costs 143 340000 170000       70000 100000          
TOTAL   1000000 500000       125000 155000 75000 55000 55000 35000  

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

Covenant Village

Input array: GANDA

Periods are Quarterly COA# Total Total 1 2 3 4 5 6 7 8 9 10
Salaries 810 711276 355638 23358 17520 29220 33720 38220 42720 42720 42720 42720 42720
Property Plant & Equipment 180 117800 58900 28450   28450       2000      
Office Expense 820 162050 81025 10300 7725 7875 7875 7875 7875 7875 7875 7875 7875
Professional Fees 860 250000 125000 12500 12500 12500 12500 12500 12500 12500 12500 12500 12500
Other G&A 890 20000 10000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000
TOTAL   1261126 630563 75608 38745 79045 55095 59595 64095 66095 64095 64095 64095

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

Covenant Village

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 17:12)

Covenant Village

Input array: LAND

  Total Total 1 2 3
1. 750000 375000     375000

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

Covenant Village

Input array: FACTORS

  Total 1 2 3
1 2 1   1

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

Covenant Village:1313800 22685 13 (3)

Detail of Financing Sources & Interest

  Total Total AMJ'85 JAS'85 OND'85 JFM'86 AMJ'86 JAS'86 OND'86 JFM'87 AMJ'87 JAS'87
6200 Const Loan Interest                        
6201 Interest Finance A -1532090 -766045     -12167 -24468 -46217 -90220 -136816 -161784 -170018 -124355
                         
6300 Borrowing                        
6301 Finance A     75608 41391 469321 229482 1027032 1495503 1161331 249774 220192 -4969634
                         
FINANCING BALANCES                        
6201 Interest Finance A 18500623   75608 116999 574153 779167 1759982 3165265 4189780 4277770 4327944 -766045