Matthew Bernath
Matthew Bernath
  • 62
  • 47 328
NPV & IRR: Essential Financial Modelling Metrics Explained
📊 NPV & IRR: Essential Financial Modelling Metrics Explained
Master the fundamentals of investment analysis with our comprehensive guide to Net Present Value (NPV) and Internal Rate of Return (IRR). Perfect for financial analysts, investors, and business professionals.
🔑 KEY TOPICS:
- Time Value of Money
- NPV Calculation
- IRR Analysis
- Investment Decision Making
💼 CONNECT WITH US:
Website: financialmodellingpodcast.com
LinkedIn: /FinancialModellingPodcast
Instagram: @FinancialModellingPodcast
#FinancialModelling #Investment #NPV #IRR #Finance #FinancialAnalysis
มุมมอง: 39

วีดีโอ

Debt Sculpting Explained: Optimise Project Finance Repayments with Financial Modelling
มุมมอง 942 หลายเดือนก่อน
In this video, we dive into debt sculpting-an essential technique in project finance. Learn how aligning debt repayments with project cash flows can improve financial sustainability and reduce risk. Whether you're working on infrastructure projects, renewable energy, or any large-scale project, debt sculpting ensures you can service your debt efficiently. 👉 Subscribe to the Financial Modelling ...
My Top 4 AI-Driven Excel Tricks You Need to Know!
มุมมอง 956 หลายเดือนก่อน
In today's video, I'm excited to share my top 4 AI-driven Excel tricks that will transform how you work with data. These powerful tips and techniques will help you harness the power of artificial intelligence to boost your productivity and make data analysis easier and more efficient. In this video, you'll discover: - How to leverage Excel's AI-driven data types to enrich your datasets effortle...
The Power of Visual Data Storytelling: Transforming Data into Actionable Insights
มุมมอง 1057 หลายเดือนก่อน
In this video, I dive into the world of visual data storytelling and explore how it transforms complex data into clear, compelling insights. In this video, I cover what visual data storytelling is and why it matters and some effective techniques for creating engaging and informative data visualisations. Connect with me: LinkedIn: www.linkedin.com/in/matthewbernath/ #datastorytelling #datavisual...
Debt Structuring in Project Finance
มุมมอง 641ปีที่แล้ว
Explore different debt structuring techniques used in project finance, such as senior debt, mezzanine debt, and subordinated debt and their impact on risk and returns. #ProjectFinance #infrastructureprojects #Infrastructurefinance #PPP #investmentbanking
Key Players in Project Finance Explained
มุมมอง 190ปีที่แล้ว
Project finance is a complex process that involves numerous players coming together to finance ambitious ventures. This video provides an overview of the key stakeholders involved.
Building a One-Page Smart Website with GPT: Intro to the Code| AI Magic Course
มุมมอง 82ปีที่แล้ว
🚀 Get started with our AI Magic Course: www.udemy.com/course/ai-magic-create-a-smart-website-in-one-hour-with-openai-gpt/ In this video, we briefly introduce the power of JavaScript, HTML, and CSS, and show you how they come together to create a one-page smart website powered by OpenAI's GPT. In this video, you'll learn: ✅ The basics of HTML, CSS, and JavaScript for web development Ready to tak...
Unleash the Power of OpenAI's GPT: A Brief Look at the API | AI Magic Course
มุมมอง 68ปีที่แล้ว
🔥 Dive into the world of AI with our AI Magic Course: www.udemy.com/course/ai-magic-create-a-smart-website-in-one-hour-with-openai-gpt/ This video explores the OpenAI API for GPT, the groundbreaking language model revolutionising how we interact with technology. Discover how you can harness the power of GPT to create innovative applications, automate processes, and much more. In this video, you...
Demystifying Debt Service Reserve Account Modelling Complexities
มุมมอง 354ปีที่แล้ว
In this video, we explore the complexities of modelling debt service reserve accounts (DSRA) and provide insights into navigating them effectively. A DSRA is a critical feature in many financing structures, acting as a buffer against default risk for lenders. However, the calculation and management of DSRA can be tricky, involving factors such as interest rates, drawdown schedules, and covenants.
Transform Your Website into an AI-Powered Masterpiece in Just One Hour with OpenAI's GPT
มุมมอง 95ปีที่แล้ว
This course on Udemy will teach you how to create a smart website in just one hour using the power of OpenAI's GPT. By the end of the course, you'll be equipped with the skills to create intelligent and personalised websites that will leave a lasting impression on your audience.
Mastering Financial Modelling: NPV, XNPV, IRR, and XIRR Explained
มุมมอง 1.9Kปีที่แล้ว
This video explores the key differences between four essential financial modelling formulas: NPV, XNPV, IRR, and XIRR. We explain how these formulas work, their benefits, and how they can help you create accurate financial models. Whether you're a financial analyst or someone looking to learn more about financial modelling, this video will give you a comprehensive understanding of these formula...
Understanding the Debt Service Coverage Ratio (DSCR) in Project Finance
มุมมอง 6502 ปีที่แล้ว
Are you new to Project Finance and struggling to understand the Debt Service Coverage Ratio (DSCR)? If so, you're not alone. The DSCR is a critical component of any project finance model, and mastering it is essential for success in the industry. In this informative video, we take a deep dive into the DSCR, explaining what it is, how to calculate it, and why it matters. Our expert presenter use...
The Ultimate Guide to Project Finance Ratios: DSCR, LLCR, and PLCR Explaine
มุมมอง 2.5K2 ปีที่แล้ว
If you're interested in Project Finance, you've probably heard about the Debt Service Coverage Ratio (DSCR), Loan Life Coverage Ratio (LLCR), and Project Life Coverage Ratio (PLCR). But how do these ratios work together, and why are they so crucial for financial modelling? In this must-watch video from the Financial Modelling Podcast, we explore these three key ratios in detail. Our expert pres...
Project Finance Overview - From Inception to Financial Close
มุมมอง 1.4K2 ปีที่แล้ว
Infrastructure Finance, or Project Finance, is more than just another form of investment banking. It's the lifeblood of our economy, financing critical projects that keep our roads, bridges, hospitals, and power stations running. If you're interested in this exciting and essential field, then our course is the perfect place to start. From project finance structures to risk mitigation, this cour...
Demystifying Debt Service Reserve Accounts in Project Finance Modelling
มุมมอง 1.5K2 ปีที่แล้ว
If you're working on a Project Finance model, you've likely come across the concept of a Debt Service Reserve Account (DSRA). But what exactly is a DSRA, and how do you model it effectively? In this video from the Financial Modelling Podcast, we explore the ins and outs of DSRA modelling. We explain what a DSRA is, how it works, and why it's so important for lenders and investors. You'll learn ...
FMP Season 4 Episode 18: Season 4 Finale - The State and Future of Excel
มุมมอง 1503 ปีที่แล้ว
FMP Season 4 Episode 18: Season 4 Finale - The State and Future of Excel
FMP Book Club - Becoming a Data Head
มุมมอง 1.2K3 ปีที่แล้ว
FMP Book Club - Becoming a Data Head
FMP Book Club - Python for Excel
มุมมอง 5443 ปีที่แล้ว
FMP Book Club - Python for Excel
Building an online training business with John Michaloudis
มุมมอง 923 ปีที่แล้ว
Building an online training business with John Michaloudis
Becoming a Digital Nomad with Roderick McKinley - Financial Modelling Podcast Season 4 Episode 15
มุมมอง 4613 ปีที่แล้ว
Becoming a Digital Nomad with Roderick McKinley - Financial Modelling Podcast Season 4 Episode 15
The Road to the Financial Modelling Summit
มุมมอง 1193 ปีที่แล้ว
The Road to the Financial Modelling Summit
Launch of the Financial Modelling Summit 2021
มุมมอง 1853 ปีที่แล้ว
Launch of the Financial Modelling Summit 2021
Catch up with Oz du Soleil at the Global Excel Summit 2021
มุมมอง 1843 ปีที่แล้ว
Catch up with Oz du Soleil at the Global Excel Summit 2021
Catch up with Danielle Stein Fairhurst at the Global Excel Summit
มุมมอง 713 ปีที่แล้ว
Catch up with Danielle Stein Fairhurst at the Global Excel Summit
Charging for your financial models with Robin Waite
มุมมอง 1873 ปีที่แล้ว
Charging for your financial models with Robin Waite
FMP Book Club - The Book for All Chief Data Analytics Officers!
มุมมอง 713 ปีที่แล้ว
FMP Book Club - The Book for All Chief Data Analytics Officers!
FMP Book Club: Storytelling with Data
มุมมอง 1.8K3 ปีที่แล้ว
FMP Book Club: Storytelling with Data
How do we value companies?
มุมมอง 1793 ปีที่แล้ว
How do we value companies?
FMP - Libraries for financial modellers
มุมมอง 3713 ปีที่แล้ว
FMP - Libraries for financial modellers
Defining your vision and purpose as a financial modeller
มุมมอง 793 ปีที่แล้ว
Defining your vision and purpose as a financial modeller

