Assisted Living Templates

Document Sample
Assisted Living Templates Powered By Docstoc
					Appendix G
Table G-1
Development Program- Rafael Village
Hamilton Army Airfield
Novato, CA                                                                                                                                                                        Rafael Village


                                                                                  Market Rate                                                        Deed Restricted
Single Family Detached
                                                                                                                                                                                     Level of
                                                                                                   Unit       1999                                        Unit       1999         Affordability (1)
   Number of Bedrooms                                      Lot size         # of Units     Size (sq. ft.)    Value      Lot size    # of Units    Size (sq. ft.)    Value      very low   low   mod


        3 bedrooms
        4 bedrooms
        5 bedrooms
                                                            ---------          ---------        ---------   ---------   ---------     ---------        ---------   ---------     -----     -----      -----
                                   Total

For Sale, Attached Units

        Site Area: _______________
                                                                                                   Unit       1999                                        Unit       1999         Affordability (1)
   Number of Bedrooms                                                       # of Units     Size (sq. ft.)    Value                  # of Units    Size (sq. ft.)    Value      very low   low   mod


        1 bedrooms
        2 bedrooms
        3 bedrooms
        4 bedrooms
                                                                               ---------        ---------   ---------                 ---------        ---------   ---------     -----     -----      -----
                                   Total

Senior Rental, Attached Units

        Site Area: _______________
                                                                                                   Unit       1999                                        Unit       1999         Affordability (1)
   Number of Bedrooms                                                       # of Units     Size (sq. ft.)    Value                  # of Units    Size (sq. ft.)    Value      very low   low   mod


        Studios
        1 bedrooms
        2 bedrooms


                                                                               ---------        ---------   ---------                 ---------        ---------   ---------     -----     -----      -----
                                   Total


(1) Indicate number of units for each level of affordablitliy:
        Very low = maximum of 50% of median income
        Low = maximum of 80% of median income
        Mod = maximum of 120 % of median income




Prepared by: Keyser Marston Associates, Inc.
Novato/Hamilton AFB/RFP Files/ a3f51558-f34e-4142-b057-fc586a46c879.xls/Table G-1; cda
12/20/2010
Table G-2
Development Program- Capehart/Hillside
Hamilton Army Airfield
Novato, CA                                                                                                                                                                               Capehart/Hillside




        All Units Deed Restricted                                                   Ownership Units                                                                  Rental Units
Duplex Units

                                                                                                                  Level of                                                                      Level of
                                                                                Unit                1999      Affordability (1)                            Unit                1999          Affordability (1)
   Number of Bedrooms                                # of Units         Size (sq. ft.)             Value      low        mod        # of Units     Size (sq. ft.)             Value      very low low         mod

        2 bedrooms
        3 bedrooms
        4 bedrooms
                                                        ---------             ---------           ---------    -------    -------      ---------         ---------           ---------    -------   -------   -------
                                   Total

Townhome Units

                                                                                                                  Level of                                                                      Level of
                                                                                Unit                1999      Affordability (1)                            Unit                1999          Affordability (1)
   Number of Bedrooms                                # of Units         Size (sq. ft.)             Value      low        mod        # of Units     Size (sq. ft.)             Value      very low low         mod

        3 bedrooms                   Total


Hillside Apartment Units

                                                                                                                                                                                                Level of
                                                                                                                                                                                             Affordability (1)
   Number of Bedrooms                                                                                                               # of Units     Size (sq. ft.)             Value      very low low         mod
                                                                                          (n/a)
        2 bedrooms                   Total


Additional Capehart Parking

        Number of New Spaces:




(1) Indicate number of units for each level of affordablitliy:
        Very low = maximum of 50% of median income
        Low = maximum of 80% of median income
        Mod = maximum of 120 % of median income




Prepared by: Keyser Marston Associates, Inc.
Novato/Hamilton AFB/RFP Files/ a3f51558-f34e-4142-b057-fc586a46c879.xls/Table G-2; cda
12/20/2010
Table G-4
Development Program- Exchange Triangle Site
Hamilton Army Airfield
Novato, CA                                                                                     Exchange Triangle




