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
| +120 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 23 | 6h |
| +97 | Americas M&A League Table Q2 Updated | 44 | 1h |
| +72 | Wealthy Parents / Jaded | 24 | 8h |
| +56 | How are hours rn for SA (interns) | 31 | 4h |
| +47 | Venezuela Debt Restructuring - LAZ vs CVP | 22 | 19h |
| +44 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 11 | 2h |
| +37 | Boutique firm wants access to my LinkedIn? | 34 | 1h |
| +31 | Investment Banking in Mexico | 9 | 5h |
| +26 | MM bottom bucket bonus | 9 | 3d |
| +25 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 14 | 8h |
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.
Ad sit sit molestiae praesentium et fugiat dolore. Ut aut omnis est. Quia voluptatem soluta laboriosam labore et possimus.
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...