NSP2 25Set-AsideTemplates-ex

Document Sample
NSP2 25Set-AsideTemplates-ex Powered By Docstoc
					                                              Development Pro Forma

Project Name:
Developer:
Project Address:

Total # of Units:


                                                           Funding Sources

                                                                                                         % of
                                    NSP2 Request       Source 1           Source 2           Total
             Uses                                                                                        Total

  Acquisition
  Acquisition: Land               $          -     $              -   $              -   $           -
  Acquisition: Buildings          $          -     $              -   $              -   $           -
                Total Acquisition $          -     $              -   $              -   $           -   #DIV/0!

  Site Improvement
  Demolition                        $        -     $              -   $              -   $           -
  On-site Improvements              $        -     $              -   $              -   $           -
  Off-site Improvements             $        -     $              -   $              -   $           -
       Total Site Improvements      $        -     $              -   $              -   $           -   #DIV/0!

  Construction
  Rehabilitation                    $        -     $              -   $              -   $           -
  New Construction                  $        -     $              -   $              -   $           -
  Contingency                       $        -     $              -   $              -   $           -
  Permits                           $        -     $              -   $              -   $           -
  Furnishings                       $        -     $              -   $              -   $           -
  Other                             $        -     $              -   $              -   $           -
              Total Construction    $        -     $              -   $              -   $           -   #DIV/0!

  Soft Costs
  Survey                            $        -     $              -   $              -   $           -
  Architect & Engineer              $        -     $              -   $              -   $           -
  Real Estate Attorney              $        -     $              -   $              -   $           -
  Consultant                        $        -     $              -   $              -   $           -
  Tax Opinion                       $        -     $              -   $              -   $           -
  Developer Fee                     $        -     $              -   $              -   $           -
  Market Study                      $        -     $              -   $              -   $           -
  Marketing Expense                 $        -     $              -   $              -   $           -
  Relocation                        $        -     $              -   $              -   $           -
  Application Processing Fees       $        -     $              -   $              -   $           -
  Financial Services                $        -     $              -   $              -   $           -
  Transfer Taxes/Costs              $        -     $              -   $              -   $           -
  Cost Certification                $        -     $              -   $              -   $           -
  Other                             $        -     $              -   $              -   $           -
                 Total Soft Costs   $        -     $              -   $              -   $           -   #DIV/0!

  Construction Finance
  Construction Loan Interest        $        -     $              -   $              -   $           -
  Construction Loan Fee             $        -     $              -   $              -   $           -
  Construction Origination          $        -     $              -   $              -   $           -
  Appraisal                         $        -     $              -   $              -   $           -
  Title and Recording               $        -     $              -   $              -   $           -
  Other                             $        -     $              -   $              -   $           -
    Total Construction Finance      $        -     $              -   $              -   $           -   #DIV/0!
                                            Development Pro Forma


Project Name:
Developer:
Project Address:

Total # of Units:

Permanent Finance
Permanent Loan Fee              $       -       $             -   $   -   $   -
Permanent Origination Fee       $       -       $             -   $   -   $   -
Title and Recording             $       -       $             -   $   -   $   -
Other                           $       -       $             -   $   -   $   -
     Total Permanent Finance    $       -       $             -   $   -   $   -   #DIV/0!

Other Soft Costs
Construction Insurance          $       -       $             -   $   -   $   -
Property Taxes                  $       -       $             -   $   -   $   -
Rent up Expense                 $       -       $             -   $   -   $   -
Other                           $       -       $             -   $   -   $   -
       Total Other Soft Costs   $       -       $             -   $   -   $   -   #DIV/0!

Reserves
Rent up Reserves                $       -       $             -   $   -   $   -
Operating Reserves              $       -       $             -   $   -   $   -
Other                           $       -       $             -   $   -   $   -
              Total Reserves    $       -       $             -   $   -   $   -   #DIV/0!

Development Cost                $       -       $         -       $   -   $   -   #DIV/0!

             Total Cost Per Unit                $             -
          Total NSP2 Cost Per Unit              $             -
     Total NSP2 % of Development Cost               #DIV/0!
                                                                           Operating Pro Forma




Project Name:
Developer:
Project Address:

Total # of Units:



                                           Units by AMI        Monthly Rent by AMI               Utility Allowance by AMI       Annual Rent by AMI
Income:
                                           0-30% 31-50%       0-30%            31-50%            0-30%             31-50%       0-30%           31-50%
Unit Type
Efficiency                                                                                                                  $           -   $        -
One Bedroom                                                                                                                 $           -   $        -
Two Bedroom                                                                                                                 $           -   $        -
Three Bedroom                                                                                                               $           -   $        -
Four Bedroom                                                                                                                $           -   $        -
Five Bedroom                                                                                                                $           -   $        -
                     Total Units by AMI     0         0
                     Total Project Units        0

Gross Rent                                                                 $                              -
Less:
                                Vacancy                                            0.0% $                 -
                                Bad Debt                                           0.0% $                 -
                                                                Gross Effective Income: $                 -

Expenses:
Administrative                                                                                   Annual
Advertising & Marketing                                                                  $                -
Mgmt Fee (% of collections)                                                        0.0% $                 -
Administrative                                                                           $                -
Legal                                                                                    $                -
Accounting                                                                               $                -
Office Supplies                                                                          $                -
Credit Checks                                                                            $                -
Leasing Fees                                                                             $                -
Other                                                                                    $                -
                                                                   Total Administrative: $                -
