Financial Modeling of 1MW Solar Captive Power Plant in Excel

Learn Financial Modeling and Sensitivity Analysis of 1 MW Solar Captive Power Plant

4.30 (18 reviews)
Udemy
platform
English
language
Financial Modeling & Ana
category
94
students
1.5 hours
content
Apr 2022
last update
$39.99
regular price

What you will 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

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

Content

Financial Modeling of 1MW Solar Captive Power Plant in Excel Sheet

Formulation of Parameters for Financial Modeling
Loan Repayment Schedule
Profit and Loss Account Statement
Taxable Income and Tax Calculation
Cash Flow Analysis
IRR,NPV, Cumulative Savings and Payback Calculation
Financial Snapshot and Graphical Analysis

Sensitivity Analysis of Financial Model

Sensitivity Analysis of Feed in Tariff

Screenshots

Financial Modeling of 1MW Solar Captive Power Plant in Excel - Screenshot_01Financial Modeling of 1MW Solar Captive Power Plant in Excel - Screenshot_02Financial Modeling of 1MW Solar Captive Power Plant in Excel - Screenshot_03Financial Modeling of 1MW Solar Captive Power Plant in Excel - Screenshot_04

Reviews

Angelo
July 24, 2023
Really great course. Quite difficult to catch all the formulas and understand their purpose. However, I'm not a financial expert. This has been great to learn about financial principles and will assist me greatly in my profession. More courses like this would be great!
Shreeram
November 23, 2022
I am just starting up on financial modeling for solar project and everything is new to me and a good learning.

Charts

Price

Financial Modeling of 1MW Solar Captive Power Plant in Excel - Price chart

Rating

Financial Modeling of 1MW Solar Captive Power Plant in Excel - Ratings chart

Enrollment distribution

Financial Modeling of 1MW Solar Captive Power Plant in Excel - Distribution chart

Related Topics

4511392
udemy ID
1/24/2022
course created date
2/3/2022
course indexed date
Bot
course submited by