<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>Have you tried SAM from NREL? Or a custom spreadsheet?</div>
<div> </div>
<div>NREL also has a new spreadsheet out for calculating IRR and ROI with PBI's, however it is a bit convoluted (ridiculous number of inputs) and uses a generic kWh calculation instead of a normal modeled output.</div>
<div> </div>
<div>Are you trying to calculate a simple or modified payback?</div>
<div> </div>
<div>If using a modified payback then I would perform a discounted cash-flow analysis when dealing with PBI's, before lumping it in.</div>
<div> </div>
<div><BR> </div>
<div><BR></div>
<div><SPAN style="FONT-SIZE: 8pt"><SPAN style="COLOR: #3366ff"><STRONG><SPAN style="COLOR: #0000ff">Jamie Johnson<BR>NABCEP Certified PV Technical Sales Professional<BR>NABCEP Certified Solar PV Installer<BR><BR>General Manager</SPAN></STRONG></SPAN></SPAN></div>
<div><SPAN style="FONT-SIZE: 8pt"><SPAN style="COLOR: #3366ff"><STRONG><SPAN style="COLOR: #0000ff">SOLAR POWER ELECTRIC</SPAN></STRONG></SPAN></SPAN></div>
<div><SPAN style="FONT-SIZE: 8pt"><SPAN style="COLOR: #3366ff"><STRONG></STRONG></SPAN></SPAN></div>
<div><SPAN style="FONT-SIZE: 8pt"><SPAN style="COLOR: #3366ff"><STRONG><SPAN style="COLOR: #0000ff"><IMG title="signature image" border=0 alt="" src="cid:sigimg1@15af73307510febf43180cfdcc608c99"></SPAN></STRONG></SPAN></SPAN></div>
<div> </div>
<div> </div>
<BLOCKQUOTE style="BORDER-LEFT: blue 2px solid; PADDING-LEFT: 8px; FONT-FAMILY: verdana; COLOR: black; MARGIN-LEFT: 8px; FONT-SIZE: 10pt" id=replyBlockquote webmail="1">
<DIV id=wmQuoteWrapper>-------- Original Message --------<BR>Subject: [RE-wrenches] Financial Analysis Tools<BR>From: Aaron Mandelkorn <<a href="mailto:reosolar@gmail.com">reosolar@gmail.com</a>><BR>Date: Fri, April 22, 2011 11:34 am<BR>To: RE-wrenches <<a href="mailto:re-wrenches@lists.re-wrenches.org">re-wrenches@lists.re-wrenches.org</a>><BR><BR>Hello everyone. This question goes out to the contractors that deal with rebate structures that use a performance based incentive like the new Xcel solar rewards program. I am finding it difficult to compute the performance based incentive (.40 cents per kilowatt hour of production) into the RetScreen financial analysis tool and am wondering how others are dealing with this complication and what kinds of financial analysis tools allow for the input of this kind of performance based incentive. Since the PBI is not a up front rebate but rather a monthly payout based on production over time it is difficult to input this into the program. If I take the PBI and add up the amount over the ten year period and put it into the program as a lump sum it throws off the payback timeline. There is just no option for a performance based incentive in the program. How do you all deal with an incentive of this kind and what kinds of financial analysis tools do you all use to best represent a rebate of this kind. Thanks.
<DIV><BR></DIV>
<DIV>
<DIV>
<DIV><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span>
<DIV style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span>
<DIV style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span>
<DIV><SPAN><SPAN style="FONT-FAMILY: Skia; FONT-SIZE: 16px" class=Apple-style-span>Aaron Mandelkorn</SPAN></SPAN></DIV>
<DIV><SPAN><SPAN style="FONT-FAMILY: Skia; FONT-SIZE: 16px" class=Apple-style-span></SPAN></SPAN><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span><SPAN style="FONT-FAMILY: Skia; FONT-SIZE: 13px" class=Apple-style-span>Renewable Energy Outfitters</SPAN></SPAN></SPAN></DIV>
<DIV><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span><SPAN style="FONT-FAMILY: Skia; FONT-SIZE: 13px" class=Apple-style-span>P.O. Box 65 </SPAN>
<DIV style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span>
<DIV style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span>
<DIV style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: medium Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span>
<DIV style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 12px Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span>
<DIV style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 12px Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span>
<DIV style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 12px Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span>
<DIV style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 12px Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span>
<DIV style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"><SPAN style="WIDOWS: 2; TEXT-TRANSFORM: none; TEXT-INDENT: 0px; BORDER-COLLAPSE: separate; FONT: 12px Helvetica; WHITE-SPACE: normal; ORPHANS: 2; LETTER-SPACING: normal; COLOR: rgb(0,0,0); WORD-SPACING: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px" class=Apple-style-span>
<DIV style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV><FONT class=Apple-style-span size=3 face=Skia><SPAN style="FONT-SIZE: 13px" class=Apple-style-span>Salida CO 81201</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span size=3 face=Skia><SPAN style="FONT-SIZE: 13px" class=Apple-style-span><SPAN style="FONT-FAMILY: Helvetica; FONT-SIZE: 12px" class=Apple-style-span>
<DIV><FONT class=Apple-style-span size=3 face=Skia><SPAN style="FONT-SIZE: 13px" class=Apple-style-span>(970)596-3744</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span size=3 face=Skia><SPAN style="FONT-SIZE: 13px" class=Apple-style-span><A href="mailto:reosolar@gmail.com" target=_blank>reosolar@gmail.com</A></SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span size=3 face=Skia><SPAN style="FONT-SIZE: 13px" class=Apple-style-span><A href="http://www.reosolar.com/" target=_blank>www.reosolar.com</A></SPAN></FONT></DIV></SPAN></SPAN></FONT></DIV></DIV></SPAN></DIV></SPAN></DIV></SPAN></DIV></SPAN></DIV></SPAN><FONT class=Apple-style-span face=Onyx><BR></FONT></DIV></SPAN></DIV></SPAN></DIV></SPAN></DIV></SPAN></SPAN></DIV></SPAN></DIV></SPAN></SPAN></SPAN></DIV></SPAN><BR></SPAN><BR class=Apple-interchange-newline></DIV><BR></DIV></DIV>
<HR>
_______________________________________________<BR>List sponsored by Home Power magazine<BR><BR>List Address: <a href="mailto:RE-wrenches@lists.re-wrenches.org">RE-wrenches@lists.re-wrenches.org</a><BR><BR>Options & settings:<BR><a href="http://lists.re-wrenches.org/options.cgi/re-wrenches-re-wrenches.org">http://lists.re-wrenches.org/options.cgi/re-wrenches-re-wrenches.org</a><BR><BR>List-Archive: <a href="http://lists.re-wrenches.org/pipermail/re-wrenches-re-wrenches.org">http://lists.re-wrenches.org/pipermail/re-wrenches-re-wrenches.org</a><BR><BR>List rules & etiquette:<BR><a href="http://www.re-wrenches.org/etiquette.htm">www.re-wrenches.org/etiquette.htm</a><BR><BR>Check out participant bios:<BR><a href="http://www.members.re-wrenches.org">www.members.re-wrenches.org</a><BR><BR></DIV></BLOCKQUOTE></span></body></html>