Hi, thanks for this. One question: Should the debt in sources and uses instead be calculated as present value of (CFADS / DSCR) at all in rate of 4% instead of taking 75% of cost of project
Hi Bassem, when you are analysing the LCOE in real, the future flows of energy and the cost is done in real but the discount rate you just do WACC - inflation?
Hi bassem. Thanks for you explanation and the model, it is very helpful! I was wondering if there is a modeling template or any material regarding accelerated depreciation and taxes carryforward in the project finance context. Thanks a lot!
Hi Bassem, I have just purchased your model, and its a great tool for students like me. However, I noticed that in the levelised cost of energy calculation, you have written "NPV of Loan Payment Less Interest Tax Shield)", however in the calculation you have deducted "PV of Loan Payment Tax Shield" and not just Interest expense tax shield. Is this a typo, or am I missing something ? would appreciate feedback. Thank You !
Try this link, I think the whole website is Down. www.efinancialmodels.com/downloads/infrastructure-private-equity-wind-energy-modeling-test-solution-associate-level-280695/
Great model, thank you for your explanations ! Is there any touchy points regarding the forecasted balance sheet of such a project ? Is it even relevant for an investor ? I guess it is, to calculate ratios such as Loan to value
Hello Mathys in Project Finance a Balance sheet is not so important for an analysis purpose. But in my opinion its benefit is that it can quickly have you identify a mistake you make have in your model. In terms of debt sizing what is usually taken is cashflow ratios rather than bs ratios. But when the model gets complex and there are different tranches of debt then a balance sheet is crucial to identify in which periods excess cash is present to pay down more debt or sweep it.
Hi Bassem, To move from a Civil Engineer in Construction Industry to Infrastructure Investment Bank career. What certifications should I consider? Also please tell me if you have any other useful suggestions for me. I'd be very grateful. Thanks
I think maybe moving to consulting firm first then IB could be better. As consulting is seen in IB as a good way to learn the required skills. But going straight to IB may work I think if you invest a bit on some financial modeling skills. Go for the FMVA and the AMF. Prove your taking the extra mile to learn. You can also do the CFA, level one by it's self may show some commitment. Helps you understand all the bells and whistles for economics and accounting.
@@bassemmneimne Thanks a lot. That helps. I jus took a course in Accounting Fundamental which is a perquisite for FMVA. I think I will try and prove them that I am dead serious. Thank you once again
@@varunpandey2617 don't just do it with the prerequisites. Do it with getting the whole FMVA certificate. I finished it in 2 weeks rly it's no big deal
Super! Thank you so much Bassem
Hi, thanks for this. One question: Should the debt in sources and uses instead be calculated as present value of (CFADS / DSCR) at all in rate of 4% instead of taking 75% of cost of project
Hi Bassem. Just purchased the model. However, I would like to use it in ZAR(South African Rands). How do I go about making this change? Thanks.
Would need to change all the inputs to ZAR currency. Very straight forward
Hi Bassem, just curious, why did you include interest charge when calculating the tax shield for UFCF, is this specific for project finance?
Hi Bassem, when you are analysing the LCOE in real, the future flows of energy and the cost is done in real but the discount rate you just do WACC - inflation?
Hi bassem. Thanks for you explanation and the model, it is very helpful! I was wondering if there is a modeling template or any material regarding accelerated depreciation and taxes carryforward in the project finance context. Thanks a lot!
Hi Bassem,
I have just purchased your model, and its a great tool for students like me. However, I noticed that in the levelised cost of energy calculation, you have written "NPV of Loan Payment Less Interest Tax Shield)", however in the calculation you have deducted "PV of Loan Payment Tax Shield" and not just Interest expense tax shield. Is this a typo, or am I missing something ?
would appreciate feedback.
Thank You !
THANK YOU!
Hi Basseem, Please the link to download the model is not working. Please can you help?
Try this link, I think the whole website is Down.
www.efinancialmodels.com/downloads/infrastructure-private-equity-wind-energy-modeling-test-solution-associate-level-280695/
Hi Bassem, thanks for this. Do you have any examples of a toll Road model?
Unfortunately no I don’t have such but you can find something on efinancialmodels.com
Can u please share the excel model
Great model, thank you for your explanations ! Is there any touchy points regarding the forecasted balance sheet of such a project ? Is it even relevant for an investor ? I guess it is, to calculate ratios such as Loan to value
Hello Mathys in Project Finance a Balance sheet is not so important for an analysis purpose. But in my opinion its benefit is that it can quickly have you identify a mistake you make have in your model.
In terms of debt sizing what is usually taken is cashflow ratios rather than bs ratios. But when the model gets complex and there are different tranches of debt then a balance sheet is crucial to identify in which periods excess cash is present to pay down more debt or sweep it.
Hi Bassem, To move from a Civil Engineer in Construction Industry to Infrastructure Investment Bank career. What certifications should I consider? Also please tell me if you have any other useful suggestions for me. I'd be very grateful. Thanks
I think maybe moving to consulting firm first then IB could be better. As consulting is seen in IB as a good way to learn the required skills.
But going straight to IB may work I think if you invest a bit on some financial modeling skills. Go for the FMVA and the AMF. Prove your taking the extra mile to learn.
You can also do the CFA, level one by it's self may show some commitment. Helps you understand all the bells and whistles for economics and accounting.
@@bassemmneimne Thanks a lot. That helps. I jus took a course in Accounting Fundamental which is a perquisite for FMVA. I think I will try and prove them that I am dead serious. Thank you once again
@@varunpandey2617 don't just do it with the prerequisites. Do it with getting the whole FMVA certificate. I finished it in 2 weeks rly it's no big deal
@@bassemmneimne Sure, that is the idea. I will finish that as well. Could you tell me what is AMF? Sorry I have no clue
@@varunpandey2617 fminstitute.com/
It's for 30$