Free ResourcesOur 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 CategoriesCourse SampleDebt conceptsExcel FunctionsFAQFinance 101How ToModel demosModeling Best PracticeNewsOpiniónOpinionOther conceptsPivotal180 In ConversationSin categorizarWebinar AllAllBlogCourse SampleNewsOpinionOther ResourcesWebinar Course SampleBest 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 SampleBenefits 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 SampleNet 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 SamplePresent 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 SampleDate 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 SampleControl 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 SampleRenewable 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 SampleLOOKUP 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 SampleSUMIF 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 ResourcesBasic 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… OpinionIf 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 SampleCreating 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 ResourcesCalculating 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… OpinionLIBOR’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… OpinionReal 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 SamplePrinciples 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 SampleDebt 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 ModelingIf you work in project finance, this is a must-know concept! Course SampleDebt 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 ResourcesCalculating 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 Resources10 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!… 12345678 Load More
