Optical Design Using Excel

Comprehensive instruction on developing real-world financial models This book, designed for self-study, classroom use, and reference, presents a com-prehensive approach to developing simple to sophisticated financial models in all major areas of finance. The approach is based on the author's 20 years of experience of developing such models in the business world and teaching a popular MBA class in financial modeling. The book assumes only basic knowledge of Excel and teaches all advanced features of Excel and VBA from scratch using a unique simple method. A companion CD includes all working versions of all the models presented in the book and additional useful reference material. Chandan Sengupta (White Plains, NY) teaches finance in the MBA program at Fordham University's Graduate School of Business. Formerly, he was vice president of the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for 10 years. He is also the author of The Only Proven Road to Investment Success (0-471-44307-7).

"Professional Financial Computing Using Excel and VBA is an admirable exposition that bridges the theoretical underpinnings of financial engineering and its application which usually appears as a «black-box» software application. The book opens the black-box and reveals the architecture of risk-modeling and financial engineering based on industry-standard stochastic models by utilizing Excel and VBA functionality to create a robust and practical modeling tool-kit. Financial engineering professionals who purchase this book will have a jumpstart advantage for their customized financial engineering and modeling needs." Dr. Cameron Wicentowich Vice President, Treasury Analytics Canadian Imperial Bank of Commerce (CIBC) «Spreadsheet modeling for finance has become a standard course in the curriculum of many Quantitative Finance programs since the Excel-based Visual Basic programming is now widely used in constructing optimal portfolios, pricing structured products and managing risks. Professional Financial Computing Using Excel and VBA is written by a unique team of finance, physics and computer academics and practitioners. It is a good reference for those who are studying for a Masters degree in Financial Engineering and Risk Management. It can also be useful for financial engineers to jump-start a project on designing structured products, modeling interest term structure or credit risks.» Dr. Jin Zhang Director of Master of Finance Program and Associate Professor The University of Hong Kong «Excel has been one of the most powerful tools for financial planning and computing over the last few years. Most users utilize a fraction of its capabilities. One of the reasons is the limited availability of books that cover the advanced features of Excel for Finance. Professional Financial Computing Using Excel and VBA goes the extra mile and deals with the Excel tools many professionals call for. This book is a must for professionals or students dealing with financial engineering, financial risk management, computational finance or mathematical finance. I loved the way the authors covered the material using real life, hands-on examples.» Dr. Isaac Gottlieb Temple University Author, Next Generation Excel: Modeling in Excel for Analysts and MBAs

In today's increasingly competitive financial world, successful risk management, portfolio management, and financial structuring demand more than up-to-date financial know-how. They also call for quantitative expertise, including the ability to effectively apply mathematical modeling tools and techniques, in this case credit. Credit Risk Modeling using Excel and VBA with DVD provides practitioners with a hands on introduction to credit risk modeling. Instead of just presenting analytical methods it shows how to implement them using Excel and VBA, in addition to a detailed description in the text a DVD guides readers step by step through the implementation. The authors begin by showing how to use option theoretic and statistical models to estimate a borrowers default risk. The second half of the book is devoted to credit portfolio risk. The authors guide readers through the implementation of a credit risk model, show how portfolio models can be validated or used to access structured credit products like CDO’s. The final chapters address modeling issues associated with the new Basel Accord.

This is a complete update of the author's earlier book, FSM-Based Digital Design using Verilog HDL (Wiley 2008). Whilst the essential foundation content remains, the book has been considerably refreshed to cover the design of Finite State Machines (FSM) in place of Microprocessors, using a novel form of State Machines based on Toggle Flip Flops (TFF) and Data Flip Flops (DFF). It follows a Linear Programmed Learning approach, enabling the reader to learn at their own pace, and to design their own FSM based systems.

This book presents the design of steel structures using finite element methods (FEM) according to the current state of the art in Germany and the rest of Europe. After a short introduction on the basics of the design, this book illustrates the FEM with a focus on internal forces, displacements, critical loads and modal shapes. Next to finite element procedures for linear calculations considering the stress states of normal force, biaxial bending and warping torsion, non-linear calculations and the stability cases of flexural buckling, lateral torsional buckling and plate buckling are concentrated on significantly. In this context, design procedures for stability according to the standard Eurocode 3 is introduced and discussed. In addition, important fundamental issues are covered, such as the determination of cross-section properties as well as the elastic and plastic cross-section resistance. Complementary, finite element procedures for cross sections are dealt with, which will have an increasing importance in future. This book has evolved within the teaching activities of the authors in the lecture Computer-oriented Design of Steel Structures on the Master?s Program Computational Engineering at the University of Bochum. It covers the total variety of demands needed to be discussed for the safe, economic and modern design of steel structures.

