1. Corporate Solvency & Supply Chain Financial Performance: An Industry Benchmark Audit

This project delivers a full five-year financial performance and ratio analysis of Auto Trader Group Plc, evaluating the financial footprint and working capital efficiency of the UK’s leading digital vehicle marketplace network. Using structured financial statements, ratio modelling, and visual analytics, the project evaluates profitability, liquidity, gearing, efficiency, and shareholder performance. Companies and financial institutions listed worldwide can use the analytical framework for performance benchmarking and investment decision-making.

Domain: Automotive Marketplace & Distribution Logistics
Industry Focus: UK Automotive Sector Benchmarking
Techniques: Longitudinal Financial Auditing, Working Capital Optimisation, Cash-to-Cash Cycle Impact Modelling

Business Objectives

Assess five-year financial performance using income statements and balance sheets
Identify profitability and cost-efficiency trends
Evaluate liquidity and solvency risk
Measure shareholder value through investment ratios
Demonstrate financial dashboarding for executive decision support
How do variations in inventory turnover and receivable days actively compress a distributor’s current ratio?

Data & Tools

Financial statements (Income Statement & Balance Sheet)
Excel financial modelling
Ratio analysis framework
Power BI dashboards
Tableau financial visualisations

Key Financial Metrics Analysed

Revenue growth and operating profit
Gross and net profit margins
Return on capital employed (ROCE)
Liquidity ratios (current & quick)
Gearing ratios (debt-to-equity, interest cover)
Efficiency ratios (asset turnover, receivables days, payables days)
Investment ratios (EPS, dividend cover, P/E ratio)

Five-year trend analysis of revenue, net profit, operating costs, and dividends to evaluate financial stability and growth trajectory.

The trends in gross margin, net margin, and ROCE underscore operational efficiency and capital performance.

Liquidity strength and solvency risk are measured through current ratio, quick ratio, and debt-to-equity trends.

Shareholder return indicators, including EPS, dividend cover, and price-to-earnings ratio, over five years

Key Insights

Revenue and profit recovered strongly after the 2021 downturn
ROCE remained consistently high, indicating efficient capital deployment
Liquidity improved year-on-year, reducing short-term risk
Gearing remained stable, with strong interest coverage
Dividend stability suggests sustainable shareholder return

Serving international organisations Relevance

This analytical framework directly mirrors the financial performance assessment used by World banks, investment firms, and corporate finance teams. The same methodology can be applied to ASX-listed companies such as Seek, Carsales.com.au, REA Group, and Domain Group to assess the profitability of digital platforms, operational efficiency, and investment risk.

International consulting firms, equity analysts, and CFO teams can use this model to benchmark performance, identify margin pressure, and support capital allocation decisions across sectors, including e-commerce, fintech, and digital marketplaces.

Strategic Use Cases Across global industries

Financial benchmarking for ASX-listed firms
Investor reporting dashboards
Risk assessment for lenders
M&A due diligence screening
Board-level financial performance reporting

Deliverables

Executive financial dashboards (Power BI / Tableau)
Structured ratio models in Excel
Trend analysis visualisations
Written financial interpretation
Investment and liquidity risk summaries

Why This Project Matters

This project demonstrates how macroscopic operational costs, asset turnover, and liquidity structures directly impact investor valuations. For mid-market automotive distributors and supply chain networks, this analytical framework proves how optimising working capital directly safeguards corporate solvency and frees up trapped cash during economic shocks.

2. Applied Industrial Research: Inventory Strategy Transition (JIT to Hybrid JIC Models)

This enterprise-grade research evaluates the structural transition of 14 major automotive manufacturers from pure Just-in-Time (JIT) efficiency to resilient, hybrid Just-in-Case (JIC) buffering operations under severe global maritime shocks.

Domain: Global Supply Chain Networks & Network Design
Industry Focus: UK Automotive Manufacturing (Comparative Luxury vs. Mass Segments)
Techniques: Multi-Tier Network Analysis, Time-Series Disruption Mapping, Dynamic Capability Indexing (DCI), Flow-Dependent Route Engineering

📊 Phase 1: Strategic Context & Analytical Scope

Core Business Challenge

Traditional efficiency-focused automotive operations rely on near-zero redundancy. Between 2019 and 2024, persistent global disruptions—culminating in a 50%+ contraction in Suez Canal traffic and up to 40+ day transit delay cycles—proved that uncalibrated lean structures create catastrophic operational vulnerabilities under geopolitical stress.

This project explores how premium and volume manufacturers systematically transitioned toward selectively buffered safety stocks without entirely sacrificing cost control.

Primary Business Questions

How do multi-node trade delays alter baseline inventory days (DIO) and cash-to-cash metrics across distinct industrial segments?
What specific operational thresholds trigger a structural pivot from Suez Canal transit to flow-dependent routing around the Cape of Good Hope?
To what extent does a firm’s internal Digital Capability Intensity (DCI) mitigate cost shocks compared to simple, uncoordinated stock hoarding?

📈 Phase 2: Visualizations & Deep Data Analysis

🖼️ Chart Component 1: Systemic Buffer Expansion

3. Market Basket Analysis – Retail Transactions

This project analyses retail transaction data using SQL and Power BI to identify product combinations, cross-sell opportunities, and bundle strategies tailored for the Australian and Global FMCG market.

Domain: Customer & Retail Analytics
Industry Focus: Across global industries FMCG & E-commerce

Tools: SQL, Power BI
Techniques: Market basket analysis, association rules, product affinity modelling

Business Questions

Which products are most frequently purchased together?
What product pairs generate the highest lift and cross-sell potential?
How does the basket size impact revenue and purchase behaviour?
Which bundles can increase average order value for International retailers?
How can cross-selling logic be operationalised in marketing and merchandising?

Data & Modelling

Retail transaction data was processed using SQL to construct basket-level tables. Association rules were applied to calculate support, confidence, and lift values for all product combinations. These metrics were then visualised in PowerBI for commercial interpretation.

Dashboards & Outputs

Product association rules table
Basket size distribution
Revenue by country
Cross-sell probability chart
Bundle recommendation matrix

Strategic Opportunities across Global Business Regions: FMCG Market

This analysis translates transaction-level data into commercial actions for Australian retailers and FMCG brands.

Introduce data-driven seasonal bundles based on high-lift product pairs
Encourage medium baskets (3–5 items) to upgrade to large baskets (6+ items) using targeted incentives
Deploy “Frequently Bought Together” logic on product pages
Trigger follow-up offers based on cross-purchase probability
Optimise promotional spend by focusing on proven product affinities

Business Value

Increased average order value
Stronger cross-sell performance
Reduced random discounting
Better merchandising decisions
Measurable revenue uplift

Why This Matters across international business environments

Global FMCG retailers face margin pressure, rising fulfilment costs, and intense price competition. This project demonstrates how customer transaction data can be converted into pricing, bundling, and merchandising strategies that directly support profitability and growth.

Visualization