Mastering Risk Modelling: A Practical Guide to Modelling Uncertainty with Microsoft Excel

Overview

Risks are everywhere in the business world. Mastering Risk Modelling provides the busy financial manager with useful tips andpractical templates for assessing, applying and modelling risk and uncertainty in Excel. The book is designed specifically to be of help to you if you don’t have time to start from scratch – it will improve your abilities in Excel and give you a library of basic examples that you can use as a basis for further development.

It covers:

• Review of model ...

See more details below
Paperback (Revised)
$96.91
BN.com price
(Save 3%)$99.99 List Price
Other sellers (Paperback)
  • All (6) from $71.00   
  • New (5) from $71.00   
  • Used (1) from $96.90   
Sending request ...

Overview

Risks are everywhere in the business world. Mastering Risk Modelling provides the busy financial manager with useful tips andpractical templates for assessing, applying and modelling risk and uncertainty in Excel. The book is designed specifically to be of help to you if you don’t have time to start from scratch – it will improve your abilities in Excel and give you a library of basic examples that you can use as a basis for further development.

It covers:

• Review of model design

• Risk and uncertainty

• Credit risk

• Project finance

• Financial analysis

• Valuation

• Options

• Bonds

• Equities

• Value at risk

• Simulation

This second edition contains brand new chapters:

• Revised models

• More material on credit risk modelling e.g. portfolios, bankruptcy models

• Shows dual 2003/2007 Excel key strokes

• More theory especially on statistics in Excel

• Basic statistics in Excel – tools and methods

• Capacity to borrow and repay

• Finding optimum mix of risk and return

• Fixed income risk models

• Visual Basic approach

Read More Show Less

Product Details

  • ISBN-13: 9780273719298
  • Publisher: FT Press
  • Publication date: 7/20/2009
  • Series: Financial Times Series
  • Edition description: Revised
  • Edition number: 2
  • Pages: 408
  • Product dimensions: 6.70 (w) x 9.40 (h) x 0.90 (d)

Table of Contents

Conventions
Overview

1 Introduction

Scope of the book

Example model

Objectives of risk modelling

Summary

2 Review of model design

Introduction

Design objectives

Common errors

Excel features

Formats

Number formats

Lines and borders

Colour and patterns

Specific colour for inputs and results

Data validation

Controls – combo boxes and buttons

Conditional formatting

Use of functions and types of functions

Add-ins for more functions

Text and updated labels

Recording a version number, author, etc.

Using names

Pasting a names table

Comment cells

Graphics

Dynamic graphs to plot individual series

Data tables

Scenarios

Spreadsheet auditing

Summary

3 Risk and uncertainty

Introduction

Risk

Uncertainty

Response to risk

Methods

Summary

4 Project finance

Introduction

Requirements

Advantages

Risks

Risk analysis

Risk mitigation

Financial model

Inputs

Sensitivity and cost of capital

Construction, borrowing and output

Accounting schedules

Management analysis and summaries

Summary

5 Simulation

Introduction

Building blocks

Procedure

Real estate example

Summary

6 Financial analysis

Introduction

Process

Environment

Industry

Financial statements

Profit and loss

Balance sheet

Operating efficiency

Profitability

Financial structure

Core ratios

Market ratios

Trend analysis

Cash flow

Forecasts

Financial analysis

Summary

7 Credit risk

Cash flow

Cover ratios

Sustainability

Beaver’s model

Bathory model

Z scores

Springate analysis

Logit analysis

H-Factor model

Ratings agency

Summary

References

8 Valuation

Introduction

Inputs

Cash flow

Capital structure

Valuation and returns

Sensitivity analysis

Management summary

Summary

9 Bonds

Introduction

Bond prices

Interest rates

Yield

Duration and maturity

Convexity

Comparison

Summary

10 Options

Introduction

Options

Options example

Options hedging strategy

Black–Scholes

Simulation options pricing

Binomial model

Summary

11 Real options

Introduction

Project

Option to delay

Option to abandon

Option to expand

Summary

12 Equities

Introduction

Historic data

Returns summary

Simulation

Portfolio

Summary

References

13 Risk adjusted returns

Introduction

Economic capital

Risk-adjusted return on capital (RAROC)

Summary

14 Value at risk

Introduction

Single asset model

Two assets

Three asset portfolio

Summary

15 Credit value at risk

Introduction

Portfolio approach

Overview of components

Single asset

Two-bond portfolio

Simulation

Summary

Appendix: software installation and licence

Index

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)