Mastering Financial Modelling is a bestseller - a book for ‘finance people’ who use Excel and is published as part of the successful Financial Times series 'Mastering'. In consulting and training assignments, we see lots of examples of poor Excel design and this book sets out a design method with many corporate finance examples.  See other Systematic modelling books: Mastering Risk Modelling and Mastering Financial Mathematics in Excel.

See and order the book from Systematic or the Financial Times site, (ISBN 027364310X). With the adoption of our design method, you can develop better models, in less time and with a greater probability of accuracy. The book is packed with design ideas, 250 graphics and tips to help you get more out of Excel modelling.

How to use the Mastering Financial Modelling

• Critically examine one of your own spreadsheet applications
• Read the early chapters on model design, features and techniques
• Decide on areas for improvement
• Work through the other templates and examples
• Review the fully featured applications
• Apply the design method to your own applications
• Practice, develop and improve your own spreadsheet methodology

Mastering Financial Modelling will appeal to:

• CFOs and finance directors
• Financial controllers
• Analysts
• Accountants
• Corporate finance personnel
• Treasury managers
• Risk managers
• Middle office staff
• General managers
• Personnel in banks, corporates and government who make complex decisions
• Academics, business and MBA students

Part A of the book analyses model design and outlines a design strategy for faster, more accurate application development uses templates and demonstrations of key features and techniques.

Part B applies finance theory to Excel in Applied Financial Excel. The book summaries the objectives and theory in a number of important areas and provides worked solutions:

• Analysing performance
• Cash flow
• Forecasting models
• Forecast financials
• Variance analysis
• Break-even analysis
• Portfolio analysis
• Cost of capital
• Bonds
• Investment analysis
• Adding risk to investment models
• Depreciation
• Leasing
• Company valuation
• Optimisation
• Decision trees
• Risk management
• Data functions
• Data analysis

The reader gains a powerful insight into spreadsheet design and how to apply finance to Excel successfully, which acts as a platform for future development and a key reference book for financial modelling techniques.