0
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,342
Discovery Miles 23 420

Advanced Modelling in Finance Using Excel and VBA (Hardcover)

M. Jackson

Series: Wiley Finance S.

 (sign in to rate)
Loot Price R2,342 Discovery Miles 23 420 | Repayment Terms: R219 pm x 12*

Bookmark and Share

Expected to ship within 12 - 17 working days

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  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
    LSN: 0-471-49922-6
    Barcode: 9780471499220

    Is the information for this product incomplete, wrong or inappropriate? Let us know about it.

    Does this product have an incorrect or missing image? Send us a new image.

    Is this product missing categories? Add more categories.

    Review This Product

    No reviews yet - be the first to create one!

    You might also like..

    Mr Bitcoin - How I Became A Millionaire…
    Mpho Dagada Paperback R250 R195 Discovery Miles 1 950
    Behavioral Finance - Psychology…
    Richard Deaves, Lucy Ackert Hardcover R1,328 R1,186 Discovery Miles 11 860
    Financial Mathematics - A Computational…
    K. Pereira, N. Modhien, … Paperback R319 R281 Discovery Miles 2 810
    Badass Trader - How To Trade Your Way To…
    Robert J Van Eyden Paperback R290 R227 Discovery Miles 2 270
    The Ultimate Guide To Retirement In…
    Bruce Cameron, Wouter Fourie Paperback R350 R273 Discovery Miles 2 730
    The Holy Grail Of Investing - The…
    Tony Robbins, Christopher Zook Paperback R480 R384 Discovery Miles 3 840
    Investment management
    Johan Marx Paperback  (1)
    R630 R583 Discovery Miles 5 830
    Making Money Out Of Property In South…
    Jason Lee Paperback  (3)
    R350 R273 Discovery Miles 2 730
    Plan B - How South Africans Can Invest…
    Sean Thomson Paperback R200 R172 Discovery Miles 1 720
    Principles Of Building Sustainable…
    Fulufhelo A. Sithole Paperback R280 R205 Discovery Miles 2 050
    Fundamentals of Investing, Global…
    Scott Smart, Lawrence Gitman, … Paperback R1,929 R432 Discovery Miles 4 320
    Girls That Invest: Your Guide to…
    Simran Kaur Paperback R376 Discovery Miles 3 760

    See more

    Partners