Mastering Financial Modelling is designed to help you build more useful financial applications in Excel - models that get results faster and with fewer errors. Divided into two clear parts, this book and the companion CD together provide a powerful tool for improving your spreadsheet design and applying finance in Excel more effectively.

Part A analyses model deign and outlines a design strategy for faster, more accurate application development, using templates and demonstrations of key features and techniques. Part B demonstrates how to apply corporate finance models in excel.



This indispensable book provides worked solutions in key areas of finance :

* Analysing financial performance

* Forecasting models

* Variance analysis

* Portfolio analysis

* Bonds

* Risk analysis

* Leasing

* Optimisation

* Risk management

* Cash flow

* Forecast financials

* Break-even analysis

* Cost of capital

* Investment analysis

* Depreciation

* Company valuation

* decision trees



The emphasis throughout the book is on simplicity, modularity and ease of use, while using excel features to speed up development and reduce errors.



From back cover :

Whether you are a finance professional or a business student, you will use numbers as a matter of course in analysing business performance and making decisions. These procedures and decisions could be so much better if you could use spreadsheets more effectively. Most people could do with strengthening their skills in this area. Mastering Financial Modelling in Microsoft Excel will help you to become more proficient in building and applying financial models, enabling you to get better, more accurate results, fast.

This highly practical book and CD combination is an unrivalled compendium of techniques designed to save you time and help you become more productive. Uniquely, it covers both the older releases of Microsoft Excel and the new excel 2007, so whichever version you are using, you will be able to start using more powerful and robust spreadsheet applications immediately.

Alastair Day's essential reference provides step-by-step solutions to questions such as :

* How to write and apply more useful excel models

* How to add advanced features to excel models

* How to be confident that your model is giving you the right answer

* How to model more in-depth corporate finance techniques.