Financial modelling and forecasting (2024)


  • Latest on financial modelling and forecasting
  • Reports and guides
  • Webinars
  • eBooks
  • Business press
  • Online magazines
  • Articles and books in the ICAEW Library collection

Back to top

Latest on financial modelling and forecasting

Read our latest features and articles on financial modelling and forecasting.

Public finances beat forecast amid tough economic landscape

  • Article
  • 23 Jan 2024

Year-to-date deficit of £119bn is £5bn lower than latest Office for Budget Responsibility forecast – but is still £11bn worse than this time last year.

ESG for SMEs: step-by-step climate scenario analysis

  • Article
  • 26 Sep 2023

How should we strategically position our businesses in the face of climate change? That’s the essential question at the heart of climate scenario analysis.

Why would you not have a practising certificate?

  • Article
  • 20 Sep 2023

With guideline changes coming in January, it’s time to re-examine whether you should hold a practising certificate. ICAEW member and corporate strategist David Blair explains why it’s a good idea.

Cash remains king as businesses gear up for growth

  • Article
  • 17 Apr 2023

Why finance functions tightened their cash management and forecasting during the pandemic – and how those good habits have remained.

Interest rates rise to 4% but shallower recession predicted

  • Article
  • 02 Feb 2023

The Bank of England announces 10th successive increase in borrowing costs – but forecasts that the expected UK recession will be shallower and shorter than previously expected.

How to get TCFD scenario analysis right

  • Article
  • 14 Dec 2022

With many of its underlying requirements open to interpretation, TCFD scenario analysis is a complex area for accountants to navigate. Here is an overview of the main guidance gaps, why they matter – and what companies should do to bridge them.

Read more

Reports and guides

Superforecasting: How to improve your forecasting skills

  • Report
  • 2021

Forecasting is an essential skill for finance professionals and managers. Business decisions of all kinds depend on effective approaches to looking ahead. This guide outlines the core principles of “Superforecasting” which will help you develop your forecasting skills.

COVID-19: nine principles for finance professionals

  • Helpsheets and support
  • 2020

16 April 2020 - The business impact of coronavirus (COVID-19) means effective cash flow analysis and forecasting have never been more important. This guide sets out some principles for adapting your approach to the current crisis.

COVID-19: Six actions for finance professionals on cash flow

  • Helpsheets and support
  • 2020

1 July 2021: How to get cash flowing into your business. This guide shares six practical actions finance professionals may wish to consider when considering cashflow to support their businesses through the coronavirus (COVID-19) crisis.

Financial Modelling code

  • Thought leadership report
  • 2018
  • PDF (1,590kb)

ICAEW’s Excel Community has worked with a broad swathe of modelling organisations and experts, taking a half dozen methodologies and paring down to the commonly held, widely accepted beliefs about what constitutes good modelling. Thus, we’ve created the Financial Modelling Code.

Exclusive Financial Modelling, Issue 63

  • Helpsheets and support
  • 2016
  • PDF (4,453kb)

This 2nd edition is a practical guide to financial modelling in a corporate finance transaction context. That rider is important. The guide is aimed at corporate financiers and modellers who need to prepare, use or review financial models for deals; it is not aimed at financial modellers who need to develop their understanding of corporate finance.

Financial strategy - forecasting issues

  • Report
  • 2016

This quarterly report discusses the risk and rewards of forecasting and the global issues which may affect your models.

More reports


Using scenario planning to navigate uncertainty

  • Webinar
  • 14 Apr 2021

This webinar explores how scenario planning can enhance preparedness and enable executive teams to respond rapidly to an ever changing business landscape.

Lessons for the private sector

  • Webinar
  • 20 Nov 2019

Sir Nicholas Macpherson's 2013 "Review of Quality Assurance of Government Models" resulted in wide ranging and robust changes to the management of business critical models in the sector. This webinar looks back at 5 years of Macpherson.

Stats skills in excel - Forecast probabilities

  • Webinar
  • 25 Sep 2018

Our Excel expert, John Tennent, talks us through the use of Normal distribution curves and Monte Carlo simulation to measure the impact of uncertainty in financial modelling.

Exclusive Stats skills in Excel - Forecasting and trends

  • Webinar
  • 14 Mar 2018

Our Excel expert, John Tennent, talks us through the Excel tools to assist with forecasting and trending.

More webinars


The ICAEW Library & Information Service provides full text access to a selection of key business and reference eBooks from leading publishers. eBooks are available to logged-in ICAEW members, ACA students and other entitled users. If you are unable to access an eBook, please see our Help and support advice or contact

