Financial Modeling of 1MW Solar Captive Power Plant in Excel

Learn Financial Modeling and Sensitivity Analysis of 1 MW Solar Captive Power Plant

Created by: Kiran Ramkrishna Beldar
Professor at Mumbai University, India

What Will I 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

Requirements

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

Target audience

• Solar Business Person
• Solar Investors
• Solar Entreprenuers
• Solar Installers
• Solar Industry Person
• MBA Students
• Mechanical Students
• Electrical Students
• Solar PV Designer
• Solar Sales Person