Excel Property Proforma

Document Sample
Excel Property Proforma Powered By Docstoc
					Project #          0
                                                         FEDERAL HOME LOAN BANK OF DALLAS
                                                                 AFFORDABLE HOUSING PROGRAM
                                                                  RENTAL PROJECTS WORKSHEET
                                                                                                              HUD AREA MEDIAN INCOMES (AMI)
1. Please enter the annual Median Family Income (MFI) for the project area:                        $0

2. In the spaces below, please enter the MFI adjusted for family size, based on guidelines published by the Federal Housing Finance Board. The use
   of median incomes other than those pulished by the Finance Board must be submitted with the application package and must be approved by the Bank.

                                         Family size                            Family size
                                             1                  $0                  5              $0
                                             2                  $0                  6              $0
                                             3                  $0                  7              $0
                                             4                  $0                  8              $0

                                                               Percent          MFI Adjusted     Tenant            Rent             Total Rent      Proposed Rent as %
    Number of           Bedrooms           Persons           MFI Target        for Family Size    Rent            Subsidy      (Includes Subsidy)   of Targeted Income
      Units              Per Unit          Per Unit               (1)                              (2)              (3)                (4)                  (5)
         0                  0                 0                   0%                 $0           $0.00            $0.00              $0.00               #DIV/0!
         0                  0                 0                   0%                 $0           $0.00            $0.00              $0.00               #DIV/0!
         0                  0                 0                   0%                 $0           $0.00            $0.00              $0.00               #DIV/0!
         0                  0                 0                   0%                 $0           $0.00            $0.00              $0.00               #DIV/0!
         0                  0                 0                   0%                 $0           $0.00            $0.00              $0.00               #DIV/0!
         0                  0                 0                   0%                 $0           $0.00            $0.00              $0.00               #DIV/0!
         0                  0                 0                   0%                 $0           $0.00            $0.00              $0.00               #DIV/0!
         0                  0                 0                   0%                 $0           $0.00            $0.00              $0.00               #DIV/0!
         0                  0                 0                   0%                 $0           $0.00            $0.00              $0.00               #DIV/0!
         0                  0                 0                   0%                 $0           $0.00            $0.00              $0.00               #DIV/0!
         0                  0                 0                   0%                 $0           $0.00            $0.00              $0.00               #DIV/0!
         0                  0                 0                   0%                 $0           $0.00            $0.00              $0.00               #DIV/0!
         0
(1) Targeting should agree with that provided in application (50, 60, 80, 100)
(2) Portion the Tenant Pays - Rents should not include utilities.
(3) Any subsidy paid in combination with tenant portion to equal total rent paid
(4) Total Rent (Tenant plus Subsidy)
(5) Housing ratio will be calculated based on the tenant portion only. (Not to exceed 30%)


                                                                              Rental Work Sheet
       CONFIDENTIAL                                    C:\Docstoc\Working\pdf\8390d239-30fa-480c-a4d1-548d07021f5f.xls                                 Page 1 of 4
                        A                B               C             D           E                 F           G              H               I              J
               1                                                           Fed eral Ho m e L o an B an k o f Dallas
               2                                                   Affo rd ab le Ho u sin g Pro g ram 15 year Pro fo rm a
                3
                4              Project name:                                                                   Project #                            Date 02/03/11
                5   Pro Forma Income/Expense Statement
                6
                7
                8                                                                Yr. 1                          Yr. 2          Yr. 3          Yr. 4          Yr. 5
                9   Assumptions:                                  No. Units      Rent          Gross Annual
               10                                                     0           $0                     $0
               11   Vacancy Rates                      0.00%          0           $0                     $0
               12   Rent Increase Rates                0.00%          0           $0                     $0
               13   Expense Growth Rates               0.00%          0           $0                     $0
               14   Total Number of Units                0            0           $0                     $0
               15                                                     0           $0                     $0
               16                                                     0           $0                     $0
               17                                                     0           $0                     $0
               18                                                     0           $0                     $0
               19                                                     0           $0                     $0
               20                                                     0           $0                     $0
               21   Income:                                           0           $0                     $0
               22            Rental Income                                                $0                             $0             $0             $0             $0
               23            Vacancy                                                      $0                             $0             $0             $0             $0
               24            Other Income               (Secondary Income)                $0                             $0             $0             $0             $0
               25   Total Income:                                                         $0                             $0             $0             $0             $0
               26
               27   Expenses                                       % of EGI                      $ per Unit
               28             Property Insurance                   #DIV/0!               $0       #DIV/0!               $0             $0             $0              $0
               29         1.) Property Taxes                       #DIV/0!               $0       #DIV/0!               $0             $0             $0              $0
               30         2.) Utilities (elec/gas/wtr/sewer/trash) #DIV/0!               $0       #DIV/0!               $0             $0             $0              $0
               31             Advertising & Marketing              #DIV/0!               $0       #DIV/0!               $0             $0             $0              $0
               32             Repairs & Maintenance                #DIV/0!               $0       #DIV/0!               $0             $0             $0              $0
               33             Management Fee                       #DIV/0!               $0       #DIV/0!               $0             $0             $0              $0
               34             Groundskeeping                       #DIV/0!               $0       #DIV/0!               $0             $0             $0              $0
               35             Administrative                       #DIV/0!               $0       #DIV/0!               $0             $0             $0              $0
               36             Professional                         #DIV/0!               $0       #DIV/0!               $0             $0             $0              $0
               37             Tenant Expense                       #DIV/0!               $0       #DIV/0!               $0             $0             $0              $0
               38             Other                                #DIV/0!               $0       #DIV/0!               $0             $0             $0              $0
               39   Operating Expenses                             #DIV/0!               $0       #DIV/0!               $0             $0             $0              $0
               40        2.) Utilities: Do not include tenant paid utilities
               41   Reserves
               42             Replacement                                                 $0         #DIV/0!             $0             $0             $0             $0
               43   Total Reserves                                                        $0         #DIV/0!             $0             $0             $0             $0
               44
               45   Total Expenses                                                       $0          #DIV/0!            $0             $0             $0              $0
               46
               47   Net Operating Income                                                 $0          #DIV/0!            $0             $0             $0              $0
               48
               49   Debt Service
               50            1st Mortgage (Principal)                                   $0
               51            Rate                                                  0.00%
               52            Term (Years)                                                0
               53            Monthly Payment                                    #DIV/0!                        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
               54            Annual Payment                                     #DIV/0!                        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
               55            2nd Mortgage                                               $0
               56            Rate                                                  0.00%
               57            Term (Years)                                                0
               58            Monthly Payment                                    #DIV/0!                        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
               59            Annual Payment                                     #DIV/0!                        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
               60            Deferred Developer Fee
               61   Total Debt Service                                          #DIV/0!                        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
               62
               63   Cash Flow                                                   #DIV/0!                        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!
               64   3.) DSR = [Net Operating Income / Total Debt Service]
               65   3.) Debt Service Ratio                                      #DIV/0!                        #DIV/0!        #DIV/0!        #DIV/0!        #DIV/0!




                                                                                   15 Year Feasibility
