Project Finance Financial Model Interview Test - Renewables, US Solar Developer - Help Needed

To tackle this case effectively, here's a structured approach based on the most helpful WSO content and insights from renewable energy and project finance discussions:

1. Executive Summary (Slide 1):

• Key Metrics Comparison: Create a table summarizing unlevered and levered IRRs, NPVs, net equity values, and sources/uses of funds for all three scenarios. Highlight the differences clearly.
• Benefits and Drawbacks: Use bullet points to outline the pros and cons of each scenario. For example:
  • Case 1 (Increase PPA Rate): Higher revenue potential but may face market resistance or regulatory hurdles.
  • Case 2 (Increase ITC Eligibility): Improved tax benefits but dependent on eligibility criteria and timing.
  • Case 3 (Increase Interest Rates): Higher financing costs but may stress-test the project's resilience.
• Recommendation: Identify the scenario with the highest sponsor returns and justify it with a concise rationale (e.g., optimal risk-adjusted returns, alignment with market conditions).

2. Individual Case Analysis (Slides 2-4):

For each scenario, break down the analysis into the following sections:

A. Project-Level Impact:

• Revenue: Show how the scenario affects revenue streams (e.g., higher PPA rates in Case 1).
• Costs: Highlight changes in costs, including O&M, financing, and tax implications.
• Cash Flows: Present a simplified cash flow summary to show the impact on project-level IRR and NPV.

B. Sponsor-Level Returns:

• Equity IRR and NPV: Calculate and present the sponsor's returns under each scenario.
• Equity Contribution: Show how the scenario affects the sponsor's equity contribution and net equity value.

C. Tax Equity:

• ITC Impact (Case 2): Quantify the increase in tax equity proceeds and its effect on overall project economics.
• Depreciation Benefits: Highlight any changes in tax depreciation schedules.

D. Debt Implications:

• Leverage Metrics: Discuss how the scenario affects DSCR, debt sizing, and repayment schedules.
• Interest Rate Sensitivity (Case 3): Stress-test the project under higher interest rates and show the impact on cash flows and returns.

E. Risk Assessment:

• Key Risks: Identify risks specific to each scenario (e.g., regulatory risk for ITC, market risk for PPA rates, interest rate risk for back-leverage).
• Mitigation Strategies: Suggest ways to mitigate these risks (e.g., hedging interest rates, securing long-term PPAs).

3. General Tips for the Slide Deck:

• Clarity and Simplicity: Use clean visuals like tables, charts, and graphs to present data. Avoid overloading slides with text.
• Dynamic Modeling: Ensure your financial model is dynamic, allowing for quick adjustments to assumptions.
• Focus on Key Drivers: Emphasize the metrics and assumptions that drive the most significant changes in returns.
• Stress-Test Scenarios: Include sensitivity analyses for critical variables (e.g., PPA rates, ITC eligibility, interest rates).

4. Resources to Leverage:

• WSO Renewable Energy PE Overview: Insights into trends like energy storage and decentralized projects can help frame your analysis.
• WSO Infrastructure Investment Threads: Review discussions on DSCR, debt structuring, and cash flow modeling for infrastructure projects.
• Tax Equity Investment Structures: Apply your Udemy course knowledge to model ITC impacts and tax equity proceeds effectively.

5. Final Thoughts:

Your approach to breaking down Slides 2-4 into detailed sections is solid. Just ensure you balance detail with clarity—focus on the most impactful metrics and insights. For Slide 1, prioritize a clear, concise comparison that guides the audience to your recommendation.

Good luck with your case! If you need further clarification or resources, feel free to ask.

Sources: Renewable Energy PE Overview, PE professional, what's your process while judging an investment?, Renewable Energy PE Overview, PE professional, what's your process while judging an investment?, Multi-Family Acquisitions Excel Test