Offer Letter Equity

Description

Offer Letter Equity document sample

Document Sample
scope of work template
							              Paranjpe Autocast Pvt. LTD

              Assumption and financial of the project

              Details of the project
              Na me of the compa ny                                                                      Paranjpe Autocast Pvt. LTD
              s ta te where the project i s s i tua ted                                                                                Ra ja s tha n
              No. of ma chi ne                                                                                                                     4 As Per Offer letter
              Ca pa ci ty /ma chi ne                                                                                 kW                         800 As Per Offer letter
              Tota l Ca pa ci ty                                                                                     kW                        3200 As Per Offer letter
              Pl a nt l oa d fa ctor                                                                                                       22.83% Interna l ca l cul a ti on

              Generation and sale of electricity
              Annua l genera ti on                                                                                   La khs                   64.00
                                                                                                                     kWh/yea r
              Sel l i ng ra te                                                                                       RS./kWh                   3.59 As RERC Order
              Es ca l a ti on Sel l i ng ra te ti l l 12th yea r                                                     RS./kWh                   0.02 As RERC Order
              Es ca l a ti on Sel l i ng ra te from 13th yea r                                                       RS./kWh                   0.01 As RERC Order

              Operation and maintenance cost and Insurance
              O&M cha rges                                                                                           Rs . i n                   20 As Per Offer letter
                                                                                                                     La khs /Yr
              Es ca l a ti on i n the o&m expens es                                                                  Percent                 5.00%    point no. 36 of RERC Order 09.03.2007
              O&M a ppl i ca bl e                                                                                    Yea r             2nd
              Ins ura nce                                                                                            Rs . La khs               2.92 As Per insurance broker letter

              CER Calculation
              Tota l CER CO2 emi s s i on per a nnum                                                                 tCO2               5,808.00
              Ra te per MT of CO2                                                                                    Euro                  10.00      World Bank Report , State and Trends of the Carbon Market 2008, Washington DC May 2008, Page 3
              Excha nge Ra te per Euro                                                                               Rs ./Euro             62.16      http://www.gocurrency.com/v2/historic-exchange-rates.php?ccode2=EUR&ccode=INR&frMonth=6&frDay=5&frYear=2008
              Tota l CER s a l e Va l ue per a nnum                                                                  Rs . In La khs        36.10

              Depreciation
              As s umed l i fe of the pl a nt                                                                        Yea rs                      20
              Yea r-1                                                                                                Percent                   40%    As per income tax act section 32
              Yea r-2                                                                                                Percent                   48%    As per income tax act section 32
              Yea r-3                                                                                                Percent                 9.60%    As per income tax act section 32
              Yea r-4                                                                                                Percent                 1.92%    As per income tax act section 32
              Yea r-5                                                                                                Percent                 0.38%    As per income tax act section 32
              Yea r-6                                                                                                Percent                 0.10%    As per income tax act section 32

              Financial parameters
              TOTAL COST                                                                                             Rs . In La khs       1840.00 As per offer letter

              Long term l oa n                                                                                                          1,288.00 As per RERC order dated 29th September, On page no. 23,Point no. 77
              Equi ty                                                                                                                      552.00
              Cos t per MW                                                                                                                 575.00
              Res i dua l Va l ue                                                                                                           92.00
              Net Depreci a bl e Va l ue                                                                                                 1748.00



              Income tax holiday from 1st 15 years                                                                   yea rs                    10
              Income tax rate after tax holiday                                                                      Percent              33.99% As per income tax rule for respective finacial year
              MAT                                                                                                    Percent              11.33% As per income tax rule for respective finacial year

              Result of financial parameter
              Equity IRR                                   10.61%




              Profit and Loss
Sr.No.        Particular's                                           Year       Year        Year            Year           Year           Year          Year          Year        Year      Year       Year       Year      Year         Year      Year      Year      Year      Year      Year      Year      Year
                                                                      1          2           3               4              5              6             7             8           9         10         11         12        13           14        15        16        17        18        19        20        21
                                                                    Mar-09     Mar-10       Mar-11         Mar-12           Mar-13        Mar-14        Mar-15       Mar-16      Mar-17    Mar-18      Mar-19    Mar-20    Mar-21       Mar-22    Mar-23    Mar-24    Mar-25    Mar-26    Mar-27    Mar-28    Mar-29
