Project Title Financial Modeling and Analysis of 10 MW Solar/Wind Power Project in Porbandar,
Gujarat IN
Techvardhan Power Pvt. Ltd (Any Company) “CLIENT” has signed a PPA for 25 years with GUVNL
for a 10 MW Solar PV / Wind Power Plant at a fixed tariff of Rs. 3.50 / kWh. The project location
is in Porbandar Gujarat, India.
They are expecting a net annual energy production of 18 Million kWh / year . The expected
CapEx is Rs. 3 Crore / MW and fixed OpEx is Rs. 30 Lacs / per annum for the whole plant.
They are seeking a non-recourse debt (project financing) with 70:30 as D/E ratio from leading
commercial banks in India as a 9 years (maximum) term loan.
                 Numbe     Operating                             Cape
 scenario        r         expense            Revenue            x       Kd
                                                                    30
Base Case              1               25      Rs. 3.50 / kWh.    lacs           0.85
                                                                    20
Upside                 2               20      Rs. 5.50 / kWh     lacs           0.05
                                                                    40
Downside               3               30      Rs. 2.50 / kWh     lacs           0.11
Expected increase in
charges+inflation                      0%        
 Operating capacity         1-10 yr     55%      
                           11 &
                           above       100%  
 Tax rate                              0.20      
                                                  Financing
Assumptions                                                                                       
 Debt                                  0.70      
 Equity                                0.30      
                                       12.0
 Debt tenure                           0         years
 Interest rate                         8.5%      
 Cost of equity                     14%  
Please prepare a financial model and analyze the cost, revenue and debt repayment ,
FCFF,FCFE. Calculate PROJECT IRR , equity IRR and DSCR.
ALL FOR BASE CASE WITH SCENARIO SHEET