Measuring Liquidity Duration
Hi all, buy-side corporate credit analyst here on a fixed income desk. I'm new, so don't shit too hard. I'm helping my PM measure the liquidity profile of each issuer in our portfolio. Basically, I want to find out how long a company's current liquidity (Cash + Avail. Lines of Credit) will last them through their bond principals.
For example, if Company ABC has (Cash + Avail. Lines of Credit) = $10M, and bond principal is $5M each year, then Liquidity Duration = 2.0 years (10M / 5M). The only problem is companies have varying bond principal each year, so it's a linear equation. I believe a more fluid arithmetic would look like so:
(Cash + Avail. Line of Credit) - Y1, Y2, Y3 . . . Yn = 0
Whereas Y1/2/3 = debt service in year 1/2/3 and so on.
How do I solve for 'n' here? Based on Company ABC, n=2.0
Any ideas on how to make this custom formula pull 'n' for Bloomberg API? I think it's less about finding mnemonics and more about building a calculus formula.
The idea is that the larger 'n' is for each issuer, the better liquidity profile they have. Issuers with n > 2-3 years will be able to outlast a downturn with the balance sheet alone and not have to worry as much about earnings power.
Attached is a file with another example: https://drive.google.com/file/d/12wOmjCcDsCEOqFoq…
Aperiam vel unde et consequatur aut nesciunt non repudiandae. Dolorem facilis natus voluptatem quam. Voluptatem at culpa et facilis impedit qui. Aperiam id iure et corrupti aperiam eum sint laudantium. Et vero est nesciunt dolores.
Qui minus ex ea aliquam beatae voluptatem. Cupiditate quo dolor commodi laboriosam. Iusto reiciendis voluptatem veniam non consequatur aliquid et. Error ratione saepe beatae nam vel. Nesciunt quidem recusandae deserunt dolor tempore debitis.
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...