The Financial Modelling Podcast: Recent Episodes

View Details

AI Ecosystem ExplainedAdvanced Analytics and Machine LearningMatthew Bernath June 12, 2026 * ,10:24 am * ,Data analytics, Financial Modelling, Fintech Every city needs foundations, power, roads, buildings, and people using them. AI is the same , just faster and more expensive.*

Layer 1: The Sand - Chips & SemiconductorsBefore any AI can run, someone has to build specialised hardware. Normal chips can’t handle it. AI needs to do millions of calculations simultaneously, not sequentially — and that requires an entirely different class of processor.

• NVIDIA makes the gold-standard AI chip (the GPU). Basically everyone uses them. They’re the arms dealer of the AI war.
• AMD makes competing chips. Cheaper than NVIDIA and catching up fast.
• Intel is trying to get back in the game after being late to AI. Turnaround story.
• TSMC actually manufactures the chips that NVIDIA and AMD design. Nobody builds at their scale. No TSMC, no chips.
• ASML makes the machines that make the chips. One company, total monopoly, Dutch. No ASML means no modern chips. Full stop.
• ARM Holdings designs the chip architecture blueprint that almost every device uses. They license the design — they don’t build anything themselves.
• Broadcom, Marvell, Credo make the networking chips that connect all those AI chips together at speed. The glue between the GPUs.
• Micron, SanDisk make the memory chips. AI needs to store and retrieve data at extreme speed.

• That’s what these companies do. Layer 2: The Power Stations - Energy InfrastructureAI data centres consume obscene amounts of electricity. A single large facility can use as much power as a small city. Someone has to generate that power reliably, around the clock.

• Bloom Energy makes fuel cells that can power data centres without relying on the grid. Always-on, no outages.

• Babcock & Wilcox, T1 Energy are nuclear and alternative energy plays. AI needs baseload power that solar alone can’t guarantee. Layer 3: The Land - Data Centres & CloudYou need physical buildings stuffed with chips, cooled constantly, and connected to the internet at enormous speed. This is the real estate of the AI economy.

• Amazon (AWS), Microsoft (Azure), Alphabet (Google Cloud) own the biggest data centres on earth. They rent compute power to everyone else. The landlords.

• CoreWeave is a newer data centre company built specifically for AI workloads. Rents NVIDIA GPUs at scale to anyone who needs them.

• Core Scientific, IREN, Applied Digital, Cipher Mining started as crypto miners. They already own the buildings, power contracts, and cooling systems. Now pivoting to rent that infrastructure to AI companies. Smart repositioning. Layer 4: The Roads - Networking & ConnectivityData has to move between chips, servers, and data centres at ludicrous speed. These companies build the pipes and roads that make that movement possible.

• Arista Networks builds the switches that move data around inside data centres. The internal road network.

• Coherent, Lumentum, Lightwave Logic make photonics components — fibre optic connections that move data at the speed of light between data centres.

• EchoStar is satellite connectivity infrastructure. The long-range road that connects remote areas and emerging markets. Layer 5: The Buildings - AI Platforms & ModelsThis is where the actual AI gets built and run. The companies building the models that everyone else uses, and the platforms that host those models.

• Alphabet (Google) built Gemini and owns DeepMind. Has the best data in the world via Search. The incumbent with the most to lose and the most to gain.

• Meta built Llama (open source). Owns Instagram and WhatsApp, which generate enormous training data. Playing a different game to everyone else.
• Microsoft owns a large stake in OpenAI (ChatGPT). Azure is how most businesses access AI. The enterprise distribution channel.
• Nebius Group is a lesser-known European AI cloud company rebuilding from Russian tech origins. Early stage but interesting positioning.

• Snowflake, MongoDB, Oracle are data platforms. AI is useless without clean, accessible data. These companies store, manage, and serve it. Layer 6: The Shops - Software Built on AICompanies building useful products on top of the AI models. These are the applications people and businesses actually interact with every day.

• Palantir does AI analytics for governments and large enterprises. Heavy defence and intelligence contracts. Controversial but deeply embedded.

• ServiceNow is enterprise workflow software baking AI into everything. The boring-but-essential layer of corporate IT.
• Tesla is as much an AI company as a car company. Full Self Driving and the Dojo supercomputer are massive AI bets hidden inside a car manufacturer.
• Pega Systems is enterprise software with AI automation. Slower moving but deeply embedded in large organisations.
• Robinhood is a fintech that benefits from retail enthusiasm around AI stocks. A meta-play on the whole trend.

• ImmunityBio, Lemonade are AI applications in biotech and insurance respectively. Niche bets on AI transforming specific industries. Layer 7: The Guards - CybersecurityMore AI means more attack surface. More data means more to steal. AI-powered attacks require AI-powered defence. The security layer grows in direct proportion to everything else in the stack.

• CrowdStrike uses AI to detect and stop threats in real time. The endpoint security leader. Every laptop in a big company is probably running this.

• Palo Alto Networks covers networks, cloud, and endpoints. One of the most comprehensive security platforms available.
• Zscaler does cloud-native security — protecting companies where the perimeter no longer exists, when everyone works from anywhere.
• SentinelOne is an autonomous AI security platform that detects and responds to threats without needing a human in the loop. TL;DRSomeone makes the chips. Someone powers them. Someone houses them. Someone connects them. Someone builds the models. Someone builds apps on those models. Someone secures all of it.

That’s the AI ecosystem. Seven layers, hundreds of companies, and an enormous amount of capital flowing through all of it. The infrastructure layers — chips, power, data centres, connectivity — tend to win regardless of which AI model or application eventually dominates. The picks and shovels tend to win regardless of who finds the gold.

View Details

Financial Modelling with ClaudeAdvanced Analytics and Machine LearningMatthew Bernath* February 12, 2026 * ,8:58 am * ,Data analytics, Financial Modelling, Fintech In late 2025, Anthropic launched Claude in Excel. This is a sidebar that sits inside Microsoft Excel and can read, analyse, modify, and build entire workbooks (but doesn’t yet make you coffee despite my repeated requests and emails to Anthropic management).

Claude in Excel: What It Actually DoesClaude in Excel is a sidebar with structural awareness of your workbook. So it looks at every tab, every formula dependency, every named range. When you ask it a question, it tries to give you cell level citations and context.

So if you ask “why did Q3 revenue drop?” you’ll get something like: “Revenue decreased because customer acquisition in Inputs!D7 dropped from 150 to 120 customers, which flows through Forecast!B14 and reduces Summary!C22 by £180K, and no I can’t make coffee yet.”

So a lot more useful than what it did previously. Below you can see the built in financial modelling skills it now has,

What it can do in practiceExplain the model. You’ve inherited a 47 tab monstrosity from someone who left six months ago. Instead of spending two days tracing cell references, you can ask Claude to walk you through the structure. It maps the dependencies, explains the logic, and points you to the cells that matter, provided the workbook had some structure to begin with!

Debug formulas. #REF! errors, circular references, broken VLOOKUP chains can potentially be solved when Claude traces errors to their source and explains what went wrong. It also tries to explains how to fix them.

Modify assumptions. This is the one that matters most for financial modellers. You want to test what happens if you increase revenue growth by 2%, but you don’t want to break a model 5 minutes before the client meeting. Claude changes values across the entire workbook while preserving formula dependencies and relationships. Modification is explained and highlighted – but I’m still personally a bit wary of this.

Build models. Give Claude your assumptions and structure requirements, and it will create a financial model, including P&L, balance sheet and cash flow. It also does this with formula linkages. It’s not going to produce a model you’d send to a client without review, but as a first draft that gets you 30-50% of the way there.

Generate documentation. The task every modeller knows they should do but never has time for. Claude can generate model documentation including calculation methodologies, assumption sources, and cell level comments explaining complex formulas. Again – review needed!

The Financial Data ConnectorsHere’s where it gets interesting for anyone working in investment analysis or corporate finance. Anthropic has partnered with major financial data providers and connected them directly to Claude:

• LSEG (formerly Refinitiv) for equities, fixed income, FX, and macro data
• Moody’s for credit ratings, ownership data, and company financials
• S&P Capital IQ for fundamental data and analytics
• Aiera for real-time earnings call transcripts and investor event summaries
• Morningstar for fund and investment data
• Third Bridge and Chronograph for expert interviews and PE analytics

This means Claude can pull market data, reference earnings call transcripts, and cross check your assumptions against current fundamentals.

Pre-Built Financial Modelling SkillsAnthropic has also released six pre-built “Agent Skills” for financial services. These are workflows that Claude can execute:

1. Comparable company analysis: valuation multiples and operating metrics that can be refreshed with updated data
2. Discounted cash flow models: FCF projections, WACC calculations, scenario toggles, and sensitivity tables
3. Due diligence data packs: processes data room documents into Excel outputs with financial information, customer lists, and contract terms
4. Company teasers and profiles: condensed overviews for pitch books and buyer lists
5. Earnings analyses: extracts key metrics, guidance changes, and management commentary from quarterly transcripts
6. Initiating coverage reports: industry analysis, company deep dives, and valuation frameworks

These skills work across Claude.ai, Claude Code, and the API.

Where Claude Helps Financial ModellersFormula optimisation. Many financial models accumulate complexity over time. Nested IF statements five layers deep, SUMPRODUCT formulas that nobody can audit, INDEX-MATCH chains that would make your head spin. Claude can potentially simplify by transforming them into cleaner, more auditable structures. Use with caution!

Model review and quality assurance beyond what our add-ins do. Claude spot potential circular reference risks, and check that your balance sheet actually balances. It won’t catch everything a senior modeller would, but it catches the mechanical errors fast. For our own add-ins that provide model reviews see here.

VBA and macro development. If you need to automate repetitive tasks like formatting financial statements or importing data from external sources Claude can write VBA code. It’s also adds comments which can help when someone else needs to maintain it.

Formatting. Colour coding conventions (blue for inputs, black for formulas, green for links to other sheets), consistent formula structures, separation of assumptions and calculations, naming conventions, Claude can help implement these across a workbook.

Scenario and sensitivity analysis. Claude can structure scenario analyses and populate them, leaving more time to be spent on interpreting the results.

What Claude Can't Do (Yet)Make coffee. Besides for that, some other things below.

It doesn’t replace judgement. Claude can build you a DCF model, but it can’t tell you whether your terminal growth rate assumption is reasonable. That’s still your job.

Complex models need human oversight. For straightforward structures like three statement models Claude does well. For bespoke structured finance models with debt structures or tax arrangements, you’ll need to check its work carefully and potentially build your own.

It can make mistakes. Always review changes before finalising. Claude’s financial reasoning is good but not infallible”

Data privacy. If you’re working with material non-public information or sensitive client data, make sure you understand your firm’s policies around AI tool usage.

How to Get StartedIf you’re new to using Claude for financial modelling, here’s a practical starting point:

Start with model documentation. Take a model you know well and ask Claude to document it. This is low risk (you’re not changing anything), and it shows you how Claude understands workbook structure.

Then move to formula review. Share a complex formula and ask Claude to explain it, simplify it, or check it for errors. You’ll quickly get a feel for what it handles well and where you need to stay hands on.

Try building a simple model from scratch. Give Claude a set of assumptions and ask it to build a three statement model. Compare its output to how you’d build it yourself.

Use it for the tasks that eat your time but don’t require deep thinking, such as formatting, documentation, error checking, sensitivity table construction etc.

The Bigger PictureThe financial modelling profession isn’t going away. If anything, the ability to build, audit, and interpret financial models is becoming more valuable as AI makes it easier to produce them. The modellers who thrive will be the ones who use tools like Claude to handle the mechanical work while they focus on the assumptions, the commercial logic, and the story the numbers tell.

Claude in Excel is available in beta for Pro, Max, Team, and Enterprise users. You can find it in the Excel add-ins menu.

View Details

Visualise Your Model: Introducing the Formula Map ToolAdvanced Analytics and Machine LearningMatthew Bernath July 30, 2025 * ,12:15 pm * ,Data analytics, Financial Modelling, Fintech We’re excited to introduce our Formula Map Tool. This is a simple yet powerful way to see and understand* your Excel model like never before.

What Is the Formula Map Tool?The Formula Map Tool is an Excel-based utility that visualises all the formulas in your worksheet at a glance. Instead of manually digging through rows and columns to understand model logic, the Formula Map provides a bird’s eye view of where your formulas and hardcoded values live.

Whether you’re auditing a model, handing it over to a client, or diving into someone else’s workbook, the Formula Map is your instant X-ray.

How It WorksWith a single click, the tool:

• Scans your selected worksheet
• Highlights every formula cell
• Colour-codes cells

• Gives you a visual grid so you can quickly spot:

  • Errors
  • Where formulas have been copied
  • Hardcoded inputs
  • Empty spaces and structure

It’s like heatmapping your Excel brain.

Why Financial Modellers Love It Audit with Precision
Quickly find hardcoded numbers lurking in output sheets or hidden assumptions buried in helper tabs. * Speed Up Reviews
Whether you’re reviewing your own model or someone else’s, the Formula Map helps you focus where it matters most. * Train Junior Analysts
Help them understand how professional models are structured without endless cell-by-cell explanations. * Presentation-Ready*
Screenshots of Formula Maps are a great way to visually communicate model scope, logic layers, and structure to stakeholders or boards Try It Out Today​Financial modelling should be as much about clarity as it is about calculation. The Formula Map Tool helps you build trust in your work from first formula to final forecast.

Download from Addin.World

View Details

Revolutionize Your Financial Models: Introducing the Grey Beards Excel Workbook Performance AnalyzerMatthew Bernath* February 27, 2025 * ,12:38 pm * ,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. As someone who’s spent countless hours optimizing financial models, I’m excited to share a tool that’s changing the game for financial professionals.

The Hidden Cost of Slow Excel ModelsWe’ve all been there. You’re presenting a crucial financial model to stakeholders when Excel suddenly freezes. Or you’re working late, watching the calculation progress bar inch forward while the deadline looms. These aren’t just annoyances—they represent real business costs:

• Lost productivity: Financial analysts spend up to 30% of their time waiting for complex models to calculate
• Decision delays: Critical investment decisions get postponed when models can’t be updated quickly
• Error risk: Performance issues often lead to simplifying models, potentially sacrificing accuracy

After seeing these problems repeatedly across different organizations, we developed a solution.

Financial models often involve repetitive tasks such as data cleaning, consolidation, and complex calculations. Python’s automation capabilities streamline these processes, reducing errors and saving time.

• Automate data imports from APIs, databases, and websites.
• Run complex calculations across multiple sheets instantly.
• Reduce reliance on manual VBA macros, which can be cumbersome and error-prone. Introducing the Grey Beards Excel Workbook Performance AnalyzerWe built this specialized diagnostic tool specifically for financial modellers who need to maintain both model complexity and performance. Unlike general Excel optimization tips, our analyzer targets the specific challenges that make financial models slow:

Key Features Deep Formula Analysis: Identifies volatile functions, array formulas, and calculation chains that create bottlenecks * Sheet-by-Sheet Size Breakdown: Shows exactly which sheets are consuming memory and why * Hidden Element Detection: Reveals and optionally unhides “very hidden” worksheets and named ranges that might be causing issues * External Reference Mapping: Identifies links to external workbooks that create dependencies and slow calculations * Practical Recommendations*: Provides actionable suggestions tailored to financial modelling best practices. Real Results from Financial Professionals

Our quarterly consolidation model had grown to 62MB and took over 5 minutes to recalculate. After running the analyzer and implementing its recommendations, the file size dropped to 28MB with calculation time under 45 seconds—without sacrificing any functionality.

Investment Banking Analyst

I inherited a complex LBO model that would crash Excel whenever certain scenarios were run. The Performance Analyzer identified several circular references and excessive conditional formatting that weren't visible through normal means. After fixing these issues, the model runs flawlessly.

Private Equity Associate

Beyond Speed: Building Better ModelsWhat makes this tool particularly valuable for financial modelling professionals is how it helps build better modelling practices. The analyzer doesn’t just identify problems—it educates users on why certain approaches cause performance issues and suggests modelling alternatives.

For example, it might flag a SUMIFS formula spanning entire columns and suggest using Tables with structured references instead, explaining both the performance benefit and the improved maintainability.

Is Your Financial Model Running at Peak Performance?Here’s a quick self-assessment:

• Does your model take more than 30 seconds to calculate?
• Has your workbook grown beyond 10MB?
• Do you use OFFSET, INDIRECT, or volatile functions like TODAY()?
• Does your model reference external workbooks?
• Are there hidden worksheets or named ranges you didn’t create?

If you answered “yes” to any of these questions, your model likely has optimization opportunities that could save you hours each week.

Limited Time Offer - Try It For YourselfWe’re offering Financial Modeling Podcast listeners an exclusive 30-day trial of the Grey Beards Excel Workbook Performance Analyzer. Visit here and use code FMPOD to access your extended trial.

After experiencing the difference optimized models make to your workflow, you’ll wonder how you ever lived without it.

View Details

Python for Excel: Supercharging Financial ModellingMatthew Bernath February 17, 2025 * ,5:06 pm * ,Data analytics, Financial Modelling, Fintech Microsoft Excel has been the gold standard for financial modelling for decades. However, as financial models grow more complex, integrating Python with Excel offers significant advantages, from automation and scalability to powerful analytics. With the introduction of Python in Excel* (natively available in Microsoft 365), financial professionals can harness Python’s capabilities without leaving their spreadsheets.

This blog explores how Python can enhance financial modelling and how modellers can leverage it effectively.

Key Benefits of Using Python in ExcelAutomation and EfficiencyFinancial models often involve repetitive tasks such as data cleaning, consolidation, and complex calculations. Python’s automation capabilities streamline these processes, reducing errors and saving time.

• Automate data imports from APIs, databases, and websites.
• Run complex calculations across multiple sheets instantly.

• Reduce reliance on manual VBA macros, which can be cumbersome and error-prone. Advanced Analytics and Machine LearningPython unlocks access to advanced analytical tools that Excel struggles with:

• Monte Carlo simulations for risk analysis.

• Machine learning models for credit scoring or investment predictions.

• Time series forecasting using libraries like statsmodels and prophet. Seamless Data IntegrationPython’s ability to handle large datasets makes it ideal for financial modelling where data is sourced from multiple platforms:

• Connect directly to financial databases (Bloomberg, Alpha Vantage, Quandl, etc.).

• Integrate structured and unstructured data into Excel.

• Process millions of rows with ease using pandas and numpy. Code Reusability and CollaborationUnlike Excel formulas or VBA, Python scripts can be version-controlled and shared easily, improving team collaboration.

• Use GitHub for version tracking.

• Create reusable functions for financial calculations.

• Collaborate seamlessly across Excel and Jupyter Notebooks. How to Get Started with Python in ExcelMicrosoft has introduced Python in Excel, allowing direct execution of Python code within a workbook. Here’s how to get started:

• Enable Python in Excel* Open Excel (Microsoft 365 Insider Beta required as of now).

• Navigate to Formulas → Insert Python Formula (=PY()).
• Start writing Python functions directly in Excel cells.
• Use pandas for Data Analysis import pandas as pd# Read data from an Excel filefile_path = "financial_data.xlsx"df = pd.read_excel(file_path, sheet_name="Sheet1")# Perform analysisdf["Return"] = df["Price"].pct_change()df.describe()
• Automate Financial Calculations Calculate Net Present Value (NPV) using Python:import numpy as npcash_flows = [-1000, 200, 300, 400, 500]discount_rate = 0.1npv = np.npv(discount_rate, cash_flows)print(f"NPV: {npv}")
• Run Monte Carlo Simulations import numpy as npsimulations = 10000returns = np.random.normal(0.05, 0.15, simulations)portfolio_value = 100000 * (1 + returns).cumprod()print(f"Expected portfolio value: {np.mean(portfolio_value)}") The Future of Financial Modelling with Python and ExcelThe 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.

Python for Excel allows you to:

Automate repetitive financial modelling tasks.

Use Python for data analysis, forecasting, and Monte Carlo simulations.

Eliminate the limitations of traditional Excel by handling big data and APIs.

Improve collaboration with code reusability and version control.

Python in Excel is an amazing tool for forward-thinking financial professionals.

View Details

Essential Tools for Financial Modelling SuccessMatthew Bernath* February 16, 2025 * ,8:46 pm * ,Financial Modelling, Recommendations In the fast-paced world of finance, having the right tools can make all the difference. Whether you’re a seasoned investment banker, a data-driven analyst, or a finance enthusiast looking to level up your skills, the right resources will enhance your efficiency and accuracy. This post will explore some must-have products that can transform your financial modelling experience.

My pointing out my desk setup, like a proud dad! Books That Elevate Your Financial Modelling SkillsOptions, Futures, and Other Derivatives, Global Edition – John C. Hull This book is an essential resource for anyone looking to master financial derivatives and risk management. * It covers concepts such as options pricing, futures contracts, and risk hedging, making it a must-have for financial modellers dealing with complex securities. * Buy Now Stock Investing for Dummies – Paul Mladjenovic If you’re looking to integrate stock analysis into your financial models, this guide provides an accessible introduction to investing strategies, valuation techniques, and portfolio management. * Buy Now Tech Essentials for ProductivitySwissGear 2769 ScanSmart Laptop Backpack A reliable and spacious backpack is a must for financial professionals on the move. * This SwissGear backpack offers ample storage for laptops, documents, and accessories while ensuring comfort and durability. * *Buy Now Leaper Retro Crossbody Bag Sling Bag Canvas Messenger Bag For those who prefer a stylish yet functional alternative, this messenger bag provides a convenient way to carry essentials while keeping things lightweight. * Buy Now Ergonomic Upgrades for Long Hours at the DeskEverlasting Comfort Lumbar Support Pillow Sitting for hours while building financial models can strain your back. * This memory foam lumbar support pillow helps maintain proper posture, preventing back pain and improving comfort. * Buy Now Adjustable Standing Desk Converter Switching between sitting and standing can improve focus and energy levels. * This standing desk converter allows you to seamlessly transition between positions, making long hours in front of your financial models more comfortable. * *Buy Now Office Supplies for Efficient WorkflowNeenah Exact Vellum Bristol Cardstock, 67 lb, 250 Sheets, White High-quality cardstock is useful for printing financial reports, model summaries, and client presentations. * This durable paper ensures your documents look professional. * Buy Now Southworth® Parchment Specialty Paper, 8 1/2″ x 11″, 24 Lb, Ivory For financial professionals who need to produce formal documents, this parchment paper adds an extra touch of sophistication to reports and proposals. * Buy Now Time Management and Productivity AidsThe EOS Life: How to Live Your Ideal Entrepreneurial Life – Gino Wickman Balancing financial modelling with personal and professional growth is key. * This book provides valuable insights into achieving an entrepreneurial mindset and maintaining productivity. * *Buy Now Pomodoro Timer – Ticktime Cube Timer Staying focused while building models can be challenging. * Using a Pomodoro timer encourages structured work sessions with breaks, enhancing productivity and reducing fatigue. * Buy Now* Final ThoughtsBuilding accurate and efficient financial models requires the right combination of skills and tools. By investing in these products, you can streamline your workflow, enhance accuracy, and stay comfortable during long work sessions. Whether you’re improving your modelling techniques with top-tier books or upgrading your workspace with ergonomic and productivity-enhancing tools, these investments will pay dividends in your career.

