|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/financial-modeling-of-1mw-solar-captive-power-plant-in-excel/
课程评论：没有评论
**课程名称：** Excel中的1MW太阳能自发自用电站财务建模 **课程概述：** 本课程专为太阳能行业从业人员、希望投资太阳能项目的投资者、希望学习太阳能项目资产负债表的太阳能会计师，以及希望学习太阳能发电厂财务建模的太阳能技术人员设计。 **课程内容详述：** A) **Excel中的1MW太阳能自发自用电站财务建模** * **初始参数的制定：** 设定财务建模所需各项基本参数。 * **损益表：** 计算总收入和总支出。 * **应税收入与税款计算：** 确定应税收入及税款计算参数。 * **现金流量分析：** 分析系统内的现金流入与流出。 * **内部收益率（IRR）计算：** 评估项目的盈利能力。 * **25年寿命期累计节约额计算：** 衡量项目生命周期内的累积节约效益。 * **净现值（NPV）计算：** 评估项目在未来现金流折现后的价值。 * **精确回收期计算：** 确定项目投资回收的准确时间点。 * **最终主Excel工作表：** 将所有参数整合，形成一套完整的财务模型。 B) **太阳能发电厂敏感性分析** * **上网电价对内部收益率（IRR）计算的敏感性分析：** 分析上网电价变化对项目IRR的影响。 * **上网电价对25年寿命期累计节约额计算的敏感性分析：** 分析上网电价变化对项目25年累计节约额的影响。 * **上网电价对净现值（NPV）计算的敏感性分析：** 分析上网电价变化对项目NPV的影响。 * **上网电价对精确回收期计算的敏感性分析：** 分析上网电价变化对项目投资回收期的影响。 * **详细解释Excel工作表中的所有参数。**
Welcome to your course "Financial Modeling of 1MW Solar Captive Power Plant in Excel" 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 1MW of Solar Power Plant under captive domain 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 PointsB] Sensitivity Analysis of Solar Power Plant - Sensitivity Analysis of Feed In Tariff on Calculation of Internal Rate of Return - Sensitivity Analysis of Feed In Tariff on Calculation of Cumulative Saving Over 25 Years Lifespan - Sensitivity Analysis of Feed In Tariff on Calculation of Net Present Value - Sensitivity Analysis of Feed In Tariff on Calculation of Exact Payback Points In the excel Sheet where all parameters are explain very well. - Formulation of Initial Parameters: Parameters are required for financial modeling - Profit and Loss Account Statement: Total Revenue and Expenses - Taxable income and Tax Calculation: Parameters for taxable income and tax calculations - Cash Flow Analysis: Cash in and Out the system - Calculation of Internal Rate of Return: %IRR - Calculation of Cumulative Saving Over 25 Years Lifespan: Equity Turnaround the Project - Calculation of Net Present Value: NPV value - Calculation of Exact Payback Points: Payback Period
