Bank Run
Bank Run
  • Видео 58
  • Просмотров 97 607
#3 Renewable Energy Financial Modeling Excel Case Interview
In this video I complete from scratch a Renewable Energy Financial Modeling Excel Case Interview for a wind farm.
Very interest exercise with several insights and takeaways that you can use not only to deliver the Financial Model, but to show as a candidate you are ready for the job.
----------------------
Download the files at bankruntemplates.com/collections/case-interview/products/wind-farm-project-in-thailand-real-case-financial-model-interview
-------------------------
Check out all my models and templates: 🔥🔥🔥
bankruntemplates.com
Got any Excel questions? 📊💼 Join the discord server at discord.gg/jU7DCtqsS3
Feeling generous? ☕️ Buy me a coffee to support my content:
www.buymeacoffee.com/neve...
Просмотров: 1 171

Видео

Data Tables in MS Excel - The ULTIMATE GUIDE for Sensitivity Analysis
Просмотров 752 месяца назад
In this step-by-step tutorial, learn how to use Data Table in Microsoft Excel. With Data Table, you can perform sensitivity analysis for 1 or 2 inputs and calculate the output for several variables.. Playlist on Sensitivity Analysis: ruclips.net/p/PLlW0IhpkW9AdODLNZV-Xr2aJRWEs6mvSZ The ULTIMATE GUIDE for Sensitivity Analysis video: ruclips.net/video/nj3O6n7EhsQ/видео.html Check out all my model...
Goal Seek in MS Excel - The ULTIMATE GUIDE for Sensitivity Analysis
Просмотров 642 месяца назад
In this step-by-step tutorial, learn how to use Goal Seek Microsoft Excel. With Goal Seek, you can find the result you want by adjusting an input value. SENSITIVITY ANALYSIS playlist: ruclips.net/p/PLlW0IhpkW9AdODLNZV-Xr2aJRWEs6mvSZ The ULTIMATE GUIDE for Sensitivity Analysis video: ruclips.net/video/nj3O6n7EhsQ/видео.html Check out all my models and templates: 🔥🔥🔥 bankruntemplates.com Got any ...
ULTIMATE guide for SENSITIVITY ANALYSIS: Goal Seek | Data Table | Sce. Manager | Solver & More
Просмотров 1612 месяца назад
In this video, I present a complete and detailed explanation on how to use the built-in MS Excel tools designed for SENSITIVITY ANALYSIS. I will also teach you how to build YOUR OWN sensitivity analysis tool, which provides more flexibility and better readability which you can use to impress your manager or your client! During the first half of the video I will walk you through the built-in too...
#2 - Financial Modeling Interview in Excel - Real Case - Wind farm in Spain
Просмотров 4742 месяца назад
Today, I'll walk you through another real case 📊 MS Excel Financial Model Interview! This is a full exercise, where I will guide you through a blank worksheet to the final version of the model. 🎥✨ Download the file of this video at bankruntemplates.com/products/2-real-case-financial-model-interview-wind-farm-in-spain Check out all my models and templates: 🔥🔥🔥 bankruntemplates.com Got any Excel ...
#1 - Financial Modeling Interview in Excel - Real Case
Просмотров 4444 месяца назад
Today, I'll walk you through another real case 📊 MS Excel Financial Model Interview! A viewer sent me a request 📨 asking how to set up the tax loss carry forward structure. That's exactly what I'll be presenting today! Stay tuned, because in the next video, I'll complete the entire exercise. 🎥✨ 🎉 Want a FREE Levelized Cost of Hydrogen Template??? 🎉 If so, subscribe to the channel and email me a...
#REF Error in Microsoft Excel: How to Fix it and Avoid it at all
Просмотров 3815 месяцев назад
In this video, we'll walk you through managing #ref errors in Excel, starting with simple examples and then moving on how to deal with this type of error with financial models. You'll learn what causes REF errors, how to troubleshoot them, and most importantly, how to avoid them altogether. Stay tuned for expert tips on handling these errors effectively and improving your Excel skills. Check ou...
Breaking Down Circular References in Project Finance - 05 Commitment Fee
Просмотров 4318 месяцев назад
Welcome to our 🌐 Breaking Down Circular References in Project Finance Model Series! 📊 In this series, I'll guide you through the best practices of handling circular references in project finance models. 🔄 🏗️ Dive deep into the three core project finance structures that lead to circularities: - Interest During Construction, - Debt Sculpting, and - Debt Service Reserve Account - Commitment Fee (e...
Tax Equity Financial Model - 03 Options Available: Flexi or Fix dates, Scenario Manager, & Flip
Просмотров 1358 месяцев назад
The Tax Equity Financial Model is the most complete template available for the U.S. market. Among its features, you will find: - Partnership flip - Direct-Pay & Transferable tax - MACRS - Complete Dashboard with 10 graphs - Scenario Manager - Debt Sculpting - and much more. Buy yours at bankruntemplates.com/collections/paid/products/tax-equity-financial-model-for-renewable-projects Check out al...
Tax Equity Financial Model - 02 Main Sections and Sheets
Просмотров 1868 месяцев назад
The Tax Equity Financial Model is the most complete template available for the U.S. market. Among its features, you will find: - Partnership flip - Direct-Pay & Transferable tax - MACRS - Complete Dashboard with 10 graphs - Scenario Manager - Debt Sculpting - and much more. Check out all my models and templates: 🔥🔥🔥 bankruntemplates.com Got any Excel questions? 📊💼 Join the discord server at dis...
Tax Equity Financial Model - 01 Initial Presentation
Просмотров 1528 месяцев назад
The Tax Equity Financial Model is the most complete template available for the U.S. market. Among its features, you will find: - Partnership flip - Direct-Pay & Transferable tax - MACRS - Complete Dashboard with 10 graphs - Scenario Manager - Debt Sculpting - and much more. Check out all my models and templates: 🔥🔥🔥 bankruntemplates.com Got any Excel questions? 📊💼 Join the discord server at dis...
Breaking Down Circular References in Project Finance - 03 DSRA (Debt Service Reserve Account)
Просмотров 8109 месяцев назад
Welcome to our 🌐 Breaking Down Circular References in Project Finance Model Series! 📊 In this series, I'll guide you through the best practices of handling circular references in project finance models. 🔄 🏗️ Dive deep into the three core project finance structures that lead to circularities: - Interest During Construction, - Debt Sculpting, and - Debt Service Reserve Account - Commitment Fee (e...
Breaking Down Circular References in Project Finance - 00 Introduction
Просмотров 5329 месяцев назад
Breaking Down Circular References in Project Finance - 00 Introduction
Breaking Down Circular References in Project Finance - 02 Debt Sculpting
Просмотров 1,1 тыс.9 месяцев назад
Breaking Down Circular References in Project Finance - 02 Debt Sculpting
Breaking Down Circular References in Project Finance - 04 Bringing all together
Просмотров 4859 месяцев назад
Welcome to our 🌐 Breaking Down Circular References in Project Finance Model Series! 📊 In this series, I'll guide you through the best practices of handling circular references in project finance models. 🔄 🏗️ Dive deep into the three core project finance structures that lead to circularities: - Interest During Construction, - Debt Sculpting, and - Debt Service Reserve Account - Commitment Fee (e...
Breaking Down Circular References in Project Finance - 01 IDC (Interest During Construction)
Просмотров 1,6 тыс.9 месяцев назад
Welcome to our 🌐 Breaking Down Circular References in Project Finance Model Series! 📊 In this series, I'll guide you through the best practices of handling circular references in project finance models. 🔄 🏗️ Dive deep into the three core project finance structures that lead to circularities: - Interest During Construction, - Debt Sculpting, and - Debt Service Reserve Account - Commitment Fee (e...
TAX EQUITY Financial Model for US Based Projects
Просмотров 17610 месяцев назад
TAX EQUITY Financial Model for US Based Projects
Excel Case Interview - Financial Modeling - Renewable Energy 02/02
Просмотров 1,3 тыс.Год назад
Excel Case Interview - Financial Modeling - Renewable Energy 02/02
Excel Case Interview - Financial Modeling - Renewable Energy 01/02
Просмотров 4,6 тыс.Год назад
Excel Case Interview - Financial Modeling - Renewable Energy 01/02
The 2023 Guide to Financial Modeling for Renewable Projects - 10 - Carry Forward Tax Loss
Просмотров 1,7 тыс.Год назад
The 2023 Guide to Financial Modeling for Renewable Projects - 10 - Carry Forward Tax Loss
The 2023 Guide to Financial Modeling for Renewable Projects - 09 - LCOE & LPPA Calculation
Просмотров 2,4 тыс.Год назад
The 2023 Guide to Financial Modeling for Renewable Projects - 09 - LCOE & LPPA Calculation
The 2023 Guide to Financial Modeling for Renewable Projects - 08 Project & Equity Returns
Просмотров 2,5 тыс.Год назад
The 2023 Guide to Financial Modeling for Renewable Projects - 08 Project & Equity Returns
The 2023 Guide to Financial Modeling for Renewable Projects - 07 Tax & Depreciation
Просмотров 2,5 тыс.Год назад
The 2023 Guide to Financial Modeling for Renewable Projects - 07 Tax & Depreciation
The 2023 Guide to Financial Modeling for Renewable Projects - 06 Debt Modeling
Просмотров 3,6 тыс.Год назад
The 2023 Guide to Financial Modeling for Renewable Projects - 06 Debt Modeling
MACRS Depreciation Schedule - How to CALCULATE it in Excel!
Просмотров 927Год назад
MACRS Depreciation Schedule - How to CALCULATE it in Excel!
Annuity Debt Schedule | How to PROPERLY do it in Excel!
Просмотров 320Год назад
Annuity Debt Schedule | How to PROPERLY do it in Excel!
Reducing Balace Depreciation
Просмотров 117Год назад
Reducing Balace Depreciation
Fixed Principal Debt Schedule | How to PROPERLY do it in Excel!
Просмотров 436Год назад
Fixed Principal Debt Schedule | How to PROPERLY do it in Excel!
Depreciation Schedule - How to CALCULATE it in Excel!
Просмотров 236Год назад
Depreciation Schedule - How to CALCULATE it in Excel!
How to Create you OWN Break-Even Point Formula in Excel
Просмотров 205Год назад
How to Create you OWN Break-Even Point Formula in Excel

