Docstoc

cashflow

Document Sample
cashflow Powered By Docstoc
					Cash Flow                    For Energy Savings

GENERAL ASSUMPTIONS
Financial Assumptions                                  Energy Costs
Interest rate, fixed               7.0%                           nat gas             propane
Term, years                           30               $$/unit     $    1.65        $      3.50
Inflation Rate                     3.5%                           per ccf            per gallon
                                                       $$/MMBtu $         17        $         38
Energy Escalation Rates
Electricity                         8%                 change values in yellow areas to match your project
Natural Gas                        10%                 See graph below and to the right
Propane                            10%
Wood Pellets                       10%

PROJECT-SPECIFIC INFORMATION
Energy Costs                                           Energy Improvements and Cost
                             Propane                              As-Built         Cost/sq.ft
As-Built, Energy Star         $   1,900                Walls      R-19              $       9.76
Micro-Load                    $     840                Roof       R-30 slopes
Savings, first year           $   1,060                           R-40 flats, 12" cellulose
                                                       Slab       R-10
Mortgage Cost for Improvements                         Windows R-3                  $         25
      $925 Annual payment                              Air leakage control
                                                       Heat recovery ventilation system


CASH FLOW (propane) Energy Star                        CASH FLOW (propane) Micro-Load
              Propane       Added          Propane +               Propane      Added
   Year         Cost       Mortgage        Mortgage      Year        Cost      Mortgage
         1 $        1,900        $0           $1,900           1 $        840       $925
         2 $        2,090        $0           $2,090           2 $        924       $925
         3 $        2,299        $0           $2,299           3 $      1,016       $925
         4 $        2,529        $0           $2,529           4 $      1,118       $925
         5 $        2,782        $0           $2,782           5 $      1,230       $925
         6 $        3,060        $0           $3,060           6 $      1,353       $925
         7 $        3,366        $0           $3,366           7 $      1,488       $925
         8 $        3,703        $0           $3,703           8 $      1,637       $925
         9 $        4,073        $0           $4,073           9 $      1,801       $925
        10 $        4,480        $0           $4,480          10 $      1,981       $925
        11 $        4,928        $0           $4,928          11 $      2,179       $925
        12 $        5,421        $0           $5,421          12 $      2,397       $925
        13 $        5,963        $0           $5,963          13 $      2,636       $925
        14 $        6,559        $0           $6,559          14 $      2,900       $925
        15 $        7,215        $0           $7,215          15 $      3,190       $925
        16 $        7,937        $0           $7,937          16 $      3,509       $925
        17 $        8,730        $0           $8,730          17 $      3,860       $925
        18 $        9,603        $0           $9,603          18 $      4,246       $925
        19 $      10,564         $0          $10,564          19 $      4,670       $925
        20 $      11,620         $0          $11,620          20 $      5,137       $925
        21 $      12,782         $0          $12,782          21 $      5,651       $925
22   $   14,060   $0   $14,060   22   $    6,216   $925
23   $   15,467   $0   $15,467   23   $    6,838   $925
24   $   17,013   $0   $17,013   24   $    7,522   $925
25   $   18,714   $0   $18,714   25   $    8,274   $925
26   $   20,586   $0   $20,586   26   $    9,101   $925
27   $   22,645   $0   $22,645   27   $   10,011   $925
28   $   24,909   $0   $24,909   28   $   11,012   $925
29   $   27,400   $0   $27,400   29   $   12,114   $925
30   $   30,140   $0   $30,140   30   $   13,325   $925
                       25-Jun-11




                     Oil             wood pellets Electricity
            $                 3.50   $       210 $      0.15
                 per gallon            per ton     per kWh
            $                  26    $         13 $       44

eas to match your project




            Micro-Load               Cost/sq.ft    Incremental    # Sq.ft.     Total
            R-39 (add 4" iso)        $      14.27 $      4.51         862    $ 3,892
            R-54 (add 4" iso)                       $    3.27          52    $    170
            R-60, 18" cellulose                     $    1.46         469    $    683
            R-20 (add 2" EPS)                       $    1.93          510   $    982
            R-5 triple               $          50 $       28         138    $ 3,855
                                                                             $    400
                                                                             $ 1,500
                                                                 TOTAL       $ 11,484

                                                  Table for comparison to make graph
                 Propane +
                 Mortgage                            Year
                                                       Propane+mortgage payment- with improvements
                                                   Propane+mortgage payment- as is
                        $1,765                              1   $1,900    $1,765
                        $1,849                              2   $2,090    $1,849
                        $1,942                              3 Comparison of typical and micro-load
                                                                $2,299    $1,942
                        $2,043                              4   $2,529energy+mortgage cost
                                                                          $2,043
                        $2,155                              5   $2,782    $2,155
                        $2,278                              6        Propane+mortgage payment- as is
                                                                $3,060    $2,278
                                                $35,000
                        $2,414                              7   $3,366    $2,414
                        $2,562                  $30,000     8   $3,703    $2,562
                                                                     Propane+mortgage payment- with
                        $2,726                              9   $4,073    $2,726
                                                                     improvements
                        $2,906                  $25,000    10   $4,480    $2,906
                        $3,104                             11   $4,928    $3,104
                        $3,322                  $20,000    12   $5,421    $3,322
                        $3,562                             13   $5,963    $3,562
                                                $15,000
                        $3,825                             14   $6,559    $3,825
                        $4,115                  $10,000    15   $7,215    $4,115
                        $4,434                             16   $7,937    $4,434
                        $4,785                   $5,000    17   $8,730    $4,785
                        $5,171                             18   $9,603    $5,171
                        $5,596                       $0    19 $10,564     $5,596
                        $6,063                           0 20 $11,620 10 $6,063        20            30
                        $6,577                             21 $12,782     $6,577
 $7,142   22   $14,060    $7,142
 $7,763   23   $15,467    $7,763
 $8,447   24   $17,013    $8,447
 $9,199   25   $18,714    $9,199
$10,027   26   $20,586   $10,027
$10,937   27   $22,645   $10,937
$11,938   28   $24,909   $11,938
$13,039   29   $27,400   $13,039
$14,250   30   $30,140   $14,250
40

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:9
posted:6/25/2011
language:English
pages:6