Advanced Renewable Energy Financial Modeling (Udemy.com)

High recommended for someone who wants to learn about Project Finance modelling. This course offers a comprehensive syllabus with a very hands-on approach. Though it maybe technical for beginner but I strongly suggest to take the Excel DNA for Project Finance Modeling first before starting to enroll into this course.

内容： プロジェクトファイナンスにおけるモデリングを十分に網羅している。当然ながらすべての要素を網羅しているわけではなく、Project Finance Moldelingをする担当者に求められる要素を網羅しているという意味である。EBL、Equityの拠出タイミング（Equity First、Pro-rata、Equity Lastなど）、国際金融機関を活用する際のTranche分け、メザニンファイナンスやそのサイジングなど個別要素の大きなものは含まれていない。 課題： PCのスペックによってはTarget IRRを算出するマクロがうまく動作しない場合もある、と思われる。 また画質が粗いため小さな画面（ipadなど）だと数式やVBAのコードを見るのが大変であり、画質の改善は早急に対応したほうが良いと思われる。若しくはコードをより大きな文字で別表示にして表示するなどの対策でもよい。 Content: This video offers a thorough introduction to financial modeling in project finance. While it does not claim to cover every detail, it does encompass the essential aspects required of individuals responsible for project finance modeling. It does not include major individual elements such as EBL, equity contribution timing (Equity First, Pro-rata, Equity Last, etc.), tranche allocation when utilizing international financial institutions, or mezzanine finance and its sizing. Issues: Depending on the PC specifications, the macro for calculating Target IRR may not function properly. Additionally, the low image quality makes it difficult to read formulas and VBA code on small screens, such as iPads. Addressing the issue of improving image quality promptly is essential. As an alternative solution, displaying the code separately in a larger font could be a viable option.

Training module is quite comprehensive. Minor improvement I would like to suggest is that trainer can spend bit more time on elaborating the necessity and impact of doing certain things such as applying limitation of available cashflows before distributions, implication of covenant breach, releasing funds due to cashflow shortfall, etc. This would have helped to grasp concepts as well in addition to the mechanics of modeling.

The course provides and in-depth coverage on how to make a financial model from scratch. I found the keyboard shortcuts to be the most useful aspect of the course. I like how Lukas includes the keyboard icons on the screen which helps the audience know which buttons to press on the keyboard. A point of recommendation is when using the shortcut to sum numbers, mention that some users have to press "alt + =" as opposed to "shift + alt + ="

Overall the course is great and I love how much detail and complexity we go into here. That said, it would be worth stopping at some point to explain why we do something instead of just how to do it. Why do we focus on debt sculpting in section A and not B? Maybe the course is more suited towards those that already have experience with project finance. For those with more general finance background it may be difficult to follow.

It is a truly advanced course, aimed at those who have this level of knowledge. From this perspective, it is a very good course, highly recommended. However, do not expect explanations about concepts and often even the reason for modeling the way it is done.

This course is excellent: 10 out of 10. I liked the way the brain of the model was built within the cash flow statement, using the "corkscrew" calculations in a simple way per account. Rather than having everything scattered around the P&L and balance sheet. In this way, a balanced balance sheet is achieved in a simple and elegant approach. It also provides excellent storytelling for a renewable energy project perspective. The storytelling of the cash flow waterfall chart and the explanations of the peaks are superb.

I am still amazed by the content and the material covered in this course. Your dashboard is out of this world. I wonder which school Lucas went to. Of course, the CFA Institute does not teach this kind of stuff. You could be one of the three people in this world who can model Renewable Energy assets with that level of granularity.

Modeling- and content-wise, it's a really good example. what I would expect more from the instructor is to give an overview of the model structure right at the beginning, and help readers/listeners understand how different bits link to each other, before diving into any details. I have to download the completed model to familiarise myself with the model structure and pause at different stages to better understand what is the part that we are building.

I spent two years in a specialist big 4 financial modelling team and I still must say this is some of the best modelling training I have seen in the market and the end result is a highly dynamic, best in class project finance model. I took this course to brush up on my skills- and it didnt disappoint. This training is perfect for any project finance professional starting off in the industry or even more seasoned professionals. Lukas was highly responsive to all of the questions and perfect help throughout.