ความคิดเห็น

  • @Mr04241969
    @Mr04241969 2 หลายเดือนก่อน

    Thanks Mat!

  • @Catherine.Sheetcast
    @Catherine.Sheetcast 2 หลายเดือนก่อน

    I adore Oz's storytelling techniques and his advice about having fun and enjoying the creative process.

  • @salahhasan1365
    @salahhasan1365 ปีที่แล้ว

    Excellent session !

  • @RobinMWaite
    @RobinMWaite ปีที่แล้ว

    Gosh, I can’t believe this was two years ago already 😲😲

  • @guillermomorrison3846
    @guillermomorrison3846 ปีที่แล้ว

    Picked this book up a week ago. Started it today and I am more than half way complete. Chalk full of information and provides information for diving into greater detail into certain topics.

  • @berniebateman5889
    @berniebateman5889 ปีที่แล้ว

    'Promo sm'

  • @erwinvitrianudin7956
    @erwinvitrianudin7956 ปีที่แล้ว

    hello matthew, can i get this template? how to i get this template, do i should subscribe first?

  • @Paul-ul8lh
    @Paul-ul8lh ปีที่แล้ว

    Hi Matthew, great video ! I have a internship in project finance (focus Highways) starting in september. Would you have ressources to advise ? Thanks

  • @Paul-ul8lh
    @Paul-ul8lh ปีที่แล้ว

    Great video 👍

  • @Tim-again
    @Tim-again 2 ปีที่แล้ว

    Thank you! Going to pick this up

  • @rahulanilthapa3737
    @rahulanilthapa3737 2 ปีที่แล้ว

    quite informative!

  • @WebberJason
    @WebberJason 2 ปีที่แล้ว

    Great overview thanks Matthew!

  • @universehasourback
    @universehasourback 2 ปีที่แล้ว

    Gratitude for this overview

  • @jonnyfavela1011
    @jonnyfavela1011 2 ปีที่แล้ว

    hi pls share

  • @yelenasmetannikov9214
    @yelenasmetannikov9214 2 ปีที่แล้ว

    This book seems intense!

  • @Ossai.N
    @Ossai.N 2 ปีที่แล้ว

    This is interesting. Thank you

  • @mazharhussain8871
    @mazharhussain8871 2 ปีที่แล้ว

    no excel file? then useless.

    • @matthewbernath2917
      @matthewbernath2917 2 ปีที่แล้ว

      Hi, the model is available on the Operis website.

  • @analuisa_jacob
    @analuisa_jacob 2 ปีที่แล้ว

    Hello, how can we I get hold of the excel document discussed on this video?

  • @jibroniuk3604
    @jibroniuk3604 2 ปีที่แล้ว

    Excellent video. Thank you!

  • @excelrobot
    @excelrobot 3 ปีที่แล้ว

    Great discussion. Thanks guys!

  • @EFFICIENTCORPORATES
    @EFFICIENTCORPORATES 3 ปีที่แล้ว

    Its one of the Book in my Wishlist..!! Looking forward to grab and read it.!! Great Matthew Bernath..!!

  • @marcelcoetzee48
    @marcelcoetzee48 3 ปีที่แล้ว

    Nice! Most South African businesses run of excel. This book can empower analysts to automate

  • @akask6458
    @akask6458 3 ปีที่แล้ว

    do you have the link to the model please

  • @swatimaste1906
    @swatimaste1906 3 ปีที่แล้ว

    Thank you!

  • @OzduSoleilDATA
    @OzduSoleilDATA 3 ปีที่แล้ว

    Good interview! Thanks for having me on Matthew.

  • @andrewlim8177
    @andrewlim8177 3 ปีที่แล้ว

    Hi Matthew, you mentioned that you had a video on coverage ratios but I couldn’t find it on your list. Would you mind sharing the link?

    • @matthewbernath2917
      @matthewbernath2917 3 ปีที่แล้ว

      I will be uploading this shortly - stay tuned!

    • @vihaanwalter2350
      @vihaanwalter2350 3 ปีที่แล้ว

      you prolly dont give a shit but if you are bored like me during the covid times you can stream all the new movies and series on instaflixxer. I've been streaming with my brother for the last days :)

    • @mosesdominic9827
      @mosesdominic9827 3 ปีที่แล้ว

      @Vihaan Walter Yup, have been watching on InstaFlixxer for since november myself :)

  • @chintzd6851
    @chintzd6851 3 ปีที่แล้ว

    Dear sir, where I can download this model

    • @matthewbernath2917
      @matthewbernath2917 3 ปีที่แล้ว

      From the Operis website: www.operis.com/ppp-operating-modelling-template/

    • @chintzd6851
      @chintzd6851 3 ปีที่แล้ว

      @@matthewbernath2917 can you post link please

    • @chintzd6851
      @chintzd6851 3 ปีที่แล้ว

      @@matthewbernath2917 if possible can you send me e-mail this model.. chintanmba2019@gmail.com

    • @akask6458
      @akask6458 3 ปีที่แล้ว

      @@chintzd6851 Hi Chintz - has he sent you the model? I have tried to access it but link is broken

    • @СергейХ-п6к
      @СергейХ-п6к 2 ปีที่แล้ว

      @@akask6458 Go to Operis website -> Modelling -> PPP Operating template (end of page) -> fill personal information (email) -> receive email -> click "Accept" in excel.

  • @timoshenkoish
    @timoshenkoish 3 ปีที่แล้ว

    Hi Matthew, Thanks you very much for this helpfull video. Could you help with the link to part 3 containing a reallife sample

  • @positiveandhealthy2728
    @positiveandhealthy2728 3 ปีที่แล้ว

    These videos make me change the way I view life.

  • @dilanmaisuria8202
    @dilanmaisuria8202 3 ปีที่แล้ว

    Hi Matthew, could you please attach the link to part 3 (I can't seem to find it)? Also do you have a similar walkthrough for a transaction model (as opposed to an operating model)?

  • @weaponutjoe
    @weaponutjoe 3 ปีที่แล้ว

    The "stocls button does not show up on my Data tab at all.

    • @matthewbernath2917
      @matthewbernath2917 3 ปีที่แล้ว

      It may be due to the version of Excel you are using.

  • @rubenmartinezfanals3331
    @rubenmartinezfanals3331 3 ปีที่แล้ว

    Indeed a great feature introduced by Excel, thanks for sharing!

  • @Julie-zt3ib
    @Julie-zt3ib 4 ปีที่แล้ว

    STARTENGINE is the place to raise capital, avoid venture capitals in the early stages of your business and avoid debt. You have to check them out!

  • @kagisomokena7140
    @kagisomokena7140 4 ปีที่แล้ว

    Hi Matthew, thanks for this video, I would just like to know if you know of any best practices on how to quantify these risks. I'll give and example, say for example interest rate risk materialises, this is something that will affect your debt repayment, or maintenance risk materialises, this will affect your operating costs but is there a best practice way of determining how much the project company would be on the hook for if any of the risks materialise? Surely as the project company I need a way to assess whether it is worthwhile for me to spend any further money mitigating certain risks because other risks might be so immaterial that it does not make sense for me to spend money trying to mitigate them.

    • @matthewbernath2917
      @matthewbernath2917 4 ปีที่แล้ว

      Absolutely - this is where a well built financial model comes in. The model should be capable of running various risk scenarios to quantify this risk.

  • @westernvaluersandSurveyors
    @westernvaluersandSurveyors 4 ปีที่แล้ว

    Download link does not work

  • @matthewadegbile5838
    @matthewadegbile5838 4 ปีที่แล้ว

    Thank you for this great interview Matthew. I’m one who comes from a Real Estate finance background and I’m also a Machine Learning Engineer now. I would love to speak with Mr. Guy Zapori to get a full scope of career prospects for me. Please respond!

  • @FlipWithRick
    @FlipWithRick 5 ปีที่แล้ว

    Hey Matthew! Liked and Subbed for more of that great real estate content! I love the content quality! Can’t wait to see more! What market are you in?

  • @TyNeTho
    @TyNeTho 5 ปีที่แล้ว

    Please include the blog article link in your video description 🙏