1         Income
      1.1 electricity sale                                           19.51     229.86           231.14     232.42           233.70           234.73      233.30      234.57       235.83    236.84      235.38    236.63    237.82       238.19    236.08    236.70    237.32    237.68    235.57    236.18    216.63
      1.2 CER Sa l e                                                                              -          -                -                -           -           -            -         -           -         -
      1.3 Total Income                                               19.51     229.86           231.14     232.42           233.70           234.73      233.30      234.57       235.83    236.84      235.38    236.63    237.82       238.19    236.08    236.70    237.32    237.68    235.57    236.18    216.63

2             O&M expenses                                                       1.70           20.08       21.09            22.14           23.25       24.41        25.63       26.92       28.26     29.67     31.16     32.72        34.35     36.07     37.87     39.77     41.76     43.84     46.04     44.04
              Insurance charges                                       0.25       2.92            2.92        2.92             2.92            2.92        2.92         2.92        2.92        2.92      2.92      2.92      2.92         2.92      2.92      2.92      2.92      2.92      2.92      2.92       2.67




3             PBDIT                                                  19.26     225.24           208.13     208.41           208.63           208.56      205.97      206.01       206.00    205.66      202.79    202.55    202.19       200.92    197.09    195.91    194.63    193.00    188.80    187.22    169.91

4             Depreciation                                             7.42     87.40            87.40       87.40             87.40          87.40       87.40         87.40      87.40      87.40      87.40     87.40        87.40     87.40     87.40     87.40     87.40     87.40     87.40     87.40     79.98

5             PBIT                                                   11.84     137.84           120.73     121.01           121.23           121.16      118.57      118.61       118.60    118.26      115.39    115.15    114.79       113.52    109.69    108.51    107.23    105.60    101.40     99.82     89.93

6             Interest                                               13.69     164.22       154.34         136.09           117.84           99.60       81.35        63.10       44.86       26.61      8.36

7             Profit before tax                                       -1.84     -26.38       -33.60        -15.08             3.39          21.56         37.22         55.51      73.74      91.65     107.02    115.15    114.79       113.52    109.69    108.51    107.23    105.60    101.40     99.82     89.93
8             Add book depreciation                                    7.42      87.40        87.40         87.40            87.40          87.40         87.40         87.40      87.40      87.40      87.40     87.40     87.40        87.40     87.40     87.40     87.40     87.40     87.40     87.40     79.98
              Less IT depreciation                                    699.2     839.04       167.81         33.56            6.64           1.75
              Total                                                 -693.62    -778.02      -114.01         38.76            84.15         107.21        124.62      142.91       161.14    179.05      194.42    202.55    202.19       200.92    197.09    195.91    194.63    193.00    188.80    187.22    169.91
              cumul a ti ve                                         -693.62   -1471.64     -1585.65      -1546.89         -1462.75       -1355.53      -1230.91    -1088.00      -926.86   -747.81     -553.38   -350.83   -148.65        52.28    249.37    445.28    639.91    832.91   1021.72   1208.94   1378.85
              Less : Deduction U/S 80 IA                               0.00       0.00         0.00          0.00             0.00           0.00          0.00        0.00         0.00      0.00        0.00      0.00      0.00        52.28    197.09      0.00      0.00      0.00      0.00      0.00      0.00
              Net Taxable Income                                    -693.62    -778.02      -114.01         38.76            84.15         107.21        124.62      142.91       161.14    179.05      194.42    202.55    202.19       148.65      0.00    195.91    194.63    193.00    188.80    187.22    169.91

              Income tax                                               -          -               -         13.17            28.60           36.44       42.36        48.58       54.77       60.86     66.08     68.85     68.72        50.52       -       66.59     66.15     65.60     64.17     63.64     57.75
              MAT                                                      -          -               -           -               0.38            2.44        4.22         6.29        8.35       10.38     12.13     13.05     13.01        12.86     12.43     12.29     12.15     11.96     11.49     11.31     10.19

     9.00     Income tax                                               -          -               -         13.17            28.60           36.44       42.36        48.58       54.77       60.86     66.08     68.85     68.72        50.52     12.43     66.59     66.15     65.60     64.17     63.64     57.75

