Financial modeling
Financial modeling
  • Видео 75
  • Просмотров 738 096
Modeling Interest During Construction Roll Up - Project Finance
This is a lesson from the Financial Modeling for Mining course where we show how to model interest during construction roll-up (sometimes referred to as IDC capitalization, erroneously). This is a situation where interest on a construction loan is not paid during construction and instead is added to the principal to be paid when the project starts commercial operations.
Click the below link to check out the details:
www.financialmodelonline.com/p/financial-modeling-for-mining
The course focuses on:
1) how to model the mining operations including mining ore, stockpiling, and processing
2) how to incorporate tax and accounting of mining operations into the financial model (asset retirement oblig...
Просмотров: 1 659

Видео

Renewable Energy Project - Energy Production Due Diligence
Просмотров 2,5 тыс.9 месяцев назад
#financialmodeling #projectfinance #renewableenergy #M&A This is a lesson from the financial modeling course "Financial Modeling for Renewable Energy M&A " www.financialmodelonline.com/... Financial Modeling for Renewable Energy M&A course will give you the skills to develop and analyze financial models for M&A transactions. The course covers essential topics including M&A transaction analysis,...
Renewable Energy Project Due Diligence - Revenue (PPA)
Просмотров 7 тыс.Год назад
#financialmodeling #projectfinance #renewableenergy #M&A This is a lesson from the financial modeling course "Financial Modeling for Renewable Energy M&A " www.financialmodelonline.com/... Financial Modeling for Renewable Energy M&A course will give you the skills to develop and analyze financial models for M&A transactions. The course covers essential topics including M&A transaction analysis,...
Deal Premiums in M&A - Financial Modeling for Renewable Energy M&A
Просмотров 1,6 тыс.Год назад
#financialmodeling #projectfinance #renewableenergy #M&A This is a lesson from the financial modeling course "Financial Modeling for Renewable Energy M&A " www.financialmodelonline.com/p/m-a-modeling-for-renewable-energy Financial Modeling for Renewable Energy M&A course will give you the skills to develop and analyze financial models for M&A transactions. The course covers essential topics inc...
Introduction to Financial Modeling for Renewable Energy M&A Course
Просмотров 3,4 тыс.Год назад
#financialmodeling #projectfinance #renewableenergy #M&A This is a lesson from the upcoming financial modeling course "Financial Modeling for Renewable Energy M&A " www.financialmodelonline.com/p/m-a-modeling-for-renewable-energy Financial Modeling for Renewable Energy M&A course will give you the skills to develop and analyze financial models for M&A transactions. The course covers essential t...
M&A Deal Synergies
Просмотров 3,2 тыс.Год назад
#financialmodeling #investmentbanking #accoutning This is the lesson from the upcoming course - Financial Modeling for Renewable Energy M&A, where we review the M&A deal synergies. www.financialmodelonline.com/
M&A Deal Analysis
Просмотров 7 тыс.Год назад
#financialmodeling #investmentbanking #accoutning This is the lesson from the upcoming course - Financial Modeling for Renewable Energy M&A, where we review the M&A deal analysis process. www.financialmodelonline.com/
M&A Process
Просмотров 7 тыс.2 года назад
#financialmodeling #investmentbanking #accoutning This is the lesson from the upcoming course - Financial Modeling for Renewable Energy M&A, where we review the typical M&A process. www.financialmodelonline.com/
Why Do Companies Pursue M&A?
Просмотров 1,8 тыс.2 года назад
#financialmodeling #investmentbanking #accoutning This is the lesson from the upcoming course - Financial Modeling for Renewable Energy M&A, where we rationale behind the mergers and acquisitions transactions. www.financialmodelonline.com/
Stock-Based Compensation - Accounting for Financial Modeling
Просмотров 7 тыс.2 года назад
#financialmodeling #investmentbanking #accoutning This is the lesson from the Accounting for Financial Modeling course, where we review the basics of stock-based compensation. Click the below link to check out our existing courses: www.financialmodelonline.com/ This course is about understanding the practical side of the complex accounting for public and private companies. In this course, we st...
Deferred Revenue - - Accounting for Financial Modeling
Просмотров 2,7 тыс.2 года назад
#financialmodeling #investmentbanking #accoutning This is the lesson from the upcoming course - Accounting for Financial Modeling, where we review the deferred revenue liability. www.financialmodelonline.com/
Introduction to Accounting for Debt - - Accounting for Financial Modeling
Просмотров 1,7 тыс.2 года назад
#financialmodeling #investmentbanking #accoutning This is the lesson from the upcoming course - Accounting for Financial Modeling, where we review the basics of cash flow statements. www.financialmodelonline.com/
How to Model Equity Bridge Loan - Mining Project Finance
Просмотров 3,2 тыс.2 года назад
#financialmodeling #mining #projectfinance This is a lesson from the Financial Modeling for Mining course where we review modeling the equity bridge loan. Click the below link to check out details: www.financialmodelonline.com/p/financial-modeling-for-mining The course focuses on: 1) how to model the mining operations including mining ore, stockpiling, and processing 2) how to incorporate tax a...
Cash Flow Statement - Accounting for Financial Modeling
Просмотров 1,3 тыс.2 года назад
#financialmodeling #investmentbanking #accoutning This is the lesson from the upcoming course - Accounting for Financial Modeling, where we review the basics of cash flow statements. www.financialmodelonline.com/
Introduction to Goodwill - - Accounting for Financial Modeling
Просмотров 3,2 тыс.2 года назад
#financialmodeling #investmentbanking #accoutning This is the lesson from the upcoming course - Accounting for Financial Modeling, where we review the basics of accounting for Goodwill. Goodwill will further be reviewed in detail when we cover consolidation accounting methods. www.financialmodelonline.com/
What is Equity on the Balance Sheet? - Accounting for Financial Modeling
Просмотров 1,2 тыс.2 года назад
What is Equity on the Balance Sheet? - Accounting for Financial Modeling
Creating Scenarios To Negotiate a Better Deal Structure 2 - Financial Modeling for Tax Equity
Просмотров 9172 года назад
Creating Scenarios To Negotiate a Better Deal Structure 2 - Financial Modeling for Tax Equity
Creating Scenarios To Negotiate a Better Deal Structure 1 - Financial Modeling for Tax Equity
Просмотров 1,4 тыс.2 года назад
Creating Scenarios To Negotiate a Better Deal Structure 1 - Financial Modeling for Tax Equity
Introduction to Balance Sheet - and Why It Has to Balance!
Просмотров 2,3 тыс.2 года назад
Introduction to Balance Sheet - and Why It Has to Balance!
P- value, Probability and Excel in Renewable Energy
Просмотров 7 тыс.2 года назад
P- value, Probability and Excel in Renewable Energy
Project Finance in Mining
Просмотров 4,8 тыс.3 года назад
Project Finance in Mining
Modeling Investment Tax Credit for Solar Projects in US (Tax Equity)
Просмотров 5 тыс.3 года назад
Modeling Investment Tax Credit for Solar Projects in US (Tax Equity)
EPCM in Project Finance? - Financial Modeling for Mining
Просмотров 8 тыс.3 года назад
EPCM in Project Finance? - Financial Modeling for Mining
Modeling Production Tax Credit for Wind Projects in US (Tax Equity)
Просмотров 2,9 тыс.3 года назад
Modeling Production Tax Credit for Wind Projects in US (Tax Equity)
Wind and Solar Energy Generation - Financial Modeling for Renewable Energy
Просмотров 7 тыс.3 года назад
Wind and Solar Energy Generation - Financial Modeling for Renewable Energy
Mining Project Consideration - Financial Modeling For Mining
Просмотров 1,9 тыс.3 года назад
Mining Project Consideration - Financial Modeling For Mining
Interest Rate Hedging in Project Finance Modeling
Просмотров 5 тыс.3 года назад
Interest Rate Hedging in Project Finance Modeling
Mini-Perm Loan in Project Finance - Financial Modeling for Mining
Просмотров 3,3 тыс.3 года назад
Mini-Perm Loan in Project Finance - Financial Modeling for Mining
Cash Flow Waterfall in Project Finance Structures - Financial Modeling for Mining
Просмотров 7 тыс.3 года назад
Cash Flow Waterfall in Project Finance Structures - Financial Modeling for Mining
Introduction to Financial Modeling for Mining Course
Просмотров 2,8 тыс.3 года назад
Introduction to Financial Modeling for Mining Course

Комментарии

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

    5:45. All payments indexed to US Dollar. The reason and consequences would be appreciated!

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

    THIS IS SO COMPREHENSIVE!!!

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

    It seems there is a missing video, as this is lesson 2. I cannot find lesson 1

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

    Excellent video, very well explained and informative. Greetings from Italy 🇮🇹

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

    Frankly speaking, your way of speaking is very boring and very transactional. I couldn't understand anything in this video.

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

    we model our tax equity cash flows pre debt to size the debt, then flip the te and debt flows in the water fall.

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

    How does the flip occur? In the partnership agreement?

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

      the agreement between the sponsor and the investor will give the sponsor a call option and the investor a put option. the options can be excercised after x time and/or certain hurdles being met. one party just calls the other and says i want to exercise my option.

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

      @@Jupiter1423 That's helpful, I appreciate it, but I mean more of the documents; where is the flip outlined in the legal documents, I am assuming within the partnership agreement, is that right?

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

      @@chuckerp2 yes...its where the put & call options are

  • @好-p5u
    @好-p5u 2 месяца назад

    Blogger, please tell me how to join your group.

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

    How does one purchase these PowerPoint slides?

  • @AngelSnow-x1f
    @AngelSnow-x1f 2 месяца назад

    Videos are indeed helpful, but some of the material is always lost by adding video cards with 15-20 seconds of content still showing.

  • @judyl.7811
    @judyl.7811 3 месяца назад

    1:55 sources of equity: 1. financial: look for financial returns, diversification, and tax benefits (as google has a lot tax payable) 2. industrial: expertise. i.e. energy company 3. government: welfares benefits. 2:30 sources of debt: 1. commercial banks: largest and most experienced. 2. bonds: subject to market sentiment: rating as this is one of the cost. 3. export credit agencies: invest in emerging markets. political assurance. export financing. 4. multilateral financial institutions: development bank etc. preferred crediter status can support exchange currency and political assurance. 4:05 loan types: 1. construction loans: covering the construction cost of the project 2. term loan: take-out or refinance the construction loan. this is made upon project completion. as construction period is the riskiest period of the project finance, they take the most restrictive covenants and highest interest rate. 3. RCF, revolving credit facilities: subordinated debt to cover unexpected short-term cash flow problem. 4:50 commercial bank loans: syndication or loan sales. in syndication: each bank will have a direct contract with borrower in loan sale: only lead bank has the contract

  • @judyl.7811
    @judyl.7811 3 месяца назад

    1:00 when the financing is closed and construction stage starts. 1:10 EPC contractor designs and project procures necessary. 1:35 O&M contractor takes over. 1:45 the project enters the decommission stage. 2:50 construction stage with pre-completion risks include: 1. delay risk: lenders cannot get paid accordingly in debt repayment schedule. the buyer cannot get the agreed project output. the suppliers cannot sell the product as per agreed schedule. (EPC contractor will pay the penalties each day it violates.) 4:00 2. completion risk: completion guarantees by EPC contractor. (guarantee by a bank) 3. performance risk: EPC contractor. the project has to perform as least as good as specified in the EPC contract. otherwise, it cannot produce the planned output and planned cash flow. 3:10 project finance is a highly structured transaction.each small mistake may generate a million loss. 5:10 post-completion risks: operations: 1. revenue: take or pay contract with off-taker 2. supply: put or pay contracts with supplier 3. operation: performance penalties to O&M contractor 8:45 post-completion risks: macroeconomic & political risks 1. inflation: price escalation pass through to buyer 2. exchange rate: hedging, government conpensation 3. change of law expropriation: government guarantee, EXIM agency insurance.

  • @judyl.7811
    @judyl.7811 3 месяца назад

    0:40 SPV, special purpose vehicle: is being ring-fenced. i.e. own bank account, own board of directors, own financial report, own accounting. 0:55 SPV will raise the debt financing from the lender and equity financing from the sponsor. the lender will take the SPV asset as security and this may include equipment, processing plant, and mining licenses. 1:10 once the mining project is operational and generating cash flow, it will repay the interest and principal to the lender. and the remaining cash flow will go to the sponsor in the form of dividends. if the generated cash flow is not sufficient, then the lender cannot go after the SPV. this is non-recourse. 2:00 factors of project finance in mining company 1. project economics: attractive projects with high project IRR, internal rate of return 2. long mine life: long reserve tail after debt repayment reduces project's risk. this can be a cushion against deficient debt repayment. 2:50 how liquid the commodity is the mine will product (precious and base metals vs. rare earth metals) the former can be traded easily. 3:50 availability of offtake and hedging agreements. 4:00 project riskiness and availability of risk mitigation mechanism will drive lender's decision to lend. 4:25 limited recourse model: - often, lending is done on limited recourse basis to mining companies. - lenders require the sponsor to provide limited guaranties. 1. guarantee loan repayment if the contruction completion is never achieved. 2. provide performance guarantees, if performance is worse than agreed. 3. provide equity support to cover cost overrun 超過 4. a full recourse to the sponsor during the construction phase. 5:50 Why SPV? 1. ring fencing provides limited recourse for project sponsor 2. ring fencing provides limited liability for project sponsor.

  • @judyl.7811
    @judyl.7811 3 месяца назад

    7:00 debt size = PV, present value of debt service 8:45 interest rate determines the debt size for the project. the lower the risk, the lower the DSCR interest rate. and higher the debt size. tenor also determines the debt size. the longer the tenor, the higher the debt size is.

  • @judyl.7811
    @judyl.7811 3 месяца назад

    0:35 with installed capacity of 440 MW, megawatt which was built under BOO, Build Own Operate concession agreement. power purchase agreement, PPA life: 25 years. Total Project Cost: over 800 million attracted debt financing of 510 million on non-recourse basis. (which is 75%) construction date: December 1996 operations date: January 2000 1:10 philipines power plant development landscape: 4:50 PPA offtaker: structure: take or pay payment structure: capacity, O&M, energy fees, payment indexation: US dollar annual revenue 1st year: 6:25 EPCM contract Contractor: Contract structure: Guarantees: completion date & performance. 6:50 O&M contract, operation & management contract: 7:30 coal supply contract: coal suppliers: structure: put or pay guarantees: financial guarantees. 8:20 currency and country risk: exchange rate: PPA denominated in US$ country risk: EXIM Bank insurance political & economic landscape: improving debt rating: upgrading 9:35 turn-key EPC project.

  • @judyl.7811
    @judyl.7811 3 месяца назад

    0:20 capex is financed through term loan. as a construction debt. equity is from project sponsor. 1:15 RCF in project finance and corporate finance is different. in corporate finance it is senior debt, while in project finance, this is based on the loan agreement. this is stand-by facility. and for general operating purpose. this would be called upon through either emergency capital investment or significant fluctuation in working capital 1:40 make project company, SPV, bankruptcy-remote. for a project that also issues bonds to public market, it may also require credit rating.

  • @judyl.7811
    @judyl.7811 3 месяца назад

    1:45 for an equity investor cash inflows: stock dividends and redemptions. cash outflows: investment 2:25 CAPM is for listed company or stock exchanges. 2:40 Risk-free rate: rate of the long-term treasury yield 3:15 hurdle rate: the minimum rate of return of a project or investment. they are derived from industry rule of thumb. extensively used in private equity and infrastructure investment. 3:45 NPV = Cash flow* Discount factor. 4:40 IRR is also used extensively in project finance and private equity. IRR is a discount rate at which net present value of the project is zero: IRR 是專案淨現值為零時的折現率。

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

    Instead of considering 100 as opening balance for all years, each year's closing Balance should be calculated by deducting interest of each year calculated on respective year's opening balance.. this would be more prudent..

  • @MohamedSalah-le8mt
    @MohamedSalah-le8mt 3 месяца назад

    How can we get this sheet ?

  • @nitinsahu-zp3bv
    @nitinsahu-zp3bv 4 месяца назад

    Sir can i get a certificate after complete this course or not

  • @AnjaliPayneeandy-k1b
    @AnjaliPayneeandy-k1b 5 месяцев назад

    Thank you. C'est top

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

    @financialmodeling1899 Hello there I would like to extend an invitation for a strategic discussion focused on optimizing your Udemy course to effectively attract and enroll a larger cohort of students, positive reviews with real and active student I don't know if might be available for a brief call @YAGI TEAM W.W

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

    Hi, pls advice how can I get fully details excel module for each step...thanks for info.

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

    A very high quality content, thank you very much! Always disappointed on a low volume of likes and views on such videos.

  • @DrakeKratos1
    @DrakeKratos1 6 месяцев назад

    In the end you just show that you change between scenario 1 and 2. I don't see you configuring the financing methods, so I'm wondering about the scope of this video.

  • @kenamedo
    @kenamedo 6 месяцев назад

    great excellent summary

  • @lemphotsenthebe1935
    @lemphotsenthebe1935 6 месяцев назад

    After attending your online classes do we get certificates f completion?

  • @lifeofpettit389
    @lifeofpettit389 7 месяцев назад

    Question: is this only possible through tax credits from renewable energy?

    • @financialmodeling1899
      @financialmodeling1899 7 месяцев назад

      real estate, other where is there is tax credits

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

      not all renewable energy. must serve a certain purpose ie no itc to use solar to heat your pool.

  • @kidkid123123123
    @kidkid123123123 7 месяцев назад

    Very clear Thanks

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

    I still have a hard time understanding what a revolver is

    • @bokilo12
      @bokilo12 7 месяцев назад

      This is specific amount of money kept in a seperte account which the borrower can borrow, paybacjkqnd reborrow t for emergencies

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

    what is sovereign guarantee?

  • @venkatkrishna7943
    @venkatkrishna7943 10 месяцев назад

    Isn’t EPCM contract is similar to Designbuild contract where the employer employes consultant to monitor the contractor activities.

  • @ranno2264
    @ranno2264 10 месяцев назад

    Is project finance different from finance modelling?

  • @tsionfiseha8724
    @tsionfiseha8724 10 месяцев назад

    Thank you so much for this video, found it very helpful! Would you please recommend a book that elaborate about renewable PPA structuring and pricing? Thanks in advance

  • @rush4050
    @rush4050 10 месяцев назад

    Awesome!

  • @gezikolik5886
    @gezikolik5886 10 месяцев назад

    can you send me your excel table?

  • @gezikolik5886
    @gezikolik5886 10 месяцев назад

    hi teacher, IRR (PV of dividends is 49 so project's NPV İS -

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

    Wait why does the balance sheet have to balance again?

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

      I was just struggling and i THINK i have figured it out. I think a balance sheet is only to see what you are spending money on right? So you are buying something but you need a way to get that money and the balance sheet just shows where you got the money from. Take for example you buy a car. The car costs 10,000 which means you need something to pay to pay for the car whether that be from debt or from your own money . So on your balance sheet you would write expense 10k and write where you financed that 10k from. LMK if ur still confused cus i was confused about this for a solid 2 days!

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

    Dear Friends, I have a question: Will a company achieve financial synergies when it creates many companies or buys many other companies? Thank you

  • @basketballeko588
    @basketballeko588 Год назад

    Hello, 4:07 minutes into the video you said something that i need more clarity on; can lenders go after the assets of the SPV in case it fails to service the debts i.e., can they sell of the SPV assets to recover the debt?

  • @jordansage9655
    @jordansage9655 Год назад

    yield based flip.

  • @ummadivenkat8393
    @ummadivenkat8393 Год назад

    What about project closure or failure settlement structure. Is it like debt> equity> company or something else?

  • @BhromonBhomra
    @BhromonBhomra Год назад

    I have a doubt , please solve this. I understand the circularity of debt sizing, but for CFADS, we start with revenues for which we require tariff charges for a 4 part tariff structure (suppose). Now for the capital cost recovery charge rate we need to goal seek the rate such that the equity IRR meets the target IRR. So essentially we need CFADS for arriving at the capital recovery charge rate which in turn is again determing the CFADS and hence the circularity. Also this CFADS is being used in the debt sizing equation. So which to size first debt or tariff?

  • @Cbasd
    @Cbasd Год назад

    This was great!

  • @j.michaelkafes4684
    @j.michaelkafes4684 Год назад

    If equity returns are generally low, then wouldn't the interest rate (especially in this rising rate environment) on the loan eat away into that low return and make the project uneconomical?

  • @tushar5beloshe
    @tushar5beloshe Год назад

    Hi, This is really helpful for quick understanding of Probability of Generation. Thank you

  • @VadimSyomik
    @VadimSyomik Год назад

    Your class is great. Any chance you can share the Excel?

  • @henryp1806
    @henryp1806 Год назад

    😊 'promosm'

  • @MechLab3D
    @MechLab3D Год назад

    ruclips.net/video/AgeoiBZMlVM/видео.html

  • @vedantvnevatia6761
    @vedantvnevatia6761 Год назад

    Thank you ! Your videos were really helpful !