# Installment Interest Equal Calculation

W
Description

Installment Interest Equal Calculation document sample

Shared by:
Categories
Tags
-
Stats
views:
6
posted:
3/8/2011
language:
English
pages:
6
Document Sample

```							                                                                          INTERNAL RATE OF RETURN (With Out CDM)

(Rs.in lacs)
2003      2004      2005     2006     2007     2008     2009     2010     2011     2012     2013     2014     2015     2016          2017

Capital Investment                                 -1850.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     0.00          0.00

Working capital Borrowings                             0.00   -100.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          0.00

Profit before tax                                      0.00    30.02     37.56     42.95    54.75    76.84    98.93   134.77   137.89   137.89   137.89   283.13   316.52   316.52       316.52

Add Depreciation and non cash expenses                 0.00   146.47    177.40    178.63   178.63   178.63   178.63   178.63   178.63   178.63   178.63    33.39     0.00     0.00          0.00

Add : Interest on TL                                   0.00   149.45    133.69     94.94    83.14    61.05    38.96     3.12     0.00     0.00     0.00     0.00     0.00     0.00          0.00

Add: Interst on OD                                     0.00      3.00      7.45     9.53    10.25    10.25    10.25    10.25    10.25    10.25    10.25    10.25    10.25    10.25        10.25

Less : Tax                                             0.00      2.31      2.94     3.65     4.65     6.53     8.41    11.46    11.72    11.72    11.72    24.07    26.90    26.90        26.90

Add : Salvage Value                                    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     0.00          0.00

Net cash flows                                     -1850.00   226.63    353.16    322.40   322.12   320.24   318.36   315.31   315.05   315.05   315.05   302.70   299.87   299.87       299.87

Post - Tax Project IRR %                             13.94

Calculation of Equity IRR

Operating Profit                                       0.00    30.02     37.56     42.95    54.75    76.84    98.93   134.77   137.89   137.89   137.89   283.13   316.52   316.52       316.52

Interest on TL and OD                                  0.00    152.45    141.14   104.47    93.39    71.30    49.21    13.37    10.25    10.25    10.25    10.25    10.25    10.25        10.25
Tax                                                    0.00      2.31      2.94     3.65     4.65     6.53     8.41    11.46    11.72    11.72    11.72    24.07    26.90    26.90        26.90
Nett Profit                                            0.00   -124.74   -106.52   -65.17   -43.29    -0.99    41.31   109.95   115.92   115.92   115.92   248.81   279.37   279.37       279.37

Project Outflow                          -550.00       0.00   -124.74   -106.52   -65.17   -43.29    -0.99    41.31   109.95   115.92   115.92   115.92   248.81   279.37   279.37       279.37

Equity IRR                                 5.41%
INTERNAL RATE OF RETURN (With CDM)

(Rs.in lacs)
2003       2004       2005       2006        2007     2008     2009     2010     2011     2012     2013     2014     2015           2016     2017

Capital Investment                                       -1850.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          0.00      0.00

Working capital Borrowings                                   0.00   -100.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      0.00

Profit before tax                                            0.00     30.02      37.56      42.95      107.49    173.53   195.62   231.46   234.58   234.58   234.58   379.82   413.21       413.21     360.47

Add Depreciation and non cash expenses                       0.00    146.47     177.40     178.63      178.63    178.63   178.63   178.63   178.63   178.63   178.63    33.39     0.00          0.00      0.00

Add : Interest on TL                                         0.00    149.45     133.69      94.94       83.14     61.05    38.96     3.12     0.00     0.00     0.00     0.00     0.00          0.00      0.00

Add: Interest on OD                                          0.00      3.00       7.45       9.53       10.25     10.25    10.25    10.25    10.25    10.25    10.25    10.25    10.25         10.25     10.25

Less : Tax                                                   0.00      2.31       2.94       3.65        9.14     14.75    16.63    19.67    19.94    19.94    19.94    32.28    35.12         35.12     30.64

Add : Salvage Value                                          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          0.00      0.00

Net cash flows                                           -1850.00    226.63     353.16     322.40      370.37    408.71   406.83   403.79   403.52   403.52   403.52   391.18   388.34       388.34     340.08

Post - Tax Project IRR %                                   16.93

Calculation of Equity IRR

Operating Profit                                             0.00     30.02      37.56      42.95      107.49    173.53   195.62   231.46   234.58   234.58   234.58   379.82   413.21       413.21     360.47

Interest on TL and OD                                        0.00    152.45     141.14     104.47       93.39     71.30    49.21    13.37    10.25    10.25    10.25    10.25    10.25        10.25      10.25
Tax                                                          0.00      2.31       2.94       3.65        9.14     14.75    16.63    19.67    19.94    19.94    19.94    32.28    35.12        35.12      30.64
Nett Profit                                                  0.00   -124.74    -106.52     -65.17        4.96     87.48   129.78   198.42   204.39   204.39   204.39   337.29   367.84       367.84     319.58

Project Outflow                               -550.00        0.00   -124.74    -106.52     -65.17        4.96     87.48   129.78   198.42   204.39   204.39   204.39   337.29   367.84       367.84     319.58

Equity IRR                                      10.80%

Assumptions on calculation on IRR

1. Up to 2006 Financial figures are acutual and audited.
2. We are charging Depreciation on SLM method at 10%.
3. Tax calculated under MAT provisions @ 8.50%
4.Differance in Profit Before Tax with CDM and With out CDM is in every year Rs. 7669000
We are expecting to receive 16,125 Carban Credits in every year as per Project indexation Note Book .
One Carbon Credit = 10 euro's                                                                       96.69
Hence 16963*10*57/- = 9668910.00
***              At the time of starting power project we have obtained 3 loans from different finacial instutions they are

1. Andhra Bank          Rs. 650.00 lacs
2. Canara Bank          Rs. 350.00 lacs
3. SBI                  Rs. 300.00 lacs

***              In the month of June 2004 we have shifted from Andhra Bank and Canara Bank to IOB .
The outstanding amount as on is Rs. 985.00 lacs

***              In the month of December 2004 the SBI out standing loan converted in to FCNR
loan account with \$ 550000& Rs 6,90000/-indian Rupes

***              Based on above reasons the interst of 2004, 2005 and 2006 is not in equal .i.e not in sequence

Intrest calculation for futuer years
IOB Loan account
Opening Bal      installment Closing balance interest
April-06       72173783        1386000       70787783 616484.40
May-06         70787783        1386000       69401783 604645.65
June-06        69401783        1386000       68015783 592806.90
July-06       68015783        1386000       66629783 580968.15
August-06        66629783        1386000       65243783 569129.40
September-06         65243783        1386000       63857783 557290.65
October-06         63857783        1386000       62471783 545451.90
November-06          62471783        1386000       61085783 533613.15
December-06          61085783        1386000       59699783 521774.40
January-07        59699783        1386000       58313783 509935.65
February-07         58313783        1386000       56927783 498096.90
March-07         56927783        1386000       55541783 486258.15         6616455.26
April-07       55541783        1386000       54155783 474419.40
May-07         54155783        1386000       52769783 462580.65
June-07        52769783        1386000       51383783 450741.90
July-07       51383783        1386000       49997783 438903.15
August-07        49997783        1386000       48611783 427064.40
September-07         48611783        1386000       47225783 415225.65
October-07         47225783        1386000       45839783 403386.90
November-07          45839783        1386000       44453783 391548.15
December-07          44453783        1386000       43067783 379709.40
January-08        43067783        1386000       41681783 367870.65
February-08         41681783        1386000       40295783 356031.90
March-08         40295783        1386000       38909783 344193.15         4911675.26
April-08       38909783        1386000       37523783 332354.40
May-08         37523783        1386000       36137783 320515.65
June-08        36137783        1386000       34751783 308676.90
July-08       34751783        1386000       33365783 296838.15
August-08        33365783        1386000       31979783 284999.40
September-08         31979783        1386000       30593783 273160.65
October-08         30593783        1386000       29207783 261321.90
November-08          29207783        1386000       27821783 249483.15
December-08          27821783        1386000       26435783 237644.40
January-09        26435783        1386000       25049783 225805.65
February-09         25049783        1386000       23663783 213966.90
March-09         23663783        1386000       22277783 202128.15         3206895.26
April-09       22277783        1386000       20891783 190289.40
May-09         20891783        1386000       19505783 178450.65
June-09        19505783        1386000       18119783 166611.90
July-09       18119783        1386000       16733783 154773.15
August-09        16733783        1386000       15347783 142934.40
September-09         15347783        1386000       13961783 131095.65
October-09         13961783        1386000       12575783 119256.90
November-09          12575783        1386000       11189783 107418.15
December-09          11189783        1386000         9803783   95579.40
January-10         9803783        1386000         8417783   83740.65
February-10          8417783        1386000         7031783   71901.90
March-10          7031783        1386000         5645783   60063.15       1502115.26
April-10        5645783        1386000         4259783   48224.40
May-10          4259783        1386000         2873783   36385.65
June-10         2873783        1386000         1487783   24546.90
July-10        1487783        1386000          101783   12708.15
August-10           101783        101783                0     869.40       122734.48
SBI FCNR
Opening Bal  installment Closing balance interest
April-06      18816611       410000       18406611 160725.22
May-06        18406611       410000       17996611 157223.14
June-06       17996611       410000       17586611 153721.05
July-06      17586611       410000       17176611 150218.97
August-06       17176611       410000       16766611 146716.89
September-06       16766611       410000       16356611 143214.80
October-06       16356611       410000       15946611 139712.72
November-06        15946611       410000       15536611 136210.64
December-06        15536611       410000       15126611 132708.55
January-07       15126611       410000       14716611 129206.47
February-07       14716611       410000       14306611 125704.39
March-07       14306611       410000       13896611 122202.30      1697565.13
April-07      13896611       410000       13486611 118700.22
May-07        13486611       410000       13076611 115198.14
June-07       13076611       410000       12666611 111696.05
July-07      12666611       410000       12256611 108193.97
August-07       12256611       410000       11846611 104691.89
September-07       11846611       410000       11436611 101189.80
October-07       11436611       410000       11026611    97687.72
November-07        11026611       410000       10616611    94185.64
December-07        10616611       410000       10206611    90683.55
January-08       10206611       410000         9796611   87181.47
February-08         9796611      410000         9386611   83679.39
March-08         9386611      410000         8976611   80177.30    1193265.13
April-08        8976611      410000         8566611   76675.22
May-08          8566611      410000         8156611   73173.14
June-08         8156611      410000         7746611   69671.05
July-08        7746611      410000         7336611   66168.97
August-08         7336611      410000         6926611   62666.89
September-08         6926611      410000         6516611   59164.80
October-08         6516611      410000         6106611   55662.72
November-08          6106611      410000         5696611   52160.64
December-08          5696611      410000         5286611   48658.55
January-09         5286611      410000         4876611   45156.47
February-09         4876611      410000         4466611   41654.39
March-09         4466611      410000         4056611   38152.30     688965.13
April-09        4056611      410000         3646611   34650.22
May-09          3646611      410000         3236611   31148.14
June-09         3236611      410000         2826611   27646.05
July-09        2826611      410000         2416611   24143.97
August-09         2416611      410000         2006611   20641.89
September-09         2006611      410000         1596611   17139.80
October-09         1596611      410000         1186611   13637.72
November-09          1186611      410000          776611   10135.64
December-09           776611      410000          366611     6633.55
January-10          366611      366611                0    3131.47    188908.44
CALCULATION OF DEPRECIATION
2006      2007      2008      2009     2010      2011       2012      2013      2014      2015       2016
Gross Block (Assets)        1786.30   1786.30   1786.30   1786.30   1786.30   1786.30   1786.30   1786.30   1786.30   1786.30    1786.30
Depreciation for the year    178.63    178.63    178.63    178.63    178.63    178.63    178.63    178.63     33.39       0.00       0.00
Cum.depreciation             502.50    681.13    859.76   1038.39   1217.02   1395.65   1574.28   1752.91   1786.30   1786.30    1786.30
Years (January to December)            Annual estimation of emission CDM Revenue
reductions in tonnes of CO2e  Considered for 10
Years
2007 (June to December)                           9253.00                        52.74
2008                                             16963.00                        96.69
2009                                             16963.00                        96.69
2010                                             16963.00                        96.69
2011                                             16963.00                        96.69
2012                                             16963.00                        96.69
2013                                             16963.00                        96.69
2014                                             16963.00                        96.69
2015                                             16963.00                        96.69
2016                                             16963.00                        96.69
2017 (January to May)                             7711.00                        43.95
Total estimated reductions (tones of            169632.00
CO2e)                                                                          966.90
Total number of crediting years                    10.00
Annual average over the crediting                16963.00
period of estimated reductions
(tonnes of CO2 e)                                                                96.69

```
Other docs by bao12053
Inform Bank for Expecting Payment Delay - PDF
Informes Consent