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.
Financial risk manager handbook
The book contains sections on quantitative analysis, financial markets and financial products, and the various kinds of risk management. It includes chapters on the financial modelling of risk, credit risk, and market risk. Each chapter contains examples and exercises for students.
Financial planning using Excel: forecasting, planning and budgeting techniques
The book is aimed at people who already have some knowledge of Microsoft Excel. It looks at spreadsheet skills for different types of planning, and contains detailed sections on business planning, forecasting and managing budgets with business software.
Practical financial modelling: a guide to current practice
The book provides guidance on using complex spreadsheets and other business software for financial modelling. It outlines good modelling practice and addresses the role of information technology in financial modelling.
A few tweaks here and there
these changes actually improve accuracy? Research suggests that positive adjustments, where the forecaster optimistically increases the statistical forecast, are more likely to be inaccurate.
Better depreciation method using INDEX
Bill Jelen explains an Excel tip for modelling depreciation, which he picked up whilst judging the ModelOff World Financial Modeling Championships event. Rather than using the common OFFSET solution which slows your worksheet, try using this technique with INDEX.
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. That’s a big problem — because assumptions about the costs of equity and debt profoundly affect both the type and the value of the investments that companies make.
Better depreciation method using INDEX
Bill Jelen explains an Excel tip for modelling depreciation, which he picked up whilst judging the ModelOff World Financial Modeling Championships event.
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.
Best-practice guideline: Financial Modelling 2012
Baker Tilly have developed this guideline to best practice, published by the ICAEW’s Corporate Finance Faculty. ICAEW Corporate Finance Faculty members can access the full version through the Faculty's Corporate finance guidelines page.
ICAEW business resources on forecasting, including articles and webcasts
Financial planning: realizing the value of budgeting and forecasting
A PWC March 2010 study which focuses on current financial planning challenges and the practices organizations are deploying to improve financial budgeting and forecasting activities.
Articles and books in the Library collection
Click on the links below to see our catalogue record and holdings for each item. Please contact us if you would like to borrow a book or request a copy of an article.
Next generation Excel modelling in Excel for analysts and MBAs (for Windows and Mac OS)
Gottlieb, I. (John Wiley & Sons, 2013)
This book "shows you how to harness the full power of Excel to help you to perform an array of advanced business decision making, financial, and accounting functions. You'll learn how to quickly create models that deliver accurate, relevant information to boost efficiency, improve your forecasting ability, and perform an array of other crucial business and reporting functions."
Business and financial models
Marsh, C. (Kogan Page, 2013)
This book takes you through the process of building your model, from the initial phase of formulating questions through modelling cash flow, budgets, investment appraisal and 'dashboard' tools for monitoring performance. Business and Financial Models also includes coverage of new visual thinking techniques, and how these can be incorporated into conventional business modelling.
Guide to business modelling
Tennent, J. (Profile Books, 2011)
Intends to provide "practical help on how to build the most robust, flexible and easy-to-use models for analysing the potential upside or downside of any business project. This guide is aimed at both those who are business modelling novices and those with considerable experience".
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.