Model Test (debt raise/debt size)

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:

1. 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.

2. 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.

3. Key Metrics for Debt Sizing:

   • Debt Service Coverage Ratio (DSCR): This measures the company's ability to use its operating income to cover all debt obligations, including interest, principal, and lease payments. A higher DSCR indicates greater capacity to take on more debt.
   • Cash Flow Available for Debt Service (CFADS): This is a measure of the cash flow the company can use to service its debt. It's calculated before any debt payments but after operational expenses and capital expenditure needs have been met.

4. 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.

5. 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