Start Up Wind Farm Excel Model and Valuation Template
  • Start Up Wind Farm Excel Model and Valuation Template
  • Start Up Wind Farm Excel Model and Valuation Template
  • Start Up Wind Farm Excel Model and Valuation Template
  • Start Up Wind Farm Excel Model and Valuation Template
  • Start Up Wind Farm Excel Model and Valuation Template
  • Start Up Wind Farm Excel Model and Valuation Template
  • Start Up Wind Farm Excel Model and Valuation Template
  • Start Up Wind Farm Excel Model and Valuation Template
  • Start Up Wind Farm Excel Model and Valuation Template
  • Start Up Wind Farm Excel Model and Valuation Template
  • Start Up Wind Farm Excel Model and Valuation Template
  • Start Up Wind Farm Excel Model and Valuation Template
Originally published: 19/03/2019 21:09
Last version published: 01/04/2020 07:08
Publication number: ELQ-75987-6
View all versions & Certificate
certified

Start Up Wind Farm Excel Model and Valuation Template

Model that presents an investment in the construction of a wind farm and the sale of the energy generated from it.

Description
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).

This Best Practice includes
1 Excel file and 1 PDF

Acquire business license for $49.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • Rate this Downloadable Best Practice

    Write a review

  • Jor Rob(last updated: 02/07/2020 07:17)

keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Big4WallStreet

See all
keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Start Up Wind Farm Excel Model And Valuation Template

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

  • Sandeep Gupta721
    Hi, I can't follow the way VAT facility is structured in the model. Isn't the VAT facility used for temporary funding (during the construction phase on equipment purchase) before VAT is recovered in the VAT recovery phase (First 2 years of operations)? Shouldn't the amount equivalent to the VAT facility be recovered from the refund from government/Tax Authority and not from the cash flows of the project? Can you please explain the flow of VAT facility in the Balance Sheet and Cash Flow statement. Thanks in advance.
    arrow_drop_uparrow_drop_downReply reply
    • Big4WallStreet
      Please send to us a PM thanks
      arrow_drop_uparrow_drop_downReply reply
      • Sandeep Gupta721
        I sure can send you a PM if you can share the email. But then what's the point of having a discussion forum online?
        arrow_drop_uparrow_drop_downReply reply
        • Big4WallStreet
          You can email us here: marketing@big4wallstreet.com

          Thanks
          arrow_drop_uparrow_drop_downReply reply
          • Big4WallStreet
            The answer is yes to all your questions.
            arrow_drop_uparrow_drop_downReply reply
            • Sandeep Gupta721
              I just have one last question. The Balance Sheet doesn't balance unless you add the interest on VAT Facility during year 2 of construction (from Debt Schedule) to the interest during WIP (Work in Progress) in year 2 of construction (Depreciation Schedule). I just can't follow this logic. Would you be kind enough to explain this concept/logic?
              arrow_drop_uparrow_drop_downReply reply
              • Big4WallStreet
                Are you a user of the model?
                arrow_drop_uparrow_drop_downReply reply
                • Sandeep Gupta721
                  Yes
                  arrow_drop_uparrow_drop_downReply reply
                  • Big4WallStreet
                    From the Eloquens platform? Because we can't find you in the users of the model.
                    arrow_drop_uparrow_drop_downReply reply
                    • Sandeep Gupta721
                      Yes from eloquens platform
                      arrow_drop_uparrow_drop_downReply reply
                      • Big4WallStreet
                        We have thoroughly checked and you are not in the users of the model.
                        arrow_drop_uparrow_drop_downReply reply
                        • Sandeep Gupta721
                          What do you mean I am not in the users of the model? How am I then messaging you and you responding to my messages? If you can't answer my question, tell me so. Else, I'd really appreciate if you could answer my last question? Thanks
                          arrow_drop_uparrow_drop_downReply reply
                          • Big4WallStreet
                            This means you have not purchased the model. We can see all the users of the model, that have actually purchased the model. We won't answer any further questions.
                            arrow_drop_uparrow_drop_downReply reply
                            • Sandeep Gupta721
                              Just to clarify, I never said that I purchased the model. I recreated the model using the screenshots of the excel sheet from scratch. I wasn't able to balance the BS but then I figured out The Balance Sheet won't balance unless you add the interest on VAT Facility during year 2 of construction (from Debt Schedule) to the interest during WIP (Work in Progress) in year 2 of construction (Depreciation Schedule). This is the only logic I can't follow because most likely it's wrong. I just wanted your view on why you've done what you've done. If you don't want to answer I can understand as I haven't purchased your model. But I thought this was more like a discussion forum for all rather than for just people who have purchased the model.
                              arrow_drop_uparrow_drop_downReply reply


    5.0 / 5 (1 votes)

    please wait...