Let us know which tools have made the biggest impact on your financial modelling journey! Stay tuned to the Financial Modelling Podcast for more insights and recommendations.

View Details

How Your Workspace Design Impacts Performance: The Psychology of Professional EnvironmentsMatthew Bernath* January 17, 2025 * ,3:35 pm * ,Financial Modelling, Fintech In the demanding world of finance, where precision and focus are paramount, every element of your workspace matters. Whether you’re building complex financial models, analyzing market data, or preparing client presentations, your environment plays a crucial role in your performance and decision-making capabilities.

Get The Finance Wallpaper Premium CollectionThe Science of Workspace PsychologyResearch from organizational psychology has demonstrated that our environment significantly influences cognitive function and professional performance. A landmark study by the University of Texas revealed that visual elements in our workspace affect everything from analytical capabilities to creative problem-solving. For finance professionals who spend 12+ hours at their desks, these environmental factors become even more critical.

Visual Foundations of Professional PerformanceYour desktop wallpaper serves as the foundation of your digital workspace. It’s the canvas upon which you build financial models, craft pitch decks, and analyze market data. While often overlooked, this persistent visual element sets the tone for your entire work session.

Introducing the Professional Finance Wallpaper CollectionUnderstanding these principles, we’ve created a collection of wallpapers specifically designed for finance professionals. Each design balances aesthetic sophistication with psychological benefits.

1. The Institutional Excellence

Inspired by professional terminal interfaces, this design incorporates subtle data visualizations that complement your workflow. The deep charcoal background reduces eye strain during late-night modeling sessions, while professional accent colors maintain an atmosphere of institutional excellence.

2. Analytical Clarity

Clean, precise data visualizations serve as a reminder of the importance of clear thinking and structured analysis. Available in both light and dark variants, this design speaks to the methodical nature of financial analysis.

3. Mathematical Precision

Where geometric elegance meets financial sophistication, this design incorporates golden ratios and mathematical patterns that reinforce analytical thinking. The refined color palette projects professionalism and attention to detail.

4. Modern Minimalism

Ultra-clean designs featuring subtle market data flows remind you of the dynamic nature of financial markets while maintaining a professional aesthetic that impresses during client screen shares.

Design Principles at WorkEach wallpaper incorporates several key psychological and professional elements:

1. Professional Psychology
2. Color schemes aligned with institutional finance
3. Visual elements that promote analytical thinking
4. Designs that maintain credibility during client interactions
5. Cognitive Enhancement
6. Patterns that support structured thinking
7. Elements that reinforce financial precision
8. Layouts that promote organized analysis
9. Professional Endurance
10. Eye strain reduction for long modeling sessions
11. Clean designs that reduce mental fatigue

12. Optimization for extended work hours Impact on Professional PerformanceYour workspace design can influence several aspects of your professional capabilities:

13. Analytical Clarity The right environment supports clear thinking during complex financial analysis and model building.

14. Professional Focus Clean, purposeful designs reduce distractions during critical tasks like deal analysis and client presentations.
15. Corporate Excellence Sophisticated visual elements reinforce a professional atmosphere, essential for both individual work and client interactions. Looking ForwardAs 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.

The best professional achievements often stem from an optimized environment that brings out your analytical best. Sometimes, that starts with the fundamental visual elements of your workspace.

View Details

5 Key Trends Shaping Project Finance in 2025Matthew Bernath January 14, 2025 * ,4:47 pm * ,Financial Modelling, Fintech Project finance continues to be a critical enabler for large-scale infrastructure and energy projects worldwide. In 2025, the industry is undergoing significant changes driven by global trends and technological advancements. Here are the five key trends* reshaping project finance today.

1. The Rise of Energy Transition ProjectsAs the world focuses on sustainability, renewable energy projects—such as wind farms, solar plants, and battery storage systems—have taken centre stage. Hybrid energy systems that combine renewables with traditional sources are also gaining traction to ensure reliability and grid stability.

Why It Matters:

• These projects are complex, often involving carbon credits, government subsidies, and fluctuating commodity prices.
• Financial models must now accommodate dynamic revenue streams and sensitivity analyses around energy prices and carbon taxes.
• Increased Focus on ESG MetricsEnvironmental, Social, and Governance (ESG) criteria are no longer optional in project finance. Investors, particularly development finance institutions (DFIs) and green bond issuers, demand rigorous ESG reporting and link financing terms to sustainability outcomes.

Why It Matters:

• Many financing deals now feature performance-based incentives, such as interest rate reductions for meeting ESG targets.
• Modelling these incentives requires incorporating ESG-linked performance metrics into cash flow projections and debt repayment schedules.
• Growth in Digital Infrastructure ProjectsWith the global reliance on technology growing exponentially, investments in data centres, fibre optic networks, and 5G infrastructure are surging. These projects offer predictable cash flows, often secured by long-term contracts with technology companies.

Why It Matters:

• Financial models must account for granular data usage forecasts and the potential risks of technological obsolescence.
• Stress-testing demand growth scenarios and assessing regulatory risks are crucial to ensuring project viability.
• Blurred Lines Between Private and Public FinancingGovernments increasingly rely on private capital to fund essential infrastructure through Public-Private Partnerships (PPPs). Fiscal constraints have also led to the rise of blended finance structures, where concessional loans from development agencies combine with commercial financing.

Why It Matters:

• These arrangements require careful modelling of risk allocation between public and private entities.
• Sensitivity analysis around availability-based payments, regulatory risks, and performance penalties is critical.
• Technology Driving Efficiency in FinancingAdvancements in technology—such as AI, blockchain, and advanced analytics—are transforming the project finance landscape. Blockchain is being used for transparent payment tracking, while AI enhances risk identification and optimises capital structures.

Why It Matters:

• Financial modellers must embrace tools like Python and Power BI to supplement traditional Excel models.
• These technologies improve efficiency, accuracy, and the ability to handle increasingly complex scenarios. Key TakeawaysThe project finance industry is being reshaped by sustainability, technology, and evolving financing models. Whether you’re a project finance professional or a financial modeller, staying ahead of these trends is essential to remain competitive and add value to your projects.

View Details

Using Claude AI to Supercharge Your Excel Financial ModellingMatthew Bernath* January 6, 2025 * ,1:18 pm * ,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. Here’s how you can leverage this powerful tool to enhance your modelling practice.

Model Building and ValidationOne of Claude’s most valuable capabilities is its ability to review complex Excel formulas and model structures. It can spot potential circular references, identify hardcoded values that should be variables, and suggest ways to make your models more robust. For instance, if you’re building a DCF model, you can ask Claude to review your free cash flow calculations or help structure your sensitivity analysis tables.

• Consider this scenario: You’re working on a complex LBO model and want to ensure your debt scheduling is properly structured. Simply share your formulas with Claude, and it can help you:
  Verify the mathematical logic of your calculations
• Suggest more efficient formula structures
• Identify potential issues in your waterfall calculations
• Recommend best practices for handling debt amortization Overview of a project finance structure for data centersFormula OptimizationOverview of a project finance structure for data centersMany financial models suffer from unnecessarily complex formulas that are difficult to audit. Claude excels at simplifying and optimizing Excel formulas while maintaining their functionality. For example, it can help transform nested IF statements into more elegant solutions using INDEX-MATCH or XLOOKUP, making your models more maintainable and easier to debug.

Documentation and CommentsClear documentation is crucial for model handover, but it’s often overlooked due to time constraints. Claude can help generate comprehensive documentation for your models, including:

• Detailed explanations of calculation methodologies
• Assumptions and their sources
• Cell-level comments explaining complex formulas
• User guides for model navigation and updates Typical data center clientsModel Testing and DebuggingWhen your model isn’t behaving as expected, Claude can help you implement systematic testing approaches. It can suggest test cases for different scenarios and help you build checks and balances throughout your model. This is particularly valuable for complex models with multiple interconnected worksheets.

Best Practices ImplementationInternational Banker addresses the environmental impact of data centresFinancial modelling best practices are essential for creating reliable, professional models. Claude can guide you in implementing industry-standard conventions, such as:

• Proper colour coding for inputs, calculations, and outputs
• Consistent formula structures across worksheets
• Clear separation of inputs and calculations
• Effective naming conventions for ranges and variables Real-World ApplicationsThe real power of Claude becomes apparent when dealing with specific modelling challenges. For example, when building a working capital model, you might ask Claude:

“How can I make my working capital calculations more dynamic to account for seasonal variations in inventory levels?”

Claude can then provide specific formula structures and modelling approaches, complete with explanations of the underlying logic and implementation steps.

Getting StartedTo begin incorporating Claude into your financial modelling workflow, start with simple tasks like formula reviews or documentation generation. As you become more comfortable with the tool, you can gradually expand its use to more complex modelling tasks.

Remember that while Claude is incredibly helpful, it should complement rather than replace your financial modelling expertise. The best results come from combining AI capabilities with human judgment and industry knowledge.

View Details

Top Business Travel Must-HavesMatthew Bernath* December 23, 2024 * ,12:07 pm * ,Recommendations Travelling for business demands efficiency, organisation, and the right tools to keep you productive. After travelling extensively for work over the past few years, locally and internationally, I’ve honed my list of essentials. These ensure I’m always prepared for work, no matter where I am. Here are my must-haves that simplify business travel and make life easier— items I’ve personally road-tested and can endorse.

Logitech MX Master Anywhere MouseA reliable mouse is non-negotiable for efficiency, and the Logitech MX Master Anywhere is my top pick. Compact yet powerful, this mouse works on almost any surface, including glass, and features customisable buttons for multitasking. Whether in an airport lounge or a hotel room, it’s a productivity powerhouse.

Why it’s essential: Lightweight and portable, yet full of features that boost efficiency on the go.

Bellroy Desk CaddyKeeping small essentials organised during travel can be tricky, but the Bellroy Desk Caddy handles it perfectly. It’s a sleek organiser that holds cables, pens, chargers, and more. Once unpacked, it transforms into a mini desk setup, making it easier to find everything you need without rummaging through your bag.

Why it’s essential: Keeps your workspace tidy and transitions easily from bag to desk.

I keep a USB multiplug, cables, business cards (yes, I’m old school), lens wipes, alcohol swaps and some cologne wipes in mine.

Osprey Daylite Toiletry KitA good toiletry kit is essential for any traveller, and the Osprey Daylite Toiletry Kit is my go-to. It’s compact, durable, and perfectly organised for all your toiletries. e sleek design fits easily into your luggage without taking up too much space, and the quality ensures it lasts trip after trip.

Why it’s essential: Streamlines packing and ensures you’re always prepared with the essentials.

Refillable Travel BottlesTravelling light includes managing toiletries effectively. Mrsdry Travel Bottles are leak-proof, TSA-approved, and perfect for carrying your favourite shampoo, conditioner, or lotion without the bulk of full-sized bottles. These are amazing for keeping the right amount of shampoo, conditioner or anything else for travel.

Why it’s essential: Saves space while keeping your essentials accessible and mess-free.

Slim Power BanksPortable chargers are a must-have for business travel. A slim, lightweight power bank ensures you’re never caught with a dead device. Look for options with high capacity and fast charging capabilities to minimise downtime. I keep two in my bag!

Why it’s essential: Keeps your phone and other devices powered throughout the day, no matter where you are.

USB-C Fast Charger & Braided Charging CablesThe Aiminu USB-C Multiport Charger is indispensable. It charges multiple devices simultaneously, saving time and space. This charger lets you quickly and efficiently power up your phone, laptop, and other gadgets.

Why it’s essential: Consolidates your charging needs into one compact device, ideal for the modern traveller.

Durable charging cables are a must, and these braided cables are built to last. With compatibility across devices like iPhones, MacBooks, and Samsung phones, they’re versatile and reliable for all your charging needs.

Why it’s essential: Long-lasting and tangle-free, perfect for on-the-go use.

Lounge AccessAirport lounge access is essential for business travellers as it provides a quiet, comfortable space to relax or work, away from the hustle and noise of the terminal. With amenities like Wi-Fi, refreshments, and charging stations, lounges help maximise productivity and reduce travel stress.

To the left, you can see an espresso I had on a rainy morning flying to Cape Town from Lanseria.

A coffee I had before flying to New York.Closing a deal in an airport lounge in 2018. To the right you can see the champagne my wife had organised to celebrate.Universal Plug AdapterPair your USB-C charger with a universal plug adapter to stay connected internationally. Look for a model with surge protection to safeguard your devices.

Why it’s essential: Simplifies charging abroad, ensuring you’re ready to plug in anywhere.

Travel Smarter, Not HarderEvery item on this list makes business travel smoother, more organised, and less stressful. Whether navigating airports, setting up a hotel workstation, or staying charged on the go, these tools have you covered.
Stay productive and prepared—wherever your business takes you.

View Details

Protecting Your Financial Models: Why and How to Implement Disclaimer ControlsMatthew Bernath* December 3, 2024 * ,11:13 am * ,Financial Modelling Financial models are valuable intellectual property that often contain sensitive information, proprietary methodologies, and competitive insights. As financial professionals increasingly share these models with clients and stakeholders, protecting this IP becomes crucial. In this post, I’ll explain why you should implement NDA controls in your financial models and how to do it effectively.

Why Protect Your Financial Models?When you spend hours developing sophisticated financial models, you’re creating valuable intellectual property that deserves protection. Here’s why:

1. Proprietary Methodologies: Your unique approach to financial modelling and analysis represents significant intellectual capital.
2. Client Confidentiality: Models often contain sensitive client data and assumptions.
3. Professional Reputation: Unauthorised sharing can dilute you or your firm’s competitive advantage.

4. Revenue Protection: Preventing unauthorised distribution helps maintain the value of your work. Technical ImplementationThe most effective way to protect Excel-based financial models is by implementing a VBA-based NDA system that:

5. Appears automatically when the workbook opens.

6. Requires explicit acceptance before showing content.
7. Cannot be bypassed through normal means.

8. Maintains a professional appearance aligned with your brand. Best Practices for Model ProtectionBeyond the technical implementation, consider these best practices:

9. Clear Terms: State exactly what users can and cannot do with your model.

10. Liability Protection: Include disclaimers about forecast accuracy and reliance.
11. Professional Branding: Maintain your firm’s visual identity in the NDA interface.

12. Audit Trail: Consider logging acceptance for compliance purposes. Ready-to-Use SolutionWhile you can build this protection system yourself, I’ve created a professional, tested solution that you can implement immediately. My package includes:

13. Complete VBA code for NDA implementation

14. Professional disclaimer text reviewed for legal completeness.
15. Easy installation instructions
16. Customisation guide for your branding Buy NowFutureproofing Your ModelsAs financial modelling becomes increasingly collaborative, protecting your intellectual property while maintaining usability is crucial. Whether you build your own solution or use a pre-built one, implementing NDA controls is no longer optional for serious financial professionals.

View Details

Productivity Tools Every Financial Modeller NeedsMatthew Bernath* November 22, 2024 * ,1:35 pm * ,Financial Modelling, Recommendations In the demanding world of financial modelling, efficiency, precision, and comfort are key. Equipping your workspace with the right tools enhances productivity and ensures you can work for extended periods without discomfort. Below is a detailed guide to the productivity tools and accessories every financial modeller should consider.

My setup last year, I've since upgraded my art and layout a bitMechanical Keyboards for Fast TypingA high-quality mechanical keyboard can make a world of difference in how quickly and accurately you input data. Mechanical keyboards provide tactile feedback, faster response times, and superior durability compared to standard keyboards.

Keychron K8 Wireless Mechanical Keyboard

• Features a tenkeyless (TKL) layout for a compact design while retaining essential functionality.
• Hot-swappable switches allow you to customise the typing experience.
• Works in both wired and wireless modes for ultimate flexibility.

• Buy Now Das Keyboard 4 Professional

• A favourite among professionals, this keyboard uses Cherry MX switches for precision typing.

• It includes a full number pad, perfect for heavy data entry.
• Its aluminium top panel ensures durability and a premium feel.
• Buy Now Dual Monitors for MultitaskingDual monitors revolutionise workflow efficiency, allowing you to open multiple documents, models, or dashboards simultaneously. This setup is a game-changer for those who need to cross-reference data or present polished financial reports.

Dell UltraSharp U2720Q 27-Inch 4K Monitor

• Stunning 4K resolution with exceptional colour accuracy.
• Ideal for detailed Excel spreadsheets, Power BI dashboards, and financial charts.

• Buy Now HP Z24f G3 23.8-Inch Full HD Monitor

• • A budget-friendly monitor that doesn’t skimp on features.
  • Includes an ergonomic stand for tilt, pivot, and height adjustments.
  • Buy Now VIVO Dual Monitor Desk Mount

• Organise your desk by mounting two screens with adjustable angles.

• Buy Now HUANUO Dual Monitor Stand

• Adds flexibility and helps maintain an ergonomic viewing height.

• Buy Now Ergonomic Chairs to Prevent Back PainHerman Miller Aeron Ergonomic Chair

• Features adjustable lumbar support, armrests, and breathable mesh for maximum comfort.

• Perfect for long days spent modelling or analysing data.

• Buy Now Steelcase Series 1 Work Office Chair

• Offers exceptional support and customisable settings at a more accessible price point.

• Includes an adjustable seat depth and lumbar support for personalised comfort.

• Buy Now Footrests for Enhanced PostureMind Reader Adjustable Footrest

• Encourages proper leg positioning and relieves pressure on your lower back.

• Buy Now ErgoFoam Footrest

• Memory foam support for added comfort during long work sessions.

• Buy Now Desk Organisation ToolsA clutter-free desk promotes focus and reduces stress. Keeping your workspace organised ensures you can find the necessary tools and documents without wasting time.

Cable Management Kits

• • Joto Cable Sleeves: Keep all your cables organised and tangle-free.
  • D-Line Cable Management Box: Perfect for hiding power strips and excess cords. Desk Drawer Organisers
• • SimpleHouseware Drawer Organiser Tray: A handy accessory for storing pens, sticky notes, and other small items. Monitor Stands with Storage

• Metal Monitor Stand: Elevates your monitor while providing space underneath for storage. Noise-Cancelling Headphones for FocusStaying focused on complex financial models can be challenging in a busy office or noisy home environment. Noise-cancelling headphones block out distractions and help you maintain concentration.

Sony WH-1000XM5 Noise-Cancelling Headphones

• Personal recommendation – I have the XM4s and the WF4s, which are the in-ear version. Best noise cancelling I’ve experienced.
• Industry-leading noise cancellation with exceptional audio quality.
• Perfect for video calls and listening to podcasts while working.

• Buy Now SAMSUNG Galaxy Buds 3 Pro AI True Wireless Bluetooth Earbuds

• Personal recommendation – I purchased these recently, and they are amazing for work calls and listening to music. They are super comfy, and I can wear them all day. The only downside is the lack of dual connectivity to two devices simultaneously.

• Offers both noise-cancelling and “aware” modes for different work settings.
• Buy Now High-Quality Mouse and Mouse PadsA precise and ergonomic mouse is essential for efficiently navigating complex spreadsheets and dashboards.

My own (seemingly very dustry!) setup with my MX Master 3S and Delta Hub restLogitech MX Master 3S Performance Wireless Mouse

• The mouse I use and swear by, I have two! One for my home and one for my office.
• It features programmable buttons and hyper-fast scrolling, ideal for large datasets.
• Buy Now

DELTAHUB Wrist Wrists

• Another personal recommendation of mine, I use two! One for my left hand and one for my right. Next-level comfort.
• Buy Now ConclusionInvesting in the right tools can drastically improve your efficiency and comfort as a financial modeller. From mechanical keyboards to dual monitors, ergonomic chairs, and desk accessories, these items will make your workflow smoother and your workspace more enjoyable.

Boost your productivity with these tools designed for modellers. Check out these must-have products on Amazon and take the first step toward an optimised work environment!

View Details

How to Project Finance a Data CenterMatthew Bernath* November 22, 2024 * ,8:41 am * ,Financial Modelling, Project Finance Data centres are increasingly vital in our digital economy, serving as the backbone for cloud services, artificial intelligence, and other technology-driven applications. However, developing a data centre is a capital-intensive undertaking that requires sophisticated project finance modelling to ensure bankability. This guide outlines the critical parameters, financial structures, and considerations required for successfully project-financing a data centre.

Infrastructure Investor explores financing data centersKey Project ParametersRevenue Drivers

1. Rack Space Rental: Typically priced per kW of IT load, providing stable, predictable revenues through long-term contracts.
2. Cross-Connect Fees: Charges for interconnecting customers within the facility.
3. Remote Hands Services: On-demand technical support billed hourly.

4. Power Pass-Through: Energy costs are passed to tenants with a small markup. Capital Costs

5. Land Acquisition: Typically 3–5 acres per MW of IT load.

6. Core & Shell: $200–400 per square foot.
7. Mechanical & Electrical Infrastructure: $8–12 million per MW of IT load.
8. Fibre Connectivity: $2–5 million for diverse routing.

9. Commissioning: 2–3% of total capital expenditure. Operating Costs

10. Power: Often the largest operating cost, representing 30–40% of revenue.

11. Staff: Facility management, technical operations, and security.
12. Maintenance: Preventative and emergency repairs.
13. Property Tax: Calculated on the improved value of the facility.
14. Insurance: Covers all risks and business interruptions. Project Finance StructureOverview of a project finance structure for data centersSpecial Purpose Vehicle (SPV)

The project is typically housed within an SPV to isolate risks and segregate assets. This structure ensures:

• Bankruptcy remoteness.
• Direct flow of revenues to lenders and investors.

• Simplified contractual and operational governance. Capital Structure

• Equity: 25–35% of total project costs, contributed by sponsors and investors.

• Senior Debt: 65–75% loan-to-value (LTV) ratio.
• Debt Terms: 5–7-year mini-perm loans, converting to term loans post-completion. These can go up to 15-year loans.

• Debt Service Coverage Ratio (DSCR): Minimum thresholds of 1.35x–1.45x ensure healthy cash flow margins. Security Package

