Start Up Wind Farm Excel Model and Valuation
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 capacity utilization parameters such as derating factors and other losses), 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 were 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 bottom line along with debt, assets, working capital and cash flows which results in a 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 indicates calculation cells. The model does not use a macro (all calculations are performed on the spot).