Home   E-Mail  HomePage    index    Format420    Format418    Format424    Format426    Format421    Format409    Format410    Format411    Format401    Format423    Format413    Format414    Format412    Format404    Format425    Format429    Format402    Format422    Format428    Format405    Format406    Format407    Format408    Format415    Format416    Format417    AVI    MV    ALTI    UNITMIX   

Covenant Village:FAHP & LIHTC Test:Trial 6: Test All Form Inputs: Projection

Schedule D: Present Value By Participant By Line Item

discount rate = 0.12

Developer  
Land ( 1 132) -312500
Start-up Oper. Losses (exp.) ( 1 167) -184432
Working Capital ( 1 172) -8171
Operating Reserve ( 1 173) -190428
Land Residual ( 1 195) 179871
Equity Residual ( 1 196) 3918
Investment Adj. ( 1 320) 51136
Investment Adj. ( 1 320) 57093
Ground Rent ( 1 631) 127704
Net Cash Flow (NCF) ( 1 699) 1362
Subtotal: Developer -274447
   
Lender  
Financing Fees ( 2 158) 56250
Financing Fees ( 2 158) 31605
Orig.Mtge(s) ( 2 240) -1053507
Mtge Interest ( 2 660) 611840
Mtge Amortization ( 2 670) 120264
Mtge Amortization ( 2 670) 153891
Subtotal: Lender -79657
   
Investor  
Equity Residual ( 3 196) 387919
Investment ( 3 310) -1630262
Net Cash Flow (NCF) ( 3 699) 134867
Income Taxes (Const.) ( 3 820) 1731
Income Taxes (Annual) ( 3 850) 218200
Inc.Taxes:Equity Residual ( 3 880) -73612
Tax Credit ( 3 890) 1731303
Tax Credit ( 3 890) -66088
Subtotal: Investor 704058
   
Other  
Const.Interest ( 4 155) 359507
Const.Loan ( 4 220) -360561
Subtotal: Other -1054
   
Public  
Income Taxes (Const.) ( 5 820) -1731
Income Taxes (Annual) ( 5 850) -218200
Inc.Taxes:Equity Residual ( 5 880) 73612
Tax Credit ( 5 890) -1731303
Tax Credit ( 5 890) 66088
Subtotal: Public -1811534
   
Secondary Lender  
Orig.Mtge(s) ( 6 240) -1594388
Mtge Interest ( 6 660) 266991
Mtge Amortization ( 6 670) 334378
Mtge Amortization ( 6 670) 173756
Subtotal: Secondary Lender -819263
   
Underwriter/Syndctr  
Financing Fees ( 7 158) 125399
Credit Enhancement ( 7 641) 68824
Subtotal: Underwriter/Syndctr 194222
   
Total -2087674



 Home   E-Mail  home at CD root