Docstoc

Solar Investment Tax Credit - Excel

Document Sample
Solar Investment Tax Credit - Excel Powered By Docstoc
					Commonwealth Commercial Solar Photovoltaic Calculator (posted 4/06/09)
Commonwealth Solar Rebate Program 2008 Version 3.0


                                   Commercial: Commonwealth Solar Rebate Matrix ($/watt dc)
                   Incremental Capacity                   1 to 25 kW          > 25 to 100 kW > 100 kW to 200      > 200 kW to 500
                                                      (1,000 to 25,000 watts)                      kW                   kW
     Base Incentive ($/watt dc)                                      $3.15            $3.00               $2.00             $1.40
   PLUS: Additions to Base
     MA-Manufactured Components                                      $0.15            $0.15               $0.15             $0.15
     Public Building Adder                                           $1.00            $1.00               $1.00             $1.00


            Commercial: Commonwealth Solar Rebate Calculator

Total PV Project Size (watts dc)                                    50,000    Click here for Financial Model
Total PV Project Size for Rebate Calculation (500 kW cap)           50,000
     MA-manufactured components                                         yes NO
     Public Building Adder                                              yes YES
  Rebate ($)                                                    $211,250.00
  Rebate ($/watt dc) based on total project size            $      4.22500

             Key
               Entry Cells
               Calculation Cells (not for Entry)
Commercial Solar Photovoltaic Project Simple Financial Model (posted 4/06/09)
Commonwealth Solar Rebate Program 2008 Version 3.0
DATA ENTRY AND FINANCIAL SUMMARY
Key                                                                                                                                  Scenario Definitions
      Entry Cells                                                                                                                        Scenario A: Non-Taxable Rebate - Assumes that the state rebate is non-taxable, but is subtracted from the cost basis for purposes of determining tax credits and accelerated depreciation.
      Cells Draw Data from Another Worksheet
      Calculation Cells (Not for Entry)                                                                                                  Scenario B: Taxable Rebate - Assumes that the state rebate is taxable, but is not subtracted from the cost basis for purposes of determining tax credits and accelerated depreciation.
                                                                                                                                         Both Scenarios assume that the project owner can use both federal and state tax benefits
Select Taxable or Non-Taxable Entity                        Taxable             Taxable                                                                                                                      1             2              3              4             5       6           7             8             9              10      11      12       13
                                                                                Non-Taxable                                          Tax Assumptions
Project and Customer Cost Assumptions                                                                                                    Federal Tax Rate                                                35%
      Solar Photovoltaic System Size                                  50,000 Watts (DC STC)                                              State Tax Rate                                                  10%
      Total System Cost/Watt                                $            -   $/Watt (DC STC)                                             Effective Tax Rate                                              42%
      Total System Cost                                     $            -                                                               Federal Tax Credit                                              30%
                                                                                                                                         State Tax Deduction                                            100%
MTC Rebate Assumptions                                                                                                                   5 Year Accelerated Depreciation Schedule (MACRS)             20.00%        32.00%          19.20%         11.52%         11.52%   5.76%
      Rebate$ per/Watt                                      $       4.225 $/Watt (DC STC)                                                Depreciation                                                 20.00%        32.00%          19.20%         11.52%         11.52%   5.76%       0.00%         0.00%         0.00%          0.00%    0.00%   0.00%   0.00%
      Total Rebate                                          $     211,250                                                                    Asset Basis
                                                                                                                                                  Gross Cost                                    $        -
                                                                                                                                                  Rebate                                        $        -
                                                                                                                                                  Less 50% of Federal Tax Credit                $        -
