Public Finance--What do you do in excel?
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
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
Minima doloribus quos delectus iusto consequatur neque. Natus dolor qui vero sequi consequatur ut. Est unde qui voluptas iste. Assumenda qui quidem cum temporibus sit quae. Libero sed omnis voluptas architecto harum. Sapiente ad neque incidunt consequatur enim possimus nesciunt sed.
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...