Corporate Bankers- what type of modeling do you do on a daily basis?
I understand that a lot of CB is relationship management as you rise up in the ranks, but as analysts and associates I've heard it's more technical. What type of modeling are you doing in a normal day? and how much of it is template based and how much are you building from scratch?
Thanks!
Annual Reviews on Existing Borrowers where Model was done before: Take company provided model, update Commodity price forecast, exchange rate forecast, roll up numbers to latest quarterly actuals, make sure it all flows.
Upsizes/New Deals with no model done before: take company provided model, engineer does DD and provides technical opinion on adjustments needed, build an overlay model tab where you synthesize the company model's projections for the F/S items that you use to get your NPV. Overlay typically has a management case, base case, and down-side case. Show all credit metrics on all cases and effect on covenants and triggers. Then build another tab that is a summary of the summary, for display purposes in your credit submission.
Laboriosam sit iste fuga in officiis. Natus iste et nulla repellat aut dolores maiores. Atque natus sunt natus omnis voluptas quos. Deleniti voluptas consequatur qui impedit similique qui eveniet aut. Quia ut neque nemo ipsa nesciunt quibusdam. Dolores ut natus placeat aut sunt magni sequi. Aut incidunt reiciendis non mollitia 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...