Комментарии

  • @camilaortizsuarez1273
    @camilaortizsuarez1273 4 дня назад

    Thank you!! Great video, very useful and clear. I have a question, what happens when you have a negative cashflow to equity? in the first period of operation there is a negative cashflow to equity of EUR 183,000, so it turns positive when you change the sign for the distributions line, does it make sense?

  • @ruwanhettiarachchi6980
    @ruwanhettiarachchi6980 13 дней назад

    Many of video watched get idea.. only your video have explain .. Thank you ..

  • @camilaortizsuarez1273
    @camilaortizsuarez1273 15 дней назад

    When you calculate the cost (ungeared), shouldn't you take the equity line but only 60% of the upfront fee amount and debt closing costs? since equity line already includes 40% of this costs, I think the amount is included twice

  • @camilaortizsuarez1273
    @camilaortizsuarez1273 15 дней назад

    Thank you! very clear

  • @camilaortizsuarez1273
    @camilaortizsuarez1273 16 дней назад

    When the taxable income is negative does it make sense to have positive tax payable?

  • @camilaortizsuarez1273
    @camilaortizsuarez1273 16 дней назад

    I have a question, when you changed the depreciation time to 5 years the Taxable Income became negative in the first 5 years so the Tax Payable becomes positive and that also contributes with the increase of IRR, even though the total amount of tax payable doesn't change in the 15 yeras, does it make sense to have tax payable positive?

  • @truthfulguidance1452
    @truthfulguidance1452 18 дней назад

    Hey man, thanks for this. Can you incorporate BESS into this template? Would energy arbitrage or time-variant energy prices make a difference in terms of PPA calculation if we do incorporate it? for example, if its a fixed PPA at 6 cents/kWh, I believe the energy arbitrage would be a single value which would the delta of buying and selling prices, can you kindly complete this model into the file since I have finished the series with you? Much appreciated! M.K

    • @bankrun2023
      @bankrun2023 18 дней назад

      Thank you so much for watching the series. I am planning to start a new series where I will go through every and each step to build a fully fledge financial model with BESS. I am just a busy lately, with no free time to record and edit!

    • @truthfulguidance1452
      @truthfulguidance1452 17 дней назад

      @@bankrun2023 Kindly do it. We will be eagerly waiting :). I believe you had made a BESS and PV model from before but just without the tax and other financial details which would be the ideal case. Do you have any templates that have PV + BESS (optional) we can use to secure funding from banks?

  • @parquevillalonquejar8549
    @parquevillalonquejar8549 18 дней назад

    Impresionante, me ha encantado, wonderfull. Many thanks

  • @pipstersapprenticeshipprog6309
    @pipstersapprenticeshipprog6309 19 дней назад

    Question on the tax depreciation. What is this for? I don't see it being connected to the three statements.

    • @bankrun2023
      @bankrun2023 18 дней назад

      I have a full series on depreciation. I recommend you watch it! ruclips.net/p/PLlW0IhpkW9AcB9v6_u2PAnMfmPzQRSNi0

    • @pipstersapprenticeshipprog6309
      @pipstersapprenticeshipprog6309 17 дней назад

      @@bankrun2023 Thanks will do!

  • @truthfulguidance1452
    @truthfulguidance1452 21 день назад

    Hi, Thanks for the video. In 13:10 you calculated LCOE (geared) wrong. It should be costs (geared)/production (geared). But, when you correct it, the LCOE (geared) is higher than the LCOE ungeared) which also doesnt make sense. Is it possible to have this answer? Why is geared LCOE always lower than the ungeared?

    • @bankrun2023
      @bankrun2023 20 дней назад

      Hi, Thank you for your question. The calculation is correct.The reason why the LCOE geared is higher than the ungeared is because the LCOE geared also has the cost of debt included on it. Usually, you should not calculate LCOE geared, and the only reason why I used it in this example is because I wanted to compare the LCOE vs LPPA. Let me know if you have more questions. Best, BankRun

    • @truthfulguidance1452
      @truthfulguidance1452 18 дней назад

      @@bankrun2023 Thanks, Bankrun. When you say the "calculation is correct', you are referring that your calculation or my correction? Also, when changing my interval period to be more than 1 quarter I am getting a "DIV" error in the cells because the construction period is contained in the 6 months so it reads FALSE which wont count the CAPEX. For reference, what I have as inputs for interval between periods = 2 quarters and construction period = 1 quarter. In other words, the model want to have construction period to always be higher than interval between period which is not robust. How can we solve this?

    • @truthfulguidance1452
      @truthfulguidance1452 18 дней назад

      @@bankrun2023 Another question, I am trying to incorporate a degradation rate for the battery and PV production, how can I go about this?

    • @bankrun2023
      @bankrun2023 18 дней назад

      @@truthfulguidance1452 My calculation should be correct. the LCOE geared is greater than the LCOE ungeared because for the LCOE geared you have to add the financial cost (interest expense). I can't help you with the error without seeing the model.

    • @bankrun2023
      @bankrun2023 18 дней назад

      @@truthfulguidance1452 The calculation for the degradation is almost the same as for the calculation for escalation, where the generation from the previous period will be multiplied by (1-degradation %).

  • @truthfulguidance1452
    @truthfulguidance1452 22 дня назад

    This is good man! Gracias!

  • @musabalfarsi9191
    @musabalfarsi9191 24 дня назад

    Thank you alot for your efforts, I think there is a mistake in the calculations of the Cost (geared), only the interest payment should be counted, not the whole debt repayment. Could you please advise

    • @bankrun2023
      @bankrun2023 24 дня назад

      Can you let me know in which row do you think the mistake is? In principle it should be correct as both the interest expense and debt repayment are costs that will impact the cash flow of the project. BR, BankRun

    • @musabalfarsi9191
      @musabalfarsi9191 24 дня назад

      @@bankrun2023 I am sorry; the mistake is mine. The principal payment should be included; I meant in the calculations of LCOE. However, I believe the NPV calculations should not count the CAPEX in unleveraged and Equity in leveraged as we should not discount it. Let me know your thoughts

    • @bankrun2023
      @bankrun2023 24 дня назад

      @@musabalfarsi9191 In a nutshell, I am of the opinion that the LCOE should only be used for unlevered projects, but I have used LCOEs on levered calculations and I have seen these calculation in other models. Principal payment should not be part of the cost. For the NPV calculations, you should NPV everything according to your timeline. Eventually what happens is that you have an early model, where all your capex falls into period 0 and then you do not NPV your CAPEX because it is at period 0. But this is a simplification. If I recall correctly, all cash flows in this video are calculated at 31-DEC-2022.

  • @ivan.klykov
    @ivan.klykov 25 дней назад

    Actually IDC on an opening balance without Fees require additional 30-50 lines of calculations for pro rata and equity first funding timing (without circularity), the main problem is commitment fees that are also could be algebraically calculated, but it requires about 300 lines:)

  • @ivan.klykov
    @ivan.klykov 25 дней назад

    In order to avoid circularity you have to use only operating income tax (EBIT * Income Tax Rate) for CFADS.

    • @bankrun2023
      @bankrun2023 25 дней назад

      I agreed with your first comment, bit I disagree with this one. Calculating the CFADS based out of the EBIT is a simplification. This is because the CFADS determines the Debt Size, and Debt Size determines interest expense. And interest expense changes your EBT, which changes your tax payable. Because you change your tax payable, you also change the cash flow of the projects and therefore your CFADS. In this video (ruclips.net/video/gVliFCP8xHs/видео.html) I did use this shortcut.. but it is a simplification.

    • @ivan.klykov
      @ivan.klykov 24 дня назад

      @@bankrun2023 I would definitely argue with that :) I believe that the problem of CFADS and circularity has a psychological origin mostly, as probably long time ago some analysts invented it showing - as it seemed to them - to their superiors obvious and beautiful figures inside financial statements that were somehow prepared beforehand. So that’s an issue of mixing direct and indirect counting. And in future financial modellers started to copy this approach that led to circularity in Excel. But what actually happens in reality? When you use direct counting: First, you should count everything before Debt and interest. As I mentioned above, maximum you could get to is EBIT (you do not know your interest yet). If we try to implement algebraic approach, tax impact could be defined in the following way: all positive cashflows include tax inside (let’s say income tax rate is 30%), so every positive cash flow generates extra 30% of tax liabilities and every cash outflow and depreciation generates extra 30% of tax asset. Very similar approach to how VAT is calculated. If we would like to calculate everything before debt and interest probably we will get a tax liability (that equals EBIT multiplied by 30%). As debt service includes interest and principal, we have to confirm that these two cash outflows have different features. Interest generates extra tax shield (assets) and principal does not. So the most issues are connected with interest as it generates more CFADS only if there is a Tax Liability before Debt payments. And if there is a Tax Asset, Interest does not lead to reduction of tax payments in this period. So I suggest to use EBIT in the beginning and call it “Opening CFADS” and after Debt and Interest is calculated, you can add a tax reductions due to the interest back and calculate Closing CFADS for the period. Besides the problem of taxation makes circular issue more complicated as due to NOL transferring from period to period modeling becomes a pain - as it restores periodic dependency. And it seems to me that CFADS as a financial item was invented in order to structure debt only on the basis of cash flows before debt of every current period without the influence of anything that happens in other periods:) But we can make a suggestion that we will not have any periodic loss in our model (i.e. in every modeling period net income is to be generated), so you can use very simple trick - just multiply interest rate on a tax shield (1 - tax rate), and you will get the same result (as the circularity does).

  • @ismaelthiombiano3596
    @ismaelthiombiano3596 25 дней назад

    Hello ! How did you calcultate the 29 million TBH of land costs for project A? Mine comes to 0,27

    • @bankrun2023
      @bankrun2023 24 дня назад

      Hi, It is very difficult for me to provide a feedback on your questions as I do not know what you did. I would recommend you to either watch the video again and check the formulas or go to the website and purchase the final version of the document. Best.

    • @danielofomi4872
      @danielofomi4872 24 дня назад

      @@ismaelthiombiano3596 if you go to the input tab, you will see the calculation as land area per MW × land cost per square meter x capacity of project a / million.

  • @rizelibergma
    @rizelibergma 28 дней назад

    Adam ctrl c ctrl v yaptı

  • @sarahgibson492
    @sarahgibson492 Месяц назад

    Hi there, I downloaded the excel file "Excel Real Case - Tax Loss Carry Forward - Start" but the file does not appear to correspond to the file shown in the video. Where is the video for the particular excel? Thanks in advance.

  • @noname-ug2qx
    @noname-ug2qx Месяц назад

    Color formatting is not working. I also clicked "apply" but nothing happens to TRUE/FALSE cells.

  • @hamraouiaziz1573
    @hamraouiaziz1573 Месяц назад

    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

    • @bankrun2023
      @bankrun2023 24 дня назад

      Well.. This is a good question and there is an argument for not discounting the generation. I have also seen calculations that use different discount rates for the Generation and for the Costs. When you calculate the NPV of generation, you are annualizing it, or considering that electricity generated today is more valuable than electricity generated 10 or 20 years in time. However, it might very well be the opposite, that the electricity in 10 years time will be more valuable than today. The most important thing to me is that you know what you are calculating and when you can use LCOE. LCOE is very useful to either compare the cost of the same technology over time or to compare the same project using different technologies (for example: a 100 MW site in a given location). Using the LCOE to other purposes is not really useful in my opinion. Best

  • @danielofomi4872
    @danielofomi4872 Месяц назад

    Thank you again for another insightful walk through. Took me a while to get through, but happy to have finished it. You are the best.

  • @shaniaho6193
    @shaniaho6193 Месяц назад

    Hi, Thanks for the video, but for the cashflow to the project why is capex added twice? it is already accounted for in cashflow after funding

  • @noname-ug2qx
    @noname-ug2qx Месяц назад

    Formatting @23.27 doesn't work with me.

    • @noname-ug2qx
      @noname-ug2qx Месяц назад

      Same with me. It doesn't work

    • @bankrun2023
      @bankrun2023 24 дня назад

      The problem may be fixed if you watch the video @22.47. This is a bit trick of a formatting context and you need to follow each step carefully, particularly when choosing the "Rule Type"

  • @ZipperZbieracz
    @ZipperZbieracz Месяц назад

    The discord invite is invalid

    • @bankrun2023
      @bankrun2023 Месяц назад

      Thank you for letting me know. The one below should be working: discord.gg/jU7DCtqsS3

  • @ZipperZbieracz
    @ZipperZbieracz Месяц назад

    Incredible amount of practical knowledge packed in 40 minutes. Just one thing: in 25:27 if would be "easier" to use MATCH rather than scenario_picker+1, since then we don't have to fiddle with that +1 value which can easily pass through inspection and make the calculations wrong, and MATCH is quite universal.

    • @bankrun2023
      @bankrun2023 24 дня назад

      You are absolutely right! I am pretty sure I used Match for the scenario manager in other situations... Not really sure why I did not use the Match at this case. A valide comment is that I most often record the video as if it is the first time I am doing it, without looking at the final version of the model.

  • @stoniferraz4103
    @stoniferraz4103 Месяц назад

    We can consider payment of O&M, Land Leasing and Insurance during the construction phase?

    • @bankrun2023
      @bankrun2023 Месяц назад

      If these are costs that your project will incur during the construction phase, then it should be added in the CAPEX Sheet. Very unlikely to have O&M costs though in this phase of the project.

  • @stoniferraz4103
    @stoniferraz4103 Месяц назад

    At my project, the LCOE geared become bigger than the ungeared. What the meaning of this to the project?

    • @bankrun2023
      @bankrun2023 Месяц назад

      This is mostly likely because you are adding financing costs into the LCOE geared.

  • @oumaymakharbouch1213
    @oumaymakharbouch1213 Месяц назад

    Thanks ! Very clear. But I notice that the gearing level has increased over the periods. How to manage to calculate the IDC with the Gearing constraint be respected ?

  • @danielofomi4872
    @danielofomi4872 2 месяца назад

    Awesome lesson and walk through, really transforming

  • @getempowered
    @getempowered 2 месяца назад

    Hello sir, I'm an aspiring tech entrepreneur in the energy sector. I would like to have a chat with you sir on learning the finance aspects of renewable energy systems. May I know how to get in contact with you? (WhatsApp, LinkedIn, email etc)

    • @bankrun2023
      @bankrun2023 2 месяца назад

      There are two ways you can go about it: though the Discord community where I share more information and have deeper discussions with viewers and students (discord.gg/wUbJPJpr) or with 101 classes. For this you can email me at info@bankruntemplates.com

  • @stanwilson1189
    @stanwilson1189 2 месяца назад

    Thnaks if you are using differnt discounts for LPA specifically the levered and unleverd how could they be the same

  • @stanwilson1189
    @stanwilson1189 2 месяца назад

    Thanks for the video my only question is while there is operating cashflow during the construction period there is still interest payable you need to take that in to account by way extra equity or indeed capitalising the interest. Thoughts please Thanks

    • @bankrun2023
      @bankrun2023 2 месяца назад

      Hi @starnwilson, could you email me your questions? I am not really sure if I understood them. Email me at info@bankruntemplates.com

  • @stanwilson1189
    @stanwilson1189 2 месяца назад

    Hi why during constrcution period is there no interest paid

    • @bankrun2023
      @bankrun2023 2 месяца назад

      The assumption is that on a project finance structure, the project does not generate revenue, reason why there is no interest payment during the construction.

    • @stanwilson1189
      @stanwilson1189 2 месяца назад

      @@bankrun2023 yes i know that but you still have to fund the interest doing the constrcution period or have you assumed that there is equity covering the cost or is the interest capitalised

  • @n3komata
    @n3komata 2 месяца назад

    Hi Bank Run, great video. I just wanted to check something when you calculate interest per period. If the interest is being compounded on a monthly basis, would dividing the interest rate by 4 understate the interest accrued for that quarter? Thanks!

    • @bankrun2023
      @bankrun2023 2 месяца назад

      Hi. This is a good question and I plan to do a video on this topic. If you are interested in digging on it by yourself, just google "nominal vs real interest rates".

  • @abdulazizs2978
    @abdulazizs2978 2 месяца назад

    thanks for the video. Could you update your video with the current version?

    • @bankrun2023
      @bankrun2023 2 месяца назад

      I will make another video to check out if Chat GTP has improved! :)

  • @Simthjohnson-z5o
    @Simthjohnson-z5o 3 месяца назад

    This project finance modeling test walkthrough video is incredibly informative and educational. It’s truly a one-of-a-kind resource. The clarity and depth of the content are impressive, and I’ve learned so much from it. I especially appreciate your conceptual modeling and spreadsheet engineering, particularly how you mapped Project B from Project A and then merged them together for synergistic benefits. I really hope this channel continues to grow and reach more people who can benefit from such high-quality tutorials. Keep up the fantastic work!

  • @samsmith3961
    @samsmith3961 3 месяца назад

    @4:40 where is anyone supposed to get the information and template of the "calculation sheet"

    • @bankrun2023
      @bankrun2023 2 месяца назад

      I haven't shared that. But I am preparing a 2024 series where I will make it available.

  • @sophiax6788
    @sophiax6788 3 месяца назад

    Hi can you do a tax equity financial model tutorials building from scratch?

    • @bankrun2023
      @bankrun2023 3 месяца назад

      I can do it, the problem is that it would take too many hours. It is quite complex and very few people would follow all the away through.

  • @fishyy5758
    @fishyy5758 3 месяца назад

    Hey! It would be good if you don't change the main inputs halfway through the guide or at least mention in the following video that key inputs were altered.

    • @bankrun2023
      @bankrun2023 3 месяца назад

      Hi, can you please send me an email to info@bankrutemplates.com to let me know where the discrepancy is? I will take a look into it and if there is an error, I will forward to you the final version of the model and add a note to the video. Thank you.

  • @riyabiswas6303
    @riyabiswas6303 4 месяца назад

    Hi,could you mention the approximate inputs for which county have you taken.

  • @Osowoaji
    @Osowoaji 4 месяца назад

    Do you have an LCOE model for a biomass plant where the OPEX includes fuel cost?

    • @bankrun2023
      @bankrun2023 4 месяца назад

      I do not. But the only thing you need to add is a new row with the fuel cost.

    • @Osowoaji
      @Osowoaji 4 месяца назад

      @@bankrun2023 Thanks. How do you model for possible price variations in the fuel costs?

    • @bankrun2023
      @bankrun2023 4 месяца назад

      @@Osowoaji If you want to measure the change of fuel costs over time, you need to adapt your inputs to account for it. If on the other hand you want to check the different LCOEs for different fuel costs, you would need to do a sensitivity analysis.

    • @Osowoaji
      @Osowoaji 4 месяца назад

      @@bankrun2023 Thank you for your reply. Would it be possible to do a video for a biomass plant with fuel cost, including a sensitivity analysis?

  • @AlvaroNavarro-ym7uq
    @AlvaroNavarro-ym7uq 4 месяца назад

    Did you forget the Depreciation element in the cash flow analysis?

    • @bankrun2023
      @bankrun2023 4 месяца назад

      Depreciation should not be part of the cash flow calculations because it is a non-cash expense.

  • @flaviohns1
    @flaviohns1 4 месяца назад

    ótimo vídeo, você é brasileiro?

    • @bankrun2023
      @bankrun2023 4 месяца назад

      Obrigado! Sou sim.

    • @flaviohns1
      @flaviohns1 4 месяца назад

      @@bankrun2023 que legal, trabalha com project finance aqui no Brasil?

  • @hnqp1
    @hnqp1 4 месяца назад

    Great sharing. Thank you so much

    • @bankrun2023
      @bankrun2023 4 месяца назад

      Thank you for watching!

  • @Chatik08
    @Chatik08 4 месяца назад

    I loved this video, thank you very much for taking the time to make it, I really appreciate. Keep it up!!

    • @bankrun2023
      @bankrun2023 4 месяца назад

      Thank you! I am now preparing a new series which should be ready in a month!

  • @Bongobondhu2
    @Bongobondhu2 4 месяца назад

    Thank you for this. Very clear examples.

  • @AnastasiiaSaprykina-uk5ez
    @AnastasiiaSaprykina-uk5ez 5 месяцев назад

    hi, thank you for the complete guidance for financial models. I've followed you all 10 videos and the explanation was very clear

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

      Thank you so much. I'm now working on a more detailed project finance series. I hope I can start releasing it during July.

  • @eo33746
    @eo33746 5 месяцев назад

    Great video. Thanks!

  • @SineadODriscoll
    @SineadODriscoll 5 месяцев назад

    Hi there, I have a question around the NPV of the hydrogen production amount. Is the NPV not used to discount back cash flows to present value? Just wondering how it applies to a non-cash related figure (in this case hydrogen production in KGs)? Thanks very much!

    • @babane7833
      @babane7833 3 месяца назад

      yes you are correct. He made a mistake. The total amount of h2 produced should be calculated by SUM and not with the NPV. Resulting in 255.000.000 kgH2

  • @AnastasiiaSaprykina-uk5ez
    @AnastasiiaSaprykina-uk5ez 5 месяцев назад

    Hi, thank you for the informative videos. It would be nice if you can highlight in description all differences with lection No.4 (Populating the calculation sheet). Examples: (i) the flow was calculated based on incorrect amount of years of financial model (probably), your total land lease in lecture No.4 was 175,000, meaning 175,000/20,000=8,75 years instead of 30. And this mistake is everywhere, less revenue, less opex etc. Sanity check would be also useful on each step. (ii) sign of Funding was corrected. I was following you by doing the same in excel, in this lecture No.6 I see that amount of years is corrected and my numbers (EBITDA 40M instead of 13M) are matching with yours. Thank you

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

      Hi, Thank you for your feedback. Would you be able to forward me your excel file so I can check the points you raised on your comments? Could you email it to info@bankruntemplates.com? Best, BRT