Build a LCOE model in Excel in 5 minutes!

Подписаться 1,4 тыс.

Просмотров 7 тыс.

50% 1

Get a LCOE done in 5 minutes. Check that out.
For a step-by-step explanation on LCOE models in Excel, what the series "The Expert's Guide to Build an LCoE & LCoS Model Using Excel Best Practices in 2022 ".
To download the Excel file from this video: bankruntemplat...
To watch the series on LCOE: shorturl.at/fpTW3
-------------------------
Check out all my work: 🔥🔥🔥
bankruntemplat...
------------------------
Got any Excel questions? 📊💼 Join my Discord server and let's chat about Excel, best practices, and financial models! 💬💡
/ discord
------------------------
Feeling generous? ☕️ Buy me a coffee to support my content:
www.buymeacoff...
BTC: bc1qdmf35xjmqv9qxrdcxggq0qtjhwf43npzj0mu0m
ETH: 0xB1c39A1818baEc2b4219F4F78Cd9065B64b85EE9
-------------
🙏 Thank you for your support! Enjoy the content! 🎉📺

Опубликовано:

15 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 10

@tufferyclement606 8 месяцев назад

MERCI, and thanks you from FRANCE

@bankrun2023 8 месяцев назад

Thank you too!

@ErvellBoyd Год назад

Why do you discount the total generation? What are some ways that power producers come up with discount rates? Is it just their WACC?

@bankrun2023 11 месяцев назад

Hi @user-ig1tt3ve8q, I discount the generation to calculate its NPV. As you know the LCOE = NPV(costs)/NPV(generation). The discount rates can be calculate in different ways. A company can use the WACC, WACC + Risk Premium, etc.

@jaden8672 Год назад

Could you recommend a book related te how to build financial modelling for energy project, in particular using macro method ?

@bankrun2023 Год назад

Hi Jaden86, I am not aware of any good book for FM. But I can recommend you the courses from Wall Street Prep and I am planning on recording RU-vid videos on how to do FM for renewable projects. Planning to start this week.

@jaden8672 Год назад

@@bankrun2023 many thanks! for your great work !

@milesjohnston149 Год назад

my inputs and table match yours exactly, when i do the final step (entering LCOE formula) i end up with $50.03/mWh. can you help?

@milesjohnston149 Год назад

i also think you're wrong brotha, you're project inputs are realistic but there's no project in the world that could produce energy for $0.04 per mWh...

@bankrun2023 Год назад

Hi, send me your file to ineverxever@gmail.com. I will look at it and revert back by the end of the weekend. For the LCOE, it should be 50 USD/MWh or 5cUSD/kWh, which is reasonable for a utility scale project. And subscribe to the channel if you haven't done that yet.