Finance
Hands on Training icon
Hands On Training
Hands on Training icon

Financial Modeling of 10kW Solar Power Plant in Excel Sheet

Course Cover

5

(1)

compare button icon

Course Features

icon

Duration

2 hours

icon

Delivery Method

Online

icon

Available on

Lifetime Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Beginner

icon

Teaching Type

Self Paced

icon

Video Content

2 hours

Course Description

Welcome to your course "financial modeling of 10kW solar power plant in 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 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

Course Overview

projects-img

Post Course Interactions

projects-img

Instructor-Moderated Discussions

projects-img

Case Studies, Captstone Projects

Skills You Will Gain

Prerequisites/Requirements

Basic Knowledge of Microsoft Excel

Pen, Notebook, Calculator and Laptop

Financial Modeling of 10kW of Solar Power Plant considering 100% equity and 0% Loan 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

What You Will Learn

Solar Financial Modeling

Taxable Income and Tax Calculation

Course Instructors

Kiran Beldar

Instructor

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 have conducted  Various Seminars and Webinars across Indi...
Course Cover