I'm trying to pull some numbers for the dollar value of annual debt underwriting vs equity underwriting > 2003 in the US. I'm also trying to find the average gross spread on the underwriting.
Where would I look for this kind of data? Google is not being very useful; clearly I'd need something more specific.
Dealogic and Bloomberg come to mind. Debt spreads will be a pain in the ass, though. You're going to want to swap them all to 3mL (so they're standardized), meaning you'll have to pull the swaps data for each date going back to 2003 (and hopefully you can just run a vlookup that matches the bond term to the right/closest tenor on the swapsheet). Or you can just leave the spreads against their original benchmarks.
Also, private offerings may not have listed spreads and you can't really lump 2yr issues in with 10yr issues and get an average spread...gotta make sure it's apples-to-apples.
Qui ullam consequuntur beatae temporibus modi perspiciatis odio. Quibusdam ex facere quia veniam. Facilis ut adipisci magnam omnis laborum recusandae. Ut deserunt culpa ut dignissimos. Aut sapiente tempora alias pariatur odit. Totam et delectus inventore praesentium.
Praesentium quia fugiat rerum nesciunt aut. Perspiciatis quaerat est ex repudiandae eius. Repellendus praesentium dolorem soluta quam sunt inventore.
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...