Skip to content

Financial Modelling in Practice A Concise Guide for Intermediate and Advanced Level

Spend $50 to get a free DVD!

ISBN-10: 0470997443

ISBN-13: 9780470997444

Edition: 2008

Authors: Michael Rees

List price: $135.00
Shipping box This item qualifies for FREE shipping.
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!


How do you estimate the value of a security when its future trajectory, or the trajectory of the other securities or economic variables it depends on, is unknown? Based on the authors many years of real-life solutions to financial modeling, Financial Modelling in Practice teaches readers how to build and operate a range of financial models. This practical, in-depth guide provides an in-depth look at financial modeling and covers the full range of topics that are truly relevant to financial engineers, academics, and students in financial modeling.
Customers also bought

Book details

List price: $135.00
Copyright year: 2008
Publisher: John Wiley & Sons, Incorporated
Publication date: 12/3/2008
Binding: Hardcover
Pages: 292
Size: 6.75" wide x 10.00" long x 1.00" tall
Weight: 1.474
Language: English

Background, Objectives and Approach
About The Author
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
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 FlowCompactness
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
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
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
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
VBA for Financial Modelling
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
Using GoalSeek and Solver
Examples: Simulation Modelling
Examples: User-defined Functions
Creating Functions
Structure and Organisation: Further Topics
Further Reading