• First lien on project assets and revenues.

• Assignment of material contracts (e.g., tenant agreements, EPC contracts).

• Reserve accounts for debt service, maintenance, and operational contingencies. Financial Model FrameworkConstruction Period

• Timeline: Typically 18–24 months for full build-out.

• Draw Schedule: Monthly drawdown of capital to align with construction milestones.
• Interest During Construction: Capitalised to ensure the SPV maintains cash flow.

• Pre-Completion Tests: Technical and financial tests validate the project’s readiness for operation. Operating Period

• Ramp-Up: 24–36 months to stabilise capacity utilisation.

• Revenue Build-Up:
  • Progressive absorption of rack space.
  • A mix of contracted vs merchant capacity.
  • Power Usage Effectiveness (PUE) assumptions to optimise energy efficiency.

• Operating Costs:

  • Fixed and variable components (e.g., labour, power, maintenance).
  • Lifecycle reserve allocations for long-term equipment replacement. Typical data center clientsTypical Key Metrics

• Project IRR: 12–15% (unlevered).

• Equity IRR: 15–20% (levered).
• Minimum DSCR: 1.35x–1.45x.
• Loan Life Coverage Ratio (LLCR): Minimum 1.4x.

• Project Life Coverage Ratio (PLCR): Minimum 1.5x. Risk MitigationConstruction Risk

• Fixed-price, date-certain EPC contracts with experienced contractors.

• Adequate contingency budget (5–10% of CapEx).

• Independent technical advisor oversight. Market Risk

• Pre-leasing requirements (50–60% of capacity).

• Diversified customer base to minimise concentration risk.

• Strategic site location near fibre optic routes and population hubs. Operational Risk

• Redundant systems (minimum N+1 design for resilience).

• Preventative maintenance and emergency response plans.

• Performance guarantees from equipment suppliers. Environmental Risk

• Power usage effectiveness (PUE) targets.

• Renewable energy integration (e.g., solar, wind).

• Water conservation and waste heat recovery initiatives. Environmental, Social, and Governance (ESG) ConsiderationsInternational Banker addresses the environmental impact of data centresEnvironmental

• Energy efficiency metrics (e.g., PUE, carbon intensity per kW).

• Procurement of renewable power.

• Waste and water management strategies. Social

• Local job creation during construction and operation.

• Community engagement and digital inclusion initiatives. Governance

• Transparent operational reporting.

• Cybersecurity and data privacy safeguards.

• Regular ESG disclosures to investors and stakeholders. Environmental Risk

• Power usage effectiveness (PUE) targets.

• Renewable energy integration (e.g., solar, wind).
• Water conservation and waste heat recovery initiatives. Documentation Requirements1. Project Agreements:
  • EPC contracts, O&M agreements, and interconnection agreements.
  • Long-term customer contracts for rack space and cross-connect fees.
• Finance Documents:
  • Credit agreements, security documents, and reserve account terms.
  • Independent technical and insurance reports will be used to validate assumptions.
• Energy efficiency metrics (e.g., PUE, carbon intensity per kW).
• Procurement of renewable power.
• Waste and water management strategies.

• Project Agreements:

  • EPC contracts, O&M agreements, and interconnection agreements.
  • Long-term customer contracts for rack space and cross-connect fees.

  • Finance Documents:

  • Credit agreements, security documents, and reserve account terms.

  • Independent technical and insurance reports will be used to validate assumptions. ConclusionProject financing a data centre requires detailed planning across technical, commercial, and financial dimensions. A successful deal hinges on the following:

• Robust financial modelling with conservative assumptions.

• Effective risk allocation across construction, market, and operational phases.
• Clear ESG strategies to meet modern investor expectations.

By following this structured approach, developers can secure debt and equity investments, delivering essential digital infrastructure to power the modern economy.

For more insights into financial modelling and project finance, visit the Financial Modelling Podcast and listen to our episodes covering real-world applications in infrastructure finance.

View Details

Modelling Interest During Construction (IDC) in Project FinanceMatthew Bernath* October 1, 2024 * ,1:13 pm * ,Financial Modelling, Project Finance In project finance, understanding and accurately modelling Interest During Construction (IDC) is crucial for project viability and financial planning. This post will delve into the concept of IDC, its importance, and how to model it effectively in your financial projections.

What is Interest During Construction (IDC)?Interest During Construction refers to the interest costs incurred on borrowed funds used to finance a project during its construction phase before it starts generating revenue. In project finance, these interest costs are typically capitalised (added to the project’s cost) rather than expensed immediately.

Why is IDC Important?1. Cost Impact: IDC can significantly increase the total project cost, sometimes by 10–15% or more, depending on the project’s size, duration, andinterest rate. 2. Funding Requirements: Accurate IDC projections help determine the total funding needed for the project, as this needs to be taken into account. 3. Financial Viability: IDC affects the project’s overall returns and debt service capacity as capitalised interest needs to not only be paid but also increases the debt balance. Key Factors Affecting IDC1. Construction period duration — the longer the period, the more interest will be capitalised. 2. Debt drawdown schedule — debt drawn down towards the end of construction will result in lower interest capitalised, while debt drawn with equity will result in higher interest capitalised. 3. Interest rates — the higher the rate, the higher the interest. 4. Capitalisation policy (i.e. is interest capitalised during construction or paid for from debt drawn during construction). Steps to Model IDC in Project Finance1. Define the Construction Period Clearly outline the start and end dates of the construction phase. * Break down the period into monthly or quarterly intervals for detailed modelling. 2. Project the Debt Drawdown Schedule Estimate how much debt will be drawn and when during construction. * This often aligns with the project’s capital expenditure (CAPEX) schedule. 3. Determine the Interest Rate* Use the agreed interest rate for the construction facility. * If it’s a floating rate, you may need to forecast the base rate and add the margin. 4. Calculate IDCFor each period:

1. Calculate the average debt balance.
2. Multiply by the interest rate and the time fraction (e.g., 1/12 for monthly periods).
3. Sum up the interest for all periods.
4. Capitalise IDC* Add the calculated IDC to the project’s total cost.

5. Ensure this aligns with the project’s capitalisation policy and accounting standards. Example IDC Calculation* Let’s walk through a simplified example:

   1. Construction period: 2 years
   2. Total debt: $100 million
   3. Interest rate: 5% per annum

   4. Drawdown schedule:  — Year 1: $40 million (evenly throughout the year)  — Year 2: $60 million (evenly throughout the year)Calculation:

   5. Year 1 average balance: $20 million IDC Year 1 = $20 million * 5% = $1 million

   6. Year 2 average balance: $70 million IDC Year 2 = $70 million * 5% = $3.5 millionTotal IDC = $1 million + $3.5 million = $4.5 million Best Practices for IDC Modelling* 1. Use Dynamic Formulas: Link your IDC calculations to your debt drawdown and CAPEX schedules for flexibility.
   7. Consider Interest Rate Scenarios: Model different interest rate scenarios to understand the potential impact on total project cost.
   8. Align with Lender Agreements: Ensure your IDC modelling aligns with any specific terms in your financing agreements.
   9. Monitor Capitalisation Limits: Be aware of any limits on IDC capitalisation imposed by accounting standards or project agreements.
   10. Create Clear Documentation: Document your IDC assumptions and calculations for stakeholders and auditors. ConclusionAccurately modelling Interest During Construction is a critical component of project finance. It impacts the total project cost and influences funding requirements and overall project viability. By following the steps and best practices outlined in this post, you can create more accurate and robust financial models for your projects.

Remember, while IDC modelling can be complex, it’s an essential skill for any project finance professional. As with all aspects of financial modelling, accuracy, clarity, and attention to detail are key to success.

View Details

Top 5 Must-Read Books for Aspiring Investment BankersMatthew Bernath* August 18, 2024 * ,1:47 pm * ,Financial Modelling, Recommendations Breaking into the world of investment banking requires more than just a strong academic background—it demands a deep understanding of finance, markets, and the strategic thinking that drives successful deals. For aspiring investment bankers, building this knowledge is crucial, and one of the best ways to do so is by immersing yourself in the right literature. Below, I’ve compiled a list of the top five books that every aspiring investment banker should read. These books cover essential topics ranging from financial modelling and valuation to the intricacies of M&A deals and the culture of investment banking.

Investment Banking: Valuation, Leveraged Buyouts, and Mergers & Acquisitions by Joshua Rosenbaum and Joshua PearlWhy I Recommend It: This book is often considered the go-to resource for understanding the core concepts of investment banking. Rosenbaum and Pearl offer a clear and detailed explanation of valuation methodologies, leveraged buyouts (LBOs), and mergers & acquisitions (M&A). The book is filled with real-world examples and case studies, making it an invaluable resource for anyone looking to enter the field.

Key Takeaways:

– Comprehensive coverage of valuation techniques, including DCF, comparable companies, and precedent transactions.

– In-depth exploration of LBOs and M&A processes.

– Practical examples that bridge theory and practice.

Buy on Amazon

The Intelligent Investor by Benjamin GrahamWhy I Recommend It: While not specific to investment banking, “The Intelligent Investor” is a classic that lays the foundation for understanding value investing and the principles of sound financial analysis. Graham’s philosophy of “value investing” is a critical concept that every aspiring banker should understand, as it influences many aspects of investment decision-making.

Key Takeaways:

– Principles of value investing and margin of safety.

– Insights into the psychology of investing and market behavior.

– Timeless wisdom on financial analysis and risk management.

Buy on Amazon

Barbarians at the Gate: The Fall of RJR Nabisco by Bryan Burrough and John HelyarWhy I Recommend It: “Barbarians at the Gate” is more than just a gripping story—it’s an insightful look into one of the most famous leveraged buyouts in history. This book provides a detailed account of the corporate greed, power struggles, and financial machinations behind the RJR Nabisco takeover. For aspiring investment bankers, it’s a fascinating study of high-stakes finance in action.

Key Takeaways:

– A deep dive into the world of leveraged buyouts and corporate takeovers.

– Real-world insights into the culture of Wall Street and investment banking.

– Lessons on negotiation, strategy, and the complexities of large deals.

Buy on Amazon

Monkey Business: Swinging Through the Wall Street Jungle by John Rolfe and Peter TroobWhy I Recommend It: For those curious about the day-to-day life of a junior investment banker, “Monkey Business” offers a candid and humorous look behind the scenes. Rolfe and Troob, both former investment bankers, share their experiences of the demanding and often absurd world of banking. It’s a must-read for anyone considering a career in the industry.

Key Takeaways:

– An insider’s view of the culture and challenges of investment banking.

– Real-life stories that highlight the highs and lows of the job.

– Practical advice for surviving and thriving in a fast-paced environment.

Buy on Amazon

Liar’s Poker: Rising Through the Wreckage on Wall Street by Michael LewisWhy I Recommend It: Michael Lewis’s “Liar’s Poker” is a classic memoir that chronicles his experience as a bond salesman at Salomon Brothers during the 1980s. The book provides a revealing look at the excesses of Wall Street, the culture of investment banking, and the personalities that drive the industry. It’s an engaging read that offers both entertainment and valuable lessons about the financial world.

Key Takeaways:

– A firsthand account of life inside one of Wall Street’s most powerful firms.

– Insights into the bond market and the role of traders in investment banking.

– A critical examination of the culture of greed and risk-taking in finance.

Buy on Amazon

ConclusionConclusionThese five books provide a comprehensive foundation for anyone aspiring to enter the world of investment banking. From technical skills in valuation and financial modelling to real-world insights into the culture and challenges of the industry, these books offer a wealth of knowledge that will prepare you for a successful career in investment banking. Whether you’re looking to sharpen your analytical skills, understand market dynamics, or simply get a glimpse of what life is like on Wall Street, these reads are essential additions to your library.

Disclaimer: The links provided are Amazon affiliate links, which means I may earn a small commission at no additional cost to you if you decide to make a purchase through them.

View Details

My Top 5 Must-Read Books on Project FinanceMatthew Bernath* August 9, 2024 * ,4:45 pm * ,Financial Modelling, Project Finance, Recommendations Project finance is a complex yet rewarding field that requires a deep understanding of various financial, legal, and operational aspects. Whether you’re new to the field or a seasoned professional, having the right resources can significantly impact your understanding and execution of project finance deals. Below, I’ve compiled a list of my top five books on project finance, each offering unique insights and valuable knowledge. These books have been instrumental in shaping my understanding of the industry, and they can do the same for you.

Project Finance in Theory and Practice: Designing, Structuring, and Financing Private and Public Projects by Stefano GattiWhy I Recommend It: This book provides a comprehensive overview of project finance, combining theoretical frameworks with practical case studies. Gatti’s approach to explaining the nuances of project structuring, risk management, and financial modelling makes it an essential read for anyone involved in project finance.

My Key Takeaways:

– In-depth analysis of project risk management.

– Practical insights into the design and structuring of project finance deals.

– Detailed case studies that illustrate real-world applications.

Buy on Amazon

Principles of Project Finance by E. R. YescombeWhy I Recommend It: Yescombe’s book is a classic. It provides a clear and thorough explanation of the principles that underpin project finance. It’s particularly valuable for those looking to understand the financial and contractual structures that are key to successful project finance transactions.

My Key Takeaways:

– Comprehensive coverage of project finance principles and structures.

– Detailed discussion on the role of sponsors, lenders, and government entities.

– Practical advice on risk allocation and mitigation strategies.

Buy on Amazon

International Project Finance in a NutshellWhy I Recommend It: This book is an excellent resource for understanding the international aspects of project finance. It breaks down the complexities of cross-border projects, focusing on the legal, financial, and regulatory challenges that often arise.

My Key Takeaways:

– Insightful analysis of international project finance.

– Strategies for managing cross-border risks and challenges.

– Overview of international financial markets and their impact on project finance.

Buy on Amazon

The Law and Business of International Project Finance by Scott L. HoffmanWhy I Recommend It: Hoffman’s book is indispensable for understanding the legal frameworks surrounding international project finance. It covers everything from contract negotiation to dispute resolution, making it a valuable resource for legal and finance professionals.

My Key Takeaways:

– Comprehensive coverage of the legal aspects of international project finance.

– Practical guidance on contract negotiation and dispute resolution.

– In-depth analysis of regulatory compliance in different jurisdictions.

Buy on Amazon

Investment Project Design: A Guide to Financial and Economic Analysis with Constraints by Lech Kurowski and David SussmanWhy I Recommend It: This book takes a unique approach by combining financial and economic analysis with project design. It’s a great resource for those involved in the early stages of project development, offering practical tools for assessing project viability and sustainability.

My Key Takeaways:

– Integration of financial and economic analysis into project design.

– Practical tools for evaluating project viability and sustainability.

– Guidance on managing financial and operational constraints.

Buy on Amazon

ConclusionThese five books are great resources for anyone looking to deepen their understanding of project finance. Whether you’re involved in structuring deals, managing risks, or navigating the legal complexities of international projects, these books provide the knowledge and insights needed to excel in the field. I truly believe that by investing time in reading and understanding these works, you will enhance your ability to navigate the complex but exciting world of project finance successfully.

View Details

Financial Modelling for Mergers and Acquisitions: A Practical ApproachMatthew Bernath* July 8, 2024 * ,10:03 am * ,Financial Modelling, M&A Project finance involves complex and high-value transactions that require meticulous legal oversight. Understanding the legal framework and considerations is crucial for successfully executing any project finance initiative. This blog post provides an overview of the key legal aspects of project finance, including the intricacies of contracts, agreements, and compliance issues that stakeholders must navigate.

Key Considerations in M&A Financial Modelling​Understanding the ObjectivesStrategic Fit: Assess the strategic rationale behind the merger or acquisition and determine how the deal aligns with the acquiring company’s long-term goals.

Synergies: Identify potential synergies and cost savings that can be realised post-merger, such as economies of scale, increased market share, and enhanced operational efficiencies.

Comprehensive Due DiligenceFinancial Health: Conduct a thorough analysis of the target company’s financial statements to understand its revenue streams, profitability, cash flow, and debt levels.

Legal and Compliance Issues: Review any legal, regulatory, or compliance issues that could impact the transaction.

Market Position: Evaluate the target company’s market position, competitive landscape, and growth prospects.

Valuation MethodsDiscounted Cash Flow (DCF): Estimate the present value of future cash flows generated by the target company. This method is widely used for its focus on intrinsic value.

Comparable Company Analysis: Compare the target company with similar companies in the industry to determine its relative value.

Precedent Transactions: Analyse past M&A deals in the same sector to gauge market trends and valuation multiples.

Steps in Building an M&A Financial ModelGather Historical DataCollect historical financial data for both the acquiring and target companies. This includes income statements, balance sheets, and cash flow statements.

Develop Revenue ProjectionsRevenue Streams: Identify and project the combined entity’s revenue streams. Consider growth rates, market conditions, and competitive factors.

Synergy Realisation: Incorporate revenue synergies expected from the merger, such as cross-selling opportunities and market expansion.

Expense AnalysisOperating Costs: Project operating expenses, including cost synergies such as reduced overhead and procurement efficiencies.

Integration Costs: Estimate the costs of integrating the two companies, including IT systems, staff training, and potential redundancies.

Capital Expenditure and Working CapitalCapEx Requirements: Forecast capital expenditure to support the combined entity’s growth plans.

Working Capital: Estimate changes in working capital requirements post-merger, considering inventory management, receivables, and payables.

Debt and Financing StructureDebt Levels: Evaluate the debt levels of the combined entity and its impact on financial stability.

Financing Needs: Determine if additional financing is required to complete the transaction and assess the terms of new debt or equity issuance.

Build the Integrated Financial ModelPro Forma Financial Statements: Create the combined entity’s pro forma income statements, balance sheets, and cash flow statements.

Scenario Analysis: Perform sensitivity analysis to understand the impact of different assumptions on the financial projections.

Valuation Analysis: Use the projected financials to conduct a valuation analysis, applying the DCF method, comparable company analysis, and precedent transactions.

Assess Financial ImpactEarnings Per Share (EPS) Accretion/Dilution: Calculate the impact of the transaction on the acquirer’s EPS to determine if the deal is accretive or dilutive.

Return on Investment (ROI): Evaluate the expected return on investment from the merger or acquisition.

ConclusionBuilding a financial model for M&A activities requires a detailed and systematic approach. By understanding the strategic objectives, conducting comprehensive due diligence, and following a structured process, finance professionals can create robust models that provide valuable insights into the transaction’s financial impact. These models support decision-making and help negotiate and structure the deal to maximise value for stakeholders.

Stay tuned to the Financial Modelling Podcast for more insights and practical tips on navigating the complexities of financial modelling in various business scenarios.

View Details

Navigating Legal Aspects in Project FinanceMatthew Bernath* July 1, 2024 * ,8:23 pm * ,Financial Modelling, Project Finance Project finance involves complex and high-value transactions that require meticulous legal oversight. Understanding the legal framework and considerations is crucial for successfully executing any project finance initiative. This blog post provides an overview of the key legal aspects of project finance, including the intricacies of contracts, agreements, and compliance issues that stakeholders must navigate.

Understanding Project Finance Contracts and AgreementsProject finance transactions typically involve multiple contracts that can be intricate and interdependent. These contracts are designed to delineate the roles, responsibilities, and risks of various parties involved.

1. Loan Agreements: Loan agreements are at the core of project finance. They detail the terms under which financiers provide funds to the project. These agreements cover interest rates, repayment schedules, and conditions for fund disbursement.

2. Concession Agreements: Often used in infrastructure projects like roads, bridges, and utilities, concession agreements grant private companies the right to operate public assets for a specified period. Legal considerations include terms of operation, public interest safeguards, and reversion rights.

3. Offtake Agreements: These are crucial for ensuring a project’s economic viability. Offtake agreements secure a market for the project’s output, power, minerals, or other commodities. They define pricing formulas, minimum purchase quantities, and penalties for non-compliance.

4. EPC Contracts: Engineering, Procurement, and Construction (EPC) contracts are widespread in project finance. They outline the project’s construction specifics, including timelines, specifications, and contractor duties. Legal clarity in EPC contracts helps prevent disputes related to project delays or defects.

5. Operation and Maintenance Agreements: These agreements are essential for the project’s long-term success. They ensure the project’s operational phase is managed efficiently and outline maintenance duties, performance standards, and operational budgets.

Navigating Compliance and Regulatory IssuesCompliance with local and international laws is a critical aspect of project finance that can influence every project stage.

• Environmental Laws: Projects, especially those in the energy and infrastructure sectors, must comply with environmental regulations. Legal teams must manage due diligence processes, obtain necessary environmental permits, and ensure compliance with environmental standards.
• Cross-Border Issues: For international projects, understanding and complying with all jurisdictions’ laws is imperative. This includes navigating foreign investment laws and taxation issues and understanding bilateral agreements that may impact project finance.

• Local Regulations: Adhering to local laws and regulations, including labour, safety, and construction standards, is essential. Legal expertise is crucial in interpreting these regulations and integrating compliance into project contracts. Mitigating Legal RisksLegal risks in project finance can derail even the most well-planned projects. Key strategies for mitigating these risks include:

• Thorough Due Diligence: Conducting comprehensive legal due diligence before project commencement can identify potential legal issues and allow for early resolution.

• Robust Contractual Frameworks: Well-drafted contracts that clearly define the rights and obligations of all parties can reduce the likelihood of disputes.
• Legal Risk Management Plans: Developing and implementing a legal risk management plan can help monitor compliance and manage legal issues as they arise. ConclusionThe legal landscape of project finance is complex and fraught with challenges. However, these challenges can be effectively managed with careful planning, expert legal guidance, and a thorough understanding of the necessary agreements and compliance requirements. Legal diligence protects stakeholders’ interests and ensures the financial project’s long-term success and sustainability.

Stay tuned to the Financial Modelling Podcast for more insights into the intersection of finance, law, and project management.

View Details

How to Effectively Present Financial Models to StakeholdersMatthew Bernath* June 29, 2024 * ,3:28 pm * ,Financial Modelling Presenting financial models to stakeholders, particularly those who may not be experts in financial terminology or complex modelling techniques, is crucial for any financial analyst or business professional. A well-executed presentation can not only ensure understanding but also facilitate informed decision-making. This blog post provides the following:

• Comprehensive guidance on how to present complex financial models to non-expert stakeholders.
• Focusing on clarity.
• Effective use of visual aids.
• Effective communication of key takeaways. Understand Your AudienceBefore you begin preparing your presentation, it’s important to understand who your audience is. Are they senior management, potential investors, or non-finance department heads? Knowing your audience helps tailor your presentation to their expertise and interests, focusing on the model’s most relevant aspects.

Simplify Complex ConceptsFinancial models can be complex, but how you present them shouldn’t be. Start by simplifying your language:

