| B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Lincoln Library Decarbonization Options | Lincoln Library In-Kind Replacement Options | |||||||||||||||||||||||||||
2 | JANUARY 2026 GSHP+ | JULY 2026 GSHP+ | AUGUST 2026 GSHP+ | Total Variance | Notes | JANUARY 2026 CONVENTIONAL | JULY 2026 CONVENTIONAL | AUGUST 2026 CONVENTIONAL (Updated with NE Engineering Project Costs) | Variance | Notes | |||||||||||||||||||
3 | Proposal Scope Elements | Well Drilling | $511,799 | $405,711 | $384,210 | -$127,589 | Well drilling. External GC work. | $0 | $0 | $0 | $0 | NA for conventional boiler replacement | |||||||||||||||||
4 | Interior HVAC | $4,203,942 | $2,786,092 | $2,054,452 | -$2,149,490 | Electrical transformer and generator work may also be required, pending results of Megger test. See below.* | $1,833,526 | $1,283,468 | $1,194,045 | -$639,481 | New VAV's, ERV in attic, replace AHU2,3, electrical upgrade. View details HERE | ||||||||||||||||||
5 | New Electrical Transfomer | $0 | $0 | $40,000 | $40,000 | Not detailed in prior budgets. Replaces current transformer with a 150kVA cluster transformer on the existing pole. | $0 | $0 | $0 | $0 | Carried below only if required by Megger test | ||||||||||||||||||
6 | ADA | $200,000 | $398,198 | $430,900 | $230,900 | Triggered by MAAB. All ADA items flagged are included here, though we belief that items #8 and #12 are quite likely to be waived (~$32k, in addition to several items), we are seeking meeting with MAAB to determine ADA variances alongside Town Building Inspector. | $200,000 | $398,198 | $430,900 | $230,900 | Triggered by MAAB. All ADA items flagged are included here, though we belief that items #8 and #12 are quite likely to be waived (~$32k, in addition to several items), we are seeking meeting with MAAB to determine ADA variances alongside Town Building Inspector. | ||||||||||||||||||
7 | Building Envelope | $235,134 | $43,380 | $43,380 | -$191,754 | Formally "Misc ECM's". Door and window weather stripping and caulking, air sealing and thermal barrier coating in accessible attic space. | $235,134 | $43,380 | $43,380 | -$191,754 | Door and Window weather stripping and caulking, air sealing and thermal barrier coating in accessible attic space. | ||||||||||||||||||
8 | Flat Roof Replacement | $0 | $0 | $0 | $0 | $88,665. OPTIONAL | $0 | $0 | $0 | $0 | $88,665. OPTIONAL | ||||||||||||||||||
9 | Fire Alarm | $0 | $0 | $0 | $0 | $443,327. OPTIONAL | $0 | $0 | $0 | $0 | $443,327. OPTIONAL | ||||||||||||||||||
10 | Design Fee (30% drawings) | $0 | $0 | $266,640 | $266,640 | Not detailed in prior budgets. Initial evaluation to bid document set. | $0 | $0 | $0 | $0 | Included in interior HVAC. | ||||||||||||||||||
11 | Construction Drawing Set | $0 | $0 | $486,501 | $486,501 | Not detailed in prior budgets. Includes engineering, electrical, ADA, MAAB application. | $0 | $0 | $0 | $0 | Included in interior HVAC. | ||||||||||||||||||
12 | Project-Level Costs | $0 | $1,744,191 | $1,744,191 | $1,744,191 | Program cost structure; Investment Grade Energy Audit & Proposal, Engineering, Project Management, On-site construction management, Commissioning, Training, Measurement & Verification, Cost of Risk, Payment and performance bonds, Travel, Site Conditions, Construction interest, Hazardous Waste, Grant Support, Overhead & Profit. | $0 | $862,523 | $835,149 | $835,149 | Development and delivery costs like professional services, management, construction support, testing, financial protections, and contractor overhead and profit.  | ||||||||||||||||||
13 | Base Scope Project Value ($) | $5,150,875 | $5,377,572 | $5,450,274 | $299,399 | This includes all items deemed neccessary to the project that cannot potentially be reduced through variance. See below for grants & incentives (confirmed and potential). | $2,268,660 | $2,587,570 | $2,503,474 | $234,814 | |||||||||||||||||||
14 | |||||||||||||||||||||||||||||
15 | To be determined by Eversource during the week of 9/7/26 | Technical Assistance Study | $0 | $0 | $9,000 | $9,000 | Required by Eversource to confirm / approve custom incentives. During a meeting with ESG and PowerOptions on Fri. 9/4/26, Eversource tentatively agreed to front the cost of any needed TA study (~$9,000) to approve custom incentives for the project. This may allow Eversource to complete a preliminary evaluation of possible custom incentives and provide a conservative estimate ahead of Town Meeting. | $0 | $0 | $0 | $0 | NA for conventional replacement. | |||||||||||||||||
16 | New Transformer Pole and Feeders | $0 | $0 | $120,000 | $120,000 | Megger test results expected in mid-September to determine whether or not this expense is needed or can be reduced. May also be eligible for ITC credits. | $0 | $0 | $160,000 | $160,000 | This is an estimate of both the new electrical transformer ($40K), as well as the pole and feeders ($120K). Megger test results expected in mid-September to determine whether or not this expense is needed or can be reduced. May also be eligible for ITC credits. | ||||||||||||||||||
17 | New Emergency Generator | $0 | $0 | $368,900 | $368,900 | Megger test results expected in mid-Sept. that would determine if this may be triggered. Would require follow up discussion with Building Inspector and Brandon to determine generator requirements / interpretation. | $0 | $0 | $368,900 | $368,900 | Megger test would also determine if a generator is required. | ||||||||||||||||||
18 | Budget Contingency | $250,000 | $268,879 | $297,409 | $47,409 | Assumed 5% contingency for ESG due to CM at Risk model. | $113,433 | $258,757 | $250,347 | $136,914 | Assumed 5% contingency back in January. 10% contingency in July and August. | ||||||||||||||||||
19 | |||||||||||||||||||||||||||||
20 | Total Project Value | $5,400,875 | $5,646,451 | $6,245,583 | $844,708 | Total Project Costs BEFORE incentives | $2,382,093 | $2,846,326 | $3,282,721 | $900,628 | Total Project Value BEFORE incentives. | ||||||||||||||||||
21 | |||||||||||||||||||||||||||||
22 | Incentives & Grants | Investment Tax Credit (ITC via Direct Pay) | $1,674,088 | $1,150,000 | $1,150,000 | -$524,088 | Based on 25.5% confirmed for ESG (per Energy Tax Savers) | $0 | $0 | $0 | $0 | NA in conventional project | |||||||||||||||||
23 | ITC Bonus | $0 | $400,000 | $400,000 | $400,000 | Based on 34% total (or an additional 8.5%) for ESG. | $0 | $0 | $0 | $0 | NA in conventional project | ||||||||||||||||||
24 | Climate Leader Decarbonization Accelerator Grant | $1,000,000 | $1,000,000 | $1,000,000 | $0 | If we start over, we may need to reapply for this money, but it would remain available. | $0 | $0 | $0 | $0 | NA in conventional project | ||||||||||||||||||
25 | Mass Save Rebates | $260,729 | $0 | $0 | -$260,729 | App $129,600 based on $3,600/ton. After performing Technical Assistance (TA) study w 50% match from Town, see TA Study line item above. | $0 | $0 | $0 | $0 | NA in conventional project | ||||||||||||||||||
26 | META Grant | $0 | $0 | $0 | $0 | Applied for up to $15,000 in assistance for TA Study. | $0 | $0 | $0 | $0 | NA in conventional project | ||||||||||||||||||
27 | Mass Cultural Grant | $0 | $0 | $0 | $0 | Potential $200,000 grant available | $0 | $0 | $0 | $0 | NA in conventional project | ||||||||||||||||||
28 | Total Est. Incentives & Grants | $2,934,817 | $2,550,000 | $2,550,000 | -$384,817 | Total Incentives & Grants (that have been awarded or confirmed very likely) | $0 | $0 | $0 | $0 | NA in conventional project | ||||||||||||||||||
29 | |||||||||||||||||||||||||||||
30 | Net Project Value ($) October 2026 | $2,466,058 | $3,096,451 | $3,695,583 | $1,229,525 | Total Project Value AFTER incentives. | $2,382,093 | $2,846,326 | $3,282,721 | $900,628 | Total Project Value AFTER incentives. | ||||||||||||||||||
31 | |||||||||||||||||||||||||||||
32 | Net project value with inflation (Assuming 3.5% if project is sent out to market and pushed to Spring 2027) | $2,655,089 | $3,294,077 | $3,914,178 | $1,259,089 | Inflation modeled at 3.5% increase in total project value (inflation, increases in labor and equipment, etc.) minus incentives. ESG at 0% if contract can be executed by October 31, 2026. | $2,465,466 | $2,945,948 | $3,397,617 | $932,150 | August inflation modeled at 7% of total project value, but ultimately depends on when work is undertaken. Could be less if all done next year. | ||||||||||||||||||
33 | |||||||||||||||||||||||||||||
34 | Annual Cost Savings | Energy ($) | $12,360 | $12,360 | $2,196 | -$10,164 | Energy cost savings estimates based on ESG modeling. This does not take into effect any rate change based on demand. | $1,494 | $1,494 | $3,848 | $2,354 | These are based on ESG analysis | |||||||||||||||||
35 | O&M ($) | -$4,723 | -$4,723 | -$4,722 | $1 | OPTIONAL: After Year 1 (ESG included 1 year of O&M) . Library currently does not have an O&M contract but has spent an average of $12,061 over last three years) ($16,783 new spend - $12,061 old spend = $4722 net new cost) . ESG can help you bid this in Year 2. I its recommended but only required with a performance guarantee. | $0 | $0 | -$8,078 | -$8,078 | OPTIONAL: These are based on ESG analysis ($20,139-12,061=$8,078.60 . Cost to maintain convential is more than GSHP by about 20%. Will be required with a performance guarantee. | ||||||||||||||||||
36 | M&V ($) | $0 | $0 | -$5,990 | -$5,990 | OPTIONAL After Year 1 (ESG included 1year of M&V at no additional charge). Will work with Beth on final scope to present. Will be required with a performance guarantee. | $0 | $0 | -$5,990 | -$5,990 | OPTIONAL After Year 1 (ESG included 1year of M&V at no additional charge). Will work with Beth on final scope to present. Will be required with a performance guarantee. | ||||||||||||||||||
37 | Total ($) | $7,637 | $7,637 | -$8,516 | -$16,153 | $1,494 | $1,494 | -$10,220 | -$11,714 | ||||||||||||||||||||
38 | |||||||||||||||||||||||||||||
82 | Estimated Annual Debt Service | Financing Information | Original CPC Vote January 2026 | Revised Estimate August 2026 | Variance | ||||||||||||||||||||||||
83 | Total Authorization-Original | $4,400,875 | $5,245,583 | $844,708 | |||||||||||||||||||||||||
84 | Net Project Cost to Bond | $2,466,058 | $3,695,583 | $1,229,525 | |||||||||||||||||||||||||
85 | |||||||||||||||||||||||||||||
86 | BAN -one year interest only | $118,000 | $131,140 | $13,140 | Revised BAN based on total project cost less $1,000,000 climate leader received | ||||||||||||||||||||||||
87 | Permanent -20 Yr borrowing -Aug | $180,000 | $280,422 | $100,422 | 4.35% interest rate per MMD | ||||||||||||||||||||||||
88 | |||||||||||||||||||||||||||||
89 | |||||||||||||||||||||||||||||
90 | |||||||||||||||||||||||||||||
91 | |||||||||||||||||||||||||||||
92 | |||||||||||||||||||||||||||||
93 | |||||||||||||||||||||||||||||
94 | |||||||||||||||||||||||||||||
95 | |||||||||||||||||||||||||||||
96 | |||||||||||||||||||||||||||||
97 | |||||||||||||||||||||||||||||
98 | |||||||||||||||||||||||||||||
99 | |||||||||||||||||||||||||||||
100 | |||||||||||||||||||||||||||||
101 | |||||||||||||||||||||||||||||
102 | |||||||||||||||||||||||||||||
103 | |||||||||||||||||||||||||||||
104 | |||||||||||||||||||||||||||||
105 | |||||||||||||||||||||||||||||
106 | |||||||||||||||||||||||||||||
107 | |||||||||||||||||||||||||||||
108 | |||||||||||||||||||||||||||||
109 | |||||||||||||||||||||||||||||
110 | |||||||||||||||||||||||||||||
111 | |||||||||||||||||||||||||||||
112 | |||||||||||||||||||||||||||||
113 | |||||||||||||||||||||||||||||
114 | |||||||||||||||||||||||||||||
115 | |||||||||||||||||||||||||||||
116 | |||||||||||||||||||||||||||||
117 | |||||||||||||||||||||||||||||
118 | |||||||||||||||||||||||||||||
119 | |||||||||||||||||||||||||||||
120 | |||||||||||||||||||||||||||||
121 | |||||||||||||||||||||||||||||
122 | |||||||||||||||||||||||||||||
123 | |||||||||||||||||||||||||||||
124 | |||||||||||||||||||||||||||||
125 | |||||||||||||||||||||||||||||
126 | |||||||||||||||||||||||||||||
127 | |||||||||||||||||||||||||||||
128 | |||||||||||||||||||||||||||||
129 | |||||||||||||||||||||||||||||
130 | |||||||||||||||||||||||||||||
131 | |||||||||||||||||||||||||||||
132 | |||||||||||||||||||||||||||||
133 | |||||||||||||||||||||||||||||
134 | |||||||||||||||||||||||||||||
135 | |||||||||||||||||||||||||||||
136 | |||||||||||||||||||||||||||||
137 | |||||||||||||||||||||||||||||
138 | |||||||||||||||||||||||||||||
139 | |||||||||||||||||||||||||||||
140 | |||||||||||||||||||||||||||||
141 | |||||||||||||||||||||||||||||
142 | |||||||||||||||||||||||||||||
143 | |||||||||||||||||||||||||||||