Financial Modeling of 1MW Solar Captive Power Plant in Excel
Learn financial modeling of a 1MW solar power plant in Excel. This course is designed for solar industry professionals and investors. Gain insights on parameters like profit and loss, cash flow analysis, IRR, NPV, and more. Perfect for solar business persons, entrepreneurs, installers, and students.
What you’ll learn
- Financial Modeling of 1MW of Solar Power Plant considering Capex Model
- 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
Show moreShow less
Welcome to your course “Financial Modeling of 1MW Solar Captive Power Plant in Excel” 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 1MW of Solar Power Plant under captive domain
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 Period
Who this course is for:
- Solar Business Person
- Solar Investors
- Solar Entreprenuers
- Solar Installers
- Solar Industry Person
- MBA Students
- Mechanical Students
- Electrical Students
- Solar PV Designer
- Solar Sales Person
User Reviews
Be the first to review “Financial Modeling of 1MW Solar Captive Power Plant in Excel”
You must be logged in to post a review.
There are no reviews yet.