Financial Modeling of Solar Plant in Premium Excel Sheets

Get A to Z Knowledge of Financial Modeling of Solar Power Plant in Excel Sheets for 10kW and 50kW of Solar Capacity

4.05 (23 reviews)
Udemy
platform
English
language
Financial Modeling & Ana
category
Financial Modeling of Solar Plant in Premium Excel Sheets
156
students
3.5 hours
content
Mar 2021
last update
$49.99
regular price

What you will learn

Financial Modeling of 10kW of Solar Power Plant considering 100% equity and 0% Loan Investment

Financial Modeling of 50kW of Solar Power Plant Cosidering 75% Loan and 25% Equity Investment.

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 Debt Service Coverage Ratio

Calculation of MAT Credit

Calculation of Accelerated Depreciation

Percentage Saving In Project

Calculation of Project Cost Per Wp

Calculation of Tax Benefits

Why take this course?

Welcome to your course "Financial Modeling of Solar Power Plant in Premium Excel Sheets" 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 10kW of Solar Power Plant considering 100% equity and 0% Loan Investment

B) Financial Modeling of 50kW of Solar Power Plant Cosidering 75% Loan and 25% Equity Investment.

      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

     - Calculation of Debt Service Coverage Ratio

Screenshots

Financial Modeling of Solar Plant in Premium Excel Sheets - Screenshot_01Financial Modeling of Solar Plant in Premium Excel Sheets - Screenshot_02Financial Modeling of Solar Plant in Premium Excel Sheets - Screenshot_03Financial Modeling of Solar Plant in Premium Excel Sheets - Screenshot_04

Charts

Price

Financial Modeling of Solar Plant in Premium Excel Sheets - Price chart

Rating

Financial Modeling of Solar Plant in Premium Excel Sheets - Ratings chart

Enrollment distribution

Financial Modeling of Solar Plant in Premium Excel Sheets - Distribution chart
3345720
udemy ID
7/19/2020
course created date
8/2/2020
course indexed date
Bot
course submited by