Dis

  • July 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Dis as PDF for free.

More details

  • Words: 1,235
  • Pages: 3
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

Related Documents

Dis
July 2020 25
Tar Dis
October 2019 37
Mat. Dis.
May 2020 1
Dis 2656
May 2020 3
Dis Curs
June 2020 5
Safe Dis
November 2019 25