Rating 1.7 out of 5 (5 ratings in Udemy)

• How to do financial modelling of solar power plants/projects and decide about the profitability in investing solar power plant by covering the topics as follows:
• Inputs: Solar insolation (kWh/m2/day) , Various component specs & efficiencies , Units produced (kWh/ year) , Generation derating factor (%) , Tracker Efficiency (%) , Tariff Discount (%)
• Carbon credits rate (Euro/CER) , Project Cost , Loan Interest rates (%) , Moratorium period (years) , Capital structuring (Equity ratio)
• Optimization levers to key project costs , Accelerated Depreciation selection, Tax incentives, Tax and MAT rates (%)
• Outputs: Levelised cost of Energy (LCOE), Project IRR, Project Payback, Equity IRR, Equity Payback, Average DSCR, Return on Equity (ROE)
• Return on Capital Employed (ROCE), Return on Investment (ROI), Gains from Tax savings due to depreciation, Net Estimated Expenses and Revenues in 25 years, Net Gain over Project Life Cycle, Cash Flows for project life cycle
• Modelling Analysis : Project Costs details, Electricity Generation estimates, Depreciation including Accelerated Depreciation, Loan Interest, Working Capital (for pre-operative phase), Projected Balance Sheet
• Profit & Loss statement, Income Tax (both under Companies Act and Income Tax Act), Minimum Alternative Tax (MAT), Cash Flows, Debt Service Charge Ratio (DSCR), Internal Rate of Return (IRR)
• Breakeven point, Payback Ratios, Summary – Various ratios, FORM-II to FORM-VI – Various standard forms required for bankable Detailed, Project Report, Carbon Credit modeling
• Bid Related Results : Scenario Analysis to arrive at optimum bid tariff rate, Bank