10            PAT                                                     -1.84     -26.38          -33.60      -28.25           -25.21          -14.88        -5.14         6.94      18.97      30.79      40.94     46.30        46.06     63.00     97.27     41.92     41.08     40.00     37.23     36.18     32.18




              Ca l cul a ti on of fi na nci a l pa ra meter
         1)   Particular                                             Year       Year        Year            Year           Year           Year          Year          Year        Year      Year       Year       Year      Year         Year      Year      Year      Year      Year      Year      Year      Year
                                                                    Mar-09     Mar-10       Mar-11         Mar-12           Mar-13        Mar-14        Mar-15       Mar-16      Mar-17    Mar-18      Mar-19    Mar-20    Mar-21       Mar-22    Mar-23    Mar-24    Mar-25    Mar-26    Mar-27    Mar-28    Mar-29
              Equity Capital                                        -552.00
              PAT                                                     -1.84     -26.38          -33.60      -28.25           -25.21          -14.88        -5.14         6.94      18.97      30.79      40.94     46.30        46.06     63.00     97.27     41.92     41.08     40.00     37.23     36.18     32.18
              Add:Residule value                                                                                                                                                                                                                                                                                92.00
              Add: Depreciation                                        7.42      87.40        87.40          87.40             87.40          87.40       87.40         87.40      87.40      87.40      87.40     87.40        87.40     87.40     87.40     87.40     87.40     87.40     87.40     87.40     79.98
              Add: tax shield                                       235.76     264.45        38.75            -
               Less: Repayment of Term Loan                                     11.93       143.11         143.11           143.11        143.11        143.11      143.11       143.11    143.11      131.19
              Net Operating cash flow                               -310.66     313.54       -50.56         -83.97           -80.92        -70.59        -60.85      -48.78       -36.74    -24.92       -2.85    133.70    133.46       150.40    184.67    129.32    128.48    127.40    124.63    123.58    204.16
                                                                    -310.66     313.54       -50.56         -83.97           -80.92        -70.59        -60.85      -48.78       -36.74    -24.92       -2.85    133.70    133.46       150.40    184.67    129.32    128.48    127.40    124.63    123.58    204.16
                           Equity IRR                      10.61%


Calculation of DSCR                                                  Year       Year        Year            Year           Year              Year        Year         Year        Year        Year     Year       Year      Year         Year      Year      Year      Year      Year      Year      Year      Year
                                                                    Mar-09     Mar-10       Mar-11         Mar-12           Mar-13        Mar-14        Mar-15      Mar-16       Mar-17    Mar-18      Mar-19    Mar-20    Mar-21       Mar-22    Mar-23    Mar-24    Mar-25    Mar-26    Mar-27    Mar-28    Mar-29
Profi t a s per P&L A/C                                               -1.84     -26.38       -33.60         -28.25           -25.21        -14.88         -5.14        6.94        18.97     30.79       40.94     46.30     46.06        63.00     97.27     41.92     41.08     40.00     37.23     36.18     32.18
Add: Depreci a ti on                                                   7.42     87.40        87.40          87.40            87.40         87.40         87.40       87.40        87.40     87.40       87.40     87.40     87.40        87.40     87.40     87.40     87.40     87.40     87.40     87.40     79.98
Add: i ntres t on term l oa n                                        13.69     164.22       154.34         136.09           117.84         99.60         81.35       63.10        44.86     26.61        8.36       -         -            -         -         -         -         -         -         -         -
Cash available for service                                            19.26     225.24       208.13         195.24           180.03        172.12        163.61      157.44       151.23    144.80      136.70   133.70    133.46       150.40    184.67    129.32    128.48    127.40    124.63    123.58    112.16
Interes t on Term Loa n                                              13.69     164.22       154.34         136.09           117.84         99.60         81.35       63.10        44.86     26.61        8.36       -         -            -         -         -         -         -         -         -         -
Term l oa n repa yments                                                -        11.93       143.11         143.11           143.11        143.11        143.11      143.11       143.11    143.11      131.19
Total obligation                                                     13.69     176.15       297.45         279.20           260.95        242.71        224.46      206.21       187.97    169.72      139.55       -            -         -         -         -         -         -         -         -         -
DSCR Claculation                                                      1.41       1.28         0.70           0.70             0.69          0.71          0.73        0.76         0.80      0.85        0.98
Average DSCR                                                         0.87
                                                                          1        2              3              4                5             6            7            8            9        10          11        12        13           14        15        16        17        18        19        20         21
