Jump to content

cashflow table. how to study it. please tell me anyone


asif

Recommended Posts

PV Generator Energy (AC grid)

4,645,692

kWh/Year

PV Generator Output

3010.4

kWp

Start of Operation of the System

1.1.24

 

Assessment Period

20

Years

Interest on Capital

1

%

Economic Parameters

Return on Assets

12.63

%

Accrued Cash Flow (Cash Balance)

35,41,96,573.58

Amortization Period

8.0

Years

Electricity Production Costs

2.23

₹/kWh

Payment Overview

Specific Investment Costs

65,000.00

₹/kWp

Investment Costs

19,56,76,000.00

One-off Payments

0.00

Incoming Subsidies

0.00

Annual Costs

0.00

₹/Year

Other Revenue or Savings

0.00

rs

Remuneration and Savings

Total Payment from Utility in First Year

0.00

₹/Year

First year savings

2,39,22,336.41

₹/Year

 

 

 

New Tariff (Example)

 

 

  Energy Price

5.15

₹/kWh

  Compensation for Surplus

0.00

₹/kWh

  Inflation Rate for Energy Price

 

Cashflow Table

 

Year 1

Year 2

Year 3

Year 4

Year 5

Investments

₹ -19,56,76,000.00

₹ 0.00

₹ 0.00

₹ 0.00

₹ 0.00

Electricity Savings

₹ 2,36,85,481.59

₹ 2,39,19,991.31

₹ 2,41,56,822.91

₹ 2,43,95,999.37

₹ 2,46,37,540.28

Annual Cash Flow

₹ -17,19,90,518.41

₹ 2,39,19,991.31

₹ 2,41,56,822.91

₹ 2,43,95,999.37

₹ 2,46,37,540.28

Accrued Cash Flow (Cash Balance)

₹ -17,19,90,518.41

₹ -14,80,70,527.10

₹ -12,39,13,704.20

₹ -9,95,17,704.83

₹ -7,48,80,164.55

 

 

 

 

 

 

 

Year 6

Year 7

Year 8

Year 9

Year 10

Investments

₹ 0.00

₹ 0.00

₹ 0.00

₹ 0.00

₹ 0.00

Electricity Savings

₹ 2,48,81,484.43

₹ 2,51,27,821.93

₹ 2,53,76,629.03

₹ 2,56,27,867.04

₹ 2,58,81,626.06

Annual Cash Flow

₹ 2,48,81,484.43

₹ 2,51,27,821.93

₹ 2,53,76,629.03

₹ 2,56,27,867.04

₹ 2,58,81,626.06

Accrued Cash Flow (Cash Balance)

₹ -4,99,98,680.12

₹ -2,48,70,858.19

₹ 5,05,770.85

₹ 2,61,33,637.88

₹ 5,20,15,263.94

 

 

 

 

 

 

 

Year 11

Year 12

Year 13

Year 14

Year 15

Investments

₹ 0.00

₹ 0.00

₹ 0.00

₹ 0.00

₹ 0.00

Electricity Savings

₹ 2,61,37,861.34

₹ 2,63,96,654.59

₹ 2,66,58,018.54

₹ 2,69,21,962.65

₹ 2,71,88,513.85

Annual Cash Flow

₹ 2,61,37,861.34

₹ 2,63,96,654.59

₹ 2,66,58,018.54

₹ 2,69,21,962.65

₹ 2,71,88,513.85

Accrued Cash Flow (Cash Balance)

₹ 7,81,53,125.28

₹ 10,45,49,779.87

₹ 13,12,07,798.41

₹ 15,81,29,761.05

₹ 18,53,18,274.90

 

 

 

 

 

 

 

Year 16

Year 17

Year 18

Year 19

Year 20

Investments

₹ 0.00

₹ 0.00

₹ 0.00

₹ 0.00

₹ 0.00

Electricity Savings

₹ 2,74,57,695.22

₹ 2,77,29,566.52

₹ 2,80,04,102.28

₹ 2,82,81,374.18

₹ 2,85,61,389.36

Annual Cash Flow

₹ 2,74,57,695.22

₹ 2,77,29,566.52

₹ 2,80,04,102.28

₹ 2,82,81,374.18

₹ 2,85,61,389.36

Accrued Cash Flow (Cash Balance)

₹ 21,27,75,970.12

₹ 24,05,05,536.63

₹ 26,85,09,638.91

₹ 29,67,91,013.10

₹ 32,53,52,402.46

 

 

 

 

 

 

 

Year 21

 

 

 

 

Investments

₹ 0.00

 

 

 

 

Electricity Savings

₹ 2,88,44,171.12

 

 

 

 

Annual Cash Flow

₹ 2,88,44,171.12

 

 

 

 

Accrued Cash Flow (Cash Balance)

₹ 35,41,96,573.58

 

 

 

 

 

 

 

 

 

 

Degradation and inflation rates are applied on a monthly basis over the entire observation period.  This is done in the first year.

 

 

 

 

 

2

%/Year

 

 

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...