Udemy – Financial Modeling of 1MW Solar Captive Power Plant in Excel 2022-1

Financial Modeling of 1MW Solar Captive Power Plant in Excel, Welcome to your course “Financial Modeling of 1MW Solar Captive Power Plant in Excel”! This course is designed for solar industry business professionals and investors who are interested in solar projects. It is also beneficial for solar accountants who want to understand the balance sheet structure of solar projects and solar technicians aiming to learn financial modeling for solar power plants. Throughout this course, all relevant parameters are consolidated into an Excel sheet to create the Final Master Excel Sheet. The first step involves the formulation of initial parameters, followed by the preparation of the Profit and Loss Account Statement. The course also covers the calculation of taxable income and tax, ensuring a solid understanding of tax obligations related to solar investments. The financial modeling process includes cash flow analysis, which is essential for evaluating the project’s liquidity. Participants will also learn how to compute the internal rate of return (IRR) to assess profitability, along with the calculation of cumulative savings over a 25-year lifespan and net present value (NPV) to determine the financial viability of the project.

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

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

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

• Publisher : Udemy
• Teacher : Kiran Ramkrishna Beldar
• Language : English
• Level : Intermediate
• Number of Course :
• Duration : 1 hours and 23 minutes

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

Requirements

• Pen, Notebook, Calculator and Laptop
• Microsoft Excel 2007 Onwards
• Curiosity about knowledge in solar field
• Enthusiasm to learn

Pictures

Sample Clip

Installation Guide

Extract the files and watch with your favorite player

Subtitle : Not Available

Quality: 720p

Download Links

Download – 712 MB

File size

712 MB