Best Financial Modelling Short Courses in the UK 2027
Financial modelling is the technical language of UK corporate finance, investment banking, and private equity. The ability to build a three-statement model, run a DCF valuation, or stress-test an LBO is what separates candidates who get hired from those who don't — and what drives salary premiums throughout a finance career. In 2027, AI tools have changed how models are built, but not whether you need to understand them. This guide covers the best financial modelling short courses available in the UK in 2027: from online self-paced programmes like FMVA and BIWS through to London-based workshops and ICAEW-accredited Excel credentials — with honest guidance on where to start, what each course covers, and what you can expect to earn.
Key Takeaways
- ✅ Most comprehensive online: CFI FMVA — structured curriculum, globally recognised, ~£400–£600
- ✅ Best for IB interviews: Breaking Into Wall Street (BIWS) — investment banking focused, ~£400–£600
- ✅ Best in-person intensive: Macquarie Financial Modelling Workshop — 3 days London, ~£1,500–£2,500
- ✅ ICAEW credential: ICAEW Excel for Finance — UK-recognised, suited for ACA/ACCA-qualified professionals
- ✅ Build Excel fluency first — most modelling courses assume intermediate Excel
- ✅ IB analyst salary (London): £60,000–£85,000 base | FP&A analyst: £38,000–£58,000
Find Your Perfect Course
Tell us what you're looking for — we'll match you with the best courses and providers. Free, no spam.
Financial Modelling in UK Finance: The 2027 Landscape
London remains one of the world's two preeminent financial centres, and the demand for technically proficient finance professionals has not diminished. What has changed in 2027 is how financial models are built and reviewed: AI-assisted modelling tools (Microsoft Copilot in Excel, emerging AI valuation platforms) can now construct model skeletons from natural language prompts. But this has not reduced demand for financial modelling skills — it has amplified the value of practitioners who can direct AI tools intelligently, audit their outputs, and build on their foundations.
The core financial modelling skill set remains: Excel proficiency at an advanced level, understanding of financial statements (P&L, balance sheet, cash flow), DCF valuation, comparable company analysis, precedent transactions, M&A modelling, LBO modelling, and sensitivity analysis. These skills are the foundation that AI tools extend — not replace.
Where Financial Modelling Skills Are Used in UK Finance
- Investment banking (M&A, ECM, DCM): Deal analysis, pitch books, fairness opinions, financial sponsor coverage. LBO and M&A modelling essential.
- Private equity: Target company analysis, deal structuring, portfolio monitoring, fund returns analysis. LBO modelling is the core technical interview test.
- Corporate finance / transaction advisory (Big Four, boutiques): Financial due diligence, valuation, SPA support. Three-statement modelling + valuation.
- Equity research: Company financial models, earnings forecasting, price targets. Three-statement + DCF/comparable company analysis.
- FP&A (Financial Planning and Analysis): Corporate forecasting, scenario modelling, variance analysis. Excel/BI-based modelling in corporate environments.
- Project finance (infrastructure, energy, real estate): Project cash flow modelling, debt sizing, covenant compliance. Highly specialised modelling discipline.
1. CFI FMVA (Financial Modeling & Valuation Analyst)
The FMVA from Corporate Finance Institute (CFI) is the most widely completed online financial modelling certification globally and is well-recognised by UK finance employers. The curriculum covers:
- Excel fundamentals and best practices (formatting, shortcuts, efficiency)
- Financial statement analysis and accounting mechanics
- Three-statement model construction from scratch
- DCF (Discounted Cash Flow) valuation
- Comparable company analysis and precedent transactions
- M&A modelling (accretion/dilution analysis)
- LBO modelling (leveraged buyout analysis)
- Sensitivity analysis and scenario modelling
- Budgeting and forecasting models
Duration: Self-paced; typically 6–12 months for full programme | Cost: ~£400–£600 (CFI subscription or bundle, varies by region) | Certificate: FMVA designation upon completion | Delivery: Fully online, downloadable Excel models included
The FMVA curriculum is extensive and covers more ground than most competitors. For professionals wanting a comprehensive self-study route into financial modelling, it is the best value option available. CFI also offers the BIDA (Business Intelligence & Data Analyst) and CBCA (Capital Markets & Securities Analyst) as complementary credentials.
2. Breaking Into Wall Street (BIWS)
Breaking Into Wall Street (BIWS) is widely regarded as the most interview-relevant financial modelling training available for investment banking, private equity, and hedge fund candidates. Its founder built the programme based on actual investment banking training materials, and the content is uniquely focused on what is actually tested in IB/PE interview processes.
The core BIWS programmes:
- Core Financial Modeling: Three-statement models, DCF, LBO, M&A. The foundation package.
- Bank & Financial Institution Modeling: Specialist coverage of financial sector modelling.
- Real Estate Financial Modeling: REIT, commercial real estate, and development modelling.
- Industry-specific packs: Oil & gas, mining, biotech modelling.
Cost: ~£400–£600 per programme (premium pricing reflects premium quality) | Delivery: Online video + downloadable Excel models | Best for: IB and PE interview preparation, career switchers targeting top-tier finance roles
3. Wall Street Prep (WSP)
Wall Street Prep is used by bulge bracket investment banks for analyst and associate training, and offers premium self-study programmes mirroring that institutional training. Key programmes:
- Financial Modeling Fundamentals: Core modelling skills with three-statement integration, DCF, and comparable companies.
- Premium Package: Adds LBO, M&A, restructuring modelling, and real estate.
- Certified Financial Modeling & Valuation Analyst (FMVA) equivalent from WSP on completion.
Cost: ~£400–£700 depending on package | Delivery: Online with downloadable Excel workbooks and video walkthroughs | Best for: Candidates who want IB-standard training material and the institutional credibility that WSP's bank partnerships provide
| Programme | Best For | Duration | Cost (GBP approx.) |
|---|---|---|---|
| CFI FMVA | Comprehensive self-study | 6–12 months | ~£400–£600 |
| BIWS Core Financial Modeling | IB/PE interview prep | Self-paced | ~£400–£600 |
| Wall Street Prep Premium | IB analyst training | Self-paced | ~£500–£700 |
| Macquarie FM Workshop (London) | Intensive hands-on (in-person) | 3 days | ~£1,500–£2,500 |
| ICAEW Excel for Finance | ACA/ACCA-qualified professionals | 2–3 days | ~£500–£900 |
| Analyst Academy (online) | Affordable Excel/FM fundamentals | Self-paced | ~£100–£200 |
4. Macquarie Financial Modelling Workshop (London)
Macquarie's Financial Modelling workshops are among the most respected in-person financial modelling training programmes available in the UK. Delivered over 3 intensive days in London, the workshops combine lecture, hands-on Excel modelling, and model review — covering three-statement models, DCF valuation, and transactions modelling with a focus on practical speed and accuracy.
Duration: 3 days (typically Mon–Wed, London) | Cost: ~£1,500–£2,500 | Best for: Finance professionals who want intensive, face-to-face modelling practice and a credential from a respected provider; corporate finance practitioners wanting to accelerate from intermediate to advanced modelling
Macquarie workshops are regularly attended by Big Four corporate finance professionals, boutique advisory staff, and corporate treasury practitioners. The in-person format provides a level of instructor feedback and peer practice that self-study programmes cannot replicate.
5. ICAEW Excel for Finance
The Institute of Chartered Accountants in England and Wales (ICAEW) offers an Excel for Finance short course — particularly relevant for UK-qualified accountants (ACA, ACCA, CIMA) who want to formalise their Excel and modelling skills with an ICAEW credential. The course covers advanced Excel functions in a finance context, model construction best practices, and data analysis.
Duration: 2–3 days | Cost: ~£500–£900 through ICAEW or accredited providers | CPD: Counts toward ICAEW ACA CPD requirements | Best for: ACA, ACCA, or CIMA-qualified accountants moving into corporate finance, M&A, or FP&A roles
Find Your Perfect Course
Tell us what you're looking for — we'll match you with the best courses and providers. Free, no spam.
Financial Modelling Best Practices: What Good Looks Like
Technical proficiency in Excel and model mechanics is not sufficient — financial models must also be auditable, flexible, and clearly structured. UK banks and advisory firms use specific best practice standards that candidates are expected to follow:
- Colour coding: Blue for inputs/hardcoded numbers, black for formulas, green for links from other sheets. Consistently applied throughout.
- Separation of inputs and calculations: Assumptions clearly separated from working sheets and output sheets.
- No hard-coded numbers in formulas: Every number that could change should reference a labelled input cell.
- Circularity management: Interest circularity (interest depends on debt balance which depends on cash which depends on interest) handled through circular reference switches or iterative calculation.
- Error checks: Balance sheet balance check (Assets = Liabilities + Equity), cash flow check, and key metric cross-checks built into the model.
- Scenario switches: Named scenarios (base/upside/downside) linked to a dedicated scenario input section — not duplicated sheets.
BIWS and Wall Street Prep both teach these standards rigorously. CFI FMVA covers them as part of the Excel foundations module. Macquarie workshops are particularly strong on model structure and best practice enforcement.
AI and Financial Modelling in 2027
AI-assisted modelling has become a practical reality in UK corporate finance in 2027. Microsoft Copilot in Excel can generate formula suggestions, write XLOOKUP formulas from natural language, and explain model logic in plain English. Emerging AI valuation tools can construct model frameworks from company descriptions. Institutional platforms like Visible Alpha and Bloomberg use AI to automate consensus model aggregation.
For finance professionals, AI tools accelerate model construction — but require strong foundational knowledge to direct and audit. An analyst who doesn't understand three-statement mechanics cannot verify an AI-generated model for errors. The value of financial modelling training has therefore not decreased — it has shifted from rote construction to intelligent oversight and interpretation.
Salary Overview: Financial Modelling Roles in the UK (2027)
| Role | Sector | Salary Range (GBP) |
|---|---|---|
| FP&A Analyst | Corporate (all sectors) | £38,000–£58,000 |
| Equity Research Analyst | Asset management / sell-side | £45,000–£70,000 |
| Corporate Finance / M&A Analyst | Big Four / boutique advisory | £45,000–£70,000 |
| Project Finance Analyst | Infrastructure / energy | £42,000–£65,000 |
| Investment Banking Analyst | Bulge Bracket / Elite Boutique | £60,000–£85,000 base (+bonus) |
| Private Equity Analyst | PE fund | £65,000–£95,000 base (+carry) |
| IB Associate / VP | Investment banking | £80,000–£150,000 base (+bonus) |
Choosing the Right Financial Modelling Course
- New to finance, want a comprehensive foundation: CFI FMVA is the best value self-paced programme. Comprehensive, structured, widely recognised. Start with the Excel fundamentals module before the modelling content.
- Targeting investment banking or private equity: BIWS or Wall Street Prep Premium. Both are built around the specific content tested in IB/PE interviews. BIWS is slightly more interview-focused; WSP has stronger institutional backing.
- Want intensive, in-person practice in London: Macquarie Financial Modelling Workshop. Three days, hands-on, instructor-led. Worth the higher cost for professionals who learn best by doing.
- ACA/ACCA/CIMA qualified, want an ICAEW-credentialled Excel course: ICAEW Excel for Finance. Formal UK credential, counts toward ACA CPD, respected by employers.
- On a tight budget wanting to build fundamentals: Analyst Academy (online, ~£100–£200) or free YouTube channels (Macabacus, Mergers & Inquisitions) combined with Microsoft Excel Specialist certification (~£100).
- PE-specific modelling (LBO): BIWS or Wall Street Prep Premium both include dedicated LBO modules. CFI FMVA LBO module is also solid.
Related Guides
- Best Finance & Accounting Short Courses UK
- Best Business Analytics Short Courses UK
- Best Accounting & Finance Short Courses UK
- Best Digital Transformation Short Courses UK
Frequently Asked Questions
What is financial modelling and why is it important in UK finance careers?
Financial modelling is the process of building structured representations of a company's financial performance — past, present, and projected — typically in Excel or a specialist financial modelling platform. Models are used to support investment decisions, mergers and acquisitions analysis, capital raising, project finance, budgeting, forecasting, and strategic planning. In UK finance careers, financial modelling is a core technical skill expected in investment banking, private equity, corporate finance, transaction advisory, equity research, real estate finance, and FP&A (Financial Planning and Analysis) roles. Candidates who can build clean, auditable, dynamic financial models are significantly more hireable and command higher salaries than those who cannot. In 2027, AI tools can assist with model construction — but understanding how models work, how to stress-test them, and how to interpret outputs remains a distinctly human and highly valued competency.
What is the FMVA certification and is it recognised by UK employers?
The FMVA (Financial Modeling & Valuation Analyst) is a professional certification offered by CFI (Corporate Finance Institute), a Canadian-based online finance education provider. The FMVA curriculum covers financial statement modelling, valuation (DCF, comparables, precedent transactions), M&A modelling, LBO modelling, sensitivity analysis, and presentation. It is delivered entirely online and is self-paced. The FMVA is widely recognised by UK finance employers — particularly in investment banking, corporate finance, and FP&A roles — as evidence of structured financial modelling training. It is not a regulated UK qualification (unlike ICAEW, ACCA, or CIMA) but carries strong brand recognition in global finance. Completing the FMVA alongside a professional accounting qualification (ACA/ACCA/CIMA) creates a highly competitive combination for UK corporate finance and advisory roles.
What are the best resources for learning financial modelling from scratch in the UK?
The best structured resources for learning financial modelling from scratch in the UK include: CFI FMVA (Corporate Finance Institute Financial Modeling & Valuation Analyst) — the most comprehensive self-paced online programme. Covers everything from Excel fundamentals through to LBO and M&A modelling. Breaking Into Wall Street (BIWS) — widely regarded as the highest-quality financial modelling training for investment banking candidates. More expensive (~£400–£600) but extremely detailed and interview-focused. Wall Street Prep — used by investment banks for analyst and associate training. Macquarie Financial Modelling Workshop — a 3-day intensive in London and other UK cities, highly regarded for hands-on modelling practice. The ICAEW Excel for Finance short course — for UK-qualified accountants wanting to formalise Excel and modelling skills with an ICAEW credential. For complete beginners, a structured Excel fundamentals course (Microsoft Excel Specialist or similar) should precede dedicated financial modelling training.
What Excel skills do I need before starting financial modelling training?
Before starting dedicated financial modelling training, you should be comfortable with: Core Excel functions: SUM, AVERAGE, IF, VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIF, COUNTIF. Pivot tables and data manipulation. Basic chart creation and formatting. Cell referencing (absolute vs relative: F4 toggle). Paste Special (values, formulas, transpose). You do not need to be an Excel expert before starting — most quality financial modelling courses build on Excel fundamentals. However, struggling with basic Excel during a modelling course will slow your progress significantly. If you are not yet comfortable with the above, complete a structured Excel course first: Microsoft Excel Associate certification (MO-200, ~£100) covers the fundamentals and provides a recognised credential. Most financial modelling trainees become highly proficient Excel users through the modelling training itself — the practice is intensive.
How much does a financial modelling analyst earn in the UK?
Financial modelling skills command significant salary premiums in UK finance. Roles where financial modelling is a core requirement: Investment banking analysts (Bulge Bracket / Elite Boutique): £60,000–£85,000 base + bonus (total comp often £90,000–£150,000+ at junior level). Corporate finance / M&A advisory analysts: £45,000–£70,000. Private equity analysts: £65,000–£95,000 base + carry. Equity research analysts: £45,000–£70,000. FP&A analysts (corporate finance teams): £38,000–£58,000. Project finance analysts (infrastructure, energy): £42,000–£65,000. Real estate finance analysts: £40,000–£65,000. At Associate and VP levels (3–7 years experience), salaries in investment banking and private equity rise substantially — Associates at Bulge Bracket banks typically earn £80,000–£120,000 base. Financial modelling skills are valued throughout — financial model quality becomes a career differentiator at senior levels.
What is an LBO model and when do I need to learn it?
An LBO (Leveraged Buyout) model is a financial model used in private equity to analyse the potential returns from acquiring a company using a combination of equity and debt financing. It projects the company's cash flows, models the debt repayment schedule, and calculates the expected return on equity investment (IRR — Internal Rate of Return and MOIC — Multiple on Invested Capital) at exit. LBO models are essential for private equity roles, and LBO modelling proficiency is one of the most common interview tests for private equity associate positions. Investment banking analysts at firms with active PE-backed deal flow are also expected to build LBO models. If you are targeting private equity or leveraged finance roles in the UK, LBO modelling is non-negotiable. Both CFI FMVA and BIWS include LBO modelling modules. Wall Street Prep's premium package includes a dedicated LBO programme that is particularly well-regarded for PE interview preparation.