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 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… Course Sample Principles OVERVIEW Gain a quick overview of best practice financial modeling in this extract from a Pivotal180 course. Although in many ways obvious, these concepts are a useful reminder for experienced… Course Sample Debt Service Reserve Account (DSRA) Requirements This is a brief introduction to a Debt Service Reserve Account (DSRA). It is an extract from Pivotal180’s project finance courses: – Renewable Energy Project Finance Modeling – Infrastructure and Project Finance Modeling – Mining Project Finance Modeling If you work in project finance, this is a must-know concept! Course Sample Debt Service Coverage Ratio (DSCR) Sculpting DSCR Sculpting Overview In this extract from a Pivotal180 course, you will learn the concept of Debt Service Coverage Ratio (DSCR) sculpting. It is the most common form of project… Other Resources Calculating the Debt Service Coverage Ratio (DSCR) Overview The Debt Service Coverage Ratio (‘DSCR’) is the most commonly used ratio in project finance. It is most often used to: Size the amount of debt the project can… Other Resources 10 guiding principles for an effective financial model Overview Financial models are developed to assist with decision making. A model needs to accurately communicate a story to senior stakeholders, clarity is crucial for them and for your career!… 1 2 3 4 5 6 7 8 Load More