Pay Back Period                                                     Mar-09   Mar-10         Mar-11         Mar-12           Mar-13        Mar-14        Mar-15       Mar-16      Mar-17     Mar-18      Mar-19    Mar-20   Mar-21        Mar-22   Mar-23     Mar-24    Mar-25    Mar-26    Mar-27   Mar-28     Mar-29
 Profit as per P&L A/C                                                -1.84   -26.38         -33.60         -28.25           -25.21        -14.88        -5.14         6.94        18.97     30.79       40.94     46.30     46.06        63.00     97.27     41.92     41.08     40.00     37.23     36.18      32.18
 Add: Depreciation                                                     7.42    87.40          87.40          87.40            87.40         87.40        87.40        87.40        87.40     87.40       87.40     87.40     87.40        87.40     87.40     87.40     87.40     87.40     87.40     87.40      79.98
 Add:Residule value                                                    -        -              -              -                -             -            -            -            -         -           -         -         -            -         -         -         -         -         -         -        92.00
Add: tax shield                                                     235.76  264.45           38.75            -                -             -            -            -            -         -           -         -         -            -         -         -         -         -         -         -          -
Total                                                                241.34  325.47           92.55          59.15            62.19         72.52        82.26        94.34       106.37    118.19      128.34    133.70    133.46       150.40    184.67    129.32    128.48    127.40    124.63    123.58    204.16
Cumulative                                                           241.34  566.81         659.36         718.50           780.69        853.21        935.48      1029.81      1136.18   1254.37     1382.71   1516.41   1649.88      1800.28   1984.94   2114.26   2242.74   2370.14   2494.77   2618.35   2822.51
                                         Pay Back Period             14.22 Years




                                                                                                         Calculation of term loan

                                                                                                         Total term loan                              1,288.00
                                                                                                         Interest rate                                  12.75% http://rbi.org.in/scripts/AnnualReportPublications.aspx?Id=948
                                                                                                         Instalment/month                                 11.93

                                                                                         Year            Month       Amount            Repayment          Year Ending      Monthly Yearly
                                                                                                                                                      Repayment            interest
                                                                                                                                                                   outstanding       interest
                                                                                            Mar-09              1         1,288.00             -            -        ######    13.69    13.69
                                                                                                                2         1,288.00             -                               13.69
                                                                                                                3         1,288.00             -                               13.69
                                                                                                                4         1,288.00             -                               13.69
                                                                                                                5         1,288.00             -                               13.69
                                                                                                                6         1,288.00             -                               13.69
                                                                                                                7         1,288.00             -                               13.69
                                                                                                                8         1,288.00             -                               13.69
                                                                                                                9         1,288.00             -                               13.69
                                                                                                               10         1,288.00             -                               13.69
                                                                                                               11         1,288.00             -                               13.69
                                                                                                               12         1,288.00             -                               13.69
                                                                                            Mar-10             13         1,288.00           11.93       11.93      ######     13.69   164.22
                                                                                                               14         1,276.07           11.93                             13.56
                                                                                                               15         1,264.15           11.93                             13.43
                                                                                                               16         1,252.22           11.93                             13.30
                                                                                                               17         1,240.30           11.93                             13.18
                                                                                                               18         1,228.37           11.93                             13.05
                                                                                                               19         1,216.44           11.93                             12.92
                                                                                                               20         1,204.52           11.93                             12.80
                                                                                                               21         1,192.59           11.93                             12.67
                                                                                                               22         1,180.67           11.93                             12.54
                                                                                                               23         1,168.74           11.93                             12.42
                                                                                                               24         1,156.81           11.93                             12.29
                                                                                            Mar-11             25         1,144.89           11.93      143.11      ######     12.16   154.34
                                                                                                               26         1,132.96           11.93                             12.04
                                                                                                               27         1,121.04           11.93                             11.91
                                                                                                               28         1,109.11           11.93                             11.78
                                                                                                               29         1,097.19           11.93                             11.66
                                                                                                               30         1,085.26           11.93                             11.53
                                                                                                               31         1,073.33           11.93                             11.40
                                                                                                               32         1,061.41           11.93                             11.28
                                                                                                               33         1,049.48           11.93                             11.15
                                                                                                               34         1,037.56           11.93                             11.02
                                                                                                               35         1,025.63           11.93                             10.90
                                                                                                               36         1,013.70           11.93                             10.77
                                                                                            Mar-12             37         1,001.78           11.93      143.11      989.85     10.64   136.09
                                                                                                               38           989.85           11.93                             10.52
                                                                                                               39           977.93           11.93                             10.39
                                                                                                               40           966.00           11.93                             10.26
                                                                                                               41           954.07           11.93                             10.14
                                                                                                               42           942.15           11.93                             10.01
                                                                                                               43           930.22           11.93                              9.88
                                                                                                               44           918.30           11.93                              9.76
                                                                                                               45           906.37           11.93                              9.63
                                                                                                               46           894.44           11.93                              9.50
                                                                                                               47           882.52           11.93                              9.38
                                                                                                               48           870.59           11.93                              9.25
                                                                                            Mar-13             49           858.67           11.93      143.11      846.74      9.12   117.84
                                                                                                               50           846.74           11.93                              9.00
                                                                                                               51           834.81           11.93                              8.87
                                                                                                               52           822.89           11.93                              8.74
                                                                                                               53           810.96           11.93                              8.62
                                                                                                               54           799.04           11.93                              8.49
                                                                                                               55           787.11           11.93                              8.36
                                                                                                               56           775.19           11.93                              8.24
                                                                                                               57           763.26           11.93                              8.11
                                                                                                               58           751.33           11.93                              7.98
                                                                                                               59           739.41           11.93                              7.86
                                                                                                               60           727.48           11.93                              7.73
                                                                                            Mar-14             61           715.56           11.93      143.11      703.63      7.60    99.60
                                                                                                               62           703.63           11.93                              7.48
                                                                                                               63           691.70           11.93                              7.35
                                                                                                               64           679.78           11.93                              7.22
                                                                                                               65           667.85           11.93                              7.10
                                                                                                               66           655.93           11.93                              6.97
                                                                                                               67           644.00           11.93                              6.84
                                                                                                               68           632.07           11.93                              6.72
                                                                                                               69           620.15           11.93                              6.59
                                                                                                               70           608.22           11.93                              6.46
                                                                                                               71           596.30           11.93                              6.34
                                                                                                               72           584.37           11.93                              6.21
                                                                                            Mar-15             73           572.44           11.93      143.11      560.52      6.08    81.35
                                                                                                               74           560.52           11.93                              5.96
                                                                                                               75           548.59           11.93                              5.83
                                                                                                               76           536.67           11.93                              5.70
                                                                                                               77           524.74           11.93                              5.58
                                                                                                               78           512.81           11.93                              5.45
                                                                                                               79           500.89           11.93                              5.32
                                                                                                               80           488.96           11.93                              5.20
                                                                                                               81           477.04           11.93                              5.07
                                                                                                               82           465.11           11.93                              4.94
                                                                                                               83           453.19           11.93                              4.82
                                                                                                               84           441.26           11.93                              4.69
                                                                                            Mar-16             85           429.33           11.93      143.11      417.41      4.56    63.10
                                                                                                               86           417.41           11.93                              4.43
                                                                                                               87           405.48           11.93                              4.31
                                                                                                               88           393.56           11.93                              4.18
                                                                                                               89           381.63           11.93                              4.05
                                                                                                               90           369.70           11.93                              3.93
                                                                                                               91           357.78           11.93                              3.80
                                                                                                               92           345.85           11.93                              3.67
                                                                                                               93           333.93           11.93                              3.55
                                                                                                               94           322.00           11.93                              3.42
                                                                                                               95           310.07           11.93                              3.29
                                                                                                               96           298.15           11.93                              3.17
                                                                                            Mar-17             97           286.22           11.93      143.11      274.30      3.04    44.86
                                                                                                               98           274.30           11.93                              2.91
                                                                                                               99           262.37           11.93                              2.79
                                                                                                              100           250.44           11.93                              2.66
                                                                                                              101           238.52           11.93                              2.53
                                                                                                              102           226.59           11.93                              2.41
                                                                                                              103           214.67           11.93                              2.28
                                                                                                              104           202.74           11.93                              2.15
                                                                                                              105           190.81           11.93                              2.03
                                                                                                              106           178.89           11.93                              1.90
                                                                                                              107           166.96           11.93                              1.77
                                                                                                              108           155.04           11.93                              1.65
                                                                                            Mar-18            109           143.11           11.93      143.11      131.19      1.52    26.61
                                                                                                              110           131.19           11.93                              1.39
                                                                                                              111           119.26           11.93                              1.27
                                                                                                              112           107.33           11.93                              1.14
                                                                                                              113            95.41           11.93                              1.01
                                                                                                              114            83.48           11.93                              0.89
                                                                                                              115            71.56           11.93                              0.76
                                                                                                              116            59.63           11.93                              0.63
                                                                                                              117            47.70           11.93                              0.51
                                                                                                              118            35.78           11.93                              0.38
                                                                                                              119            23.85           11.93                              0.25
                                                                                            Mar-19            120            11.93           11.93      131.19         -        0.13     8.36
                          Paranjpe Autocast Pvt. LTD
                          Rajasthan
                          No. of Machine                              4
                          Total KW                                 3200

                          Month                        Days
                          Mar                                        31
                          Days in first year                         31
                          days in a year                            365
                          Days of 21st year                         334

                                     Year                Generation                    Deration in Energy generation in 6th,10th,14th,18th by=                1.25%
                          1st to 5th                           64.00
                          6th to 9th                           63.20
                          10th to 13th                         62.41
                          14th to 17th                         61.63
                          18th to 20th                         60.86




