Financial Modeling of 1MW Solar Captive Power Plant in Excel
Learn Financial Modeling and Sensitivity Analysis of 1 MW Solar Captive Power Plant
Excel,Financial Analysis,Financial Modeling,Solar Energy,Finance & Accounting
Lectures -8
Duration -1 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
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
Goals
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
Prerequisites
- Basic Excel knowledge is required. Rest Financial models and Excel formulas you will learn here in detail.
![Financial Modeling of 1MW Solar Captive Power Plant in Excel Financial Modeling of 1MW Solar Captive Power Plant in Excel](https://d3mxt5v3yxgcsr.cloudfront.net/courses/15831/course_15831_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Financial Modeling of 1MW Solar Captive Power Plant in Excel Sheet
7 Lectures
-
Formulation of Parameters for Financial Modeling 13:10 13:10
-
Loan Repayment Schedule 12:32 12:32
-
Profit and Loss Account Statement 12:30 12:30
-
Taxable Income and Tax Calculation 13:12 13:12
-
Cash Flow Analysis 12:13 12:13
-
IRR,NPV, Cumulative Savings and Payback Calculation 10:52 10:52
-
Financial Snapshot and Graphical Analysis 03:01 03:01
Sensitivity Analysis of Financial Model
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Kiran Ramkrishna Beldar](https://www.tutorialspoint.com/assets/profiles/678762/profile/200_2786214-1688989214.jpg)
Kiran Ramkrishna Beldar
I am Prof. Kiran Beldar, I am a professor in Mumbai University in India. I am teachings the renewable energy subject in Mumbai university. I am the author of a book of " A to Z design of rooftop solar Plant". Teaching to my students and spreading knowledge amongst the solar technicians is my passion. I always present 24/7 for my students. I guaranteed Hope this online course will definitely help online learning community And the tree of knowledge will spread all over the world
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)