9780273772255

Mastering Financial Modelling in Microsoft Excel 3rd edn A Practitioner's Guide to Applied Corporate Finance

  • ISBN 13:

    9780273772255

  • ISBN 10:

    0273772252

  • Edition: 3rd
  • Format: Paperback
  • Copyright: 09/27/2012
  • Publisher: FT Press

Note: Not guaranteed to come with supplemental materials (access cards, study guides, lab manuals, CDs, etc.)

Extend Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Sorry, this item is currently unavailable.

Summary

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.

Author Biography

Read more

Table of Contents

Read more

Write a Review