Financial Modelling And Analysis Using Microsoft Excel For Non Finance Personnel

Financial Modelling and Analysis Using Microsoft Excel

Financial Modelling and Analysis using Microsoft Excel for non -finance personnel

Create an inventory system! Calculate loan repayments! Handle a production’s limiting factors successfully! Work out customers’ profitability! Yes, most of the above and much more can be achieved in Microsoft Excel if you understand some basic concepts of financial modelling and analysis. This book was written to help any users wanting to have a clear understanding of how Excel can help to perform some aspects of financial modelling and analysis using some of its built-in financial and logical functions. It goes further by elaborating detail exercises on the above. The book introduces the basic concepts of balance sheet, income statement and cash flow and builds the relevant models. Many books have been written on Excel. However, this book explains some advanced techniques for sensitivity analysis and features in a rather simplified manner with plenty of screen captures wherever possible. New users and existing users on Excel will find this book handy.

Mastering Financial Modelling in Microsoft Excel

Comprehensive tools and methods to help you build, develop and apply financial models using Microsoft Excel, enabling you to get better, more accurate results, faster. The new edition of this bestselling title begins by explaining basic modelling techniques before moving through to more complex models. The book is divided into two parts: the first part outlines model designs and gives templates, key features and techniques. The second part of the book shows how to build corporate financial models in Excel. The accompanying CD allows you to use and adapt templates and models. This new edition includes a reworking of the book in Excel 2010 (but with older material still included), inclusion of Apple Mac, addition of specific 2010 features and end of chapter exercises.