Attachment_8_Exhibit_8-3.xlsx
XLSX spreadsheet 30 KB Posted
- Attached to
- Solar PV Energy Phase VIII - CDCR
- Solicitation number
- 0000000049
- Issued by
- California
About this file
This document is a price bid form and associated exhibits for a state and local contract opportunity. The contract is for the supply of renewable energy to the state over a 20-year term, with a project commercial operation date in 2016. The bidder is required to provide an annual site output of 2,000,000 kWh, with a bid price of $0.0800/kWh, and a projected 0% annual degradation rate. The benchmark electricity price used for the savings calculation starts at $0.0857/kWh in the first year and escalates at 3.50% annually.
The pricing exhibits detail the projected costs and savings over the 20-year contract term, including the bidder's annual system costs of $160,000 and the avoided utility costs based on the benchmark electricity price. The net present value of the estimated savings over the contract term is $1,647,024 at a 4.50% discount rate. The documents also include the bidder's contact information and an authorized signature.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| GTC-610.doc | DOC document | |
| Final_PPA_Template_1-6-2016.docx | DOCX document | |
| Phase_VIII_Addendum_1__01-13-2016.doc | DOC document | |
| Phase_VIII_QnA_1_22_16.docx | DOCX document | |
| Final_SLA_Template_1-6-2016.docx | DOCX document | |
| Attachment_8_Exhibit_8-2.xlsx | XLSX spreadsheet | |
| Phase_VIII_CDCR_RFP_01-13-2016.doc | DOC document | |
| Attachment_8_Exhibit_8-1.xls | XLS spreadsheet |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
NPV Savings
ATTACHMENT 8 - PROPOSAL FORM 2 – PRICE BID FORM
Exhibit 8-3: Projected Costs and Savings
Host Facility Name: ** SAMPLE **
| = inputs by Bidder. Bidder may not change any other cell. | |||||
| State Discount Rate for NPV | 4.50% | Name of Bidder: | |||
| Years of Analysis | 20 | Date: | |||
| Utility Tariff | Authorized Signature: | ||||
| Benchmark Price (based on) | 2015 | $0.080 |
DGSAU: This rate does not represent the actual rate paid by HOST This value is simply used to drive the savings formula below in cell D43.
| Print Name: | |||
| Background CPI | 2.50% | ||
| Real IOU escalation | 1.00% | ||
| Total annual IOU escalation | 3.50% | ||
| Project COD Year | 2016 |
| PROPOSER'S BID INPUTS | |||||
| Bid Price | |||||
| Start Price | $/kWh | $0.0800 | Exhibit 8-2: Annual Site Output and Pricing Profile | ||
| First Full Year EEP (kWh) | kWh | 2,000,000 | Exhibit 8-2: Annual Site Output and Pricing Profile | ||
| Annual Degradation | % | 0.00% | Exhibit 8-2: Annual Site Output and Pricing Profile |
| Contract year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | ||||
| In/out | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||
| Contract Year ending in: | ||||||||||||||||||||||||
| NPV @ 4.5% | Totals | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | |||
| Base Case Assumptions | ||||||||||||||||||||||||
| CPI | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | 2.50% | ||||
| CPI index | 1.000 | 1.025 | 1.051 | 1.077 | 1.104 | 1.131 | 1.160 | 1.189 | 1.218 | 1.249 | 1.280 | 1.312 | 1.345 | 1.379 | 1.413 | 1.448 | 1.485 | 1.522 | 1.560 | 1.599 | ||||
| Real utility price escalation | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | 1.0% | ||||
| Benchmark electricity price | $ 0.0857 | $ 0.0887 | $ 0.0918 | $ 0.0950 | $ 0.0983 | $ 0.1018 | $ 0.1053 | $ 0.1090 | $ 0.1128 | $ 0.1168 | $ 0.1209 | $ 0.1251 | $ 0.1295 | $ 0.1340 | $ 0.1387 | $ 0.1436 | $ 0.1486 | $ 0.1538 | $ 0.1592 | $ 0.1648 |
| Expected PV Performance | |||||||||||||||||||||||
| Net kWh sold to State (Q) | 40,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | ||
| Bid price/kWh (P) | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | $ 0.0800 | |||
| Proposer's Costs to State | $ 2,081,270 | $ 3,200,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 | $ 160,000 |
| Benchmark Costs for Same Quantities of Electricity | |||||||||||||||||||||||
| Avoided utiity price | $ 0.0857 | $ 0.0887 | $ 0.0918 | $ 0.0950 | $ 0.0983 | $ 0.1018 | $ 0.1053 | $ 0.1090 | $ 0.1128 | $ 0.1168 | $ 0.1209 | $ 0.1251 | $ 0.1295 | $ 0.1340 | $ 0.1387 | $ 0.1436 | $ 0.1486 | $ 0.1538 | $ 0.1592 | $ 0.1648 | |||
| Quantities delivered from system per above | 40,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | 2,000,000 | ||
| Avoided Benchmark Costs | $2,998,543 | $ 4,847,024 | $ 171,396 | $ 177,395 | $ 183,604 | $ 190,030 | $ 196,681 | $ 203,565 | $ 210,689 | $ 218,064 | $ 225,696 | $ 233,595 | $ 241,771 | $ 250,233 | $ 258,991 | $ 268,056 | $ 277,438 | $ 287,148 | $ 297,198 | $ 307,600 | $ 318,366 | $ 329,509 |
Savings from proposal $ 917,273 $ 1,647,024 $ 11,396 $ 17,395 $ 23,604 $ 30,030 $ 36,681 $ 43,565 $ 50,689 $ 58,064 $ 65,696 $ 73,595 $ 81,771 $ 90,233 $ 98,991 $ 108,056 $ 117,438 $ 127,148 $ 137,198 $ 147,600 $ 158,366 $ 169,509
| Cumulative Costs & Savings | |||||||||||||||||||||
| Benchmark costs | 171,396 | 348,791 | 532,395 | 722,424 | 919,105 | 1,122,670 | 1,333,359 | 1,551,423 | 1,777,119 | 2,010,714 | 2,252,485 | 2,502,718 | 2,761,709 | 3,029,765 | 3,307,203 | 3,594,351 | 3,891,549 | 4,199,149 | 4,517,515 | 4,847,024 | |
| Proposer's costs | 160,000 | 320,000 | 480,000 | 640,000 | 800,000 | 960,000 | 1,120,000 | 1,280,000 | 1,440,000 | 1,600,000 | 1,760,000 | 1,920,000 | 2,080,000 | 2,240,000 | 2,400,000 | 2,560,000 | 2,720,000 | 2,880,000 | 3,040,000 | 3,200,000 | |
| Estimated savings - nominal | 11,396 | 28,791 | 52,395 | 82,424 | 119,105 | 162,670 | 213,359 | 271,423 | 337,119 | 410,714 | 492,485 | 582,718 | 681,709 | 789,765 | 907,203 | 1,034,351 | 1,171,549 | 1,319,149 | 1,477,515 | 1,647,024 |
| NOTE: Exhibit 8-1 is to be completed, printed, signed and submitted with proposal. | ||
| Host Facility Name: | ** SAMPLE ** |
| Project COD Year | 2016 |
| Start Price | $0.0800 |
| First Full Year EEP (kWh) | 2,000,000 |
| Annual Degradation | 0.00% |
Estimated Annual Costs System Costs 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 160000 Utility Costs 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 171396 177394.86 183603.68009999997 190029.80890349997 196680.85221512243 203564.68204265172 210689.44591414451 218063.57652113956 225695.80169937943 233595.15475885768 241770.98517541768 250232.96965655728 258991.12359453674 268055.81292034552 277437.76637255761 287148.08819559711 297198.27128244296 307600.21077732847 318366.21815453493 329509.03578994359 Estimated Cumulative Costs System Costs 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 160000 320000 480000 640000 800000 960000 1120000 1280000 1440000 1600000 1760000 1920000 2080000 2240000 2400000 2560000 2720000 2880000 3040000 3200000 Utility Costs 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 171396 348790.86 532394.54009999998 722424.34900349996 919105.20121862239 1122669.8832612741 1333359.3291754187 1551422.9056965583 1777118.7073959378 2010713.8621547953 2252484.8473302131 2502717.8169867704 2761708.9405813073 3029764.7535016527 3307202.5198742105 3594350.6080698078 3891548.8793522506 4199149.0901295794 4517515.3082841141 4847024.3440740574
File details come from the government source that posted it. Updated .