Neighborhood Serving Commercial Uses

  Commercial Uses                                        Sq. Ft.




                                                                              --------------
                                          Total




Prepared by: Keyser Marston Associates, Inc.
Novato/Hamilton AFB/RFP Files/ a3f51558-f34e-4142-b057-fc586a46c879.xls/Table G-4; cda
12/20/2010
Table G-3
Development Program- San Pablo Ave. Site
Hamilton Army Airfield
Novato, CA                                                                                                                                                                 San Pablo Ave.




                                                                         Market Rate                                                              Deed Restricted
Single Family Detached

                                                                                                                                                                              Level of
                                                                                            Unit        1999                                         Unit        1999      Affordability (1)
  Number of Bedrooms                                  Lot size     # of Units       Size (sq. ft.)     Value      Lot size     # of Units    Size (sq. ft.)     Value       low          mod

       3 bedrooms
       4 bedrooms
       5 bedrooms
                                                       ---------      ---------           ---------   ---------    ---------     ---------         ---------   ---------    ------     ------
                                 Total




(1) Indicate number of units for each level of affordablitliy:
       Very low = maximum of 50% of median income
       Low = maximum of 80% of median income
       Mod = maximum of 120 % of median income


Prepared by: Keyser Marston Associates, Inc.
Novato/Hamilton AFB/RFP Files/ a3f51558-f34e-4142-b057-fc586a46c879.xls/Table G-3; cda
12/20/2010
Table G-5
Development Program Summary
Hamilton Army Airfield
Novato, CA




                                                      Market Rate                        Deed Restricted Units             Non-Residential           Park      Open Space      Lane Street
                                                             Units             very low           low            mod                 GBA          Acreage         Acreage         Mileage

Rafael Village

     Detached, Single Family
     Attached, For Sale
     Attached, Rental
                                                           ------------             ------          ------        ------        ---------------     --------        --------        --------
                                      Total                                                                                                n/a




Capehart/Hillside

     For-sale Units
     Rental Units
                                                           ------------             ------          ------        ------        ---------------     --------        --------        --------
                                      Total                                                                                                n/a




San Pablo Avenue Site

     Detached, Single Family        Total                                                                                                 n/a



Exchange Triangle Site

     Land Use                      Total                          n/a                                   n/a




Prepared by: Keyser Marston Associates, Inc.
Novato/Hamilton AFB/RFP Files/ a3f51558-f34e-4142-b057-fc586a46c879.xls/Table G-5; cda
12/20/2010
Table G-10
Cash Flow Projections
Hamilton Army Airfield
Novato, CA

                                                  1999
                                           Unit Values                2000               2001       2002       2003       2004       2005       2006       2007       2008       2009       2010

Net Revenues
  Loan Proceeds
  Equity Contribution
  Agency Loan                                ________           ________           ________     ________   ________   ________   ________   ________   ________   ________   ________   ________
     Total Resources


Development Costs

  Land Acquisition

  Hard Costs
    Demolition
    Asbestos/Lead paint
       remedeation
    Public Infrastructure
    New Unit Construction
    Unit Rehabilitation
    Park Improvements
            Total Hard Costs

  Soft Costs
     Entitlements
     City Permits & Fees
     Security & Maintenance
     Taxes, Ins. & Legal
     Legal
     Contingency
           Subtotal Soft Costs
           (excluding financing)



  Financing Costs
     Fees
     Debt Service
     Loan 1
     Loan 2
                      Subtotal


Cash Flow, After Financing
                            IRR


  Housing Fund (20% set-aside)


  Non-Housing Agency Funds
    (80% monies)
    Other subsidies

  Cash Flow
                            IRR

    Prepared by: Keyser Marston Associates, Inc.
    Novato/Hamilton AFB/RFP Files/ a3f51558-f34e-4142-b057-fc586a46c879.xls/Table G-10; cda
    12/20/2010