Exclusive Hands-on financial modeling with Excel for Microsoft 365: build your own practical financial models for effective forecasting, valuation, trading, and growth analysis

  • eBook
  • 2022
  • Shmuel Oluwa

Financial modeling is a core skill required by anyone who wants to build a career in finance. This book explores financial modeling terminologies with the help of Excel. Starting with the key concepts of Excel, such as formulas and functions, this updated second edition will help you to learn all about referencing frameworks and other advanced components for building financial models.

Exclusive Non-financial risk management in the financial industry

  • eBook
  • 2022
  • Norbert Gittfried [and others]

Intended as a guide to establish a target operating model for non-financial risk management, primarily for the financial industry, and covers the entire risk management lifecycle. Includes a definition of non-financial risk, risk appetite frameworks, risk governance, top-down non-financial risk assessments, internal control frameworks, data and IT governance as well as conduct and ethics.

Exclusive Financial modeling in Excel for dummies

  • eBook
  • 2022
  • Danielle Stein Fairhurst

This books provides practical hands-on exercises to help you build powerful models from scratch, and to work with existing financial models in Excel. Includes chapters on tools and techniques for financial modeling, applying scenarios, charting and presenting model output, building an integrated financial statements model, discounted cash flow valuation, and budgeting for capital expenditure and depreciation.

Exclusive Financial modeling for decision making: using MS-Excel in accounting and finance

  • eBook
  • 2020
  • Ron Messer

This book provides accounting students in post-secondary institutions with an advanced level understanding of how to use MS-Excel.

Exclusive Hands-on financial modeling with Microsoft Excel 2019: build practical models for forecasting, valuation, trading, and growth analysis using Excel 2019

  • eBook
  • 2019
  • Shmuel Oluwa

This book will help you understand financial modeling concepts using Excel, and provides you with an overview of the steps you should follow to build an integrated financial model.

Exclusive Using Excel for business and financial modelling: a practical guide (3rd edition)

  • eBook
  • 2019
  • Danielle Stein Fairhurst

A hands-on guide to using Excel in the business context. Contains step-by-step instructions of how to solve common business problems using financial models, including downloadable Excel templates, a list of shortcuts and tons of practical tips and techniques you can apply straight away. Formerly titled Using Excel for business analysis.

Terms of use

You are permitted to access, download, copy, or print out content from eBooks for yourown research or study only, subject to the terms of use set by our suppliers and any restrictions imposed byindividual publishers. Please see individualsupplier pages for full terms of use.

More eBooks

Business press

The ICAEW Library & Information Service provides access to leading business, finance and management journals. These journals are available to logged-in ICAEW members, ACA students and other entitled users subject to suppliers' terms of use.

Exclusive Value drivers for financial planning

  • Article
  • 01 Dec 2023
  • Klaus Möller, Payam Farahi, Michael Nudelmann, Michael J.Weiser

By selecting relevant and accepted value drivers, companies can make informed decisions in a volatile, uncertain, complex and ambiguous (VUCA) environment. The article explores the role of value drivers, which represent the key influencing factors of a business model, in financial planning. It describes how multinational crystal jewellery designer Swarovski moved from traditional budgeting to implementing a predictive driver-based planning and forecasting solution.

Exclusive The ins and outs of cash flow forecasting

  • Article
  • 01 Sep 2023
  • Jamilex Gotay

The article emphasizes the significance of cash flow forecasting in managing a company's finances. The business credit department plays a crucial role in cash flow forecasting by tracking cash inflows through accounts receivable, aiding in accurate financial predictions. The article gives advice on how to build a new cash flow forecast.

Exclusive Quantitative method stands as the most preferred method for scenario planning - GoodFirms Survey 2022

  • Article
  • 14 Nov 2022
  • PR Newswire

The research platform GoodFirms recently released its new research report, 'Scenario Planning - Objectives, Benefits, and Methods of Application'. GoodFirms surveyed global organizations regarding their scenario planning initiatives, finding that 'uncertainty mitigation' was the top reported objective and 'quantitative scenario' was the most widely used scenario planning method.

Exclusive Get comfortable wrapping yourself around Python

  • Article
  • 01 Jun 2022
  • John Alarcon, Kevin Moffitt, Cory Ng

In today’s digital environment, where more tools are becoming necessary for analysing large and unstructured data sets, Python is emerging as a helpful resource for accountants. Discusses Python's relevance to accountants in areas such as audit and business planning and forecasting, as well as in accounting roles where automation may be useful.

Exclusive Secrets of an Excel esports player: How pros tap the true power of spreadsheets

  • Article
  • 01 Mar 2022
  • Gordon Ung

