Financial Modeling of Solar Plant in Premium Excel Sheets
- 4
-
![]()
![]()
![]()
![]()
Brief Introduction
Get A to Z Knowledge of Financial Modeling of Solar Power Plant in Excel Sheets for 10kW and 50kW of Solar CapacityDescription
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
Requirements
- Requirements
- Pen, Notebook, Calculator and Laptop
- Microsoft Excel 2007 Onwards
- Curiosity about knowledge in solar field
- Enthusiasm to learn
Knowledge
- 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
Kiran Ramkrishna Beldar
4 Raiting
Financial Modeling of Solar Plant in Premium Excel Sheets
- 4
-
![]()
![]()
![]()
![]()
![]()
Get A to Z Knowledge of Financial Modeling of Solar Power Plant in Excel Sheets for 10kW and 50kW of Solar Capacity...