• Avoid jargon and technical terms unless absolutely necessary.
• Use simple, concise language to explain the concepts.

• Break down complex calculations into understandable steps. Use Visual Aids WiselyVisual aids can transform your presentation, making complex data more accessible:

• Charts and Graphs: Visually represent data using bar charts, line graphs, and pie charts. Make sure they are clearly labelled and not overly cluttered.

• Flow Charts: Show the flow of calculations or the logic of the model with flow charts.
• Tables: Use tables to present data clearly, but ensure they are not too dense. Highlight the key figures.

• Dashboards: Summarize key outputs of the model in a dashboard format, showing the most important metrics at a glance. Focus on Key Outputs and InsightsWhile the inner workings of your model are important, stakeholders are most often interested in the outcomes:

• Clearly state the key findings or insights from the model.

• Discuss the implications of these findings for the business or project.

• Be ready to answer what these findings mean in a practical, actionable way. Prepare for QuestionsBe well-prepared to answer detailed questions about your model:

• Understand every aspect of your model, including the assumptions and variables used.

• Think about potential questions that might arise and prepare your answers in advance.

• If a question is too complex to answer on the spot, offering a detailed answer after the meeting is acceptable. Practice Your PresentationPractice delivering your presentation multiple times:

• Try presenting to a colleague or a friend first and ask for feedback.

• Check the timing of your presentation to ensure it fits within the allotted time.
• Make sure you can navigate through your visual aids smoothly. ConclusionEffectively presenting a financial model to stakeholders is more than just showing your work—it’s about telling a story they can understand and use. By simplifying complex information, effectively using visual aids, focusing on key outputs, and thoroughly preparing for questions, you can ensure that your stakeholders understand your model and make informed decisions based on the insights it provides.

View Details

How to Build a Robust Financial Model for StartupsMatthew Bernath* June 26, 2024 * ,7:38 pm * ,Financial Modelling For startups, a robust financial model is not just a tool for attracting investors; it’s a crucial part of strategic planning that helps you understand your business’s potential and map out its future. Whether pitching to investors, applying for loans, or planning your growth strategy, a well-constructed financial model can make all the difference. You can build one tailored specifically for your startup’s needs.

Step 1: Define Your PurposeBefore you dive into numbers, define what you want your financial model to achieve. Are you using it to secure funding, guide internal strategy, or both? Your end goal will influence how you structure the model and the data you must include.

Step 2: Gather Historical DataIf your startup is already operational, gather as much historical financial data as available. This includes sales figures, expenses, capital expenditures, and cash flow. Historical data provides a foundation for your model and helps validate your assumptions.

Step 3: Set Up Your AssumptionsThe next step is to list out the key assumptions of your business model. Assumptions could be about market size, growth rate, sales conversion rates, pricing strategy, customer acquisition costs, churn rate, etc. Be realistic with your assumptions and base them on industry benchmarks, market research, and historical data.

Step 4: Project Your RevenuesStart by projecting your revenues, which are often the most complex part of a financial model. Use your sales assumptions to estimate the number of units you expect to sell and at what price point. Consider different revenue streams if applicable. Be sure to factor in seasonality and market trends.

Step 5: Forecast Operating ExpensesList all expected operating expenses, including salaries, rent, utilities, marketing, and production costs. Break them down into fixed and variable costs. Accurately forecasting expenses is critical for understanding your startup’s cash flow and profitability.

Step 6: Include Funding Sources and InvestmentsDetail any known capital injections from venture capital, loans, or equity investments. Also, outline how much capital expenditure (CapEx) is needed for significant purchases or investments in technology and physical assets.

Step 7: Construct the Financial StatementsIntegrate the data into three main financial statements:

• Income Statement (Profit and Loss Account): Shows long-term profitability.
• Balance Sheet: Provides a snapshot of your financials at a specific point in time, detailing assets, liabilities, and equity.
• Cash Flow Statement: Highlights how changes in the Balance Sheet and Income affect cash and cash equivalents, breaking it down into operations, investing, and financing activities. Step 8: Conduct Risk Analysis and Sensitivity TestsUnderstand the risks involved by conducting sensitivity analysis on key variables. Adjust your assumptions to see how changes impact your profitability and cash flow. This can help identify potential financial pressure points.

Step 9: Continuously Update Your ModelA financial model is not a one-time effort. Regularly update it with actual financial results and revise projections and assumptions as your startup grows and market conditions change.

ConclusionBuilding 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. Remember, the key to effective financial modelling is realistic assumptions and regular updates to reflect the evolving business environment.

Stay tuned to the Financial Modelling Podcast for more tips and insights into effectively managing your startup’s finances!

View Details

Why Project Finance Uses Special Purpose Vehicles (SPVs)Matthew Bernath* June 25, 2024 * ,7:51 pm * ,Project Finance In today’s interconnected global economy, export credit finance is a pivotal tool for companies looking to expand into international markets. It not only facilitates the export and import of goods and services but also ensures that companies can compete globally without bearing excessive risk. This blog post, brought to you by the Financial Modelling Podcast, explores the intricacies of export credit finance, its benefits, challenges, and its role in global trade enhancement.

What is a Special Purpose Vehicle (SPV)?An SPV is a legal entity created solely to execute a specific project. It is a separate company with its own assets and liabilities, created for a specific and limited purpose – often to isolate financial risk. An SPV is the primary company in project finance for all project-related contracts and operations.

Key Reasons for Using SPVs in Project Finance1. Risk Isolation: One of the primary reasons for using an SPV in project finance is risk isolation. By segregating the project into a standalone entity, the SPV limits financial risk to the assets held within it, protecting the parent company and other assets from the repercussions of potential project failure. 2. Bankruptcy Remote: SPVs are often structured to be bankruptcy remote, meaning that in the case of bankruptcy, the SPV’s financial difficulties will not directly impact the parent company’s financial health. This makes the project more attractive to lenders and investors, as the risks associated with the project are confined within the SPV. 3. Asset Shielding: Project sponsors can shield these assets from external claims by housing specific assets and liabilities in an SPV. This legal and financial separation is crucial in scenarios involving multiple parties, and complex financing structures require clear delineation of asset control. 4. Enhanced Creditworthiness: An SPV can sometimes achieve a better credit rating than its parent company because the SPV’s financial risk is limited to the specific project and does not include broader corporate risks. This can lead to more favourable borrowing terms, such as lower interest rates or more capital. 5. Simplified Project Management: Managing a project through an SPV simplifies the process because all operations, revenues, and expenses are consolidated under one entity. This centralisation makes monitoring project performance, managing cash flows, and complying with regulatory requirements easier. 6. Tax Benefits: In some jurisdictions, using an SPV can offer tax advantages, such as reduced capital gains taxes, making the project financially more viable. The specific structure and location of the SPV can be optimised to take advantage of these benefits. 7. Attracting Investment: SPVs allow for more flexible investment options. Investors can invest directly in the project without exposure to the parent company’s broader financial risks. This structure attracts private equity firms and institutional investors looking for direct exposure to specific projects. ConclusionThe 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. SPVs facilitate the management and financing of large projects and enhance their appeal to a broad spectrum of investors by mitigating risks and improving financial governance. As the landscape of global finance grows ever more complex, the role of SPVs in project finance will likely become even more pivotal.

For more insights into financial structuring and project finance, tune into the Financial Modelling Podcast, where experts discuss the latest trends and techniques in the finance world.

View Details

Unlocking Global Trade: A Deep Dive into Export Credit FinanceMatthew Bernath* June 14, 2024 * ,11:02 am * ,Financial Modelling, Project Finance In today’s interconnected global economy, export credit finance stands out as a pivotal tool for companies looking to expand into international markets. It not only facilitates the export and import of goods and services but also ensures that companies can compete on a global scale without bearing excessive risk. This blog post, brought to you by the Financial Modelling Podcast, explores the intricacies of export credit finance, its benefits, challenges, and the role it plays in global trade enhancement.

What is Export Credit Finance?Export credit finance involves financial instruments and products that exporters use to reduce risks associated with receiving payment from foreign buyers. Typically backed by national export credit agencies (ECAs), these financial arrangements help companies mitigate the risks of non-payment by providing loans, insurance, and guarantees to both exporters and foreign buyers.

Key Components of Export Credit FinanceExport Credit Agencies (ECAs) are quasi-governmental institutions that provide government-backed loans, insurance, and guarantees to support domestic companies in their export endeavours. They play a crucial role in managing political and commercial risks.

There are various types of financing:

• Direct Lending: ECAs provide direct loans to foreign buyers to finance their purchase of exports.
• Buyer’s Credit: This involves loans provided directly to an overseas buyer to finance the purchase of capital goods and services.
• Supplier’s Credit: Here, the exporter extends credit to the buyer, with the ECA covering the risk of buyer default. Benefits of Export Credit Finance* Risk Reduction: Export credit agencies absorb significant risks, including political and commercial risks, thereby safeguarding the exporter’s interests.
• Competitive Advantage: Exporters can offer more attractive credit terms to overseas buyers, supported by the security of ECAs, making their offerings more competitive.
• Market Expansion: By securing export transactions, companies can explore and penetrate new international markets more confidently and extensively. Challenges and Considerations* Regulatory Hurdles: Export credit finance is subject to international regulations, including agreements made under the OECD Arrangement on Officially Supported Export Credits, which can limit the terms and conditions of export credits.
• Economic and Political Risk: Despite ECA coverage, geopolitical and macroeconomic instabilities can still pose significant risks that need careful assessment.
• Dependency and Debt: Relying heavily on export credit facilities can lead some buyers or countries into problematic debt situations, necessitating responsible lending practices. Case Study: Boosting Infrastructure in Emerging MarketsConsider the role of export credits in financing infrastructure projects in Africa. ECAs like the U.S. Exim Bank and U.K. Export Finance have underwritten numerous projects, from renewable energy plants in South Africa to telecommunications infrastructure in Ghana. These projects not only support local economies but also open up new markets for international exporters.

ConclusionExport credit finance is a key enabler of global trade, providing the necessary support for companies to expand internationally while mitigating inherent risks. As global trade dynamics evolve, the importance of understanding and leveraging such financial instruments becomes increasingly crucial for businesses aiming to grow beyond their borders.

Stay tuned to the Financial Modelling Podcast for more insights into how financial strategies and tools can help drive business success in international markets. Whether you’re an established exporter or a startup looking to make a mark globally, understanding the nuances of export credit finance is essential.

View Details

Understanding the Cash Flow Waterfall in Project FinanceMatthew Bernath* May 30, 2024 * ,1:52 pm * ,Financial Modelling, Project Finance In the world of project finance, the term “cash flow waterfall” describes a crucial financial structure that dictates the order in which generated cash flow is distributed to various stakeholders involved in a project. This mechanism ensures funds are allocated and used effectively, promoting financial stability and satisfying all parties’ contractual and operational needs. This article delves into the importance, structure, and strategic implications of cash flow waterfalls in project finance.

What is a Cash Flow Waterfall in Project Finance?A cash flow waterfall is a sequential method of distributing the cash flows from a project finance operation. It sets out the priority sequence in which revenue from the project is allocated to different expenses, debts, reserves, and equity distributions. This structured approach is essential for managing the inherently high risks associated with financing large-scale infrastructure and industrial projects.

Key Components of a Cash Flow WaterfallThe cash flow waterfall model can vary between projects but typically includes several key components:

1. Operating Costs: The first allocation of cash flow generally covers the project’s operational costs and maintenance. Ensuring the project’s operational viability is a priority.
2. Senior Debt Service: The next step usually involves making scheduled debt service payments on senior loans. These loans are often secured by the project’s assets and have priority over other forms of financing.
3. Reserve Accounts: Before any profits are distributed, cash is often set aside in various reserve accounts, including funds for future capital expenditure, debt service reserves, or maintenance reserves.
4. Subordinated Debt: Once senior debts and necessary reserves are funded, any remaining cash flow can go towards servicing subordinated or mezzanine debt, which carries higher risk and, therefore, usually commands a higher interest rate.

5. Equity Distributions: Any remaining cash flows after all debts and reserves can then be distributed to equity investors as a return on their investment. Benefits of a Cash Flow WaterfallThe structured approach of a cash flow waterfall offers several benefits:

6. Risk Mitigation: By prioritizing debt service and operational costs, the structure ensures that the project remains financially healthy and operationally sound.

7. Investor Assurance: Investors and lenders are more likely to commit funds to a project if there is a clear, contractual stipulation on how cash flows will be distributed, providing them visibility and predictability of returns or debt repayment.

8. Regulatory Compliance: Waterfall structures help ensure that funds are available to meet regulatory requirements, such as environmental regulations or mandatory reserve contributions. Challenges and ConsiderationsDespite its benefits, the cash flow waterfall structure is not without challenges:

9. Complexity in Management: Managing the distributions according to the waterfall can be complex, especially when dealing with multiple stakeholders and fluctuating project revenues.

10. Inflexibility: Once the terms of the waterfall are contractually agreed upon, altering them can be difficult, which might limit the project company’s ability to respond to unexpected financial needs or opportunities. Strategic Importance in Project FinanceIn project finance, the cash flow waterfall is more than just a financial tool – it is a strategic element influencing decision-making throughout the project lifecycle. It affects how projects are financed, how risks are shared, and how rewards are distributed, playing a crucial role in the project’s overall financial strategy and structure.

ConclusionThe 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. By understanding and strategically planning the cash flow waterfall, project sponsors and financiers can enhance the feasibility and attractiveness of major infrastructure projects, ensuring that all parties’ financial interests are aligned and protected. As such, mastering this concept is essential for anyone involved in project finance’s complex yet rewarding arena.

View Details

Automating Excel Tasks with AI: Boosting Efficiency in Financial ModellingMatthew Bernath* May 29, 2024 * ,8:48 pm * ,Financial Modelling Automating Excel Tasks with AIIn the fast-paced world of finance, time is of the essence. As financial professionals, we constantly seek ways to streamline our workflows and reduce the time spent on repetitive tasks. Enter Artificial Intelligence (AI) and its integration with Microsoft Excel. By leveraging AI, we can automate mundane tasks, enhance data analysis, and make more informed decisions faster. In this post, we explore the transformative power of AI in Excel and how it can revolutionise financial modelling.

Flash Fill: Simplifying Data EntryOne of the most accessible AI features in Excel is Flash Fill. This tool detects patterns in your data and fills in the remaining cells based on a few examples you provide. It’s particularly useful for cleaning and transforming data without needing complex formulas.

Example: Suppose you have a list of unformatted phone numbers. By entering the desired format for a few entries, Flash Fill will automatically reformat all phone numbers, saving you significant time and effort.

Macros: Automating Routine ProcessesMacros allow you to record and replay a sequence of actions whenever needed. This is invaluable for tasks that must be performed regularly, such as generating monthly reports or formatting data.

Example: Imagine you need to create a monthly financial report with the same format each time. By recording a macro that formats the data, adds charts, and performs calculations, you can automate this process with a single click, ensuring consistency and saving time.

Power Automate: Advanced Workflow AutomationFor those seeking even more advanced automation, Power Automate (formerly Microsoft Flow) allows you to create workflows that integrate Excel with other apps and services. This cloud-based tool can automate everything from data collection to notifications.

Example: Suppose you receive daily sales data via email. You can create a flow in Power Automate that automatically extracts the data from the email attachment and updates your Excel sales report. This seamless integration can significantly reduce manual data entry and improve accuracy.

AI-Driven Functions: Enhanced Data AnalysisExcel’s AI-driven functions, such as Forecast Sheet and Ideas, bring advanced analytical capabilities to your fingertips. These tools can automate complex analyses and provide actionable insights based on your data.

Example: Using the Forecast Sheet function, you can create a forecast for future sales based on historical data. This predictive analysis helps plan inventory, allocate resources, and set realistic sales targets.

ConclusionIncorporating 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. Whether you’re using Flash Fill for data entry, macros for routine processes, Power Automate for complex workflows, or AI-driven functions for advanced analysis, the benefits are clear: increased efficiency and better decision-making.

View Details

Matthew BernathThe Role of Data in Strategic Dealmaking* May 17, 2024 * ,3:00 pm * ,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.Share this post

View Details

Exploring the Nuances of Valuation Financial Models: A Guide for Finance ProfessionalsValuation is the cornerstone of finance, encompassing everything from mergers and acquisitions to portfolio management and corporate finance. In this post, we’ll break down the types of valuation models, discuss their applications, and highlight best practices and common pitfalls.

Understanding the intrinsic value of a business is pivotal for financial analysts, investors, and corporate decision-makers alike. As we explore the intricate world of financial valuation models, we aim to equip you with the knowledge and tools needed to perform precise and insightful financial analysis.

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. Today, we will unpack various valuation techniques, each with its own unique approach and area of application. By the end of this discussion, you should have a clearer understanding of how these models work, their strengths and limitations, and how they can be applied in real-world scenarios to determine the value of an investment or company.

Types of Valuation ModelsDiscounted Cash Flow (DCF) Model

The DCF model is arguably the most detailed method of assessing a firm’s intrinsic value. It involves forecasting the free cash flows of a business and discounting them back to their present value using the company’s weighted average cost of capital (WACC). This model is particularly useful for stable, cash-generating businesses.

Comparable Company Analysis (Comp) Model

This relative valuation model estimates a company’s value based on the metrics of similar companies. By examining ratios such as P/E, EV/EBITDA, and others, financial analysts can determine how the market currently values companies in the same industry or sector.

Precedent Transaction Analysis

Often used in an M&A context, this model looks at past transactions of similar companies to determine an appropriate valuation multiple. It’s valuable for understanding the premium paid for control in acquisitions.

Leveraged Buyout (LBO) Model

Used primarily by private equity firms, the LBO model projects the potential returns of buying a company using a significant amount of borrowed money, restructuring it, and selling it at a profit.

Sum of the Parts Model

Useful for diversified companies, this model breaks down the value of each business segment independently and adds them up to calculate the total corporate value.

Applications and Best PracticesValuation models are indispensable in various scenarios, such as investment analysis, capital budgeting, financial reporting, and strategic planning. To achieve the best results, it’s critical to:

• Ensure Data Integrity: All financial models are only as good as the data inputted. Accurate, up-to-date financial data is essential.
• Understand the Business: Analysts must deeply understand the business and industry to make reasonable assumptions and forecasts.
• Sensitivity Analysis: Incorporating sensitivity analysis helps identify how changes in key assumptions impact the valuation.
• Continuous Learning: Financial modelling is dynamic; continuous learning and adaptation to new methods or changes in market conditions are crucial. Common Pitfalls to Avoid* Over-reliance on Historical Data: Markets evolve, and relying solely on historical data can lead to inaccurate valuations if the industry faces significant changes.
• Overly Optimistic Assumptions: Avoid unrealistic growth rates or cost savings, which can skew the model results.
• Ignoring Market Conditions: Economic and sector-specific factors can drastically affect valuations and should not be overlooked. ConclusionValuation financial models are powerful tools requiring analytical skills, critical thinking, and in-depth industry knowledge. Whether you’re a seasoned finance professional or new to the field, mastering these models can significantly enhance your analytical capabilities and decision-making processes.

By embracing best practices and staying aware of common pitfalls, finance professionals can leverage valuation models to provide strategic insights and drive business decisions. Remember, the key to effective financial modelling lies in a balanced approach of rigorous analysis, realistic assumptions, and continuous refinement.

View Details

Advanced Financial Modelling TechniquesUnveiling the Power of Monte Carlo AnalysisIn today’s fast-paced financial environment, the ability to predict and plan for uncertainty is more valuable than ever. Advanced financial modelling techniques, such as Monte Carlo analysis, play a crucial role in helping analysts and investors navigate the complexities of modern markets. This blog post delves into the depths of advanced financial modelling, with a special focus on the Monte Carlo method, exploring its applications, benefits, and how it can be used to enhance predictive accuracy and decision-making in finance.

The Essence of Advanced Financial ModellingAdvanced financial modelling involves using sophisticated algorithms and statistical tools to forecast the financial performance of projects or investments. These models are crucial for risk assessment, strategic planning, and investment decision-making. They incorporate various inputs, including hypothetical variables and real-world data, to simulate potential outcomes and inform better financial decisions.

Monte Carlo Analysis – A PrimerThe Monte Carlo analysis is at the heart of advanced simulation techniques—a method used extensively across finance sectors, including project finance, risk management, and investment analysis. Named after the famous Monte Carlo Casino due to its inherent randomness (and actually after a physicist’s aunt I believe, who gambled there, but I stand to be corrected!), this technique uses random sampling and statistical modelling to predict the probability of different outcomes when the intervention of random variables is present.

How Monte Carlo Analysis Works1. Definition of Probability Distributions: Initially, the model requires a clear definition of all relevant variables. For financial models, these could include interest rates, market risks, and other economic indicators, each described by a probability distribution. 2. Random Sampling: Monte Carlo analysis runs thousands, or even millions, of trials, each time picking random values for each variable from their respective distributions. 3. Calculation of Results: For each simulation or trial, the model calculates the results, which typically include NPV (Net Present Value), IRR (Internal Rate of Return), or other relevant financial metrics. 4. Analysis of Outcomes: The outcomes of each run are then compiled to create a probability distribution of all possible outcomes, providing a comprehensive view of potential risks and returns. Applications of Monte Carlo Analysis in Finance Risk Assessment: By simulating a wide range of outcomes based on the random variation of input variables, Monte Carlo analysis helps identify and quantify risks in investment portfolios or project finances. * Portfolio Management: This technique is used to simulate the future performance of a portfolio and assess the probability of achieving specific financial goals, helping portfolio managers in asset allocation and risk diversification. * Pricing Derivatives: Monte Carlo simulation is crucial for valuing options and derivatives where the payoff depends on the stochastic behaviour of the underlying assets over time. Benefits of Using Monte Carlo Analysis Handling Uncertainty: It provides a robust way to model scenarios involving significant uncertainty and to assess the impact of various risk factors on project or investment outcomes. * Broad Applications: It can be applied across different domains of finance, regardless of the complexity of the models. * Enhanced Decision Making: By providing a probabilistic range of outcomes rather than a single point estimate, it aids in making informed, data-driven decisions.

BUT BEWARE – the probability curve you use is key. I learnt this by building a Monte Carlo Simulation for a wind farm, but wind actually has a Weibull distribution.

ConclusionMonte Carlo analysis represents a pinnacle in the field of financial modelling, offering a sophisticated tool for managing the uncertainties inherent in today’s financial markets. Whether you are a financial analyst, a portfolio manager, or involved in corporate finance, integrating Monte Carlo simulations into your financial analysis toolkit can significantly enhance your ability to make informed decisions and strategically plan for the future.