Project Performance and Savings/ Cost Assumptions
      Annual Net Capacity Factor                                       14.0% kW (DC STC) to kWh AC                                           Asset Basis                                        $        -
      Annual Production Degradation                                    0.50% %                                                       Financing Assumptions
      Project Life                                                         25   Years                                                    % Financed w/ Cash                                           100%           Cash
      Depreciation Life                                                    20   Years                                                    % Financed w/ Loan                                              0%
      Electricity Revenue (Avoided Costs)                   $           0.15    $/kWh                                                    Loan Interest Rate                                          9.00%           Loan
      Electricity Revenue (Avoided Costs) Annual Adjustor               3.0%    %                                                        Loan Period                                                      20 Years (must be equal to or less than project life)
      Renewable Energy Certificate (REC) Revenue            $           0.04    $/kWh                                                    Net Cost                                               $ (211,250)
      REC Revenue Annual Adjustor                                       0.0%    %                                                        Loan                                                   $      -
      REC Revenue Term                                                      5   Years (must be equal to or less than project life)       Customer Discount Rate                                      3.00%
      Annual Operations and Maintenance Cost Factor         $          17.59    $/kW/Year
      Annual Operations and Maintenance Cost                $            880    $/Year
      Annual Operations and Maintenance Adjustor                        3.0%    %                                                    Solar Project Financial Analysis Summary
      Future Inverter Replacement Cost                      $           0.71    $/Watt (DC STC)                                          Net Present Value                                      $    214,798
      Inverter Life, Replace Every X Years                                 10   Year (must be equal to or less than project life)        Simple Payback (100% Cash only)                                Year
                                                                                                                                         Estimated Return on Equity                                 #DIV/0!
                                                                                                                                             Scenario A: Guess Return on Equity                          10%

Disclaimer: This Unofficial Cash Flow Model is intended to provide non-residential entities that are considering the purchase and installation of solar energy equipment with a general
understanding of possible financial implications of such purchase and installation. Those entities interested in learning more about the financial implications of the purchase and installation of
solar energy equipment are urged to consult their own tax and financial experts. The information contained in the Unofficial Cash Flow Model may not be relied on by anyone for any purposes.
Furthermore, the information contained in this model does not necessarily reflect the views of the Massachusetts Technology Collaborative or the Commonwealth of Massachusetts, and
reference to any specific method does not constitute an implied or expressed recommendation or endorsement of it. Neither the Massachusetts Technology Collaborative nor the Commonwealth
of Massachusetts make any warranties or representations, expressed or implied, as to the usefulness, completeness, or accuracy of any processes, methods or other information contained,
described, disclosed, or referred to in this model. Finally, neither the
Massachusetts Technology Collaborative nor the Commonwealth of Massachusetts makes any representation that the use of any product, apparatus, process, method, or other
information will not infringe privately owned property rights and assumes no liability of any kind or nature for any loss, injury, or damage directly or indirectly resulting from, or
occurring in connection with, the use of information contained, described, disclosed, or referred to in this Unofficial Cash Flow Model.




                                                                                                                                                                  20977d79-8c90-4274-b5a4-87885b592573.xls                                                                                                                                                 2
Commercial Solar Photovoltaic Project Simple Financial Model (posted 4/06/09)
PRO FORMA AND PRODUCTION
                                                                                 Start-Up           Year                 Year                 Year                 Year               Year                Year               Year               Year               Year               Year                Year                Year                Year                Year                Year                Year                Year                Year                Year                Year
Project Output                                                                      0                1                    2                    3                    4                  5                   6                  7                  8                  9                  10                  11                  12                  13                  14                  15                  16                  17                  18                  19                  20
Annual Generation (kWh)                                                                                  61,320               61,013               60,708           60,405             60,103              59,802             59,503             59,206             58,910             58,615              58,322              58,030              57,740              57,452              57,164              56,879              56,594              56,311              56,030              55,749


