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 business tool includes
1 Excel Model, 1 Example, 1 Cancun Solar Model, 1 Explanatory Video

Acquire business license for $20.00

Add to cart

Add to bookmarks

Discuss

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More tools 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!

  • 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
      • FinExMod
        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
          • FinExMod
            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
              • FinExMod
                Ok will send you a private message
                arrow_drop_uparrow_drop_downReply reply
                • PDN
                  Hi, still waiting on the chat, thanks
                  arrow_drop_uparrow_drop_downReply reply
                  • FinExMod
                    Please check your messages. Thanks
                    arrow_drop_uparrow_drop_downReply reply
                    • PDN
                      Thank you for the quick turnaround!
                      arrow_drop_uparrow_drop_downReply reply
      please wait...