ELECTRICITY SALE INCOME
Paranjpe Autocast Pvt. LTD                             Rajasthan

                                   Mar-09                  Mar-10          Mar-11     Mar-12     Mar-13       Mar-14                Mar-15                Mar-16      Mar-17     Mar-18    Mar-19    Mar-20    Mar-21    Mar-22    Mar-23    Mar-24    Mar-25    Mar-26    Mar-27    Mar-28    Mar-29           Total
1 April to 28 February.
Generation                                                         58.56      58.56      58.56     58.56           58.56                          57.83       57.83      57.83     57.83     57.11     57.11     57.11     57.11     56.39     56.39     56.39     56.39     55.69     55.69     55.69          1145.19
Rate Rs / kWh                                                       3.59       3.61       3.63      3.65            3.67                           3.69        3.71       3.73      3.75      3.77      3.79      3.81      3.82      3.83      3.84      3.85      3.86      3.87      3.88      3.89
1 March to 31March
Generation                                      5.44                5.44       5.44       5.44       5.44           5.37                           5.37        5.37       5.37      5.30      5.30      5.30      5.30      5.23      5.23      5.23      5.23      5.17      5.17      5.17                     106.29
Rate Rs / kWh                                   3.59                3.61       3.63       3.65       3.67           3.69                           3.71        3.73       3.75      3.77      3.79      3.81      3.82      3.83      3.84      3.85      3.86      3.87      3.88      3.89

                                                                                                                                                                                                                                                                                                                1251.48
