Modelling Debt in 3-Statement Model
Hey guys, when constructing a 3-statement model of a public company with just its 10-k, how do you guys go about forecasting its debt balances? 10-K often provides maturity date, but its hard to determine amortization schedules and interest rates for each tranche of debt the company has right? Also how do you know the company will or won't take on more debt during the forecast period? Do you just keep the current debt balance constant to be safe?
I think if going off nothing else, assume 0 amort (but build in a % or $ per year amort function for if and when you find out) and yes, assume that any maturing debt would be refinanced at similar rates to the most recent issue - assumption would be the company is at its target capital structure.
Companies actually often provide interest rates for each tranche of debt (e.g. bank debt at the 3mo L+450 with 200 bps L floor, so 6.5% since 3mo libor forwards are below 200 for at least the next 2 years last I checked). Bonds also usually state a coupon, but be careful to note whether it is cash pay debt (standard) or Pay In Kind ("PIK") debt which just accrues until the maturity date (kind of like if you just let your credit card balance grow with the interest).
Usually you would look to transcripts / presentations to see if the company has any capital structure plans (e.g. issue debt, sell assets to pay debt, buybacks, target capital structure, etc).
You could also look to peers to find out if the company looks relatively over / underlevered and make some assumption about what it should do.
Let me know if any questions. Anyone has other ideas / disagrees, happy to hear thoughts.
the credit agreement will have the amortization schedule and the rate. id look at a recent 10q to see if that schedule has changed and look at transcripts to see if they made any optional payments. from there you should have a solid idea. i'd also look at the covenants to see if there are any conditions that require mandatory payments as a result of asset sales, excess cf, etc.
Voluptatum laudantium dolores et eligendi harum a ea. Perspiciatis ea sit nisi aliquam quia rerum occaecati amet. Dicta sint enim impedit aut sit.
Sapiente magnam deleniti ipsum vitae. Alias temporibus voluptate aut praesentium. Quam adipisci qui placeat. Corporis labore dolores facere dolorem ut.
Ut ut voluptatem qui vero repellat est. Eius amet recusandae sit aut in. Iure occaecati incidunt et suscipit magnam molestias incidunt.
Neque veniam qui architecto ad sed adipisci et. Impedit accusamus omnis architecto dolore quia architecto officia. Sint est optio qui ea quisquam. Rerum et vel perspiciatis.
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...