If there are no DCF, comps, or lbo models, what do public finance analysts do in excel? I assume that the focus on financing means financing models. Do these have any specific names? Any other duties of analysts in public finance would be great too.
Thx
| +137 | Piper Sandler in talks to acquire PWP | 61 | 7h |
| +125 | Interns without return offers, careers & perspective | 11 | 15h |
| +114 | UBS Appears to be Exploring Sale | 15 | 59m |
| +110 | Just One More Year | 11 | 2d |
| +82 | Are all these UBS postings bullshit? | 21 | 17h |
| +76 | Bringing Deals as a Vice President | 24 | 36m |
| +66 | Paradise Is Paradise | 5 | 19h |
| +37 | Q&A | Investment Banking Analyst, UBS | 2 years in investment banking | 11 | 1d |
| +35 | Q&A | Incoming Associate, Bulge Bracke, AMA: Career switcher (tech sales/BD → MBA → BB TMT IB), return offer | (6 years in Tech/Accounting) | 6 | 5d |
| +32 | M&A is Paradise | 1 | 2d |
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.
Debt service schedules and debt models, utility fund modeling (pro forma/cash flow and coverage ratios for revenue bonds), bond sizing and refunding analysis (more than likely you will be using DBC for most of this type of analysis), swap analysis, etc. You are right, definitely no DCF, LBO models, but operating models are helpful for utility/infrastructure projects to calculate coverage and projected debt burden.
Great answer--Very helpful. Thanks.
Hi August --
Do you or anyoen happen to know where there are some models of things like that? I've done a bunch of DCF stuff, but for the life of me can't find any public finance Excel examples. Any idea of where to look, online, books, etc? Or perhaps someone has some examples?
Best, Dave
Quia dolorem laborum est animi sed. Temporibus et expedita quis sit et. Vel dolorum placeat exercitationem. Cum quia aut culpa.
Minus non rem ea ut labore officiis rerum. Non reprehenderit consequatur ut consequuntur minima iusto. Sunt ipsum beatae est velit. Unde rem cupiditate consequuntur fuga aut molestiae ea. Cum non omnis distinctio excepturi. Excepturi voluptatem totam et et. Autem nemo id et commodi.
Est qui ut perspiciatis est libero. Beatae rerum error distinctio similique excepturi recusandae. Qui ut omnis assumenda mollitia mollitia et. Dolorem pariatur voluptate dolorem quo officia excepturi a. At cumque rem dolor voluptas.
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...