SiteMap
Page Bottom  
Tax Credits for Low Income Housing, 11th Edition

g This presents a variation on a form developed by Joseph Guggenheim and explained in his book Tax Credits for Low Income Housing (Simon Publications, P.O.Box 229, Glen Echo, Maryland.) When completed, the form will be interactive so that you may change any number shown in green, click update, and the form will be revised for whatever changes in assumptions have been made. At present, the forms are presented with the same numbers as are presented in the book (11th edition) on pages 98-105 (minor differences are rounding errors).

New Construction - $80,000 Cost per Unit; Conventional Financing no bonus bonus
Rehabilitation - $80,000 Cost per Unit; Conventional Financing no bonus bonus
New Construction - $100,000 Cost per Unit; Conventional Financing no bonus bonus
Rehabilitation - $100,000 Cost per Unit; Conventional Financing no bonus bonus
New Construction - $50,000 Cost per Unit; Conventional Financing no bonus bonus
Rehabilitation - $80,000 Cost per Unit; Tax-exempt Financing no bonus bonus
New Construction - $100,000 Cost per Unit; Tax-exempt Financing no bonus bonus
Rehabilitation - $50,000 Cost per Unit; Tax-exempt Financing no bonus bonus

The formats shown above are what is often called in the real estate development industry a "setup". It compares development costs and financing with a "proforma" year.

A more sophisticated financial analysis is likely to include a time series projection. The following are various formats for a single time series projection for the first of the sixteen analyses shown above. These formats provide for a great deal more complexity than this data requires, but do suggest additional issues likely to be encountered as development gets underway. For a more complete presentation of the economic model which created this time series projection, see ProCash, an Economic Model for Income Properties.

viewtypeviewfile sizecomplexityhelp#comment
OutputsProject Cash Flow 18826 2204 520 
Cash Flow By Participant 10006 841 621 
Residual Values & IROR'S 6058 154 622 
Present Value By Participant By Line Item 3907 70 623 
Taxable Income 8071 640 751 
Development Cash Flow 5643 837 546 
Operations 7279 532 330 
Sources Of Financing 3206 25 555 
Debt Service Schedule 7235 532 556 
Depreciation Schedules 5817 243 730 
Tax Liability on Residual Values 5845 522 752 
Operating Accounts For Bridge/Const. Loan 7264 470 794 
Detail Of Investment Adjustment 4633 323 795 
Reconciliation Project/Distributed Cash 7925 760 796 
Basis Accounts 4328 198 793 
Detail Of Present Value 6842 496 624 
Sources Of Financing II 3216 23 557 
Development Cash Flow II 3881 47 547 
Sources Of Financing III 4299 227 558 
Development Cash Flow III 5160 623 548 
Operating Cash Flow 13441 1389 330 
Total Cash Flow By Participant 9213 809 625 
InputsSimple Inputs 4835 72 141a good example of simple inputs sufficient for a complicated project
Simple Inputs II 2479 5 142 
Alternative Inputs 10002 511 810 
OtherBaseViews 127634  951 

horizontal line
e-mail Page Top