Start Up Solar Farm Excel Model and Valuation
Originally published: 27/03/2019 07:36
Last version published: 29/03/2019 10:34
Publication number: ELQ-58954-3
View all versions & Certificate

Start Up Solar Farm Excel Model and Valuation

The model presents an investment in the construction of a solar farm and the sale of the energy generated from it.

Start Up Solar Farm Excel Model presents the business case of an investment in the construction of a solar 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:

Map Tab: presents on a global scale the horizontal irradiation in order for the user to be able to approximate an estimate of the irradiation for his region (" Solar resource data obtained from the Global Solar Atlas (GSA), owned by the World Bank Group and provided by Solargis" under the Commons Attribution license)

Manual Tab: main conventions used in the model.

Inputs Tab: (in yellow whatever can be amended as an assumption): detailed inputs for revenues (tariffs, capacity assumptions, and other capacity utilization parameters such as pre photovoltaic and system & thermal losses), costs (maintenance, insurance, land leasing, system and transmission costs, contingency costs), 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 Tab: 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 relevant graph, DSCR, LLCR, and other financing assumptions.

Calculations Tab: this is 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 Tab: everything is aggregated here into the relevant statements: profit and loss, balance sheet and cash flow.

Graphs Tab: 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).

This Best Practice includes
1 Excel file and 1 PDF

Acquire business license for $89.00

Add to cart

Add to bookmarks



  • Be the first to review this Downloadable Best Practice

    Write a review

People using this Best Practice also downloaded


More Best Practices from Big4WallStreet

See all

Discussion feed for Start Up Solar Farm Excel Model And Valuation

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

  • Kirkland Allen,  CPA
    I bought this model. However, I feel like it is as good as the user. The instructions are vague. Is there any better guidance available?
    arrow_drop_uparrow_drop_downReply reply
    • Big4WallStreet
      The only thing you need is to fill the yellow cells in the yellow tabs. Everything else is calculated automatically. Should you need any specific explanations please send to us a PM through Eloquens platform and we will get back to you.
      -1arrow_drop_uparrow_drop_downReply reply

    0.0 / 5 (0 votes)

    please wait...