andrew@agcapitalcfo.com

Stage 6 (2022) “Layton’s Lenders”

Professional Excel Templates for your Business

Stage 6 (2022) "Layton's Lenders"

This is an actual case study that was presented to the participants of the Financial Modeling World Cup 2022, Stage 6 (September 2-5).

Case study description:

As the new manager of a wind farm project, your objective is to find a financing structure that both sponsors and lenders agree on. You must explore various metrics and scenarios in the financial model that your co-worker, Emmy, has set up. Specifically, you must calculate LLCRs, debt sculpting, and incorporate seasonal adjustments in the model. All calculations must be done based on the assumption that Emmy’s existing workings are correct, and no range names need to be used in your workings.

The main problematic for the wind farm project is that the sponsors and lenders are not agreeing on the financing structure. The project requires an enormous amount of capital expenditure, and both parties want to find more agreeable terms. Specifically, the lender, Descolé, has an unusual agreement with Layton, the sponsor, on how much debt to draw.

The downloadable file consists of the following:
Task: PDF file with Case Materials; PDF file with Questions; Excel file with initial data and case assumptions
Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold

You can also buy tickets to participate in the future FMWC Stages here.

 

Reviews

There are no reviews yet.

Be the first to review “Stage 6 (2022) “Layton’s Lenders””

Your email address will not be published. Required fields are marked *