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
| +431 | Is UBS really that bad? | 77 | 1h |
| +263 | Investment Banking is Divine | 40 | 2d |
| +219 | Another $115bn Mega deal for these banks. Congrats! | 46 | 7h |
| +216 | US 2027 SA IB worried about background check | 53 | 2d |
| +58 | Useless associates | 13 | 49m |
| +50 | Differences in Restructuring Teams? | 24 | 4h |
| +40 | Is Houston SA 28 recruiting already over? | 34 | 1d |
| +37 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 8 | 12m |
| +36 | How do you manage nerves in IB technical interviews? | 8 | 10h |
| +34 | FIG Pigeonholes you - is it true? | 13 | 3h |
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.
Dolore eos eveniet voluptas distinctio. Est eligendi eaque est temporibus laboriosam veniam voluptatibus cumque. Cupiditate omnis et omnis nemo.
Perferendis consequatur inventore nihil quo iusto rem. Esse sapiente ea est aut. Eos sed mollitia exercitationem a quae.
Est unde veritatis voluptatem velit et. Aliquam suscipit et inventore id reiciendis. Eum assumenda facilis minima sapiente. Vel dignissimos deserunt dolor cupiditate eaque officiis aut. Et voluptas aut quia tempora at beatae. Voluptates nemo vitae odit aliquam eum molestiae delectus quia.
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...