EDIT_DELETE
EDIT
Keywords
EDIT_DELETE
EDIT
Trending Content
| +111 | At what point should you give up? | 61 | 1h | |
| +37 | I am lost on the next step - Need Advice | 8 | 4d | |
| +37 | Recruiting while unemployed | 16 | 2d | |
| +25 | SF vs NY IB Stint | 10 | 3d | |
| +22 | Incoming freshmen at bocconi - SA 2025 recruiting | 15 | 1d | |
| +19 | NYC Consumer PE/Growth Funds with decent comp but amazing WLB? | 6 | 1d | |
| +19 | Trying to break into IB | 7 | 17h | |
| +18 | Job Switch Advice | 4 | 2s | |
| +16 | SHIFTING FROM LAW TO FINANCE | 11 | 5h | |
| +15 | Lost And Need Advice | 4 | 5d |
Career Resources
1) As a syndicate analyst you will be tracking investor orders in deals. Pivots are therefore important since you will be keeping a running database of deals -- you'll be able to see what deals each investor participated in, how much they ordered and how much they actually received. If your database is robust enough -- and it should be -- you'll be able to see who the top investors are for specific companies, industries, bond tenors (i.e. the buyer base of 3yr FRNs is different than for 10yr fixed), etc... and you can use this information to efficiently market new issues.
2) Functions shouldn't be much complicated than lookups, sumif, sumproduct and match functions. Pretty simple stuff overall.
3) Traditional modelling will be non-existent. You won't be digging into company financials but you'll want to be able to have spreadsheets that have comparable bonds issues with their different spreads, prices and yields, and you'll also want spreadsheets that make it easy to price new deals. That said, I'm 10000% sure the syndicate desk will already have these. From there, once you become comfortable with them, you'll want to figure out ways to improve them.
Honestly, an analyst in syndicate is a glorified travel agent and admin. But the hours are great.
Second that. In the Canadian space it probably won't even be that that difficult (in regards to bullet 1) as it's not a huge space with a ton of players so you can typically just pull a buyers list from a couple of precedent deals.
Thank you @mrb87 and @juniormistmaker
Creating pivot tables and searching pivot tables using filter etc is not particularly difficult. Infact, it sounds too easy to be true. Any specific functionality of pivot tables I should know other than this?
Basic of use of those functions are simple enough!
Modelling: Traditional modelling obviously is irrelevant to the syndicate desk. The job requirement stated that modelling skills will be an asset. I can value bonds in excel using present value by a simple creation of discounting formulas but what about using comparables? Is there a specific name for bond modelling using comparables? I am unable to find any info on this online!
Thanks for the help!
It's not "bond modelling"; you're just using comps to help zero in in the appropriate spread/yield for a new issue.
Adipisci dolor perferendis vel aperiam eligendi tempora. Ut ab qui accusantium soluta ea perspiciatis. Iste neque et minima unde corrupti. Assumenda consequuntur in et qui sed labore minus. Odit incidunt laboriosam expedita et facilis est ea. Reprehenderit dignissimos esse aliquid praesentium ut voluptas. Quia nihil et molestiae cumque voluptatem sequi eos non.
Ipsam saepe ipsa natus dolor earum voluptas. Tenetur et veniam velit minus animi officia. Quia sit debitis debitis cum voluptas. Qui consequatur voluptate velit aperiam vero sit laboriosam qui. Nemo nulla iste voluptas reiciendis. Sit et numquam ab. Dolore esse asperiores enim mollitia sint pariatur eos velit.
Molestiae sit veniam omnis amet. Aliquam eos non velit saepe et laboriosam error.
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...