ࡱ>    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdeRoot Entry\ob$OSL5#b@PerfectOffice_MAIN& SummaryInformation(8PerfectOffice_OBJECTS,## P033D 033D 033D 033D P0@33D 0@33D 0@0D 0033D 00v33@ 0t33@ 0133D033@ P0t33@ 133D1U33D1@33D1@33D1@0D10D133D133D33D133D133D033D 133@P133@133@133@133D133DP133@133@P133@133@133@133D033D 033@ P033@  233@033@ 033D 033D 033D 033D  2@33@P0@33@  2@33DP0@33D  2A33DP033@ P033D  2P33DP033@ P033D 2033@ 133@ QFUNC1ANDi\Documents and Settings\Paul Gipe\My Documents\Quattro\Solar\Solar PV Current Installed Prices3  %&'( @@0d  $ Arial͝@4 L$ Arial͝@4 L  LB  %&'( 0d  $ Arial͝@4 L$ Arial͝@4 L  B  E    E ^ Ķ ddư>  n2  ?  HH #  Ld af   E  f E  g i2 E     .@ -/g E  0d s hs @ 6K Variables$u<7~7%%%%:%R0FJ!Solar Cost Calculator Using Chabot-BSi-Rate Methods for California+!Adapted by Paul Gipe, pgipe@igc.orgHB88 Arials`T@"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 H x x x x x  x : J0u$Ep@ Q? LM?/3$ Arialn2 3$Arialn2 3$ Arialn2 3$ Arialn2 3$ Arialn2 3$Arialn2 3$ Arialn2 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@ 033D B033@ @033@ 033@ 3033@ 033D 033D 033D 033D 033@ 033@ 033D 033D 033D 033D 033D 033D 033D 033D 1D033@ 03D 00D 0D 0D 0D 0D 1D0D 0D 1D033@ 033@ `33@ 33@ @033@ 0@33D 033@ 0033@ 00@33D 033@ 033D R ? p= ף?  %333333?   p= ף?65p= ף?"    {Gz?25?     :r$@     S333333? X    H 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 P 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  )$/kWh'Ǎڔ?!RHk?%\?"EI?QSensitivity Analysis$u<7~7%%'0      F= Sensitivity Analysis for California for Chabot MethodSolar YieldkWh/kWDC/yrHF<<e RHk? r  r  r @ r   r x! Cost in $/kWDCHB88  Arial B CoJL?C 0}?C \2?Cp6[? CL?  B pCp6[?C9Y?C>բf?Ct96:? C"=#Q?  B XC-j-j?C>CY??CsN)?CN ? CD?  B @CX=?Cm&|1?{ D?CYp|? C )?  B (#CD?C:KW?Ce >?Cd? CZ+nB|?BSi Calculator$u<7~7 % %$&%!pSC  $&0''''''''LBSi Solar Cost Calculator (now Bundesverband Solarwirtschaft or BSW)HF<<=Intalled 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}k#?   7}h#?   7}e#?   7}33333c#?   7}gffff`#?   7}33333SZ#?   7}yT#?   7}@M#?   7}̌A#?   7}gfffff'#?   7}#?   7}#?   7}#?   7}#?   7}#?   7}#?   7}#?   7 }#?   7!}#?   7"}#?   "#}HP $`.%'@PAYMT(~Umlaufrendite,20,~Barwert,0,0) '               Debt Repayment [vG   ;cvO%   ;[vG   ;cvO%   ;[vG   ;cvO%   ;[vG   ;cvO%   ;[vG   ;cvO%   ;[vG   ;cvO%   ;[vG   ;cvO%   ;[vG   ;cvO%   ;[vG   ;cvO%   ;[vG   ;cvO%   ;[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?$ mV@  {Gz? ș@   Remaining debt *P   $ $ $ $  $ $ $ $v $ $ $ $ $ $ $ $ $  $! $"  # $ % & '  Euro Euro  Euro  years years   Euro   kWh/kWp   Operating costs V )33333V    )bX9hW    )TގW    )u*ZX    )kcX    ),EVY    )z&mY    )}č\Z    )RZ    )cuihm[    )*[    )ޞ\    )Η,]    )?<ؚ2]    )@ 3H^    )>^    ) ㏱c_    )!vdY`    )"iĽc`    "#̆P $ & ' '+~Preis'+~BetragEK'+~ZinsEK'+~KreditbetragKfW'+~ZinsKfW'+~LaufzeitKfWKredit'+~tilgungsfreieZeit'+~BKAnteil  '+~Betriebskosten_absolut '+~SteigerungBK '+~Stromertrag   Cost of Equity %c %c %c %c %c %c %c %c %c %c %c %c %c %c %c %c %c % c %!c %"c "#`P $ % & '               Return of Equity                    !"  # $NPV%Annuity&Cost of energy '               Returns <fffff(     <5(     < +(     <_c܇(     <l=~0(     <sڒV(     <ػu څ(     < /(     <\e(     <ڃ(     <X]Zp(     <Jup(     <Dp(     <t%q(     < ,q(     <B| Rq(     <Cxq(     < c,Xq(     <![[q(     <"I9(      #)$V!9V1%̓@ %& 'Ǎڔ?  'Chabot PI Method$u<7~7%%eU!*+B...... . .F F F F &&F ''F (($Chabot-Gipe PIM Solar PV.wb39Note: Before tax, 100% Adjustment with Inflation.From Variables Page3Average Weighted Cost of Capital Before TaxHB88!  89Equity9Return on Equity 9Debt 9Interest on Debt 9Nominal AWCC 9Inflation AAWCC real )Rated Power (kW)1Installed Cost1Specific Installed Cost1Annual Expenses 1Term1Discount Rate (AWCC)1Specific Capacity%1Capital Recovery Factor (n,t)"1Profitability Index Target1Cost of EnergySimple Payback  H H IROE H  H  H  H  Qt   I Ius Kom n t Eas Kd PI T1     (u?}p= ף? 333333?   p= ף?6 }p= ף?"     e{Gz?2 ?     0@L@p@Q?4@?ș@M>\?9      333333?CRHk?/     5{_J!@!     '$/kW years realkWh/kW/yr NPV/I $/kWh h @   &h '@ ( ) *p +p ,x -p .p '+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 H @ 8   ! " # &h 'H (@ )8 * + , - . h H H 8   !` " # &h 'H (H )8 * +` , - . h H H X   ! " # &h 'H (H )X * + , - . h H H 8   ! " # &h 'H (H )8 * + , - . h H H 8   ! " # &h 'H (H )8 * + , - .  h  H  H  8     !  "  #  &h  'H  (H  )8  *  +  ,  -  .  h  H  H  8     !  "  #  &h  'H  (H  )8  *  +  ,  -  .PAYMT Calculation$u<7~7%%   %ؘW  FCRate of Return Calculation of Solar PV Using @PAMT FunctionHF<<. by Paul GipeInstalled Cost Fv Nper TypeGeneration O&M O&M Cost Inflation Total O&M Total PV Investment'@Payment COE QNote: No financing cost.]Note: The @PAYMT function in Quattro Pro is equivalent to the =PMT function in Excel.HF<<?  5p@ 24@ r =ș@ MQ?$ 5V@  ={Gz?  8< 5:i@(    $ 5EGZ@ 65?O@" $E\?  X H !$/kW Cost of solar systemAt end of period yearsEnd of yearPayment per yearkWh/kW/yr% of installed cost/yr  $/yrF $ for 20 years, Note this value is higher than from cash flow.1 sum of Installed Cost and Total O&M costs*'@PAYMT(Variables:C16,B5,-B13,B4,0)Cost of Energy  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 PV in Toronto|3"Rated Powerrrrrrrr3$Installed Costttttttt3.Specific Installed Costttttttt 3(Specific Capacityyyyyyyy 3 GenerationnnnnnnnTariffRevenue" Simple Payback of Solar PV7 Note: No reoccurring costs, no financing costs.  05A31IIIIIIII=h39Iussssssss0 3Eassssssss   =@=L@=p@=ș@ =@ C̪?$='sv"ۺ@ $ =ظ]t@    3kWWWWWWWW3$/kWWWWWWWWЮ 3 kWh/kW/yrrrrrrrr@@ 3kWh/yrrrrrrrr $/kWh $/yr  Installed Costs$u<7~7%% %%*% UdGeރXރ *61*1,'(1((PS.Bhttp://www.energy.ca.gov/renewables/emerging_renewables/index.htmlP&/www.sunenergy-gmbh.deP$0www.sharpesolar.comP^1Mhttp://www.energy.ca.gov/renewables/emerging_renewables/COMPLETED_SYSTEMS.XLSJ!Solar PV Current Installed Prices per kW in California & Elsewherec`T@ hExchange Rate$/AC W to $/DC WAll Prices in $/DC kW!German Prices 2005 SunEnergy 5 kW !German Prices 2006  Low  High!California Prices$Bakersfield Californian 2006(Scott Anders, CalSEIA, San Diego$Sharpe Solar Bakersfield Low%Sharpe Solar Bakersfield High,CEC Buy Down Average Before 1/1/20055CEC Buy Down Average After 1/1/2005-3/30/20064CEC Buy Down Average After 1/1/2006-1/1/2007HNDD" Arial4CEC Buy Down Average After 1/1/2006-1/1/2007HNDD" Arial4CEC Buy Down Average After 1/1/2006-1/1/2007HNDD" Arial4CEC Buy Down Average After 1/1/2006-1/1/2007HNDD" Arial4CEC Buy Down Average After 1/1/2006-1/1/2007HNDD" Arial4CEC Buy Down Average After 1/1/2006-1/1/2007HNDD" Arial4CEC Buy Down Average After 1/1/2006-1/1/2007HNDD" Arial4 CEC Buy Down Average After 1/1/2007-7/1/20074!CEC Buy Down Average After 1/1/2007-7/1/20074"CEC Buy Down Average After 1/1/2007-7/1/20074#CEC Buy Down Average After 1/1/2007-7/1/20074$CEC Buy Down Average After 1/1/2007-7/1/2007&PG&E >100 kW'(WindWolves Preserve 2007 6.3 kW*!New Mexico+PNM (New Mexico),PNM (New Mexico) 2 kWJ.q'http://www.energy.ca.gov/renewables/emerging_renewables/index.html/q'www.sunenergy-gmbh.de0y'www.sharpesolar.comU1q'http://www.energy.ca.gov/renewables/emerging_renewables/COMPLETED_SYSTEMS.XLS333333? 8Euro/kWDCHB88  :|  8  8  :  :|  0 0 0 8 8 8 8 8 8 8 8  8 !8 "8 #8 $8 %8 &8 '8 (8 )8 *8 0 0    0 0USD/kWDCHB88 0$ 5GJ@   0  0$ 5Y@ $ 5˓%T յ@   0 2@ 24! 2@ 2' 0$5̌@ $5@  0$5+#a@ $5'_'1@ $5U@ $5Ts @ $5R7~@ $5BKq@ $5M@  0$ 5(e>@ $!5O@ $"5<զ7>f@ $#5A@ $$5k".@  %0$&5OA@  '0$(5(@  )0 *0 +2(#,5@ N  -0 .0 / 0 10u3 (Euro)))))?CAD/kWDCHB88$ 5= ף@   8  8$ 5 @ $ 5= ף@  $5y|ׄ@ $5 z@ $5y|ׄ@ $5-̭@  0$5d$@ $5!/@ $5($V׼@ $5շ@ $5t*@ $5>"W^@ $5M@ $5%ɜ@ $5m2&@  8$ 5g&k@ $!5isc@ $"5^<@ $#5x @ $$5½r:@ $ %8$&53.@  '0$(55S$t@  )8 *8$+56@ $,5-̭@ 3$ (CAD)))))@M-[ ?MPB? MWcRj?tI?K.xe5@ !"tg8@P&4@X"@abS@  ?!\(\?"(\@#7h*@"$z0;!/3@P % & '03$ (USD)))))å?? Size>100 kW50-100 kW10-50 kW5-10 kW2.5-5 kW0-2.5 kW All  >100 kW!25-100 kW"10-25 kW#0-10 kW $All %&100-1,100 kW '(333333@ 333333@ 8 8  8 8 Units 8  8  8  8  8  8 8 8 8 8 8 8 8 8 8 : : : t@@u<)  u<    !D " # $[ % & ' ( )8 *8 +8 ,8 -8 .8 /8 08 18    DC  DC AC AC AC AC AC AC AC  AC !AC "AC #AC $AC &AC (AC$/kWACHB88 2;" 2B"2 @yo@uPv@@ư@D2~@A@#{4=@$@ %&3ˑ@ ' (( QEQ @@333333@ Typical Yields$u<7~7%% %%%%"#%$&%+%0%6%''U "#&+06$?????P@</http://rredc.nrel.gov/solar/codes_algs/PVWATTS/FF9;F<<F==F>>F??2 Solar Radiation & Yields on Tilted Surface   ) GermanyHamburgKasselNuernburgStuttgart   1 Canada Toronto, ON 'Toronto, ON/Sanyo Toronto, ONWiarton, ONOttawa, ONOttawa, ON 9 FranceH>44Nice, France  1 Italy Rome  1 SpainMadrid  A USAI CaliforniaBakersfield, CABakersfield, CABakersfield, CA Sacramento, CA!Average, CA "# Florida $Miami %&Oregon'Salem, OR(Bend, OR)Average, OR *+New York,Albany, NY-New York, NY.New York, NY /0Wisconsin1Madison, WI2Milwaulkee, WI3Milwaulkee, WI4Eau Claire, WI 56Minnesota7Minneapolis, MNg9Q Source: RETScreen Solar Resource and System Load Calculation - Photovoltaic Project :X ;X 7<a 'http://rredc.nrel.gov/solar/codes_algs/PVWATTS/j=i Average generation from solar in California in 2005 ~1,500 kWh/kW is ~203 GWh. CEC-300-2006-009-F.>i Average generation from solar in California is 1,150 kWh/kW, Measured Performance of California Buydown Program, Residential PV Systems, Regional Economic Research.Hx>nn-t N?q Average generation for Oregon ~1,168 kWh/kW. ODOE, Christopher Dymond.    Gross kWh/m2/yrHF<<   V  L          " 433336@HzG@m   6  " ̱@RQ@m                  " @HzG@m    ! " # $ : % & '  ( 6 ) * + ,  - . / 0 1 2 "3 ՙ@Q@m  4 5 6 "7 gffff@(\@m  9X : ;X <X = > ?    mono-Si kWh/kWDC/yrHF<<         A        ;  A            x         e      ? !  " # $  % & '  ( 0 )  * + , & - I .  / 0 1 _ 2 F 3  4 W 5 6 7  9X : ;X <X = > ?    ^poly-Si kWh/kWDC/yrHF<<         A                      ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 9X : ;X <X = > ?   Source   RetScreenRetScreenRetScreenRetScreen    Oh+'0 `lx C\ Paul GipeL~p Paul Gipem199@`ɩkH@K`Quattro Pro for Windows 7 RetScreen 'RetScreen  NRELRetScreenRetScreen NREL  RetScreen  RetScreen  RetScreen   RetScreenRetScreen NREL RetScreen!RetScreen " #$RetScreen % &'RetScreen(RetScreen)RetScreen * +,RetScreen-RetScreen .NREL / 01RetScreen2RetScreen 3NREL4RetScreen 5 6 7NREL 9X :X ;X <X = > ? TiltedVerticalOXdd   E Group14?Group1 @* /M ? ms ms ms