Mastering Financial Modelling in Microsoft Excel

Alastair L. Day

Financial Times/Prentice Hall

2019

501 páginas

16h 42m

ISBN-13: 9780273772255

All the tools and techniques you need to build, develop, and apply reliable financial models with Microsoft Excel. * *Updated to reflect Excel 2010 features (including sparklines) and Mac versions of Excel, but still works exceptionally well with older Windows versions of Excel. *Fully explains basic and complex modeling techniques, and offers specific, detailed coverage of models ranging from cash flow to company valuation. *CD contains models and templates designed for clarity and easy adaptation. This book brings together everything financial professionals and students need to build and develop reliable financial models with the latest versions of Microsoft Excel, and use those models to make more effective and successful decisions. Updated for new Excel 2010 features (including sparklines) as well as the newest versions of Excel for Mac, this edition also remains fully appropriate for older versions of Excel. Leading financial consultant and writer Alastair Day begins by explaining basic modeling techniques, then moves step by- step through building increasingly complex models. In Part I, Day introduces the essentials of model design, demystifying features and techniques every model builder must understand, and showing how they come together in a complete model. Next, in Part II, he focuses on creating accurate models for many specific applications. These include: performance analysis, cash flow, forecasting, variance analysis, breakeven analysis, cost of capital, bonds, investment analysis, risk analysis/management, depreciation, leasing, company valuation, optimization, and much more. Along the way, Day explains relevant data functions and analysis techniques, and presents full chapters on both decision trees and optimization. An accompanying CD-ROM provides an extensive library of templates and sample models designed for easy adaptation. The book also provides end-of chapter exercises, making it an even more valuable resource for formal or classroom study.