Payroll
Administrative Payroll                                                                    $               -
Maintenance Payroll                                                                       $               -
Fringe                                                                            15.0% $                 -
Payroll Taxes                                                                     7.65% $                 -
                                                                           Total Payroll: $               -
Maintenance
Decorating (unit make ready)                                                             $                -
Repairs                                                                                  $                -
Security                                                                                 $                -
Grounds (landscaping, snow removal)                                                      $                -
Building supplies                                                                        $                -
Service contracts (HVAC)                                                                 $                -
Other                                                                                    $                -
                                                                      Total Maintenance: $                -
Operating
Fuel (heating & hot water)                                                               $                -
Electric                                                                                 $                -
Water/Sewer                                                                              $                -
Trash removal                                                                            $                -
Janitorial                                                                               $                -
Exterminating                                                                            $                -
Telephone                                                                                $                -
Other                                                                                    $                -
                                                                  Total Operating Costs: $                -
Taxes & Insurance:
Real Estate Taxes                                                                       $                 -
Insurance                                                                               $                 -
Other Taxes, Licenses, Fees                                                             $                 -
                                                               Total Taxes & Insurance: $                 -
                                                    Total Annual Operating Expenses: $                    -



             Net Operating Income (NOI) Before Reserves & Debt Service: $                                 -
                                          Operating Pro Forma




Reserves:                                     Per Unit          Annual
Replacement Reserve                       $          -   $               -
Operating Reserve                         $          -   $               -
Cash Flow Before Debt Service:                           $               -
Debt Service                                                 #DIV/0!
Cash Flow After Debt Service                                 #DIV/0!


Supportable Debt Service Calculation:
Required Debt Service Coverage (Ratio):                                       0
Loan Amortization Period (in years)                                           0
Interest Rate                                                                0%



Supportable Debt on Terms Above:                             #DIV/0!
                   Operating Pro Forma




    Total Annual
       Rent

$             -
$             -
$             -
$             -
$             -
$             -
Project Name:                    0                  Project Address:                                0
Income Adjuster:         0.00%                      Expense Adjuster:                   0.00%


Income:                                  Year 1         Year 2          Year 3         Year 4               Year 5         Year 6         Year 7         Year 8         Year 9         Year 10
Gross Effective Income               $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -

Expenses:
Administrative                       $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -
Payroll                              $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -
Maintenance                          $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -
Operating                            $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -
Taxes & Insurance                    $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -
Total Expense:                       $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -

NOI (w/o Res & Debt Svc)             $         -    $         -    $          -    $         -          $         -    $         -    $         -    $         -    $         -    $         -

Replacement & Op Reserves            $          -   $          -   $           -   $          -         $          -   $          -   $          -   $          -   $          -   $          -
Debt Service                             #DIV/0!        #DIV/0!         #DIV/0!        #DIV/0!              #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!

Cashflow After Debt Svc:                 #DIV/0!        #DIV/0!         #DIV/0!        #DIV/0!              #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!


Income:                                  Year 11        Year 12         Year 13        Year 14              Year 15        Year 16        Year 17        Year 18        Year 19        Year 20
Gross Effective Income               $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -

Expenses:
Administrative                       $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -
Payroll                              $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -
Maintenance                          $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -
Operating                            $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -
Taxes & Insurance                    $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -
Total Expense:                       $          -   $          -   $           -   $            -       $          -   $          -   $          -   $          -   $          -   $          -


NOI (w/o Res & Debt Svc)             $         -    $         -    $          -    $         -          $         -    $         -    $         -    $         -    $         -    $         -

Replacement & Op Reserves            $          -   $          -   $           -   $          -         $          -   $          -   $          -   $          -   $          -   $          -
Debt Service                             #DIV/0!        #DIV/0!         #DIV/0!        #DIV/0!              #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!

Cashflow After Debt Svc:                 #DIV/0!        #DIV/0!         #DIV/0!        #DIV/0!              #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
                                                                         30-Year Cash Flow Projection



Income:                         Year 21        Year 22        Year 23        Year 24        Year 25         Year 26        Year 27        Year 28        Year 29        Year 30
Gross Effective Income      $          -   $          -   $          -   $          -   $          -    $          -   $          -   $          -   $          -   $          -

Expenses:
Administrative              $          -   $          -   $          -   $          -   $          -    $          -   $          -   $          -   $          -   $          -
Payroll                     $          -   $          -   $          -   $          -   $          -    $          -   $          -   $          -   $          -   $          -
Maintenance                 $          -   $          -   $          -   $          -   $          -    $          -   $          -   $          -   $          -   $          -
Operating                   $          -   $          -   $          -   $          -   $          -    $          -   $          -   $          -   $          -   $          -
Taxes & Insurance           $          -   $          -   $          -   $          -   $          -    $          -   $          -   $          -   $          -   $          -
Total Expense:              $          -   $          -   $          -   $          -   $          -    $          -   $          -   $          -   $          -   $          -


NOI (w/o Res & Debt Svc)    $         -    $         -    $         -    $         -    $         -     $         -    $         -    $         -    $         -    $         -

Replacement & Op Reserves   $          -   $          -   $          -   $          -   $          -    $          -   $          -   $          -   $          -   $          -
Debt Service                    #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!         #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!

Cashflow After Debt Svc:        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!         #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:5/18/2012
language:English
pages:7
fanzhongqing fanzhongqing http://
About