FINANCIAL SCHEDULES
INCOME STATEMENT
    Electricity Revenue (Avoided Cost)                                                          $          9,198     $          9,427     $          9,661     $     9,901        $    10,147        $     10,399        $    10,657        $    10,922        $    11,194        $    11,472         $    11,757         $    12,049         $    12,349         $    12,655         $    12,970         $    13,292         $    13,623         $    13,961         $    14,308         $    14,664
    MTC Rebate                                                               $       211,250
    REC Revenue                                                                                 $         2,453      $         2,441      $         2,428      $    2,416         $    2,404         $       -           $       -          $      -           $      -           $       -           $      -            $      -            $      -            $      -            $      -            $      -            $      -            $      -            $      -            $       -
                          Total Revenue (Avoided Costs)                      $      211,250     $        11,651      $        11,867      $        12,089      $   12,317         $   12,551         $    10,399         $   10,657         $   10,922         $   11,194         $    11,472         $   11,757          $   12,049          $   12,349          $   12,655          $   12,970          $   13,292          $   13,623          $   13,961          $   14,308          $    14,664
Replace Inverter?                                                                  No               No                   No                   No                   No                 No                  No                 No                 No                 No                 Yes                 No                  No                  No                  No                  No                  No                  No                  No                  No                  Yes
    Operations & Maintenance Costs                                                            $            (880)     $          (906)     $          (933)     $     (961)        $     (990)        $    (1,020)        $    (1,050)       $   (1,082)        $   (1,114)        $    (1,148)        $   (1,182)         $   (1,217)         $   (1,254)         $   (1,292)         $   (1,330)         $   (1,370)         $   (1,411)         $   (1,454)         $   (1,497)         $    (1,542)
    Inverter Replacement Cost                                                                 $             -        $           -        $           -        $      -           $      -           $       -           $       -          $      -           $      -           $   (35,500)        $      -            $      -            $      -            $      -            $      -            $      -            $      -            $      -            $      -            $   (35,500)
                                Total Operating Expenses                     $           -    $            (880)     $          (906)     $          (933)     $     (961)        $     (990)        $    (1,020)        $    (1,050)       $   (1,082)        $   (1,114)        $   (36,648)        $   (1,182)         $   (1,217)         $   (1,254)         $   (1,292)         $   (1,330)         $   (1,370)         $   (1,411)         $   (1,454)         $   (1,497)         $   (37,042)
                                                 EBITDA                      $       211,250  $          10,771      $        10,961      $        11,156      $   11,356         $   11,561         $     9,379         $     9,607        $    9,841         $   10,080         $   (25,176)        $   10,575          $   10,832          $   11,095          $   11,364          $   11,640          $   11,922          $   12,211          $   12,507          $   12,811          $   (22,379)
    Federal Depreciation Expense                                                              $             -        $           -        $           -        $      -           $      -           $       -           $       -          $      -           $      -           $       -           $      -            $      -            $      -            $      -            $      -            $      -            $      -            $      -            $      -            $       -
                                                    EBIT                     $       211,250 $           10,771      $        10,961      $        11,156      $   11,356         $   11,561         $     9,379         $     9,607        $    9,841         $   10,080         $   (25,176)        $   10,575          $   10,832          $   11,095          $   11,364          $   11,640          $   11,922          $   12,211          $   12,507          $   12,811          $   (22,379)
    Interest Expense                                                                          $             -        $           -        $           -        $      -           $      -           $       -           $       -          $      -           $      -           $       -           $      -            $      -            $      -            $      -            $      -            $      -            $      -            $      -            $      -            $       -
                                                     EBT                     $       211,250 $           10,771      $        10,961      $        11,156      $   11,356         $   11,561         $     9,379         $     9,607        $    9,841         $   10,080         $   (25,176)        $   10,575          $   10,832          $   11,095          $   11,364          $   11,640          $   11,922          $   12,211          $   12,507          $   12,811          $   (22,379)
    Federal taxes saved/(paid)                                               $       (66,544) $          (3,393)     $        (3,453)     $        (3,514)     $   (3,577)        $   (3,642)        $    (2,955)        $    (3,026)       $   (3,100)        $   (3,175)        $     8,811         $   (3,331)         $   (3,412)         $   (3,495)         $   (3,580)         $   (3,666)         $   (3,755)         $   (3,847)         $   (3,940)         $   (4,035)         $     7,833
    State taxes saved/(paid) [can not deduct federal depreciation expense]   $       (21,125) $          (1,077)     $        (1,096)     $        (1,116)     $   (1,136)        $   (1,156)        $      (938)        $      (961)       $     (984)        $   (1,008)        $     2,518         $   (1,058)         $   (1,083)         $   (1,109)         $   (1,136)         $   (1,164)         $   (1,192)         $   (1,221)         $   (1,251)         $   (1,281)         $     2,238
                                              Net Income                     $       123,581 $            6,301      $         6,412      $         6,526      $    6,643         $    6,763         $     5,487         $     5,620        $    5,757         $    5,897         $   (13,847)        $    6,186          $    6,337          $    6,490          $    6,648          $    6,809          $    6,974          $    7,144          $    7,317          $    7,494          $   (12,308)

