Revenue vs Expenses
Rs. Crore - 25 Yrs
Cumulative ROI
% - 25 Yrs
Year-wise Summary - 25 Years (* = after loan closure, lower gen cost)
Project Particulars
Fill in your project details, then click Submit to calculate
Loading live rates...
Client / Company Information
Project Information
Auto = MW × Price/KW × 1,000
Auto = MW × Rs.18,00,000 — editable
% of Total Project Cost
Loan Parameters
Auto = Project Cost - RPI - − Capital Investment
Auto calculated
EMI × Tenure months
Total Repayment − Loan Amount
Generation & Efficiency
Total working days in a year
Days ÷ 30 avg days/month
BESS round-trip efficiency
MW × 1,000 × Efficiency% × Days
Pricing
Includes loan repayment — higher cost
After loan tenure — lower cost, higher profit
25-Year Financial Projection
Year column frozen - scroll right and down for all data
23 columns25 rows
Blue row = end of loan tenure. EMI = 0 from Year 11 onwards.
EMI Amortization Schedule
Monthly: · Annual:
Taxes & Miscellaneous Expenses
Optional annual costs — enabled items are added to cash outflow each year
Annual Additional Expenses
Each enabled item is added to annual Cash Outflow, reducing Cash Surplus and ROI. Disable a row to temporarily exclude it without deleting it.
On
Item Name
Annual Amount (Rs.)
Total Annual Additional Cost (enabled only):
Rs.0.00 Cr
How it works: Enabled tax/misc items are summed and added to annual Cash Outflow every year for the full project life. This reduces Cash Surplus, ROI%, and Payback Period. Examples: GST on generation, land tax, insurance, management fees, compliance costs.
Saved Scenarios
0 scenarios
Export Report
Download a complete PDF with all tables
Report Contents
1
Project Particulars
Company, plant size, cost, loan, tariff
2
Charts
Revenue vs Expenses & Cumulative ROI graphs
3
25-Year Projections
Year-by-year full financial model
4
EMI Amortization
Month-by-month for all loan years
Quick Preview