A self-made Modeling Test with a solution of an Onshore Wind Turbine. The case study is in Chile assuming a 376 MW Capacity. The download includes a PowerPoint Presentation, a PDF, along with an excel model with explanations.
The model is a full-scale model with a Project Finance Debt Sizing, Balance Sheet, Cashflow & Income Statement.
The Model is complemented with an executive summary and interactive Graphs, along with Data Table Sensitivities. No Macros.
It is best for an Associate/Analyst looking to Break into Infrastructure Private Equity. This will illustrate how the exact solution should be presented, and how to debt size the cash flow along with tax credit and others assumptions.
Most Models online are too complicated with excessive use of macros. What is appropriate for an Analyst/Associate level is to create a simple, easy-to-use, easy to modify model that incorporates all the variables in Project Finance Investment Analysis.
From my experience, the best way to pass an assessment is to have already a template ready and then input the given you get into the template. Saves you time and gives you extra time to create a PowerPoint presentation to showcase your presentation skills along with your conclusions.
This model template comes as a PREMIUM version in .xlsx file type which can be opened using MS Excel.