Welcome to Loot.co.za! Sign in / Register |Wishlists & Gift Vouchers |Help | Advanced search

Checkout
- Your Cart Price

Your cart

Your cart is empty

Books > Business & Economics > Finance & accounting > Finance > Investment & securities

Buy Now

Advanced Modelling in Finance Using Excel and VBA (Hardcover) Loot Price: R2,394

Discovery Miles 23 940

Repayment Terms: R224 pm x 12*

Add to cart

Advanced Modelling in Finance Using Excel and VBA (Hardcover)

M. Jackson

Series: Wiley Finance S.

(sign in to rate)

Loot Price R2,394 Discovery Miles 23 940 | Repayment Terms: R224 pm x 12*

Expected to ship within 10 - 15 working days

Description
Details
Customer Reviews

This book will appeal to both graduate students and practitioners. Students will value the Excel spreadsheets allowing them to develop their knowledge of modelling in finance, using a step-by-step approach accompanied by explanations using elementary mathematical statistics and probability. Practitioners will value the VBA functions as a source of up-to-date and efficient programs that can be easily used from Excel.

Standard material covered includes:

portfolio theory and efficient frontiers
the Capital Asset Pricing Model, beta and variance-covariance matrices
performance measurement
the Black-Scholes option pricing formula
binomial trees for options on equities and bonds
Monte Carlo simulation
bond yield-to-maturity, duration and convexity
term structure models from Vasicek and Cox, Ingersoll and Ross

Advanced topics covered include:

Value-at-Risk

style analysis

an improved binomial tree (Leisen and Reimer)

Quasi Monte Carlo simulation

volatility smiles

Black, Derman and Toy trees

normal interest rate trees

The book is accompanied by a CD-ROM containing the spreadsheets, VBA functions and macros used throughout the work.

General

Imprint:	John Wiley & Sons
Country of origin:	United States
Series:	Wiley Finance S.
Release date:	April 2001
First published:	June 2001
Authors:	M. Jackson
Dimensions:	254 x 165 x 25mm (L x W x T)
Format:	Hardcover • CD-ROM
Pages:	263
ISBN-13:	978-0-471-49922-0
Categories:	Books > Computing & IT > Computer software packages > Spreadsheet software > Excel Books > Business & Economics > Finance & accounting > Finance > Investment & securities > General Books > Money & Finance > Investment & securities > General Promotions
LSN:	0-471-49922-6
Barcode:	9780471499220