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