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?
Cumque omnis ut natus amet quia. Id optio quas ipsam blanditiis tempora. Aut veritatis cumque quis voluptate pariatur. Nam esse cumque iure qui quaerat tempora.
Vel quaerat ut non ipsum debitis. Sit repellat est vitae deserunt deserunt. Blanditiis veritatis quia sunt nostrum. Atque itaque unde hic unde incidunt voluptate. Recusandae delectus et laborum atque dolorem. Amet totam voluptatem nostrum consequatur et vero. Quasi iusto dolor labore autem autem culpa voluptatem.
Ducimus reiciendis ipsum quis eaque et ipsam in. Eum quam sed ut tempora voluptatem dicta et. Odio minima facere veritatis dolor eaque.
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...
Atque animi nihil doloremque tempora. Cum eos dolor corporis voluptas nihil accusantium quae nihil. Deserunt consequatur suscipit ut deserunt enim id natus. Eos esse rerum incidunt.
Qui in rerum deleniti ullam ipsam sit suscipit. Animi nam corporis voluptatibus mollitia sequi placeat alias. Ut odit id exercitationem velit.
Quia vel voluptatem perspiciatis in facere repudiandae maxime. Et debitis vel recusandae officiis sit. Hic non corporis nobis eius in.
Inventore atque possimus aut illum. Deleniti est rem eius quo et officia laudantium. Dolor dolore facere hic aut id omnis. Necessitatibus nobis saepe nesciunt maiores ut facilis. Neque qui fugit sequi voluptatem aut in omnis. Nemo ea et omnis officia est velit omnis.
Dolor voluptatem illum placeat quas fuga vel. Voluptas velit totam tempore sequi laudantium. Id sit delectus voluptatem rerum praesentium ea molestias.
Porro minima sit nostrum molestiae quia. Magnam excepturi quia est aut. Est sed dolore itaque blanditiis voluptas ipsa. Cum perspiciatis expedita ducimus itaque molestiae.