Table G-11
Rental Property Cash Flow Projections
Hamilton Army Airfield
Novato, CA


                                                     2000             2001                2002       2003       2004       2005       2006       2007       2008       2009       2010

Gross Scheduled Rental Income
   Hillside Units
   Capehart Units
   Rafael Village Senior Units
   Rafael Village Assisted Living
        Service Income
   Miscellaneous Income                         ________         ________         ________       ________   ________   ________   ________   ________   ________   ________   ________

   Less: Vacancy
      Hillsides Units
      Capehart Units
      Rafael Village Units                      ________         ________         ________       ________   ________   ________   ________   ________   ________   ________   ________

Gross Effective Rental Income

   Less: Operating Expenses
   Less: Rafael Village Assisted
      Living Service Expenses
   Less: Replacement Reserves                   ________         ________         ________       ________   ________   ________   ________   ________   ________   ________   ________

   Total Annual Expenses




Net Operating Income




Prepared by: Keyser Marston Associates, Inc.
Novato/Hamilton AFB/RFP Files/ a3f51558-f34e-4142-b057-fc586a46c879.xls/Table G-11; cda
12/20/2010
Table G-8
Absorption Projections (Rentals, For Sale Units and Lot Sales)
Hamilton Army Airfield
Novato, CA




                                                    Number
                                                    of Units              2000                2001   2002   2003   2004   2005   2006   2007   2008   2009   2010
Rafael Village

  Lot Sales
  Market Rate
     Senior
     Single Family
  Deed Restricted
     Senior
     Single Family

Capehart/Hillside

  Duplexes, For Sale
    2 Bedroom
    3 Bedroom
    4 Bedroom

  Duplexes, For Rent
    2 Bedroom
    3 Bedroom
    4 Bedroom

  Townhomes, For Sale
    3 Bedroom

  Townhomes, For Rent
    3 Bedroom

  Hillside Apartments, For Rent
      2 Bedroom


San Pablo Avenue Site

  Lot Sales
  Single Family, Market Rate
  Single Family, Deed Restricted

Exchange Triangle Site
                                                      Sq. ft.
  Commercial Land Uses




     Prepared by: Keyser Marston Associates, Inc.
     Novato/Hamilton AFB/RFP Files/ a3f51558-f34e-4142-b057-fc586a46c879.xls/Table G-8; cda
     12/20/2010
Table G-9
Revenue Projections (Rentals, For Sale Units and Lot Sales)
Hamilton Army Airfield
Novato, CA


                                                  1999
                                           Unit Values             2000            2001       2002   2003   2004   2005   2006   2007   2008   2009   2010
Rafael Village

  Lot Sales
  Market Rate
     Senior
     Single Family
  Deed Restricted
     Senior
     Single Family

Capehart/Hillside

  Duplexes, For Sale
    2 Bedroom
    3 Bedroom
    4 Bedroom

  Duplexes, For Rent
    2 Bedroom
    3 Bedroom
    4 Bedroom

  Townhomes, For Sale
    3 Bedroom

  Townhomes, For Rent (NOI)
    3 Bedroom

  Hillside Apartments, For Rent (NOI)
      2 Bedroom


San Pablo Avenue Site

  Lot Sales
  Single Family, Market Rate
  Single Family, Deed Restricted

Exchange Triangle Site

  Commercial Land Uses


Total Gross Sales Revenues
  Less: Sales Costs




  Net Revenues



     Prepared by: Keyser Marston Associates, Inc.
     Novato/Hamilton AFB/RFP Files/ a3f51558-f34e-4142-b057-fc586a46c879.xls/Table G-9; cda
     12/20/2010
Table G-12
Sources and Uses of Funds (1)
Hamilton Army Airfield
Novato, CA

Development Costs                                   Cost,                  Source #1                       Source #2                        Source #3                       Source #4                       Source #5               Source #6
                                                    1999
                                                                     _________________               _________________                _________________               _________________               _________________         _________________


Land Acquisition