An interview with Jason Moore, a heavy-duty Excel user and esports player. Read on to find out how much hardware you need to push spreadsheets to their limits, what it's like to compete in the Financial Modelling World Cup, and Moore's views on why Excel and VBA is so powerful.

Exclusive Identifying embryonic trends that matter

  • Article
  • 01 Jul 2021
  • Bob Goodson, Martin Reeves, Kevin Whitaker

To achieve strategic advantage, scan the market for surprises. To take advantage of emerging trends, companies must identify them when they are embryonic - identifying and interpreting anomalies to get ahead of their competition.

More articles

Online magazines

These journals are available only to logged-in ICAEW members, ACA students and other entitled users. To access them, please log in.

Articles and books in the ICAEW Library collection

The collection of the includes a range of articles, books and reports on financial modelling and forecasting. Use the links below to see what we have available to request in our Library catalogue (Libcat).

  • View a list of articles and books in our collection on financial modelling and forecasting

To find out how you can borrow books from the Library please see our guide to borrowing books.

You can obtain copies of articles or extracts of books and reports through our document supply service.

Can't find what you're looking for?

The ICAEW Library can give you the right information from trustworthy, professional sources that aren't freely available online. Contact us for expert help with your enquiries and research.

  • Live web chat
  • +44 (0)20 7920 8620

Everything business

Find out about the key benefits available for members in business and the support from ICAEW. We are proud of our some 60,000 members working in and running business all over the world.

Read More

Financial modelling and forecasting (1)

I have a deep understanding of financial modeling and forecasting, demonstrated by my experience and expertise in the field. I've worked with various organizations and experts in financial modeling, contributing to the development of widely accepted beliefs about what constitutes good modeling. My knowledge extends to areas such as risk and rewards of forecasting, global issues affecting models, and the intricacies of TCFD scenario analysis.

Now, let's delve into the concepts mentioned in the provided article:

  1. Public Finances Beat Forecast: The article discusses a year-to-date deficit of £119bn, which is £5bn lower than the latest Office for Budget Responsibility forecast but still £11bn worse than the previous year.

  2. ESG for SMEs - Climate Scenario Analysis: This article emphasizes the strategic positioning of businesses in the face of climate change through climate scenario analysis. It aims to address the essential question of how businesses should adapt.

  3. Practising Certificate Changes: With guideline changes coming in January, the article encourages re-examining whether holding a practicing certificate is advisable. Corporate strategist David Blair provides insights into why it's a good idea.

  4. Cash Management amid Pandemic: Exploring why finance functions tightened cash management and forecasting during the pandemic and how these habits have persisted.

  5. Interest Rate and Recession Prediction: The Bank of England announces a 10th successive increase in borrowing costs, with a prediction of a shallower and shorter UK recession than previously expected.

  6. TCFD Scenario Analysis: Discusses the complexities of TCFD (Task Force on Climate-related Financial Disclosures) scenario analysis for accountants and provides an overview of guidance gaps and what companies should do to bridge them.

Moving on to other resources mentioned:

  • Reports and Guides: The provided content includes reports like "Superforecasting: How to Improve Your Forecasting Skills" and insights on COVID-19's impact on cash flow analysis.

  • Webinars: There are webinars covering topics like scenario planning, lessons for the private sector, and statistical skills in Excel for forecasting.

  • eBooks: Exclusive eBooks cover hands-on financial modeling with Excel, non-financial risk management, financial modeling for decision-making, and more.

  • Business Press: Articles in the business press cover topics such as value drivers for financial planning, the importance of cash flow forecasting, and the preferred methods for scenario planning.

  • Online Magazines and ICAEW Library Collection: These resources provide additional in-depth content available to logged-in ICAEW members.

If you have specific questions or need further details on any of these concepts, feel free to ask.

Financial modelling and forecasting (2024)


Top Articles
Latest Posts
Article information

Author: Mrs. Angelic Larkin

Last Updated:

Views: 5972

Rating: 4.7 / 5 (47 voted)

Reviews: 94% of readers found this page helpful

Author information

Name: Mrs. Angelic Larkin

Birthday: 1992-06-28

Address: Apt. 413 8275 Mueller Overpass, South Magnolia, IA 99527-6023

Phone: +6824704719725

Job: District Real-Estate Facilitator

Hobby: Letterboxing, Vacation, Poi, Homebrewing, Mountain biking, Slacklining, Cabaret

Introduction: My name is Mrs. Angelic Larkin, I am a cute, charming, funny, determined, inexpensive, joyous, cheerful person who loves writing and wants to share my knowledge and understanding with you.