CASH FLOW STATEMENT
   Cash From Operations
         Net Income                                                          $       123,581    $          6,301     $          6,412     $          6,526     $     6,643        $     6,763        $      5,487        $     5,620        $     5,757        $     5,897        $   (13,847) $            6,186         $     6,337         $     6,490         $     6,648         $     6,809         $     6,974         $     7,144         $     7,317         $     7,494         $   (12,308)
         Federal Depreciation Expense                                        $           -      $            -       $            -       $            -       $       -          $       -          $        -          $       -          $       -          $       -          $       -    $              -           $       -           $       -           $       -           $       -           $       -           $       -           $       -           $       -           $       -
                             Cash Flow From Operations                       $       123,581    $          6,301     $          6,412     $          6,526     $     6,643        $     6,763        $      5,487        $     5,620        $     5,757        $     5,897        $   (13,847) $            6,186         $     6,337         $     6,490         $     6,648         $     6,809         $     6,974         $     7,144         $     7,317         $     7,494         $   (12,308)

    Cash From Investing
         Installed PV Cost                                               $                  -
                                                                         $
         One Time State Solar Investment Tax Deduction (Actual Cash Value)                  -
         One Time Federal Solar Investment Tax Credit                    $                  -
                              Cash Flow From Investing                   $                  -   $            -       $            -       $            -       $          -       $          -       $           -       $          -       $          -       $          -       $          -        $          -        $          -        $          -        $          -        $          -        $          -        $          -        $          -        $          -        $          -

    Cash From Financing
         Loan Disbursement                                                   $              -
         Loan Repayment (Principle)                                                             $            -       $            -       $            -       $          -       $          -       $           -       $          -       $          -       $          -       $          -        $          -        $          -        $          -        $          -        $          -        $          -        $          -        $          -        $          -        $          -
                            Cash Flow From Financing                         $              -   $            -       $            -       $            -       $          -       $          -       $           -       $          -       $          -       $          -       $          -        $          -        $          -        $          -        $          -        $          -        $          -        $          -        $          -        $          -        $          -

    Annual Cash Flow                                                         $       123,581    $       6,301        $       6,412        $       6,526        $     6,643        $     6,763        $      5,487        $     5,620        $     5,757        $     5,897        $   (13,847) $            6,186         $     6,337         $     6,490         $     6,648         $     6,809         $     6,974         $     7,144         $     7,317         $     7,494         $   (12,308)
    Cumulative Cash Flow                                                     $       123,581    $     129,882        $     136,295        $     142,821        $   149,464        $   156,228        $    161,715        $   167,335        $   173,092        $   178,988        $   165,142 $           171,328         $   177,665         $   184,155         $   190,803         $   197,612         $   204,586         $   211,730         $   219,047         $   226,541         $   214,233

    Simple Payback                                                                              $                1   $                2   $                3   $              4   $              5    $              6   $              7   $              8   $              9   $              10   $              11   $              12   $              13   $              14   $              15   $              16   $              17   $              18   $              19   $              20
    Net Investment                                                           $       123,581    $     129,882        $     136,295        $     142,821        $   149,464        $   156,228        $    161,715        $   167,335        $   173,092        $   178,988        $   165,142         $   171,328         $   177,665         $   184,155         $   190,803         $   197,612         $   204,586         $   211,730         $   219,047         $   226,541         $   214,233
                                                   Simple Payback Year                   -




                                                                                                                                                                                                     20977d79-8c90-4274-b5a4-87885b592573.xls                                                                                                                                                                                                                                                  3