For finance professionals looking to stay ahead of the curve, mastering Monte Carlo and other advanced modelling techniques is not just beneficial; it is essential. As markets continue to evolve, so too must our methods for understanding and forecasting their movements. Embrace the complexity, and let the data guide your decisions.

View Details

Investment Banking in the 1960s: A Look Back at a Transformative DecadeMatthew Bernath* November 18, 2023 * ,12:20 pm * ,Financial Modelling The 1960s was a transformative decade in many respects—socially, culturally, and economically. The landscape of the financial world, too, was undergoing a sea change. Investment banking during this era was marked by a series of developments, both progressive and disruptive, that would shape the industry for years to come. This blog post explores the key aspects of what investment banking was like in the 1960s.

Regulatory EnvironmentThe 1960s was a time when financial regulations were considerably lax compared to today’s environment. The Glass-Steagall Act, which separated commercial and investment banking, was still in effect, but enforcement was relatively lenient, providing a more flexible operational structure for investment banks.

Dominance of the 'White Shoe' FirmsThe term ‘White Shoe Firm’ refers to the old, established investment banking firms that dominated Wall Street. Companies like Goldman Sachs, Morgan Stanley, and Merrill Lynch had a strong grip on high-profile deals, M&A activities, and IPOs. Their influence was monumental and largely unchallenged during this era.

Role in the EconomyInvestment banks played a key role in fuelling industrial growth by connecting capital with opportunity. This was especially true in the technology and manufacturing sectors. They facilitated IPOs and underwrote securities, essentially acting as the middlemen between companies in need of capital and investors seeking opportunities.

Introduction of New Financial InstrumentsDuring the 1960s, the industry began to experiment with new types of financial instruments. For example, the ‘negotiable certificate of deposit’ was introduced, providing corporations with a new avenue to raise short-term funds. Such innovations added complexity and diversity to the services offered by investment banks.c

International ExpansionThe 1960s also saw American investment banks starting to spread their wings globally. As post-war reconstruction gained momentum, especially in Europe, American financial institutions started establishing overseas branches to tap into emerging markets.

The Bull Market and Subsequent DeclineThe decade started with a robust bull market, encouraging aggressive investments and speculative activities. However, the market was volatile, and the late 1960s saw a decline that led to a bear market, impacting investment banking revenues and initiating a period of introspection in the industry.

Investment banking in the 1960s was marked by dominance, innovation, and expansion, albeit accompanied by the risks of a volatile market. The era laid the groundwork for many of the practices and structures we see in modern investment banking. It was a decade of growth but also one that taught hard lessons, which would become the guiding principles for future regulatory measures and risk management practices.

View Details

Harnessing the Power of Data in Project FinanceMatthew Bernath* November 18, 2023 * ,12:12 pm * ,Data analytics, Financial Modelling, Project Finance With a background in data analytics and project finance, I have witnessed firsthand the transformative power of data in steering financial decisions and shaping project outcomes. My journey in this field has shown me the unique intricacies of harnessing data for financial success. Alternative Data has the potential to enhance the bankability of project finance deals, thereby enabling the development of critical infrastructure globally.

Movement data, through its detailed insights into passenger flow and commuting patterns, can greatly enhance the bankability of transport hubs by providing tangible evidence of its potential for high user traffic The Importance of Alternative Data in Project FinanceAlternative data, which includes non-traditional data sources like satellite imagery and transactional data, is becoming increasingly vital in project finance. This data offers a fresh lens through which to evaluate investment opportunities and risks. For instance, satellite data can provide crucial insights into weather patterns in a wind project financing scenario, directly impacting project viability. Similarly, in financing a consumer-facing infrastructure project, transactional data offers a detailed understanding of customer behaviour and market trends, proving indispensable in the valuation process.

Building Effective Data EcosystemsThe concept of a Data Ecosystem encompasses the various elements involved in data management, including storage, analysis, and security. My focus on building data ecosystems that are secure and privacy-centric and enable economic analysis has led me to believe that these can be used for project finance dealmaking. This involves the careful selection of technologies and practices that safeguard data integrity and confidentiality while enabling seamless integration and accessibility for decision-making purposes – to lenders and project sponsors alike.

The role of a well-structured data ecosystem in project finance, especially when it comes to funding large-scale infrastructure projects, can prove to be critical. These data ecosystems offer several significant benefits.

A robust data ecosystem enables bankability in infrastructure finance by providing comprehensive, accurate, and timely data, crucial for assessing project viability, risk, and return on investment.Data Ecosystem Benefits for Project Finance* Enhanced Risk Assessment and Management: Large-scale infrastructure projects entail substantial financial and operational risks. An efficient data ecosystem allows for the aggregation and analysis of vast amounts of anonymised data, which can uncover patterns and trends not visible through traditional data analysis methods. For instance, by analysing traffic flow data, investors can better understand the potential success of a new toll road project and identify ongoing project risks. * Improved Investment Decision-Making: The ability to integrate and analyse diverse data sets, including economic indicators, demographic trends, and environmental impacts, provides a comprehensive view of a project’s potential. This holistic data analysis approach helps make more informed investment decisions, ensuring that funds are allocated to projects with the highest potential for success and societal impact. * Facilitating Public-Private Partnerships: Large infrastructure projects often involve collaboration between public and private sectors. A robust data ecosystem can help bridge the information gap between these entities. By providing aggregated, anonymised insights, these systems ensure that both parties have access to the same information, fostering transparency and trust, which are crucial for the success of such partnerships. * Predictive Analytics for Future Planning: Predictive models built within these ecosystems can forecast future trends and potential issues, allowing for proactive measures. This aspect is particularly crucial in infrastructure projects with long lifespans and are subject to various external factors such as economic shifts, policy changes, and environmental conditions. I would love to see predictive analytics used to identify public infrastructure faults that can be addressed quickly. * Cost Efficiency and Resource Optimisation: Data ecosystems enable the identification of cost-saving opportunities and optimisation of resources. For example, by analysing construction data, project managers can identify inefficiencies and allocate resources more effectively, reducing both time and cost overruns. * Enhancing Sustainability and Compliance: In today’s world, there is a growing emphasis on sustainable development. Data ecosystems can track and report on various sustainability metrics, ensuring that projects adhere to environmental regulations and contribute positively to societal goals. Data Ecosystems can be key to enabling ESG goals and reporting. * Enabling Dynamic Monitoring and Management: The ability to continuously monitor project performance through real-time data analysis allows for quick adjustments and dynamic management. This agility is particularly valuable in large-scale projects where conditions and requirements can change rapidly. In summary, the development of secure, efficient, and privacy-preserving data ecosystems has the ability to play a critical role in advancing project finance, particularly for large-scale infrastructure projects. These systems enhance decision-making and risk management and foster collaboration, sustainability, and operational efficiency, ultimately leading to more successful and impactful projects.

Insights from Financial Modelling PodcastThrough my Financial Modelling Podcast, I’ve had the opportunity to engage with industry experts and discuss various aspects of project finance and data analytics. Key takeaways from these discussions include the increasing relevance of predictive analytics in financial modelling and the necessity of integrating qualitative data with quantitative analysis. These insights are particularly applicable in project finance, where the ability to forecast and mitigate risks can significantly influence the success of a project.

Expanding on my experiences with the Financial Modelling Podcast, I have had the privilege of interviewing a range of experts specialising in hedging strategies and project finance. These conversations have offered deep insights into how predictive analytics and integrated data approaches are reshaping the landscape of project finance.

• Integrating Qualitative and Quantitative Data: One of the key insights from these interviews has been the importance of integrating qualitative data (such as political climate, regulatory changes, and market sentiments) with quantitative data in financial models. This comprehensive approach provides a more holistic view of a project’s potential risks and returns, enabling more informed decision-making.
• Dynamic Hedging Strategies: Several experts have emphasised the need for dynamic hedging strategies that can adapt to changing market conditions. This agility is particularly crucial in long-term projects where fixed hedging strategies may not be sufficient to address evolving risks.
• Educating Stakeholders on Risk Management: A significant aspect of these discussions has been the importance of educating stakeholders, including investors and project managers, on the complexities of hedging and risk management. This knowledge is vital for ensuring that all parties involved in a project understand the risk landscape and the rationale behind financial decisions.
• The Future of Hedging in Project Finance: The experts have shared their perspectives on how emerging technologies and data analytics tools will continue to evolve hedging practices. The integration of AI and machine learning in financial modelling is expected to further enhance the accuracy and effectiveness of risk assessment and mitigation strategies. The insights I’ve gained from these interviews have significantly enriched my understanding of the complexities of project finance and the critical role of managing financial risks. The ability to forecast and adapt to changing market conditions while integrating diverse data sources is essential for the success of any large-scale project.

Future Trends and PredictionsLooking towards the future, I anticipate a continued evolution in data analytics and project finance. Emerging trends, such as using artificial intelligence and machine learning in financial modelling, are poised to revolutionise the industry. These technologies will enhance the accuracy of financial projections and enable more nuanced risk assessments. I also predict a greater emphasis on sustainability and social impact in project finance, where data analytics will play a pivotal role in identifying and evaluating environmentally and socially responsible investment opportunities.

I am very excited by the potential for alternative data and advanced data analytics in project and infrastructure finance. As we progress, the ability to effectively harness and interpret data will become increasingly critical in guiding investment decisions and driving project success.

View Details

The Pivotal Role of Alternative Data in Hedge Fund StrategiesMatthew Bernath* November 7, 2023 * ,4:11 pm * ,Data analytics, Financial Modelling In the rapidly evolving landscape of investment, hedge funds have always been at the forefront of adopting innovative strategies to gain a competitive edge. One of the most significant transformations in recent years is the incorporation of alternative data into investment decision-making. This kind of data encompasses a vast array of non-traditional information sources, ranging from satellite imagery to social media sentiment and from credit card transactions to foot traffic data collected from smartphones.

In 2015, hedge funds used images from space to observe the parking lots of major retailers.Understanding Alternative DataAlternative data refers to information that is not derived from traditional financial sources such as company filings, earnings reports, and economic indicators. The uniqueness of alternative data lies in its ability to provide real-time, predictive insights that are not readily available from conventional sources but can be sourced by the creative problem-solver. Hedge funds utilise this data to anticipate market movements, understand consumer behaviour, and assess company performance.

Real-World Applications in Hedge FundsThe utilisation of alternative data by hedge funds is more than just theoretical. Numerous hedge funds have successfully leveraged such data to drive investment decisions.

Case Study: Satellite ImageryOne notable example involves the use of satellite imagery. In 2015, hedge funds used images from space to observe the parking lots of major retailers. By quantifying the number of cars over time, they could estimate the retailers’ sales volumes ahead of official earnings releases. This information offered an unparalleled advantage in predicting stock performance. Eagle Alpha, an alternative data provider, suggests that parking lot car counts can forecast same-store sales growth with a correlation as high as 0.9.

Case Study: Web ScrapingWeb scraping is another tool used to gather vast amounts of information from the internet. For instance, in 2017, a hedge fund scraped employment data from corporate websites to gauge workforce expansion or contraction. This data provided insights into company growth that might not be evident from public filings for several more weeks or months.

Case Study: Social Sentiment AnalysisThe rise of social media has also been a boon for alternative data aficionados. Hedge funds analyse sentiment on platforms like Twitter to gauge public perception of a brand or product. An instance of this was when a hedge fund detected a shift in consumer sentiment towards a tech company due to product issues, prompting them to short the stock before a significant drop in its price.

Challenges and ConsiderationsWhile the examples illustrate the potential of alternative data, there are challenges. The primary concerns include data quality, privacy issues, and the complexity of integrating vast and varied datasets. Furthermore, the SEC is paying close attention to ensuring that the use of alternative data complies with securities laws, especially around material non-public information (MNPI).

ConclusionAdopting alternative data is not just a trend but a paradigm shift in hedge fund investment strategies. It offers a deeper and often timelier window into company and market performance, providing an edge over those relying solely on traditional data sources. However, the efficacy of this data hinges on the ability to accurately interpret and apply it within the boundaries of regulatory compliance and ethical considerations. Hedge funds that master this balance may find themselves at an advantage in the competitive and fast-paced investment world.

Key Takeaways– Alternative data gives hedge funds unique and predictive insights into market and consumer behaviour.
– Real examples include satellite imagery analysis, web scraping for employment data, and social media sentiment analysis.
– Using alternative data presents challenges, including data integrity, privacy concerns, and regulatory compliance.
– There is a balance to be struck between the competitive edge offered by alternative data and the ethical and legal implications of its use.

View Details

How to Achieve Your Visions by Making Your Life Strategy ActionableMatthew Bernath* October 24, 2023 * ,12:18 pm * ,Recommendations Your visions are the compass for your life—a guiding star that shows you the way to your true north. However, how many times have you set lofty visions for your life, only to find them gathering dust in the forgotten corners of your mind? The gap between vision and reality is often filled with nebulous goals and unclear strategies. In this blog post, we’ll explore the importance of making your life strategy actionable by introducing the “Success Blueprint: Vision, Goals & Strategy Notion Template”. This transformative Notion template is designed to turn your grand visions into achievable milestones.

The Holy Trinity of Planning: Visions, Goals, and StrategiesVisions: Your North StarYour visions serve as your North Star, providing a general direction for your personal and professional aspirations. Visions encompass your deepest desires and paint a broad strokes picture of what you want your future to look like. Without visions, you’re like a ship without a compass—drifting aimlessly.

When thinking about visions, think big. This is your ultimate dream state—what would you do if failure was not an option?

Goals: The MilestonesWhile visions offer the ‘why,’ goals provide the ‘what.’ Goals are the concrete, measurable milestones that make your vision achievable. They break down your visions into specific, actionable targets, making it easier to chart a course toward realizing your dreams.

Set SMART Goals—Specific, Measurable, Achievable, Relevant, and Time-bound. This framework ensures your goals are practical and trackable.

Strategies: The RoadmapStrategies are your action plans—the ‘how’ of achieving your goals. They give you a step-by-step guide to navigate through the complexities of life as you work towards your objectives. Strategies turn your vision and goals into a tangible action plan.

Consider potential roadblocks and think about how you can work around them. Good strategy always has a Plan B.

Success Blueprint: Vision, Goals & Strategy Notion TemplateHere comes the game-changer—the “Futurescape: Your Vision, Goal & Strategy Planner.” This Notion template allows you to articulate your visions, break them down into SMART goals, and devise a set of actionable strategies. What sets this template apart is its ingenious use of table relations, connecting your visions to corresponding goals and those goals to specific strategies.

With the Futurescape Planner, you have a one-stop shop for all your visionary planning needs. It streamlines the planning process and makes it much easier to track your progress, ensuring you’re not just daydreaming but actively working towards your dreams.

Use the code FMPNOTIONTEMPLATE for an exclusive 50% discount.

ConclusionVisions remain dreams if you don’t take actionable steps to achieve them. The “Futurescape: Your Vision, Goal & Strategy Planner” offers a robust framework that helps you do just that—turning your lofty visions into achievable goals and actionable strategies. By employing a structured, systematic approach to planning, you can make your life strategy actionable and set yourself on a path to achieving your grandest visions. So, stop drifting and start planning—your future self will thank you.

Buy Now with 50% FMP Discount

View Details

The Importance of Financial Modelling in Investment BankingMatthew Bernath* October 13, 2023 * ,11:31 am * ,Financial Modelling Investment banking, often described as the nexus between financial institutions and corporations, plays a pivotal role in facilitating capital allocation, mergers, acquisitions, and a myriad of other financial transactions. At the heart of these functions lies a crucial tool: financial modelling. This article delves into the importance of financial modelling in investment banking.

What is Financial Modelling?Financial modelling is the process of creating a representation of a company’s financial performance. This representation is based on a set of assumptions about the future, and the model is typically built using Excel. Through a financial model, analysts can simulate various scenarios to forecast future financial performance, value companies, or evaluate investment opportunities.

Key Uses in Investment Banking Valuation: Whether determining the value of a business for an acquisition or a buyout, a well-crafted financial model can ascertain the intrinsic worth of the entity. * Mergers & Acquisitions (M&A): In M&A transactions, financial models help in assessing how much a company should pay for another and the financial impact of the potential merger. * Project Finance & Advisory: For large-scale infrastructure projects, financial modelling assesses feasibility, expected returns, and risks associated. * IPOs: When a company goes public, its value needs to be determined. Financial models provide the groundwork for this valuation. Benefits of Financial Modelling Informed Decision Making: By simulating multiple scenarios, banks can understand the implications of different strategies or decisions. * Risk Management: Financial models allow bankers to anticipate potential risks and pitfalls, thereby mitigating them proactively. * Efficiency: With a robust model, banks can quickly adapt to new information, leading to more agile decision-making. Challenges and ConsiderationsWhile the advantages of financial modelling are numerous, it’s essential to remember that every model is built on assumptions. These assumptions can sometimes be erroneous or not account for unexpected market shifts. As the adage goes: “All models are wrong, but some are useful.” The skill lies in understanding the model’s limitations and using it as a guide rather than an absolute predictor.

The Future of Financial Modelling in Investment BankingAs technology evolves, financial modelling is also undergoing transformative changes. The integration of AI and machine learning promises more sophisticated and adaptive models. Moreover, as global markets become more interconnected and complex, the demand for detailed and comprehensive financial models will only increase.

Financial modelling is undeniably indispensable in investment banking, facilitating informed and strategic decision-making. As we progress into a more digitised and interconnected financial future, the nuances and intricacies of financial modelling will undoubtedly become even more integral to investment banking.

View Details

Financial close is when all the financial agreements and commitments are formalised and the project is officially set in motion.

The post Financial Close in Project Finance first appeared on The Financial Modelling Podcast.

The post Financial Close in Project Finance appeared first on The Financial Modelling Podcast.

View Details

Decoding LBO financial models - Learn how these models facilitate informed decision-making within leveraged buyouts.

The post Decoding LBO Financial Models: A Deep Dive into Leveraged Buyouts first appeared on The Financial Modelling Podcast.

The post Decoding LBO Financial Models: A Deep Dive into Leveraged Buyouts appeared first on The Financial Modelling Podcast.

View Details

Essential financial modelling tools available on Amazon that will boost your analytical prowess and help you stay ahead in the game.

The post Must-Have Financial Modelling Tools for Aspiring Analysts and Entrepreneurs first appeared on The Financial Modelling Podcast.

The post Must-Have Financial Modelling Tools for Aspiring Analysts and Entrepreneurs appeared first on The Financial Modelling Podcast.

View Details

Essential books for financial modelling, investment banking, infrastructure finance, project finance, and corporate finance.

The post Mastering Finance: 7 Essential Books for Financial Modelling and Investment Success first appeared on The Financial Modelling Podcast.

The post Mastering Finance: 7 Essential Books for Financial Modelling and Investment Success appeared first on The Financial Modelling Podcast.

View Details

Two prominent methods stand out for funding large-scale projects and business activities: project finance and traditional financing.

The post Project Finance vs Traditional Financing first appeared on The Financial Modelling Podcast.

The post Project Finance vs Traditional Financing appeared first on The Financial Modelling Podcast.

View Details

Project finance is a complex process that involves numerous players coming together to finance ambitious ventures.

The post Key Players in Project Finance first appeared on The Financial Modelling Podcast.

The post Key Players in Project Finance appeared first on The Financial Modelling Podcast.

View Details

Debt structuring is a critical aspect of project finance, serving as the backbone for funding large-scale infrastructure and development projects.

The post Debt Structuring in Project Finance first appeared on The Financial Modelling Podcast.

The post Debt Structuring in Project Finance appeared first on The Financial Modelling Podcast.

View Details

AI in Project Finance: From streamlining legal agreements and advertising efforts to enhancing risk assessment and project evaluation.

The post Harnessing AI in Investment Banking first appeared on The Financial Modelling Podcast.

The post Harnessing AI in Investment Banking appeared first on The Financial Modelling Podcast.

View Details

Embracing AI in Project FinanceMatthew Bernath* May 1, 2023 * ,5:12 pm * ,Data analytics, Fintech, Project Finance AI in Project Finance: From Drafting Legal Agreements to Risk AssessmentThe landscape of project finance is undergoing a significant transformation, fueled by the integration of artificial intelligence (AI) and machine learning. In addition to streamlining legal agreements and advertising efforts, AI-powered tools like ChatGPT offer numerous applications that are reshaping traditional financing methods for large-scale infrastructure and development projects. In this article, we will explore how AI is revolutionizing project finance by enhancing risk assessment, project evaluation, and stakeholder management.

Drafting Legal Agreements with AILegal agreements are a critical aspect of project finance, as they set the foundation for the rights and obligations of all parties involved. Historically, drafting these documents was a time-consuming and costly process, often involving multiple iterations and input from various stakeholders. Today, AI-powered tools like ChatGPT are streamlining the process, providing significant benefits such as:

1. 1. Improved efficiency: AI can quickly generate and review contract templates, helping legal teams save time and resources. This allows them to focus on more complex and high-value tasks, ensuring the legal agreements are comprehensive and tailored to the project’s unique requirements.
   2. Enhanced accuracy: AI algorithms can analyze vast amounts of data and identify potential errors or inconsistencies in legal agreements. This reduces the risk of costly disputes and ensures all parties have a clear understanding of their obligations.
   3. Customization: AI-driven tools can easily incorporate specific clauses, terms, and conditions into legal agreements based on the unique needs of the project. This level of customization can help mitigate risks and protect the interests of all stakeholders.
   4. Collaboration: AI-powered platforms enable better collaboration between legal teams, project sponsors, and other stakeholders. By providing a centralized location for document drafting and review, AI tools can streamline communication and help maintain version control. Risk Assessment with AIProject finance inherently involves numerous risks, making risk assessment a critical aspect of the process. AI-driven tools are increasingly being used to improve the accuracy and efficiency of risk assessment:

2. Data-driven insights: AI algorithms can process and analyze vast quantities of data, enabling more accurate identification and quantification of project risks. This results in better-informed decision-making and more effective risk mitigation strategies.

3. Predictive analytics: AI-powered tools can forecast potential risks by analyzing historical data and identifying patterns or trends. These predictions can help project teams anticipate and proactively address potential issues, reducing the likelihood of project delays or cost overruns.

4. Real-time monitoring: AI-driven platforms can continually monitor project performance, detecting emerging risks and alerting stakeholders when necessary. This real-time risk monitoring can help prevent problems from escalating and ensure swift resolution. Project Evaluation and Selection with AIAI is also transforming how projects are evaluated and selected in project finance:

