Preview

Advanced Modelling in Finance

Powerful Essays
Open Document
Open Document
57522 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Advanced Modelling in Finance
Advanced Modelling in Finance using Excel and VBA

Wiley Finance Series
Operational Risk: Measurement and Modelling Jack King Advance Credit Risk Analysis: Financial Approaches and Mathematical Models to Assess, Price and Manage Credit Risk Didier Cossin and Hugues Pirotte Dictionary of Financial Engineering John F. Marshall Pricing Financial Derivatives: The Finite Difference Method Domingo A Tavella and Curt Randall Interest Rate Modelling Jessica James and Nick Webber Handbook of Hybrid Instruments: Convertible Bonds, Preferred Shares, Lyons, ELKS, DECS and Other Mandatory Convertible Notes Izzy Nelken (ed) Options on Foreign Exchange, Revised Edition David F DeRosa The Handbook of Equity Derivatives, Revised Edition Jack Francis, William Toy and J Gregg Whittaker Volatility and Correlation in the Pricing of Equity, FX and Interest-Rate Options Riccardo Rebonato Risk Management and Analysis vol. 1: Measuring and Modelling Financial Risk Carol Alexander (ed) Risk Management and Analysis vol. 2: New Markets and Products Carol Alexander (ed) Implementing Value at Risk Philip Best Credit Derivatives: A Guide to Instruments and Applications Janet Tavakoli Implementing Derivatives Models Les Clewlow and Chris Strickland Interest-Rate Option Models: Understanding, Analysing and Using Models for Exotic Interest-Rate Options (second edition) Riccardo Rebonato

Advanced Modelling in Finance using Excel and VBA
Mary Jackson and Mike Staunton

JOHN WILEY & SONS, LTD
Chichester
ž

New York

ž

Weinheim

ž

Brisbane

ž

Singapore

ž

Toronto

Copyright  2001 by John Wiley & Sons, Ltd, Baffins Lane, Chichester, West Sussex PO19 1UD, England National 01243 779777 International (C44) 1243 779777 e-mail (for orders and customer service enquiries): cs-books@wiley.co.uk Visit our Home Page on http://www.wiley.co.uk or http://www.wiley.com All Rights Reserved. No part of this publication may be reproduced, stored in a retrieval system, or

