Solar Farm Investment Excel Model Template
Originally published: 26/12/2018 11:15
Publication number: ELQ-38580-1
View all versions & Certificate

Solar Farm Investment Excel Model Template

Solar farm investment assessment model in Excel

30 year annual solar 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 solar 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.

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 $40.00

Add to cart

Add to bookmarks


Further information

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

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

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

0.0 / 5 (0 votes)

please wait...