Sales Revenue
1 April to 28 February.                         0.00          210.24         211.41     212.58    213.75          214.92                         213.39      214.55     215.70    216.86    215.29    216.43    217.58    218.15    215.99    216.55    217.11    217.68    215.51    216.07    216.63
1 March to 31March                             19.51           19.62          19.73      19.84     19.95           19.81                          19.91       20.02      20.13     19.98     20.09     20.19     20.25     20.05     20.10     20.15     20.20     20.00     20.05     20.11      0.00

TOTAL Receipts                                 19.51          229.86         231.14     232.42    233.70          234.73                         233.30      234.57     235.83    236.84    235.38    236.63    237.82    238.19    236.08    236.70    237.32    237.68    235.57    236.18    216.63   0.00   4706.08
Paranjpe Autocast Pvt. LTD Rajasthan
Particular                Year      Year          Year          Year          Year          Year
                           Mar-09     Mar-10       Mar-11        Mar-12        Mar-13        Mar-14


1 April to 28 February.                              18.30         19.22         20.18         21.19

1 March to 31March                         1.70          1.78          1.87          1.97          2.06


Total Rs. In Lakhs                         1.70      20.08         21.09         22.14         23.25
Year          Year          Year          Year          Year          Year          Year          Year          Year
 Mar-15        Mar-16        Mar-17        Mar-18        Mar-19        Mar-20        Mar-21        Mar-22        Mar-23


   22.25         23.36         24.53         25.75         27.04         28.39         29.81         31.30         32.87

       2.17          2.28          2.39          2.51          2.64          2.77          2.91          3.05          3.20


   24.41         25.63         26.92         28.26         29.67         31.16         32.72         34.35         36.07
