|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/project-finance-modeling/
课程评论：没有评论
课程名称：Excel中的项目融资完整财务建模 概述：本课程旨在帮助学员掌握高端财务建模技能，特别是针对基础设施领域项目的财务模型开发、修改和分析。在在线学习平台上，您将从一个空白的Excel工作簿开始，逐步构建适合投资分析、债务结构和运营情景评估的财务模型。课程提供逐步指导，帮助您构建适合分析项目融资交易的财务模型。 课程内容：项目融资模型用于评估为基础设施项目提供借款和投资的风险与收益。项目的债务能力、估值和财务可行性依赖于项目自身生成的预期未来现金流，因此建立财务模型至关重要。在本课程中，我们将从零开始建模复杂的绿色田野收费公路项目融资交易。您将学习： - 项目融资的基本概念； - 复杂的实际项目融资交易的财务建模； - 如何根据目标债务服务覆盖比率（DSCR）塑造债务； - 如何创建最佳实践的宏和VBA代码以解决循环引用； - 如何建模债务服务储备账户和维护储备账户； - 如何模拟股东贷款、循环信贷和混合股本内部收益率（IRR）； - 在Excel中构建覆盖项目生命周期的项目融资模型； - 基于折现现金流（DCF）和内部收益率（IRR）方法进行估值分析； - 准备面向投资者和融资者的可靠项目融资模型，重点关注估值和风险； - 根据F.A.S.T标准设计的财务模型。 课程优势：本课程提供的项目融资建模培训与顶级金融机构和基础设施基金的分析师和经理培训相同。课程提供超过9小时的讲师视频内容，适合自学，价格合理，学习时间灵活，可以随时随地进行学习。 课程结构：课程总时长超过9小时。首先，我们将回顾项目融资的基本理论，确保您理解项目融资交易的所有基本组件。然后，通过收费公路项目案例研究，审查建模方法以提升Excel工作效率。接下来，我们将构建综合的财务模型，包括损益表、资产负债表和现金流量表。之后，我们将建模覆盖比率、债务塑造、债务服务储备账户和维护储备账户等内容，并使用DCF和IRR方法进行项目估值。最后，我们还将介绍一些高级财务建模主题，如优先股融资法、债务规模自动化和情景分析。 适合人群：本课程适合需要构建、审查或分析基础设施、石油和天然气或矿业部门项目融资模型的人士。典型学员包括分析师、经理、高级经理、助理董事、财务顾问、融资人员及项目公司、投资银行、私募股权和基础设施基金的首席财务官。 课程前提：学员需具备Excel财务建模方面的基础知识及对NPV和现金流等投资概念的基本了解。
Master the high-end financial modeling skills pivotal to developing, modifying and analyzing financial models for projects in infrastructure sector.In an online environment you will go from a blank Excel workbook to a financial model suitable for investment analysis, debt structuring and operational scenario evaluation. This course will provide step-by-step instructions on how to build financial model suitable for analyzing project finance transactions.What this course is about?Project finance models are used to assess the risk-reward of lending to and investing in an infrastructure project. The project's debt capacity, valuation and financial feasibility depend on expected future cash flows generated by the project itself and a financial model is built to analyze this.In The Project Finance Modeling course we will model complex greenfield toll road project finance transactions from scratch in excel.You will learn about:- what is project finance;- financial modeling of complex, real-life project finance transactions;- how to sculpt debt to a target DSCR;- how to create best practice macro's and VBA codes to break circularities;- how to model Debt Service Reserve Account and Maintenance Reserve Account;- how to model Shareholder Loan, Revolver and Blended Equity IRR;- building project finance models in excel that cover the entire life of the project;- carry out valuation analysis based on the discounted cash flow (DCF) and internal rate of return (IRR) methods;- preparing trusted project finance models tailored to investors and financiers, with a focus on valuation and risk- financial models that are designed according to the F.A.S.T standards.This is the same comprehensive financial training used to prepare analysts and managers at top financial institutions and infrastructure funds.Why you should enroll in the Complete Project Finance Modeling Course? Realistic project finance training - The Project Finance Modeling in Excel course includes over 9 hours of instructor-led video content to learn at your own pace. After completing this course you will be able to build complex, real-life project finance and valuation models.Affordability - a similar course, which provides realistic project finance modeling training will cost you anywhere from US$1000 to US$2500 per course.Learn anytime and anywhere - The Project Finance Modeling course is 100% online so you can learn the modeling when it is convenient for you.How does it work?The course length is over 9 hours. First, we will review basic project finance theory, so you understand all essential components of project finance transaction.Then, in the second part, we will go over the toll road project case study and review modeling methods to improve our productivity in excel. We will then dive into building our project finance model. We will work on the construction costs, funding and financing fees.In the third part, we will build fully integrated, 3 statements financial model which will include income statement, balance sheet and cash flow statement. In the forth part, we will model such items as coverage ratios, debt sculpting, debt service reserve account and maintenance reserve account, revolver, shareholder loan. We will also carry out valuation of the project using discounted cash flow ( DCF ) and internal rate of return ( IRR ) methods. This is a core part of any project finance model. Finally, in the fifth part, we will introduce advanced financial modeling topics such as equity first funding method, debt sizing automation, debt service reserve account automation and scenario analysis.Is this course for you?Yes, if you need to build, review or analyse project finance models within the infrastructure, oil & gas or mining sectors. Typical students include analysts, managers, senior managers, associate directors, financial advisors, financiers and CFOs from project companies, investment banks, private equity and infrastructure funds.This course prerequisites:You will need previous exposure to Excel in a financial modelling context and basic knowledge of investment concepts such as NPV and cash flows.
