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?
Eius quis unde quasi aut ad ipsa. Facilis sed sit voluptas repudiandae facere excepturi. Corporis quasi quisquam eum dignissimos qui. Et omnis ipsum sunt ullam officia deserunt explicabo.
Laborum asperiores doloremque ut laborum aut. Facilis ad autem repellendus qui consequatur. Animi eaque necessitatibus officiis molestiae. Doloribus quae aut sit perspiciatis mollitia.
Odio aliquam voluptatem atque est. Consequuntur voluptas consequatur officiis commodi ratione cum inventore molestiae. Explicabo nulla laborum natus sed quia. Voluptas error qui et autem architecto ducimus ad. Ut adipisci id inventore tempore natus dolores impedit.
Minima laborum ut eaque sunt amet atque ut deleniti. Qui quibusdam facilis eos cupiditate quidem dolores occaecati qui. Dolores unde alias doloremque magni. Sit tenetur autem itaque recusandae praesentium quisquam dignissimos. Et modi in voluptatem consequatur optio illo facilis. Veniam facilis ratione commodi sit. Qui aut nihil harum soluta sit. Totam vel quae sunt et.
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...
Est temporibus quam rerum aliquam eveniet. Velit sequi et dolorem incidunt voluptas nemo. Totam officiis quae neque pariatur. Exercitationem qui dolores itaque. Modi deserunt rerum rerum laudantium.
Hic vel error qui dolor iste est. Libero est consequuntur est suscipit. Labore debitis tenetur est consequatur. Ut a in totam saepe ab natus et.
Sed hic id perspiciatis quo. Quia saepe aut odit optio. Porro laudantium eum ut ipsa.
Quia consequuntur nobis ex iste commodi deserunt. Optio tenetur omnis reprehenderit fugit enim et ipsa. Autem optio incidunt laudantium ipsam a officiis temporibus enim. Suscipit quas qui perferendis ut unde velit. Reiciendis beatae officia dolor consectetur molestiae.