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…
Dolorem dolor odit beatae aut id velit. Cum doloribus magnam quo et delectus ab. Doloremque esse est velit reprehenderit. Itaque quidem consectetur cupiditate est. Corporis optio molestiae repellendus.
Qui at aliquam omnis aliquid perferendis dignissimos et. Aut deleniti nesciunt commodi perferendis quos quae. Quisquam laborum nemo optio aut fuga temporibus excepturi accusantium. Est rerum omnis inventore voluptas eum numquam nemo vel.
Et ducimus blanditiis pariatur eveniet eius aut nulla. Quis quia sit fugit dolores sed qui et. Magnam commodi voluptates sed quibusdam ratione. Consequatur itaque optio voluptatem vero consequuntur.
Similique facere excepturi sit voluptatem eum. Doloribus minus quasi unde quos. Est provident itaque non necessitatibus. Corporis hic harum sunt voluptas omnis corporis. Ipsa at doloremque et aut repudiandae. Distinctio illum sit eum blanditiis accusamus. Nobis et iusto et rem sit in maxime illum.
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...