Cost Cert EXCEL Forms by Tv5ZYr9

VIEWS: 21 PAGES: 9

									                                                                                                                      EXHIBIT 9A. PLACEMENT IN SERVICE

                                       DEVELOPMENT NAME: 0                                                                                                                           0                                     FILE NUMBER: 0

                                                Placed in Service Date                          Applicable Fraction                             Applicable Percentage                                          Eligible Basis                            Requested Tax Credits
       Credit
       Period                                                Rehab/New      Net Rentable                                   Weighted                   Acquisiiton        Rehab/        Rehab/New                             Rehab/                             Rehab/
      Election     Bldg. #        BIN #      Acquisition     Construction   Area (NRA)     Based on Units Based on NRA     Average    Acquisition   Weighted Average   New Constr.   Weighted Average   Acquisition        New Constr.      Acquisition       New Constr.         Total
                       1         00-00001                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                         $           -        $       -       $           -
                       2         00-00002                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                       3         00-00003                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                       4         00-00004                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                       5         00-00005                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                       6         00-00006                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                       7         00-00007                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                       8         00-00008                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                       9         00-00009                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      10         00-00010                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      11         00-00011                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      12         00-00012                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      13         00-00013                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      14         00-00014                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      15         00-00015                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      16         00-00016                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      17         00-00017                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      18         00-00018                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      19         00-00019                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      20         00-00020                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      21         00-00021                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      22         00-00022                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      23         00-00023                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      24         00-00024                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      25         00-00025                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      26         00-00026                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      27         00-00027                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      28         00-00028                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      29         00-00029                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      30         00-00030                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      31         00-00031                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      32         00-00032                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      33         00-00033                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      34         00-00034                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                      35         00-00035                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                     250         00-00250                                                                                  #DIV/0!                     #DIV/0!                           #DIV/0!                                                          -               -                   -
                                 TOTAL                                           0                                         #DIV/0!                     #DIV/0!                           #DIV/0!                      $0                 $          -         $       -       $           -




Cost Certification (Effective March 2011)                                                                                                                                                                                                                                   Exhibit 9A
Real Estate Analysis, TDHCA                                                                                                                                                                                                                                       Placement in Service
                                       EXHIBIT 9B: INDIVIDUAL BUILDING DESCRIPTION

             DEVELOPMENT NAME:          0                                                                     FILE NUMBER:      0

The form has been constructed to allow information for two different building types to be presented on a single page. If the development
consists of more than two building types, the worksheet may be copied to a new worksheet multiple times. Right click with the mouse on
the worksheet tab. Select “Move or Copy” and check “Create a copy” at the bottom of the dialog box.


                   Building Type                                                         Building Type
                                       Building Numbers                                                     Building Numbers




                                    Housing Tax Credit Units                                             Housing Tax Credit Units
                       # of Units           Sq. Ft/Unit    Total Sq. Ft.                    # of Units          Sq. Ft/Unit         Total Sq. Ft.
            A.                                                   0                A.                                                      0
            B.                                                   0                B.                                                      0
            C.                                                   0                C.                                                      0
            D.                                                   0                D.                                                      0
            E.                                                   0                E.                                                      0
            F.                                                   0                F.                                                      0
            G.                                                   0                G.                                                      0
            H.                                                   0                H.                                                      0
            I.                                                   0                I.                                                      0
            J.                                                   0                J.                                                      0
        SUBTOTAL           0                                     0           SUBTOTAL           0                                         0

                                       Market Rate Units                                                    Market Rate Units
            A.                                                  0                 A.                                                     0
            B.                                                  0                 B.                                                     0
            C.                                                  0                 C.                                                     0
            D.                                                  0                 D.                                                     0
            E.                                                  0                 E.                                                     0
            F.                                                  0                 F.                                                     0
            G.                                                  0                 G.                                                     0
            H.                                                  0                 H.                                                     0
            I.                                                  0                 I.                                                     0
            J.                                                  0                 J.                                                     0
        SUBTOTAL           0                                    0            SUBTOTAL           0                                        0

                                         Building Total                                                       Building Total
                           0                                    0                               0                                        0


                               Building Applicable Fraction                                          Building Applicable Fraction
                   Unit Fraction                           #DIV/0!                       Unit Fraction                           #DIV/0!
                   Square Footage Fraction                 #DIV/0!                       Square Footage Fraction                 #DIV/0!
                   Applicable Fraction                     #DIV/0!                       Applicable Fraction                     #DIV/0!




