My Account Log in

1 option

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

O'Reilly Online Learning: Academic/Public Library Edition Available online

O'Reilly Online Learning: Academic/Public Library Edition
Format:
Book
Author/Creator:
Day, Alastair L., author.
Series:
The Mastering Ser.
Language:
English
Subjects (All):
Microsoft Excel (Computer file).
Corporations--Finance--Mathematical models.
Corporations.
Corporations--Finance--Data processing.
Physical Description:
1 online resource (521 pages) : illustrations
Edition:
Third edition.
Place of Publication:
Harlow, England : Pearson, [2012]
Language Note:
English
Summary:
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.
Contents:
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.
Notes:
Previous edition: Harlow: Financial Times Prentice Hall, 2007.
Includes CD-ROM.
Includes bibliographical references and index.
Description based on print version record.
Description based on publisher supplied metadata and other sources.
ISBN:
0-273-77233-3
OCLC:
1015866796

The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.

My Account

Shelf Request an item Bookmarks Fines and fees Settings

Guides

Using the Library Catalog Using Articles+ Library Account