The Ultimate Project Finance Modeling Package(Wall Street Prep）介绍
内容介绍
Project Finance Modeling requires complexity not seen in typical corporate finance models. This program breaks down everything you need to build and interpret project finance models for a transaction. Learn project finance financial statement modeling, debt sizing mechanics, running upside & downside cases and more.
你能学到什么
- Project finance theory and implementation
- Best-practice financial modeling
- How to build a project finance model from scratch
- Advanced debt & equity modeling: debt service reserve accounts, refinancing, shareholder loans
- Modeling depreciation, tax, working capital, and financial statements
- How to extend the financial model to different types of infrastructure, incorporate other sophisticated deal terms and multiple phases with different periodicity
课程目录
本课程包括6个Module, 分别如下：
Project Finance Modeling 1: Boot Module and Case Study
Section 1 of our Project Finance Modeling Program. Learn project finance through the lens of an airport. Review the theory of PF, discuss the business case of Heathrow Airport expansion, then dive into the particulars of the project finance model. Go through the case study step by step. Calculate CFADS, tax, debt ratios like DSCR & LLCR, and equity and project returns. Get hands on in the model. Run different cases to optimize the project and meet stakeholders criteria.
Project Finance Modeling 2: Excel DNA for Modelers
Section 2 of our Project Finance Modeling Package. Learn the DNA of Excel and become a bulletproof financial modeler. Here, we break down the skillset of financial modeling and piece it together step by step with financial modeling best practices layered throughout. You’ll learn how formula works and when they break down and the top 50 shortcuts to make you a speed demon. By the end of this course, you’ll get up to 3x quicker at developing robust, transparent financial models
Project Finance Modeling 3: Blueprint of the Model
Section 3 of our Project Finance Modeling Program. With a wind-farm case study, this course guides you in building – from scratch – your very own infrastructure model. Model a greenfield asset, calculate revenue, fixed & variable expenses. Review the relevant parts of a term sheet and model paying down debt with annuity & sculpted repayment mechanisms, and analyze lender covenants. Bring the model together into a Cashflow Waterfall. Using equity & project returns, DSCR and other outputs, trace the drivers of performance with a scenario manager, and run a debt and equity type process as a window to how stakeholders might view the deal.
Project Finance Modeling 4: Advanced Debt & Equity
Section 4 of our Project Finance Modeling Program. This section will challenge you to get the most out of a project finance deal. Using advanced material, it expands on our work in Blueprint and asks questions such as: How does DSCR target or gearing driven debt sizing work? How do I re-profile debt to optimize equity returns? How does a model integrate advanced funding features like a DSRA? Go further by adding in sophisticated funding structures, like the option to refinance debt and shareholder loans. Automate debt sizing and the scenario manager to solve the debt case, or run a debt process by evaluating multiple lender terms.
Project Finance Modeling 5: Depreciation, Tax & Financial Statements
Section 5 of out Project Finance Modeling Program. This section advances the accounting rigor around a project finance model. Like the other sections, each module begins with the “Why”, giving you the theoretical background, before diving into the “How” – the implementation in the model. Continuing from the Blueprint model, pull together the elements to deliver a bankable financial model. Calculate working capital using multiple methodologies, discuss and calculate corporate tax, calculate depreciation using straight line, reducing balance or MACRS methodology, bring together a P&L and Balance sheet. Improve the model robustness by adding checks.
Project Finance Modeling 6: Bringing It All Together & Model Extensions
Section 6 of our Project Finance Modeling Program. This section brings together everything we’ve learned so far and delivers a complete project finance model. We start to look into ways of extending the model with material such as how to change the construction timeframe from quarterly to monthly periodicity in a best practice manner, while keeping operations quarterly.
购买
请到官网购买
Please purchase from official website
课程链接
www.wallstreetprep.com/self-study-programs/the-ultimate-project-finance-modeling-package/
希望看到这里的童鞋们：事事如意，(面试)试试如意！
有任何疑问可添加微信号(扫码添加):
美东时间作息时间回复
福贝壳儿 » The Ultimate Project Finance Modeling Package(Wall Street Prep）介绍
福贝壳儿 » The Ultimate Project Finance Modeling Package(Wall Street Prep）介绍