5. Enhanced due diligence: AI tools can automate the due diligence process, examining vast amounts of data to assess the viability of a project quickly and accurately. This can help project sponsors and financiers make more informed investment decisions.

6. Portfolio optimization: AI algorithms can evaluate and optimize a portfolio of projects, ensuring that investments are allocated efficiently and in line with the investor’s risk appetite and strategic objectives.

7. Scenario analysis: AI-powered platforms can simulate various scenarios to assess the potential impact of different factors on a project’s financial performance. This enables project teams to make data-driven decisions and optimize project structures for maximum profitability and minimal risk. Stakeholder Management with AIManaging relationships with various stakeholders is a crucial aspect of project finance. AI-driven tools can help streamline communication and collaboration, improving stakeholder management:

8. Automated reporting: AI algorithms can generate customized reports and updates for stakeholders, ensuring they have the information they need to make informed decisions. This can save time and resources, as well as enhance transparency and trust among project participants.

9. Sentiment analysis: AI-powered tools can analyze stakeholder communications and feedback, gauging sentiment and identifying potential areas of concern. This can help project teams proactively address stakeholder issues and maintain strong relationships.

10. Decision support: AI-driven platforms can help project teams make more informed decisions by analyzing stakeholder input and providing data-driven recommendations. This can lead to more effective collaboration and better project outcomes. Advertising Completed Projects with AIOnce a project is completed, it’s essential to advertise its success and generate interest among potential investors and users. AI-driven tools are reshaping how projects are promoted, leveraging data-driven insights and automating various aspects of the advertising process:

11. Targeted marketing: AI algorithms can analyze vast amounts of data to identify the most effective channels and strategies for reaching target audiences. This enables project teams to tailor their advertising efforts, maximizing return on investment.

12. Personalization: AI tools can create personalized advertising campaigns based on user behavior, interests, and demographics. This level of personalization results in more engaging and relevant ads, improving the likelihood of conversion.
13. Real-time optimization: AI-powered advertising platforms can continually monitor campaign performance, adjusting strategies in real-time to maximize results. This dynamic approach helps ensure that advertising budgets are used efficiently and that campaigns achieve their desired outcomes.
14. Performance analytics: AI-driven tools can provide comprehensive insights into the performance of advertising campaigns, helping project teams understand what worked well and what needs improvement. These insights can inform future marketing strategies, ensuring continued success in promoting projects. AI in Project Finance - ConclusionAI is revolutionizing project finance, offering numerous applications that are improving risk assessment, project evaluation, and stakeholder management. Tools like ChatGPT are enhancing the efficiency and accuracy of traditional processes, resulting in more effective project financing and ultimately driving the development of essential infrastructure worldwide. As AI technology continues to advance, we can expect to see even more innovative applications in project finance, shaping the industry and improving the lives of millions globally.

The post Embracing AI in Project Finance appeared first on The Financial Modelling Podcast.

View Details

Data Ecosystems: Privacy-Preserving Data Sharing for a Better TomorrowMatthew Bernath* April 29, 2023 * ,8:52 pm * ,Data analytics Data Sharing - A New Way of BusinessIn 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 regard has been on developing Data Ecosystems that enable companies to share data while preserving privacy. The Boston Consulting Group (BCG) has been at the forefront of exploring such models, and tools like Omnisient are emerging to help companies achieve these goals. This blog post delves into the concept of privacy-preserving data ecosystems and discusses the benefits, such as improved health outcomes and financial inclusion.

The Need for Privacy-Preserving Data EcosystemsSharing data across organisations has the potential to fuel innovation, drive efficiency, and create social impact. However, data privacy and security concerns often limit the extent to which companies are willing to share data. Privacy-preserving data ecosystems provide a solution to this problem by allowing organisations to share data without compromising on privacy.

BCG explored more than 550 data-sharing projects and innovative or sustainable business initiatives. Of these, they identified 220 examples of data sharing for mega-use cases.BCG's Work on Data EcosystemsBoston Consulting Group (BCG) has conducted extensive research on data-sharing models and their potential benefits. In their recent publications, they have highlighted the importance of broad data-sharing models and how they can be vital to societal changes. BCG’s work showcases how data ecosystems can lead to better health outcomes, increased financial inclusion, and more sustainable cities. I was fortunate to meet Tian Feng and Massimo Russo to share ideas on this important topic.

Technology companies that enable many ecosystems either have developed or are developing a host of technological solutions to facilitate data sharing by mitigating risk, enhancing value, and reducing the sources of friction that inhibit sharing - source: BCG The New Tech Tools in Data SharinOmnisient: A Tool for Privacy-Preserving Data SharingTo facilitate the creation of privacy-preserving data ecosystems, tools like Omnisient – Collaborative Consumer Intelligence have emerged. Omnisient is a data exchange platform that enables organisations to share data securely and privately. By leveraging advanced cryptographic techniques and privacy-enhancing technologies, Omnisient ensures that sensitive information is protected while enabling organisations to derive valuable insights from shared data.

Collaborating businesses can see the overlap in shared consumers and match them to gain insights on their consumers beyond their business and run predictive models in a privacy-by-design environment.Benefits of Privacy-Preserving Data EcosystemsWhile numerous opportunities arise from data sharing, I have highlighted three that I’ve seen value in below.

1. Improved Health Outcomes: Sharing health data across different organisations can help researchers uncover new patterns, leading to better diagnoses and treatments. Privacy-preserving data ecosystems allow for the secure exchange of sensitive health information, enabling medical research advancements without compromising patient privacy.
2. Financial Inclusion: Sharing data between financial institutions and other organisations can help identify underserved populations and provide them with better access to financial services. Privacy-preserving data ecosystems can protect personal financial information while facilitating a more inclusive financial landscape.
3. Sustainable Cities: Urban planners, transportation authorities, and utility companies can benefit from sharing data to build smarter and more sustainable cities. Privacy-preserving data ecosystems can help these organisations collaborate without risking the privacy of citizens’ data. I gave a talk on this at the IT News Africa Events IoT Forum Africa 2022. ConclusionPrivacy-preserving data ecosystems are an essential tool for enabling organisations to share data while protecting their clients’ privacy and preserving trust. BCG’s research in this area highlights the immense potential of such ecosystems to drive innovation and create societal impact. Tools like Omnisient make it possible for companies to participate in these ecosystems securely and efficiently. By embracing privacy-preserving data sharing, we can unlock the power of data to solve some of the world’s most pressing challenges, leading to a brighter and more inclusive future.

The post Data Ecosystems: Privacy-Preserving Data Sharing for a Better Tomorrow appeared first on The Financial Modelling Podcast.

View Details

Excel Formulas for Financial ModellersMatthew Bernath* April 27, 2023 * ,8:46 pm * ,Financial Modelling As a financial modeller, it is essential to understand Excel formulas that can help you build robust and accurate financial models. In this blog post, we will discuss the top five Excel formulas for Financial Modellers.

Excel Formulas for Financial Modellers No 1. NPVNet Present Value (NPV) is a formula that helps you to calculate the present value of future cash flows. It is a key formula in financial modelling, as it allows you to determine whether an investment is worth pursuing based on the future cash flows it is expected to generate. The NPV formula is as follows:

=NPV(rate, value1, [value2], …)

The rate parameter is the discount rate, which is the rate at which future cash flows are discounted to their present value. The value parameters represent the cash flows that are expected to be generated in the future.

Excel Formulas for Financial Modellers No 2. IRRThe Internal Rate of Return (IRR) is a formula that helps you to determine the rate of return on an investment. It is also an important formula in financial modelling, as it allows you to compare different investment opportunities and determine which one offers the best return. The IRR formula is as follows:

=IRR(values, [guess])

The values parameter represents the cash flows that are expected to be generated by the investment. The guess parameter is an optional parameter that represents your estimate of the IRR.

Interlude for XXIRR and XNPV are advanced versions of the IRR and NPV formulas, respectively. XIRR helps to calculate the internal rate of return on investments that have irregular cash flows and dates, whereas XNPV calculates the net present value of investments with irregular cash flows and dates. These formulas are particularly useful for financial modellers dealing with complex financial models that involve multiple cash flows over varying periods.

Excel Formulas for Financial Modellers No 3. PMTThe PMT formula helps you to calculate the periodic payment required to pay off a loan or investment. It is an important formula in financial modelling, as it allows you to determine the amount of payments required to pay off a loan or investment over a given period. The PMT formula is as follows:

=PMT(rate, nper, pv, [fv], [type])

The rate parameter represents the interest rate, nper represents the number of periods, and pv represents the present value of the loan or investment. The fv parameter represents the future value of the loan or investment, and the type parameter represents the timing of the payments.

Excel Formulas for Financial Modellers No 4. VLOOKUPThe VLOOKUP formula is a powerful tool that allows you to look up data from a table. It is an important formula in financial modelling, as it allows you to retrieve data from a large data set and use it in your financial models. The VLOOKUP formula is as follows:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

The lookup_value parameter represents the value that you want to look up in the table. The table_array parameter represents the range of cells that contains the data. The col_index_num parameter represents the column number of the data that you want to retrieve, and the range_lookup parameter represents the type of match that you want to use.

X Interrupts Again!XLOOKUP is an improved version of the VLOOKUP formula, which provides greater flexibility and functionality. It allows for more precise matching and the ability to search in any direction, as well as the ability to handle errors and empty cells more effectively. XLOOKUP is particularly useful for financial modellers working with large and complex datasets, where accuracy and efficiency are critical.

Excel Formulas for Financial Modellers No 5. SUMIFThe SUMIF formula allows you to sum a range of cells based on specific criteria. It is an important formula in financial modelling, as it allows you to sum data based on specific conditions, such as date ranges or product categories. The SUMIF formula is as follows:

=SUMIF(range, criteria, [sum_range])

The range parameter represents the range of cells you want to evaluate, and the criteria parameter represents the condition you want to evaluate. The sum_range parameter represents the range of cells that you want to sum.

Essential Excel Formulas for Financial ModellersIn conclusion, mastering Excel formulas is crucial for financial modelling. The top five formulas discussed in this post – NPV, IRR, PMT, VLOOKUP, and SUMIF – are essential for building robust and accurate financial models.

However, it’s worth noting that there are other important formulas that financial modellers should be familiar with, such as XIRR, XNPV, and XLOOKUP. By taking the time to learn and practice these formulas, financial modellers can create sophisticated models that help organizations make informed decisions about their investments and financial future.

NPV, IRR, XNPV and XIRR ExplainerThe post Excel Formulas for Financial Modellers appeared first on The Financial Modelling Podcast.

View Details

5 Reasons to Get Accredited as a Financial ModellerMatthew Bernath* April 19, 2023 * ,8:31 am * ,Financial Modelling In today’s fast-paced business environment, financial modelling has become an essential tool for decision-making. Financial models help businesses evaluate and forecast financial performance, assess investment opportunities, and make informed decisions. As a result, financial modelling has emerged as a critical skill set in the finance industry. As a result, there is an increasing demand for professionals who can develop complex financial models that can provide accurate and reliable insights.

One way to demonstrate your proficiency in financial modelling is to get accredited as a financial modeller. Accreditation provides validation of your expertise and credibility in the field, and it sets you apart from others who may not have the same level of proficiency. In this blog post, we will discuss why getting accredited as a financial modeller is a good idea and the benefits it can offer.

The Financial Modelling Institute The Financial Modelling Institute (FMI) is a globally recognized organization that offers accreditation for financial modellers. FMI accreditation is a rigorous process that evaluates an individual’s skills in financial modelling, including their ability to develop and analyze complex financial models, effectively communicate results, and adhere to best practices and ethical standards. The FMI accreditation process ensures that an individual has the necessary skills and knowledge to perform financial modelling tasks to a high standard.

5 Reasons to Get AccreditedThere are several reasons why getting accredited as a financial modeller can be a good idea:

1. CredibilityAccreditation from a recognized organization like FMI adds credibility to your skills and expertise in financial modelling. It demonstrates that you have met a rigorous standard and can perform financial modelling tasks to a high standard.

2. Career advancementAccreditation can significantly boost your career advancement prospects. It demonstrates to employers that you have the necessary skills and expertise to perform financial modelling tasks effectively, which can lead to new job opportunities or promotions.

3. Competitive advantageIn today’s job market, having a competitive advantage is crucial. Accreditation can give you an edge over other candidates who may not have the same accreditation or expertise in financial modelling.

4. Professional development: FMI accreditation requires ongoing professional development to maintain the accreditation. This ensures that you stay up-to-date with the latest trends, best practices, and ethical standards in financial modelling.

5. Networking opportunitiesAccreditation from a recognized organization like FMI can provide opportunities to network with other financial modellers and industry experts. Networking can be a great way to learn about new trends, best practices, and potential job opportunities.

Accreditation is a stamp of qualityIn conclusion, getting accredited as a financial modeller is a good idea for several reasons. Accreditation from a recognized organization like FMI can provide credibility, career advancement prospects, a competitive advantage, ongoing professional development, and networking opportunities. If you are interested in financial modelling, consider pursuing accreditation to demonstrate your skills and expertise to potential employers and clients.

The post 5 Reasons to Get Accredited as a Financial Modeller appeared first on The Financial Modelling Podcast.

View Details

In the season 5 finale of the Financial Modelling Podcast, we explore the potential of generative AI in financial modelling. Our guests, Lance Rubin, Hedieh Kianyfard, Danielle Stein Fairhurst and Adrian Miric, discuss the current use of generative AI in finance, its benefits and limitations, and potential use cases for financial modelling. As we wrap up the season, we thank our sponsor, Model Citizn, for their support and encourage listeners to share their thoughts and experiences with generative AI in finance. Join us for this exciting finale episode and gain valuable insights into the future of financial modelling. Don't forget to subscribe, rate, and review the podcast on your preferred platform!

View Details

Sensitivity analysis is an essential financial modelling toolMatthew Bernath* March 20, 2023 * ,12:22 pm * ,Financial Modelling Sensitivity analysis is an essential tool used in financial modelling to assess the impact of changes in key assumptions or inputs on the output of the model. It involves testing the model with different values for one or more input variables to determine how sensitive the output is to changes in those variables.

Sensitivity Analysis for Risk AssessmentSensitivity analysis helps to identify and evaluate the risks associated with an investment or project. By testing the model with different assumptions, financial analysts can determine how sensitive the output is to changes in key variables, such as interest rates, exchange rates, or sales volumes. This allows them to identify the risks that could impact the project or investment most.

Sensitivity Analysis for Decision-makingSensitivity analysis provides decision-makers with valuable insights into the financial implications of different scenarios. By testing the model with different assumptions, decision-makers can determine the range of possible outcomes for the project or investment and choose the scenario most likely to produce the desired results.

Sensitivity Analysis for PlanningSensitivity analysis helps in planning by allowing analysts to identify and quantify the key drivers of financial performance. This information can be used to develop contingency plans and mitigation strategies to address potential risks and ensure the project or investment remains on track.

Sensitivity Analysis for Communication Sensitivity analysis helps communicate different scenarios’ financial implications to stakeholders, such as investors or lenders. By presenting the sensitivity analysis results clearly and understandably, financial analysts can help stakeholders make informed decisions based on a thorough understanding of the risks and opportunities associated with the project or investment.

Sensitivity Analysis - a Key Tool for ModellersIn conclusion, sensitivity analysis is an essential tool for financial modelling. It helps to assess the risks associated with an investment or project, provides decision-makers with valuable insights into the financial implications of different scenarios, and allows financial analysts to communicate the results of their analysis to stakeholders clearly and understandably.

The post Sensitivity analysis is an essential financial modelling tool appeared first on The Financial Modelling Podcast.

View Details

Matthew BernathCreating AI-Powered One Page Websites with OpenAI ChatGPT* March 8, 2023 * ,12:07 pm * ,Financial Modelling OpenAI GPT technology can be a powerful tool for entrepreneurs looking to create smarter, more personalized websites and online experiences for their customers. By incorporating GPT into their websites, entrepreneurs can create chatbots that can understand and respond to natural language, allowing for a more human-like interaction with their visitors. This can lead to increased engagement, better customer satisfaction, and more sales. Additionally, GPT can generate personalized product recommendations based on customer behaviour and preferences, allowing entrepreneurs to offer a more targeted and customized shopping experience. Overall, OpenAI GPT has the potential to help entrepreneurs create smarter, more efficient, and more profitable online businesses.

AI Magic: Create a Smart Website in One Hour with OpenAI GPTAre you looking to take your website to the next level? Want to incorporate artificial intelligence to create a truly smart website? Look no further than the AI Magic course on Udemy.

In just one hour, this course will teach you how to use OpenAI’s GPT technology to create a website that is intelligent, personalized, and engaging for your users. With GPT, your website can understand and respond to natural language, allowing for a more human-like interaction with your visitors.

In the AI Magic course, you will learn how to harness the power of GPT to create a website that can understand and respond to user input in a natural and intuitive way. You will start by setting up a basic website, and then integrate GPT to add natural language processing capabilities.

Whether you are a seasoned web developer or a beginner, the AI Magic course is a great way to explore the exciting possibilities of AI-powered websites. With its step-by-step approach, you will gain practical skills and knowledge that you can apply to your own projects.

What is ChatGPT?But what exactly is OpenAI’s GPT technology? GPT, or Generative Pre-trained Transformer, is a type of machine learning model that is trained on vast amounts of text data. It can then use this training to generate natural language responses to prompts, making it ideal for creating chatbots, language models, and other AI applications.

ChatGPT, the large language model behind this blog post, is an example of GPT technology at work. Trained on massive amounts of text data, ChatGPT can generate coherent and relevant responses to a wide variety of prompts, making it a valuable tool for communication, education, and entertainment.

AI Magic: Create a Smart Website in One Hour with OpenAI GPTThis course is suitable for beginners and those with some prior knowledge of web development.

Throughout this course, you will learn how to use HTML, CSS, and JavaScript to design and develop a one page website that incorporates the OpenAI GPT API. You will learn how to use API keys to authenticate your requests and how to format your input data in JSON format for consumption by the API.

By the end of this course, you will have developed a fully functional one page website that integrates with the OpenAI GPT API, and you will have the skills and knowledge to create powerful and innovative applications that leverage the power of artificial intelligence. Whether you are a web developer or a business owner, this course will help you take your skills to the next level and unlock the potential of the OpenAI GPT API.

Sign up for free - only during March 2023Sign up for the AI Magic course today, and take your website to the next level with the power of GPT technology.

AI Magic: Create a Smart Website in One Hour with OpenAI GPTThe post Creating AI-Powered One Page Websites with OpenAI ChatGPT appeared first on The Financial Modelling Podcast.

View Details

Matthew BernathThe History of Financial Modelling* March 3, 2023 * ,2:59 pm * ,Financial Modelling Microsoft Excel is one of the most widely used software applications for creating financial models, and there are several reasons why it is the preferred tool of many financial professionals.

Early Economic AnalysisFinancial modelling has a long history, dating back to the early 20th century. The earliest financial models were developed to analyse stock market data and make investment decisions. Over time, financial modelling has evolved to become an essential tool for businesses and financial professionals, used for a wide range of purposes, including budgeting, forecasting, and investment analysis.

One of the first financial models was developed by economist Irving Fisher in the 1930s. Fisher’s model was designed to forecast the behaviour of the stock market, using a complex set of equations to predict future prices.

The Explosion of ExcelIn the 1950s and 1960s, financial modelling began to gain traction in the business world. During this time, the first computer-based financial models were developed, which allowed businesses to analyse large amounts of financial data more quickly and accurately than ever before. The development of spreadsheets, such as Lotus 1-2-3 and Microsoft Excel, in the 1980s further revolutionised the field of financial modelling, making it more accessible and user-friendly.

In the 1990s and early 2000s, financial modelling became increasingly important in the world of finance as companies began to rely more heavily on financial models to make important business decisions. The rise of investment banking, private equity, and hedge funds also contributed to the growth of financial modelling, as these industries require sophisticated financial models to analyse potential investments and make informed decisions.

The Future of Financial ModellingToday, financial modelling is essential for businesses and financial professionals in virtually every industry. It is used to analyse financial data, make investment decisions, forecast future performance, and much more. As technology continues to evolve, financial modelling is likely to become even more important in the future.

The post The History of Financial Modelling appeared first on The Financial Modelling Podcast.

View Details

In today's rapidly evolving financial landscape, traditional data sources such as company reports, financial statements, and economic indicators are no longer enough to gain a competitive edge in the market. Alternative data, which refers to non-traditional data sources such as satellite imagery, social media activity, web traffic, and credit card transactions, has become an essential tool for investors and financial analysts to make better investment decisions.

In this podcast, we'll explore the world of alternative data with expert John Farrall. Join us as we delve into the world of alternative data in financial modelling and discover how this new frontier of data is reshaping the way we invest and analyze the markets.

View Details

Matthew BernathWhy is Microsoft Excel the Financial Modelling Tool?* February 16, 2023 * ,2:16 pm * ,Financial Modelling Microsoft Excel is one of the most widely used software applications for creating financial models, and there are several reasons why it is the preferred tool of many financial professionals.

User FriendlyFirstly, Excel is user-friendly, and most people have at least a basic proficiency with the software. This makes it easy to create and modify financial models quickly and efficiently.

CustomisableSecondly, Excel is highly customisable, allowing financial professionals to create models that meet their specific needs. This flexibility makes it possible to create models that are tailored to the unique requirements of a particular business or industry.

Built-In Formulas
Thirdly, Excel offers many built-in functions and formulas commonly used in financial modelling. These functions include math, statistical, and financial calculations, which can help to simplify the modelling process and save time.

Compatability
Fourthly, Excel is compatible with other software programs, making it easy to import and export data from other sources. This can be especially helpful when working with large data sets or integrating financial models with other business applications.

Widely Used and Accepted
Finally, Excel is widely recognised and accepted in the financial industry. This means that models created in Excel can be easily shared and reviewed by other financial professionals, making it an ideal tool for collaboration.

Financial models are primarily 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 programs can be used to create financial models, Excel remains the most popular tool.

Start learning financial modelling todayIn conclusion, financial modelling is a valuable skill that everyone should know. Whether you want to make better financial decisions, increase your financial literacy, improve your forecasting abilities, or advance your career, financial modelling is a skill worth learning.

Learn financial modelling in Excel skills - free for February 2023!The post Why is Microsoft Excel the Financial Modelling Tool? appeared first on The Financial Modelling Podcast.

View Details

Matthew BernathData sharing responsibly can revolutionize industries* February 15, 2023 * ,8:41 pm * ,Financial Modelling In today’s world, data is a precious commodity that can be used to revolutionize various industries. With the rise of big data and advanced analytics, companies can now gather and analyze vast amounts of data to gain insights that can be used to improve their operations and decision-making processes. However, with great power comes great responsibility, and data sharing must be done in a responsible way to ensure the privacy and security of individuals.

