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
| +404 | Evercore Intern Seizure | 62 | 59m |
| +98 | UBS IB Americas has failed, now behind Santander and Stiffel | 27 | 1h |
| +79 | JPM M&A is Gone??? Purely Coverage Banking??? | 41 | 8m |
| +60 | How do I understand vs. just memorizing? | 11 | 4h |
| +48 | Losing my personality in Banking | 9 | 1d |
| +45 | The good and bad with Wells Fargo | 12 | 3h |
| +42 | Associate & Above IB exits | 18 | 6h |
| +35 | Sent my Claude prompt to 200+ Teams chat. MD wants to see me Monday. | 18 | 8h |
| +33 | Incoming IB Analyst: Best Ways to Prepare? | 13 | 3h |
| +31 | Tech to IB Pivot | 20 | 17h |
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
Soluta qui ut iure repudiandae. Rerum suscipit et ad excepturi. Totam deleniti non id odio necessitatibus.
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...