Year          Year          Year          Year          Year          Year
 Mar-24        Mar-25        Mar-26        Mar-27        Mar-28        Mar-29


   34.51         36.24         38.05         39.95         41.95         44.04

       3.36          3.53          3.71          3.89          4.09


   37.87         39.77         41.76         43.84         46.04         44.04
                                      Benchmark as per CAPM =                                15.75%


                                            200                              GUJ IND                                 REL INFRA                        TATA POWER                     BF Utilities                 Neyveli Lignite Corporation
                       Month        Open        Close         Return         Open         Close        Return        Open        Close      Return    Open      Close      Return    Open         Close Return    Open       Close       Return
                            Apr-07     1,556.72      1,666.14          7.03%        55.15        63.70       15.50%       495.15     508.40     2.68%    509.45     591.65    16.14% 2,329.00 1,874.85 -19.50%        50.40        62.25    23.51%
                           May-07      1666.14       1,766.08          6.00%         63.7        65.05         2.12%       508.4     539.65     6.15%    591.65     580.25    -1.93% 1874.85 1,899.65       1.32%     62.25        64.35     3.37%
                            Jun-07     1766.08       1,804.81          2.19%        65.05        67.90         4.38%      539.65     614.10    13.80%    580.25     670.95    15.63% 1899.65 1,832.75      -3.52%     64.35        61.75    -4.04%
                             Jul-07    1804.81       1,894.18          4.95%         67.9        59.90      -11.78%        614.1     793.45    29.21%    670.95     734.05     9.40% 1832.75 2,513.05      37.12%     61.75        81.65    32.23%
                           Aug-07      1894.18       1,857.70         -1.93%         59.9        60.95         1.75%      793.45     779.75    -1.73%    734.05     683.75    -6.85% 2513.05 2,122.10 -15.56%         81.65        76.50    -6.31%
                            Sep-07       1857.7      2,118.86         14.06%        60.95        86.20       41.43%       779.75 1,205.50      54.60%    683.75     855.20    25.07%    2122.1 2,399.50    13.07%      76.5       105.20    37.52%
                            Oct-07     2118.86       2,439.87         15.15%         86.2       112.85       30.92%       1205.5 1,866.80      54.86%     855.2 1,211.60      41.67%    2399.5 2,598.10     8.28%     105.2       140.05    33.13%
                           Nov-07      2439.87       2,454.20          0.59%       112.85       108.70        -3.68%      1866.8 1,738.10      -6.89%    1211.6 1,172.30      -3.24%    2598.1 2,024.95 -22.06%      140.05       235.55    68.19%
                            Dec-07       2454.2      2,656.52          8.24%        108.7       133.60       22.91%       1738.1 2,134.60      22.81%    1172.3 1,470.95      25.48% 2024.95 2,264.60      11.83%    235.55       257.05     9.13%
                            Jan-08     2656.52       2,230.39        -16.04%        133.6       105.20      -21.26%       2134.6 1,984.10      -7.05% 1470.95 1,280.00 -12.98%          2264.6 1,494.40 -34.01%      257.05       142.20 -44.68%
                            Feb-08     2230.39       2,217.47         -0.58%        105.2       110.75         5.28%      1984.1 1,567.75 -20.98%          1280 1,401.10       9.46%    1494.4 1,200.20 -19.69%       142.2       151.60     6.61%
                           Mar-08      2217.47       1,932.40        -12.86%       110.75        90.20      -18.56%     1567.75 1,251.15 -20.19%         1401.1 1,171.90 -16.36%        1200.2 1,062.50 -11.47%       151.6       119.90 -20.91%

                                                                                             BETA                   1.77              BETA      2.17          BETA            1.61            BETA            1.33           BETA             2.22