You May Also Find These Documents Helpful

  • Powerful Essays

    Acct 3563 Summary

    • 7433 Words
    • 30 Pages

    This work is licensed under the Creative Commons Attribution Attribution-Non-CommercialNo Deriva Derivative Works 2.5 Australia Licence. To view a copy of this license, visit http://creativecommons.org/licenses/by-nc-nd/2.5/au/ or send a letter to Creative http://creativecommons.org/licenses/by nd/2.5/au/ Commons, 171 Second Street, Suite 300, San Francisco, California, 94105, USA. Disclaimer: The author does not guarantee the accuracy of the notes available and will not be held liable for any damages (including lost marks etc.) as a result of the use of these notes. Use at your own discretion with etc.) caution. Do not rely on them; these notes are not intended to serve as a replacement for your own.…

    • 7433 Words
    • 30 Pages
    Powerful Essays
  • Powerful Essays

    Tolstoy's Hadji Murad

    • 49666 Words
    • 199 Pages

    This web edition published by eBooks@Adelaide. Rendered into HTML by Steve Thomas. Last updated Sun Aug 29 19:45:31 2010. This work is licensed under a Creative Commons Licence (available at http://creativecommons.org/licenses/by-nc-sa/2.5/au/). You are free: to copy, distribute, display, and perform the work, and to make derivative works under the following conditions: you must attribute the work in the manner specified by the licensor; you may not use this work for commercial purposes; if you alter, transform, or build upon this work, you may distribute the resulting work only under a license identical to this one. For any reuse or distribution, you must make clear to others the license terms of this work. Any of these conditions can be waived if you get permission from the licensor. Your fair use and other rights are in no way affected by the above. eBooks@Adelaide The University of Adelaide Library University of Adelaide South Australia 5005…

    • 49666 Words
    • 199 Pages
    Powerful Essays
  • Good Essays

    Dyslexia and Open University

    • 19760 Words
    • 80 Pages

    The Open University Walton Hall Milton Keynes MK7 6AA First published 2001. Second edition 2004. Third edition 2006. Copyright © 2006 The Open University All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, transmitted or utilized in any form or by any means, electronic, mechanical, photocopying, recording or otherwise, without written permission from the publisher or a licence from the Copyright Licensing Agency Ltd. Details of such licences (for reprographic reproduction may be obtained from the Copyright Licensing Agency Ltd of 90 Tottenham Court Road, London W1P 0LP. Edited, designed and typeset by The Open University. Printed in the United Kingdom by Hobbs the Printer Limited, Brunel Road, Totton, Hampshire SO40 3WX ISBN N978 0 7492 1260 5…

    • 19760 Words
    • 80 Pages
    Good Essays
  • Powerful Essays

    Porcine Skin

    • 6081 Words
    • 25 Pages

    Downloaded by Queen Mary, University of London on 19/04/2013 18:44:34. Published on 21 April 2011 on http://pubs.rsc.org | doi:10.1039/C1AN15111H…

    • 6081 Words
    • 25 Pages
    Powerful Essays
  • Good Essays

    Access to this document was granted through an Emerald subscription provided by UNIVERSITY OF MANCHESTER For Authors: If you would like to write for this, or any other Emerald publication, then please use our Emerald for Authors service.…

    • 6019 Words
    • 25 Pages
    Good Essays
  • Powerful Essays

    Published by John Wiley & Sons, Ltd The Atrium Southern Gate Chichester West Sussex PO19 8SQ England E-mail (for orders and customer service enquires): cs-books@wiley.co.uk Visit our Home Page on www.wiley.com Copyright © 2010 John Wiley & Sons, Ltd, Chichester, West Sussex, England Published by John Wiley & Sons, Ltd, Chichester, West Sussex All Rights Reserved. No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except under the terms of the Copyright, Designs and Patents Act 1988 or under the terms of a licence issued by the Copyright Licensing Agency Ltd,…

    • 128837 Words
    • 516 Pages
    Powerful Essays
  • Powerful Essays

    The Rise of Nine

    • 90129 Words
    • 361 Pages

    First published in Great Britain by Michael Joseph and Razorbill 2012 001 Copyright © Big Jim Industries, Inc., 2012 The moral right of the author has been asserted All rights reserved Without limiting the rights under copyright reserved above, no part of this publication may be reproduced, stored in or introduced into a retrieval system, or transmitted, in any form or by any means (electronic, mechanical, photocopying, recording or otherwise), without the prior written permission of both the copyright owner and the above publisher of this book Set in 13.5/16 Garamond MT Std Typeset by Jouve (UK), Milton Keynes Printed in Great Britain by Clays Ltd, St Ives plc ACIP…

    • 90129 Words
    • 361 Pages
    Powerful Essays
  • Good Essays

    © 2012 Southern Cross University Southern Cross University Military Road East Lismore NSW 2480 No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by means electronic, mechanical, photocopying, recording or otherwise without the prior written permission of the publisher. Copyright material indicated in this work has been copied under Part VB of the Copyright Act 1968.…

    • 4504 Words
    • 19 Pages
    Good Essays
  • Powerful Essays

    Ishikawa

    • 1080 Words
    • 5 Pages

    Chapman, Robert J.. Wiley Finance Series: Simple Tools and Techniques for Enterprise Risk Management (2nd Edition). Hoboken, NJ, USA: Wiley, 2011. p 230…

    • 1080 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    In the last chapter, we examined ways in which we can adjust the value of a risky asset for its risk. Notwithstanding their popularity, all of the approaches share a common theme. The riskiness of an asset is encapsulated in one number – a higher discount rate, lower cash flows or a discount to the value – and the computation almost always requires us to make assumptions (often unrealistic) about the nature of risk. In this chapter, we consider a different and potentially more informative way of assessing and presenting the risk in an investment. Rather than compute an expected value for an asset that that tries to reflect the different possible outcomes, we could provide information on what the value of the asset will be under each outcome or at least a subset of outcomes. We will begin this section by looking at the simplest version which is an analysis of an asset’s value under three scenarios – a best case, most likely case and worse case – and then extend the discussion to look at scenario analysis more generally. We will move on to examine the use of decision trees, a more complete approach to dealing with discrete risk. We will close the chapter by evaluating Monte Carlo simulations, the most complete approach of assessing risk across the spectrum.…

    • 17404 Words
    • 70 Pages
    Good Essays
  • Powerful Essays

    Financial Modeling

    • 1653 Words
    • 7 Pages

    This article describes the formula syntax and usage of the VLOOKUP function in Microsoft Excel.…

    • 1653 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    Lehman Case

    • 3956 Words
    • 16 Pages

    Financial Risk MVE220 Work distribution: 2010-11-24 Both the members of the project team have contributed equally to the case. Even though several parts have been written individually, the analyzing and key concepts have been developed mutually together. Examinator: Holger Rootzén Robin Feng 910911-1675 Niklas Fredriksson 900310-1855…

    • 3956 Words
    • 16 Pages
    Powerful Essays
  • Better Essays

    Derivative instruments are used as financial management tools to enhance investment returns and to manage such risks relative to interest rates, exchange rates, and financial instrument and commodity prices. Several local and international banks, businesses, municipalities, and others have experienced significant losses with the use of derivatives. However, their use has increased as efforts to control risk in complex situations are perceived to be wise strategic decisions.…

    • 3945 Words
    • 16 Pages
    Better Essays
  • Powerful Essays

    Petronas

    • 4521 Words
    • 19 Pages

    2.0 Financial Risk Analysis 2.1 United States Risk Analysis 2.2 China Risk Analysis 2.3 Russia Risk Analysis3.0 Foreign Exchange and Derivative Market 3.1 United States 3.2 China 3.3 Russia4.0 Hedging Instruments 4.1Types of Instrument 4.1.1 Interest Rate Derivative 4.1.2 Foreign Currency Derivative 4.1.3 Commodity Price Derivative 4.2 Hedging in United States 4.3 Hedging in China 4.4 Hedging in Russia5.0 Business Form…

    • 4521 Words
    • 19 Pages
    Powerful Essays
  • Good Essays

    Sr Aquino

    • 109674 Words
    • 439 Pages

    All rights reserved. No part of this book may be reproduced, in any form or by any means without permission in writing from the publisher. Printed in the United States of America 10 9 8 7 6 5 4 3 2 1…

    • 109674 Words
    • 439 Pages
    Good Essays

Related Topics