Practical Financial Modelling: A guide to current practice / Edition 2

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $16.75
Usually ships in 1-2 business days
(Save 71%)
Other sellers (Paperback)
  • All (8) from $16.75   
  • New (4) from $39.53   
  • Used (4) from $16.75   


This second edition of Practical Financial Modelling is vital tool for all finance and management professionals whose work involves the production and development of complex spreadsheets and financial models. The author bridges the gap between the Excel manual and financial literature with a wealth of practical advise and useful tips.

The book identifies good practice and highlights those areas which are prone to error and inconsistency resulting in a refreshingly simple approach to building and using financial models suitable for novice and experienced modellers. By using practical worked examples the most effective ways in which problems can be solved are explored. Key themes include: model structure, audit formulae and functions and model use.

New to the second edition:

Instructive information on Excel 2007 and its enhanced modelling functions and feature; Risk controls in developing and using financial models; Test-yourself modelling problems and applied examples in every chapter; Substantial information related to reporting and charting techniques and an appendix devoted to parallel comparison of how-to in Excel 2003 and 2007.

• Instructive information on Excel 2007 and its enhanced modelling functions and features
• Risk controls in developing and using financial models
• Test-yourself modelling problems and applied examples in every chapter
• Substantial information relating to reporting and charting techniques
• An appendix devoted to a parallel comparison of how-to in Excel 2003 and Excel 2007

This book is for all financial professionals whose work, to a greater or lesser degree, involves complex spreadsheets and financial models. This includes investment bankers, commercial banks, accountancy firms, property firms, public sector including local government and healthcare, PFI/PPP enterprises, financial managers and financially literate general managers. Junior/middle management, where the focus would be on cash flow forecasting and budgeting tasks, will also find this book of value.

For the vast majority of people involved in this subject, financial modelling is an activity, a task requiring skills. Once people have the ability to structure the model, they have a better starting point from which to address the financial problems. This new book proposal intends to offer that starting point.

Theory is limited to the absolute essentials that aid understanding; thus the focus with this new book is very practical - this is "how-to-do-it", showing best practice, and is illustrated with many practical worked examples. Practical financial modelling- all the essentials in one book

Read More Show Less

Editorial Reviews

From the Publisher
Five Star Reviews from (all five stars):
"I attended one of Jonathan's courses recently and commented at the time that it was rather like the spreadsheet equivalent of going from an ordinary car to driving an F1 car! I have now read through his book and I can only say that this is a superb publication. It sets out how to do advanced spreadsheet modelling far better than anything else I have come across."

"This guide consists of 163 pages of text along with a CD containing Excel-based demonstration material...It offers detailed advice on preparing financial models using Excel spreadsheets, which is likely to be of use to both practitioners and students of practical financial modelling....Although there are many guides to Excel on the market, this one is distinguished by its emphasis on how to use the program for management accounting. Even the most experienced modeller will learn something from this resource."

Read More Show Less

Product Details

  • ISBN-13: 9780750686471
  • Publisher: Elsevier Science
  • Publication date: 6/13/2008
  • Edition number: 2
  • Pages: 304
  • Product dimensions: 6.60 (w) x 9.10 (h) x 0.90 (d)

Meet the Author

Jonathan Swan's work has encompassed a range of consultancy and development assignments with investment banks and others in the City and throughout Europe. He is currently Director of Training at Operis Group plc, the UK's leading independent financial modelling consultancy.

Read More Show Less

Table of Contents

Introduction; Definitions; Descriptions; Common approaches; Structure; Inputs; Workings; Outputs; Variations; Support; Documentation; Navigation; Content: Formulae; Range names; Corkscrews; Masks and switches; Recalculation; Circularities; Functions; Logical; Lookup; Financial; Other; Custom; Quality control: Audit; Audit sheet; Structural checks; Arithmetical checks; Financial checks; Model Use; Grouping; Data validation and Dropdown lists; Conditional and custom formats; Sensitivity analysis; Reporting - Reports, Charting, Printing; Automation; Macros; Appendix; Keyboard shortcuts; References; Further information; index.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)