Source:- For the values of BSE 200
http://www.bseindia.com/histdata/hindices.asp



Source :- For the values of all stocks
http://www.moneycontrol.com/
*** Here you have to select stock and its date , So you willl get the value.



Company                 Beta          D/E ratio      Tax                                     Asset Beta
GUJ IND                        1.77           0.35         27.06%      72.94%         0.26           1.41
REL INFRA                      2.17           0.49          5.81%      94.19%         0.46           1.48
TATA POWER                     1.61           0.43         10.25%      89.75%         0.39           1.16
BF Utilities                   1.33           0.58         12.48%      87.52%         0.51           0.88
Neyveli Lignite Corporation    2.22           0.24         22.50%      77.50%         0.19           1.87




                                      BSE 200
                                      Start Date                     1-Mar-89
                                      Base value                           100
                                      End Date                      31-Mar-08
                                      Close Value                     1,932.40
                                      Total maturity in Yr.             19.08
                                      Market Return                    16.79%
                                      Rf                                 8.12% http://rbi.org.in/scripts/AnnualReportPublications.aspx?Id=901
                                      MRP                                8.67%
                                      Beta                                0.88
                                      ER                               15.75%
                                           Sensitivity Analysis
   Variation                  -10%           -5%       0%
   Equity IRR                 6.31%         8.35%        10.61%
Annual Generation
(In Lakhs Unit)                57.6          60.8          64.00




                                     Sensitivity Analysis
   Variation                    -10%    -5%        0%
  Equity IRR                   11.12%       10.87%         10.61%
  O&M Cost ( In Lakhs )               18            19     20.00




                                     Sensitivity Analysis
   Variation                    -10%    -5%        0%
  Equity IRR                   15.57%       12.85%         10.61%
  Project Cost ( In Lakhs)       1656         1748        1840.00




Tarrif varied by             Sensitivity Analysis
   Variation                    -10%           -5%           0%
  Equity IRR                    6.44%        8.43%         10.61%
sitivity Analysis
                    5%          10%
                13.00%          15.64%

                    67.2         70.4        0%



sitivity Analysis
                      5%          10%
                    10.36%       10.10%
                           21           22   0%



sitivity Analysis
                      5%          10%
                     8.73%        7.04%
                     1932          2024      0%




                      5%          10%
                    12.93%       15.49%      0%

						
Related docs
Other docs by hyh95662
Ofccp for Federal Construction Contracts
Views: 11  |  Downloads: 0
Offer to Purchase Raw Land
Views: 48  |  Downloads: 1
Offer in Pr Services Template
Views: 27  |  Downloads: 1
Offer to Purchase a House
Views: 4  |  Downloads: 0
Offer to Purchase Geothermal Llc
Views: 31  |  Downloads: 0
Offer Letters for Real Estate
Views: 27  |  Downloads: 0
Offer Purchase Shares
Views: 20  |  Downloads: 0
Offer of Corporate Employment
Views: 9  |  Downloads: 0