The 2023 Guide to Financial Modeling for Renewable Projects - 02 Input & Calculations Sheets

In this second video of this series, I will set up the Input & Calculation sheets. 💻

-------------------------
Check out all my models and templates: 🔥🔥🔥
https://bankruntemplates.com

Got any Excel questions? 📊💼 Join the discord server at   / discord  

Feeling generous? ☕️ Buy me a coffee to support my content:
https://www.buymeacoffee.com/neverxever
BTC: bc1qdmf35xjmqv9qxrdcxggq0qtjhwf43npzj0mu0m
ETH: 0xB1c39A1818baEc2b4219F4F78Cd9065B64b85EE9

🙏 Thank you for your support! Enjoy the content! 🎉📺

-------------
Affiliate links. Support the channel by using the link below 🥳:

📈 Deribit Exchange: This bot runs on Deribit Exchange. If you do not have an account, you can open one by clicking here. You will get a 10% discount on trading fees for the first 6 months:
Affiliate Link to Sign-Up Form: https://www.deribit.com/?reg=17933.3396
Affiliate Link to Front Page: https://www.deribit.com/?reg=17933.33...

💻 Want to learn how to trade options. Everything I know about it, I learned at tastytrade.com. Sign up for the best trading platform and watch thousands of hours of videos explaining options and options strategies:
https://start.tastytrade.com/#/login?...

🤖 Do you want to run the bot on Pythonanywhere.com? This is where I run it. Subscribe for their service by clicking here: https://www.pythonanywhere.com/?affil...

💼 NordVPN is the best VPN service out there. Sign up and receive up to 3 months for free: https://ref.nordvpn.com/qtVHFjIGOAX
---------------------
Chapters:
00:00 - Intro 🎬
00:23 - Recap Video 01 - The timeline 🔄
00:57 - What are we up to in this second video? 🤔
01:47 - The Input sheet 📝
03:11 - Styling the cells and numbers: In sheet input and in sheet calculation styles 💅
03:47 - Why you should properly style your models?!?!?! ❗️❓
04:48 - The Calculations sheet 📊
05:45 - The initial Cash Flow Structure 💰
07:12 - Updating the model: fixing hardcoded inputs and formulas 🔃
08:08 - Named Cell: Always name important model's cells! 🔖
08:38 - Model Start Date: An important parameter to the model ⏰
09:12 - More named Cells: Construction and Operation Start Dates 🔢
09:39 - NEVER EVER HARD CODE NUMBERS IN FORMULAS!!! ❌🔢
10:15 - EOMONTH formula: Why you always get it wrong? ❓📅
10:53 - The Technical Parameters Sheet 📊
12:38 - The only number allowed in formulas are 0s and 1s. Check out why! 🚫🔢
14:18 - More Styling: Please, properly style your numbers!!! Make it easy for you and others to read your model. 💅📌
15:21 - More Styling: Make sure you style formulas and calculated cells properly 💡💅💻
15:48 - Fixing hard coded inputs in the timeline. No hardcoded inputs in any sheet other than in the Input sheet 🛠️🔢
19:13 - We are done. But before we close the video, check the whole model for mistakes and things that you missed out during the code session! 🧐✅

-------------------------
Check out all my models and templates: 🔥🔥🔥
https://bankrun.gumroad.com/?sort=newest
------------------------
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:
https://www.buymeacoffee.com/neverxever
BTC: bc1qdmf35xjmqv9qxrdcxggq0qtjhwf43npzj0mu0m
ETH: 0xB1c39A1818baEc2b4219F4F78Cd9065B64b85EE9
-------------
🙏 Thank you for your support! Enjoy the content! 🎉📺