1.

Record Nr.

UNINA9910151652403321

Autore

Day Alastair L.

Titolo

Mastering financial mathematics in Microsoft® Excel : a practitioner's guide to applied corporate finance / / Alastair L. Day

Pubbl/distr/stampa

Harlow, England : , : Pearson, , [2012]

©2012

ISBN

0-273-77233-3

Edizione

[Third edition.]

Descrizione fisica

1 online resource (521 pages) : illustrations

Disciplina

658.154

Soggetti

Corporations - Finance - Mathematical models

Corporations - Finance - Data processing

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Previous edition: Harlow: Financial Times Prentice Hall, 2007.

Includes CD-ROM.

Nota di bibliografia

Includes bibliographical references and index.

Nota di contenuto

Cover -- Mastering Financial Modelling in Microsoft® Excel -- Contents -- About the author -- Introduction - who needs this book? -- Preface to the third edition -- Acknowledgements -- Conventions -- Executive summary -- PART A Developing Financial Models -- Overview -- Design introduction -- Features and techniques -- Sample model -- Example model -- PART B Applications -- Analysing performance -- Cash flow -- Forecasting models -- Forecasting financials -- Variance analysis -- Breakeven analysis -- Portfolio analysis -- Cost of capital -- Bonds -- Investment analysis -- Risk analysis -- Depreciation -- Leasing -- Company valuation -- Optimisation -- Decision trees -- Risk management -- Data functions -- Data analysis -- Modelling checklist -- Appendices -- Appendix 1: Software installation -- Appendix 2: Licence -- Appendix 3: File list -- Appendix 4: Microsoft Office 2010 (Office 14) -- Bibliography and references -- Index.

Sommario/riassunto

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.