ICAEW.com works better with JavaScript enabled.

Financial modelling and forecasting

Find out more about building financial models, the pitfalls of financial modelling and how to carry out effective forecasting.

What's on this page?

  • eBooks
  • Online articles
  • Useful links
  • Articles and books in the Library collection

Contact the Library

Expert help for your enquiries and research.

E  library@icaew.com

T  +44 (0)20 7920 8620

Featured article 

Demolishing uncertainty
On the basis of research involving 25,000 forecasters and a million predictions, the authors identified a set of practices that can improve companies’ prediction capability: providing training in the basics of statistics, assembling teams of forecasters, tracking performance and giving feedback.

You will need to be logged-in to the website to access the full range of articles available online.

Featured guide

Financial modelling code
(ICAEW, 2018)
Building on the earlier guide, the Twenty principles for good spreadsheet practice, this thought leadership guide from ICAEW's IT Faculty sets out guidance on what the Faculty sees as the universal tenets of best practice in the field.


The Library 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 library@icaew.com.

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

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.

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

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.

Principles of financial modelling: model design and best practices using Excel and VBA

A practical guide to financial modelling, demonstrating how to plan, design and build financial models.

Showing 3 of 17 items

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

Online articles

The Library 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.

How recent insolvency reform in the UK impacts business valuations

A look at how the new UK Corporate Insolvency and Governance Act (CIGA) 2020 is likely to impact a business valuation conducted for purposes of insolvency. The article covers the valuation elements which are likely to require more preparation and support than in the past, including providing more scenario analysis to aid the court and additional stress-testing of discounted cash flow (DCF) analyses and scenarios.

Accounting curricula in the digital age

Accounting programs need to ensure that students are equipped with digital capabilities that will prepare them for leadership roles in the profession. The article looks at the case for including Excel, financial modelling, process automation and data analytics and visualization in an academic accounting curriculum.

Volatility forecasting using financial statement information

This paper examines whether financial statement information can predict future realized equity volatility incremental to market-based equity volatility forecasts. The paper uses an analytical framework to identify accounting-based drivers of realized volatility.

Showing 3 of 11 items

Articles and books in the Library collection

Financial modelling
(ICAEW, 2016)
Best-practice guideline from ICAEW's Corporate Finance Faculty, aimed at corporate financiers who need to prepare, use or review financial models for deals.

Next generation Excel modelling in Excel for analysts and MBAs (for Windows and Mac OS) 
(John Wiley & Sons, 2013)
Covers advanced business decision making, financial, and accounting functions. The book demonstrates how to create models to boost efficiency and improve your forecasting ability.

Business and financial models 
(Kogan Page, 2013)
A step-by-step guide to building a financial model, from formulating questions to monitoring performance. .

Find more articles and books

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

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

Can't find what you are looking for?

If you're having trouble finding the information you need, ask the Library & Information Service. Contact us by telephone on +44 (0)20 7920 8620, by web chat or by email at library@icaew.com.

ICAEW accepts no responsibility for the content on any site to which a hypertext link from this site exists. The links are provided ‘as is’ with no warranty, express or implied, for the information provided within them. Please see the full copyright and disclaimer notice.