Cost Certification ( Effective March 2011)                                                                                        Exhibit 9B
Real Estate Analysis, TDHCA                                                                                  Individual Building Description
                                         EXHIBIT 10C: TOTAL DEVELOPMENT COST SCHEDULE
                   DEVELOPMENT NAME:                 0                                                                    FILE NUMBER:            0

                                                             DEVELOPMENT COST SUMMARY                               Taxpayer Identification Number (TIN)
                                                                                   Eligible Basis                and % of cost if item involves multiple payees
                                                         Total Cost
                                                                           Acquisition        New/Rehab.              [Texas Statutes, Title 10, Chapter 2306.184]

 ACQUISITION
 Site acquisition cost
 Existing structures acquisition cost
 Closing costs & acq. legal fees
 Other:
 Subtotal Acquisition Cost                                            $0                 $0                $0
 DIRECT CONSTRUCTION COSTS
 Offsite Work
 Demolition
 Site Work
 Residential Buildings                                                                                -
 Accessory Buildings

 Subtotal Direct Construction Costs                                   $0                 $0                $0
 OTHER CONSTRUCTION COSTS
 General requirements (<6%)                #DIV/0!
 Contractor overhead (<2%)                 #DIV/0!
 Contractor profit (<6%)                   #DIV/0!
 Subtotal Other Const. Costs                                          $0                 $0                $0
 INDIRECT CONSTRUCTION COSTS
 Architectural - Design fees
 Architectural - Supervision fees
 Engineering fees
 Real estate attorney/other legal fees
 Accounting fees
 Impact Fees
 Building permits & related costs
 Appraisal
 Market analysis
 Environmental assessment
 Soils report
 Survey
 Marketing
 Course of construction insurance
 Hazard & liability insurance
 Real property taxes
 Personal property taxes
 Tenant relocation expenses
 Other:
 Subtotal Indirect Const. Cost                                        $0                 $0                $0




Cost Certification (Effective March 2011)                                                                                           Exhibit 10C
Real Estate Analysis, TDHCA                                                                                     Total Development Cost Schedule
                                                                                                                       TDHCA File #: 0


                                                   DEVELOPMENT COST SUMMARY                                   Taxpayer Identification Number (TIN)
                                                                         Eligible Basis                    and % of cost if item involves multiple payees
                                               Total Cost
                                                                 Acquisition        New/Rehab.          [Required by Texas Statutes, Title 10, Chapter 2306.184]
 DEVELOPER FEES
 Housing consultant fees
 General & administrative
 Profit or fee
 Subtotal Developer's Fees (<15%)    #DIV/0!                $0                 $0                $0
 FINANCING:
 CONSTRUCTION LOAN(S)
 Interest
 Loan origination fees
 Title & recording fees
 Closing costs & legal fees
 Inspection fees
 Credit Report
 Discount Points
 Other:
 PERMANENT LOAN(S)
 Loan origination fees
 Mortgage brokerage fee
 Title & recording fees
 Closing costs & legal
 Bond premium
 Credit report
 Discount points
 Credit enhancement fees
 Prepaid MIP
 Other:
 BRIDGE LOAN(S)
 Interest
 Loan origination fees
 Title & recording fees
 Closing costs & legal fees
 Other:
 OTHER FINANCING COSTS
 Tax credit fees
 Tax credit application fee                                                                           TDHCA TIN: 74-2610542

 Payment bonds
 Performance bonds
 Cost of underwriting & issuance
 Syndication organizational cost
 Tax opinion
 Other:
 Subtotal Financing Cost                                    $0                 $0                $0




Cost Certification (Effective March 2011)                                                                                    Exhibit 10C
Real Estate Analysis, TDHCA                                                                              Total Development Cost Schedule
                                                                                                                                     TDHCA File #: 0


                                                                   DEVELOPMENT COST SUMMARY                                Taxpayer Identification Number (TIN)
                                                                                         Eligible Basis                 and % of cost if item involves multiple payees
                                                               Total Cost
                                                                                 Acquisition        New/Rehab.        [Required by Texas Statutes, Title 10, Chapter 2306.184]
 RESERVES
 Rent-up
 Operating
 Replacement
 Escrows
 Subtotal Reserves                                                          $0                 $0                $0
 TOTAL DEVELOPMENT COSTS                                                    $0                 $0                $0
 - Commercial Space Costs
 TOTAL RESIDENTIAL COSTS                                                    $0

 Deduct From Basis:
 Fed. grant proceeds used to finance costs in eligible basis
 Fed. B.M.R. loans used to finance costs in eligible basis
 Non-qualified non-recourse financing
 Non-qualified portion of higher quality units
 Historic Credits (residential portion only)
 Total Eligible Basis                                                                          $0                $0
 High Cost Area Adjustment (100% or 130%)
 Total Adjusted Basis                                                                          $0                $0
 Applicable Fraction                                                                                      #DIV/0!
 Total Qualified Basis                                          #DIV/0!                        0      #DIV/0!
 Applicable Percentage                                                                   0.00%            #DIV/0!
 Owner's Requested Credits                                      #DIV/0!                        $0     #DIV/0!




