Wind Farm Investment Excel Model
  • Wind Farm Investment Excel Model
  • Wind Farm Investment Excel Model
  • Wind Farm Investment Excel Model
  • Wind Farm Investment Excel Model
  • Wind Farm Investment Excel Model
Originally published: 26/12/2018 11:10
Publication number: ELQ-77963-1
View all versions & Certificate
certified

Wind Farm Investment Excel Model

Wind farm investment assessment model in Excel

Description
30 year annual wind farm investment appraisal model. The user does not have to use all 30 years. The model has the ability to enter opening Balance Sheet (optional) and forecast numbers. The user has the ability to enter a capital structure. This can be a mix of senior debt and equity used for purchasing/investing in the wind farm site.

The outputs include a simplified Profit and Loss statement, a simplified Balance Sheet, a statement of net cash flows and an IRR (valuation) output.

Prices are entered as "real" prices and the user can enter various "inflation" rates to apply to prices.
The user can enter up to two different production efficiencies which can be pulled into the annual timeline.

In addition to electricity sales the user has the ability to enter assumptions for subsidies per MWh.
Costs are entered for both fixed and variable costs.
Working capital assumptions are entered separately in days for electricity sales, subsidy sales, fixed costs and variable costs.

Tax assumptions are entered annually and paid in the year in which they accrue. The user has the option to enter an EBITDA restriction for interest deductibility.

Debt assumptions are entered including the term, the cost, the amount, the margin, the upfront fee, hedging portion of debt. The user can also enter various debt sizing restrictions.

Finally the user can enter various acquisition assumptions including equity investment required and acquisition cost percentage.

This Best Practice includes
1 powerpoint of instructions, 1 excel model template

Acquire business license for $45.00

Add to cart

Add to bookmarks

Discuss

Further information

To model out and get an initial view of the feasibility of a wind farm investment/purchase

When the user wants a quick answer as to the feasibility of a wind farm investment

When the user requires more specific and sophisticated mechanisms e.g. specific jurisdictional tax and subsidy calculations

Reviews

  • Be the first to review this Downloadable Tool

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from ModellingGuy

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Wind Farm Investment Excel Model?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...