Hard Costs
   Demolition, Rafael Village
   Demolition, Capehart
   Infrastructure, Rafael Village
   Infrastructure, Capehart
   Unit Construction/Rehab
      Rafael Village:
      Capehart
      Hillside
      San Pablo Ave. Site
      Exchange Triangle Site                         _______                 ____________                    ____________                    ____________                     ____________                    ____________           ____________


Total Hard Costs



Soft Costs
   Entitlements
   City Permits & Fees
   Security & Maintenance
   Taxes, Ins. & Legal
   Development Mgmt.
   Contingency                                       _______                 ____________                    ____________                    ____________                     ____________                    ____________           ____________

Subtotal Soft Costs
(excluding financing)

Financing Costs


Municipal Service and
Predevelopment Reimbursement

                                 Total

(1) In order to ensure an equal set of parameters for all respondents to this RFP, proposed financing sources shall be restricted to private debt and equity sources, redevelopment agency funds, and other public
    financing mechanisms that are available to all respondents, such as community facility districts, tax exempt bonds, and 4% tax credits. Responses shall not include any other grant or subsidy sources. Finalists will be
    allowed and encouraged to enhance proposed financing plans with other subsidy sources when submitting "best and final" offers.



     Prepared by: Keyser Marston Associates, Inc.
     Novato/Hamilton AFB/RFP Files/ a3f51558-f34e-4142-b057-fc586a46c879.xls/Table G-12; cda
     12/20/2010
   Table G-6
   Development Costs
   Hamilton Army Airfield
   Novato, CA

   Development Costs                                                    # of Units        # of SF    $/Units       $/SF

   Land Acquisition


   Hard Costs
       Demolition, Rafael Village
       Demolition, Capehart
       Asbestos/ Lead based paint remeditation
       Public Infrastructure, Rafael Village
       Public Infrastructure, Capehart/Hillside
       On-site Improvements-
            Rafael Village
            Capehart
            Hillside Apartments
            San Pablo Ave. Site
            Exchange Triangle Site
       Park Improvements
       Unit Construction/ Rehabilitation-
            Rafael Village:
                 Single Family, Mkt. Rate
                 Single Family, Deed Restricted
                 Senior, Mkt. Rate
                 Senior, Deed Restricted
            Capehart:
                 New Units
                 Rehab Units
            Hillside:
                 New Units
                 Rehab Units
            San Pablo Ave. Site
            Exchange Triangle Site
       Additional Capehart Parking
                                                                         ________        ________   ________   ________
            Total Hard Costs


   Soft Costs
       Professional Fees
       Entitlements
       City Permits & Fees
       School Fees
       Security Costs
       Maintenance Costs, Capehart
       Taxes
       Insurance
       Development Mgmt.
       Legal
       Contingency
                                                                         ________        ________   ________   ________
            Subtotal Soft Costs
            (excluding financing)


   Financing Costs
       Fees
       Interest carry                                                    ________        ________   ________   ________
            Subtotal Financing Costs



       Total Development Costs

Prepared by: Keyser Marston Associates, Inc.
Novato/Hamilton AFB/RFP Files/ a3f51558-f34e-4142-b057-fc586a46c879.xls/Table G-6; cda
12/20/2010
Table G-7
Hard Infrastructure Costs
Hamilton Army Airfield
Novato, CA



Hard Infrastructure Costs

     Infrastructure Item                         Rafael Village                          Capehart/Hillside   San Pablo Ave. Site   Exchange Triangle Site

         Drainage
         Water
         Sewer
         Street
         Electrical
         Telephone
         Cable TV
         Natural Gas
         Miscellaneous

               Subtotal Costs

        Contingency (___%)




Infrastructure Construction Costs




Prepared by: Keyser Marston Associates, Inc.
Novato/Hamilton AFB/RFP Files/ a3f51558-f34e-4142-b057-fc586a46c879.xls/Table G-7; cda
12/20/2010

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:31
posted:12/21/2010
language:English
pages:12
Description: Assisted Living Templates document sample