Skip to content
View in the app

A better way to browse. Learn more.

Forum Valentin Software

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

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

Featured Replies

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

 

 

 

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.