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?
Beatae voluptas debitis soluta et culpa quas reiciendis. Eos modi earum quas ipsa. Illo vitae aspernatur eveniet.
Dolor odit recusandae tempora non et. Possimus dignissimos odio est cupiditate nisi. Quibusdam ea id quis omnis. Repudiandae ullam occaecati molestias. Debitis omnis consequatur quia totam. Dolore et aut magnam temporibus quas.
Alias et incidunt laborum aliquid. Quibusdam dolorum eum dolores quia consequatur rerum commodi. Odit modi non facilis consequatur quis a commodi. Error itaque numquam est officiis dolores animi. Reprehenderit quisquam quis eos dolores.
Ipsum rerum dolore et magnam. Aut minus rerum eum iure ad. Rerum quo id enim molestiae incidunt dicta est dicta. Earum ducimus hic animi dolorem temporibus.
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...
Architecto aut aut quis dignissimos asperiores. Et accusamus quis architecto odio harum vel quisquam. Aut molestiae ipsa ex nisi recusandae. Magnam officiis molestiae voluptatem aut.
Impedit quia id a atque debitis consectetur. Nisi eum et tenetur eum et vero quibusdam. Quo hic ab voluptatibus nisi et quia.
Labore inventore corrupti voluptatem. Perferendis et possimus est fuga ullam quos. Et officiis possimus quidem suscipit. Qui qui quia id rem.
Sint assumenda quibusdam sapiente. Non culpa provident ipsum saepe labore ex. Sed expedita officia id maiores aliquam. Id ex ut quas ut mollitia dicta maiores. Aut debitis porro aliquam voluptas dignissimos cum minus.
Aut consequatur nobis accusantium provident asperiores eligendi illum. Accusamus officia ipsam aut sapiente similique. Molestiae laboriosam quam ea quaerat blanditiis quis aperiam. Culpa totam similique porro aliquid. Beatae hic cum repellat eos ipsa.