Read more
Zusatztext No. 4 bestseller in 'General Finance' (erivativesreview.com! December 2001) Informationen zum Autor Mary G. Jackson, MEd, MS, is a Licensed Clinical Professional Counselor (LCPC) in private practice and a graduate of Loyola College of Maryland's School of Pastoral Counseling. She holds two master's degrees, the first studying educational psychology and the second in counseling, followed by advanced study in pastoral counseling. Mary has led an eclectic life spurred by her adventurous curiosity. She is just as much at home in the city of her birth, Washington, D.C., the Maryland farm raising alpacas, or the coastal beach of Delaware. Mary delights in her close and loving family, world travel, and a search for meaning. A life-long seeker, Mary invites you to ponder your spiritual journey and to recognize the Divine in your everyday life. Klappentext Advanced modelling in finance using Excel and VBA Mary Jackson and Mike Staunton 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 rovered 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 & Reimer) quasi Monte Carlo simulation volatility smiles Black, Derman & Toy trees normal interest rate trees No. 4 bestseller in 'General Finance' (erivativesreview.com, December 2001) Zusammenfassung Advanced Modelling in Finance Using Excel and VBA outlines a step-by-step approach to using the more sophisticated aspects of Excel macros and VBA programming to model and manipulate financial data, illustrating with practical examples how these can be applied to a variety of financial problems and situations. Inhaltsverzeichnis Preface xi Acknowledgements xii 1 Introduction 1 1.1 Finance insights 1 1.2 Asset price assumptions 2 1.3 Mathematical and statistical problems 2 1.4 Numerical methods 2 1.5 Excel solutions 3 1.6 Topics covered 3 1.7 Related Excel workbooks 5 1.8 Comments and suggestions 5 Part One Advanced Modelling in Excel 7 2 Advanced Excel functions and procedures 9 2.1 Accessing functions in Excel 9 2.2 Mathematical functions 10 2.3 Statistical functions 12 2.3.1 Using the frequency function 12 2.3.2 Using the quartile function 14 2.3.3 Using Excel's normal functions 15 2.4 Lookup functions 16 2.5 Other functions 18 2.6 Auditing tools 19 2.7 Data Tables 20 2.7.1 Setting up Data Tables with one input 20 2.7.2 Setting up Data Tables with two inputs 22 2.8 XY charts 23 2.9 Access to Data Analysis and Solver 26 2.10 Using range names 27 2.11 Regression 28 2.12 Goal Seek 31 2.13 Matrix algebra and related functions 33 2.13.1 Introduction to matrices 33 2.13.2 Transposing a matrix 33 2.13.3 Adding matrices 34 2.13.4 Multiplying matrices 34 2.13.5 Matrix inversion 35 2.13.6 Solving systems of simultaneous linear equations 36 2.13.7 Summary of Excel's matrix functions 37 Summary 37 3 Introd...