Data sharing in a responsible way can revolutionize industries in several ways, including improving customer experiences, driving innovation, and enabling more efficient and effective decision-making.

Improving Customer Experiences One of the most significant benefits of data sharing is the ability to improve customer experiences. Companies can gather and analyze data on customer behaviour, preferences, and interests to provide personalized and targeted products and services. For instance, Netflix uses data on customer viewing habits to suggest content users are likely to enjoy. This approach has led to increased customer satisfaction and loyalty, as well as higher revenues for the company.

Driving Innovation Data sharing can drive innovation by enabling companies to identify new opportunities and develop innovative products and services. By analyzing data on customer needs and preferences, companies can create new products and services that better meet the needs of their customers. For example, Amazon uses data on customer purchases and browsing behaviour to identify emerging trends and develop new products that are likely to be in high demand.

Enabling More Efficient and Effective Decision-Making Finally, data sharing can enable more efficient and effective decision-making by providing companies with insights that can be used to optimize operations and improve performance. By analyzing data on customer behavior and preferences, companies can make informed decisions on product development, marketing strategies, and customer engagement. For instance, airlines use data on flight schedules, weather patterns, and customer demand to optimize their operations and improve customer experiences.

In conclusion, data sharing in a responsible way can revolutionize industries in many ways. By leveraging data to improve customer experiences, drive innovation, and enable more efficient and effective decision-making, companies can gain a competitive advantage and create new opportunities for growth and success. However, it is important to ensure that data is shared in a responsible way that respects the privacy and security of individuals. Privacy Enhancing Technologies can be used to ensure analysis is done in an anonymized manner, and insights on individuals are only used with explicit consent. Only then can we truly unlock the potential of data and use it to make a positive impact on the world.

The post Data sharing responsibly can revolutionize industries appeared first on The Financial Modelling Podcast.

View Details

Matthew BernathWhy financial modelling is a skill everyone should know* February 10, 2023 * ,1:17 pm * ,Financial Modelling Learn financial modelling – a term I’ve said many times before! Financial modelling is a crucial skill in today’s economy and one that everyone should know, regardless of their career path. Whether you are a student, a professional, or an entrepreneur, having a solid understanding of financial modelling will help you make informed decisions, maximise profits, and minimise risks.

Here are some of the reasons why financial modelling is a skill everyone should know.

Learn financial modelling for better decision-makingFinancial modelling allows you to simulate different scenarios and evaluate their potential outcomes, helping you make informed decisions about your finances. You can use financial modelling to evaluate investment opportunities, assess the viability of a new business idea, or determine the best course of action for paying off debt.

Improved forecastingFinancial modelling is often used for forecasting. By learning financial modelling and analysing past financial data and making assumptions about future trends, you can create a model that predicts future financial performance. A data-informed prediction allows you to identify potential challenges and opportunities and make proactive decisions to mitigate risks and maximise profits.

Learn financial modelling to be a better communicatorFinancial modelling requires you to present complex financial information clearly and concisely. This skill is useful for financial professionals and anyone who needs to communicate financial information to others.

Career advancementA solid understanding of financial modelling is an in-demand skill in many industries and can set you apart from your peers. Financial modelling is a valuable skill for finance professionals, but it is also useful for anyone working in a business-related field, such as marketing, operations, or strategy.

Increased financial literacyLearning financial modelling will improve your overall financial literacy. You will gain a deeper understanding of the financial world and learn how to analyse financial data, which will help you make better decisions about your own finances.

Start learning financial modelling todayIn conclusion, financial modelling is a valuable skill that everyone should know. Whether you want to make better financial decisions, increase your financial literacy, improve your forecasting abilities, or advance your career, financial modelling is a skill worth learning.

Learn financial modelling in Excel skills - free for February 2023!The post Why financial modelling is a skill everyone should know appeared first on The Financial Modelling Podcast.

View Details

The Power of Data EcosystemsMatthew Bernath* February 5, 2023 * ,1:43 pm * ,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 using privacy-preserving and purpose-built data ecosystems is so powerful.

1. Improved Decision MakingSharing data between organizations allows for the pooling of resources and knowledge, enabling businesses and institutions to make informed decisions based on a wider range of data points. For example, data sharing in healthcare can help doctors and researchers make better diagnoses and develop new treatments. In retail, data sharing can help companies understand consumer spending patterns and improve financial inclusion.

2. Enhanced Customer ExperienceBy sharing data in a privacy-preserving manner, organizations can gain a more comprehensive view of their customers, including their needs, preferences, and behaviours. This allows them to personalize their offerings and improve the customer experience. Data Ecosystems are revolutionising personalisation.

3. Increased EfficiencyData sharing can help organizations streamline their operations and reduce costs by eliminating the need for duplicate data entry and reducing the time required to find and access information. In healthcare, data sharing can help providers access patient information more quickly, improving the speed and efficiency of care.

4. Better Collaboration with Data EcosystemsSharing data between organizations can improve collaboration and foster partnerships. For example, in healthcare, data sharing can help researchers and scientists collaborate on developing new treatments and cures, while in retail, data sharing can help companies work together to improve the supply chain and reduce waste.

5. Enhanced TrustSharing data between organizations can enhance trust and transparency, allowing organizations to build stronger relationships with their customers and partners. For example, in retail, data sharing can help companies demonstrate their commitment to financial inclusion and demonstrate their responsible use of consumer data. Data Ecosystems allow for the economic upliftment of individuals and entrepreneurs.

Data Ecosystems are the Future of Data PartnershipsIn conclusion, data sharing across organizations is a powerful tool that can help businesses and institutions improve their operations, better understand their customers, and enhance their relationships with partners and customers. Whether it’s health data sharing or retail data sharing for financial inclusion, the benefits of data sharing are numerous and should not be overlooked.

The post The Power of Data Ecosystems appeared first on The Financial Modelling Podcast.

View Details

2023 Finance Book RecommendationsMatthew Bernath* February 2, 2023 * ,1:02 pm * ,Financial Modelling, Recommendations Finance is a vast and ever-evolving field that covers various topics, from personal finance to corporate finance and investments. Reading books can be an excellent way to gain knowledge and insights for those looking to understand finance better and improve their skills. In this blog post, we’ll be highlighting the top 5 books for finance that are must-reads for anyone interested in the field.

"The Intelligent Investor" by Benjamin GrahamThis classic book, first published in 1949, is widely considered one of the best books on investing ever written. It covers the basics of value investing and provides a framework for making smart investment decisions. It is a must-read for anyone looking to learn about investing and the stock market.

The Total Money Makeover" by Dave RamseyThis book is a personal finance classic that provides a step-by-step plan for getting out of debt, building wealth, and achieving financial freedom. It’s filled with practical tips and strategies to help anyone take control of their finances and achieve their financial goals.

"The Big Short: Inside the Doomsday Machine" by Michael LewisThis book provides a detailed account of the events leading up to the 2008 financial crisis. It’s a fascinating and sobering read that offers insights into the inner workings of the financial industry and the human behaviour that led to the crisis.

"The Efficient Market Hypothesis and Its Critics" by Eugene FamaThis book provides a comprehensive overview of the efficient market hypothesis, which states that financial markets are efficient and that it’s impossible to outperform the market consistently. It covers the history of the theory, its criticisms, and its implications for investors.

"The Black Swan: The Impact of the Highly Improbable" by Nassim Nicholas TalebThis book is a thought-provoking look at the role of randomness and unpredictability in the financial markets. It explores the concept of “black swan” events – rare and unpredictable events that have a significant impact – and the implications for investors and financial professionals.

Understanding Finance asIn conclusion, these are the top 5 books for finance that can help you gain a better understanding of the field and improve your skills. Each of these books covers a different aspect of finance and provides valuable insights and strategies that can help you make better financial decisions and become a better financial modeller.

Whether you’re looking to learn about investing, personal finance, or the inner workings of the financial industry, these books are sure to provide valuable insights and inspiration.

Practice AreasProject Finance Model BuildI can build or be a part of your project finance modelling team on an ad-hoc basis. I offer discrete and tailored service.I have built over 20 bankable project finance models, which have been used to raise over $5bn in debt and equity.

I have assisted companies to transition their financial close models intooperational models with strategic value.Project Finance Model AdvisoryFrom ensuring the project finance model is bankable to minimising audit costs with pre-audit model reviews, I will help you define the model structure and guide on best practice project finance modelling techniques.

I can also build custom VBA macros for automated scenario and sensitivity analysis and debt sculpting.Project Finance TrainingI provide one or two-hour courses on Project Finance Overviews and Project Finance Model Walkthroughs.

The two-hour course focuses on crucial project finance concepts, including the commercial structure, due diligence, the project finance model and debt structures such as sculpting.

I also offer online training.The post 2023 Finance Book Recommendations appeared first on The Financial Modelling Podcast.

View Details

2023 Financial Modelling Book RecommendationsMatthew Bernath2023 Financial Modelling Book Recommendations* January 30, 2023 * ,10:32 pm * ,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 difficult to know where to start.

In this blog post, we’ll be highlighting the top 5 financial modelling books that are must-reads for anyone looking to enhance their skills.

"Financial Modeling" by Simon BenningaThis book is considered a classic in the field and is often used as a textbook in finance courses. It covers the basics of Excel modeling and provides step-by-step instructions for building financial models. It also includes plenty of real-world examples and exercises to help you practice what you’ve learned.

The Basics of Financial Modeling by Jack AvonThis comprehensive guide covers everything from the basics of Excel and financial modeling to more advanced topics such as discounted cash flow analysis and Monte Carlo simulation. It also includes detailed case studies and practical examples to help you apply what you’ve learned.

"Financial Modeling in Excel for Dummies" by (FMP Friend) Danielle Stein FairhurstThis book is great for beginners who are new to financial modeling and Excel. It provides a clear and easy-to-understand introduction to the basics of financial modeling and includes plenty of step-by-step instructions and examples.

"Financial Modeling and Valuation: A Practical Guide to Investment Banking and Private Equity" by Paul PignataroThis book is aimed at more advanced financial modelling practitioners and covers a wide range of topics, including advanced Excel techniques, financial statement analysis, and forecasting. It also covers valuation of companies using various analysis techniques.

"Financial Modeling Using Excel and VBA" by Chandan Sengupta This book is designed for those who are already familiar with financial modeling and Excel and want to take their skills to the next level. It covers advanced Excel and VBA techniques and shows you how to automate your financial models and perform advanced analysis.

Building a Financial Modelling LibraryIn conclusion, these are the top 5 financial modeling books that can help you to enhance your skills. Each of these books is designed to cater to different skill levels and provide you with the knowledge and tools you need to be successful in the field of financial modeling. Whether you’re a beginner or an advanced practitioner, these books will help you take your skills to the next level.

Practice AreasProject Finance Model BuildI can build or be a part of your project finance modelling team on an ad-hoc basis. I offer discrete and tailored service.I have built over 20 bankable project finance models, which have been used to raise over $5bn in debt and equity.

I have assisted companies to transition their financial close models intooperational models with strategic value.Project Finance Model AdvisoryFrom ensuring the project finance model is bankable to minimising audit costs with pre-audit model reviews, I will help you define the model structure and guide on best practice project finance modelling techniques.

I can also build custom VBA macros for automated scenario and sensitivity analysis and debt sculpting.Project Finance TrainingI provide one or two-hour courses on Project Finance Overviews and Project Finance Model Walkthroughs.

The two-hour course focuses on crucial project finance concepts, including the commercial structure, due diligence, the project finance model and debt structures such as sculpting.

I also offer online training.The post 2023 Financial Modelling Book Recommendations appeared first on The Financial Modelling Podcast.

View Details

How can real-time data be utilised to update financial models in a complicated enterprise environment? How can we prevent organisations from making decisions based on obsolete projections?

Dhanusha Muthukumarana, CEO of POTENZA and a member of the Forbes Technology Council, joins the Financial Modelling Podcast to discuss how data engineering enables accurate and comprehensive financial models.

Season 5 of the Financial Modelling Podcast is sponsored by Model Citizn, a consulting, advisory, and training organisation specialising in financial modelling.

View Details

Brian Egger, Global Head of Financial Modeling at Bloomberg Intelligence at Bloomberg LP, joins the Financial Modelling Podcast to discuss the Bloomberg Interactive Calculator. As a leader at Bloomberg LP, Brian is at the forefront of innovation in financial data curation and visualisation. We speak about how Bloomberg has excelled at data visualisation for financial decision-making.

View Details

Learn how to partner with businesses effectively as a financial modeller (or anyone else!). In this episode, live from the Financial Modelling Summit, Andi Lonnen explains the 9 Cs for effective partnering, including:

• Connect and Collaborate
• Communicate Effectively
• Clear Strategic Thinking
• Commercial Acumen
• Change Agent and Challenging the Status Quo
• Curiosity & Creativity

Andi Lonnen is the Founder & CEO of the Finance Training Academy & Finance Business Partner Academy.

View Details

Live from the Financial Modelling Summit, Danielle Stein Fairhurst chats to the Financial Modelling Podcast.  Danielle is an accomplished author, trainer, consultant, and the 2022  Financial Modelling Lifetime Achievement Award winner.  This award recognises somebody who has consistently served to move the profession forward whilst raising the profile of financial modelling.  In this podcast, we discuss lessons for entrepreneurs and how to succeed in the creator economy.

View Details

Bill Jelen joined us for a chat during the 2022 Financial Modelling Summit. Hear his thoughts on the future of automation, Microsoft Excel and which talk impressed him most.

The Financial Modelling Summit is the world's largest gathering of financial modellers. From experts, deal makers and executives to those just starting their financial modelling journey.

View Details

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 optimise decisions such as refinancing and optimise project returns. Unfortunately, most project finance models are not built to meet these many uses. These […]

The post 5 Tips on Building a Project Finance Financial Model appeared first on The Financial Modelling Podcast.

View Details

Andrew is the Founder and CEO of the Financial Modeling World Cup, Excel Esports battles, the Microsoft Excel World Championship, and the Microsoft Excel Collegiate Challenge. With eight stages during the year, competitors in the Financial Modeling World Cup model their way to a $25,000 prize. In this podcast, Andrew talks about how Excel became an ESPN broadcast e-sport and provides some tips on how to win the Financial Modeling World Cup

View Details

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. Besides the traditional uses of a Financial Model, such as raising capital, pricing a service, or forecasting revenue, a Financial […]

The post How to Negotiate Using the Financial Model appeared first on The Financial Modelling Podcast.

View Details

This year the Financial Modelling Summit is taking the journey from Numbers to Insights. Bill Jelen joins the Financial Modelling Podcast, summit host, to share what he is most looking forward to at this year's event. The Financial Modelling Summit is the world's largest gathering of financial modellers. Buy your tickets here: https://www.financialmodellingsummit.com/.

View Details

In this special episode, Matthew Bernath from the Financial Modelling Podcast and Paul Barnhurst from The FP&A Guy sit down to chat about where these two worlds collide.

View Details

Is Microsoft Excel Dead? Lance Rubin from Financial Modelling Podcast sponsor Model Citizn, and Christopher Argent from Generation CFO resume their debate of whether this 35-year-old tool is the pocket knife for all tasks or past its prime.

View Details

Alternative Data can be used by any company, in any industry, to grow, better serve the environment and help entrepreneurs and students.

The post Alternative Data – Beyond Finance appeared first on The Financial Modelling Podcast.

View Details

Mark Vigors is no stranger to data analytics and financial modelling. In fact, he argues that these two skills are intertwined.  In this episode, we discuss how data scientists can get budget allocation for their projects, why dashboards need to enable decision making and even what energy source could potentially solve our energy needs.

View Details

Can Microsoft Excel and Python play together nicely?  Could Python be the next frontier of financial modelling?  In this episode, Felix Zumstein, Creator of xlwings, author of "Python for Excel", and CEO at xltrail joins the Financial Modelling Podcast to discuss Python integrations and how Excel users can perform advanced modelling in Python with ease.

View Details

Eloquens' tagline is "Don't Reinvent the Wheel!".  When it comes to financial modelling, many modellers start their models from scratch instead of using best-practice templates.  Eloquens seeks to solve this by providing a financial model marketplace whereby model templates can be bought and sold - whether you're financing a project finance deal or a startup!  In this episode, Tim Demoures, Managing Director at Eloquens, talks us through why you should never reinvent the wheel again. 

Learn more about our sponsors at https://www.modelcitizn.com/ and https://fmwiki.glideapp.io/.

View Details

Blockchain, Tokenomics and DeFi are often associated with the potential future of finance.  In this episode we explore what this means for financial modelling with Roderick McKinley, Blockchain and Tokenomics expert who has spent the last two years advising blockchain enterprises on quantitative modelling, design, and strategic advisory.  

Learn more about our sponsors at https://www.modelcitizn.com/ and https://fmwiki.glideapp.io/.

View Details

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 early intervention and I sat down and discussed what we thought would be great books and concepts for children […]

The post Data Analytics for Kids appeared first on The Financial Modelling Podcast.

View Details

In the first episode of the Financial Modelling Podcast, Lance Rubin from Model Citizn spoke about the future of financial modelling. Now in Season 5, Lance joins us as season sponsor to discuss why now is the time to revisit this discussion as financial modelling transcends both industries and technologies. Learn more about our sponsors at https://www.modelcitizn.com/ and https://fmwiki.glideapp.io/.

View Details

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 rebelling against society.  Then reading The New Hacker’s Dictionary and aspiring to play college pranks like […]

The post Gifts for Geeks appeared first on The Financial Modelling Podcast.

View Details

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 much into the ethics of data presentation and visualisation. I will instead point you in the direction of […]

The post AI Ethics and Data Analytics Governance appeared first on The Financial Modelling Podcast.

View Details

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 data-driven (don’t discount the ability and benefit of small companies using data!). In that case, banking […]

The post Alternative Data for Finance appeared first on The Financial Modelling Podcast.

View Details

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, the themes are often used without naming them explicitly.  The first two are Data vs. Data Analytics.  The […]

The post Analytics Across the Spectrum: Defensive to Offensive Analytics appeared first on The Financial Modelling Podcast.

View Details

In the Season 4 final, Bill 'MrExcel' Jelen, Lance Rubin and Alan Samuels join me to discuss the greatest changes to Microsoft Excel over the past year, and what the future holds in store.

View Details

What is an Operational Model and how is it different to a Financial Close Model?  In this episode, Alan Samuels from Amberside Advisors Ltd gives us insight as to why an Operational Model is a crucial decision-making tool.

View Details

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 in one intoxicating feeling of hunger and passion. Being an entrepreneur isn’t for everyone. However, in today’s digital world the lines between being an employee are becoming more blurred.

The post How to start your own podcast, business or launch your personal brand appeared first on The Financial Modelling Podcast.

View Details

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 Recommendations – Part 2 With so many great data analytics books coming out, I needed to provide an addition to […]

The post Data Analytics Books Recommendations Part 2 appeared first on The Financial Modelling Podcast.

View Details

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. Data analysis using data from months ago is no longer relevant, especially in a financial context. The way to overcome this is by using high-frequency data.

The post Why High-Frequency Analysis is the Future of Economic Forecasting appeared first on The Financial Modelling Podcast.

View Details

John Michaloudis left his corporate job and started MyExcelOnline where he could teach the world on a much grander scale how to use Excel effectively. In this podcast, he discusses the journey to building a successful online training business.

View Details

Roderick McKinley is a Tokenomics Advisory and Financial Modeling expert who has used his deep technical skills to become a freelancer and travel the world as a digital nomad.  Roderick joins us to discuss the skills one needs to become a freelancer.

View Details

In this episode, Julie Scotto (Of Counsel at Covington & Burling LLP London) explains the key components a financial modeller needs to be aware of.  Does your financial model accurately reflect the financial agreements? Julie's practice focuses on project finance and acquisitions in the energy, water, transportation and infrastructure sectors.  She advises developers and lenders in Europe, the Middle East and Africa.

View Details

Learn more about what is in store for delegates at the Financial Modelling Summit 2021, and stand a chance to win a ticket! I'm joined in this podcast by Giles Male from Summit Host Full Stack Modeller.

View Details

Oz is a 6x Microsoft MVP and Content Creator Extraordinaire!  In this podcast, we talk about the creative process behind his mind-blowing Excel tutorials on YouTube.  Learn the magical process that grew Oz's following on YouTube to 25,000 subscribers.

View Details

Joining me on this episode are the hosts of the Financial Modelling Summit 2021. Financial models, and the modellers behind them, must be ready to step up and help businesses take advantage of opportunities. In a fast-changing environment, reliable insights from financial models have never been more significant. Is your financial model ready to elevate your business?

Find out more at https://www.financialmodellingsummit.com/.

View Details

