ࡱ>    !"#$%&'()*+,-./0123456789:;<=>?@ABDRoot EntryA,X芙I_6@)QC@PerfectOffice_MAIN& SummaryInformation(8PerfectOffice_OBJECTS,QQ  ^ ~ ddư> ?  ʤ #       f  g i2   ia s k -/g  0d  @   O6 6K Variables$u<7~7%%%%R0;!Solar Cost Calculator Using Chabot-BSi-Rate Methods+!Adapted by Paul Gipe, pgipe@igc.orgHB88 Arials!@"Enter Data in These Cells. xqRated PowerqInstalled CostqSpecific Installed CostqAnnual Expenses qTerm qEquity qReturn on Equity qDebt qInterest on DebtqNominal AWCCqInflationqAWCC realqSpecific CapacityGeneration pUsed in Chabot PIM"qProfitability Index TargetUsed in BSi CalculatorqTerm of Debt xwyNote: These tables were created and formatted in Quattro Pro. Excel files have been converted from Quattro Pro. x x x x x x P qI qIus qKom  qn  p  qROE  p  p p p qt qEas  p p qPI x x p x x x x x x x  x : J'$E@ Q?  R ? p= ף?  %333333?   p= ף?65p= ף?"    {Gz?25?     :$@     S? X     P   x x x kW '$/kWon installed cost  years  x  x  x  x x xyDiscount rate realkWh/kW/yrkWh/yr NPV/I x x yyears x x x x x x x x x x x x  x  x  x  x  x x x x x  x xPPI Target should be in the range of 0.2-0.3 to foster industrial growth. x x x x x x x x x x x x x x x  x  x  x  x  x x x x x  x x x x x x x x x x x x xResults BSi CalculatorChabot PIM'@Paymt Modified  )$/kWh2t*?! %`?%rqi?BSi Calculator$u<7~7 % %$&%!pSC  $&0''''''''LBSi SoLM'/3$ Arialpp' 3$Arialpp' 3$ Arialpp' 3$ Arialpp' 3$ Arialpp' 3$Arialpp' 3@S Normal Comma Currency Percent Fixed DateHeading 1Heading 2 Total Comma0 Currency0033@ R033@ 2033@ B033@ 033@  033@ 033@ 033@ 0 33@ P033@ 0033@ P06 33@ P06 33@ P0> 33@ P0> 33@ P0 33@ P0> 33@ P0> 33@ P06 33@ P0 33@ P0> 33@ P0> 33@ A0633@ P0> 33@ P06 33@ P06 33@ P06 33@ P6 33@ P0 33@ P06 33@ P06 33@ P06 33@ 306 33@ P06 33@ P06 33@ 033@ 03D 0D 033D 033D 033D 033D @ 2033DA 2033D@0033D B 2033DA0033D A033D 1 0D0D P 2<0D010D0 20DA 20D 20D00D 00D A10DP 20D00D 300D 03D 033@ 033D 1D0 33D  2U33D0<33D 0033D 0D 033@ 033D 033D 1D03D 0D 00D 0D 10D00D @ 233DA 233D@033D B 233DA033D 0D P 20D01D0 2DA 2D 2DA1DP 2D0D 30D 03D 0D @ 2DA 2D@0D B 2DA0D P 2D01D0 2D 2DA1D0D 30D 0D 1D1D@1D@1DB1DA1D1DP1D1D31D1D 2D133@133@P1>33@P1>33@1<33@R1>33@1<33@1<33@R1>33@R1> 33@P1> 33@0033@ P033@ 2033@ B033@ 0@33D 033@ A06 33@ 006 33@ @ 2033DA 2033D@ 2033DB 2033DP 2<0D0 20DA 20D 20DP06 33@ 06 33@ R0>33@ R0>33@ R0>33@ 0>33@ P0>33@ R0633@ @1D033@ 033@  2D0D 1D1D0UD 0U33D 033@ B033@ P033@ 033@ 033@ 033@ 033@ 033@ 033@ 033@ 0A33@ 033@ 033@ 033@ 0P33@ 033D 033D 0A33D 033D 033D 033D 0P33D 033D 033D 033D 033D 0<33D 0033D 0033D 033D 0033D 033@ 133@133@P1>33@P1>33@1<33@R1>33@1<33@R1>33@R1> 33@P1> 33@P1>33@P1>33@1<33@R1>33@1<33@R1>33@R1> 33@P1> 33@R1>33@R1>DR1U>DR1U>33DR1>33D1<33@1<D033D 033D 033@ P033@ 033D 033@ 033D 033D 033D 033D 033D P033@ 033@ 033@ 033@ 033@ 033@ 033D 033D 033D 033D 033D 033D 033D 033D A033@ 033D QFUNC1AND  %&'( @@0d  $ Arial:h' $ Arial:h'   LB  @%&'( 0d  $ Arial:h' $ Arial:h'   B   #lar Cost Calculator (now Bundesverband Solarwirtschaft or BSW)HF<<= ArialIntalled Cost/kWEquityDesired ROE DebtInterest on Loan$Repayment time for KfW loan Grace Period3Operating costs p.a. relative to investment Operating costs p.a.+ Rate of increase of operating costs Annual Yield  `  qYear{{?{@{@{@{@{@{@{ @{"@{$@{&@{(@{*@{,@{.@{0@{1@ {2@!{3@"{4@ #x $` % & ' ` h h h h h h h h  h  h  h  ` qDebt Interest 7}(w#?   7}t#?   7}Hr#?   7}o#?   7}j#?   7}e#?   7}a#?   7}`X#?   7}@M#?   7}3#?   7}#?   7}#?   7}#?   7}#?   7}#?   7}#?   7}#?   7 }#?   7!}#?   7"}#?   "#}xP $`.%'@PAYMT(~Umlaufrendite,20,~Barwert,0,0) '               Debt Repayment [G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[G   ;cO%   ;[ G   ;c O%   ;[!G   ;c!O%   ;["G   ;c"O%   ; # $ % & ' @$@@ p= ף?)p@   p= ף?$@ Q?$ mb@  {Gz? @   Remaining debtp *   $ $h $  $p $ $  $ $ $ $ $ $ $ $ $ $ $  $! $"  # $ % & '  Euro Euro  Euro  years years   Euro   kWh/kWp   Operating costs b ) c    )Rc    )!Acc    )yaKd    )Y}d    ){ae    )he    )j e    )9qhf    )W,f    )ǣY2Pg    )!dg    )%OAh    ) h    )73+\?9      ?C %`?/     5#7$@!     '$/kW years realkWh/kW/y NPV/I $/kWh Solar PV Tariff $CAD/kWhHAChabot Profitability Index Method Simple Solar PV Tariff PricingHxnn) Arial Arial PPI Index %`?  !?"?#333333? '+1-C8 '($C8*$C9)+($C10*$C11) '(C12-C13)/(1+C13)+'(C22*(1+C22)^C21)/(((1+C22)^C21)-1)#'((1+C25)*C24+C20)*(C19/C23)'+C18/(C23*C17*C26)  H!AInstalled Cost in $CAD/kWHF<< Arial : Jy?!D?"Cq?#p6[?  H H : X?!c %`?"#i?# &Cpr?  H H Zp aZo6?!#,f?"Tl. ?#D?  H H :X k ?!6v?"~?#4bP?  H H :@ Jy?!D?"Cq?#p6[?    H  H  :(#  C? !!j? "kE? #>բf?    H  H  :'  X? ! %`? "#i? # &Cpr?PAYMT Calculation$u<7~7%%    %HW  ;Rate of Return Calculation of Solar PV Using @PAYMTby Paul GipeInstalled Cost Fv Nper TypeGenerationReoccurring Costs O&M Cost Inflation Total O&M Total PV Investment'@PAYMT COE QNote: No financing cost.NNote: The @PAYMT function is equivalent to the =PMT function in Excel.HF<<0 Arial 5@ 24@ r =@ MQ?$ 5b@  {Gz?  8< 50栙i@(    $ 5s<@ 65y;@" $Erqi?  X H!$/kW Cost of solar systemAt end of period yearsEnd of yearPayment per yearkWh/kW/yr% of installed cost/yr  $/yr6 Note this value is higher than from cash flow.1 Sum of Installed Cost and Total O&M costs,@PAYMT(Rate, Nper, Pv, , )  HBSi Defintions$u<7~7%I      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~-9BSi Definitions (English Equivalents) @AEigenkapitalAKfW KreditLaufzeit KfW-KreditUmlaufrenditeBetriebskosten p.a.Steigerungsrate der BKStromertrag pro kWp Betrag Verzinsung Zinsatz tilgungsfreie Zeit '+~Preis*~AnteilEK+~Preis*(1-~AnteilEK)AAnteil @ @AEquityADebt or loan from KfWALoan period or term!AYield or return on equity3Operating costs p.a. realtive to investment8AInflation rate or growth rate on operating costsAYield in kWh/kW Aamount& Ainterest rate on equity or ROE Ainterest rate on debt Apayment free period Aprice*(Equity)Aprice*(1-Equity)Aportion @ @ AEK @ @ @ ABK @ @  @  @  @  @  @ @ @Simple Payback$u<7~7%ރU   FF "Simple Payback of Solar PVuTA3qRated PowerrrruD3qInstalled Costttt 3&Specific Installed Costttt 3 Specific CapacityyyyxA 3GenerationnnnTariff from Chabot PIMRevenue" Simple Payback of Solar PV7 Note: No reoccurring costs, no financing costs.  0531IIII=\39IussssPE 3Eassss   =?=@=@=@ =@ E %`?$=1y@ $ ]#7$@     8  8  8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 03kWWWW|*3$/kWWWW< 3kWh/kW/yrrrr 3kWh/yrrrr $/kWh $/yr  Oh+'0 `lx C\ Paul GipeL~p Paul Gipet169@`ɩkH@U0Quattro Pro for Windows 7WXdd !  HGroup14?Group1 @* /M ?