Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
  • Solar Project Finance Model
Originally published: 30/04/2018 15:40
Last version published: 09/04/2019 15:31
Publication number: ELQ-63279-4
View all versions & Certificate
certified

Solar Project Finance Model

Understand the effects of financing costs on the required price of a solar project finance model.

Description
The files provided in this tool demonstrate how finance and costs affect the required price in a solar project finance model.

The solar project finance file includes functions that can resolve circular reference so that bid prices are able to be evaluated with various financing techniques. The file can be used to examine how bid prices are impacted by up-front funding, the DSCR, interest rates, debt repayment tenure and techniques, and the DSRA accounts.

DSRA stands for Debt Service Reserve Account is a fundamental aspect of most project financial models. The DSRA serves the purpose of protecting the lender againt unpredictable or unexpected volatility in the CFADS - the Cash Flow Available for Debt Service.

This can all be done on the summary sheet by using the spinner buttons. It also includes application of the scenario reporter. Here, you can build a list of scenarios by changing inputs and placing the output on a separate sheet. The Cancun solar model has also been included which has been made to work through various issues linked with estimating solar resources. This includes a fundamental modelling structure.

In addition, there is an accompanying tutorial video that provides a great explanation of how to best utilise the model.

This Best Practice includes
1 Excel Model, 1 Example, 1 Cancun Solar Model, 1 Explanatory Video

Acquire business license for $50.00

Add to cart

Add to bookmarks

Discuss

Reviews

keyboard_arrow_downShow all


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Prof. Ed Bodmer

See all
keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Solar Project Finance Model

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

  • Andrés Arango Santamaría
    Hello,

    I have the same problem

    The Solar Model Example I just downloaded. It opens up with a bunch of errors (i.e. VALUE! signs all over the worksheets)

    And the model didn´t opened The yellow Message Bar and the Enable Content button.

    What can I do ?
    arrow_drop_uparrow_drop_downReply reply
    • Prof. Ed Bodmer
      Hello,

      I tried to figure out by myself and this is my solution.

      If you can not open it in your mic. excel or you do not have it.

      This files are .XLSM so you can open it in your google account.
      What I did is, that I send this file to my google email and I opened it there. And it works. Or you can save this file in your google account and open it there.

      If this doesnt work for you, just let me know please.
      -1arrow_drop_uparrow_drop_downReply reply
      • Andrés Arango Santamaría
        Prof. Bodmer, thank you very much for your soon response.

        This time the yellow Message Bar and the Enable Content button were there and I enabled them, but the #VALUE sales still appear in many cells.
        arrow_drop_uparrow_drop_downReply reply
        • Andrés Arango Santamaría
          The #VALUE appear in many cells
          arrow_drop_uparrow_drop_downReply reply
          • Prof. Ed Bodmer
            I am really really sorry for this problem.
            I am trying to figure out where is the problem.
            My question is, do you open the file in microsoft excel or by google ?
            arrow_drop_uparrow_drop_downReply reply
            • Prof. Ed Bodmer
              So, i got the solution to this problem. It is working 100%, but you need to open it in microsoft excel, because there are macros and all this kind of stuff which google doesnt have.
              arrow_drop_uparrow_drop_downReply reply
              • Andrés Arango Santamaría
                Dear Profesor Bodmer;

                Thank you very much for your timely answers. I did what you told me. I sent the model to Gmail and downloaded it from there in excel.

                The yellow boxes appeared this time and I accepted them all, but still the #VALUE appears in many cells.

                I sent you the pictures to your email.

                I also bought your book and I have it on Kindle version. Is any solution there?
                arrow_drop_uparrow_drop_downReply reply
                • Andrés Arango Santamaría
                  Dear Profesor Bodmer;

                  Thank you very much for your timely answers. I did what you told me. I sent the model to Gmail and downloaded it from there in excel.

                  The yellow boxes appeared this time and I accepted them all, but still the #VALUE appears in many cells.

                  I sent you the pictures to your email.

                  I also bought your book and I have it on Kindle version. Is any solution there?
                  arrow_drop_uparrow_drop_downReply reply
                  • Prof. Ed Bodmer
                    So, i got the solution to this problem. It is working 100%, but you need to open it in microsoft excel, because there are macros, scripts and all this kind of stuff which google doesnt have
                    arrow_drop_uparrow_drop_downReply reply
                    • Andrés Arango Santamaría
                      Profesor Bodmer I´m opening the file in Microsof Excel, dowloaded it from Gmail (as you recommended me), accepted all the Yellow boxes of editing etc . But there still appear #VALUE in many cells.

                      Could we connect for a couple of minutes (skype zoom, Google Talk) so I can show you?

                      Maybe this way we could resolve this issue in 2 to 3 minutes.

                      Thank you very much for your help and disposition. I´ll be waiting for your answer.

                      Andrés Arango.
                      arrow_drop_uparrow_drop_downReply reply
                      • Prof. Ed Bodmer
                        Hi,

                        yes of course. We can skype and try to figure out! Tell me what is the best time for you to talk.
                        arrow_drop_uparrow_drop_downReply reply
                        • Andrés Arango Santamaría
                          Dear Prof. Bodmer,

                          Thank you very much for your disposition and help. With all the information and links you sent me in the last email I solved the problem.

                          Thanks again

                          Andrés Arango
                          arrow_drop_uparrow_drop_downReply reply
        • Fanex
          Correction: I meant to write 15-20 year projections.
          arrow_drop_uparrow_drop_downReply reply
          • Fanex
            I need help building a financial model with a 15-20 cash flow projections for a planned 15 MW Solar PV farm in NJ, US.
            Where and how can I access a free model template or low cost help?
            1arrow_drop_uparrow_drop_downReply reply
          • PDN
            hi Ed, there seems to be an issue w the Solar Model Example or at least the version I just downloaded. It unfortunately opens up w a bunch of errors (i.e. VALUE! signs all over the worksheets). Any idea what might be the issue?
            arrow_drop_uparrow_drop_downReply reply
            • Hedieh Kianyfard
              Hello PDN,
              Did you enable macros (yellow Message Bar and the Enable Content button)? Please try this and if the problems persist, let me know and we can have a chat with screen sharing to detect your issue. Thanks,
              arrow_drop_uparrow_drop_downReply reply
              • PDN
                yes indeed, i've done that to no avail. i will try to re-download and re-open etc. to see if that solves the issue
                arrow_drop_uparrow_drop_downReply reply
                • Hedieh Kianyfard
                  Ok. Let me know if you need any assistance with this.
                  arrow_drop_uparrow_drop_downReply reply
                  • PDN
                    Yes, pls. I just re downloaded everything and the issue seems to persist
                    arrow_drop_uparrow_drop_downReply reply


          4.6 / 5 (53 votes)

          please wait...