# The Financial Modelling Podcast

> Financial modelling, project finance, valuation and AI in finance, hosted by Matthew Bernath, CFA. The site publishes podcast episodes, long form articles, online courses and Excel tools and templates.

Author: Matthew Bernath, CFA. Financial modelling and project finance specialist, host of The Financial Modelling Podcast.
Canonical host: https://financialmodellingpodcast.com
Content licence: articles may be quoted with attribution and a link to the source page.

## Key pages
- [Home](https://financialmodellingpodcast.com/): overview of the podcast, articles, courses and tools.
- [Episodes](https://financialmodellingpodcast.com/episodes): podcast episodes on Spotify and YouTube.
- [Blog](https://financialmodellingpodcast.com/blog): 99 articles on modelling, project finance, valuation, Excel, Python and AI.
- [About](https://financialmodellingpodcast.com/about): Matthew Bernath's background, credentials and speaking.
- [Courses](https://financialmodellingpodcast.com/courses): online financial modelling and project finance courses.
- [Grey Beard tools](https://financialmodellingpodcast.com/grey-beards): Excel add ins, financial model templates and performance tools.
- [Contact](https://financialmodellingpodcast.com/contact): contact form.

## Feeds and machine readable sources
- [RSS feed](https://financialmodellingpodcast.com/rss.xml)
- [Sitemap](https://financialmodellingpodcast.com/sitemap.xml)
- [Full text of every article](https://financialmodellingpodcast.com/llms-full.txt)
- Plain markdown for any article: https://financialmodellingpodcast.com/llms/{slug}.md

## Topics
- [Coffee](https://financialmodellingpodcast.com/blog/category/coffee)
- [Data analytics](https://financialmodellingpodcast.com/blog/category/data-analytics)
- [Financial Modelling](https://financialmodellingpodcast.com/blog/category/financial-modelling)
- [Fintech](https://financialmodellingpodcast.com/blog/category/fintech)
- [M&A](https://financialmodellingpodcast.com/blog/category/manda)
- [Project Finance](https://financialmodellingpodcast.com/blog/category/project-finance)
- [Recommendations](https://financialmodellingpodcast.com/blog/category/recommendations)

## Articles
- [AI Ecosystem Explained](https://financialmodellingpodcast.com/blog/ai-ecosystem-explained) (2026-06-12, Data analytics, Financial Modelling, Fintech): From chips to cybersecurity, this post gives a breakdown of the seven layers powering the AI economy.
- [Financial Modelling with Claude](https://financialmodellingpodcast.com/blog/financial-modelling-with-claude) (2026-02-12, Data analytics, Financial Modelling, Fintech): A lot has changed since we first wrote about using Claude for financial modelling. Back then, it was a clever chatbot you could paste formulas into. Now it lives inside your spreadsheet. Here's what that means for your workflow.
- [Visualise Your Model: Introducing the Formula Map Tool](https://financialmodellingpodcast.com/blog/visualise-your-model-introducing-the-formula-map-tool) (2025-07-30, Data analytics, Financial Modelling, Fintech): The Formula Map Tool gives you a powerful visual overview of your Excel model. Instantly spot formulas, hardcodes, and complexity, making auditing, reviewing, and explaining your model faster and easier than ever.
- [Revolutionize Your Financial Models: Introducing the Grey Beards Excel Workbook Performance Analyzer](https://financialmodellingpodcast.com/blog/python-for-excel-supercharging-financial-modelling-copy) (2025-02-27, Data analytics, Financial Modelling, Fintech): In the world of financial modelling, time is money. Whether you're racing to prepare for a client meeting, finalizing quarterly projections, or updating valuation models, nothing derails productivity like a sluggish Excel workbook.
- [Python for Excel: Supercharging Financial Modelling](https://financialmodellingpodcast.com/blog/python-for-excel-supercharging-financial-modelling) (2025-02-17, Data analytics, Financial Modelling, Fintech): The integration of Python into Excel is a game-changer. Financial modellers can now combine the intuitiveness of Excel with the power of Python, making models more robust, scalable, and insightful.
- [Essential Tools for Financial Modelling Success](https://financialmodellingpodcast.com/blog/essential-tools-for-financial-modelling-success) (2025-02-16, Financial Modelling, Recommendations): My latest must-have products that can transform your financial modelling experience.
- [How Your Workspace Design Impacts Performance: The Psychology of Professional Environments](https://financialmodellingpodcast.com/blog/how-your-workspace-design-impacts-performance-the-psychology-of-professional-environments) (2025-01-17, Financial Modelling, Fintech): As we enter 2025, the optimization of professional workspaces becomes increasingly important. These wallpapers represent a thoughtful step toward creating an environment that supports peak financial performance.
- [5 Key Trends Shaping Project Finance in 2025](https://financialmodellingpodcast.com/blog/5-key-trends-shaping-project-finance-in-2025) (2025-01-14, Financial Modelling, Fintech): In 2025, the industry is undergoing significant changes driven by global trends and technological advancements. Here are the five key trends reshaping project finance.
- [Using Claude AI to Supercharge Your Excel Financial Modelling](https://financialmodellingpodcast.com/blog/using-claude-ai-to-supercharge-your-excel-financial-modelling) (2025-01-06, Financial Modelling, Fintech): As financial modellers, we're always looking for ways to streamline our workflow and reduce errors in our models. Enter Claude, an AI assistant that's proving to be a game-changer for Excel-based financial modelling.
- [Top Business Travel Must-Haves](https://financialmodellingpodcast.com/blog/top-business-travel-must-haves-for-the-modern-professional) (2024-12-23, Recommendations): Every item on this list makes business travel smoother, more organised, and less stressful.
- [Protecting Your Financial Models: Why and How to Implement Disclaimer Controls](https://financialmodellingpodcast.com/blog/protecting-your-financial-models-why-and-how-to-implement-nda-controls) (2024-12-03, Financial Modelling): As financial modelling becomes increasingly collaborative, protecting your intellectual property while maintaining usability is crucial.
- [How to Project Finance a Data Center](https://financialmodellingpodcast.com/blog/how-to-project-finance-a-data-center) (2024-11-22, Financial Modelling, Project Finance): The surge in data centre investments by tech giants like Microsoft, Amazon, Google, and Meta underscores just how central these facilities have become to the AI-driven future.
- [Productivity Tools Every Financial Modeller Needs](https://financialmodellingpodcast.com/blog/productivity-tools-every-financial-modeller-needs) (2024-11-22, Financial Modelling, Recommendations): Investing in the right tools can drastically improve your efficiency and comfort as a financial modeller.
- [How Data Centres are Financed: Financial Models for the Digital Backbone](https://financialmodellingpodcast.com/blog/how-data-centres-are-financed-financial-models-for-the-digital-backbone) (2024-11-06, Financial Modelling, Project Finance): The surge in data centre investments by tech giants like Microsoft, Amazon, Google, and Meta underscores just how central these facilities have become to the AI-driven future.
- [Understanding the Structure of a Project Finance Financial Model](https://financialmodellingpodcast.com/blog/understanding-the-structure-of-a-project-finance-financial-model) (2024-10-25, Financial Modelling, Project Finance): This article breaks down the key components of a project finance model and explains how they interconnect to create a comprehensive financial analysis tool.
- [Modelling Interest During Construction (IDC) in Project Finance](https://financialmodellingpodcast.com/blog/modelling-interest-during-construction-idc-in-project-finance) (2024-10-01, Financial Modelling, Project Finance): Accurately modelling Interest During Construction is a critical component of project finance.
- [Top 5 Must-Read Books for Aspiring Investment Bankers](https://financialmodellingpodcast.com/blog/top-5-must-read-books-for-aspiring-investment-bankers) (2024-08-18, Financial Modelling, Recommendations): These five books provide a comprehensive foundation for anyone aspiring to enter the world of investment banking.
- [My Top 5 Must-Read Books on Project Finance](https://financialmodellingpodcast.com/blog/my-top-5-must-read-books-on-project-finance) (2024-08-09, Financial Modelling, Project Finance, Recommendations): These five books are great resources for anyone looking to deepen their understanding of project finance.
- [Financial Modelling for Mergers and Acquisitions: A Practical Approach](https://financialmodellingpodcast.com/blog/financial-modelling-for-mergers-and-acquisitions-a-practical-approach) (2024-07-08, Financial Modelling, M&A): Building a financial model for M&A activities requires a detailed and systematic approach.
- [Navigating Legal Aspects in Project Finance](https://financialmodellingpodcast.com/blog/navigating-legal-aspects-in-project-finance) (2024-07-01, Financial Modelling, Project Finance): Understanding the legal framework and considerations is crucial for successfully executing any project finance initiative.
- [How to Effectively Present Financial Models to Stakeholders](https://financialmodellingpodcast.com/blog/present-financial-models-to-stakeholders) (2024-06-29, Financial Modelling): Effectively presenting a financial model to stakeholders is more than just showing your work—it's about telling a story they can understand and use.
- [How to Build a Robust Financial Model for Startups](https://financialmodellingpodcast.com/blog/financial-model-for-startups) (2024-06-26, Financial Modelling): Building a robust financial model for your startup is rigorous but rewarding. It provides clarity, prepares you for potential challenges, and helps communicate your vision to stakeholders.
- [Why Project Finance Uses Special Purpose Vehicles (SPVs)](https://financialmodellingpodcast.com/blog/special-purpose-vehicles-spvs) (2024-06-25, Project Finance): The strategic use of Special Purpose Vehicles in project finance is a testament to the need for sophisticated financial structures that offer security, efficiency, and flexibility.
- [Unlocking Global Trade: Export Credit Finance Explained](https://financialmodellingpodcast.com/blog/export-credit-finance) (2024-06-14, Project Finance): Export credit finance is a key enabler of global trade, providing the necessary support for companies to expand internationally while mitigating inherent risks.
- [Understanding the Cash Flow Waterfall in Project Finance](https://financialmodellingpodcast.com/blog/understanding-the-cash-flow-waterfall-in-project-finance) (2024-05-30, Financial Modelling, Project Finance): The cash flow waterfall is a fundamental concept in project finance that ensures every dollar of revenue is allocated in a way that supports the project's long-term success and stability.
- [Automating Excel Tasks with AI: Boosting Efficiency in Financial Modelling](https://financialmodellingpodcast.com/blog/automating-excel-tasks-with-ai-boosting-efficiency-in-financial-modelling) (2024-05-29, Financial Modelling): Incorporating AI into your Excel workflows can transform how you approach financial modelling. By automating repetitive tasks, you not only save time but also reduce the risk of human error and enhance the accuracy of your analyses.
- [The Role of Data in Strategic Dealmaking](https://financialmodellingpodcast.com/blog/role-of-data-in-strategic-dealmaking) (2024-05-17, Data analytics): A data-driven approach in dealmaking not only mitigates risks but also maximises value creation, paving the way for sustainable growth and successful outcomes. Embrace data to drive strategic deals and unlock new opportunities.
- [Exploring the Nuances of Valuation Financial Models](https://financialmodellingpodcast.com/blog/exploring-the-nuances-of-valuation-financial-models) (2024-05-08, Financial Modelling): Whether you're a seasoned finance professional or a newcomer to the field, mastering these valuation models is essential for making informed investment decisions and strategic business moves.
- [Monte Carlo Analysis in Financial Modelling](https://financialmodellingpodcast.com/blog/monte-carlo-simulations-finance) (2024-05-07, Financial Modelling): Monte Carlo Simulations involve using probability distributions to simulate the impact of risk and uncertainty in prediction models.
- [Investment Banking in the 1960s: A Look Back at a Transformative Decade](https://financialmodellingpodcast.com/blog/investment-banking-in-the-1960s) (2023-11-18, Financial Modelling): The 1960s was a transformative decade for the financial world. Investment banking was marked by developments that would shape the industry.
- [Harnessing the Power of Data in Project Finance](https://financialmodellingpodcast.com/blog/harnessing-the-power-of-data-in-project-finance) (2023-11-18, Data analytics, Financial Modelling, Project Finance): Alternative Data can enhance the bankability of project finance deals, enabling the development of critical infrastructure globally.
- [The Pivotal Role of Alternative Data in Hedge Fund Strategies](https://financialmodellingpodcast.com/blog/alternative-data-in-hedge-fund-strategies) (2023-11-07, Data analytics, Financial Modelling): One of the most significant transformations in recent years is the incorporation of alternative data into investment decision-making.
- [How to Achieve Your Visions by Making Your Life Strategy Actionable](https://financialmodellingpodcast.com/blog/how-to-achieve-your-visions) (2023-10-24, Recommendations): Investment banking plays a pivotal role in facilitating capital allocation, mergers, acquisitions, and many other financial transactions.
- [The Importance of Financial Modelling in Investment Banking](https://financialmodellingpodcast.com/blog/financial-modelling-in-investment-banking) (2023-10-13, Financial Modelling): Investment banking plays a pivotal role in facilitating capital allocation, mergers, acquisitions, and many other financial transactions.
- [Financial Close in Project Finance](https://financialmodellingpodcast.com/blog/financial-close-in-project-finance) (2023-09-06, Financial Modelling): Financial close is when all the financial agreements and commitments are formalised and the project is officially set in motion.
- [Decoding LBO Financial Models: A Deep Dive into Leveraged Buyouts](https://financialmodellingpodcast.com/blog/decoding-lbo-financial-models) (2023-08-24, Financial Modelling): Decoding LBO financial models - Learn how these models facilitate informed decision-making within leveraged buyouts.
- [Mastering Finance: 7 Essential Books for Financial Modelling and Investment Success](https://financialmodellingpodcast.com/blog/essential-books-for-financial-modelling-and-investment-success) (2023-08-08, Financial Modelling, Project Finance, Recommendations): Essential books for financial modelling, investment banking, infrastructure finance, project finance, and corporate finance.
- [Must-Have Financial Modelling Tools for Aspiring Analysts and Entrepreneurs](https://financialmodellingpodcast.com/blog/essential-financial-modelling-tools) (2023-08-08, Financial Modelling, Recommendations): Essential financial modelling tools available on Amazon that will boost your analytical prowess and help you stay ahead in the game.
- [Project Finance vs Traditional Financing](https://financialmodellingpodcast.com/blog/project-finance-vs-traditional-financing) (2023-08-07, Financial Modelling, Project Finance): Two prominent methods stand out for funding large-scale projects and business activities: project finance and traditional financing.
- [Key Players in Project Finance](https://financialmodellingpodcast.com/blog/key-players-in-project-finance) (2023-08-06, Financial Modelling, Project Finance): Project finance is a complex process that involves numerous players coming together to finance ambitious ventures.
- [Debt Structuring in Project Finance](https://financialmodellingpodcast.com/blog/debt-structuring-in-project-finance) (2023-08-03, Financial Modelling, Project Finance): Debt structuring is a critical aspect of project finance, serving as the backbone for funding large-scale infrastructure and development projects.
- [Harnessing AI in Investment Banking](https://financialmodellingpodcast.com/blog/ai-in-investment-banking) (2023-07-31, Data analytics, Fintech): AI in Project Finance: From streamlining legal agreements and advertising efforts to enhancing risk assessment and project evaluation.
- [Embracing AI in Project Finance](https://financialmodellingpodcast.com/blog/embracing-ai-in-project-finance) (2023-05-01, Data analytics, Fintech, Project Finance): AI in Project Finance: From streamlining legal agreements and advertising efforts to enhancing risk assessment and project evaluation.
- [Data Ecosystems: Privacy-Preserving Data Sharing for a Better Tomorrow](https://financialmodellingpodcast.com/blog/data-sharing-for-a-better-tomorrow) (2023-04-29, Data analytics): Data Sharing - A New Way of Business In the age of data-driven decision-making, the ability to securely and efficiently share data is critical to solving some of the world's most pressing problems. A recent focus in this
- [Excel Formulas for Financial Modellers](https://financialmodellingpodcast.com/blog/excel-formulas-for-financial-modellers) (2023-04-27, Financial Modelling): This post is about essential Excel formulas for financial modellers, suitable for both beginners and experienced professionals.
- [Financial Modelling Accreditation: 5 Reasons to get Accredited](https://financialmodellingpodcast.com/blog/5-reasons-for-financial-modelling-accreditation) (2023-04-19, Financial Modelling): The top 5 reasons why getting accredited as a financial modeller can boost your career, credibility, and expertise in financial modelling.
- [Sensitivity analysis is an essential financial modelling tool](https://financialmodellingpodcast.com/blog/sensitivity-analysis-important-financial-modelling) (2023-03-20, Financial Modelling): Sensitivity analysis is an important tool used in financial modeling to assess the impact of changes in key assumptions or inputs on the output of the model.
- [Creating AI-Powered One Page Websites with OpenAI ChatGPT](https://financialmodellingpodcast.com/blog/creating-ai-powered-one-page-websites-with-openai-gpt) (2023-03-08, Data analytics): Learn how to create a smart website with OpenAI GPT in one hour! The AI Magic course on Udemy will teach you how to integrate GPT technology to add natural language processing capabilities to your website.
- [The History of Financial Modelling](https://financialmodellingpodcast.com/blog/history-of-financial-modelling) (2023-03-03, Financial Modelling): Financial models are mostly built in Microsoft Excel due to its user-friendly interface, customization options, built-in functions, compatibility with other software, and wide acceptance in the financial industry. While other software...
- [Why is Microsoft Excel the Financial Modelling Tool?](https://financialmodellingpodcast.com/blog/why-financial-modelling-is-a-skill-everyone-should-know-copy) (2023-02-16, Financial Modelling): Financial models are mostly built in Microsoft Excel due to its user-friendly interface, customization options, built-in functions, compatibility with other software, and wide acceptance in the financial industry. While other software...
- [Data sharing responsibly can revolutionize industries](https://financialmodellingpodcast.com/blog/data-sharing-responsibly-can-revolutionize-industries) (2023-02-15, Financial Modelling): Data is a precious commodity that can be used to revolutionize various industries - sharing data expedites growth and innovation.
- [Why financial modelling is a skill everyone should know](https://financialmodellingpodcast.com/blog/learn-financial-modelling) (2023-02-10, Financial Modelling): Alternative Data can be used by any company, in any industry, to grow, better serve the environment and help entrepreneurs and students.
- [The Power of Data Ecosystems](https://financialmodellingpodcast.com/blog/power-of-data-ecosystems) (2023-02-05, Financial Modelling, Recommendations): Data sharing across organisations is a powerful tool that enables businesses and institutions to better understand and meet the needs of their customers and clients. Here are five reasons why data sharing is so powerful.
- [2023 Finance Book Recommendations](https://financialmodellingpodcast.com/blog/2023-finance-book-recommendations) (2023-02-02, Financial Modelling, Recommendations): When it comes to finance, there is no shortage of topics to explore. From basic personal finance to complex corporate investments, there is always something new to learn. For those who are looking to deepen their underst
- [2023 Financial Modelling Book Recommendations](https://financialmodellingpodcast.com/blog/5-tips-on-building-a-project-finance-financial-model-copy) (2023-01-30, Financial Modelling, Recommendations): Financial modelling is an essential skill for anyone in the finance industry, and there are countless books available that can help you improve your abilities. However, with so many options to choose from, it can be diff
- [5 Tips on Building a Project Finance Financial Model](https://financialmodellingpodcast.com/blog/5-tips-on-building-a-project-finance-financial-model) (2022-10-16, Financial Modelling, Project Finance): Project finance models are some of the most complex financial models out there. However, their usefulness can extend over many years of closing the deal, meeting financing requirements, and helping project owners optimis
- [How to Negotiate Using the Financial Model](https://financialmodellingpodcast.com/blog/how-to-negotiate-using-the-financial-model) (2022-09-30, Financial Modelling): I often say that if you understand the Financial Model, you understand the deal, business or whatever you're building a Financial Model for. That's because all the business logic is encapsulated in the Financial Model. B
- [Alternative Data – Beyond Finance](https://financialmodellingpodcast.com/blog/alternative-data-beyond-finance) (2022-05-29, Data analytics): Alternative Data can be used by any company, in any industry, to grow, better serve the environment and help entrepreneurs and students.
- [Data Analytics for Kids](https://financialmodellingpodcast.com/blog/analytics-for-kids) (2022-04-05, Recommendations): After my first post on Coding for Kids exploded in popularity, I decided to bring in some experts in the field and provide some more recommendations. My wife, a Paediatric Speech Language Therapist who specialises in ear
- [Gifts for Geeks](https://financialmodellingpodcast.com/blog/gifts-for-geeks) (2021-12-04, Recommendations): The holiday season is here! And what better way to celebrate the end of 2021 than with some geeky Christmas gifts? I've always been fairly geeky, proudly wearing my Linux t-shirt when I was 14 and thinking I was rebellin
- [AI Ethics and Data Analytics Governance](https://financialmodellingpodcast.com/blog/data-science-ai-ethics) (2021-11-27, Uncategorized): Data Governance vs. Model Governance and AI Ethics It's one thing having data governance, but we need governance across the whole data value chain - from data capturing to data use and presentation. I won't delve too muc
- [Analytics Across the Spectrum: Defensive to Offensive Analytics](https://financialmodellingpodcast.com/blog/analytics-across-the-spectrum-defensive-to-offensive-analytics) (2021-10-18, Data analytics, Fintech): Data Analytics Overview It is important to understand two major differences in terms used in the data analytics space. The first two terms are very commonly used, the second two are less commonly used in name, however, t
- [Alternative Data for Finance](https://financialmodellingpodcast.com/blog/alternative-data-for-finance) (2021-10-18, Data analytics, Fintech): What is Alternative Data? There has been a big move recently into examining Alternative Data. This term strikes me as odd, as it's pretty tricky to define. For example, suppose you own a grocery store and want to become 
- [How to start your own podcast, business or launch your personal brand](https://financialmodellingpodcast.com/blog/how-to-start-your-own-podcast-business-or-launch-your-personal-brand) (2021-09-05, Recommendations): I’ve been very fortunate to have experienced the thrills of entrepreneurialism a few times. I love nothing more than building a company up from the ground. The freedom of creativity, the excitement and the trepidation all come together...
- [Data Analytics Books Recommendations Part 2](https://financialmodellingpodcast.com/blog/analytics-book-recommendations-part2) (2021-08-23, Data analytics, Recommendations): Disclosure: Some of the links below are affiliate links, meaning, at no additional cost to you the Financial Modelling Podcast may earn a commission if you click through and make a purchase. Data Analytics Book Recommend
- [Why High-Frequency Analysis is the Future of Economic Forecasting](https://financialmodellingpodcast.com/blog/why-high-frequency-analysis-is-the-future-of-economic-forecasting) (2021-08-22, Data analytics, Financial Modelling, Fintech): Data analytics and AI depends on historical data to make predictions of the future. During COVID-19, the change in behaviour and increased frequency of global events was enough to overwhelm most models, even sophisticated AI models....
- [Must-Have Financial Modelling Office Accessories](https://financialmodellingpodcast.com/blog/financial-modelling-desk-accessories-must-haves) (2021-04-26, Financial Modelling, Recommendations): Optimise your work setup with these must-have financial modelling office accessories. From noise-cancelling headphones to keyboards!
- [Microsoft Excel Stock Types](https://financialmodellingpodcast.com/blog/microsoft-excel-stock-types) (2021-01-02, Data analytics, Financial Modelling): Microsoft Excel has introduced Stock Types. Learn what this means and how to use this to build financial models with stocks.
- [Coffee Book Recommendations](https://financialmodellingpodcast.com/blog/coffee-book-recommendations) (2020-12-07, Coffee, Recommendations): Coffee is a passion of mine! Here I share my favourite coffee books, telling the story of how coffee came to dominate our world and senses.
- [Financial Modelling Book Recommendations](https://financialmodellingpodcast.com/blog/financial-modelling-books) (2020-10-22, Financial Modelling, Recommendations): Financial modelling is such a vast field that it is almost impossible to know everything there is. Instead, many professionals, myself included, pick a field of specialty and focus there.
- [Data Analytics Books Recommendations Part 1](https://financialmodellingpodcast.com/blog/analytics-book-recommendations) (2020-10-19, Data analytics, Financial Modelling, Fintech, Recommendations): If there is one aspect of data analytics that I’ve realised in exceptionally important, it is the ability to tell a story with data.
- [Working from Home Essentials for the Financial Modeller](https://financialmodellingpodcast.com/blog/working-from-home-essentials) (2020-10-18, Coffee, Financial Modelling): Working from home is the new normal - here I list my essential working from home items to make your home your productivity paradise.
- [Data Analytics in Finance](https://financialmodellingpodcast.com/blog/data-analytics-in-finance) (2020-07-30, Fintech): Data Analytics in Finance Any Financial Modelling Podcast listener will know that data is a passion of mine. In the past few years, the finance world has woken up to the power of data - from hedge funds to traders. Citad
- [Analytics Zen - The Art of Mindful Analytics](https://financialmodellingpodcast.com/blog/analytics-zen-the-art-of-mindful-analytics) (2020-07-30, Data analytics): Analytics Zen - The Art of Mindful Analytics A while back while doing a presentation for some executives, I came across a methodology for creating presentations called Presentation Zen. While there are a number of princi
- [Online Financial Modelling Training](https://financialmodellingpodcast.com/blog/online-financial-modelling-training) (2020-03-25, Financial Modelling, Fintech): Online Financial Modelling Training I get numerous requests for online training - specifically on project finance modelling. As I’ve written about before, project finance modelling is one of the most complex forms of fin
- [Project Life Cover Ratio - PLCR](https://financialmodellingpodcast.com/blog/project-life-cover-ratio) (2020-02-05, Fintech): The PLCR, together with the DSCR and LLCR, provide a holistic view of a project's ability to repay and restructure its debt. Matthew Bernath Tweet The Key Project Finance Ratios In a Project Finance Model there are three
- [Project Finance Risks and Mitigants](https://financialmodellingpodcast.com/blog/project-finance-risks-and-mitigants) (2020-01-10, Fintech): Project Finance Risks and Mitigants Successful project financiers understand the risks involved in project finance and know how to successfully allocate them to the best parties capable of dealing with them. Full risk mi
- [Knowing the Difference - Governing AI](https://financialmodellingpodcast.com/blog/artificial-intelligence-governance) (2019-11-17, Fintech): Knowing the Difference*: Artificial Intelligence Governance *This article is based on a Fortune magazine article I read recently and highlights the need for Artificial Intelligence Governance. Headlines have been blaming
- [Arixcel Explorer: Add-in for Microsoft Excel](https://financialmodellingpodcast.com/blog/arixcel-explorer-add-in-for-microsoft-excel) (2019-08-31, Uncategorized): Arixcel Explorer: Add-in for Microsoft Excel Why use Excel Add-Ins? If you have listened to one of my podcasts, you may have heard me wonder why more Excel users aren’t using Excel add-ins. To me, this is the equivalent 
- [What is a Debt Service Reserve Account?](https://financialmodellingpodcast.com/blog/what-is-a-debt-service-reserve-account) (2019-08-31, Financial Modelling): What is a Debt Service Reserve Account, or DSRA? In Project Finance, a Debt Service Reserve Account (‘DSRA’), is a reserve account specifically set aside to make debt payments in the event of a disruption of cashflows to
- [What is a Loan Life Cover Ratio?](https://financialmodellingpodcast.com/blog/what-is-a-loan-life-cover-ratio-and-why-does-it-even-exist) (2019-08-31, Financial Modelling): The Loan Life Cover Ratio - What Is It and How Is It Calculated If anyone has looked at a financial model and seen a Debt Service Cover Ratio (DSCR) and a Loan Life Cover Ratio (LLCR), they might ask why does the LLCR ev
- [What is Debt Sculpting?](https://financialmodellingpodcast.com/blog/what-is-debt-sculpting) (2019-08-31, Financial Modelling): What is Debt Sculpting? *Note: This article has an accompanying Excel file and podcast on debt sculpting. Debt sculpting is a powerful tool in debt structuring and project finance . Debt sculpting can be used to maximise
- [Getting a Bank Onboard](https://financialmodellingpodcast.com/blog/getting-a-bank-onboard) (2019-08-31, Uncategorized): Getting a Bank Onboard In today's fast-paced and competitive business landscape, securing the right financing is crucial for the success of any project or deal. One of the most reliable and time-tested sources of funding
- [The Financial Model Audit](https://financialmodellingpodcast.com/blog/the-financial-model-audit) (2019-08-31, Financial Modelling): What is the Financial Model Audit? Why is the auditing of financial models so important, and who does it? World-renowned model auditors will audit everything in your financial model, from the technical assumptions to the
- [What is a PPP?](https://financialmodellingpodcast.com/blog/what-is-a-ppp) (2019-08-31, Financial Modelling): Public Private Partnerships – Leveraging private sector investment and capital to deliver public infrastructure If you have ever worked in project finance, you have probably heard of a Public-Private Partnership or PPP. 
- [The Coffice](https://financialmodellingpodcast.com/blog/the-coffice) (2019-08-31, Coffee): The Coffice, or Coffee Shop Office I do my best creative work in coffee shops – and that includes building financial models from the ground up and financial engineering! I have turned my favourite coffee shops into offic
- [What is a Financial Close Model vs. an Operational Financial Model?](https://financialmodellingpodcast.com/blog/what-is-a-financial-close-model-vs-an-operational-financial-model) (2019-08-31, Financial Modelling): What is a Financial Close Model vs. an Operational Financial Model? Most project financiers will agree that a project finance model is one of the most complicated financial models to build. What happens when a project re
- [DealTech Part 3- Let’s Get Practical](https://financialmodellingpodcast.com/blog/dealtech-part-3-lets-get-practical) (2019-08-31, Fintech): DealTech – Let’s Get Practical In the previous two DealTech articles, I discussed how DealTech could revolutionise investment banking through automation and optimisation. In the first article , I introduced the concept o
- [DealTech Part 2 – Where Can DealTech Work in Investment Banking](https://financialmodellingpodcast.com/blog/dealtech-part-2-where-can-dealtech-work-in-investment-banking) (2019-08-31, Fintech): For DealTech, We Must Ask What is a Deal Anyway? DealTech has many uses in structuring deals, but how can it be applied? When looking at an investment banking deal, one can roughly break it down into the following compon
- [DealTech - A Combination of Deal Making and Data Science](https://financialmodellingpodcast.com/blog/dealtech-a-combination-of-deal-making-and-data-science) (2019-08-31, Uncategorized): DEALTECH – A COMBINATION OF DEAL MAKING AND DATA SCIENCE DealTech – what is this? Well according to me, it’s a word I made up! However, according to Google its the name of a few companies and products that exist already.
- [Can you be a Professional Financial Modeller?](https://financialmodellingpodcast.com/blog/can-you-be-a-professional-financial-modeller) (2019-08-31, Uncategorized): Can you be a Professional Financial Modeller? Can you make a profession out of financial modelling? Is an entrepreneurial spirit, financial modelling skills and some drive enough to build a business out of financial mode
- [Five Financial Models Tips to Make Models Easier to Understand, Use and Audit](https://financialmodellingpodcast.com/blog/five-financial-models-tips-to-make-models-easier-to-understand-use-and-audit) (2019-08-31, Financial Modelling): Financial models can be scary and even daunting – especially when you haven’t built them! Maybe you are a financier or model auditor trying to figure out what a model is trying to tell you. Using the five financial model
- [Why is Project Finance Modelling so complicated?](https://financialmodellingpodcast.com/blog/why-is-project-finance-modelling-so-complicated) (2019-08-31, Project Finance): So, what is Project Finance? What differentiates it from corporate or leveraged finance? And why does it suit infrastructure projects? And what are infrastructure financing models all about?
- [Financial Modelling for Entrepreneurs](https://financialmodellingpodcast.com/blog/financial-modelling-for-entrepreneurs) (2019-08-31, Financial Modelling): Financial Modelling for Entrepreneurs - A Key Skill Entrepreneurship is an exciting journey filled with countless opportunities and challenges, and in the world of business, making well-informed decisions is crucial for 
- [Will data science disrupt financial modelling?](https://financialmodellingpodcast.com/blog/will-data-science-disrupt-financial-modelling) (2019-08-31, Fintech): Is the financial modelling profession dead, and if not will it be disrupted by data science like so many other industries? The answer is a little more complicated than a simple yes or no.
- [Funding your Dreams – Finance for Entrepreneurs](https://financialmodellingpodcast.com/blog/funding-your-dreams-finance-for-entrepreneurs) (2019-08-31, Financial Modelling): The average entrepreneur does not have a comfortable understanding of finance. This allows them to miss opportunities to save money, streamline processes, and raise capital. In addition, it sometimes means that they don’t optimise the...
- [Forecasting](https://financialmodellingpodcast.com/blog/forecasting) (2019-08-31, Financial Modelling): Mastering the Art of Forecasting: A Key to Strategic Decision-Making and Business Success Forecasting – the ability to foresee the future, analyse trends and make semi-accurate predictions allows the entrepreneur to be p
- [Financial Models Models Models](https://financialmodellingpodcast.com/blog/models-models-financial-models) (2019-08-31, Financial Modelling): Demystifying Financial Models As a business owner, when talking about models, you are talking about financial models. The type of model that shows you where your business is going to be in five years time. The type of mo
- [The Future of Financial Modelling with Lance Rubin](https://financialmodellingpodcast.com/blog/the-future-of-financial-modelling-with-lance-rubin) (2019-08-31, Financial Modelling, Fintech): Despite the fact that artificial intelligence, automation and machine learning are so widely discussed at the moment, Microsoft Excel remains one of the most commonly used tools in any finance department. Financial Modelling continues...