INPUTS FOR CALCULATION OF PROJECT FINANCIALS Yellow cells require data entry by user
Blue cells require only 'selection' from available drop-down list
All other cells are locked and no changes can be made in the contents therein
Contact Information Customer's Name
Temple Advertising
Sales Office
Address City Pin Code State
Sales Manager Bangalore
Sales Contact Number
Customer Contact Person
Proposal Number
Customer Contact Number
Date of Proposal
3-Oct-09
Project Details
WTG Model (Rating in MW) No. of WTGs Price per WTG Total Project Size Total Project Cost Est. Annual Generation per WTG
O & M Price for 2nd year Annual Escalation in O&M Price from 3rd year onwards
1.25 MW 1
Depreciation Benefit
With Dep. Benefit
Commissioning Period
October to March
675 Rs Lacs 1.25 MW 675 Rs. Lacs
Est. rate for carbon trading (Rs. Per unit of power)
0.5
Number of years CDM Available
10
25 KWh (units Lacs)
12 Rs. Lacs 5%
Project Location (State)
Karnataka
Project Type
Sale EB
Generation Based Incentive (GBI)
No
Investment Details Equity (%) Borrowings (%) Rate of Interest p.a. (%)
30%
Loan Tennure (Years)
7
70%
Moratorium Period
1
13.0%
Summary of Project Financials for Wind Power Project Comprising of 1 no(s) of 1.25 WTG in Karnataka Contact Information Customer's Name
Temple Advertising
-
Address
Sales office
-
Sales Manager
-
City
Bangalore
Pin Code
0
Sales Contact Number
0
0
-
State
Customer Contact Person
0
Proposal Number
Customer Contact Number
0
Date of Proposal
03-Oct-09
Basis for Calculations
IRR & Payback Calculations 1
Equity (Promotor's Contribution)
202.5 Lacs
30%
Project Life Cycle Period
2
Borrowings (Bank Loan)
472.5 Lacs
70%
WTG Model (Rating in MW)
3
Project Investment (1+2)
675.0 Lacs
Total Project Size
4
Life cycle expenses (O&M, Insurance)
421.8 Lacs
No. of WTGs
5
Interest on Loan
230.1 Lacs Estimated annual power generation per WTG in Units
6
Expenses over Project Life Cycle (4+5)
7
Estimated revenue from sale of power
8
Gain from Tax Saving due to depreciation
224.3 Lacs
Project Type
9
Estimated additional revenue from Carbon Trading
112.5 Lacs
Prevaling Power Purchase Tariff (for sale to EB)
10
Estimated revenue over Project Life Cycle (7 + 8 + 9)
2,036.8 Lacs
11
Net Gain over Project Life Cycle (10-(3+6))
710.0 Lacs
12
Equity IRR
12.05%
Estimated savings in power expenditure per unit (%)
13
Project IRR
12.53%
Rate of Interest p.a. (%)
14
Project Payback
15
Weighted average DSCR for the period of loan repayment
651.8 Lacs 1,700.0 Lacs
5.5 1.16 : 1
Est. rate for carbon trading (Rs. Per unit of power)
Prevaling Cost of Power (for captive project) Cost of power generation from wind power project (Avg. over project life cycle)
20 Years 1.25 MW 1.3 MW 1
(kWh 25.00 units) (Lacs)
0.50
Rs Per Unit
Sale EB 3.40
Rs Per Unit
NA
Rs Per Unit
2.59
Rs Per Unit
NA 13%
Loan Tennure including moratorium (Years)
7 years
Moratorium Period
1 years
O & M Price for 2nd year (1st year O&M is free. Annual Escalation in O&M price of 5 % from 3rd year onwards) Commissioning Period
12.00 Rs Lacs October to March
Disclaimer The above data is only indicative of the returns on investment in a typical wind power project. The actual financial could vary depending upon changes in project parameters. This statement does not warrant accuracy / completeness of the data or calculations. There is no explicit / implicit warranty associated.
(Feasibility Report) COST BREAK UP
Cost of Land Cost of WTG Erection & Commissioning Charge Infrastructure Charges Processing Fees Total Cost Cost Per MW. Yr Receipts (Rs Lacs) Power Tariff (Rs. / kWh) Power Tariff (Rs. / kWh) Receipt (Sale of Power) Receipt (Sale of Power) IT Benefit Generation Based Incentive CDM Benefit
Rs Lacs/WTG Rs Lacs
15.00 507.50 113.00 39.50 0.00 675.00 540.0
15.00 507.50 113.00 39.50 0.00
Mar'10
Mar'11
0
1
Expenses (Rs. Lacs) O&M Service Tax on O&M Intrest on Loan Insurance Scheduling charges Total Expenses
Mar'12
Mar'13
2
3
Mar'15
5
Mar'16
Mar'17
6
7
Mar'18
8
Mar'19
9
State of Installation
1
O & M (Rs. Lacs) Escalation Free O&M (Yrs) Generation (kWh) Losses
12 5.0% 1 25 0%
Tarrif (i) (Rs.) Escalation Tarrif (ii) (Rs.) Insurance Serive Tax Rate
Karnataka
3.40 0.00 3.40 0.50 12.36%
Depreciation Rate
80%
Corp. Tax
33.99%
Mar'20
Mar'21
Mar'22
Mar'23
Mar'24
Mar'25
Mar'26
Mar'27
Mar'28
Mar'29
Mar'30
10
11
12
13
14
15
16
17
18
19
20
3.40 0.00 0.0 85.0 0.9 0.0 12.5
3.40 0.00 0.0 85.0 0.2 0.0 12.5
3.40 0.00 0.0 85.0 0.0 0.0 12.5
3.40 0.00 0.0 85.0 0.0 0.0 12.5
3.40 0.00 0.0 85.0 0.0 0.0 12.5
3.40 0.00 0.0 85.0 0.0 0.0 12.5
3.40 0.00 0.0 85.0 0.0 0.0 12.5
3.40 0.00 0.0 85.0 0.0 0.0 0.0
3.40 0.00 0.0 85.0 0.0 0.0 0.0
3.40 0.00 0.0 85.0 0.0 0.0 0.0
3.40 0.00 0.0 85.0 0.0 0.0 0.0
3.40 0.00 0.0 85.0 0.0 0.0 0.0
3.40 0.00 0.0 85.0 0.0 0.0 0.0
3.40 0.00 0.0 85.0 0.0 0.0 0.0
3.40 0.00 0.0 85.0 0.0 0.0 0.0
3.40 0.00 0.0 85.0 0.0 0.0 0.0
3.40 0.00 0.0 85.0 0.0 0.0 0.0
89.7
192.7
119.0
101.8
98.4
97.7
97.5
97.5
97.5
97.5
97.5
85.0
85.0
85.0
85.0
85.0
85.0
85.0
85.0
85.0
85.0
0.0 0.0 0.0 0.0 0.0
0.0 0.0 59.0 0.5 0.0
12.0 1.5 50.5 0.5 0.0
12.6 1.6 41.7 0.5 0.0
13.2 1.6 32.9 0.5 0.0
13.9 1.7 24.1 0.5 0.0
14.6 1.8 15.4 0.5 0.0
15.3 1.9 6.6 0.5 0.0
16.1 2.0 0.0 0.5 0.0
16.9 2.1 0.0 0.5 0.0
17.7 2.2 0.0 0.5 0.0
18.6 2.3 0.0 0.5 0.0
19.5 2.4 0.0 0.5 0.0
20.5 2.5 0.0 0.5 0.0
21.6 2.7 0.0 0.5 0.0
22.6 2.8 0.0 0.5 0.0
23.8 2.9 0.0 0.5 0.0
24.9 3.1 0.0 0.5 0.0
26.2 3.2 0.0 0.5 0.0
27.5 3.4 0.0 0.5 0.0
28.9 3.6 0.0 0.5 0.0
0.0
59.5
64.4
56.3
48.3
40.2
32.2
24.3
18.6
19.5
20.4
21.4
22.5
23.6
24.7
25.9
27.2
28.5
29.9
31.4
32.9
133.2 223.0 67.5
54.6 277.6 67.5
45.5 323.0 67.5
50.1 373.1 67.5
57.4 430.5 67.5
65.3 495.8 67.5
73.2 569.1 67.5
78.9 648.0 33.8
78.0 726.0 0.0
77.1 803.1 0.0
63.6 866.7 0.0
62.5 929.2 0.0
61.4 990.7 0.0
60.3 1050.9 0.0
59.1 1110.0 0.0
57.8 1167.8 0.0
56.5 1224.3 0.0
55.1 1279.4 0.0
53.6 1332.9 0.0
52.1 1385.0 0.0
-17.4 17.4 89.7
-9.3 34.8 155.5
-1.8 34.8 142.6
6.3 34.8 120.5
14.4 34.8 103.1
22.4 34.8 93.0
30.4 34.8 90.8
38.4 34.8 96.6
44.1 34.8 141.7
43.2 34.8 219.8
42.2 34.8 296.8
28.7 34.8 360.4
27.7 34.8 423.0
26.6 34.8 484.4
25.4 34.8 544.7
24.2 34.8 603.8
23.0 34.8 661.6
21.6 34.8 718.0
20.2 34.8 773.1
38.3 15.3 826.7
52.1 0.0 878.8
8.8
Project Payback (Year)
5.5
D S C R (Debt Service Coverage Ratio)
4
472.50 202.50
3.40 0.00 0.0 85.0 4.3 0.0 12.5
ESTIMATED RESULTS
Internal Rate of Return (20 Yr.)
Mar'14
472.50 202.50
3.40 0.00 0.0 85.0 21.5 0.0 12.5
Equity Payback (Year)
` Cumulative cash Inflow (20 Years) (Rs. Lacs/ WTG)
1.25
70% 30% 13% 7 1
89.7 89.7
Yearly Cash Accrual Cumulative Cash accrual Loan Repay Profit Before Tax Depreciation (As per A/c Stnd.) Cumulative cash Inflow
Loan Equity Interest Loan term Moratorium
Number of WTGs
3.40 0.00 0.0 85.0 107.7 0.0 0.0
89.7
Total Receipts
Size of Project
878.75 12.53% 1.16