Docstoc

bv_pro_forma_15_years

Document Sample
bv_pro_forma_15_years Powered By Docstoc
					Bayview Village
Pro Forma Input Summary
KEY PARAMETER INPUTS:

 Residential Product Mix and Base Price
      Unit Type                             Qty              Liv Space            Price
      Studio - Condo                                  40               411          $185,000
      One Bedroom - Condo                           150                530          $220,000
      Two Bedroom - Walkup Flat                     186                795          $240,000
      Two Bdrm 2 Bath - Walkup Flat                 312                855          $280,000
      Three Bedroom - Townhouse                     170              1511           $400,000
      Four Bedroom - Townhouse                      102              1715           $440,000
      Five Bedroom - Townhouse                        64             2131           $510,000
         Living Space Adjustment=                  100%    A quick way to modify all living spaces
         Price Adjustment=                         100%    A quick way to modify all prices
                                                   1024
 Direct Costs
      Component                             Cost
      Modular Fabrication, 2 Br                     $79 Per square foot of living area
      Modular Fabrication, 4 Br                     $69 Per square foot of living area
      Photovoltaic System, 2 Br               $19,500 Per system
      Photovoltaic System, 4 Br               $25,350 Per system
      Solar Hot Water, 2 Br                    $4,000 Per system
      Solar Hot Water, 4 Br                    $5,600 Per system


 Project Costs
      Component                           Unit Cost            Qty
      Earthwork                                     $10            37,000 Per cubic yard moved
      Hard Rock Excavation                          $35          164,600 Per cubic yard excavated
      Perimeter Retaining Walls                     $20           14,500 Per square foot of surface area of retaining wall
      Storm Drain Pipe                              $60            7,500 Per lineal foot of storage pipe
      C3 Storage Drain Pipe                         $80            3,694 Per lineal foot of storage pipe
      General Site Landscaping                        $6         325,000 Per square foot of landscaped area, including irrigation and
      Contingency                                  20%                       Percentage of total site improvement budget
      Developer Overhead                      $40,000                        Average per quarterly expense of developer's office space, o


 Event Triggers
      Event                                Value             Value 2         Allowable Range
      Build Cycle                                     2                      1 to 4 Quarters
      Quarterly Absorption Rate                       26                     <-- new Residential units sold each quarter, No less than 10
      Trigger to construct next phase              80%                       Can be 10% to 80%, representing the percent of units sold in
      Start of Sales                                  4                  1 Year plus quarter that sales begin, must be no sooner than 2
       Entitlements Obtained                              2                1 Can be no sooner than 1 year plus 2 quarters, representing t


  Selling Expenses
       Item                                     Rate
       Model Operating Expense                     $15,000 Per quarter, represents mortgage payments, utilities, cleaning and maintenan
       Sales Commission Rate                           1.8% Percent of revenue paid to dedicated sales team (either employees or consult
       Broker Coop                                     1.0% Percent of revenue paid to independent brokers representing buyers, this is a
       Advertising                                $10,000 Per quarter expense for website, brochures, newspaper ads, etc.


  Interest and Taxes
       Property Tax Rate                             1.50%
       Development Loan Interest Rate                  8.5%


NOTEWORTHY FIXED INPUTS
       Model setup costs are $80,000 per model
       Engineering phase will take 4 quarters to complete
       Land purchase maintenance deposits are paid quarterly at a rate of .4% of purchase price, applicable to price
       Land purchase initial deposit is 2.5% of purchase price, applicable to price
       Land purchase will close on entitlements, whenever that will occur
       Each phase improvements are constructed over a 5 quarter period
       The Commercial Buildings and Manager Units starts construction 3 during Phase 1 and 2.
       Equity Investor payouts are hard-entries…see Cash Flow Statement

Changes
       Commercial construction start/fninish moved up 1 quarter but not sale.
       Faster absorption, 15 to 34, seven years of building
       Cash on hand and invesor payout adjusted exogenously.
                                               Hayward Area Planning Association




ea of retaining wall



d area, including irrigation and soil amendment
ovement budget
se of developer's office space, office equipment, staff salaries, construction trailer, stationery, etc.




 each quarter, No less than 10
ting the percent of units sold in the current phase to trigger start of next phase's site improvements
egin, must be no sooner than 2 years after entitlements are obtained
r plus 2 quarters, representing the time required to obtain all government discretionary approvals.




tilities, cleaning and maintenance, property taxes on 6 model homes
m (either employees or consultant-specialists)
rs representing buyers, this is a blended rate of commission times proportion of total sales completed with brokers
ewspaper ads, etc.
Bayview Village                                                                                 Hayward Area Planning Association

Income Statement
                                                    Project-Wide                          Per Unit
Category - Item                                   Amount           Subtotal     Units     Quantity   Per Unit    Basis (Worksheet)

REVENUE
    Residential Sales - Base               $317,920,000                       D.U.          1,024    $310,469    Sales
      Residential Sales - Options               $1,827,625                    D.U.          1,024      $1,785    Sales
      Commercial Sales                          $2,867,200                    Leased SF     8,192        $350    Sales
      Sales Incentives                           -$512,000                    D.U.          1,024       -$500
        NET REVENUE                                          $322,102,825


COSTS
  Land Development Costs
      Land Acquisition                         $28,526,659                    D.U.          1,024     $27,858    Land
      Site Improvements                        $28,226,302                    D.U.          1,024     $27,565    Site Imp
      Loan Interest                            $20,573,792                    D.U.          1,024     $20,092    Cash Flow
      Property Taxes & Assessments              $2,974,446                    D.U.          1,024      $2,905    Cash Flow
      Project Level Government Fees             $1,121,140                    D.U.          1,024      $1,095    Proj Fees
      Project Level Consultant Fees             $4,198,100                    D.U.          1,024      $4,100    Proj Cons
        Subtotal: Land Development Costs                      $85,620,440


  Building Costs
      Direct Costs - Residential-Base      $126,372,651                       D.U.          1,024    $123,411    Bldgs
      Direct Costs - Green Energy              $31,614,558                    D.U.          1,024     $30,874    Energy
      Direct Costs - Residential-Options   $    1,503,000                     D.U.          1,024      $1,468    Sales
      Direct Costs - Commercial/Other      $    4,758,429                     Leased SF     8,192       $581     Bldgs
      Building Permit Fees                     $30,783,098                    D.U.          1,024     $30,062    Bldg Fees
      Building Consultant Fees                  $1,375,918                    D.U.          1,024      $1,344    Bldg Cons
        Subtotal: Building Costs                             $196,407,653


  Selling Expenses                                                                                                                   % of Revenue:
      Model Expenses                            $1,020,000                    D.U.          1,024       $996     Cash Flow
      Sales Commissions                         $5,797,851                    D.U.          1,024     $5,662     % of Revenue            1.8%
      Broker Coop Fees                          $3,221,028                    D.U.          1,024     $3,146     % of Revenue            1.0%
      Advertising                                $390,000                     D.U.          1,024       $381     Cash Flow
      Sellers Closing Costs                     $1,288,411                    D.U.          1,024     $1,258     % of Revenue            0.4%
        Subtotal: Selling Expenses                            $11,717,290


  Other Expenses
      Warranty Reserve                          $3,221,028                    D.U.          1,024     $3,146     % of Revenue            1.0%
      Insurance                                 $2,254,720                    D.U.          1,024     $2,202     % of Revenue            0.7%
      Village Bus                               $2,650,000                    D.U.          1,024     $2,588     Bus
      Developer Administration/Overhead         $2,080,000                    D.U.          1,024     $2,031     Cash Flow
        Subtotal: Other                                       $10,205,748


        NET COSTS                                            $303,951,132



NET OPERATING INCOME                                          $18,151,693
PRETAX PROFIT MARGIN                                                  5.6%

Equity ROI                                          10.5%
First Payout Recevied in                            Year 7
                                           Income
8c037106-2338-4492-be16-876d3afc0a89.xls Year 21
Last Payout Received in                                                                                                     4/21/2012 7:40 PM
Maximum Debt Exposure                          $42,168,902
sociation




        % of Revenue:




                   8c037106-2338-4492-be16-876d3afc0a89.xls   Income   4/21/2012 7:40 PM
    Bayview Village                                                                                                   Hayward Area Planning Association

    Sales Background Data
                                                         RESIDENTIAL SALES - BASE (Note 1)

    Dwelling Unit Description                      Quantity              Base Price        Revenue by Unit        Size (SF)      Price per SF

    Studio - Flat in Mixed Use Bldg                       40               $185,000               $7,400,000            411              $450
    One Bedroom - Condo                                  150               $220,000             $33,000,000             530              $415
    Two Bedroom - Condo                                  186               $240,000             $44,640,000             795              $302
    Two Bedroom Two Bath - Condo                         312               $280,000             $87,360,000             855              $327
    Three Bedroom -Condo                                 170               $400,000             $68,000,000           1511               $265
    Four Bedroom - Condo                                 102               $440,000             $44,880,000           1715               $257
    Six Bedroom - Townhouse                               64               $510,000             $32,640,000           2131               $239

      Total Dwelling Units                             1024
      Total Revenue - Base Residential                                                         $317,920,000

                                                     RESIDENTIAL SALES - UPGRADES (Note 2)

    Upgrade Description                                Units      %        Avg. Cost               Total Cost        Price           Revenue              Markup

    Interior Upgrades
     Granite Countertops                                 205 20%              $1,500                $307,500        $1,875          $384,375                 25%
     Upgraded Cabinets                                    52     5%           $7,000                $364,000        $8,750          $455,000                 25%
     Molding Package                                      21     2%           $1,500                 $31,500        $1,950            $40,950                30%
     Technology Wiring Package                            52     5%           $3,500                $182,000        $4,550          $236,600                 30%
     Upgraded Floor Coverings                            103 10%              $6,000                $618,000        $6,900          $710,700                 15%

      Total Cost - Upgrades                                                                       $1,503,000
      Total Revenue - Upgrades                                                                                                    $1,827,625

                                                          SALES - COMMERCIAL BUILDINGS

    Building Description                           Quantity              Base Price        Revenue by Unit        Size (SF)      Price per SF

    Community Center (Note 3)                               1                    $0                       $0          9504                 $0
    Village Store (Note 4)                                  1            $1,792,000               $1,792,000          5120               $350
    Restaurant (Note 4)                                     2              $537,600               $1,075,200          1536               $350

      Total Revenue - Commercial                                                                  $2,867,200

          TOTAL: REVENUES                                                                                                                            $322,614,825

    NOTES
    Note 1: Pricing is based on an in-house informal market survey of resales in Hayward, including consulting with local real estate brokers.
    Pricing for these units is adjusted upwards reflecting the significant new house premium buyers are willing to pay in this built-out locale.
    Note 2: Pricing for upgrades is based on the industry practice of applying a percentage markup to expected costs. "%" is an estimate
    of proportion of buyers opting for the particular upgrade.
    Note 3: The Community Center is the common facility for the Quarry Village Homeowners Association. It will deeded to the HOA at no cost.
    Note 4: The store and restaurant will be owned by the HOA, leased to operators, and managed to reduce HOA fees.




8c037106-2338-4492-be16-876d3afc0a89.xls                    Sales                                                                                  4/21/2012 7:40 PM
Bayview Village                                                                                                  Hayward Area Planning Association

Land Acquisition Background Data
Property Address of Assemblage          Physical Description                       APN              Units              Unit Price       Qty          Amount

Main Quarry Site (Note 1)               Raw Land                            445-0180-001-00         Acres                $809,198     29.42      $23,806,614
1199 Overlook Ave. (Note 2)             3 Single Family Dwellings           445-0170-020-01         Per House            $253,773         3         $761,318
1199 Overlook Ave. (Note 2)             1 Lot - Vacant                      445-0170-020-01         Per Vacant Lot        $76,132         1          $76,132
1151 Overlook Ave. (Note 2)             1 House                             445-0170-038-03         Per House            $253,773         1         $253,773
1155 Palisade (Note 2)                  4 Lots - Vacant                     445-0170-038-03         Per Vacant Lot        $76,132         4         $304,527
Palisade (Note 1)                       Paved Street                    N/A: Street ROW Vacation    Acres                $809,198      0.36         $291,311
1174 Overlook (Note 2)                  3 Single Family Dwellings           445-0170-017-01         Per House            $253,773         3         $761,318
1174 Overlook (Note 2)                  1 Lot - Vacant                      445-0170-017-01         Per Vacant Lot        $76,132         1          $76,132
Overlook (Note 1)                       Paved Street                    N/A: Street ROW Vacation    Acres                $809,198      0.96         $776,830
1138 Overlook (Note 2)                  3 Single Family Dwellings           445-0170-034-01         Per House            $253,773         3         $761,318

 Subotal: Land Purchases                                                                                                                         $27,869,274

Land Transaction Item                                                                               Units              Unit Price       Qty          Amount

Land Purchases                                                                                                                                   $27,869,274
Buyer Closing Costs                                                                                 % of Purchases                       1%         $278,693
Legal: Purchase Agreements                                                                          Lump Sum             $100,000         1         $100,000
RE Broker: Negotiations, Establish Pricing                                                          % of Purchases                       1%         $278,693

  TOTAL: LAND ACQUISITIONS                                                                                                                       $28,526,659


NOTES
Note 1: Raw land value is based on an average transaction price of representative large parcels in the East Bay in 2009. Individual reported
sales were as reported in table below. (Source: Mike McMahon, Placer Title Company, San Leandro)

Seller                                  Property Description           City                         Price          Size (ac)                   Price per acre
Old D                                   Commercial - vacant            Oakland                         $13,500,000            8                    $1,605,232
Tri                                     Rural - mostly undevelopable   Livermore                        $1,500,000            6                      $250,000
Lin, commercial                         Commercial - vacant            Dublin                           $7,000,000           12                      $572,363

 Average of Comparable Raw Land Parcels Sold                                                                                                        $809,198

Note 2: House value is based on an average transaction price of 23 single family and duplex units in the immediate Hayward area in 12/09.
Individual reported sales were: (Source: Mike McMahon, Placer Title Company, San Leandro)
Vacant lot uses a rule-of-thumb that a buildable lot should be about 30% of the final product cost.
                                                                                                                                               Average Price
Property Description                            Living Space                 Bedroom Count                     Price     Price/SF              per SF by type
Duplex (each half: dwelling unit)                      1,183                       2                        $170,000         $144
Duplex (each half: dwelling unit)                      1,230                       3                        $200,000         $163
Duplex (each half: dwelling unit)                        829                       2                        $175,000         $211              Duplex=
Duplex (each half: dwelling unit)                        917                       2                         $95,000         $104                         $155
Detached Single Family                                   690                       2                        $215,000         $312
Detached Single Family                                 1,114                       2                        $321,500         $289
Detached Single Family                                 1,235                       2                        $267,636         $217
Detached Single Family                                   670                       2                         $87,000         $130
Detached Single Family                                 1,041                       2                        $200,000         $192
Detached Single Family                                 1,107                       2                        $265,000         $239
Detached Single Family                                   794                       2                        $215,000         $271              2 Bdrm =
Detached Single Family                                   950                       2                        $190,000         $200                         $231
Detached Single Family                                 1,577                       3                        $245,000         $155
Detached Single Family                                 2,220                       3                        $411,000         $185
Detached Single Family                                 1,304                       3                        $429,000         $329
Detached Single Family                                 2,163                       3                        $513,000         $237
Detached Single Family                                 1,178                       3                        $280,000         $238
Detached Single Family                                 1,187                       3                        $195,000         $164
Detached Single Family                                 1,724                       3                        $270,500         $157
Detached Single Family                                 1,229                       3                        $279,000         $227
Detached Single Family                                 1,075                       3                        $215,000         $200
Detached Single Family                                 1,304                       3                        $157,000         $120
Detached Single Family                                 1,173                       3                        $230,000         $196              3 Bdrm =
Detached Single Family                                 1,016                       3                        $250,000         $246                         $205
Detached Single Family                                 2,552                       4                        $360,000         $141
Detached Single Family                                 1,426                       4                        $230,000         $161
Detached Single Family                                 2,240                       4                        $380,000         $170              4 Bdrm =
Detached Single Family                                 1,382                       4                        $260,000         $188                         $165

 Average Price of D.U.'s sold                                                                               $253,773


8c037106-2338-4492-be16-876d3afc0a89.xls                Land                                                                                              4/21/2012 7:40 PM
8c037106-2338-4492-be16-876d3afc0a89.xls   Land   4/21/2012 7:40 PM
Bayview Village                                                                                                                                  Hayward Area Planning Association

Site Improvements Background Data
Category - Line Item                                                Units   Unit cost      Qty       Amount       Subtotal   Comments


Site Preparation and Field Expense
      Clear and Grub                                                Ac         $5,000       24      $120,000                 Main quarry site largely free of trees, structures, debris
      Mobilization                                                  LS       $60,000           4    $240,000                 Includes construction trailer, temp power setup, fencing
      Demolish houses                                               EA       $30,000        10      $300,000                 8 occupied houses; 2 boarded up houses
      Palisade, partial street removal (Note 1)                     SF          $3.00     2,240       $6,720                 14' x 160', north side of existing street
      Utility relocation                                            LF           $150      500       $75,000
      Erosion Control                                               site    $200,000           1    $200,000                 Includes temporary silt basins to be built first.
      Utilities                                                     years        $800          8      $6,400
      General site maintenance, cleanup & repairs                   years      $7,000          8     $56,000
        Subtotal: Site Preparation and Field Expense                                                            $1,004,120


Grading ( Note 2)
      Soil volume estimate                                          CY            $10    37,000     $370,000                 Area to be graded times assumed 1.5 feet soil depth
      Hard rock blasting & grading cut to fill                      CY            $35   164,600    $5,761,000                Blasting or heavy equipment; loading, moving. avoid hard
                                                                                                                             on 4.4 acres, handle twice, replace with soil, to
      Over-excavation by 1' of hard rock                            CY            $35   20,000      $700,000                 rock finish….Soil from cliff area can cover much of the 4.4
      Grinding quarry aggregate for onsite base                     CY             $2   20,000       $30,000                 supplement soil volume to meet need on surface
      Perimeter Soil-Nail Retaining Walls                           SF            $20   14,500      $290,000
      Catchment Fence                                               LF            $18      550        $9,900
      Catchment Wall                                                LF           $400      350      $140,000
      Pad fine grading , 281 res. buildings, C. Center, CB          EA         $1,000      283      $283,000                 aver. Footprint =1,492 sq ft
        Subtotal: Grading                                                                                       $7,583,900


Concrete and A.C.
      3" A.C. over 8" A.B. Overlook Extension (Note 3)              SF             $8    15,818     $126,544                 Overlook extension
      3" A.C. over 6" A.B. for car ports for 100 cars               SF             $7    16,120     $112,840                 Stall at 8x15 to 19; carport at 9x18 to 20, ~ 170 sq ft each
      Pervious walkways, 12' wide H-20 req. (Note 4)                SF            $10   129,320    $1,293,200
      Concrete Sidewalk along busway and east side, Overlook        SF            $12     7,140      $85,680
      3.5" A.C. over 14.5" A.B. (TI = 6.5) - busway, 20' wide)      SF            $11    16,708     $183,788
      Driveway cut 2 at 20' wide (H-20 req.) 6" PCC over 3" A.B     SF            $15      192        $2,880                 Crosses sidewalk, busway to Main Way and Knoll Way
      Street curbs and gutters                                      LF            $20      600       $12,000
        Subtotal: Concrete and A.C.                                                                             $1,816,932




8c037106-2338-4492-be16-876d3afc0a89.xls                 Site Imp                         10                                                                         4/21/2012 7:40 PM
Bayview Village                                                                                                                                Hayward Area Planning Association

Site Improvements Background Data
Category - Line Item                                                 Units   Unit cost    Qty       Amount       Subtotal   Comments
Storm Drain System (Note 5)
      Small storm drain inlets (pipes)                               EA         $2,500    172      $430,000
       HDPE (15") with 4" outlet                                     LF            $60   7,500     $450,000
       HDPE (24") for storage                                        LF            $80   3,694     $295,520
       Storm drain manholes with 2" dia. Metered release             EA         $4,000    100      $400,000
         Subtotal: Storm Drain System                                                                          $1,575,520


Sanitary Sewer
       Manholes                                                      EA         $4,000     40      $160,000
       8" San Sewer (xRCP)(PVC)                                      LF            $65   3,972     $258,180                 Considers hard rock trenching cost
       8" San Sewer Connector Line (Extra Deep)                      LF            $85   1,600     $136,000                 Portions to be bore & jacked
       Connect to Existing                                           EA         $1,500        1      $1,500
       6" PVC lateral w/ double cleanout                             EA           $700    283      $198,100                 One per bldg
         Subtotal: Sanitary Sewer                                                                               $753,780


Water System
       8" distribution main                                          LF            $80   8,600     $688,000
       Water meter box                                               EA           $400    953      $381,200                 1 meter for studios
       D.U. Service Lateral                                          EA         $1,000    905      $905,000                 1/ unit wet tap
       Building Service Lateral                                      EA       $10,000         4     $40,000
       Detector Check Valves                                         EA         $5,000     94      $471,667                 Will need to include at most major buildings.
       Water Valves                                                  EA         $2,000     15       $30,000                 at end of water line
       Fire hydrants                                                 EA         $4,000     30      $120,000
         Subtotal: Water System                                                                                $2,635,867


Dry Utilities
       Joint trench                                                  LF           $200   8,600    $1,720,000                2'w x5'deep + 6 conduits
       PG&E: electric mains, meter w/ service laterals               Meter      $2,200   1,024    $2,252,800                Cost shown is net of refunds
       Rule 20 Undergrounding                                        Pole     $25,000         5    $125,000
       Satellite dish feed and site security w/service laterals      LF            $10   8,600      $86,000                 HOA maintained equipment (from dish to D.U.'s)
       Low-height street and walkway lights                          EA         $2,500    215      $537,500                 Placed at 40' intervals along walkways and roads
         Subtotal: Dry Utilities                                                                               $4,721,300




8c037106-2338-4492-be16-876d3afc0a89.xls                  Site Imp                       11                                                                      4/21/2012 7:40 PM
Bayview Village                                                                                                                                                                Hayward Area Planning Association

Site Improvements Background Data
Category - Line Item                                                        Units      Unit cost             Qty       Amount            Subtotal        Comments
Landscaping and Miscellaneous
        Common Area Landscaping and irrigation                              SF                  $9      112,000      $1,008,000                          Includes biofiltration features, Bayview trail/picnic area
        Village Square/park                                                 SF                $15           3000       $45,000                           High intensity use area calling for identity hardscaping
        Parks                                                               SF                $10         83000       $830,000
        Plazas                                                              EA           $30,000                 2     $60,000
        Gate, path, footbridge across creek to Highland Blvd.               SF                $20            200         $4,000                          100 sq ft 200/sq ft
        Entry sign / monument                                               EA           $35,000                 1     $35,000
        Front yard, courtyard, and walkway landscaping                      SF                  $6      100,000       $600,000
        trees                                                               EA               $175            100       $17,500
        Street signs                                                        EA               $300             20         $6,000
        Survey Monuments                                                    LS             $1,000             30       $30,000                           Standard survey monuments
        Electric Gates                                                      EA           $20,000                 2     $40,000
        Striping                                                            LS             $5,000                1       $5,000
        Offsite Traffic Signals (Note 6)                                    EA          $250,000                 3    $750,000
          Subtotal: Landscaping & Miscellaneous                                                    .                                  $3,430,500


Contingency                                                                 %           20.00%         23,521,919    $4,704,384       $4,704,384


            TOTAL: SITE IMPROVEMENTS                                                                                                 $28,226,302




Notes
Note 1: Palisade east from 120 feet west of Overlook and all Overlook become owned by the project. North side of Palisade is rebuilt for busway; south side is part of site.
Note 2: See separate cut/fill analysis and grading plan. A small southern area south of about 300' elevation has 9% to 16% slopes that cannot be changed much, but already has utilities in the street. The large northern
area of bedrock mostly needs about five feet of fill to get depth for utility trenches, with a pit on the northwest needing more fill. A knoll on the midwest has elevation that will be lowered to create a 6 to 7 percent
walking grade, the steepest in the plan north of 300', to reach scenic views. An area between the small southern area and the bedrock has overburden and bedrock that needs to come down and will help fill the north.
Toby did AutoCAD volume analysis (Dec. 3, 2010) and got 125,000 cu yds cut and 106,000 cu yds fill based on a 3% slope in the in-between area. If this slope went to 5%, cut and fill would easily balance at about 115,000
cu yds. Grading is also needed for 2% drainage slopes and to support easier walking to north to south. Some cut is dirt (natural and piles of overburden) and some is hard rock, some of which may need to be grind to
fines for surface finish soil quality. About 20% of trenches (on the knoll and in the in-between area) will have to be in hard rock. (The 7.5 minute Geo Survey contour lines are pre-quarry.)


Note 3: 100 covered parking spaces for short term parking and drop off/pick up parking on Overlook

Note 4: Roads, parking, busway, major walkways allow fire trucks, garbage trucks, etc. See data on acres tab. Existing Overlook and Palisade sidewalks to be retained are not listed. I'd like walkways to use something
easy on the feet. www.rubbersidewalks.com may work.




8c037106-2338-4492-be16-876d3afc0a89.xls                     Site Imp                                       12                                                                                    4/21/2012 7:40 PM
Bayview Village                                                                                                                                                               Hayward Area Planning Association

Site Improvements Background Data
Category - Line Item                                                        Units      Unit cost            Qty        Amount            Subtotal       Comments
Note 5: Based on civil engineer's estimate dated 1/12/2010, based HydroCAD estimates (10 year event, 3 hour total time event, .01 minute time intervals) for each courtyard type. and for habitat use. Pipes in cortyward
hold storm bursts and trickly off through 4" outlet. There will be about 6 metered low-flow discharge points into the creek with the rest going into walkways and streets.



Note 6: Palisade and Overlook are now public ROW. East of Overlook, the City would abandon Palisade, which would become part of the QV busway. QV would have an easement with PG&E to use its rOW for the rest of
the busway. Overlook from Palisade to Carlos Bee continues as public ROW with parking on the east side and public travel lanes on the west side. North of Palisade the City would abandon Overlook, which would be
used for QV parking and a drop off lane for rental cars and taxis. At Overlook and Bee, left turns coming uphill onto Overlook would be barred. A left turn lane would be created for the bus with a signal controlled by the
bus allowing it to stop downhill traffic and turn left. At Busway and Bee, traffic signals, again congtrolled by the bus, would stop downhill traffic and allow the bus to turn left uphill, where it wold go into a new bus
merge lane that merges into Bee. Auto access from the east, downhill on Bee, would turn in at Overlook. Auto access from the west to the Palisade and QV areas would use Palisade. This plan eliminates any auto traffic
going up Bee from crossing any downhill traffic. All traffic up Bee would use Mission Blvd. This plan requires 3 lights at busway and Bee and 3 at Overlook and Bee.




8c037106-2338-4492-be16-876d3afc0a89.xls                     Site Imp                                      13                                                                                     4/21/2012 7:40 PM
Bayview Village                      Hayward Area Planning Association

Site Improvements - Breakdown by Building Phase
                                                                                                 Overall                    By Building Phase
Category - Line Item                                               Units   Unit cost      Qty        Amount      Subtotal   Phase 1       Phase 2          Phase 3          Phase 4


Site Preparation and Field Expense
      Clear and Grub                                               Ac         $5,000       24      $120,000                      $24,000                       $42,000
      Mobilization                                                 LS       $60,000         4      $240,000                      $60,000                       $60,000
      Demolish houses                                              EA       $30,000        10      $300,000                    $150,000
      Palisade, partial street removal (Note 1)                    SF          $3.00     2,240       $6,720                       $6,720
      Utility relocation                                           LF           $150      500       $75,000                      $75,000
      Erosion Control                                              site    $200,000         1      $200,000                      $30,000       $8,571          $40,000            $8,571
      Utilities                                                    years        $800        8        $6,400                         $576            $576             $576             $576
      General site maintenance, cleanup & repairs                  years      $7,000        8       $56,000                       $5,040       $5,040            $5,040           $5,040
        Subtotal: Site Preparation and Field Expense                                                           $1,004,120      $351,336       $14,187         $147,616          $14,187


Grading ( Note 2)
      Soil volume estimate                                         CY            $10    37,000     $370,000                      $55,500                      $148,000
      Hard rock blasting & grading cut to fill                     CY            $35   164,600    $5,761,000                   $864,150                      $2,304,400
      Over-excavation by 1' of hard rock                           CY            $35    20,000     $700,000                    $105,000                       $280,000
      Grinding quarry aggregate for onsite base                    CY          $1.50    20,000      $30,000
      Perimeter Soil-Nail Retaining Walls                          SF            $20    14,500     $290,000                      $29,000                       $72,500
      Catchment Fence                                              LF            $18      550        $9,900                                                      $9,900
      Catchment Wall                                               LF           $400      350      $140,000                                                   $140,000
      Pad fine grading , 281 res. buildings, C. Center, CB         EA         $1,000      283      $283,000                      $70,750                       $70,750
        Subtotal: Grading                                                                                      $7,583,900     $1,124,400              $0     $3,025,550                 $0


Concrete and A.C.
      3" A.C. over 8" A.B. Overlook Extension (Note 3)             SF             $8    15,818     $126,544
      3" A.C. over 6" A.B. for car ports for 100 cars              SF             $7    16,120     $112,840
      Pervious walkways, 12' wide H-20 req. (Note 4)               SF            $10   129,320    $1,293,200                   $116,388      $116,388         $116,388         $116,388
      Concrete Sidewalk along busway and east side, Overlook       SF            $12     7,140      $85,680                      $85,680
      3.5" A.C. over 14.5" A.B. (TI = 6.5) - busway, 20' wide)     SF            $11    16,708     $183,788                      $16,541      $16,541          $16,541          $16,541
      Driveway cut 2 at 20' wide (H-20 req.) 6" PCC over 3" A.B    SF            $15      192        $2,880                       $2,880
      Street curbs and gutters                                     LF            $20      600       $12,000                       $1,080       $1,080            $1,080           $1,080
        Subtotal: Concrete and A.C.                                                                            $1,816,932      $222,569      $134,009         $134,009         $134,009




8c037106-2338-4492-be16-876d3afc0a89.xls                 Site Imp-Phase                   14                                                                         4/21/2012 7:40 PM
Bayview Village                      Hayward Area Planning Association

Site Improvements - Breakdown by Building Phase
                                                                                                Overall                    By Building Phase
Category - Line Item                                                Units   Unit cost    Qty        Amount      Subtotal   Phase 1       Phase 2       Phase 3       Phase 4
Storm Drain System (Note 5)
      Small storm drain inlets (pipes)                              EA         $2,500    172      $430,000
       HDPE (15") with 4" outlet                                    LF            $60   7,500     $450,000
       HDPE (24") for storage                                       LF            $80   3,694     $295,520
       Storm drain manholes with 2" dia. Metered release            EA         $4,000    100      $400,000
         Subtotal: Storm Drain System                                                                         $1,575,520      $141,797      $141,797      $141,797      $141,797


Sanitary Sewer
       Manholes                                                     EA         $4,000     40      $160,000
       8" San Sewer (xRCP)(PVC)                                     LF            $65   3,972     $258,180
       8" San Sewer Connector Line (Extra Deep)                     LF            $85   1,600     $136,000
       Connect to Existing                                          EA         $1,500      1        $1,500
       6" PVC lateral w/ double cleanout                            EA           $700    283      $198,100
         Subtotal: Sanitary Sewer                                                                              $753,780         $67,840      $67,840       $67,840       $67,840


Water System
       8" distribution main                                         LF            $80   8,600     $688,000
       Water meter box                                              EA           $400    953      $381,200
       D.U. Service Lateral                                         EA         $1,000    905      $905,000
       Building Service Lateral                                     EA       $10,000       4       $40,000
       Detector Check Valves                                        EA         $5,000     94      $471,667
       Water Valves                                                 EA         $2,000     15       $30,000
       Fire hydrants                                                EA         $4,000     30      $120,000
         Subtotal: Water System                                                                               $2,635,867      $237,228      $237,228      $237,228      $237,228


Dry Utilities
       Joint trench                                                 LF           $200   8,600    $1,720,000
       PG&E: electric mains, meter w/ service laterals              Meter      $2,200   1,024    $2,252,800
       Rule 20 Undergrounding                                       Pole     $25,000       5      $125,000
       Satellite dish feed and site security w/service laterals     LF            $10   8,600      $86,000
       Low-height street and walkway lights                         EA         $2,500    215      $537,500
         Subtotal: Dry Utilities                                                                              $4,721,300      $424,917      $424,917      $424,917      $424,917




8c037106-2338-4492-be16-876d3afc0a89.xls                  Site Imp-Phase                 15                                                                      4/21/2012 7:40 PM
Bayview Village                      Hayward Area Planning Association

Site Improvements - Breakdown by Building Phase
                                                                                                                     Overall                              By Building Phase
Category - Line Item                                                         Units      Unit cost            Qty         Amount           Subtotal        Phase 1       Phase 2             Phase 3          Phase 4
Landscaping and Miscellaneous
        Common Area Landscaping and irrigation                               SF                 $9      112,000       $1,008,000                               $90,720           $90,720        $90,720          $90,720
        Village Square/park                                                  SF                $15         3,000        $45,000                                                  $45,000
        Parks                                                                SF                $10        83,000       $830,000                              $166,000                                           $166,000
        Plazas                                                               SF           $30,000               2       $60,000                                                  $30,000                         $30,000
        Gate, path, footbridge across creek to Highland Blvd.                SF                $20           200          $4,000
        Entry sign / monument                                                EA           $35,000               1       $35,000                                $35,000
        Front yard, courtyard, and walkway landscaping                       SF                 $6      100,000        $600,000                                $54,000           $54,000        $54,000          $54,000
        trees                                                                EA               $175           100        $17,500                                 $1,575            $1,575          $1,575           $1,575
        Street signs                                                         EA               $300             20         $6,000                                  $540              $540              $540             $540
        Survey Monuments                                                     LS            $1,000              30       $30,000                                 $2,700            $2,700          $2,700           $2,700
        Electric Gates                                                       EA           $20,000               2       $40,000                                                  $20,000
        Striping                                                             LS            $5,000               1         $5,000                                  $450              $450              $450             $450
        Offsite Traffic Signals (Note 6)                                     EA          $250,000               3      $750,000                              $250,000
          Subtotal: Landscaping & Miscellaneous                                                     .                                   $3,430,500           $600,985           $244,985       $149,985         $345,985


Contingency                                                                  %                20%       23,521,919    $4,704,384        $4,704,384           $423,395           $423,395       $423,395         $423,395


            TOTAL: SITE IMPROVEMENTS                                                                                                  $28,226,302           $3,594,466         $1,688,358     $4,752,336       $1,789,358




Notes
Note 1: Palisade east from 120 feet west of Overlook and all Overlook become owned by the project. North side of Palisade is rebuilt for busway; south side is part of site.
Note 2: See separate cut/fill analysis and grading plan. A small southern area south of about 300' elevation has 9% to 16% slopes that cannot be
changed much, but already has utilities in the street. The large northern area of bedrock mostly needs about five feet of fill to get depth for utility
trenches, with a pit on the northwest needing more fill. A knoll on the midwest has elevation that will be lowered to create a 6 to 7 percent walking
grade, the steepest in the plan north of 300', to reach scenic views. An area between the small southern area and the bedrock has overburden and
bedrock that needs to come down and will help fill the north. Toby did AutoCAD volume analysis (Dec. 3, 2010) and got 125,000 cu yds cut and
106,000 cu yds fill based on a 3% slope in the in-between area. If this slope went to 5%, cut and fill would easily balance at about 115,000 cu yds.
Grading is also needed for 2% drainage slopes and to support easier walking to north to south. Some cut is dirt (natural and piles of overburden) and
some is hard rock, some of which may need to be grind to fines for surface finish soil quality. About 20% of trenches (on the knoll and in the in-
Note 3: 100 covered parking spaces for short term parking and drop off/pick up parking on Overlook

Note 4: Roads, parking, busway, major walkways allow fire trucks, garbage trucks, etc. See data on acres tab. Existing Overlook and Palisade
sidewalks to be retained are not listed. I'd like walkways to use something easy on the feet. www.rubbersidewalks.com may work.




8c037106-2338-4492-be16-876d3afc0a89.xls                     Site Imp-Phase                                  16                                                                                       4/21/2012 7:40 PM
Bayview Village                      Hayward Area Planning Association

Site Improvements - Breakdown by Building Phase
                                                                                                                    Overall                                By Building Phase
Category - Line Item                                                          Units      Unit cost           Qty        Amount              Subtotal       Phase 1       Phase 2   Phase 3       Phase 4
Note 5: Based on civil engineer's estimate dated 1/12/2010, based HydroCAD estimates (10 year event, 3 hour total time event, .01 minute time
intervals) for each courtyard type. and for habitat use. Pipes in cortyward hold storm bursts and trickly off through 4" outlet. There will be about 6
metered low-flow discharge points into the creek with the rest going into walkways and streets.
Note 6: Palisade and Overlook are now public ROW. East of Overlook, the City would abandon Palisade, which would become part of the QV busway.
QV would have an easement with PG&E to use its rOW for the rest of the busway. Overlook from Palisade to Carlos Bee continues as public ROW with
parking on the east side and public travel lanes on the west side. North of Palisade the City would abandon Overlook, which would be used for QV
parking and a drop off lane for rental cars and taxis. At Overlook and Bee, left turns coming uphill onto Overlook would be barred. A left turn lane
would be created for the bus with a signal controlled by the bus allowing it to stop downhill traffic and turn left. At Busway and Bee, traffic signals,
again congtrolled by the bus, would stop downhill traffic and allow the bus to turn left uphill, where it wold go into a new bus merge lane that merges
into Bee. Auto access from the east, downhill on Bee, would turn in at Overlook. Auto access from the west to the Palisade and QV areas would use




8c037106-2338-4492-be16-876d3afc0a89.xls                      Site Imp-Phase                                 17                                                                              4/21/2012 7:40 PM
Phase 5          Phase 6          Phase 7          Phase 8          Phase 9          Phase 10      Phase 11      Checksum



                     $42,000                                            $12,000                                     $120,000
                     $60,000                                            $60,000                                     $240,000
                                                                       $150,000                                     $300,000
                                                                                                                      $6,720
                                                                                                                     $75,000
      $8,571         $40,000            $8,571           $8,571         $30,000           $8,571        $8,571      $200,000
          $576             $576             $576             $576             $576          $576          $640        $6,400
      $5,040           $5,040           $5,040           $5,040           $5,040          $5,040        $5,600       $56,000
    $14,187         $147,616          $14,187          $14,187         $257,616          $14,187       $14,811    $1,004,120



                    $148,000                                            $18,500                                     $370,000
                   $2,304,400                                          $288,050                                   $5,761,000
                    $280,000                                            $35,000                                     $700,000
                     $30,000                                                                                         $30,000
    $29,000                           $14,500          $29,000          $58,000          $43,500       $14,500      $290,000
                                                                                                                      $9,900
                                                                                                                    $140,000
                     $70,750                                            $70,750                                     $283,000
    $29,000        $2,833,150         $14,500          $29,000         $470,300          $43,500       $14,500    $7,583,900



                                                                        $42,181          $42,181       $42,181      $126,544
                                                                        $56,420          $56,420                    $112,840
   $116,388         $116,388         $116,388         $116,388         $116,388         $116,388      $129,320    $1,293,200
                                                                                                                     $85,680
    $16,541          $16,541          $16,541          $16,541          $16,541          $16,541       $18,379      $183,788
                                                                                                                      $2,880
      $1,080           $1,080           $1,080           $1,080           $1,080          $1,080        $1,200       $12,000
   $134,009         $134,009         $134,009         $134,009         $232,610         $232,610      $191,080    $1,816,932




8c037106-2338-4492-be16-876d3afc0a89.xls                      Site Imp-Phase                              18                   4/21/2012 7:40 PM
Phase 5       Phase 6       Phase 7       Phase 8       Phase 9       Phase 10      Phase 11      Checksum




   $141,797      $141,797      $141,797      $141,797      $141,797      $141,797      $157,552    $1,575,520




    $67,840       $67,840       $67,840       $67,840       $67,840       $67,840       $75,378      $753,780




   $237,228      $237,228      $237,228      $237,228      $237,228      $237,228      $263,587    $2,635,867




   $424,917      $424,917      $424,917      $424,917      $424,917      $424,917      $472,130    $4,721,300




8c037106-2338-4492-be16-876d3afc0a89.xls            Site Imp-Phase                         19                   4/21/2012 7:40 PM
Phase 5          Phase 6          Phase 7          Phase 8          Phase 9          Phase 10       Phase 11       Checksum


    $90,720          $90,720          $90,720          $90,720          $90,720          $90,720       $100,800      $1,008,000
                                                                                                                        $45,000
   $166,000                          $332,000                                                                          $830,000
                                                                                                                        $60,000
                                                         $4,000                                                          $4,000
                                                                                                                        $35,000
    $54,000          $54,000          $54,000          $54,000          $54,000          $54,000        $60,000        $600,000
      $1,575           $1,575           $1,575           $1,575           $1,575          $1,575         $1,750         $17,500
          $540             $540             $540             $540             $540          $540           $600          $6,000
      $2,700           $2,700           $2,700           $2,700           $2,700          $2,700         $3,000         $30,000
                                                                                         $20,000                        $40,000
          $450             $450             $450             $450             $450          $450           $500          $5,000
   $250,000                                                            $250,000                                        $750,000
   $565,985         $149,985         $481,985         $153,985         $399,985         $169,985       $166,650      $3,430,500


   $423,395         $423,395         $423,395         $423,395         $423,395         $423,395       $470,438      $4,704,384


  $2,038,358       $4,559,936       $1,939,858       $1,626,358       $2,655,688       $1,755,459     $1,826,127 $0 $28,226,302




8c037106-2338-4492-be16-876d3afc0a89.xls                      Site Imp-Phase                               20                     4/21/2012 7:40 PM
Phase 5    Phase 6    Phase 7    Phase 8     Phase 9    Phase 10   Phase 11    Checksum




8c037106-2338-4492-be16-876d3afc0a89.xls   Site Imp-Phase                 21              4/21/2012 7:40 PM
Bayview Village                                                                                               Hayward Area Planning Association

Project Consultants Background Data
Phase - Consultant                 Work Product                                               Units      Unit $     Qty        Amt          Subtotal

Feasibility Phase Consultants
       Real Estate Investment      Feasibility Package, Pro Forma Financial Statements              LS    $20,000    1          $20,000
       Feasibility Consultant
       Attorney or Finance         Private Placement Memorandum, Business Entity                    LS    $25,000    1          $25,000
       Professional                Formation Documents
       Real Estate Appraiser       Appraisals for quarry site, adjacent houses                Per Rprt     $1,500    15         $22,500
      Marketing Specialist         Marketing Study: Pricing / Absorption Rate                       LS    $10,000    1          $10,000
      Environmental Engineer       Phase 1 Environmental Site Assessment                            LS     $3,000    1           $3,000
      Geotechnical Engineer        Preliminary Report on seismic and soil conditions                LS    $10,000    1          $10,000
      Building Contractor          Provide verification of construction cost estimates              LS     $5,000    1           $5,000
        Subtotal: Feasibility Phase Consultants                                                                                               $95,500

Entitlement Phase Consultants
       Project Manager             Project Management (Note 1)                                Month        $8,000    12         $96,000
      Environmental Planner        Environmental Impact Analysis (Note 2)                     Month       $18,000    12        $216,000
      Biologist                    Biological assessment (Note 3)                             LS          $20,000    1          $20,000
      Arborist                     Tree Survey                                                LS           $5,000    1           $5,000
      Traffic Engineer             Onsite/Offsite Traffic Impacts and Mitigations             LS           $6,000    1           $6,000
      Dry Utility Consultant       Concept Dry Utilities Plan (Note 4)                        LS          $50,000    1          $50,000
      Land Planner                 Site Plan; General Plan Amendment and Zone Change          LS          $10,000    1          $10,000
                                   (Note 5)
      Architect                    Site Plan Illustrations, Streetscapes (Note 6)             LS          $40,000    1          $40,000
      Landscape Architect          Concept landscape plans (Note 7)                        LS             $36,000    1          $36,000 x
      Civil Engineer               Preliminary Grading and Tentative Map, Hydrology Study, LS             $84,500    1          $84,500
                                   Public Utility Study (Note 8)

      Attorney                     Development Agreement                                      LS          $50,000    1          $50,000
      Reimbursables                Plan printing, Photocopies, Courier                        LS          $10,000    1          $10,000
        Subtotal: Entitlement Phase Consultants                                                                                              $517,500


Design Phase Consultants
       Project Manager             Project Management (Note 1)                                Month        $8,000    12         $96,000
      Geotechnical Engineer        Design-Level Geotechnical Report (Note 9)                  LS          $70,000    1          $70,000
      Civil Engineer               Final Map, Civil Improvement Plans (Note 8)                D.U.           $900   1024       $921,600
      Dry Utility Consultant       Joint Trench Plans                                         D.U.           $300   1024       $307,200
      Landscape Architect          Landscaping Construction Documents (Note 7)                D.U.           $200   1024       $204,800
      Biologist                    Permit Applications (Note 10)                              LS          $30,000    1          $30,000
      Structural Engineer          Retaining Wall Plans                                       LS          $30,000    1          $30,000
      DRE Consultant               DRE Applications, Seller's Disclosure Package, HOA         LS          $20,000    1          $20,000
                                   Budget, Bylaws
      Stormwater Specialist        Prepare SWPPP, Stormwater Control Plan                     LS           $8,000    1           $8,000
      Attorney                     Investor Communications, Misc Legal Counsel                LS          $25,000    1          $25,000
      Other                        Other studies, reports, plans as needed                    LS          $30,000    1          $30,000
      Reimbursables                Plan printing, Photocopies, Courier                        LS          $40,000    1          $40,000
        Subtotal: Engineering Phase Consultants                                                                                             $1,782,600


Site Improvement Phase Consultants
        Site Manager              Onsite Project Management (Note 11)                         Quarter     $24,000         32   $768,000
      Attorney                     Investor Communications, Misc Legal Counsel                LS          $25,000          1    $25,000
      Interim HOA Manager          Interim HOA Operations                                     LS           $6,000          1     $6,000
      Construction Staking         Set property corners, construction Staking, As-Built Plans, LS        $350,000          1   $350,000
                                   horizontal control, Grading, Streets and Utilities



8c037106-2338-4492-be16-876d3afc0a89.xls                Proj Team               22                                               4/21/2012       7:40 PM
Bayview Village                                                                                                                     Hayward Area Planning Association

Project Consultants Background Data
Phase - Consultant                       Work Product                                                       Units             Unit $         Qty           Amt          Subtotal

         Civil Engineer                  Observation, Field Revisions to Plans, interim erosion             LS                 $25,000             1       $25,000
                                         controls, manage Best Management Practices (BMPs)

         Dry Utilities Consultant        Coordinates with PGE, SBC, Comcast, Dish, needs to know du                                 $50         950        $47,500
                                         CAT-5, fiberoptic, dish, cable, etc. Street lights
         Geotechnical Monitoring         Observe Grading, Paving, Trench Bedding, etc.           Month                           $6,000          18       $108,000
         HazMat Consultant               Lead/asbestos survey/report prior to demolition                    LS                   $5,000            1         $5,000
         Biologist                       Preconstruction Surveys, construction monitoring                   Year                 $4,000            6       $24,000
         SWPPP Maintenance               Inspect site, Update SWPPP, Prep annual report                     Year                 $3,500            6       $21,000
         Water Laboratory                water sampling                                                     Each                    $50         100          $5,000
         Site Security                   Prevent Theft, Vandalism, Trespassing                              Year               $36,000             8      $288,000
         Landscape Architect             Observe landscaping, Irrigation installation, plant material Year                     $15,000             7      $105,000

         Reimbursables                   Plan Printing, Field Office Supplies, Computers                    LS                 $25,000             1       $25,000
           Subtotal: Site Improvement Phase Consultants                                                                                                                 $1,802,500


             TOTAL: PROJECT CONSULTANTS                                                                                                                                 $4,198,100




Notes:
Note 1: Coordinates other consultants, interfaces with city staff, manages the work, budget and schedule for General Plan Amendment, Zone Change, Site Plan Application,
Grading, Utility and Drainage Plan, Floor Plans and Elevations. Environmental Analysis, Tentative Map, Final Map and Development Agreement. The Site Plan has 11 parts
(listed below); the Project Manager does Site Plan part 11. The Project Manager manages general administrative functions such as accounting, financial anlaysis, insurance. and
legal (except where shown separately) for the whole project. Project manager gets Subdivison Permit, conducts bidding, oversees contracts and executes Operations and
Maintenace Agreement for stormwater with City. Project manager gets "will serve" letters from utilities: PG&E, Comcast/AT&T, and City, and easements and use permits from
PG&E for use of its right-of-way. $12-15k: Art May, Keystone Development Group, Emeryville, phone, 12/21/09


Note 2: Prepares CEQA documents, manages public comment and response. Hayward's 238 Program EIR reviewed this property and approved a designation and zoning in
support of a QV type of project. The EIR covered most issues so a Focused Project EIR would tier off the 238 EIR. Consultnat is hired by city based on bids. Consultant likely to
subcontract with a traffic engineer and may subcontract with a geotechnical engineer, biologist, sound engineer, or archeologist.


Note 3: Biological assessment 6, protocol survey for endangered species 10, wetland delineation 4. Patrick Kobernus, Coast Range Ecology, 415-404-6757, email, 12/25/2009


Note 4: The Dry Utilities Consultant coordinates with PGE, SBC, Comcast, Dish, needs to know CAT-5, fiberoptic, dish, cable, etc. Sunny Antonio, utility consultant at BkF. Plan
includes dry trenching, service to all buildings, and street lights and is integrated into the GUD Plan.
Note 5: Bid by Jill Williams, KTGY, Jan 29 10: site plan, building types, and design (8 building types) - $85,000 to $125,000. Use bldg type 13 x 8= $104k total


Note 6: An architect by rule of thumb would charge 1.5% of building costs for plans, elevations; working/construction drawings; blueprints, floor plans, and construction
support, during entitlement, design, and some inspection of contruction by building contractors. For this project, Zeta (the modular fabricator) acts as consultant for
entitlement and design, including architectural costs. Silverman Dec. 09. 6 unit types, 4 elevations/type = 24 elevations


Note 7: Native, drought resistant landscaping. Estimate by Gary Lamon, The Guzzardo Partnership, SF, 415-433-4672, 12/22/09
Note 8: More detailed scope: Initial Site Review; Topographic and boundary surveys of land streets, utilities, tie-ins, elevations, property lines, and easements; Computer
generated Site Layout , 3 Supplemental Reports: Offsite wet utility adequacy, preliminary hydrology study, preliminary storm water study; Site Plan Application, Grading, Utility
and Drainage (GUD) Plan, Vesting Tentative Map. Design also includes Conditions of Approval, Subdivison Permit, Engineer's Estimate, misc. documents and plans.


Note 9: Letter proposal from Kamran Ghiassi, AGS, Dec. 7, 2009. $83,000 for geotechnical reports: The Phase 1 Environmental Assessment is part of Investment, shown on the
Investment tab. Phase 2 involves one day of drilling of 5 to 6 borings 20 to 30 feet deep, engineering supervision, and lab tests leading to a report with recommendations for
grading, structures, and drainage.

Note 10: Applications to: Army Corps of Engineers, SF Bay Regional Water quality Control Board, CA Dept. of Fish and Game, US Fish and Wildlife Service. Preconstruction
survey, bio-permitting for outfall structures




8c037106-2338-4492-be16-876d3afc0a89.xls                      Proj Team                   23                                                                  4/21/2012       7:40 PM
Bayview Village                                                                                                                    Hayward Area Planning Association

Project Consultants Background Data
Phase - Consultant                       Work Product                                                      Units            Unit $          Qty           Amt          Subtotal

Note 11: Manages property and construction: execution of Site Preparation Plan, consultants, contractors, inspectors and building, to end of project. Manages general
adminstrative functions, including performance bonds, insurance, legal and setting up the initial HOA, and site security. The Site Preparation Plan includes plan for demolitions,
utility relocations, trailer, lay down area, and mobilization of equipment to start work on site.




8c037106-2338-4492-be16-876d3afc0a89.xls                      Proj Team                  24                                                                 4/21/2012        7:40 PM
ning Association




                   8c037106-2338-4492-be16-876d3afc0a89.xls   Proj Team   25   4/21/2012   7:40 PM
ning Association




                   delete "(listed below)"? Add- see bolded additions




                   x




                   x




                   x




                   8c037106-2338-4492-be16-876d3afc0a89.xls             Proj Team   26   4/21/2012   7:40 PM
ning Association




                   8c037106-2338-4492-be16-876d3afc0a89.xls   Proj Team   27   4/21/2012   7:40 PM
Bayview Village                                                                                                                                 Hayward Area Planning Association

Project Level Fees Background Data
Phase - Fee                                                                                                         Units                      Unit $         Qty                 Total


Entitlement Phase Fees (Paragraph # shown from Hayward Master Fee Schedule)
        Pre-application meeting (p.1)                                                                                     LS                   $1,000                 1                   $1,000
        Environmental Assessment Consultant Oversight (p.4) (Note 1) (Note 2)                                         Per hour                   $106                 50                  $5,300
        General Plan Amendment [for area west of Overlook Ave.] (p. 5)                                                Per hour                   $106                 50                  $5,300
        Zone Change (for area west of Overlook Ave.) (p.12e)                                                          Per hour                   $106                 50                  $5,300
        Site Plan Review (includes Planned Develoment fees) (p.13)                                                    Per hour                   $106                500                $53,000
        Vesting Tentative Map (p. 21)                                                                                 Per hour                   $106                500                $53,000
        Development Agreement, filing fee (p. 27)                                                                         LS                      256                  1                    $256
        Development Agreement, staff time to process                                                                  Per hour                   $106                100                $10,600
        Fire District Pre-Application/General Plan Review/Code Assistance                                           application                  $821                  2                  $1,642
        Fire District Planning/Engineering Referrals (HWD)                                                            meeting                    $821                  1                    $821
         Subtotal: Entitlement Fees                                                                                                                                                    $136,219


Design and Site Construction Phases - Fees
        Demolition, Commercial/Residential                                                                            Per bldg                   $365                 10                  $3,650
        City engineering staff - preconstruction services (Note 3)                                                    Per hour                   $106                  6                    $636
        City engineering staff - inspections                                                                          Per hour                   $106               2000               $212,000
        Construction Water                                                                                           {Demand}                                                             $4,000
        2" Irrigation Services                                                                                          Each                 $10,000                   2                $20,000
        Irrigation Water Meters with Radio Read                                                                         Each                 $11,670                   2                $23,340
        Materials Bond                                                                                                 Note 4             $3,915,690                2.5%                $97,892
        Performance Bond                                                                                               Note 5           $24,042,502                 2.5%               $601,063
        Alameda County Flood Control Review                                                                               LS                 $10,000                   1                $10,000
        State Water Board Construction Fee                                                                            Per year                 $1,159                 10                $11,590
        State Water Board Notice of Termination Fee                                                                       LS                     $500                  1                    $500
        Final Map County Recorder’s Fee                                                                                   LS                     $150                  1                    $150
        CC&Rs County Recorder's Fee                                                                                       LS                     $100                  1                    $100
          Subtotal: Engineering/Construction Phases - Fees                                                                                                                             $984,921


             TOTAL: PROJECT LEVEL FEES                                                                                                                                              $1,121,140


Notes
Note 1: The hourly rate for time in the Planning Dept. varies by employee, including benefits, plus an hourly overhead. The $106 (from Fee Schedule p. 31 top) shown is for estimating. The
hourly rate in the Engineering Division varies by employee, including benefits, with no extra hourly overhead. Fire will charge for the Pre-Application meeting. I assume a second meeting
after Fire review of plans. need to see actual charges from large applications from Finance Dept. And Public Works for Wittek, Stonebrae, and Cannery for total time, hourly rate by
employee, on each item by payer for last 5 years.
Note 2: Environmental Assessment: An existing programmatic EIR on State Route 238 Land Use covers the Quarry Village site. The city may require a nested, Focused Project EIR and decide
what issues it will cover.

Note 3: The hourly rate in the Engineering Division varies by employee, including benefits, with no extra hourly overhead. The $106 is from Fee Schedule p. 32 top and is used for
estimating. For public works permits City requires pre-construction conference, not shown in the Fee Schedule. For a subdivision, all improvements shown individually on the Master Fee
Schedule for Engineering Services on pdf pp. 115-117 --clearing, survey, concrete, drainage, street work, utility services, sewers-- are covered. Also covered are items listed for Planning on
pdf 50-51, item 25 Grading Permit Application and item 37. Encroachment Permit Application-- Major Work. Also covered are Fire Service Lines and Fire Hydrants from Fire Prevention pdf
pp. 57-58. Developer submits plans for curbs, gutters, sidewalks, streets, utilities, fire service, hydrants, and grading base rock (cut sheets) to Engineering Services. The Survey Section
inspects pour forms and string lines before pouring of concrete. When work is approved as complete, the City issues a certificate of completion. [Tim Koonze, Jim Lear, Robert Arteaga]


Note 4: A Material Bond is required for 50% of the cost of supplies used for land improvements, e.g., pipes and conduits; bond is assumed to be renewed to cover a 5 year term.

Note 5: A Performance Bond is required for 100% of the cost of the public site improvements (excludes dry utilities); bond is assumed to be renewed to cover a 5 year term.




8c037106-2338-4492-be16-876d3afc0a89.xls                       Proj Fees                                                                                                      4/21/2012           7:40 PM
g Association




                This was in bad place on my Design tab lines 27-29:
                Final Map, improvement plan check, 106/hr, 1,000 hrs, 106k?



                need to add:
                Underground Fire Service Plan Check and inspection, pdf p. 57, per plan, $1,847




                x




                8c037106-2338-4492-be16-876d3afc0a89.xls         Proj Fees                        4/21/2012   7:40 PM
Bayview Village                                                                                                                                              Hayward Area Planning Asso

Building Construction Cost Background Data
RESIDENTIAL BUILDINGS

INPUTS TO CONSTRUCTION COST CALCULATIONS
     Building ID #                                           B1                   B2                 B3                B4                B5                B6                B7
                                                         Studio -             1 Bdrm -          2 Bdrm - Walk- 2 Bdrm 2 Bath -          3 Bdrm            4 Bdrm            5 Bdrm
     Dwelling Unit Description
                                                           Condo                Condo               up Flat       Walk-up Flat        Townhouse         Townhouse         Townhouse

     Qty Dwelling Units by Type                                      40                  150                186               312              170               102                  64
     Living Area each Dwelling Unit                                 411                  530                795               855             1,511             1,715             2,131
     Gross-up for Common Construction (Note 4)                      25%                  25%                 5%               5%                0%                0%                0%
     Gross (Effective) Living Area                                  514                  663                835               898             1,511             1,715             2,131


CONSTRUCTION COSTS
 Costs per s.f. (Note 1)
     Modular Dwelling Unit Fabrication               $            86.21 $              84.88 $            78.84 $           81.24 $           73.89 $           68.98 $           66.94
     Onsite Concrete Foundation                      $            20.00 $              20.00 $             3.67 $            3.67 $           3.67 $            3.67 $             3.67
     Modular Transportation                          $            2.75 $                2.72 $             2.63 $            2.61 $           2.40 $            2.34 $             2.20
     Crane - Modular Placement                       $            1.84 $                1.81 $             1.75 $            1.74 $           1.60 $            1.56 $             1.47
     Onsite Balconies / Exterior Stairs              $            7.20 $                6.79 $             5.89 $            5.69 $           3.47 $            2.77 $             2.77
     Onsite - Structural / Exterior Finish           $            6.00 $                6.00 $             6.00 $            6.00 $           6.00 $            6.00 $             6.00
     Onsite - MEP / Interior Finish                  $            6.00 $                6.00 $             6.00 $            6.00 $           6.00 $            6.00 $             6.00
       Subtotal: Cost per s.f.                       $        130.00 $             128.20 $            104.79 $         106.95 $              97.02 $           91.32 $           89.05
     Contingency (@ 10%)                             $         13.00 $              12.82 $             10.48 $          10.69 $               9.70 $            9.13 $            8.91
        Subtotal: Cost per s.f. with Contingency     $        143.00 $             141.02 $            115.26 $         117.64 $          106.73 $          100.45 $              97.96


     Subtotal: Construction Cost by D.U. Type        $        73,466 $             93,425 $            96,217 $        105,614 $         161,263 $         172,270 $          208,751
     Subtotal: Resid. Const. Cost by Type*Qty        $      2,938,634 $ 14,013,738 $ 17,896,421 $ 32,951,648 $ 27,414,661 $ 17,571,501 $                                   13,360,040


     Subtotal: All Residential Construction


COMMUNITY BUILDINGS (Note 2)
 Shell Space (Note 3)
     Item                                           Units                       Unit $               Qty             Amount
     Spread Footings                                Each                  $        483.75                    40 $       19,350
     Slab on Grade- Bay level                       sf                    $             9.25            14,528 $       134,384
     10' Poured in Place Columns                    Each                  $      1,800.00                    40 $       72,000
     Block Partition Walls                          sf                    $            20.00               6,000 $     120,000
     Concrete Shear Walls at Stairwells, Elev Shaft sf                    $            33.75                900 $       30,375
     Concrete Stairs                                each-per level        $     11,625.00                     2 $       23,250
     Mechanical Elevator                            Each                  $ 107,500.00                        1 $      107,500
     Concrete Headers at Exterior Walls             lf                    $            45.50                800 $       36,400
     Concrete Deck                                  sf                    $            25.00            14,528 $       363,200
     Plumbing rough-in for Restaurant               Each                  $     25,000.00                     2 $       50,000
     Plumbing rough-in for Store                    lump sum              $     12,000.00                     1 $       12,000
     Plumbing rough-in for Community Center         lump sum              $     12,000.00                     1 $       12,000
     Miscellaneous Plumbing                         lump sum              $      5,000.00                     1 $           5,000
     Fire Sprinklers                                sf                    $             2.38            14,528 $        34,613
     Electrical Stubs for Commercial Units          each                  $      5,000.00                     4 $       20,000
     Communications Stubs for Retail                each                  $      2,818.75                     4 $       11,275
     General interior lighting-rough in             sf                    $             3.88            14,528 $        56,296
     General exterior lighting-Rough in             sf                    $             3.19            14,528 $        46,308
     Illuminated signage                            each                  $      2,625.00                     4 $       10,500
     Security Monitoring System                     sf                    $             1.98            14,528 $        28,693
     Fire Alarms/Smoke Detection                    lump sum              $     28,625.00                     1 $       28,625
                                                     each
     Glass/aluminum panel/doors at retail, street side                    $      5,025.00                    24 $      120,600
     Cementious sheathing                           sf                    $             5.86            14,528 $        85,134
     3-coat stucco                                  sf                    $             7.65            14,528 $       111,139
     Exterior Trim                                  lump sum              $     30,000.00                     1 $       30,000
8c037106-2338-4492-be16-876d3afc0a89.xls                 Bldg Costs                        30                                                                   4/21/2012     7:40 PM
Bayview Village                                                                                                                                                       Hayward Area Planning Asso

Building Construction Cost Background Data
       Exterior Paint                                       sf                   $          1.74             14,528 $           25,242
       Exterior Light Fixtures (Residential)                Each                 $       362.50                   48 $          17,400
       Sack/patch/paint concrete stairwell                  sf                   $          2.81                 900 $           2,531
       Insulation (Ceiling)                                 sf                   $          0.76             14,528 $           11,078
       Drop Ceiling                                         sf                   $          2.06             14,528 $           29,964
       Clean-Up and Repairs                                 lump sum                      30,000                    1 $         30,000
                                                                                                                       $    1,684,857
       Contingency @ 20%                                                                                               $      336,971
         Subtotal : Community Shell                                                                                    $    2,021,829
 Community - Other
       Tenant Improvements Community Buildings              sf                   $       125.00              19,613 $       2,451,600
       Carports (Light gauge steel)                         Each                 $     2,850.00                  100 $        285,000


          Subtotal: Community Buildings Construction Cost                                                              $    4,758,429


              TOTAL: BUILDING CONSTRUCTION COST


Notes:
Note 1: Construction unit pricing based on an estimate received from Zeta Communities, a modular construction company.
      Zeta Estimate
      Plan                                                                  B3                 B6
      Area SF                                                              795              1,715
      D.U. Fabrication                                       $          81.91 $            71.60
      Foundation                                             $           3.67 $              3.67
      Transportation                                         $           2.63 $              2.34
      Crane                                                  $           1.75 $              1.56
      Balconies / Exterior Stairs                            $           5.89 $              2.77
      Structure - Structural / Exterior Finish               $           6.00 $              6.00
      Structure - MEP / Interior Finish                      $           6.00 $              6.00
Note 2: The community buildings are the first two floors of the Community Building and the Village Store and Restaurant in the Mixed Use Bldg. They are assumed to be Type 1 reinforced
      concrete, forming the base of podiums upon which wood-frame residential units are placed.
Note 3: Shell space unit pricing based on bid-estimates for a similar project furnished to Jacobson Consulting by San Jose Construction,
      Taisei, Swinerton, D. Ross Construction. Commercial building specification is to be determined; line items shown are for illustrative purposes.
Note 4: Common construction is defined as condominium corridors, stairwells, utility closets, and so forth, or in the case of the walk-up units, the common outdoor stairwell.




8c037106-2338-4492-be16-876d3afc0a89.xls                         Bldg Costs                     31                                                                      4/21/2012   7:40 PM
rd Area Planning Association




                      B8
                   Community
                     Center

                               2
                             900
                            25%
                           1,125     1,125,721




               $           68.98
               $            3.67
               $            2.34
               $            1.56
               $            2.77
               $            6.00
               $            6.00
               $           91.32
               $            9.13
               $        100.45


               $       113,005
               $       226,010


               $ 126,372,651




              8c037106-2338-4492-be16-876d3afc0a89.xls   Bldg Costs   32   4/21/2012   7:40 PM
rd Area Planning Association




               $ 131,131,080


                               x




              8c037106-2338-4492-be16-876d3afc0a89.xls   Bldg Costs   33   4/21/2012   7:40 PM
Bayview Village                                                                                                                                          Hayward Area Planning Association

Green Energy: Construction Cost Background Data
RESIDENTIAL BUILDINGS

INPUTS TO GREEN ENERGY COST CALCULATIONS
     Building ID #                                              B1                  B2                 B3              B4              B5              B6              B7                   B8
                                                             Studio -           1 Bdrm -          2 Bdrm - Walk- 2 Bdrm 2 Bath -      3 Bdrm          4 Bdrm          5 Bdrm             Community
      Building Description
                                                               Condo              Condo               up Flat       Walk-up Flat    Townhouse       Townhouse       Townhouse              Center

      Qty Dwelling Units by Type                                         40                150               186             312             170             102                64                   2
      Living Area each Dwelling Unit                                    411                530               795             855            1,511           1,715           2,131                900


GREEN ENERGY CONSTRUCTION COSTS
 Costs per D.U. (Note 1)
      Extra insulation, moisture barrier, etc.           $        892.07 $         1,021.75 $          1,310.54 $      1,375.93 $      2,090.81 $      2,313.12 $      2,766.46 $           1,424.97
      High efficiency space heating                      $      1,225.00 $         1,225.00 $          1,225.00 $      1,225.00 $      1,225.00 $      1,225.00 $      1,225.00 $           1,225.00
      Solar hot water system                             $      2,723.57 $         3,026.75 $          3,701.91 $      3,854.78 $      5,526.11 $      6,045.86 $      7,105.73 $           3,969.43
      Photovoltaic system                                $     14,833.04 $        15,941.56 $         18,410.11 $     18,969.03 $     25,079.86 $     26,980.18 $     30,855.33 $          19,388.22
         Subtotal: Cost per D.U.                         $     19,673.68 $        21,215.07 $         24,647.56 $     25,424.73 $     33,921.78 $     36,564.16 $     41,952.53 $          36,564.16
      Contingency (@ 10%)                                $      1,967.37 $         2,121.51 $          2,464.76 $      2,542.47 $      3,392.18 $      3,656.42 $      4,195.25 $           3,656.42
         Subtotal: Cost per D.U. with Contingency        $     21,641.05 $        23,336.57 $         27,112.32 $     27,967.20 $     37,313.96 $     40,220.57 $     46,147.78 $          40,220.57


         Subtotal: Cost by D.U. Type*Qty                 $       865,642 $        3,500,486 $         5,042,891 $     8,725,768 $     6,343,373 $     4,102,498 $     2,953,458 $             80,441


      TOTAL: GREEN ENERGY CONSTRUCTION COST                                                                                                                                          $    31,614,558




Notes:
Note 1: Unit pricing based on an estimate received from Zeta Communities, a modular construction company.
      Zeta Estimate
      Plan                                                               B3                  B6
      Area SF                                                           912               1,540                                                                                                          Zeta used 912 and 1,540 as per notes on bldgs tab
      Extra insulation, moisture barrier, etc.           $           1,438 $              2,122
      High efficiency space heating                      $           1,225 $              1,225                                                                                                          New figures are my update; QV Energy.xlsx
      Solar hot water system                             $           4,000 $              5,600                                                                                                          New figures are my update; QV Energy.xlsx
      Photovoltaic system                                $           19,500 $            25,350                                                                                                          New figures are my update; QV Energy.xlsx
                                                                                                                                                                                                         Both subject to change by Davis Energy
                                                                                                                                                                                                         The note 1 #s and the cost per DU now conform e
                                                                                                                                                                                                         I will keep these in sync as we go along.




8c037106-2338-4492-be16-876d3afc0a89.xls                     Bldg Energy                                              34                                                                                        4/21/2012     7:40 PM
12 and 1,540 as per notes on bldgs tab


are my update; QV Energy.xlsx
are my update; QV Energy.xlsx
are my update; QV Energy.xlsx
 to change by Davis Energy
s and the cost per DU now conform exactly to QV energy.xlsx
hese in sync as we go along.




                  8c037106-2338-4492-be16-876d3afc0a89.xls    Bldg Energy   35   4/21/2012   7:40 PM
Bayview Village                                                                                                                                                                                                                            Hayward Area Planning Association

Building Fees Background Data

INPUTS TO FEE CALCULATIONS                                                                                   RESIDENTIAL                                                                                      COMMERCIAL
     Building ID #                                        B1               B2               B3              B4           B5                         B6                  B7              B8-R               B1-C      B8-C                           Totals (Residential Only)
                                                      Studio -         1 Bdrm -          2 Bdrm -    2 Bdrm 2 Bath -       3 Bdrm               4 Bdrm             5 Bdrm            Comm Ctr - Mixed Use-                 Comm Ctr-
      Building Description
                                                        Condo             Condo         Walk-up Flat    Walk-up Flat     Townhouse            Townhouse          Townhouse          Manager Units Stores                  Public Rooms

      Qty Dwelling Units by Type                                  40              150            186               312             170                    102                  64                  2                  1                   1                            1,026
      Conditioned Space each Unit                                411              530            795               855            1,511                  1,715            2,131                  900         8,192               6,336
      Gross-up for Common Construction (Note 4)                  25%            25%               5%               5%               0%                     0%                  0%                25%          35%                    35%
      Gross (Effective) Living Area                              514              663            835               898            1,511                  1,715            2,131              1,125          11,059               8,554

FEE BREAKDOWN
Category - Item                                           B1               B2               B3              B4               B5                     B6                  B7              B8-R               B1-C               B8-C            Information Reference
Production Unit Fees
      Park In-lieu Fee                            $            9,653   $     9,653      $     9,653    $         9,653   $     9,653      $           9,653      $       11,359     $       9,653      $         -        $          -        Hayward Planning Dept. Handout
      Water Meter Installation                    $            2,880   $     2,880      $     2,880    $         2,880   $     2,880      $           2,880      $        3,230     $       2,880      $    3,230         $      3,230 City of Hayward, Master Fee Schedule
      Water Facilities Fee                        $            5,726   $     5,726      $     5,726    $         5,726   $     5,726      $           5,726      $        8,590     $       5,726      $    8,590         $      8,590 City of Hayward, Master Fee Schedule
      Radio Read Upgrade to Water Meter           $              200   $        200     $        200   $          200    $        200     $              200     $           200    $            200   $      200         $          200 City of Hayward, Master Fee Schedule
      Sanitary Sewer Service Connection Fee       $            6,457   $     6,457      $     6,457    $         6,457   $     6,457      $           6,457      $        7,255     $       6,457      $   30,000         $     30,000 City of Hayward, Master Fee Schedule
      State Inspections (Modular)                 $              500   $        500     $        500   $          500    $        500     $              500     $           500    $            500   $      500         $          500 Zeta Communities
      Address Assignment Fee                      $              42    $          42    $        42    $           42    $          42    $                42    $             42   $            42    $             42   $              42 City of Hayward, Master Fee Schedule
      Production Unit Plan Review (Plot Plan)     $              250   $        250     $        250   $          250    $        250     $              250     $           250    $            250   $         -        $          -        City of Hayward, Master Fee Schedule
      Production Unit Inspections (inc. MEP)      $            1,000   $     1,000      $     1,000    $         1,000   $     1,000      $           1,000      $        1,000     $       1,000      $   10,000         $     10,000 City of Hayward, Master Fee Schedule
      Fire Plan Review & Inspecton                $              250   $        250     $        250   $          250    $        250     $              250     $           250    $            250   $    3,000         $      3,000 City of Hayward, Master Fee Schedule
      Fire Alarm System Review & Inspection       $              144   $       144      $       144    $           144   $       144      $             144      $          144     $         144      $    1,400         $      1,400 Fire Alarm System pdf p. 55
      Hayward Unified School District             $            1,053   $     1,358      $     1,711    $         1,840   $     3,098      $           3,516      $        4,369     $       2,306      $    5,530         $      4,277 Hayward USD, Facilities Director
        Subtotal: Fees per Dwelling Unit Type     $         28,155     $    28,460      $    28,813    $     28,942      $    30,199      $          30,617      $       37,188     $      29,408      $   62,492         $     61,239
        Subtotal: Fees by D.U. Type * Qty         $      1,126,196     $ 4,268,974      $ 5,359,206    $   9,029,931     $ 5,133,873      $     3,122,980        $ 2,380,048        $      58,816      $   62,492         $     61,239                                               isn't this enough?


Master Plan Fees
      Incremental Plan Review (Master Set)        $            6,295   $     6,295      $     6,295    $         6,295   $     6,302      $           6,433      $        6,699     $       6,295      $   18,453         $     17,325 City of Hayward, Master Fee Schedule
      Incr. Fire Review (Master Set)              $            1,894   $     1,894      $     1,894    $         1,894   $     1,897      $           1,962      $        2,093     $       1,894      $    7,669         $      6,559 City of Hayward, Master Fee Schedule
        Subtotal: Fees by Dwelling Unit Type      $            8,189   $     8,189      $     8,189    $         8,189   $     8,200      $           8,394      $        8,792     $       8,189      $   26,122         $     23,884

Subtotal: Production and Master Plan Fees         $      1,134,385     $ 4,277,163      $ 5,367,395    $   9,038,120     $ 5,142,072      $     3,131,374        $ 2,388,840        $      67,005      $   88,613         $     85,123
SUBTOTAL: RESIDENTIAL AND COMMERCIAL BUILDING FEES                                                                                                                                                                        $ 30,720,090


Other Miscellaneous Building Dept. Fees                                                                                                                          Units                  Unit $             Qty                Amt             Information Reference
      Carports                                                                                                                                                   Each               $            405          100         $     40,500 City of Hayward, Master Fee Schedule
      Trellises                                                                                                                                                  Each               $            170                 2    $          340 City of Hayward, Master Fee Schedule
      Retaining Walls                                                                                                                                            Per 50 l.f.        $            200                 80   $                                                   Move to Proj Cons?
                                                                                                                                                                                                                                16,000 Average estimate from Master Fee Schedule
      Project Signs                                                                                                                                              Each               $            106                 10   $      1,060 City of Hayward, Master Fee Schedule
      Commercial Signs                                                                                                                                           Each               $            277                 4    $      1,108 City of Hayward, Master Fee Schedule
      Entry Monument                                                                                                                                             Each               $       1,000                     1   $      1,000 Rough Estimate
      Stormwater Treatment Inspections                                                                                                                           Each               $         250                    12   $      3,000 City of Hayward, Master Fee Schedule          Move to Proj Cons?
        Subtotal: Miscellaneous Building Fees                                                                                                                                                                             $     63,008


            TOTAL: ALL BUILDING FEES                                                                                                                                                                                      $ 30,783,098




8c037106-2338-4492-be16-876d3afc0a89.xls          Bldg Fees                                                                                    36                                                                                                                                        4/21/2012        7:40 PM
Bayview Village                                                                                                               Hayward Area Planning Association

Building Consultants Background Data
Phase - Consultant                    Work Product                                                       Units       Unit $         Qty          Amt           Subtotal
Entitlement Phase
      Architect                       Conceptual Plans and Renderings - Buildings                       Building       $8,000             8      $64,000
      Modular Design Expert           Presentation: Modular Design Details Quarry Village                  LS          $8,000             1        $8,000
         Subtotal: Entitlement Phase                                                                                                                                $72,000


Design Phase
                                      D.U. Construction Docs - Res. (included in Zeta hard costs)
      Modular Design Expert                                                                               Plan          $0.00             7             $0

                                      Residential Construction Documents (note 1)
      Architect                                                                                         Building      $10,000             8      $80,000

      Architect                       Commercial/Mixed Use Construction Documents                          SF           $4.50      16,160        $72,720
      Structural Engineering          Commercial/Mixed Use Construction Documents                          SF           $1.13      16,160        $18,180
      Energy Consultant               Commercial/Mixed Use Construction Documents                          SF          $0.36       16,160         $5,818
      Build-It-Green Certifier        Commissioning Docs (greenbuilding rating)                            LS         $25,000            1       $25,000
      Reimbursables                   Printing, photocopies, courier services                              LS         $30,000             1      $30,000
         Subtotal: Engineering Phase                                                                                                                              $231,718


Construction Phase
     Project Manager                  Coordinate permitting, subcontracts, etc. by Zeta                   D.U.           $300         1024      $307,200
      Site Superintendent             Oversee onsite construction                                         Year        $80,000             9     $720,000
      Architect/Structural            Identify and correct design problems                                 LS         $20,000             1      $20,000
      Reimbursables                   Printing, photocopies, courier services                              LS         $25,000             1      $25,000
         Subtotal: Construction Phase (2)                                                                                                                       $1,072,200


             TOTAL: BUILDING CONSULTANTS                                                                                                                        $1,375,918

Note 1: Modular, factory buiilt units. Construction Documents (CDs, blueprints) and shop drawings for residential buildings; Color and Materials Board, Architectural Plans.
Architect of Record, Title 24, subconsultants for structure, solar energy, HVAC, sound, MEP (Mechanical Electrical Plumbing), Lighting Plan and forensic consultation (by
Zeta and Zeta partner KTGY). Jill Williams, KTGY, Jan 29 10 email: Use bldg types 75k x 8 = $600k

Note 2: Cost is allocated to cash flow on a per residential unit basis                                   $1,047




8c037106-2338-4492-be16-876d3afc0a89.xls                        Bldg Team                                                                                4/21/2012        7:40 PM
nning Association




                    x You reduced unit$ from 75k to 10k. If the center and MU bldg
                    have integrated CDs, we would have 2 less building types for
                    residential.
                    x
                    no structural engineering for residential? Architect does it?




                    x




                    8c037106-2338-4492-be16-876d3afc0a89.xls             Bldg Team   4/21/2012   7:40 PM
Bayview Village                                                              Hayward Area Planning Association

Village Bus Background Data
Item                                                 Units            Unit $            Qty                Amt

Diesel-hybrid buses (Note 1)                         Each               $500,000         2                   $1,000,000
Public transit infrastructure (Note 2)               Lump Sum         $1,300,000         1                   $1,300,000
Traffic signal modifications (Note 3)                Lump Sum           $300,000         1                     $300,000
Easement Acquisition busway, PG&E (Note 4)           Each                $50,000         1                      $50,000
  TOTAL: PUBLIC TRANSIT                                                                                      $2,650,000



Notes:
Note 1: Specified are ISE-Thunderbolts or equivalent. Cost includes spare parts. Buses are to be owned
and by the HOA and run by a contract bus operater like MV Transportation for the benefit of
all Quarry Village residents, who ride for free (ecopass). Unit purchase covers capital; HOA fees cover operating.
Note 2: Consists of 14 bus stop shelters, additional raised sidewalk platforms, and ticket vending machines
as is anticipated to be required by a traffic study as part of the environmental impact report.
This infrastructure is anticipated to be both in-tract and off-tract. In-tract busway costs are
captured in the Site Improvements cost estimate.
Note 3: Traffic signals near the project site are anticipated to be modified to speed up
rapid bus traffic in and out of the project. Upgrades include GPS signal control.
Note 4: Right of way use inside the adjacent PG&E overhead transmission line is required for efficient
bus circulation. This cost estimate reflects limited use rights for utility corridors and the benefit to
PG&E from eliminating maintenance costs and significantly reducing liability.




8c037106-2338-4492-be16-876d3afc0a89.xls                 Bus                                                 4/21/2012    7:40 PM
x = minor changes




We don't need 3 and operating is higher also; 2 will do for 8 minute headways. Can be
cut if we need to.


x




x
x




x
x

x
x




8c037106-2338-4492-be16-876d3afc0a89.xls          Bus                                   4/21/2012   7:40 PM
Bayview Village
Gross Margin Analysis by Building Phase
PHASE                                                  Phase 1        Phase 2        Phase 3        Phase 4        Phase 5        Phase 6        Phase 7
Building Breakdown
         Studio - Condo                                        40                0              0              0              0              0              0
         One Bedroom - Condo                                  150                0              0              0              0              0              0
         Two Bedroom - Walkup Flat                              0               36             12              0              6              6             21
         Two Bdrm 2 Bath - Walkup Flat                          0               60             24              6             12              6             21
         Three Bedroom - Townhouse                              0                0             31             39             30             32             34
         Four Bedroom - Townhouse                               0                0             21             20             16             21             22
         Five Bedroom - Townhouse                               0                0              8             19              8             18             10
         Managers' Dwelling Units                                                2
           Subtotal: Residential Units in this Phase          190               98             96             84             72             83          108
         Community Center - Public Rooms                                         1
         Mixed Use - Commercial Space                            1
REVENUE                                                $43,511,310    $25,565,909    $35,443,340    $35,877,922    $28,012,505    $34,446,638    $39,438,757

COSTS
  Land Development Costs
        Land Acquisition (Allocated)                    $5,282,715     $2,724,769     $2,669,161     $2,335,516     $2,001,871     $2,307,712     $3,002,806
        Site Improvements (Assigned) (Note 1)           $3,594,466     $1,688,358     $4,752,336     $1,789,358     $2,038,358     $4,559,936     $1,939,858
        Capitalized Interest (Allocated)                $3,809,961     $1,965,138     $1,925,033     $1,684,404     $1,443,775     $1,664,352     $2,165,662
        Property Taxes & Assessments (Allocated)         $550,823       $284,109       $278,311       $243,522       $208,733       $240,623       $313,100
        Project Level Government Fees (Allocated)        $207,618       $107,087       $104,902        $91,789        $78,676        $90,696       $118,015
        Project Level Consultant Fees (Allocated)        $777,426       $400,988       $392,805       $343,704       $294,604       $339,612       $441,905
           Subtotal: Land Development Costs            $14,223,010     $7,170,449    $10,122,548     $6,488,293     $6,066,017     $9,202,932     $7,981,346


  Building Costs (Assigned)
        Direct Costs - Residential-Base                $16,952,372    $10,026,688    $13,976,161    $14,334,585    $11,108,875    $13,746,569    $15,598,833
        Direct Costs - Green Energy                     $4,366,128     $2,734,517     $3,367,108     $3,304,267     $2,630,411     $3,199,816     $3,771,675
        Direct Costs - Residential-Options               $278,877       $143,842       $140,906       $123,293       $105,680       $121,825       $158,520
        Direct Costs - Commercial/Other                          $0    $4,758,429              $0             $0             $0             $0             $0
        Building Permit Fees                            $5,563,168     $2,929,078     $2,922,495     $2,676,644     $2,217,987     $2,631,427     $3,291,396
        Building Consultant Fees (Allocated)             $254,800       $131,423       $128,741       $112,648        $96,556       $111,307       $144,833
         Subtotal: Building Costs          $27,415,345   $20,723,977   $20,535,411   $20,551,437   $16,159,508   $19,810,945   $22,965,257


 Selling Expenses (Allocated)
       Model Expenses                        $188,889       $97,427       $95,439       $83,509       $71,579       $82,515      $107,368
       Sales Commissions                    $1,073,676     $553,791      $542,489      $474,678      $406,867      $469,027      $610,300
       Broker Coop Fees                      $596,487      $307,662      $301,383      $263,710      $226,037      $260,571      $339,056
       Advertising                            $72,222       $37,251       $36,491       $31,930       $27,368       $31,550       $41,053
       Sellers Closing Costs                 $238,595      $123,065      $120,553      $105,484       $90,415      $104,228      $135,622
         Subtotal: Selling Expenses         $2,169,869    $1,119,195    $1,096,355     $959,310      $822,266      $947,890     $1,233,399


 Other Expenses (Allocated)
       Warranty Reserve                      $596,487      $307,662      $301,383      $263,710      $226,037      $260,571      $339,056
       Insurance                             $417,541      $215,363      $210,968      $184,597      $158,226      $182,399      $237,339
       Village Bus                           $490,741      $253,119      $247,953      $216,959      $185,965      $214,376      $278,947
       Developer Administration/Overhead     $385,185      $198,674      $194,620      $170,292      $145,965      $168,265      $218,947
         Subtotal: Other                    $1,889,953     $974,818      $954,924      $835,558      $716,193      $825,611     $1,074,289



TOTAL COSTS                                $45,698,177   $29,988,440   $32,709,238   $28,834,599   $23,763,984   $30,787,378   $33,254,292


NET INCOME                                 -$2,186,867   -$4,422,530    $2,734,102    $7,043,323    $4,248,521    $3,659,260    $6,184,466
PRETAX PROFIT MARGIN                           -5.03%       -17.30%         7.71%        19.63%        15.17%        10.62%        15.68%
                                 Hayward Area Planning Association




Phase 8        Phase 9        Phase 10        Phase 11         Overall       Checksum

           0              0               0               0             40             40
           0              0               0               0            150            150
          24             33              32              16            186            186
          42             57              54              30            312            312
           4              0               0               0            170            170
           2              0               0               0            102            102
           1              0               0               0             64             64
                                                                         0              2
          73             90              86              46          1,024          1,026



$20,603,790    $23,995,631    $22,910,492     $12,299,100     $322,102,825   $322,105,395




 $2,029,675     $2,502,339     $2,391,123      $1,278,973      $28,526,659    $28,526,659
 $1,626,358     $2,655,688     $1,755,459      $1,826,127      $28,226,302    $28,226,302
 $1,463,827     $1,804,719     $1,724,509       $922,412       $20,573,792    $20,573,792
  $211,632       $260,916       $249,320        $133,357        $2,974,446     $2,974,446
   $79,769        $98,346        $93,975         $50,266        $1,121,140     $1,121,140
  $298,695       $368,254       $351,888        $188,219        $4,198,100     $4,198,100
 $5,709,956     $7,690,261     $6,566,274      $4,399,353      $85,620,440    $85,620,440



 $7,943,355     $9,195,184     $8,782,124      $4,707,905     $126,372,651   $126,372,651
 $2,101,163     $2,488,837     $2,377,823      $1,272,813      $31,614,558    $31,614,558
  $107,147       $132,100       $126,229         $67,518        $1,503,000     $1,505,936
          $0             $0              $0              $0     $4,758,429     $4,758,429
 $2,128,952     $2,603,475     $2,487,713      $1,330,761      $30,783,098    $30,783,098
   $97,897       $120,695       $115,330         $61,688        $1,375,918     $1,375,918
$12,378,514   $14,540,290   $13,889,219    $7,440,685   $196,407,653   $196,410,589



   $72,573       $89,474       $85,497       $45,731      $1,020,000     $1,020,000
  $412,518      $508,583      $485,980      $259,943      $5,797,851     $5,797,851
  $229,176      $282,546      $269,989      $144,413      $3,221,028     $3,221,028
   $27,749       $34,211       $32,690       $17,485       $390,000       $390,000
   $91,671      $113,019      $107,995       $57,765      $1,288,411     $1,288,411
  $833,686     $1,027,832     $982,151      $525,337     $11,717,290    $11,717,290



  $229,176      $282,546      $269,989      $144,413      $3,221,028     $3,221,028
  $160,424      $197,782      $188,992      $101,089      $2,254,720     $2,254,720
  $188,548      $232,456      $222,125      $118,811      $2,650,000     $2,650,000
  $147,992      $182,456      $174,347       $93,255      $2,080,000     $2,080,000
  $726,140      $895,241      $855,453      $457,568     $10,205,748    $10,205,748



$19,648,297   $24,153,625   $22,293,096   $12,822,943   $303,951,132   $303,954,067


  $955,493      -$157,994     $617,396      -$523,842    $18,151,693    $18,151,327
     4.64%        -0.66%         2.69%        -4.26%             6%
Bayview Village              pending                                                                                                                                                             Hayward Area Planning Association

Gross Margin Analysis by Plan

                                                                                                               RESIDENTIAL                                                                         COMMERCIAL                     PROJECT         Checksum
        Building ID #                                B1-R               B2                B3              B4                 B5             B6              B7               B8-R               B1-C        B8-C                  OVERALL
                                                   Studio -         1 Bdrm -         2 Bdrm - Walk- 2 Bdrm 2 Bath -      3 Bdrm            4 Bdrm          5 Bdrm         Comm Ctr -         Mixed Use-         Comm Ctr-
        Building Description
                                                     Condo            Condo              up Flat       Walk-up Flat    Townhouse         Townhouse       Townhouse       Manager Units         Stores          Public Rooms

REVENUE
        Unit Count                                             40              150             186              312               170             102              64                    2                                                1,026
        Residential Sales - Base                     $7,400,000      $33,000,000       $44,640,000     $87,360,000         $68,000,000    $44,880,000     $32,640,000                   $0                                       $317,920,000        317,920,000
        Residential Sales - Options                    $71,392         $267,719           $331,971        $556,854           $303,414       $182,049        $114,227                    $0                                         $1,827,625          1,827,625
        Commercial Sales                                                                                                                                                                       $2,867,200                $0        $2,867,200          2,867,200
        Sales Incentives                               -$20,000         -$75,000           -$93,000       -$156,000           -$85,000       -$51,000        -$32,000                   $0                                          -$512,000           -512,000
          NET REVENUE                                $7,451,392      $33,192,719       $44,878,971     $87,760,854         $68,218,414    $45,011,049     $32,722,227                   $0     $2,867,200                $0      $322,102,825


COSTS
 Land Development Costs
        Footprint per unit (SF)                               103              177             199              285               504             572             710               -              1,664              2,376
        Total Unit Type Impact to Land                   4,110           26,500             36,968          88,920             85,623         58,310          45,461                -              1,664              2,376          349,932
        Proportion Footprint                             1.17%               7.57%          10.56%          25.41%             24.47%         16.66%          12.99%             0.00%             0.48%              0.68%
        Land Acquisition (Allocated by C.A.R.)       $335,049         $2,160,294        $3,013,611       $7,248,806         $6,980,060     $4,753,463      $3,706,032               $0           $135,650          $193,693       $28,526,659         28,526,659
        Site Improvements (Allocated by C.A.R.)      $331,522         $2,137,549        $2,981,880       $7,172,484         $6,906,567     $4,703,414      $3,667,012               $0           $134,222          $191,653       $28,226,302         28,226,302
        Capitalized Interest (allocated by SF)     $375,574.07        $1,816,188        $2,837,613       $5,119,102         $4,694,584     $3,197,040      $2,492,569          $41,121                 $0                $0       $20,573,792         20,573,792
        Property Taxes & Assessments (by C.A.R.)      $34,935          $225,252          $314,226         $755,826           $727,804       $495,639        $386,424                $0            $14,144           $20,196        $2,974,446          2,974,446
        Project Level Government Fees (per unit)       $43,709         $163,909           $203,248        $340,931           $185,764       $111,458         $69,935            $2,185                    $0             $0        $1,121,140          1,121,140
        Project Level Consultant Fees (per unit)      $163,669         $613,757           $761,059       $1,276,615          $695,592       $417,355        $261,870            $8,183                    $0             $0        $4,198,100          4,198,100
          Subtotal: Land Development Costs           $1,284,458       $7,116,950       $10,111,637     $21,913,765         $20,190,372    $13,678,368     $10,583,842          $51,490           $284,016          $405,542       $85,620,440         85,620,440


 Building Costs (Assigned)
        Direct Costs - Residential-Base              $2,938,634      $14,013,738       $17,896,421     $32,951,648         $27,414,661    $17,571,501     $13,360,040         $226,010                                           $126,372,651        126,372,651
        Direct Costs - Green Energy                   $865,642        $3,500,486        $5,042,891       $8,725,768         $6,343,373     $4,102,498      $2,953,458          $80,441                    $0             $0       $31,614,558         31,614,558
        Direct Costs - Residential-Options             $58,711         $220,166          $273,006         $457,945           $249,521       $149,713          $93,938               $0                                             $1,503,000          1,503,000
        Direct Costs - Commercial/Other                                                                                                                                                        $2,379,214         $2,379,214       $4,758,429          4,758,429
        Building Permit Fees                         $1,134,385       $4,277,163        $5,367,395       $9,038,120         $5,142,072     $3,131,374      $2,388,840         $130,013            $88,613           $85,123       $30,783,098         30,783,098
        Building Consultant Fees (Allocated)         $53,642.01      $201,157.54       $249,435.35     $418,407.69         $227,978.55    $136,787.13      $85,827.22        $2,682.10                    $0             $0        $1,375,918          1,375,918
          Subtotal: Building Costs                   $5,051,013      $22,212,710       $28,829,149     $51,591,889         $39,377,606    $25,091,873     $18,882,103         $439,146         $2,467,828         $2,464,337     $196,407,653        196,407,653


 Selling Expenses (Allocated per unit)
        Proportion                                       3.90%           14.62%             18.13%          30.41%             16.57%            9.94%           6.24%           0.19%                0%                 0%
        Model Expenses                                 $39,766         $149,123           $184,912        $310,175           $169,006       $101,404         $63,626            $1,988                    $0             $0        $1,020,000          1,020,000
        Sales Commissions                             $226,037         $847,639         $1,051,072       $1,763,089          $960,658       $576,395        $361,659           $11,302                    $0             $0        $5,797,851          5,797,851
        Broker Coop Fees                              $125,576         $470,911           $583,929        $979,494           $533,699       $320,219        $200,922            $6,279                    $0             $0        $3,221,028          3,221,028
        Advertising                                    $15,205           $57,018           $70,702        $118,596            $64,620        $38,772         $24,327                $760                  $0             $0         $390,000            390,000
        Sellers Closing Costs                          $50,230         $188,364           $233,572        $391,798           $213,479       $128,088         $80,369            $2,512                    $0             $0        $1,288,411          1,288,411
          Subtotal: Selling Expenses                  $456,814        $1,713,054        $2,124,187       $3,563,153         $1,941,461     $1,164,877       $730,903           $22,841                    $0             $0       $11,717,290         11,717,290
                                                                                                                                                                                                                                            $0



8c037106-2338-4492-be16-876d3afc0a89.xls            GMA-Plan                                                          45                                                                                                      4/21/2012    7:40 PM
Bayview Village              pending                                                                                                                           Hayward Area Planning Association

Gross Margin Analysis by Plan
 Other Expenses (Allocated per plan)                                                                                                                                                              $0
     Warranty Reserve                       $125,576      $470,911      $583,929      $979,494           $533,699      $320,219      $200,922      $6,279           $0            $0      $3,221,028         3,221,028
     Insurance                               $87,903      $329,637      $408,750      $685,646           $373,589      $224,153      $140,645      $4,395           $0            $0      $2,254,720         2,254,720
     Village Bus                            $103,314      $387,427      $480,409      $805,848           $439,084      $263,450      $165,302      $5,166           $0            $0      $2,650,000         2,650,000
     Developer Administration/Overhead       $81,092      $304,094      $377,076      $632,515           $344,639      $206,784      $129,747      $4,055           $0            $0      $2,080,000         2,080,000
       Subtotal: Other                      $397,885     $1,492,068    $1,850,165    $3,103,502         $1,691,011    $1,014,607     $636,616     $19,894           $0            $0     $10,205,748        10,205,748
                                                                                                                                                                                                  $0
       NET COSTS                           $7,190,171   $32,534,783   $42,915,137   $80,172,308        $63,200,450   $40,949,725   $30,833,464   $533,371    $2,751,844   $2,869,879    $303,951,132       303,951,132


NET OPERATING INCOME                        $261,221      $657,936     $1,963,834    $7,588,546         $5,017,964    $4,061,324    $1,888,763   -$533,371    $115,356    -$2,869,879   $18,151,693         18,151,693
PRETAX PROFIT MARGIN                           3.51%         1.98%         4.38%         8.65%              7.36%         9.02%         5.77%         N/A        4.02%           N/A




8c037106-2338-4492-be16-876d3afc0a89.xls   GMA-Plan                                               46                                                                                4/21/2012    7:40 PM
Bayview Village                                                                                                                          Hayward Area Planning Association

Quarterly Cash Flow Statement                                         (In 1000 dollar increments)
                                        Property Tax Rate=    1.50%                  Dev. Loan Interest Rate=     8.5%

YEAR                                                         Year 1                                             Year 2                                    Year 3                                     Year 4
QUARTER                                           Q1         Q2           Q3            Q4           Q1         Q2       Q3         Q4         Q1         Q2        Q3         Q4         Q1         Q2
OPERATIONS

Cumulative Residential Units Sold                        0        0              0             0            0        0          0          0          0        0           0          0          0        0

Cash Receipts
  Residential Sales (Base + Options)                   $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0         $0       $0
  Commercial Sales                                              $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0         $0       $0
  Sales Incentives                                     $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0         $0       $0
  Sales Commissions                                    $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0         $0       $0
  Broker Coop Fees                                     $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0         $0       $0
  Sellers Closing Costs                                $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0         $0       $0
Net Sales                                              $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0         $0       $0

Cash Disbursements
  Land Acquisition                                 $1,075      $111         $111           $111         $111      $111    $111       $111      $26,671        $0          $0         $0         $0       $0

  Phase 1 Site Improvements (1)                         $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0    $899        $899
  Phase 2 Site Improvements                             $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0          $0
  Phase 3 Site Improvements                             $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0          $0
  Phase 4 Site Improvements                             $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0          $0
  Phase 5 Site Improvements                             $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0          $0
  Phase 6 Site Improvements                             $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0          $0
  Phase 7 Site Improvements                             $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0          $0
  Phase 8 Site Improvements                             $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0          $0
  Phase 9 Site Improvements                             $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0          $0
  Phase 10 Site Improvements                            $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0          $0
  Phase 11 Site Improvements                            $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0          $0
    Subtotal: Site Improvement Costs                    $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0    $899        $899

  Property Taxes & Assessments                         $0        $0           $0             $0           $0        $0      $0         $0           $0      $209        $0      $209          $0       $209
  Project Level Government Fees                        $0      $136           $0             $0           $0        $0      $0         $0           $0      $985        $0        $0          $0         $0
  Project Level Consultant Fees                       $96      $104         $104           $104         $104      $104      $0         $0         $357      $357      $357      $357        $423        $67
    Subtotal: Land Development Costs               $1,171      $351         $215           $215         $215      $215    $111       $111      $27,027    $1,550      $357      $566      $1,322     $1,174

  Direct Costs - Residential Base                       $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0         $0       $0
  Direct Costs - Energy                                 $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0         $0       $0
  Direct Costs - Residential Options                    $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0         $0       $0
  Direct Costs - Commercial/Other                       $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0         $0       $0
  Building Permit Fees                                  $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0         $0       $0
  Building Consultant Fees                              $0      $36            $36            $0           $0       $0         $0         $0         $0      $58         $58        $58        $58       $0
  Building Construction Loans
    Subtotal: Building Costs                            $0      $36            $36            $0           $0       $0         $0         $0         $0      $58         $58        $58        $58       $0

  Model Expenses                                        $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0          $0
  Advertising                                           $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0         $10
  Warranty Expense                                      $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0          $0
  Insurance                                             $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0      $0          $0
  Village Bus System                                    $0       $0             $0            $0           $0       $0         $0         $0         $0       $0          $0         $0    $530        $530
  Developer Overhead                                   $40      $40            $40           $40          $40      $40        $40        $40        $40      $40         $40        $40     $40         $40
    Subtotal: Selling & Other Expense                  $40      $40            $40           $40          $40      $40        $40        $40        $40      $40         $40        $40    $570        $580
Net Cash Disbursements                             $1,211    $427    $291    $255    $255    $255    $151    $151    $27,067     $1,648     $454      $663     $1,950    $1,754

NET CASH FLOW FROM OPERATIONS                      -$1,211   -$427   -$291   -$255   -$255   -$255   -$151   -$151   -$27,067   -$1,648     -$454     -$663   -$1,950   -$1,754

INVESTING & FINANCING
Equity Investor Cash Flow                          $1,800    $200    $200    $200    $200    $200    $200    $200     $6,505         $0       $0        $0         $0        $0
Development Loan Draw (Paydown)                        $0      $0      $0      $0      $0      $0      $0      $0    $20,562     $1,648     $454      $663     $1,950    $1,754
NET CASH FLOW INVESTING/FINANCING                  $1,800    $200    $200    $200    $200    $200    $200    $200    $27,067     $1,648     $454      $663     $1,950    $1,754

NET CASH FLOW: OVERALL                               $589    -$227    -$91    -$55    -$55    -$55    $49     $49         $0        $0        $0        $0        $0        $0

Cash on Hand                                         $589    $362    $271    $216    $161    $106    $154    $203       $203      $203      $203      $203      $203      $203

DEVELOPMENT LOAN STATUS
  Draw Paid or Payment Received                        $0      $0      $0      $0      $0      $0      $0      $0    $20,562     $1,648     $454      $663     $1,950    $1,754
Interest Account
  Previous Quarter Accrued Interest                    $0      $0      $0      $0      $0      $0      $0      $0         $0        $0      $437       $918    $1,419    $1,945
  Current Quarter Interest Accrual                     $0      $0      $0      $0      $0      $0      $0      $0         $0      $437      $481       $501      $526      $579
  Current Quarter Interest Paid                        $0      $0      $0      $0      $0      $0      $0      $0         $0        $0        $0         $0        $0        $0
  Current Quarter Accrued Interest                     $0      $0      $0      $0      $0      $0      $0      $0         $0      $437      $918     $1,419    $1,945    $2,524
Principal Account
  Previous Quarter Principal                           $0      $0      $0      $0      $0      $0      $0      $0         $0    $20,562   $22,211   $22,665   $23,329   $25,279
  Draw                                                 $0      $0      $0      $0      $0      $0      $0      $0    $20,562     $1,648      $454      $663    $1,950    $1,754
  Paydown (less interest paid)                         $0      $0      $0      $0      $0      $0      $0      $0         $0         $0        $0        $0        $0        $0
  Current Principal Balance                            $0      $0      $0      $0      $0      $0      $0      $0    $20,562    $22,211   $22,665   $23,329   $25,279   $27,033
Development Loan Balance                               $0      $0      $0      $0      $0      $0      $0      $0    $20,562    $22,648   $23,583   $24,748   $27,224   $29,557
               Loan IRR (should equal int. rate)     8.5%

EQUITY
Equity Investment (Total Cash Outflows)            $9,705
Equity ROI                                          10.5%
Present Value of Equity Cash Flow                  $1,800    $195    $190    $186    $181    $177    $172    $168     $5,328        $0        $0        $0        $0        $0
Sum of Present Values of Equity Cash Flow               0
                               Year 5                                   Year 6                                     Year 7                                     Year 8
Q3        Q4        Q1         Q2       Q3         Q4        Q1         Q2        Q3         Q4         Q1         Q2        Q3         Q4         Q1         Q2         Q3


      0         0          0        0         26        52         78      104         130        156        182      208         234        260        286      312          338


     $0        $0        $0       $0    $8,119     $8,119    $8,119     $8,119    $8,119     $8,119     $8,119     $8,119    $8,119     $8,119     $8,119     $8,119     $8,119
     $0        $0        $0       $0        $0         $0        $0         $0        $0         $0         $0         $0        $0         $0         $0         $0     $2,867
     $0        $0        $0       $0      ($13)      ($13)     ($13)      ($13)     ($13)      ($13)      ($13)      ($13)     ($13)      ($13)      ($13)      ($13)      ($13)
     $0        $0        $0       $0     ($147)     ($147)    ($147)     ($147)    ($147)     ($147)     ($147)     ($147)    ($147)     ($147)     ($147)     ($147)     ($147)
     $0        $0        $0       $0      ($82)      ($82)     ($82)      ($82)     ($82)      ($82)      ($82)      ($82)     ($82)      ($82)      ($82)      ($82)      ($82)
     $0        $0        $0       $0      ($33)      ($33)     ($33)      ($33)     ($33)      ($33)      ($33)      ($33)     ($33)      ($33)      ($33)      ($33)      ($33)
     $0        $0        $0       $0    $7,844     $7,844    $7,844     $7,844    $7,844     $7,844     $7,844     $7,844    $7,844     $7,844     $7,844     $7,844    $10,711


     $0        $0         $0       $0         $0        $0         $0       $0          $0         $0         $0       $0          $0         $0         $0       $0           $0

 $899      $899           $0       $0         $0        $0         $0       $0        $0         $0         $0         $0          $0       $0         $0         $0         $0
   $0        $0           $0       $0         $0        $0         $0       $0      $422       $422       $422       $422          $0       $0         $0         $0         $0
   $0        $0           $0       $0         $0        $0         $0       $0        $0         $0         $0         $0          $0   $1,188     $1,188     $1,188     $1,188
   $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         $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        $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         $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           $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         $0          $0       $0         $0         $0         $0
 $899      $899           $0       $0         $0        $0         $0       $0      $422       $422       $422       $422          $0   $1,188     $1,188     $1,188     $1,188

   $0       $209          $0     $209         $0     $198          $0     $188        $0       $177         $0       $167          $0     $156         $0       $145         $0
   $0         $0          $0       $0         $0       $0          $0       $0        $0         $0         $0         $0          $0       $0         $0         $0         $0
  $67        $67         $67      $67        $67      $67         $67      $67       $67        $67        $67        $67         $67      $67        $67        $67        $67
 $965     $1,174         $67     $276        $67     $265         $67     $255      $489       $666       $489       $655         $67   $1,411     $1,255     $1,400     $1,255

     $0        $0   $1,070     $2,139   $3,209     $3,209    $3,209     $3,209    $3,209     $3,209     $3,209     $3,209    $3,209     $3,209     $3,209     $3,209     $3,209
     $0        $0     $268       $535     $803       $803      $803       $803      $803       $803       $803       $803      $803       $803       $803       $803       $803
     $0        $0      $13        $25      $38        $38       $38        $38       $38        $38        $38        $38       $38        $38        $38        $38        $38
     $0        $0       $0         $0       $0         $0        $0         $0        $0         $0         $0         $0      $793       $793       $793       $793       $793
     $0        $0     $261       $521     $782       $782      $782       $782      $782       $782       $782       $782      $782       $782       $782       $782       $782
     $0        $0      $27        $27      $27        $27       $27        $27       $27        $27        $27        $27       $27        $27        $27        $27        $27

     $0        $0   $1,638     $3,248   $4,858     $4,858    $4,858     $4,858    $4,858     $4,858     $4,858     $4,858    $5,651     $5,651     $5,651     $5,651     $5,651

   $0        $0       $495        $15      $15        $15       $15        $15       $15        $15        $15        $15       $15        $15        $15        $15        $15
  $10       $10        $10        $10      $10        $10       $10        $10       $10        $10        $10        $10       $10        $10        $10        $10        $10
   $0        $0         $0         $0       $0        $82       $82        $82       $82        $82        $82        $82       $82        $82        $82        $82        $82
   $0        $0        $57        $57      $57        $57       $57        $57       $57        $57        $57        $57       $57        $57        $57        $57        $57
 $530      $530       $530         $0       $0         $0        $0         $0        $0         $0         $0         $0        $0         $0         $0         $0         $0
  $40       $40        $40        $40      $40        $40       $40        $40       $40        $40        $40        $40       $40        $40        $40        $40        $40
 $580      $580     $1,132       $122     $122       $204      $204       $204      $204       $204       $204       $204      $204       $204       $204       $204       $204
 $1,545    $1,754    $2,837    $3,646    $5,047        $5,328    $5,129    $5,317    $5,551    $5,728    $5,551    $5,718    $5,922    $7,266    $7,110    $7,256    $7,110

-$1,545   -$1,754   -$2,837   -$3,646    $2,796        $2,516    $2,715    $2,527    $2,293    $2,115    $2,293    $2,126    $1,922     $578      $734      $588     $3,601


     $0        $0        $0        $0        $0         -$500        $0        $0        $0     -$500        $0        $0        $0     -$500        $0        $0        $0
 $1,545    $1,754    $2,837    $3,646   -$2,796       -$2,016   -$2,715   -$2,527   -$2,293   -$1,615   -$2,293   -$2,126   -$1,922      -$78     -$734     -$588   -$3,601
 $1,545    $1,754    $2,837    $3,646   -$2,796       -$2,516   -$2,715   -$2,527   -$2,293   -$2,115   -$2,293   -$2,126   -$1,922     -$578     -$734     -$588   -$3,601

    $0        $0        $0        $0        $0            $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0

  $203      $203      $203      $203      $203          $203      $203      $203      $203      $203      $203      $203      $203      $203      $203      $203      $203


 $1,545    $1,754    $2,837    $3,646   -$2,796       -$2,016   -$2,715   -$2,527   -$2,293   -$1,615   -$2,293   -$2,126   -$1,922      -$78     -$734     -$588   -$3,601

 $2,524    $3,152    $3,826    $4,552    $5,354        $3,453    $2,293      $409       $0        $0        $0        $0        $0        $0      $533      $421       $452
   $628      $674      $726      $802      $896          $856      $831      $791     $754      $721      $702      $669      $638      $610      $622      $619       $620
     $0        $0        $0        $0    $2,796        $2,016    $2,715    $1,200     $754      $721      $702      $669      $638       $78      $734      $588     $1,072
 $3,152    $3,826    $4,552    $5,354    $3,453        $2,293      $409        $0       $0        $0        $0        $0        $0      $533      $421      $452         $0

$27,033   $28,578   $30,333   $33,169   $36,815       $36,815   $36,815   $36,815   $35,488   $33,950   $33,056   $31,466   $30,008   $28,724   $28,724   $28,724   $28,724
 $1,545    $1,754    $2,837    $3,646        $0            $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0
     $0        $0        $0        $0        $0            $0        $0   -$1,327   -$1,538     -$894   -$1,590   -$1,457   -$1,284        $0        $0        $0   -$2,529
$28,578   $30,333   $33,169   $36,815   $36,815       $36,815   $36,815   $35,488   $33,950   $33,056   $31,466   $30,008   $28,724   $28,724   $28,724   $28,724   $26,196
$31,730   $34,159   $37,721   $42,169   $40,268       $39,108   $37,224   $35,488   $33,950   $33,056   $31,466   $30,008   $28,724   $29,257   $29,145   $29,176   $26,196




    $0        $0        $0        $0        $0          -$311       $0        $0        $0      -$282       $0        $0        $0      -$255       $0        $0        $0


                                                  `
                      Year 9                                     Year 10                                    Year 11                                    Year 12
Q4         Q1         Q2        Q3         Q4         Q1         Q2        Q3         Q4         Q1         Q2        Q3         Q4         Q1         Q2        Q3         Q4


     364        390      416         442        468        494      520         546        572        598      624         650        676        702      728         754        780


$8,119     $8,119     $8,119    $8,119     $8,119     $8,119     $8,119    $8,119     $8,119     $8,119     $8,119    $8,119     $8,119     $8,119     $8,119    $8,119     $8,119
    $0         $0         $0        $0         $0         $0         $0        $0         $0         $0         $0        $0         $0         $0         $0        $0         $0
  ($13)      ($13)      ($13)     ($13)      ($13)      ($13)      ($13)     ($13)      ($13)      ($13)      ($13)     ($13)      ($13)      ($13)      ($13)     ($13)      ($13)
 ($147)     ($147)     ($147)    ($147)     ($147)     ($147)     ($147)    ($147)     ($147)     ($147)     ($147)    ($147)     ($147)     ($147)     ($147)    ($147)     ($147)
  ($82)      ($82)      ($82)     ($82)      ($82)      ($82)      ($82)     ($82)      ($82)      ($82)      ($82)     ($82)      ($82)      ($82)      ($82)     ($82)      ($82)
  ($33)      ($33)      ($33)     ($33)      ($33)      ($33)      ($33)     ($33)      ($33)      ($33)      ($33)     ($33)      ($33)      ($33)      ($33)     ($33)      ($33)
$7,844     $7,844     $7,844    $7,844     $7,844     $7,844     $7,844    $7,844     $7,844     $7,844     $7,844    $7,844     $7,844     $7,844     $7,844    $7,844     $7,844


      $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         $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         $0         $0        $0         $0         $0         $0        $0         $0         $0         $0        $0         $0         $0         $0        $0           $0
  $447       $447       $447      $447         $0         $0         $0        $0         $0         $0         $0        $0         $0         $0         $0        $0           $0
    $0         $0         $0      $510       $510       $510       $510        $0         $0         $0         $0        $0         $0         $0         $0        $0           $0
    $0         $0         $0        $0         $0         $0     $1,140    $1,140     $1,140     $1,140         $0        $0         $0         $0         $0        $0           $0
    $0         $0         $0        $0         $0         $0         $0        $0         $0       $485       $485      $485       $485         $0         $0        $0           $0
    $0         $0         $0        $0         $0         $0         $0        $0         $0         $0         $0        $0       $407       $407       $407      $407           $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         $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
  $447       $447       $447      $957       $510       $510     $1,650    $1,140     $1,140     $1,625       $485      $485       $892       $407       $407      $407           $0

  $135         $0       $124        $0       $113         $0       $103        $0        $92         $0        $82        $0        $71         $0        $60        $0          $50
    $0         $0         $0        $0         $0         $0         $0        $0         $0         $0         $0        $0         $0         $0         $0        $0           $0
   $67        $67        $67       $67        $67        $67        $67       $67         $0         $0         $0        $0         $0         $0         $0        $0           $0
  $649       $514       $638    $1,024       $690       $576     $1,819    $1,207     $1,232     $1,625       $567      $485       $963       $407       $467      $407          $50

$3,209     $3,209     $3,209    $3,209     $3,209     $3,209     $3,209    $3,209     $3,209     $3,209     $3,209    $3,209     $3,209     $3,209     $3,209    $3,209     $3,209
  $803       $803       $803      $803       $803       $803       $803      $803       $803       $803       $803      $803       $803       $803       $803      $803       $803
   $38        $38        $38       $38        $38        $38        $38       $38        $38        $38        $38       $38        $38        $38        $38       $38        $38
  $793         $0         $0        $0         $0         $0         $0        $0         $0         $0         $0        $0         $0         $0         $0        $0         $0
  $782       $782       $782      $782       $782       $782       $782      $782       $782       $782       $782      $782       $782       $782       $782      $782       $782
   $27        $27        $27       $27        $27        $27        $27       $27        $27        $27        $27       $27        $27        $27        $27       $27        $27

$5,651     $4,858     $4,858    $4,858     $4,858     $4,858     $4,858    $4,858     $4,858     $4,858     $4,858    $4,858     $4,858     $4,858     $4,858    $4,858     $4,858

   $15        $15        $15       $15        $15        $15        $15       $15        $15        $15        $15       $15        $15        $15        $15       $15        $15
   $10        $10        $10       $10        $10        $10        $10       $10        $10        $10        $10       $10        $10        $10        $10       $10        $10
   $82        $82        $82       $82        $82        $82        $82       $82        $82        $82        $82       $82        $82        $82        $82       $82        $82
   $57        $57        $57       $57        $57        $57        $57       $57        $57        $57        $57       $57        $57        $57        $57       $57        $57
    $0         $0         $0        $0         $0         $0         $0        $0         $0         $0         $0        $0         $0         $0         $0        $0         $0
   $40        $40        $40       $40        $40        $40        $40       $40        $40        $40        $40       $40        $40        $40        $40       $40        $40
  $204       $204       $204      $204       $204       $204       $204      $204       $204       $204       $204      $204       $204       $204       $204      $204       $204
 $6,504    $5,577    $5,701    $6,086    $5,752    $5,639    $6,882    $6,269    $6,295    $6,687    $5,629    $5,547    $6,025    $5,469   $5,529    $5,469    $5,112

 $1,340    $2,267    $2,143    $1,758    $2,092    $2,205     $962     $1,575    $1,549    $1,157    $2,215    $2,297    $1,819    $2,375   $2,314    $2,375    $2,732


  -$500        $0        $0        $0     -$500        $0        $0        $0     -$500        $0        $0        $0     -$500        $0        $0        $0     -$500
  -$840   -$2,267   -$2,143   -$1,758   -$1,592   -$2,205     -$962   -$1,575   -$1,049   -$1,157   -$2,215   -$2,297   -$1,319   -$2,375   -$2,314   -$2,375   -$2,232
-$1,340   -$2,267   -$2,143   -$1,758   -$2,092   -$2,205     -$962   -$1,575   -$1,549   -$1,157   -$2,215   -$2,297   -$1,819   -$2,375   -$2,314   -$2,375   -$2,732

    $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0

  $203      $203      $203      $203      $203      $203      $203      $203      $203      $203      $203      $203      $203      $203      $203      $203      $203


  -$840   -$2,267   -$2,143   -$1,758   -$1,592   -$2,205     -$962   -$1,575   -$1,049   -$1,157   -$2,215   -$2,297   -$1,319   -$2,375   -$2,314   -$2,375   -$2,232

    $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0
  $557      $551      $514      $480      $452      $428      $390      $378      $353      $338      $321      $280      $238      $215      $169      $123       $75
  $557      $551      $514      $480      $452      $428      $390      $378      $353      $338      $321      $280      $238      $215      $169      $123       $75
    $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0

$26,196   $25,913   $24,196   $22,567   $21,289   $20,149   $18,372   $17,801   $16,604   $15,908   $15,089   $13,195   $11,179   $10,098    $7,937    $5,791    $3,540
     $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0        $0
  -$283   -$1,717   -$1,629   -$1,278   -$1,139   -$1,777     -$572   -$1,196     -$696     -$818   -$1,894   -$2,016   -$1,081   -$2,160   -$2,146   -$2,252   -$2,156
$25,913   $24,196   $22,567   $21,289   $20,149   $18,372   $17,801   $16,604   $15,908   $15,089   $13,195   $11,179   $10,098    $7,937    $5,791    $3,540    $1,383
$25,913   $24,196   $22,567   $21,289   $20,149   $18,372   $17,801   $16,604   $15,908   $15,089   $13,195   $11,179   $10,098    $7,937    $5,791    $3,540    $1,383




  -$231       $0        $0        $0      -$209       $0        $0        $0      -$189       $0        $0        $0      -$171       $0        $0        $0     -$155
           Year 13                                    Year 14                                   Year 15                        Cumulative
Q1         Q2        Q3         Q4         Q1         Q2        Q3         Q4         Q1        Q2        Q3         Q4


     806      832         858        884        910      936         962        988     1014      1024     1024       1024              884


$8,119     $8,119    $8,119     $8,119     $8,119     $8,119    $8,119     $8,119     $8,119    $3,123         $0         $0       $276,032
    $0         $0        $0         $0         $0         $0        $0         $0         $0        $0         $0         $0         $2,867
  ($13)      ($13)     ($13)      ($13)      ($13)      ($13)     ($13)      ($13)      ($13)      ($5)        $0         $0          -$442
 ($147)     ($147)    ($147)     ($147)     ($147)     ($147)    ($147)     ($147)     ($147)     ($57)        $0         $0        -$5,005
  ($82)      ($82)     ($82)      ($82)      ($82)      ($82)     ($82)      ($82)      ($82)     ($31)        $0         $0        -$2,781
  ($33)      ($33)     ($33)      ($33)      ($33)      ($33)     ($33)      ($33)      ($33)     ($13)        $0         $0        -$1,112
$7,844     $7,844    $7,844     $7,844     $7,844     $7,844    $7,844     $7,844     $7,844    $3,017         $0         $0       $269,559


      $0       $0          $0         $0         $0       $0          $0         $0        $0       $0          $0        $0        $28,527

    $0         $0        $0         $0         $0         $0        $0         $0         $0        $0          $0        $0         $3,594
    $0         $0        $0         $0         $0         $0        $0         $0         $0        $0          $0        $0         $1,688
    $0         $0        $0         $0         $0         $0        $0         $0         $0        $0          $0        $0         $4,752
    $0         $0        $0         $0         $0         $0        $0         $0         $0        $0          $0        $0         $1,789
    $0         $0        $0         $0         $0         $0        $0         $0         $0        $0          $0        $0         $2,038
    $0         $0        $0         $0         $0         $0        $0         $0         $0        $0          $0        $0         $4,560
    $0         $0        $0         $0         $0         $0        $0         $0         $0        $0          $0        $0         $1,940
    $0         $0        $0         $0         $0         $0        $0         $0         $0        $0          $0        $0         $1,626
  $664       $664      $664       $664         $0         $0        $0         $0         $0        $0          $0        $0         $2,656
    $0         $0      $439       $439       $439       $439        $0         $0         $0        $0          $0        $0           $878
    $0         $0        $0         $0         $0         $0      $457       $457       $457      $457          $0        $0             $0
  $664       $664    $1,103     $1,103       $439       $439      $457       $457       $457      $457          $0        $0        $28,226

    $0        $39        $0        $29         $0        $18        $0         $7         $0        $0          $0        $0         $2,974
    $0         $0        $0         $0         $0         $0        $0         $0         $0        $0          $0        $0         $1,121
    $0         $0        $0         $0         $0         $0        $0         $0         $0        $0          $0        $0         $4,198
  $664       $703    $1,103     $1,131       $439       $457      $457       $464       $457      $457          $0        $0        $65,047

$3,209     $3,209    $3,209     $3,209     $3,209     $3,209    $3,209     $2,550     $1,481      $411          $0        $0       $112,304
  $803       $803      $803       $803       $803       $803      $803       $638       $370      $103          $0        $0        $28,095
   $38        $38       $38        $38        $38        $38       $38        $30        $18        $5          $0        $0         $1,336
    $0         $0        $0         $0         $0         $0        $0         $0         $0        $0          $0        $0         $4,758
  $782       $782      $782       $782       $782       $782      $782       $621       $361      $100          $0        $0        $27,356
   $27        $27       $27        $27        $27        $27       $27        $10         $0        $0          $0        $0         $1,284

$4,858     $4,858    $4,858     $4,858     $4,858     $4,858    $4,858     $3,851     $2,230      $619          $0        $0       $175,133

   $15        $15       $15        $15        $15        $15       $15        $15         $0        $0          $0        $0         $1,020
   $10        $10       $10        $10        $10        $10       $10        $10         $0        $0          $0        $0           $390
   $82        $82       $82        $82        $82        $82       $82        $82        $82       $82         $31        $0         $2,699
   $57        $57       $57        $57        $57        $57       $57        $22         $0        $0          $0        $0         $2,061
    $0         $0        $0         $0         $0         $0        $0         $0         $0        $0          $0        $0         $2,650
   $40        $40       $40        $40        $40        $40       $40        $40        $40        $0          $0        $0         $2,080
  $204       $204      $204       $204       $204       $204      $204       $169       $122       $82         $31        $0        $10,900
$5,726    $5,766   $6,165   $6,194   $5,501    $5,519    $5,519    $4,483    $2,808    $1,158      $31         $0    $251,079

$2,118    $2,078   $1,679   $1,650   $2,343    $2,325    $2,325    $3,361    $5,036    $1,859      -$31        $0


     $0      $0       $0    -$500       $0        $0        $0    -$12,807      $0        $0        $0    -$10,224
-$1,413      $0       $0       $0       $0        $0        $0          $0      $0        $0        $0          $0
-$1,413      $0       $0    -$500       $0        $0        $0    -$12,807      $0        $0        $0    -$10,224

  $705    $2,078   $1,679   $1,150   $2,343    $2,325    $2,325    -$9,447   $5,036    $1,859      -$31   -$10,224

  $908    $2,986   $4,665   $5,815   $8,158   $10,482   $12,807    $3,361    $8,396   $10,256   $10,224        $0


-$1,413      $0       $0       $0       $0        $0        $0         $0       $0        $0        $0         $0

    $0       $0       $0       $0       $0        $0        $0         $0       $0        $0        $0         $0
   $29       $0       $0       $0       $0        $0        $0         $0       $0        $0        $0         $0
   $29       $0       $0       $0       $0        $0        $0         $0       $0        $0        $0         $0     $20,574
    $0       $0       $0       $0       $0        $0        $0         $0       $0        $0        $0         $0

 $1,383      $0       $0       $0       $0        $0        $0         $0       $0        $0        $0         $0
     $0      $0       $0       $0       $0        $0        $0         $0       $0        $0        $0         $0
-$1,383      $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       $0       $0        $0        $0         $0       $0        $0        $0         $0




    $0       $0       $0    -$140       $0        $0        $0     -$3,589      $0        $0        $0     -$2,865
Bayview Village                               Hayward Area Planning Association

Event Timing Worksheet
INPUT - ASSUMPTION
Build Cycle(Quarters, Note 1)        2
Absorption Rate (2)                26
% Sales triggering next phase     80%                        TYPICAL BUILD CYCLE
                                  Yr   Qtr                Quarter      1     2   3   4
Start of Sales (Year, Quarter)       4    1          Loan Draw(%) 50% 50%
Entitlements Obtained (4)            2    1

YEAR                                  Year 1       Year 2       Year 3                                Year 4
QUARTER                           Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1
                                    1   2    3 4 5   6    7 8 9  10    11 12 13
Housing Starts, First Pass
Housing Units Remaining                 1024 1024 1024 1024 1024 1024 1024 1024 1024 1024 1024 1024
Housing Starts
First Quarter W.I.P.
Second Quarter W.I.P.
Third Quarter W.I.P.
Fourth Quarter W.I.P.
Housing Completions
Cumulative Housing Completions


Entitlements Obtained                                                           1
Phase Construction Starts
Phase 1                                                                                           1
Phase 2
Phase 3
Phase 4
Phase 5
Phase 6
Phase 7
Phase 8
Phase 9
Phase 10
Phase 11


Commercial Start
Commercial Completion

Site Construction Period (Qtrs)    27

Notes:
Note 1: Allowable range is from 1 to 4 quarters
Note 2: Units sold per quarter, must be higher than 10 units
Note 3: Computed Phase Triggers are (cum units completed):
    Phase 1                             Entitlements plus 1 year
    Phase 2                               152
    Phase 3                              268.4
    Phase 4                              364.8
    Phase 5                              460.8
    Phase 6                              544.8
    Phase 7                               617
    Phase 8                               700
    Phase 9                               808
    Phase 10                              881
    Phase 11                              971

Note 4: Minimum time allowed is 1 year + 2 quarters
UNIT QUANTITY BY PHASE
Ph 1 Ph 2 Ph 3 Ph 4 Ph 5 Ph 6 Ph 7 Ph 8 Ph 9 Ph 10 Ph 11
 190    98   96    84  72   83 108    73   90   86    46


 Year 4          Year 5          Year 6          Year 7          Year 8
 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
  14    15 16 17  18    19 20 21  22    23 24 25  26    27 28 29  30    31 32
              26  26    26 26 26  26    26 26 26  26    26 26 26  26    26 26
1024 1024 1024   998   972   946   920   894   868   842   816   790   764   738   712   686   660   634   608
                 26    26     26   26    26    26    26    26    26    26    26    26    26    26    26    26
                       26     26   26    26    26    26    26    26    26    26    26    26    26    26    26
                              26   26    26    26    26    26    26    26    26    26    26    26    26    26



                              26   26    26    26    26    26    26    26    26    26    26    26    26    26
                              26   52    78    104   130   156   182   208   234   260   286   312   338   364




                                                      1
                                                                                    1
                                                                                                            1




                                                                        1
                                                                                                1
                                                            702
                                                            702

                                                            17

    Year 9          Year 10          Year 11          Year 12          Year 13
Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3
 33  34    35 36 37  38     39 40 41  42     43 44 45  46     47 48 49  50     51
 26  26    26 26 26  26     26 26 26  26     26 26 26  26     26 26 26  26     26
582   556   530   504   478   452   426   400   374   348   322   296   270   244   218   192   166   140   114
 26   26    26    26    26     26   26    26    26    26    26    26    26    26    26    26    26    26    26
 26   26    26    26    26     26   26    26    26    26    26    26    26    26    26    26    26    26    26
 26   26    26    26    26     26   26    26    26    26    26    26    26    26    26    26    26    26    26



 26   26    26    26    26     26   26    26    26    26    26    26    26    26    26    26    26    26    26
390   416   442   468   494   520   546   572   598   624   650   676   702   728   754   780   806   832   858




             1
                                1
                                                 1
                                                                   1
                                                                                                 1
                                                                                                             1
       Year 14          Year 15
Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4
 52 49  50     51 52 49  50     51 52
 26 26  26     26 26                                     <-- remove $B6
 88   62    36    10
 26   26    26    26    10                        1024
 26   26    26    26    26   10                   1024
 26   26    26    26    26   26    10             1024



 26   26    26    26    26   26    10             1024
884   910   936   962   988 1014 1024 1024 1024




                   1

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:4/22/2012
language:Latin
pages:61