Solar Value Stack Calculator

NY-Sun developed the Solar Value Stack Calculator to help contractors better estimate compensation for specific solar projects. We will periodically update the calculator—please revisit this page regularly to ensure you are using the most recent version. To download the calculator, you will need a recent version of Microsoft Excel.

The New Order version of the calculator includes the changes specified in DPS’s April 2019 Value Stack Order, and is meant for projects that qualify under the new rules. The Legacy Value Stack Calculator is for projects that qualified under the legacy value stack. For more details on qualifying dates and eligibility, please see the resources on NYSERDA’s Value Stack main page.

The New Order Calculator contains the following changes.

Revision 2.2 (7/17/2019) of the Value Stack Calculator includes the following changes:

  • Option to use bifacial PV modules
  • ICAP prices now calculated with monthly NYISO auction prices, not strip auction prices
  • Utility-provided ICAP prices now included whenever possible – see Documentation tab for more details
  • Sample ICAP Alternative 1 and Alternative 2 calculations are now included in the Documentation tab
  • ICAP Alternative 3 now modeled as 12 monthly payments, as opposed to a single annual lump sum
  • Per Orders, ICAP payments now have a line loss factor applied. The user can select this on User Inputs row 89
  • Users can now input on-site parasitic loads. See Documentation tab for details
  • Corrected an issue where custom on-site loads entered into User Inputs Column AA were treated incorrectly
  • Added best-practice instructions on Documentation tab explaining how users can manually enter customer production data from NREL’s SAM software
  • Other minor changes

If you have questions about the Solar Value Stack Calculator, email us at

Never miss an update to the calculator. Sign up to receive email notifications each time a new version is available.