Cost Certification (Effective March 2011)                                                                                                 Exhibit 10C
Real Estate Analysis, TDHCA                                                                                           Total Development Cost Schedule
                                                      EXHIBIT 11A. RENT SCHEDULE
         DEVELOPMENT NAME:                                                                               FILE NUMBER:

    Type of Unit designation should be one or more of the following based on the unit's rent restrictions:
      Tax Credit: (TC30%), (TC40%), (TC50%), (TC60%)                           501(c)(3) Mortgage Revenue Bond: (MRB)
      HOME: High (HH) or Low (LH)                                              Other: (OT) describe any "Other" restrictions on an attached sheet
      Housing Trust Fund: (HTF30%), (HTF60%), (HTF65%)
    For units funded under more than one program, the "Income Level Served" should be the most restrictive - for example a LH and TC50% would
    be “50%”.
    The rent and utility limits available at the time the Cost Certification Packet is submitted should be used to complete this form. Gross Rent
    cannot exceed the HUD maximum rent limits.

                                                        Unit Size                           Tenant
                                                                     Total Net
                     Income Level # of    # of    # of    (Net                               Paid                            Tenant Paid      Total Monthly
      Type of Unit                                                  Rentable Sq. Gross Rent
                        Served    Units Bedrooms Baths Rentable Sq.                          Utility                          Rent/ Unit          Rent
                                                                        Ft.
                                                           Ft.)                             Allow.
                                     (A)                                 (B)          (A) x (B)        (C)          (D)     (C) - (D) = (E)     (A) x (E)
                                                                                        0                                                0                  -
                                                                                        0                                                0                  -
                                                                                        0                                                0                  -
                                                                                        0                                                0                  -
                                                                                        0                                                0                  -
                                                                                        0                                                0                  -
                                                                                        0                                                0                  -
                                                                                        0                                                0                  -
                                                                                        0                                                0                  -
                                                                                        0                                                0                  -
                                                                                        0                                                0                  -
                                                                                        0                                                0                  -
                                                                                        0                                                0                  -
    Rent Restricted Total                  0                                            0                                                                   -
    Market Rate                                                                         0                                                                   -
    Market Rate                                                                         0                                                                   -
    Market Rate                                                                         0                                                                   -
    Market Rate                                                                         0                                                                   -
    Market Rate                                                                         0                                                                   -
    Market Rate                                                                         0                                                                   -
    Market Rate Total                      0                                            0                                                                   -
    Employee/Owner Occupied*                                                            0                                                                   -
    Total Units                            0                                            0                                                                   -
    + Non Rental Income Source #1                         per unit/month for:      describe source here                                                     -
    + Non Rental Income Source #2                         per unit/month for:      describe source here                                                     -
    + Non Rental Income Source #3                         per unit/month for:      describe source here                                                     -
    = POTENTIAL GROSS MONTHLY INCOME                                                                                                                        -
    - Provision for Vacancy & Collection Loss                                              % of Potential Gross Income:             7.50%                   -
    - Rental Concessions
    = EFFECTIVE GROSS MONTHLY INCOME                                                                                                                        -
    x 12 = EFFECTIVE GROSS ANNUAL INCOME                                                                                                                    -
                                               * Only enter Employee/Owner Occupied Units if not included in rent restricted or market rate units shown above.




Cost Certification (Effective March 2011)                                                                                              Exhibit 11A
Real Estate Analysis, TDHCA                                                                                                          Rent Schedule
                                                  EXHIBIT 11B. UTILITY ALLOWANCE
             DEVELOPMENT NAME: 0                                                                       FILE NUMBER: 0

Owner must attach this form to the Utility Allowance documentation used to calculate the net rent in Exhibit 11A. Rent Schedule. This exhibit must clearly
indicate which utility costs are included in the net rent estimate.

NOTE:
  If more than one entity (Sec. 8 administrator, public housing authority) is responsible for setting the utility allowance(s) in the area of the development
  location, then the selected utility allowance must be the one which most closely reflects the actual expenses.
  If an independent utility cost evaluation is conducted it must include confirming documentation from all the relevant utility providers.
  If other reductions to the tenant rent is required such as the cost of flood insurance for the tenant's contents, documentation for these reductions to
  gross rent should also be attached.

                                          Energy                                                                                                   Effective
Utility(1)                               Source (2)        Source of Utility Allowance                                                               Date
     Heating
     Cooling
     Water Heater
     Cooking
     Water
     Sewer
     Trash
     General Electricity

                           Other (Describe)




  (1) Check the box if the TENANT will have to pay for this utility directly or will have to pay an extra fee for the appliances listed.
  (2) Indicate the type of energy source used where applicable as follows: N= Natural Gas, P= Propane, E= Electric, L= Oil, O= Other




