IB renewable energy modelling test question

Based on the most helpful WSO content and insights from renewable energy modeling discussions, here's how you should approach this test:

1. Understand the Scope of the Test

• Since the test is only 2 hours and they provide inputs like debt repayment schedules, it’s likely designed to test your ability to quickly and accurately calculate IRR and NPV rather than build a full-blown financial model.
• The absence of debt sculpting simplifies the process, so focus on efficiency and accuracy.

2. Recommended Approach

• Option 2: Create a Single Waterfall is the best approach for this test. Here's why:
  • It aligns with the time constraints.
  • It directly focuses on the cash flow mechanics needed for IRR and NPV calculations.
  • It avoids unnecessary complexity, such as building full 3-statement models, which may not be required.

3. Steps to Build the Waterfall

• Time Flags: Set up a timeline (monthly, quarterly, or annual, depending on the inputs provided).
• Revenue to EBITDA:
  • Start with revenue projections.
  • Deduct operating expenses (OPEX) to calculate EBITDA.
• EBITDA to Cash Flow:
  • Deduct depreciation and amortization (D&A) if provided.
  • Account for any capex reserves or maintenance capex.
• Debt Repayments:
  • Use the provided debt repayment schedule to deduct principal and interest payments.
  • Include DSRA (Debt Service Reserve Account) adjustments if applicable.
• Cash Flow to Equity:
  • After debt service, calculate the cash flow available to equity holders.
• IRR and NPV:
  • Use the cash flow to equity to calculate the project IRR and NPV.
  • Ensure you use the correct discount rate for NPV.

4. Key Tips for Success

• Set Up Clear Inputs and Outputs:
  • Create a clean input section for assumptions (e.g., revenue growth, OPEX margins, discount rate).
  • Clearly label outputs like IRR, NPV, and cash flow summaries.
• Use Excel Best Practices:
  • Avoid hardcoding values; link everything to inputs.
  • Use consistent formatting (e.g., blue for inputs, black for formulas).
• Double-Check Formulas:
  • Pay special attention to IRR and NPV formulas. For IRR, use =IRR() and for NPV, use =NPV() but ensure the cash flows are correctly aligned.
• Time Management:
  • Allocate time wisely: 30-40 minutes for setting up the model, 20-30 minutes for calculations, and the remaining time for reviewing and refining.

5. Additional Considerations

• If they mention cash sweeps, ensure you understand how to model them (e.g., excess cash after DSRA and debt service is used to prepay debt).
• Be prepared to explain your logic during the screen-sharing session. Practice articulating your thought process clearly.

By focusing on a streamlined waterfall model, you’ll demonstrate your ability to handle renewable energy-specific cash flow mechanics efficiently. Good luck!

Sources: Renewables valuations have gotten out of hand, Renewable Energy, Affordable Housing Investment with Crazy IRR??, https://www.wallstreetoasis.com/forum/investment-banking/renewable-energy?customgpt=1