https://www.udemy.com/course/financial-modeling-of-25mw-solar-plant-under-ppa-with-state

Learn Financial Modeling  and Sensitivity Analysis of 25 MW Solar Power Plant when electricity sell to state

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

  In the excel Sheet where all parameters are explain very well. 

     - Formulation of Initial Parameters: Parameters are required for financial modeling

     - Profit and Loss Account Statement: Total Revenue and Expenses

     - Taxable income and Tax Calculation: Parameters for taxable income and tax calculations

     - Cash Flow Analysis: Cash in and Out the system

     - Calculation of Internal Rate of Return: %IRR

     - Calculation of Cumulative Saving Over 25 Years Lifespan: Equity Turnaround the Project

     -  Calculation of Net Present  Value: NPV value

     - Calculation of Exact Payback Points: Payback PeriodWho this course is for:Solar Business PersonSolar InvestorsSolar EntrepreneursSolar InstallersSolar Industry PersonMBA StudentsMechanical StudentsElectrical StudentsSolar PV DesignerSolar Sales Person

Who this course is for:

Solar Business Person

Solar Investors

Solar Entrepreneurs

Solar Installers

Solar Industry Person

MBA Students

Mechanical Students

Electrical Students

Solar PV Designer

Solar Sales Person