ICAEW.com works better with JavaScript enabled.

Financial modelling and forecasting

Effective approaches to looking ahead

In this section

Articles and features




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.

Financial modeling in Excel for Dummies

A beginner's guide to financial modeling using Microsoft Excel.

Industry press

Volatility forecasting using financial statement information

Examines whether financial statement information can predict future realized equity volatility incremental to market-based equity volatility forecasts.

A practical guide for non-financial companies when modeling longer-term currency and commodity exposures

Guidance on implementing long-term risk modelling.

A new approach to effective demand planning

This article argues for a hybrid approach to provide accurate forecasts and address the needs of local, regional and global markets.

Using financial models as a value-added management tool

Financial modelling is an important tool that lets management accountants add value and help move an organisation toward achieving its goals.

"Experts" who beat the odds are probably just lucky

An interview with Jerker Denrell, focusing on his research study into the accuracy of financial analysts' forecasts.

Do you know your cost of capital?

A survey by the Association for Financial Professionals has found that companies differ widely in the assumptions built into the financial models they use to evaluate investment opportunities.

Just-in-time budgeting for a volatile economy

The article discusses several techniques companies can use to speed the budgeting process up and make it more effective.

A few tweaks here and there

Businesses spend vast amounts of time adjusting their financial forecasts. But do these changes actually improve accuracy?

* Some of the content on this web page was provided by the Chartered Accountants’ Trust for Education and Research, a registered charity, which owns the library and operates it for ICAEW.