This spreadsheet tool developed by Sandia National Laboratories and Solar Power Electric™ is intended to help determine the value of a new or existing photovoltaic (PV) system installed on residential and commercial properties. It is designed to be used by real estate appraisers, mortgage underwriters, credit analysts, real property assessors, insurance claims adjusters and PV industry sales staff.
For appraisers, the inputs specific to PV in the Appraisal Institute’s Residential Green and Energy Efficient Addendum can be used as inputs to PV Value™. (click here for more information)
Valuing a PV system is done using an income capitalization approach, which considers the present value of projected future energy production along with estimated operating and maintenance costs that are anticipated to occur during the PV module power production warranty timeframe.
This tool was created with Microsoft Excel® 2007, and works with both Excel® 2007 and 2010. Use of this spreadsheet requires activating macros, ActiveX controls and data connections. A detailed user manual accompanies this tool and can be found in the download area below. Sandia Labs hosted a webinar describing PV Value™ on December 7, 2011, which can be viewed at the source site below.
Updates will be made as necessary, with a new version released on or before September 1, 2012. The current version is 1.0.
Please contact Geoff Klise at Sandia National Laboratories with questions or comments related to PV Value™. He can be reached at: gklise@sandia.gov
PV Value™ v1.0
(zip file 360 KB)
PV Value™ v1.0 User Manual (SAND2012-0682P)
(pdf 1.3 MB)
Please contact Geoff Klise at Sandia National Laboratories with questions or comments related to PV Value™. He can be reached at: gklise@sandia.gov
Recent Comments