asif

why first year savings in financial analysis is different first year electricity savings in cashflow table whereas start of operation is 1.1.24. and what is the algo is used in the cashflow table 3mw, 3382kwp 21.7.23 2nd.docx

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

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

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