Course Features
Duration
2 hours
Delivery Method
Online
Available on
Lifetime Access
Accessibility
Desktop, Laptop
Language
English
Subtitles
English
Level
Beginner
Teaching Type
Self Paced
Video Content
2 hours
Course Description
Course Overview
Post Course Interactions
Instructor-Moderated Discussions
Case Studies, Captstone Projects
Skills You Will Gain
Prerequisites/Requirements
Basic Knowledge Microsoft Excel
Pen, Notebook, Calculator and Laptop
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
What You Will Learn
To Learn Financial Modeling for Solar Power Plant
Develop Loan Model
Calculation of Tax Benefits
Course Instructors