Agency Profit Loss Projection - Excel by gpz80489

VIEWS: 33 PAGES: 2

Agency Profit Loss Projection document sample

More Info
									                            VERMONT HOUSING FINANCE AGENCY
                                  ANNUAL OPERATING BUDGET PROJECTION
                                   For the Year Ending      , 20  .


PROJECT NAME                             LOCATION                                # OF UNITS



A. OPERATING INCOME                          TOTAL YEAR
1. GROSS RENT POTENTIAL                        BUDGET                        For VHFA Use Only
   a. Tenant Rent Contribution
   b. HAP Payments                                                 VT HOUSING FINANCE AGENCY
   c. Total Rent Potential               $                -                APPROVED
 2. OTHER INCOME
  a. Commercial Rent                                           DATE:                  INITIALS:
 b. Interest
  c. Laundry
  d. Other                                                             You may download this budget
 e. Total Other Income                   $                -                form from the Web @:
 3. ADJUSTMENTS                                                                www.vhfa.org
  a. Vacancy Loss--Rents (at      %)
  b. Vacancy Loss--Commercial (at 5%)
  c. Total Adjustments                   $                -              Administrative Other:
 4. TOTAL INCOME                         $                -    TRACS                    $
                                                               LIHTC FEE                $
B. OPERATING EXPENSES                                          Training                 $
 1. ADMINISTRATIVE                                             Conference               $
 a. Management Fee                                             Other                    $
  b. Social Services
  c. Audit
 d. Legal
  e. Admin Other                         $                -            Total Admin Other   $               -
  f. Total Administrative                $                -
 2. UTILITY
  a. Electricity                                                   Transmit budgets electronically to:
  b. Fuel                                                                MFBudgets@vhfa.org
  c. Water and Sewer                                                          or mail to:
  d. Fire Alarm/Emergency Call                                           Management Officer
  e. Other - Specify:                                             Vermont Housing Finance Agency
  f. Total Utility                       $                -               164 St. Paul Street
 3. MAINTENANCE                                                              P.O. Box 408
 a. Maintenance/Janitor Payroll                                       Burlington, VT 05402-0408
  b. Janitor Supplies
  c. Exterminating
  d. Trash Removal
  e. Snow Removal
  f. Grounds
  g. Repairs Material
  h. Repairs Contract
  i. HVAC Repairs/Maintenance
  j. Elevator Contract/Repairs
  k. Painting and Decorating
  l. Other
  m. Total Maintenance                   $                -
 4. GENERAL                                                            (Please Complete Box Below)
  a. Real Estate Tax
  b. Property Insurance                                        Prepared By:
  c. Total – All VHFA Mortgage P & I
  d. Replacement Reserve                                       E-mail Address:
  e. Other Loan Payments (NON-VHFA)
  f. Other - Specify:                                          Cell Phone:
 g. Total General                        $                -
5. TOTAL COST OF OPERATIONS              $                -    Date:

C. OPERATING PROFIT/(LOSS)               $                -
D. RETURN ON EQUITY
E. NET PROFIT/(LOSS)                     $                -
F. TOTAL CAPITAL EXPENDITURES




   VHFA FORM #805                                                                              Revised 08/10
                               VERMONT HOUSING FINANCE AGENCY
                                        ANNUAL OPERATING BUDGET PROJECTION
                                                     SUPPLEMENT ONE

RENT CALCULATION                                         HAP Contract Anniversary date
                                                         Last Utility Allowance Adjustment date


FAMILY                      Please provide the current monthly contract rents.


                BDRM                          RENT        x     # OF       =        TOTAL RENT               UTILITY
                 SIZE                        PER UNIT          UNITS                BY BR SIZE             ALLOWANCE*
                            BR           $           -    x                =    $             -        $
                            BR           $           -    x                =    $             -        $
                            BR           $           -    x                =    $             -        $
                            BR           $           -    x                =    $             -        $
                            BR           $           -    x                =    $             -        $
                            BR           $           -    x                =    $             -        $
                            BR           $           -    x                =    $             -        $
                            BR           $           -    x                =    $             -        $


            TOTAL FAMILY MONTHLY CONTRACT RENTS                                 $             -
* Attach additional sheets for utility allowance information as needed.


ELDERLY                     Please provide the current monthly contract rents.


                BDRM                          RENT        x     # OF       =        TOTAL RENT
                 SIZE                        PER UNIT          UNITS                BY BR SIZE
                            BR           $           -    x                =    $             -
                            BR           $           -    x                =    $             -
                            BR           $           -    x                =    $             -
                            BR           $           -    x                =    $             -


            TOTAL ELDERLY MONTHLY CONTRACT RENTS                                $             -


            TOTAL PROJECT MONTHLY CONTRACT RENTS                                                       $                 -



            TOTAL ANNUAL RENT POTENTIAL (Total Project Monthly Rents x 12)                         =   $                 -
                                                                                                       enter (link) on line A.1.c.


            VACANCY RATE (For calendar Year 2010 or last 12 months)                                    %


UTILITY INFORMATION                     All properties must complete this section



 2011 Projected Monthly Cost of All Utilites:

Total Utility Expense: (line B 2. f.)           ÷         12 (months)      ÷     number of units   =   Monthly Cost Per Unit


            $                                            $____________                                 $


Have you completed the energy survey on VHFA's website?


            Yes: _____           When: _________              Completed by:




                                                                                                       revised 8/10

								
To top