Get documents about "Installment Interest Equal Calculation
W
Description
Installment Interest Equal Calculation document sample
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
Fake borrowers Fake loan amounts Altus Venture Capital Fund V AVCF V 189 million Altus Venture Capital Fund IV AVCF IV
Views: 60 | Downloads: 0
Insurance Customers Assessment of Service Quality in India a Critical Evaluation
Views: 16 | Downloads: 0