The skills and guidance needed to master RTL hardware design This book teaches readers how to systematically design efficient, portable, and scalable Register Transfer Level (RTL) digital circuits using the VHDL hardware description language and synthesis software. Focusing on the module-level design, which is composed of functional units, routing circuit, and storage, the book illustrates the relationship between the VHDL constructs and the underlying hardware components, and shows how to develop codes that faithfully reflect the module-level design and can be synthesized into efficient gate-level implementation. Several unique features distinguish the book: * Coding style that shows a clear relationship between VHDL constructs and hardware components * Conceptual diagrams that illustrate the realization of VHDL codes * Emphasis on the code reuse * Practical examples that demonstrate and reinforce design concepts, procedures, and techniques * Two chapters on realizing sequential algorithms in hardware * Two chapters on scalable and parameterized designs and coding * One chapter covering the synchronization and interface between multiple clock domains Although the focus of the book is RTL synthesis, it also examines the synthesis task from the perspective of the overall development process. Readers learn good design practices and guidelines to ensure that an RTL design can accommodate future simulation, verification, and testing needs, and can be easily incorporated into a larger system or reused. Discussion is independent of technology and can be applied to both ASIC and FPGA devices. With a balanced presentation of fundamentals and practical examples, this is an excellent textbook for upper-level undergraduate or graduate courses in advanced digital logic. Engineers who need to make effective use of today's synthesis software and FPGA devices should also refer to this book.

Utilizing the latest software, this book presents the essential statistical procedures for drawing valuable results from data in the social sciences. Mobilizing interesting real-world examples from the field of education, Understanding Educational Statistics Using Microsoft Excel and SPSS supplies a seamless presentation that identifies valuable connections between statistical applications and research design. Class-tested to ensure an accessible presentation, the book combines clear, step-by-step explanations and the use of software packages that are accessible to both the novice and professional alike to present the fundamental statistical practices for organizing, understanding, and drawing conclusions from educational research data. The book begines with an introduction to descriptive and inferential statistics and then proceeds to acquaint readers with the various functions for working with quantitative data in the Microsoft Excel environment, such as spreadsheet navigation; sorting and filtering; and creating pivot tables. Subsequent chapters treat the procedures that are commonly-employed when working with data across various fields of social science research, including: Single-sample tests Repeated measure tests Independent t-tests One way ANOVA and factorial ANOVA Correlation Bivariate regression Chi square Multiple regression Individual chapters are devoted to specific procedures, each ending with a lab exercise that highlights the importance of that procedure by posing a research question, examining the question through its application in Excel and SPSS, and concluding with a brief research report that outlines key findings drawn from the results. Real-world examples and data from modern educational research are used throughout the book, and a related Web site features additional data sets, examples, and labs, allowing readers to reinforce their comprehension of the material. Bridging traditional statistical topics with the latest software and applications in the field of education, Understanding Educational Statistics Using Microsoft Excel and SPSS is an excellent book for courses on educational research methods and introductory statistics in the social sciences at the upper-undergraduate and graduate levels. It also serves as a valuable resource for researchers and practitioners in the fields of education, psychology, and the social sciences who require a statistical background to work with data in their everyday work.

This comprehensive guide offers traders, quants, and students the tools and techniques for using advanced models for pricing options. The accompanying website includes data files, such as options prices, stock prices, or index prices, as well as all of the codes needed to use the option and volatility models described in the book. Praise for Option Pricing Models & Volatility Using Excel-VBA «Excel is already a great pedagogical tool for teaching option valuation and risk management. But the VBA routines in this book elevate Excel to an industrial-strength financial engineering toolbox. I have no doubt that it will become hugely successful as a reference for option traders and risk managers.» —Peter Christoffersen, Associate Professor of Finance, Desautels Faculty of Management, McGill University «This book is filled with methodology and techniques on how to implement option pricing and volatility models in VBA. The book takes an in-depth look into how to implement the Heston and Heston and Nandi models and includes an entire chapter on parameter estimation, but this is just the tip of the iceberg. Everyone interested in derivatives should have this book in their personal library.» —Espen Gaarder Haug, option trader, philosopher, and author of Derivatives Models on Models «I am impressed. This is an important book because it is the first book to cover the modern generation of option models, including stochastic volatility and GARCH.» —Steven L. Heston, Assistant Professor of Finance, R.H. Smith School of Business, University of Maryland

This new and unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. Advanced Modelling in Finance provides a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s. The book adopts a step-by-step approach to understanding the more sophisticated aspects of Excel macros and VBA programming, showing how these programming techniques can be used to model and manipulate financial data, as applied to equities, bonds and options. The book is essential for financial practitioners who need to develop their financial modelling skill sets as there is an increase in the need to analyse and develop ever more complex 'what if' scenarios. Specifically applies Excel and VBA to the financial markets Packaged with a CD containing the software from the examples throughout the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.