Jump to content

why first year electricity savings in financial analysis is differ from cash flow first year electricity savings.


asif

Recommended Posts

Hello asif

For the financial analysis there is always a full year taken. Within the cash flow table the days of a whole year are taken into account.

In case the date for Start of Operation on the navigational page Project data does not equal the first day of a month, there are some days missing and the values differ.

Kind regards
Frederik

  • Like 1
Link to comment
Share on other sites

thank you for replying.

can you teach me cashflow table. now why first year electricity savings in financial analysis is differ from cash flow first year electricity savings even start of operation is 1.1.24

please reply me soon . if need any other data i can provide

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...