Financial Model Suggestions

Hello everyone,

NREL is developing a work plan for a project to improve SAM's financial modeling capabilities. This work could include modifying existing models, adding new ones, or both. For a description of SAM's current financial models, see:

sam.nrel.gov/financial-models

We are already working on improvements to SAM's electricity bill calculator for behind-the-meter projects, and we do have some ideas for financial model fixes and enhancements , but would love to hear your suggestions. Is there a financial structure you would like to model in SAM that is not available in the latest version? Are there financial model inputs or results you would like us to add? Please let us know by posting a response to this post.

Thanks!
Paul and the SAM team.

p.s. We would prefer that you post your suggestion to the forum so other people can comment and respond, but if you'd prefer to make a This email address is being protected from spambots. You need JavaScript enabled to view it., please do.

Hi Brian,

Thank you for those suggestions. Would you be willing to share a copy of your modified spreadsheet with us? If you'd prefer not to share it on the forum, please This email address is being protected from spambots. You need JavaScript enabled to view it. instead.

Best regards,
Paul.

Hi Kaiyer,

Thank you for the suggestions! I made a few formatting changes to your message to make it easier to read.

By "standard SEIA PPA form", to you mean of the documents posted here on the SEIA website?

www.seia.org/research-resources/model-leases-and-ppas

Best regards,
Paul.

One of the main limitations in using SAM to model power plants in another country is that we use a Value Added Tax scheme instead of a Sales Tax. This tax applies to the investment costs as well as to the revenues, while the sales tax only applies to the investment cost.

I have no problem applying the VAT to the Investments part, since I can input it as a sales tax. On the other hand, I'm having problems applying it to the Total Revenue part. I have already searched for a solution but found none which would solve the issue correctly. If there is already an available way to work around this issue I would thank you if you could let me know.

Having said this, my suggestion/request would be to implement a way to decide whether to use Sales Tax or Value Added Tax, since this would improve the model applicability in many other countries.

Here is a suggested workaround to model the 16% VAT in Mexico:

1. Add a sales tax of 16% to match the 16% Value Added Tax. This inserts the VAT to the cash flow.
2. Set the total depreciation basis to 86.2% to remove the VAT from the depreciation basis, since the VAT does not depreciate in the long term, as required by law. (Will probably differ from country to country)
3. Add a IBI of 16%. Since the 16% VAT tax you paid is going to be in your favor when total taxes are calculated. (Will also probably differ from country to country)
4. Add a State tax of 13.8%. Since the cash flows now have the VAT added to them, this will correspond to the VAT that will need to be paid.