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
Words: 57326 - Pages: 230
SPREADSHEET MODELING IN CORPORATE FINANCE To accompany Principles of Corporate Finance by Brealey and Myers CRAIG W. HOLDEN Richard G. Brinkman Faculty Fellow and Associate Professor Kelley School of Business Indiana University Prentice Hall, Upper Saddle River, New Jersey 07458 To Kathryn, you’re the inspiration, and to Diana and Jimmy, with joy and pride. Craig CONTENTS Preface PART 1 TIME VALUE OF MONEY Chapter 1 Single Cash Flow 1.1 Present Value 1.2 Future Value Problems
Words: 49278 - Pages: 198
org/Quant/2/45 1 Abstract The prices of index options at a given date are usually represented via the corresponding implied volatility surface, presenting skew/smile features and term structure which several models have attempted to reproduce. However, the implied volatility surface also changes dynamically over time in a way that is not taken into account by current modelling approaches, giving rise to ‘Vega’ risk in option portfolios. Using time series of option prices on the SP500 and FTSE indices, we
Words: 11290 - Pages: 46
EXCEL MODELING AND ESTIMATION IN CORPORATE FINANCE Third Edition CRAIG W. HOLDEN Max Barney Faculty Fellow and Associate Professor Kelley School of Business Indiana University Copyright © 2008 by Prentice Hall, Inc., Upper Saddle River, New Jersey 07458 To Kathryn, Diana, and Jimmy. Contents iii CONTENTS Preface ..................................................................................... vii Third Edition Changes .............................................
Words: 33587 - Pages: 135
rights for their entire portfolio of movies the studios are going to produce over the next year. Arundel should make an offer to buy sequel rights as the average NPV (on a per film basis ) is $5.51 mn (this is the value calculated using real options method). Hence, we should pay a price below $5.51mn. As per informal inquiries made by us, the studios would be tempted to accept the price of $2mn or more and would not even consider a price below $1mn. We propose that we should negotiate
Words: 1681 - Pages: 7
1. When shares of common stock are issued to satisfy the exercise of employee stock options, are the shares issued from the Company’s “authorized but previously unissued shares” or from the Company’s “treasury stock”? Where in the financial statements do you find this information? (page 44) According to the 10-K, the Company’s common stock remains the same in 2011 and 2010 (75.5 million) while the treasury stock increased from 2615.2 to 3210.3 million, which means the Company didn’t issue any
Words: 991 - Pages: 4
Agreements 10. International Trade Organizations 11. International HR Strategies . 12. International Diplomacy - . Reference Text 1. International Business - Daniels and Radebouqh 2. International Business - Sundaram and Black 3. International Business — Roebuck and Simon 4. International Business – Charles Hill 5. International Business— Subba Rao 3.0.2 Strategic management 100 Marks Course Content 1. Strategic Management Process:
Words: 2761 - Pages: 12
teaching finance courses, and above all in the quantity and quality of their combined schol-arly output. The huge body of scholarly research in finance over the last forty years falls naturally into two main streams. And no, I don’t mean “asset pricing” and “cor-porate finance,” but instead a deeper division that cuts across both. The division I have in mind is the more fundamental one between what I will call the business school approach to finance and the economics department approach. Let me
Words: 5360 - Pages: 22
Paper P4 is the advanced financial MANAGEMENT paper at the Professional level. It follows on from Paper F9 at the Fundamentals level. As throughout the ACCA syllabus, the Fundamentals paper covers the main technical areas that all accountants are required to master, whereas the Professional paper builds on that knowledge and explores advanced skills and techniques. In particular Paper P4 expects candidates to have more depth of knowledge, better analytical skills, and to be able to exercise greater
Words: 3127 - Pages: 13
either cash of $5,000 or 3,000 special options that allow her to buy as many as 3000 shares of Telstar’s stocks for $35.00 at her 5th anniversary employment. Today is May 27, 1992, we have a list of quotations of Short- and Long-term Call Options of Telstar stocks, a list of historical price and volatility of Telstar Common Stock since Jan, 82, and a list of T-bill security yields. Now we are here to help her make a choice. I. B-S Model for option pricing Today is the final day for Sally to
Words: 319 - Pages: 2