Cost Certification (Effective March 2011)                                                                                                       Exhibit 11B
Real Estate Analysis, TDHCA                                                                                                               Utility Allowance
                                  EXHIBIT 11C. ANNUAL OPERATING EXPENSES
                  DEVELOPMENT NAME: 0                                                         FILE NUMBER:     0

             Advertising                                                             $
             Legal fees                                                              $
             Accounting                                                              $
             Leased equipment                                                        $
             Postage & office supplies                                               $
             Telephone                                                               $
             Other                 Describe:                                         $
             Total General & Administrative Expenses:                                                          $              -
   Management Fee:                                      Percent of Effective Gross Income:       #DIV/0!
   Payroll, Payroll Tax & Employee Benefits
             Management                                                              $
             Maintenance                                                             $
             Other                 Describe:                                         $
   Total Payroll, Payroll Tax & Employee Benefits:                                                             $              -
   Repairs & Maintenance
             Elevator                                                                $
             Exterminating                                                           $
             Grounds                                                                 $
             Repairs and make-ready                                                  $
             Supplies                                                                $
             Pool                                                                    $
             Other                 Describe:                                         $
   Total Repairs & Maintenance:                                                                                $              -
   Utilities (Enter development owner expense)
             Electric                                                                $
             Natural gas                                                             $
             Garbage/trash                                                           $
             Water & sewer                                                           $
             Other:                Describe:                                         $
   Total Utilities:                                                                                            $              -
   Annual Property Insurance:                            Rate per net rentable square foot:      #DIV/0!
   Property Taxes:
             Annual Property Taxes:                                                  $
             Payments in Lieu of Taxes:                                              $
             Other Taxes:          Describe:                                         $
   Total Property Taxes:                                                                                       $              -
   Reserve for Replacements:                                   Reserves per unit per year:       #DIV/0!
   Other Expenses
             Cable TV                                                                $
             Supportive service contract fees                                        $
             Compliance fees                                                         $
             Security                                                                $
             Other                 Describe:                                         $
             Total Other Expenses:                                                                             $              -
   TOTAL ANNUAL EXPENSES                                                 Expense per unit:       #DIV/0!       $              -
   NET OPERATING INCOME (before debt service)                                                                  $              -
   ANNUAL DEBT SERVICE                                               Debt Coverage Ratio:        #DIV/0!
   NET CASH FLOW                                                                                               $              -

Cost Certification (Effective March 2011)                                                                                 Exhibit 11C
Real Estate Analysis, TDHCA                                                                                Annual Operating Expenses
                                                                                      EXHIBIT 11D. 30-YEAR PROFORMA

       DEVELOPMENT NAME:                                                                                                                                       FILE NUMBER:

The proforma should be based on the operating income and expense information for the base year (first year of stabilized occupancy using today’s best estimates of rental income and expenses), and debt service. The
Department currently considers an annual growth rate of 3% for income and 4% for expenses to be reasonably conservative estimates. Written explanation for any deviations from these growth rates or for assumptions other
than straight-line growth made during the proforma period should be attached to this exhibit.


INCOME                              2%     Annual Increase   LEASE-UP       YEAR 1      YEAR 2         YEAR 3         YEAR 4         YEAR 5        YEAR 10        YEAR 15        YEAR 20        YEAR 25        YEAR 30

POTENTIAL GROSS ANNUAL RENTAL INCOME
Secondary Income
POTENTIAL GROSS ANNUAL INCOME
Provision for Vacancy & Collection Loss         7.50%
Rental Conessions
EFFECTIVE GROSS ANNUAL INCOME
EXPENSES                            3%     Annual Increase
General & Administrative Expenses                                       $         -
Management Fee
Payroll, Payroll Tax & Employee Benefits
Repairs & Maintenance
Electric & Gas Utilities
Water, Sewer & Trash Utilities
Annual Property Insurance Premiums
Property Tax
Reserve for Replacements
Other Expenses:
TOTAL ANNUAL EXPENSES
NET OPERATING INCOME
DEBT SERVICE
First Deed of Trust Annual Loan Payment
Second Deed of Trust Annual Loan Payment
Third Deed of Trust Annual Loan Payment
Other Annual Required Payment:
NET CASH FLOW
Debt Coverage Ratio                                          #DIV/0!        #DIV/0!     #DIV/0!        #DIV/0!        #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!




               Cost Certification (Effective March 2011)                                                                                                                                        Exhibit 11D
               Real Estate Analysis, TDHCA                                                                                                                                                 30-Year Proforma

								
To top