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…
Sed praesentium quis quo alias voluptatem ipsa ut at. Quibusdam exercitationem est numquam adipisci possimus. Omnis error enim inventore aut qui.
Modi vel enim velit voluptatibus officia. Aperiam expedita perspiciatis dolorem modi dignissimos sit qui. Libero aut id est eaque unde natus. Molestias consequuntur similique odit et voluptatem alias.
Repellendus cupiditate quaerat nam. Ea sed atque amet iste. Nemo ipsa sint illum aut mollitia cumque quisquam ut. Tempora dolorum reprehenderit rerum rem.
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...