In February 2021 I caught up with Danielle Stein Fairhurst in a live podcast broadcast from the Global Excel Summit (https://globalexcelsummit.com/​). Danielle Stein Fairhurst is a Financial Modelling Specialist at Plum Solutions, an international training and consulting company based in Sydney, Australia. Danielle has over 15 years of experience leading courses in Financial Analysis, Data Analysis, Dashboards and Budgeting and Forecasting in Excel.

View Details

Optimise your work setup with these must-have financial modelling office accessories. From noise-cancelling headphones to keyboards!

The post Must-Have Financial Modelling Office Accessories appeared first on The Financial Modelling Podcast.

View Details

Harriet is a passionate believer in using humour to build rapport and tackle important topics. Author of the bestselling business book, ‘Will It Make The Boat Go Faster?', Harriet explains approaching deal-making with humour in this podcast.  You can sign up for her weekly 'Laugh, Learn and Leg Up' emails here: bit.ly/harrietsignup

View Details

How should financial modellers charge for model building? In this episode, Robin Waite and I discuss how financial modellers can feel confident to bill for their models and discuss pricing with clients.  Robin explains some pricing tactics and how to approach difficult billing conversations with potential customers.  Robin Waite is a business coach and the Founder of The Fearless Business Accelerator

View Details

In this podcast, David Brown (Managing Partner at dbrownconsulting.net) explains the principles to tell a convincing and effective story using a financial model.  David is an experienced consultant and trainer specializing in Financial Modelling and is a Microsoft MVP.  He is also an International Consultant to the World Bank.

David runs both Live-Virtual and self-directed courses which you can check out on www.officetraininghub.com to prepare for your Financial Modeling Institute Certifications. 

View Details

In this podcast, David shares advice from his experience valuing hundreds of companies, businesses and major projects. We speak about the nuances in valuing startups and companies with intangible assets such as a loyal client following or a large social media presence.

David runs his own company providing independent valuation services, strategic consulting, financial analysis, and financial modelling to a range of companies across multiple sectors.

In commerce, he led functions such as Strategy, Corporate Development (M&A) and Finance for a global infrastructure investment manager, a steel manufacturer and energy companies and was the Corporate Finance Lead Director responsible for Business Modelling and Energy Advisory at Deloitte.

He has valued hundreds of companies, businesses and major projects, developed financial models, policies and procedures, been a financial advisor on reforms in the energy, water and port industries and led teams on merger & acquisition projects totalling more than $100 billion.

View Details

Mike Newberry, Finance Practice Lead at Accelytics, is an expert in helping companies generate insight to guide C-Suite decision-making and drive business performance. In this episode, we talk about the challenges faced by finance divisions in moving away from manual tasks to performing analytics that guides business decision making.

View Details

In this podcast, Lauren Ayers takes us through the DISC profile to understand a person’s fears, motivators, values and behavioural style using 4 profile factors.  Lauren is an Australian-based business consultant helping to bridge the gap that exists between the cultural and behavioural elements of people with the needs and goals of organisations.

View Details

Why do financial modellers not benefit from libraries of existing and audited VBA code or modelling techniques like data scientists do? In this podcast, Iain Morrow from Gridlines and I explore why, and Iain proposes Gridlines' innovative solution.

View Details

Bella Funck created the Personal Canvas to help individuals define their purpose, values, passion and vision.  Why are you modelling?  To help build more infrastructure such as schools and wind farms, to value your startup business or to perhaps raise capital to help your company grow?  Bella takes us through the Personal Canvas, while Lance discusses how he found the canvas beneficial.

View Details

In Season 4 of the Financial Modelling Podcast, we explore what makes good financial modellers great.  The ability to tell a story.  Being able to model legal nuances.  Closing deals using the financial model as an effective negotiating tool.  These are just some of the skills we reveal as what you need to know to become a financial modelling master.  Season 4 of the Financial Modelling Podcast is sponsored by Full Stack Modeller.

View Details

Microsoft Excel has introduced Stock Types. Learn what this means and how to use this to build financial models with stocks.

The post Microsoft Excel Stock Types appeared first on The Financial Modelling Podcast.

View Details

Matthew Bernath

Coffee Book Recommendations

• December 7, 2020
• , 9:25 pm
• ,

Coffee, 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.

Coffee Break!

It will be no surprise to any Financial Modelling Podcast listener that I am a massive coffee fanatic (or snob as my wife calls me). In fact, two Financial Modelling Podcasts are dedicated solely to coffee, one on the coffee journey from bean to cup with David Walstra from seam.coffee, and one on some lockdown brews with Dario Scilipoti from Bluebird Coffee Roastery. In this blog post, I provide some insight into my favourite books of the bean.

Coffee: It's not rocket science: A quick & easy guide to brewing, serving, roasting & tasting coffee

If you’ve watched my appearance on Data Conversations over Coffee you will have seen me whip this book off my bookshelf. This is a fantastic and easy reading book, one that you can pick up on any page on a given day for a quick read on some aspect of coffee – whether its equipment, coffee history or bean origins and flavour notes. Beautifully illustrated, this is a book for those who want a brief overview of every coffee nuance.

Buy Now

The World Atlas of Coffee: From Beans to Brewing -- Coffees Explored, Explained and Enjoyed

A photographic journey through the coffee world and history – from the early espresso machines to industrial coffee roasters. Read about the intricate coffee harvesting processes, the different roasting methods and of course about the coffee fruit (which most regular coffee drinkers may not even recognise!). This book has wonderful pictures capturing the coffee process from bean to cup.

Buy Now

Craft Coffee: A Manual: Brewing a Better Cup at Home

Chemex? V60? AeroPress? If you want to start making quality coffee at home, this book will help you figure out what you enjoy drinking, what you need to buy to make it and how to use your newly purchased equipment. By leveraging a four-pillar methodology assessing cost, time, taste and accessibility, this manual will have you making excellent coffee at home in no time at all. Don’t forget to invite me over to taste!

Buy Now

The Coffee Recipe Book: 50 Coffee and Espresso Drinks to Make at Home

If you enjoy playing with flavours and different coffee-based beverages, this book will introduce you to 50 different recipes to spice up your coffee life (pun intended). This book also covers all espresso-based drinks, including my favourite, the cortado. But it’s not only for day-time. This book also includes 10 coffee cocktails, from the Espresso Martini to the Nutty Irishman! A fun book for those looking to experiment with coffee-based drinks (not necessarily for the coffee purist).

Buy Now

Uncommon Grounds: The History of Coffee and How It Transformed Our World

While the other books on this list provide a pictorial history of coffee, this book will weave the stories from the introduction of coffee to various territories to the establishment of chains such as Starbucks. Indeed, this book opens with a quote from Jonathan Swift (Anglo-Irish satirist, essayist, political pamphleteer, poet and cleric, died 1745) who said that “Coffee makes us severe, and grave and philosophical.” This should give an indication of the seriousness of this volume. The book also provides a fascinating description of how the speciality coffee movement came into being. A must-read for anyone interested in how people around the globe came to drink and appreciate the nuances behind the coffee bean!

Buy Now

The post Coffee Book Recommendations appeared first on The Financial Modelling Podcast.

View Details

The final episode of the Financial Modelling Podcast Season 3 was recorded live as we came together from all four corners of the globe. How do we keep connection and community going when opportunities to meet face to face are limited? The host of the Financial Modelling Podcast, Matthew Bernath joins from Johannesburg, Virtual Meetup host and Financial Modeller, Danielle Stein Fairhurst in Sydney, are joined by Jordan Goldmeier from New York and Tea Kuseva from London.

View Details

Jordan Goldmeier is an internationally recognized analytics professional and data visualization expert. In this podcast, we chat about the use of Excel as a data analytics tool, what Microsoft tools data analysts should be focusing on, and his work helping managers communicate, challenge, and visualize data between teams.

View Details

In this podcast, I chat with Ian Bennett, Partner, Deals Modelling, PwC Australia about financial modelling in the cloud and other financial modelling innovations.  Who will take the first step into a new financial modelling world?

View Details

Tatiana Ufimtceva from keySkillset has led a fascinating life, that has taken her from her hometown in Russia to New York where she founded the Excel training company. keySkillset gamifies training and recently was awarded a Financial Modelling Innovation Award for Education.  The awards complemented their fresh, enjoyable and engaging approach to financial modelling training.  In this interview we chat about the importance of education and bringing people together from across the globe.

View Details

I've been addicted to Arixcel since I first saw it in January of 2016.  Since then, I can't work in Excel without this simple, yet powerful add-in!  From advanced formula interrogation, Arixcel has expanded its offering to include formula maps and workbook comparison functionality.  In this podcast, I chat with Igor Popov, Arixcel creator, on why simpler is better.

View Details

In Episode 13 of Season 3, I discuss the intersection of financial modelling and data analytics with Neil Macdonald and Paul van Loon from Forecast.  What is the role of data analytics in financial modelling, and how do these two key skills complement each other?  This is a special Financial Modelling Summit edition of the podcast.

View Details

In this episode I catch up with Kenny Whitelaw-Jones from Season 3 sponsor, Gridlines.  We discuss the current global pandemic, and how the Financial Modelling Summit was born.  

View Details

In this episode, I chat to Craig Steward from Corinium Global Intelligence on the current state of data analytics, and how his business has transformed to offer digital events.  We discuss the future of analytics and how the COVID-19 pandemic has put data analytics in the spotlight.

View Details

In Episode 10, I catch up with Nathaniel Baker, host of The Contrarian Investor Podcast. We discuss how the markets seem to be behaving in a contrarian fashion these days, and what his forecast is for the market and economic trends. From globalisation to movie theatres, we discuss it all!

View Details

As most of us are isolating at home during this pandemic, and coffee shops around the world are closed, we still crave a good brew to fuel our financial modelling! Enter roasteries offering speciality coffee for home brewing. Whether you're drinking espresso, a cortado, a pour-over or a french press coffee as you tune in, hear some home brewing tips from Dario Scilipoti from BlueBird Coffee Roastery!

View Details

Season 3 of the Financial Modelling Podcast focuses on the tools and technologies that make financial modellers' lives easier.  It also looks at the Global Excel Summit which was due to happen in April 2020 but was postponed (with all other conferences) due to the global pandemic.  In this episode, I catch up with co-founder Elena to hear the latest Summit news and how they are dealing with this unique situation.

View Details

Excel Analyzer gives users the power to clean, optimize and analyze Excel files and financial models. It is well known that virtually every Excel model contains errors, however, tools such as Excel Analyzer allow us to interrogate our models to ensure they are correct as possible. In this episode, I chat to podcast regular Lance Rubin and Excel Analyzer creator Maarten Bessems.

View Details

OAK is a spreadsheet auditing Excel Add-in that helps builders and reviewers save time and effort getting to grips with spreadsheet structures and formulas. In this episode, I chat to Rui Sobreiros on where OAK came from, how it helps modellers around the world and what the new version holds in store for us.

View Details

In episode 5 of the Financial Modelling Podcast, I chat to Zoltan Hegedus about the work he has done to enable modellers to better understand their models.

View Details

Gianluca Bisceglie spent time in private equity before founding Visyond.  His time as a private equity deal maker made him realize the inefficiencies in the system, and he set out trying to solve these issues by developing a secure and automated platform for spreadsheet collaboration, analysis and reporting.

View Details

In Episode 3 we are joined by Tea Kuseva and Elena Lalovska to chat about what will be happening at the Global Excel Summit in April, why they chose London and what they love about Excel.

View Details

In episode 2, Kenny Whitelaw-Jones from season 3 sponsor Gridlines joins the podcast to discuss his highlights for 2020 and how Gridlines have developed a financial modelling technology stack to empower their modelling team.

View Details

Welcome back to the Financial Modelling Podcast!  In this introduction episode to season 3, I outline some of the upcoming guests on the podcast and talk about the Global Excel Summit happening in London in April 2020.

View Details

In the finale of the Financial Modelling Podcast Season 2, Lance Rubin, Colin Human, Oz du Soleil, Brian Donnelly and myself discuss the best and worst of Microsoft Excel, financial modelling and what the future holds.  Join us as we take a journey around the world of Microsoft Excel experts!

View Details

Skyline AI is an artificial intelligence investment manager for commercial real estate.  In the penultimate Financial Modelling Podcast of Season 2, I interview Skyline AI co-founder and CEO Guy Zipori.  We discuss how AI is helping managers make better decisions, why he chose the real estate industry and the role financial modelling plays in Skyline AI.

View Details

How are shopping centres, residential developments and the tallest buildings in the world financed?  At the core of each of these transactions is a real estate financial model.  In this podcast, we chat with Andri Rabetanety, a real estate financial modelling expert.  We talk about the intricacies of real estate models, how banks are facilitating the financing of social housing projects and the emergence of PropTech.

View Details

What is Project Finance?  What differentiates it from corporate or leveraged finance?  Why does it suit infrastructure projects and what are infrastructure financing models all about?  Find out in this episode of the Financial Modelling Podcast, based on my popular blog post and download.

View Details

Can you create a financial model using an Excel add-in?  Is creating a model as easier as selecting a few options from a modelling wizard?  In this episode of the Financial Modelling Podcast, we chat to Alexander Artajaya about how he dived into the world of financial modelling using add-ins.  We discuss the pros and cons of Excel financial modelling tools, and what could soon be the future of financial modelling.

View Details

As an investment analyst, should you learn Microsoft Excel or Python?  Will the future of asset management be dominated by Robo-asset managers?  In this podcast, we delve into the world of Asset Management with Dan Page.  He explains why every future financial modeller and investment manager needs to not only know finance, but at least two programming languages!  Find out why in this fascinating deep dive into the world of quantitative analysis.

View Details

Why does every startup need a financial model?  What is the purpose of a financial model, and how can it help a business grow, obtain finance and avoid bankruptcy? Find out in this podcast on financial modelling for entrepreneurs, startups and small businesses!

View Details

According to Ronak Gopaldas, "the key to being successful in Africa hinges on understanding it properly.  The nuances, the subtleties and the intricacies.  The stuff you don't get from sitting behind a desktop."  Ronak is a director of Signal Risk, an African risk management consultancy, and is a Tutu Fellow.  In this podcast, we discuss how to identify risk and opportunities on the vast African continent.  We also discuss the five current trends in Africa.

View Details

In the summer of 2016, entrepreneur Sam Floy packed up his life in London and took a one-way flight to East Africa.  After a brief tour, he settled down in Nairobi, Kenya to start a few businesses.  He is still there, running a couple of successful companies and experiencing Kenyan life.  In this podcast, I ask him what attracted him to Kenya, what startup opportunities are like there and what the challenges are.

View Details

As a traded commodity, the price of a kg of arabica coffee has dramatically fallen. For many farmers & producers, this price has fallen to a level below the costs of production.  Thirdspace and SEAM is a coffee roaster focused on connecting farmers & consumers through generous & transparent trade. In this episode, I chat with David Walstra from Thirdspace on what ethically sourced coffee means and how to run a coffee shop!  I love coffee, and knowing that everyone is treated fairly throughout the coffee making process means a lot to me as I enjoy my cortado!

View Details

Debt sculpting is an exceptionally powerful tool to not only match debt repayments with cash flows which may be increasing or varying over time, but also to maximise the debt in a project.  This podcast is the culmination of a three-part tutorial comprising of a downloadable Excel example, a Financial Modelling Podcast blog post and a podcast.  Go through all three to master the art of debt sculpting!

View Details

What does it mean to go against the flow and maintain belief in yourself when no-one else does?  In this episode, we discuss the art of contrarian investing - buying and selling against popular opinion.  It may take years for contrarian investors to be proven right, but when they are it is typically in spectacular fashion.  Tune in to find out what contrarian investing means.

View Details

What will the workplace of the future look like?  According to Adi Kaimwoitz, it's not necessarily the offices of the firm or client you work for!  Adi Kaimowitz is CEO of Virtual Actuary, a company that empowers actuaries to utilize cutting edge technology platforms, as they apply actuarial techniques to deliver insights which are pre-emptive, precise and practical.  In this podcast, I ask him about this innovative business model.

View Details

He has authored 54 books about Microsoft Excel, Power Pivot and Power View.  He publishes books about Microsoft Office. You will find him on the road doing live Power Excel seminars for 35 events a year. He has over 2000 Excel videos on YouTube.  He is regarded as an Excel master and is known online as Mr Excel.  In this podcast., I ask him what's next for Microsoft Excel.

View Details

Hedging is incredibly important, especially for large infrastructure projects which run the risk of being underfunded if currency and interest rates move in the wrong direction!  In this episode, I chat with Lionel Kruger who provides infrastructure hedging strategies.  We discuss the importance of hedging and how it is done.

View Details

In this FMP Short Stuff episode, I discuss the DSCR.  Why is the DSCR so important that banks make it a covenant?  Best you do not breach this key ratio which dictates how easily you can service your debt in any given period from cash flow.  The DSCR is a key metric for any deal and shows how capable a project is of paying its debt. 

View Details

Africa contains enormous potential, and firms need to think hard about where to focus their efforts on the African continent.  Celeste Fauconnier and Neville Mandimika are Africa investment experts who assess opportunities and analyse the risks of various African markets.  Join me as I discuss their latest Where to Invest in Africa report.

View Details

Welcome to FMP Short Stuff where we discuss financial model essentials in five minutes or less!  Today we discuss the financial model audit and why it is so important.

View Details

What does it mean to be a financial modeller?  The Financial Modeling Institute is standardising this skill by offering professional certification in the form of the Financial Modeling exams, from Level 1 (Advanced Financial Modeler) to Level 3 (Master Financial Modeler).  The FMI  is advancing the financial modelling profession by delivering and administering the Financial Modeling Certifications and supporting high-quality education and training for financial professionals.  In this interview, I chat with Ian Schnoor from the FMI.

View Details

Chandoo.org is one of the top online Excel resources, with tutorials on everything from dashboards to financial modelling.  Chandoo is the CEO, or Chief Excel Officer, of Chandoo.org, which provides training on Excel and PowerBI.  He is also an Excel MVP.  In this interview, I chat with Chandoo about Excel trends and how he became an Excel master.

View Details

Spreadsheets are amazing tools - versatile and capable of many different jobs.  Unfortunately, the same ease of usability and access means they can be a source of risk.  How can companies effectively manage the risk of many spreadsheets and processes running throughout the organisation?

ClusterSeven enables enterprises to understand, manage and monitor their key business applications that sit outside of IT’s control, such as Excel Spreadsheets.  In this episode, I interview Alex Subba Row from ClusterSeven to talk about what this risk is and how it can be managed.

View Details

Very few people decide to uproot their entire lives and start a new business on a different continent, but Sean Keough did just that! Join me through sometimes patchy audio quality as I chat to Sean about business in Ethiopia, a country averaging growth over 10% per annum over the past 10 years.

Sean runs Ethiopia Investments Limited, a permanent capital vehicle focused on Ethiopia and is also an executive director of EQOS. EQOS Global is Ethiopia's first business process outsourcing (BPO) company. The Company provides various ICT services (data entry, data quality, data cleansing, data mining, data transcription and database management services) for customers located in the US and the UK.

View Details

In this episode, we chat to Daniel Tenzer, Actuarial Manager at SNG Argen, about what an actuary actually does!  He explains what actuaries study and how this enables them to perform company valuations and even data science.  If you have thought about studying actuarial science, or are just interested in the profession, this episode is for you.

View Details

Corporate Finance Institute (CFI) is an online financial analyst training and certification organization with 160,000+ students from over 170 countries. CFI is the official provider of the Financial Modeling & Valuation Analyst (FMVA) designation, a program designed to help anyone become a "world-class financial analyst". The curriculum focuses on practical applications of accounting, finance, Excel, financial modeling, valuation, presentations, and business strategy.

In this episode, I chat with Tim Vipond, CEO and co-founder of CFI on how the company works, and whether training and economic activity are linked. In addition, Financial Modelling Podcast listeners can get 10% off CFI courses.

View Details

In this podcast, I chat to Stefanie Bourne, Business Director, Renewable Energy Project Development at DNV GL. DNV GL acts as a lender's technical advisor on a number of infrastructure projects, as well as providing a myriad of other services.

We discuss wind power, project finance, due diligence and data science.

View Details

In this crossover episode, I chat to Andrew Ward from INFRACAST about financial modelling for infrastructure.  

View Details

In this podcast we interview Joey French, co-founder, President & CFO of Intrinio, a company based in Florida, USA. Intrinio provides access to a wealth of financial data through an API platform, including many SDKs to major programming languages, an Excel Add-In, and a Google Sheets add-on.

In this episode, we discuss financial data and how Intrinio aims to provide clean financial data to businesses, developers and entrepreneurs.

View Details

Adrian Miric is an Excel expert, financial modeller and trainer.  In this episode, we discuss how important staying relevant with Microsoft Excel updates is, and how powerful these new tools are!  Adrian also explains how he started his own consulting and training firm and some of his experiences in running his own business.

View Details

  Every major project and deal is underpinned by a financial model. Models give insight and help drive value. As the world changes so models change to keep up and modellers have to develop new approaches and new solutions. These awards were created to recognise new ideas and innovators in the dynamic field of financial modelling.

View Details

In this episode, we interview Russell Nel, a privacy expert who explains what privacy means to individuals and companies, and why privacy is a basic human right.

We delve into the history of privacy as a human right and discuss what it means for both financial modelling and data science.

View Details

This episode sees Rickard Wärnelid, Mazars Infrastructure & Energy sector lead, discuss infrastructure finance and standardisation of these unique financial models. Rickard also elaborates on his path from a quantitative analyst to running Corality, a leading provider of infrastructure financial modelling training, to his current role at Mazars.

View Details

In this episode, we discuss how Export Credit Agencies support transaction around the world with Inal Henry.

We delve into the details of export finance and how many projects rely on this support to obtain bank finance.  We also investigate how this field may be changing in the future to support the export of technology.

View Details

In this episode, we get to the bottom of what maths of finance is all about!  Cyprian Moloto, a quantitative risk analyst, explains how he uses maths every day in one of Africa's largest investment banks.

From credit rating methodologies to machine learning - this episode dives into the details of this fascinating field!

View Details

Join us as we chat to Wouter du Preez, an aviation financier.  Wouter discusses aircraft leasing and how finance works in the aviation sector. He also discusses how big data has an increasingly important role in aviation finance.

View Details

In this episode, Alan Chown, Inflation Trader at Rand Merchant Bank, discusses how the inflation market works and how to model inflation in financial models.  We discuss how countries and traders view inflation, and how to estimate this important assumption which can affect both revenue and costs!

View Details

In this podcast, we chat to Colin Human, CEO of GoalFix Financial Modelling. Colin has been a financial modeller for 40 years, and also trains and lectures on financial modelling worldwide.

Colin chats to us about his company, how he started financial modelling and what it is like to run a financial modelling firm.

He also gives advice to those looking to start financial modelling or a small business.

View Details

In this episode, we chat to Dave Theron - a South African financial modelling legend.  Dave shares with us his financial modelling story, from using punched cards and running scenarios using mainframes, to his career as a lecturer and trainer.

Dave is well known in the South African and global financial modelling world, having trained in Singapore, Hong Kong, Malaysia, Australia, New Zealand, Namibia and South Africa.

Join us as we travel back in time to the beginning of financial modelling.

View Details

In this episode, we chat to Danielle Stein Fairhurst from plum solutions. Danielle is an author, financial modeller and host of the Australian financial modelling meetups. She talks to us about modelling trends and how to learn from other financial modellers, as well as her latest book!

View Details

The accurate financial modelling of infrastructure projects is critical to ensure they are properly banked and robust enough to handle any circumstances that may arise.  Hear from Dario Musso, the Head of Infrastructure Finance at Rand Merchant Bank, as we discuss how infrastructure finance modelling has evolved and what role it plays in banking today.

View Details

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 to be one of the top skills required for Finance professionals in today’s corporates, business or even government. What does all this innovation and disruption mean for financial modellers, or anyone working in finance?

Hear from financial modelling expert, Lance Rubin (https://au.linkedin.com/in/lance-rubin-33a61b), who disrupted 75% of his own role as the CFO at the fintech start-up, Banjo, by using some of this technology.  Lance Rubin is the CEO of Model Citizn, a Melbourne-based financial modelling consulting firm that specialises in building models across a range of sectors including social benefit bonds, infrastructure and property and financial services for companies and investment trusts. Lance whilst remaining as the CFO of Banjo is also a contractor to the KPMG Australia modelling team and has over 20 years in financial services