Model Test (debt raise/debt size)
Hi Everyone, currently interviewing with an EB on their debt advisory/RX team and have been given the below description of the model test. I have some questions on it if anyone could help.
- Modelling case study centred around a debt raise for a plant
- Required to build financial model from scratch, including financial statements, used to calculate debt size capacity
Does anyone have any clue what the above would mean in the model test? Is it modelling standard 3 financial statements, DCF, or more of a debt sizing model (i.e. DSCR, CFADS etc)? Appreciate the help, thanks!
In the context of a debt advisory or restructuring (RX) team model test, the description you've provided suggests that the focus will be on building a financial model to assess a company's capacity to raise new debt. This typically involves several key components:
Three Financial Statements: You'll likely need to model the three core financial statements (Income Statement, Balance Sheet, and Cash Flow Statement) from scratch. This is foundational, as these statements provide the necessary information to assess the company's financial health and its ability to service new debt.
Debt Sizing Analysis: The primary goal of the model will be to determine the maximum amount of debt the company can raise, which involves calculating debt capacity. This is often based on certain financial metrics and covenants agreed upon with lenders.
Key Metrics for Debt Sizing:
Scenario Analysis: Depending on the complexity of the test, you might also be asked to perform scenario analysis to understand how different operating conditions affect the company's ability to raise and service new debt.
DCF (Discounted Cash Flow): While not directly related to debt sizing, understanding the company's valuation through DCF analysis can provide additional insights into its financial health and growth prospects, which indirectly impacts its debt-raising capacity.
Given the context, it's crucial to focus on accurately modeling the financial statements and understanding how to calculate and interpret key metrics like DSCR and CFADS. These elements will be central to determining the debt size capacity for the plant in question. Remember, the goal is to build a model that not only calculates the maximum debt the plant can sustain but also provides a clear picture of its financial health and the feasibility of the proposed debt raise.
Sources: Help with 3-Statement Model Test, Cheat sheet to understand ‘Stress Test’ Results, Modelling Test - Please tear it apart :), Can anyone review my modeling test answers? - Super Modelers Wanted, Credit Suisse Pymetrics Test
How did it go? Willing to provide any info on the experience?
In iure rerum hic. Ab omnis velit consectetur molestiae qui. Omnis minima quis et dolor voluptas. Possimus debitis accusantium voluptatem.
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...
Qui optio doloribus eos consequatur quia molestias. Reprehenderit inventore aliquid eveniet. Ad impedit nesciunt molestiae recusandae. Velit mollitia corporis et exercitationem sit dicta dolore tempore.
Placeat veritatis voluptatibus repudiandae quia. Nesciunt magnam itaque doloremque aspernatur eum voluptatum sed. Omnis eveniet nulla rerum tempore voluptas voluptatem. Repudiandae dolor repellat quia in quia veniam. Consectetur accusamus sunt omnis molestias et est optio asperiores. Dolor quia molestiae repellendus autem qui. Sequi accusamus molestiae quis corporis consequatur mollitia doloremque officiis.
Et quia ullam maiores non optio aut id eius. Iusto debitis incidunt quas excepturi sed sint quasi. Ut aliquam quis et dolores.
Harum mollitia autem impedit excepturi consequatur provident. Et odit eum quod. Et eaque quia soluta inventore occaecati eaque illo.
Distinctio dignissimos enim facilis aut esse ut. Voluptas dolores consequuntur eius fuga repellat quia debitis. Dolore optio temporibus et possimus autem accusantium qui.
Est cupiditate aliquid aut ut perferendis. Facere aperiam perferendis fugiat et et. Quisquam labore nihil nisi ipsa libero cupiditate. Praesentium sit omnis id error sed aut.