The Expert's Guide to Build an LCoE & LCoS Model Using Excel Best Practices in 2022 - Video 01

In this video we will model a simple LCOE calculation for a solar PV power plant. We check the LCOE formula and build an spreadsheet using Excel best practices for modelling.

In future videos we will expand the model by adding more details to the LCOE calculation and expanding increasing the robustness of the model with features to make it more flexible.
-------------------------
-------------------------
Check out all my models and templates: 🔥🔥🔥
------------------------
Got any Excel questions? 📊💼 Join my Discord server and let's chat about Excel, best practices, and financial models! 💬💡
------------------------
Feeling generous? ☕️ Buy me a coffee to support my content:
BTC: bc1qdmf35xjmqv9qxrdcxggq0qtjhwf43npzj0mu0m
ETH: 0xB1c39A1818baEc2b4219F4F78Cd9065B64b85EE9
-------------
🙏 Thank you for your support! Enjoy the content! 🎉📺

[DjalilaGad]

Thank you so much for this structured way of explaining and modeling an LCOE template. It helped me a lot !!

[lithalaxman]

Thank you for the video. I have one question please explain how to calculate LCOE if the investment is founded through a debt equity mix. For example a debt equity rate 70.30, 5% interest rate and 10 years loan repayment period.

[tintiner]

Could someone explain to me why we are discounting the energy generated? I mean why is one MWh today worth more than one MWh next year?

[ivaberiashvili]

Hi, how do you address variable costs? such as corporate tax

[hamraouiaziz]

why did you calculate the NPV of generation. what's a little bit weird here, u used a discount rate which is a whole concept corresponding to the time value of money and not to a quantity of MWH or liters or any other unit. I mean how did u use a discount rate on a quantity and why do u calcukate the npv of a quantity of MWh in the first place