Commercial Solar Photovoltaic Project Simple Financial Model (posted 4/06/09)
DEBT SCHEDULES
                                                                       Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year
Scenario A Loan: Debt Schedule                                          1              2              3              4              5              6              7              8              9              10             11             12             13             14             15             16             17             18             19             20
Beginning Balance                                                  $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -
Debt Service                                                       $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -
Principle                                                          $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -
Interest                                                           $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -
Ending Balance                                                     $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -   $          -

                                                                       Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year           Year
Disclaimer: This Unofficial Cash Flow Model is intended to provide non-residential entities that are considering the purchase and installation of solar energy equipment with a general understanding of possible financial implications of such purchase and installation. Those entities
interested in learning more about the financial implications of the purchase and installation of solar energy equipment are urged to consult their own tax and financial experts. The information contained in the Unofficial Cash Flow Model may not be relied on by anyone for any
purposes. Furthermore, the information contained in this model does not necessarily reflect the views of the Massachusetts Technology Collaborative or the Commonwealth of Massachusetts, and reference to any specific method does not constitute an implied or expressed
recommendation or endorsement of it. Neither the Massachusetts Technology Collaborative nor the Commonwealth of Massachusetts make any warranties or representations, expressed or implied, as to the usefulness, completeness, or accuracy of any processes, methods or other
information contained, described, disclosed, or referred to in this model.


Finally, neither the Massachusetts Technology Collaborative nor the Commonwealth of Massachusetts makes any representation that the use of any product, apparatus, process, method, or other information will not infringe privately owned property rights and assumes no liability of
any kind or nature for any loss, injury, or damage directly or indirectly resulting from, or occurring in connection with, the use of information contained, described, disclosed, or referred to in this Unofficial Cash Flow Model.




                                                                                                                                              20977d79-8c90-4274-b5a4-87885b592573.xls                                                                                                                                                                               4
Definitions
                                      Unit of energy. This is a measure of how much energy is consumed by a home o
Back   Kilowatt-hours (kWh)           much electricity is produced by a solar PV system. The amount of energy consu
                                      electric meter.

                                      The solar photovoltaic (PV) system. This includes your panels (modules), inverter
Back   Solar System                   utility.


       Estimated Optimal Annual       The best case scenario for how much electricity a solar PV system will produce.
       Generation (kWh)               electricity depending on several factors. For example, a system will produce less
                                      roof) than if they are on an axis that tracks the sun throughout the day. Another fa
Back
                                      is able to face due south, the more it should produce. Tilt angle also impacts prod
       optimal fixed south facing     latitude the more it will produce. An optimal system in Massachusetts that is fixed
       free from shading location     a tilt of 42 degrees.

       System Size                    Kilowatts are a measure of power. A kilowatt is 1,000 watts. In this case, it descr
Back                                  single solar PV panel might be rated at 180 watts. If a system uses 10 panels rat
       kilowatts (kW)                 be 1800 watts, or 1.8 kW.
                                      This is a ratio between the amount of energy produced by your solar PV system a
                                      production capability. A 12.8% net capacity factor is average for solar PV system
