- 62
- 47 328
Matthew Bernath
South Africa
เข้าร่วมเมื่อ 3 ม.ค. 2019
The Financial Modelling Podcast is where you can find the latest trends in financial modelling with your host, Matthew Bernath.
In the show, we interview a wide range of guests from traders to financiers, model experts, advisers, auditors, engineers and visionaries to see how financial modelling fits into the global economy. We also investigate the future of financial modelling, and how it could be disrupted by AI and automation. Learn how financial models impact companies and deals, and how they are used to understand complex transactions.
In the show, we interview a wide range of guests from traders to financiers, model experts, advisers, auditors, engineers and visionaries to see how financial modelling fits into the global economy. We also investigate the future of financial modelling, and how it could be disrupted by AI and automation. Learn how financial models impact companies and deals, and how they are used to understand complex transactions.
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
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
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 - 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
Thanks Mat!
I adore Oz's storytelling techniques and his advice about having fun and enjoying the creative process.
Excellent session !
Gosh, I can’t believe this was two years ago already 😲😲
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.
'Promo sm'
hello matthew, can i get this template? how to i get this template, do i should subscribe first?
Hi Matthew, great video ! I have a internship in project finance (focus Highways) starting in september. Would you have ressources to advise ? Thanks
Great video 👍
Thank you! Going to pick this up
quite informative!
Great overview thanks Matthew!
Gratitude for this overview
hi pls share
This book seems intense!
This is interesting. Thank you
no excel file? then useless.
Hi, the model is available on the Operis website.
Hello, how can we I get hold of the excel document discussed on this video?
Excellent video. Thank you!
Great discussion. Thanks guys!
Its one of the Book in my Wishlist..!! Looking forward to grab and read it.!! Great Matthew Bernath..!!
Hope you enjoy it!
Nice! Most South African businesses run of excel. This book can empower analysts to automate
Absolutely!
do you have the link to the model please
Thank you!
Good interview! Thanks for having me on Matthew.
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?
I will be uploading this shortly - stay tuned!
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 :)
@Vihaan Walter Yup, have been watching on InstaFlixxer for since november myself :)
Dear sir, where I can download this model
From the Operis website: www.operis.com/ppp-operating-modelling-template/
@@matthewbernath2917 can you post link please
@@matthewbernath2917 if possible can you send me e-mail this model.. chintanmba2019@gmail.com
@@chintzd6851 Hi Chintz - has he sent you the model? I have tried to access it but link is broken
@@akask6458 Go to Operis website -> Modelling -> PPP Operating template (end of page) -> fill personal information (email) -> receive email -> click "Accept" in excel.
Hi Matthew, Thanks you very much for this helpfull video. Could you help with the link to part 3 containing a reallife sample
These videos make me change the way I view life.
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)?
The "stocls button does not show up on my Data tab at all.
It may be due to the version of Excel you are using.
Indeed a great feature introduced by Excel, thanks for sharing!
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!
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.
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.
Download link does not work
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!
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?
Please include the blog article link in your video description 🙏