eBooks
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.
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.
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.
What's in your leadership toolbox?
Finance teams have been moving from counting wealth and policing compliance to creating wealth and strategy, so they need to broaden and upgrade some of their skills. As well as traditional finance functions, senior finance executives and their teams are now often expected to do financial modeling, data analytics, consider cyber security, risk management and more. The authors present their framework to help finance executives develop their leadership abilities.
A practical guide for non-financial companies when modeling longer-term currency and commodity exposures
Provides guidance on implementing long-term risk modelling to manage business risk. It discusses selection methods for simulating future prices and rates, a method for back testing risk models, and a method for estimating earnings at risk.
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 by post, fax or email through our document supply service.
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.