Back   Annual Net Capacity Factor     the angle of the system, its orientation, and the amount of shading. If a solar PV
                                      day, 24 hours per day at the optimal tilt and orientation with no shade then that sy
                                      in other words, it would produce its rated output.

       Annual Production              Over the course of the life of the PV system, its production capability will decrease
Back
       Degradation                    Our default assumption is that this degradation will be 0.5% per year.

                                      Depreciation is the reduction in the value of an asset due to usage, passage of ti
Back   Depreciation Life              obsolescence or other factors. Depreciation life is the "useful life" of the system,
                                      system will provide an economic benefit.
       Electricity Revenue (Avoided   This is the price per kWh that you will save on your electricity bill using this solar P
Back
       Costs)                         this is a state average price for electricity.

       Electricity Revenue (Avoided   This model assumes that the cost of electricity will increase at 5% per year, there
Back
       Costs) Annual Adjustor         costs will also increase at 5% a year.


                                      Renewable Energy Certificates (RECs), also known as green tags, Renewable En
       Renewable Energy               Certificates (TRCs), are tradable environmental commodities in the United States
Back
       Certificate (REC) Revenue      hour (MWh) of electricity was generated from an eligible renewable energy resour
                                      and they can be sold and traded so that the owner of the REC can claim to have p

       REC Revenue Annual
Back                                  This models allows the value of RECs to change by this percentage each year
       Adjustor
Back   REC Revenue Term               RECs can be sold under contracts and the model uses a default term of 5 years f
                                      A solar inverter is a component of a PV system that changes the direct current (D
       Future Inverter Replacement    alternating current (AC) for use with home appliances or any AC load. The life of
Back
       Cost                           the life of the PV panels and will likely need to be replaced during the lifetime of th
                                      This model assumes the default cost to replace the inverter will be $0.75/watt.
Back   Annual Generation (kWh)   This is the estimated amount of energy that your solar PV system will produce in

                                 Total System Cost includes all elements of the installation including design, equip
Back   Total System Cost         etc. In the case of taxable commercial entities, the Total System Cost should incl
                                 equipment
 y is consumed by a home or facility. It is also a measure of how
 he amount of energy consumption or production is measured by an


 r panels (modules), inverter, and meter which connects you to the


ar PV system will produce. PV systems will produce more or less
  a system will produce less energy if the panels are fixed (e.g. to a
oughout the day. Another factor is orientation. The more the system
 Tilt angle also impacts production. The closer a system's tilt is to its
 Massachusetts that is fixed, faces due south (180 degrees) and has


 watts. In this case, it describes the size of the solar PV system. A
 system uses 10 panels rated at 180 watts each, the system size will


d by your solar PV system and its optimimum nameplate (labeled)
 verage for solar PV systems in Massachusetts. This value varies by
nt of shading. If a solar PV system had the sun shining on it every
n with no shade then that system would have a 100% capacity factor,


 ction capability will decrease as it deteriorates to a degree over time.
  0.5% per year.

 due to usage, passage of time, wear and tear, technological
  "useful life" of the system, meaning the estimated length of time the

ectricity bill using this solar PV system. The default is $0.18/kWh as


 rease at 5% per year, therefore your savings from avoided electricity



 s green tags, Renewable Energy Credits, or Tradable Renewable
modities in the United States which represent proof that 1 megawatt-
ble renewable energy resource. These certificates may have a value
 he REC can claim to have purchased renewable energy.


 is percentage each year

 s a default term of 5 years for REC sales.
hanges the direct current (DC) electricity from the PV array into
 or any AC load. The life of a solar PV system's inverter is less than
aced during the lifetime of the system which can be 25 years or more.
verter will be $0.75/watt.
PV system will produce in kilowatt hours (kWh) each year.

tion including design, equipment, labor, permitting, interconnection,
tal System Cost should include Massachusetts sales tax on the

				
DOCUMENT INFO
Description: Solar Investment Tax Credit document sample