Financial risk manager handbook
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
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
Guidance on using complex spreadsheets and other business software for financial modelling. Describes good modelling practice and addresses the role of information technology in financial modelling.
Structured finance modeling with object-oriented VBA
An aid to using business software for financial modelling in the securities market. It is primarily concerned with Microsoft Excel and Visual Basic but includes general guidance on modelling and corporate finance.
Financial modeling with Crystal Ball and Excel
Guide to financial modelling using business software, including Oracle Crystal Ball and Microsoft Excel. It includes chapters on financial forecasting, modelling financial statements, and other modelling functions available in Excel.
Paul Wilmott on quantitative finance
Study guide to financial modelling of derivatives. Includes chapters on the theory of derivatives, fixed-income modelling and credit risk. There is an additional section covering numerical methods and business software.
Excel models for business and operations management
The book aims to be a practical guide to financial modelling with Microsoft Excel. It includes chapters on using a spreadsheet to manage a budget, financial statements and cash flows, and analysis of financial models. It is written for people working to US GAAP, but also aims to make the skills transferable to other financial modelling systems.
Building financial models with Microsoft Excel
A comprehensive guide for business professionals which provides step-by-step instructions for building financial models using Microsoft Excel. While it is written with United States GAAP in mind, the book's modular nature aims to help make the process of transitioning the modeling process to other accounting systems as straightforward as possible.
Paul Wilmott introduces quantitative finance
Study guide covering the essential elements of quantitative finance. Includes chapters on financial markets and products, equities, commodities, and derivatives. There are detailed sections on risk measurement metrics and financial modelling.
A few tweaks here and there
Businesses spend vast amounts of time adjusting their financial forecasts. But do 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.
"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. He discusses the finding that analysts who successfully predict a single highly unusual event often have poor records in terms of the accuracy of predictions they make over time, saying this suggests accurate prediction of unusual events should be discounted in evaluating business forecasters.
Six rules to improve your forecasting
In describing what forecasters are trying to achieve, Paul Saffo outlines six simple, commonsense rules that smart managers should observe when working with professional forecasters.
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. By relating critical inputs to performance outcomes, models support planning and controlling efforts as well as strategic decision making.
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.
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.