My Journey Dealing with Circular Reference in Project Finance Models

This video is about my journey and my personal experience dealing with circular reference in project finance models.
You can also read my blog post on the same topic 👇🏽
www.finexmod.c...
💡 If you want to learn more about my online courses please check here:
hedieh-s-schoo...
💡 Check out my website and if you like what I do, make sure you subscribe to my newsletter:
www.finexmod.c...
Who is the Financial Model Detective?
Hedieh has made financial modelling her profession and passion. She has worked since 2008 as the financial modeler and was the lead modeler for several Mega green field projects in Africa.
She is the author of a book on project finance model audit called:" Financial Model Detective"
www.amazon.com...

[@WebberJason]

Thanks Hedieh. I'm very interested in exploring alternatives to solving for circular references.

[@FinancialModelDetective]

Hi Jason. Thanks. Let’s have a chat.

[@GuillermoDelCam]

Thanks for creating all this content Hedieh… I find it quite impressive.
Greetings from Mexico.

[@FinancialModelDetective]

Many thanks Guillermo

[@kfzar908]

Very interesting. Could you guys not do small 15 minute videos (like the way Kenny structured the free Gridlines course) which goes through a module or two at a time? And lays it out in a practical real life scenario/example

[@FinancialModelDetective]

That’s a great comment. I will share with Professor Bodmer and we will work on it. Thanks again Kendall. You are great.

[@FinancialModelDetective]

Just one thing Kendall, we don’t need to recreate all the modules that Professor Bodmer has already created. We as users we need to be able to make tweaks when needed. For that we need to understand how the code works and it’s a simple step by step method mimicking our Excel model: defining inputs( time based or constant), defining the output in the report and writing formulas in calculations. For this we can make videos with Ed and show you how you can do it yourself

[@kfzar9128]

@@FinancialModelDetective Sounds great, I am sure it will be useful to a lot of people! Just breaking it down into simple, easy to understand and short videos will be beneficial I think! Thanks for the contributions and leading the way for better standards and models!

[@sanazdaniellefotoohi]

This UDF function is hard. The session was so fast though on that day and I am still lost :) So basically UDF allows for running Monte Carlo, data tables and goal seeks with the project finance models, but the copy paste macro breaks down if we pair it with simulation or goal seek. What is the fundamental technical reason for this breakdown in ms excel.

[@FinancialModelDetective]

Thanks for your comment. I know the method is not easy but doable. Your question calls for a second video this time showing the method in action and not just my bla bla bla …

[@hazratAli-pm1ns]

V.nice maam

[@FinancialModelDetective]

Thanks 😊