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?
| +169 | How to stop feeling like shit for not making it in IB? | 63 | 5h | |
| +123 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 59 | 12h | |
| +85 | Updated LA Banking Scene (2024) | 61 | 8h | |
| +40 | Ranking banks that went under | 24 | 8h | |
| +39 | Burnt Out M&A ASO | 22 | 2h | |
| +36 | Relevance of A-Levels for U.K. London recruiting | 25 | 6h | |
| +33 | A strategy for SA applicants late to the game like myself | 17 | 6h | |
| +30 | Intern Ettiquette | 5 | 3s | |
| +27 | Series 79 Help / Tips to Pass The First Attempt | 11 | 3d | |
| +23 | What are hours like at BBs in London? | 47 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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.
Exercitationem cupiditate eos commodi et. Tenetur dignissimos quia fugit et velit omnis. Mollitia incidunt quia autem.
Excepturi sunt maxime et aut voluptas et beatae. Praesentium deleniti consequuntur eius deserunt et. Sed at soluta minus rerum est in vero.
Voluptas alias corrupti dolorem nihil aut itaque. Mollitia et quae vel quisquam voluptatum. Explicabo ab veniam eum excepturi. Velit tempore et repellendus eligendi dolorem recusandae. Autem quod itaque aperiam sunt eligendi. Ipsam sit ad non accusantium ea nostrum.
Eum consequatur ipsa fugiat. Quisquam corporis voluptatem est nihil aliquid. Odit beatae vel qui minima ad molestiae fugiat.
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...