Mastering Financial Modelling in Microsoft Excel 3rd edn: A Practitioner's Guide to Applied Corporate Finance
Format
Mixed media product
Språk
Engelska
Antal sidor
520
Utgivningsdatum
2012-08-31
Upplaga
3
Förlag
FT PRENTICE HALL
Illustrationer
Illustrations
Dimensioner
247 x 171 x 31 mm
Vikt
916 g
Antal komponenter
2
Komponenter
Paperback (1), CD-ROM (1)
ISBN
9780273772255
Mastering Financial Modelling in Microsoft Excel 3rd edn: A Practitioner's Guide to Applied Corporate Finance

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

Mixed media product Engelska, 2012-08-31
519
  • Skickas inom 7-10 vardagar.
  • Gratis frakt inom Sverige över 159 kr för privatpersoner.
A practitioners guide to applied corporate finance

Mastering Financial Modelling in Microsoft Excel provides a comprehensive set of tools, methods and formulas that will help you build and develop financial models and spreadsheets. Beginning with basic modelling techniques and essential features, the book then moves through to more complex models and corporate finance solutions.

 

Mastering Financial Modelling:

  • Explains spreadsheet design, methodologies and  processes
  • Incorporates techniques for checking and improving existing models
  • Shows you how to avoid costly mistakes by testing each scenario
  • Describes which functions to use and how to discover new variables
  • Includes a CD of templates and models which you can adapt and modify
Visa hela texten

Passar bra ihop

  1. Mastering Financial Modelling in Microsoft Excel 3rd edn: A Practitioner's Guide to Applied Corporate Finance
  2. +
  3. Mastering Financial Mathematics in Microsoft Excel

De som köpt den här boken har ofta också köpt Mastering Financial Mathematics in Microsoft Excel av Alastair Day (häftad).

Köp båda 2 för 1238 kr

Kundrecensioner

Fler böcker av Alastair Day

Övrig information

Alastair Dayhas worked in the finance industry for 20 years in treasury and marketing functions. In 1990 he established Systematic Finance as a consultancy and financial lessor concentrating on the computer and communications industries. Alastair has a degree in Economics and German from London University, an MBA from the Open University Business School, and is an associate lecturer in corporate finance with the OUBS. He is the successful author of several books including Mastering Cash Flow and Valuation Modelling, Mastering Risk Modelling and The Financial Director's Guide to Purchasing Leasing.

Innehållsförteckning

Contents

Introduction who needs this book?

Preface to the third edition 

Acknowledgements

Conventions

Executive summary

Part A  DEVELOPING FINANCIAL MODELS

 

1    Overview   

Introduction                     

What is financial modelling?

History of spreadsheets  

Power of spreadsheets  

Objectives for the book  

Example spreadsheet

Summary  

 

2    Design introduction  

Introduction

Basics of design

Objectives

User interface  

Key variables and rules  

Layout

Individual modules  

Menu structure and macros

Management reporting  

Future development

Testing

Protection  

Documentation  

Peer group comments

Summary  

 

3    Features and techniques

Introduction

Formats

Number format

Lines and borders  

Colours and patterns  

Specific colours for inputs and results

Data validation  

Controls combo boxes and buttons

Conditional formatting  

Use of functions and types of function

Add-ins for more functions  

Text and updated labels

Record a version number, author, etc.  

Use names to make formulas easier to understand

Paste names as part of documentation  

Comment cells  

Graphics  

Dynamic graphs to plot individual series

Data tables

Scenarios  

Goal seek  

Solver 

Use of templates  

Summary  

 

4    Sample model

Introduction

Aims and objectives  

User needs and user interface  

Key variables and rules  

Breaking down the calculations into manageable groups

Setting up individual modules  

Menu structure  

Program sheets and macros

User assistance  

Summaries

Risk and multiple answers  

Testing and troubleshooting 

Protecting and securing  

Help and documentation  

Show to peers take their advice

Control loop listen, learn and modify

Summary  

 

5    Example model

Introduction

Case study  

Design

PPP 1

PPP 2

PPP 3

PPP 4

PPP 5

Documenting, testing and protecting  

PPP...