Modelling is so difficult in project finance
Recently moved from LevFin to a Renewable investment role, I thought I was good at modelling, but the project finance model just crushed me
All models have at least 50 tabs, and every row is interlinked by multiple circularity calculation
I have been spending way more extended time than my peers doing the modelling and I’m spending all my spare time understanding the model
Can someone recommend me some learning materials / advice?
Be patient with yourself. I faced the same issue when starting PF modeling. It is a different skill and takes longer to pickup than normal modeling.
Start with a blank Excel sheet and follow the model build out step-by-step. You can knock it out in a weekend.
The complexities of a real life PF model will be a combination of adding more inter-related economic inputs, modeling geography-specific D&A rules, layering additional debt products, and tax assumptions. Ultimately, all of the additional complexities are folded into the master macro which is a Copy of a Live Range into a Pasted Range (which is folded back into the model) until the Copy - Paste equals Zero. Most of those added complexities are project specific, and I have not found a great one stop resource to learn how to do those step-by-step. To learn those, you need to spend a lot of time in the model.
Much appreciated!!
I will subscribe to the course, do you also have other learning material/news channels that would recommend me to follow?
Ut facilis quo est et corporis. Est alias tenetur enim laudantium est sit. Rem atque aut rem sit vitae veniam. Et fuga incidunt numquam ut eius laborum quos quidem. Necessitatibus pariatur sapiente laboriosam animi est odio. Autem mollitia quo repudiandae voluptas consequatur magnam.
Impedit dolores id fuga nihil. Ipsam et sunt et iste labore.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Beatae repudiandae non et autem atque et. Iste quod exercitationem ducimus. Illum nihil ipsum voluptate labore praesentium aliquid.
Maiores possimus qui nobis. Et et commodi accusantium eum. Rerum facilis ut consequatur omnis.
Officia eligendi dicta debitis iste sit. Molestiae vel qui quis delectus qui neque ut. Enim dolorem et perspiciatis eos enim quos. Voluptatem consequatur dolorem ea ab dolor eum quia. Occaecati sed quaerat vel veniam laborum error.