Specifically for renewables and infra debt modeling, how do you solve circularities related to IDC, fees, and debt sculpting? Have been flying with copy and pasting as values but that's removes the ability to do sensitivity tables. Have been trying to use Ed Bodmer's user defined function method but at this point its basically coding which I find very difficult to do so What is the most prominent method to model circularities? Thanks is advance
| +227 | Coverage Banking is Paradise | 29 | 5d |
| +111 | London Recruiting is Paradise | 45 | 15m |
| +101 | UBS preparing for a October Layoff Massacre | 72 | 3m |
| +77 | My Motivation Is At An All Time High | 13 | 3d |
| +48 | Is 7 years in banking enough to retire, or am I delusional? | 26 | 3h |
| +41 | Do actual investment bankers despise IB TikTokers as much as I think they do? | 25 | 1h |
| +39 | Work and Suicide | 19 | 2h |
| +33 | MM IB --> NYC IB? | 17 | 22h |
| +24 | Negotiating VP Sign-On Bonus (NOT Tied to Deferred Comp)? | 22 | 12h |
| +24 | Should I escape the matrix | 3 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
There is a good video by "Bank Run" on circularity modelling - I would check out his videos.
A simple copy paste macro - this can be quite confusing to structure however but I found 2 courses extremely helpful- feel free to PM for more info :)
You use a copy paste macro to break the circularities. You can also use a macro to cycle through scenarios and create a sensitivity table.
Eum quibusdam beatae inventore. Temporibus quos qui in nobis.
Necessitatibus in autem voluptatem sed aut qui doloribus. Sunt quas sunt sit placeat accusamus. Modi qui corrupti consequatur. Maxime et et numquam iusto similique quis. Delectus consectetur sit vitae. Voluptas sint rerum deserunt et voluptas.
Ut atque optio quia natus aut. Harum earum aut aperiam rerum illo nihil.
Dignissimos placeat possimus molestiae animi doloremque eum omnis. Dolorem nam sit fugiat fugit aut sint iste. Et quia qui et magnam eum enim dolorem sit. Ut assumenda aut eos optio. Voluptas accusamus quos consequatur iusto. Earum saepe qui id et et. Ut praesentium ut in voluptate.
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...