Research and Markets


Printer Friendly

Printed from http://www.researchandmarkets.com/reports/682908


Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level with CD ROM


Description: Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level is a practical, comprehensive and in-depth guide to financial modelling designed to cover the modelling issues that are relevant to facilitate the construction of robust and readily understandable models.

Based on the authors extensive experience of building models in business and finance, and of training others how to do so this book starts with a review of Excel functions that are generally most relevant for building intermediate and advanced level models (such as Lookup functions, database and statistical functions and so on).

It then discusses the principles involved in designing, structuring and building relevant, accurate and readily understandable models (including the use of sensitivity analysis techniques) before covering key application areas, such as the modelling of financial statements, of cash flow valuation, risk analysis, options and real options. Finally, the topic of financial modelling using VBA is treated. Practical examples are used throughout and model examples are included in the attached CD-ROM.

Aimed at intermediate and advanced level modellers in Excel who wish to extend and consolidate their knowledge, this book is focused, practical, and application-driven, facilitating knowledge to build or audit a much wider range of financial models.


Contents: Background, Objectives and Approach.

About The Author.

Acknowledgements.

1. Building Blocks: Selected Excel Functions and Tools.

Core Functions for Financial Modelling.

Arithmetic Operations.

Logical Operations.

Financial Calculations.

Database Functions, Features and Pivot Tables.

Statistical Functions.

Lookup and Reference Functions.

Text Functions.

Information Functions.

Array Functions, Formulae and Matrix Calculations.

GoalSeek and Solver.

The Analysis ToolPak and Other Add-ins.

Selected Excel Short-cuts.

2. Principles of Modelling.

What is a Good Model?.

Model Design.

Selection of Model Variables and their Dependencies.

Level of Detail or Aggregation.

Model Structure and Planning.

Logical Flow.

Compactness.

Named Ranges.

Circular References.

Model Building.

Formatting and Comments.

Creating Robust Formulae.

Results Presentation and Other Uses of Sensitivity Analysis.

General Remarks on Presentation.

Using Data Tables to Conduct Sensitivity Analysis.

Hiding and Protecting Models.

Model Auditing.

3. Financial Statement, Cash Flow and Valuation Modelling.

Financial Statement Modelling: Core Points and Example.

General Comments.

Income Statement Forecasting.

Balance Sheet Forecasting.

Cash Flow Statement Forecasting.

Error Checks and Feasibility Checks.

General Error Checking Tools.

Feasibility Checking and Ratio Analysis.

Adding Generality.

Cash Flow Valuation.

Calculation of Free Cash Flow.

Discounting Free Cash Flow.

Terminal Value Calculations.

Further Adjustments.

Sensitivity Analysis.

4. Risk Modelling.

Benefits and Challenges of Risk Modelling.

The Risk Modelling Process.

An Introduction to Simulation Techniques.

The Language of Probability Distributions.

Quick Guide to using @RISK.

Types of Dependency Relationships in Risk Models.

The Selection and Use of Distributions.

Pragmatic Approaches and Distributions.

Data-Driven Approaches and Distributions.

Scientific Approaches and Distributions: The Basics.

Further Aspects of the Science of Distributions.

Further Example Models.

5. Introduction to Options and Real Options Modelling.

Financial Market Derivatives: An Introduction.

Real Options Modelling.

Uses and Relationships to Other Types of Analysis.

Examples using Simulation.

Examples using Trees.

6. VBA for Financial Modelling.

Introduction.

The Bare Essentials.

Simple Examples.

Building Blocks.

Working with Ranges.

Writing Robust Code.

Further Topics.

Object Orientation: An Introduction.

Controlling Execution and Related Topics.

Working with Functions.

Checking and Debugging Code.

Examples: Recording Macros and Related Topics.

Introduction.

Using GoalSeek and Solver.

Examples: Simulation Modelling.

Introduction.

Examples: User-defined Functions.

Creating Functions.

Examples.

Structure and Organisation: Further Topics.

Further Reading.

Index.


Author Michael Rees gained a BA with First Class Honours and a Doctorate in Mathematics from Oxford University in 1985 and 1988 respectively. In 1992 he gained an MBA with Distinction from INSEAD, and in 2003 graduated in first position on the Certificate in Quantitative Finance program, also winning the Wilmott award. Since 2002 Michael has worked independently as a consultant and trainer in financial modelling. Prior to this he worked as a strategy consultant with Braxton Associates and Mercer Management Consulting, and also as an analyst at J.P. Morgan. Michael lives in Richmond, UK. He was born in Canada, has lived in several countries, and is fluent in French and German.


Ordering: Order Online - visit http://www.researchandmarkets.com/reports/682908

Order by Fax - using the order form below

Order By Post - print the order form below and send to

Research and Markets,
Guinness Centre,
Taylors Lane,
Dublin 8,
Ireland.


Research and Markets Page 1 of 2
Printed 20/03/2010 23:25:58
Fax Order Form
To place an order via fax simply print this form, fill in the information below and fax the completed form to
646-607-1907 (from USA) or +353 1 6849977 (from Rest of World). If you have any questions please email help@researchandmarkets.net

Order information
Please verify that the product information is correct and select the format you require.
Product Name:
Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level with CD ROM
Web Address:
http://www.researchandmarkets.com/reports/682908
Office Code:
OC8HKPRLQQWTS

Report formats
Please enter the quantity of the report format you require.

Format Quantity Price
Hard Copy €90.00 + EUR€ 25.00 Shipping/Handling *
* Shipping/Handling is only charged once per order.


Contact information
Please enter all the information below in BLOCK CAPITALS.

First Name:   Last Name:  
Email Address:
Job Title:
Organisation:
Address:
City:
Postal/Zip Code:
Country:
Phone Number:
Fax Number:


Please fax this form to:
(646) 607-1907 or (646) 964-6609 (from USA)
+353-1-481-1716 or +353-1-653-1571 (from Rest of World)
Research and Markets Page 2 of 2
Printed 20/03/2010 23:25:58

Payment information

Please indicate the payment method you would like to use by selecting the appropriate box.

 Pay by Credit Card:
American Express
Diners Club
Master Card
Visa
Cardholder's Name:
Cardholder's Signature:
Expiry Date: /
Card Number:
CVV Security Code:
Issue Date: /   (Diners Club only)


 Pay by Check:
Please post the check, accompanied by this form, to:

Research and Markets,
Guinness Centre,
Taylors Lane,
Dublin 8,
Ireland.


 Pay by Wire Transfer:
Please transfer funds to:

Account number: 83313083
Sort code: 98-53-30
Swift code: ULSBIE2D
IBAN number: IE78ULSB98533083313083
Bank Address: Ulster Bank,
27-35 Main St,
Blackrock,
Co. Dublin,
Ireland.
If you have a Marketing Code please enter it below:
Marketing Code:


Please note that by ordering from Research and Markets you are agreeing to our Terms and Conditions at http://www.researchandmarkets.com/info/terms.asp

Please fax this form to:
(646) 607-1907 or (646) 964-6609 (from USA)
+353-1-481-1716 or +353-1-653-1571 (from Rest of World)