Free Resources Our Free Resources include videos, blogs, how-tos, webinar recordings and course samples. We are regularly adding new content so check back often or subscribe to stay in touch. Join our Mailing List Search Categories Course Sample Debt concepts Excel Functions FAQ Finance 101 How To Model demos Modeling Best Practice News Opinión Opinion Other concepts Pivotal180 In Conversation Sin categorizar Webinar All AllBlogCourse SampleNewsOpinionOther ResourcesWebinar Course Sample Why do capacity payments exist (Spanish) Overview Los participantes en nuestro curso de modelización financiera de proyectos de energía renovable construirán desde cero un modelo financiero de proyectos de energía renovable y aprenderán los términos clave… Course Sample What is project finance (Spanish) Overview Los participantes en nuestro curso de modelización financiera de proyectos de energía renovable construirán desde cero un modelo financiero de proyectos de energía renovable y aprenderán los términos clave… Course Sample Tax Equity Modeling: Model Familiarization Tax Equity Modeling Model Familiarization This is a video from our tax equity modeling course. Video Video Transcript Dan Welcome to the course. Before modeling, it’s nice to know where… Course Sample Tax equity s704b capital accounts Tax Equity C704b Overview This is an extract from our tax equity modeling course. Video Video Transcript We’ll use our sample project to demonstrate 704b tax capital accounts with disproportionate… Course Sample Bullet, Balloon, & Mini-Perm Repayments This is an extract from our renewable energy and infrastructure project finance modeling course. If you have taken one of Pivotal180’s project finance courses, you probably understand why Debt… Webinar CBEY Sensitivities and Scenarios Webinar VOD Missed it live? Feel free to watch the recorded video of our Sensitivities and Scenarios webinar! Watch this video on YouTube Transcript Good morning. Welcome to the webinar. I am… Course Sample Why do capacity payments exist Why do capacity payments exist Para ver el video con subtítulos y una transcripción en español, haga clic aquí. Pivotal180 is excited to share a Spanish subtitled extract from our… Opinion You Need to Know How to Build a Financial Model Looking back on how useful Financial Modelling really is In Haydn’s blog he rued what he did not know about financial modelling for project finance when he first started. For… Opinion Managing a financial modeler? Here is some advice You’ve just become a decent financial modeler, and then it’s over! You become responsible for other modelers, perhaps even needing to hire a team. Whether you have been a financial… Course Sample Best Practice: Flags and Conditional Formats in Financial Models Overview This lesson on Flags and Conditional Formats is an extract from our pre-course videos for our Renewable Energy and Infrastructure Project Finance Modeling course. Video Video Transcript Haydn: Three… Course Sample Benefits of Leverage Overview Learn the real reason for debt in a transaction. In this extract from a Pivotal180 course, you will understand why equity returns increase with leverage. Video Video Transcript… Course Sample Net Present Value (NPV ) Overview This is an extract from our pre-course videos for our renewable energy and infrastructure project finance modeling course. Video Video Transcript Dan: In the demo file, you’ll recall that… Course Sample Present Value Math (PV) Overview This is an extract from our pre-course videos for our renewable energy and infrastructure project finance modeling course. Video Video Transcript Dan: Let’s consider the concept of present value…. Course Sample Date Functions and Timelines Overview This is an extract from our pre-course videos for our renewable energy and infrastructure project finance modeling course. Video Video Transcript Haydn: When setting up a financial model, one… Course Sample Control Accounts Overview This is an extract from our pre-course videos for our renewable energy and infrastructure project finance modeling course. This lesson will introduce you to control accounts and their benefits…. Course Sample Renewable energy modeling: Model Overview Overview This is an extract from our pre-course videos for our renewable energy and infrastructure project finance modeling course. Video Video Transcript So before we start modeling, it’s always nice… Course Sample LOOKUP Overview This is an extract from our pre-course videos for our renewable energy and infrastructure project finance modeling course. Video Video Transcript Haydn: The LOOKUP function covered in this lesson… Course Sample SUMIF Overview This is an extract from our pre-course videos for our renewable energy and infrastructure project finance modeling course. Video Video Transcript Haydn: Many models may include calculations on a… Other Resources Basic Excel: IF(OR) & IF(AND) for checking multiple conditions Overview This tutorial on how to use the IF(OR) & IF(AND) functions in Excel is an extract from our pre-course videos for our renewable energy and infrastructure project finance modeling… Opinion If Only I Knew! – Financial Modeling Lessons from a (slightly) grey-haired Project Finance Advisor. I love project finance. Maybe it’s the engineer in me, but the combination of a physical asset and a highly-structured and complex investment excites me. Add to that the importance… Course Sample Creating Scenarios in an Excel Financial Model Creating Scenarios in an Excel Financial Model Pivotal180 offers best in class financial modeling, transaction execution & project finance courses and training in renewable energy, infrastructure & tax equity. Advisory,… Other Resources Calculating the Loan Life Coverage Ratio (LLCR) The Loan Life Coverage Ratio (‘LLCR’) is perhaps the second most commonly used ratio in project finance. It is most often used to: Size the amount of debt the project… Opinion LIBOR’s expiry warning: your existing borrowing costs may rise! After 30-years of benchmark dominance, LIBOR will no longer be published by the end of 2021. What will happen to your loan? What can you do about it? The London… Opinion Real financial modeling is a waste of your time New students to project finance modeling commonly approach financial models with the same question: should I build my model in nominal or real terms? You may hope the $5… 1 2 3 4 5 6 7 8 Load More
