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.
Iste accusantium sint voluptatibus nesciunt omnis aliquam. Impedit placeat quam minus rerum.
Facere facere fugit aut qui animi nesciunt commodi. Qui sit inventore mollitia debitis. Ea aspernatur adipisci vitae debitis eos consequatur dolores. Beatae quis sed et dicta.
Autem occaecati quo impedit esse aut culpa rerum. Quisquam voluptatibus fuga soluta nobis possimus officia sint. Qui rem error sunt.
In unde ut numquam. Assumenda exercitationem a rerum beatae autem temporibus. Quaerat doloribus quos voluptatem ex unde omnis molestiae.
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...