NOTE: The technical HAWT template is designed to function only with HAWT wind farms.
The simple and general template can be used to function with any wind farm type.
Start-Up Wind Farm Excel Model presents the business case of an investment in the construction of a wind farm and the sale of the energy generated from it. The model generates the three financial statements as well as the cash flows and calculates the relevant metrics (cash on cash, IRR, payback period, shareholder value, DSCR, LLCR). The financing options for the project include a construction loan, a VAT facility as well as an overdraft facility, and of course equity funding from investors.
The model structure is as follows:
Manual: main conventions used in the model.
Inputs (in yellow whatever can be amended as an assumption): detailed inputs for revenues (tariffs, capacity assumptions, theoretical and direct input gross capacity factors, and other capacities utilization parameters such as derating factors and other losses only for the technical excel model, in the simplified model revenues, are based on annual MWh produced and tariffs), costs (warranty, operations, and maintenance, land rental, insurance, distribution, operations, maintenance, insurance, etc..), working capital (receivables, payables, cash, and overdraft), fixed assets and CAPEX (including a construction schedule, VAT & Depreciation applicability), financing (long term debt and related VAT facility), equity financing as well as valuation assumptions (such as discount rates used).
Summary: Since the model does not use any macros, the summary page (1 page ready to be printed) is instantly updated with the main output metrics of the model such as IRR, Shareholder Value, Cash on Cash Multiple, Sources, and Uses, General Assumptions regarding the power generation including a power curve, DSCR, LLCR, and other financing assumptions.
Calculations: This is where all calculations are performed. The energy production is calculated and by applying the relevant tariffs adjusted for inflation and deducting the operating costs adjusted for inflation the operating profit is resulting. Based on the assets financed and the gearing of the financing the interest and depreciation are occurring. By using the working capital assumptions the impact of the business cycle is presented. Finally, the sources and uses of funds are presented and the relevant debt financing is calculated (construction loan, VAT Facility, and overdraft)
Outputs: everything is aggregated here into the relevant statements: profit and loss, balance sheet, and cash flow.
Graphs: Various graphs present the investment & operating costs as well as the energy generation potential. Then multiple charts present the performance of the project from revenues to the bottom line along with debt, assets, working capital, and cash flows which result in valuation on a project basis as well as on an equity basis together with the internal rate of return of the project and payback period metrics.
Investment Metrics: in order to see the detailed calculations for the above metrics (IRR, DSCR, LLCR, Valuations, Payback Period) you should consult this page for more information.
Checks: A dedicated worksheet that makes sure that everything is working as it should!
Important Notice: Yellow indicates inputs and assumptions that the user is able to change, blue cells are used for called-up cells, and white cells with black characters indicate calculation cells. The model does not use a macro (all calculations are performed on the spot).
Similar Products
Other customers were also interested in...
Battery Energy Pricing Model
The Battery Energy Pricing Model calculates the required energy price for an industrial-scale batter... Read more
Renewable Energy Template Bundle
This is a collection of selected renewable energy model templates which are set in a bundle which wi... Read more
Green Ammonia from Renewable Energy Financial Mode...
This comprehensive 40-year tool aid investors in evaluating potential risks and returns and assess t... Read more
Renewable Energy Financial Model Template Bundle
Take this opportunity and get a discount by getting the Renewable Energy Bundle where you get Solar,... Read more
Wind Farm Development Model
Wind Farm Excel Model Template is an excellent tool to assess the financial feasibility a proposal t... Read more
Wind Farm – 3 Statements Financial Model Tem...
Wind Farm - 3 Statements Financial Model with Flexible Timeline, NPV, IRR, Debt Covenants,... Read more
Green Hydrogen (Electrolysis) Production Financial...
This green hydrogen financial model template builds a multi-year financial plan to analyze the finan... Read more
Wind Farm Financial Model
Strategically design the financial framework for launching a wind farm, incorporating up to five dis... Read more
Wind Farm – Project Finance Model
Project Finance Model providing forecast and profitability analysis of a development and operating s... Read more
Renewable Energy Financial Models Bundle
A collection of user-friendly Project Finance Models in the Renewable Energy Sector offered at a dis... Read more
You must log in to submit a review.