CONFIDENTIAL                                               C:\Docstoc\Working\pdf\8390d239-30fa-480c-a4d1-548d07021f5f.xls                                                 Page 2 of 4
                      K                 L             M              N             O             P             Q              R               S                 T
               1
               2
               3
               4                  Project name: 0                                                                                          Project #      0
               5
               6
               7
               8                                                      Pro Forma Income/Expense Statement
               9                                                              Years 6 through 15
               10
               11
               12
               13
               14
               15
               16
               17
               18
               19
               20    Yr. 6             Yr. 7         Yr. 8          Yr. 9        Yr. 10        Yr. 11        Yr. 12         Yr. 13          Yr. 14            Yr. 15
               21
               22            $0                $0             $0            $0            $0            $0             $0             $0             $0                $0
               23            $0                $0             $0            $0            $0            $0             $0             $0             $0                $0
               24            $0                $0             $0            $0            $0            $0             $0             $0             $0                $0
               25            $0                $0             $0            $0            $0            $0             $0             $0             $0                $0
               26
               27
               28            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               29            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               30            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               31            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               32            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               33            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               34            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               35            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               36            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               37            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               38            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               39            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               40
               41
               42            $0                $0             $0            $0            $0            $0             $0             $0             $0                $0
               43            $0                $0             $0            $0            $0            $0             $0             $0             $0                $0
               44
               45            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               46
               47            $0                $0            $0             $0         $0            $0            $0             $0              $0                $0
               48
               49
               50
               51
               52
               53   #DIV/0!          #DIV/0!        #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!            #DIV/0!
               54   #DIV/0!          #DIV/0!        #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!            #DIV/0!
               55
               56
               57
               58   #DIV/0!          #DIV/0!        #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!            #DIV/0!
               59   #DIV/0!          #DIV/0!        #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!            #DIV/0!
               60
               61   #DIV/0!          #DIV/0!        #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!            #DIV/0!
               62
               63   #DIV/0!          #DIV/0!        #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!            #DIV/0!
               64
               65   #DIV/0!          #DIV/0!        #DIV/0!        #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!        #DIV/0!        #DIV/0!            #DIV/0!




                                                                            15 Year Feasibility
CONFIDENTIAL                                        C:\Docstoc\Working\pdf\8390d239-30fa-480c-a4d1-548d07021f5f.xls                                                         Page 3 of 4
                    U   V   W        X         Y        Z        AA          AB          AC       AD   AE   AF
               1
               2
                3
                4
                5
                6
                7
                8
                9
               10
               11
               12
               13
               14
               15
               16
               17
               18
               19
               20
               21
               22
               23
               24
               25
               26
               27
               28
               29
               30
               31
               32
               33
               34
               35
               36
               37
               38
               39
               40
               41
               42
               43
               44
               45
               46
               47
               48
               49
               50
               51
               52
               53
               54
               55
               56
               57
               58
               59
               60
               61
               62
               63
               64
               65




                                                        15 Year Feasibility
CONFIDENTIAL                    C:\Docstoc\Working\pdf\8390d239-30fa-480c-a4d1-548d07021f5f.xls                  Page 4 of 4

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:19
posted:2/3/2011
language:English
pages:4
Description: Excel Property Proforma document sample