| 
  Model: | 
  Middle
  Value Firm | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
 
 
  | Assumptions
  for All Models: | 
    | 
   | 
 
 
   | 
  Projects are a 2 phase investment | 
   | 
 
 
   | 
  The first phase begins
  operation in January 2010, and is completed in 2011. | 
   | 
 
 
   | 
  The second phase begins
  in January 2015 and is completed in 2016. | 
   | 
 
 
   | 
  The same tax abatement is
  offered for both phases. | 
   | 
 
 
   | 
  Land is sold, not
  donated, to investing firm.  Proceeds
  go to City. | 
   | 
 
 
   | 
   | 
   | 
 
 
  | Project
  Summary: | 
    | 
   | 
   | 
   | 
 
 
   | 
  Capital Investment in Plant: | 
  $50,000,000  | 
   | 
   | 
   | 
 
 
   | 
  Annual Local Expenditures by Firm: | 
  $3,000,000  | 
   | 
   | 
   | 
 
 
   | 
  New Jobs: | 
                    
  500  | 
   | 
   | 
   | 
 
 
   | 
  Average Wage per Job: | 
  $44,000  | 
   | 
   | 
   | 
 
 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  Average Value of Home Purchased: | 
  $217,105  | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  Total New Households in City and County: | 
                    
  411  | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  City Revenue per Firm Employee Household: | 
  $0  | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  Additional Jobs in City and County: | 
                     422  | 
   | 
   | 
   | 
 
 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  Tax Abatement/s Offered: | 
  80% | 
   | 
   | 
   | 
 
 
   | 
  Length of Tax Abatement/s: | 
   10
  Years  | 
   | 
   | 
   | 
 
 
   | 
  Number of Abatements: | 
                         2  | 
   | 
   | 
   | 
 
 
   | 
  Value of Tax Abatements, Total: | 
  $12,104,371  | 
   | 
   | 
   | 
 
 
   | 
  Value of All Incentives Offered: | 
  $12,104,371  | 
   | 
   | 
   | 
 
 
   | 
  Value of All Incentives per Job: | 
  $24,209  | 
   | 
   | 
   | 
 
 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  Returns for Jurisdictions: | 
  City | 
  County | 
   | 
   | 
   | 
 
 
   | 
  Revenues | 
  $37,861,852  | 
  $30,944,494  | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  Costs | 
  $29,336,487  | 
  $20,122,410  | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  Revenue Stream, Pre-Incentives | 
  $8,525,365  | 
  $10,822,084  | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  Value of Incentives Offered | 
  $2,734,200  | 
  $3,353,809  | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  Revenue Stream with Incentives | 
  $5,791,165  | 
  $7,468,275  | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  Returns for Jurisdictions, Discounted: | 
  City | 
  County | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  Discount Rate | 
  6.25% | 
   | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  Discounted Cash Flow, Before Incentives | 
  $3,255,096  | 
  $4,759,040  | 
   | 
   | 
   | 
   | 
 
 
   | 
  Benefit/Cost Ratio, Before Incentives | 
                    1.22  | 
                  1.47  | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
  Discounted Cash Flow, After Incentives | 
  $1,567,224  | 
  $2,688,672  | 
   | 
   | 
   | 
   | 
 
 
   | 
  Benefit/Cost Ratio, After Incentives | 
  1.10  | 
  1.22  | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
   
  
   | 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
  Lawrence Discounted Cash Flow | 
  Pre-Incentives | 
  Post-Incentives | 
   | 
 
 
   | 
  Years 1-5 | 
  ($304,568) | 
  ($708,074) | 
   | 
 
 
   | 
  Years 6-10 | 
  ($49,577) | 
  ($829,883) | 
   | 
 
 
   | 
  Years 11-15 | 
  $843,922  | 
  $458,050  | 
   | 
 
 
   | 
  Years 16+ | 
  $2,620,694  | 
  $2,620,694  | 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
   
  
   | 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
  Douglas County Discounted Cash Flow | 
  Pre-Incentives | 
  Post-Incentives | 
   | 
 
 
   | 
  Years 1-5 | 
  $352,397  | 
  ($142,549) | 
   | 
 
 
   | 
  Years 6-10 | 
  $534,733  | 
  ($422,402) | 
   | 
 
 
   | 
  Years 11-15 | 
  $905,340  | 
  $438,434  | 
   | 
 
 
   | 
  Years 16+ | 
  $2,811,420  | 
  $2,811,420  | 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
  | Appendix 1: Sources of Revenue and Costs as a Share of
  Revenue | 
   | 
 
 
   | 
 
 
  | Revenue
  Source | 
  City | 
  County | 
   | 
 
 
   | 
  Property tax from Households | 
  11.5% | 
  21.7% | 
   | 
 
 
   | 
  Property tax from Firm | 
  31.1% | 
  46.7% | 
   | 
   | 
   | 
 
 
   | 
  Sales Taxes from Residents and Employees | 
  27.7% | 
  10.3% | 
   | 
   | 
   | 
 
 
   | 
  Sales Taxes from Firm | 
  4.5% | 
  1.4% | 
   | 
   | 
   | 
 
 
   | 
  Franchise Fees, Households | 
  5.6% | 
   | 
 
 
   | 
  Franchise Fees, Firm | 
  3.0% | 
   | 
 
 
   | 
  Other | 
  16.6% | 
  19.9% | 
   | 
 
 
   | 
  Total, Revenues | 
  100.0% | 
  100.0% | 
   | 
 
 
   | 
 
 
   | 
  Costs as Share of Revenue | 
   | 
 
 
   | 
  Capital Costs, Households | 
  2.7% | 
  0.5% | 
   | 
 
 
   | 
  Capital Costs, Firm | 
  7.8% | 
  6.9% | 
   | 
 
 
   | 
  Operating Costs, Residents | 
  31.8% | 
  30.2% | 
   | 
 
 
   | 
  Operating Costs, Indirect Employment | 
  15.4% | 
  12.6% | 
   | 
 
 
   | 
  Operating Costs, Firm | 
  19.6% | 
  14.9% | 
   | 
 
 
   | 
  Infrastructure on the Firm's Property | 
  0.0% | 
  0.0% | 
   | 
 
 
   | 
  sub-total, costs | 
  77.3% | 
  64.9% | 
   | 
 
 
   | 
 
 
   | 
  Abatements | 
  7.2% | 
  10.8% | 
   | 
 
 
  |   | 
  Other Incentives | 
  0.0% | 
  0.0% | 
   | 
 
 
  | Total,
  Costs as Share of Revenue | 
  84.5% | 
  75.8% | 
   | 
 
 
   | 
   | 
   | 
   | 
   | 
 
 
   
  
   | 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
   | 
   | 
   | 
   | 
 
 
   | 
   | 
   | 
 
 
   | 
   | 
   | 
 
 
   | 
  Sensitivity Analysis | 
  City Change in Benefits | 
  County Change in Benefits | 
   | 
   | 
   | 
 
 
   | 
  10 additional indirect jobs | 
  ($51,324) | 
  ($50,143) | 
   | 
   | 
   | 
 
 
   | 
  Tax abatement increase of 1% | 
  ($21,098) | 
  ($25,880) | 
   | 
   | 
   | 
 
 
   | 
  10 additional direct jobs | 
  $6,293  | 
  $11,182  | 
   | 
   | 
   | 
 
 
   | 
  $1,000,000 additional capital investment | 
  $74,133  | 
  $90,139  | 
   | 
   | 
   | 
 
 
   | 
  $1,000 additional wages to direct employees | 
  $151,550  | 
  $95,738  | 
   | 
   | 
   | 
 
 
   | 
  1 mill increase in property taxes | 
  $212,689  | 
  $230,063  | 
   | 
 
 
   | 
   | 
   | 
 
 
   | 
   | 
   | 
 
 
   | 
   | 
   | 
 
 
   | 
   | 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
   | 
 
 
 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   | 
   |