What you’ll learn:
Financial Modeling of 25MW of Solar Power Plant considering Electricity Sell to State under Power Purchase Agreement
Formulation of Initial Parameters in Excel Sheet
Profit and Loss Account Statement in Excel Sheet
Taxable income and Tax Calculation in Excel Sheet
Cash Flow Analysis
Calculation of Internal Rate of Return
Calculation of Cumulative Saving Over 25 Years Lifespan
Calculation of Net Present Value
Calculation of Exact Payback Points
Calculation of Accelerated Depreciation
Calculation of AD Benefits in Tax
Sensitivity Analysis of Feed In Tariff on %IRR
Sensitivity Analysis of Feed In Tariff on Savings
Sensitivity Analysis of Feed In Tariff on NPV
Sensitivity Analysis of Feed In Tariff on Payback Period
Requirements:
Pen, Notebook, Calculator and Laptop
Microsoft Excel 2007 Onwards
Curiosity about knowledge in solar field
Enthusiasm to learn
Description:
Welcome to your course “Financial Modeling of 25MW Solar Plant under PPA with State” this course is designed for the Solar Industry Business Persons and Investors who wants to invest in solar project. Solar accountant who wants to learn balance sheet of Solar Project and the solar technicians who wants to learn the financial modeling of solar power plant.
This course explains the Following Parameters in Detail:
A) Financial Modeling of 25MW of Solar Power Plant under PPA with State
In the excel Sheet where all parameters are club together to obtain the Final Master Excel Sheet.
– Formulation of Initial Parameters
– Profit and Loss Account Statement
– Taxable income and Tax Calculation
– Cash Flow Analysis
– Calculation of Internal Rate of Return
– Calculation of Cumulative Saving Over 25 Years Lifespan
– Calculation of Net Present Value
– Calculation of Exact Payback Points
B] Sensitivity Analysis of Solar Power Plant
– Sensitivity Analysis of Feed In Tariff on Calculation of Internal Rate of Return
– Sensitivity Analysis of Feed In Tariff on Calculation of Cumulative Saving Over 25 Years Lifespan
– Sensitivity Analysis of Feed In Tariff on Calculation of Net Present Value
– Sensitivity Analysis of Feed In Tariff on Calculation of Exact Payback Points
