Search Results: financial-products-an-introduction-using-mathematics-and-excel

Financial Products

An Introduction Using Mathematics and Excel

Author: Bill Dalton

Publisher: Cambridge University Press

ISBN: 9781139474054

Category: Business & Economics

Page: 408

View: 4485

Financial Products provides a step-by-step guide to some of the most important ideas in financial mathematics. It describes and explains interest rates, discounting, arbitrage, risk neutral probabilities, forward contracts, futures, bonds, FRA and swaps. It shows how to construct both elementary and complex (Libor) zero curves. Options are described, illustrated and then priced using the Black Scholes formula and binomial trees. Finally, there is a chapter describing default probabilities, credit ratings and credit derivatives (CDS, TRS, CSO and CDO). An important feature of the book is that it explains this range of concepts and techniques in a way that can be understood by those with only a basic understanding of algebra. Many of the calculations are illustrated using Excel spreadsheets, as are some of the more complex algebraic processes. This accessible approach makes it an ideal introduction to financial products for undergraduates and those studying for professional financial qualifications.

Quantitative Finance

A Simulation-Based Introduction Using Excel

Author: Matt Davison

Publisher: CRC Press

ISBN: 1498782663

Category: Business & Economics

Page: 532

View: 3504

Teach Your Students How to Become Successful Working Quants Quantitative Finance: A Simulation-Based Introduction Using Excel provides an introduction to financial mathematics for students in applied mathematics, financial engineering, actuarial science, and business administration. The text not only enables students to practice with the basic techniques of financial mathematics, but it also helps them gain significant intuition about what the techniques mean, how they work, and what happens when they stop working. After introducing risk, return, decision making under uncertainty, and traditional discounted cash flow project analysis, the book covers mortgages, bonds, and annuities using a blend of Excel simulation and difference equation or algebraic formalism. It then looks at how interest rate markets work and how to model bond prices before addressing mean variance portfolio optimization, the capital asset pricing model, options, and value at risk (VaR). The author next focuses on binomial model tools for pricing options and the analysis of discrete random walks. He also introduces stochastic calculus in a nonrigorous way and explains how to simulate geometric Brownian motion. The text proceeds to thoroughly discuss options pricing, mostly in continuous time. It concludes with chapters on stochastic models of the yield curve and incomplete markets using simple discrete models. Accessible to students with a relatively modest level of mathematical background, this book will guide your students in becoming successful quants. It uses both hand calculations and Excel spreadsheets to analyze plenty of examples from simple bond portfolios. The spreadsheets are available on the book’s CRC Press web page.

Solutions Manual to Accompany Models for Life

An Introduction to Discrete Mathematical Modeling with Microsoft Office Excel

Author: Jeffrey T. Barton

Publisher: John Wiley & Sons

ISBN: 1119040027

Category: Mathematics

Page: 182

View: 9680

A solutions manual to accompany An Introduction to Discrete Mathematical Modeling with Microsoft® Office Excel® With a focus on mathematical models based on real and current data, Models for Life: An Introduction to Discrete Mathematical Modeling with Microsoft® Office Excel® guides readers in the solution of relevant, practical problems by introducing both mathematical and Excel techniques. The book begins with a step-by-step introduction to discrete dynamical systems, which are mathematical models that describe how a quantity changes from one point in time to the next. Readers are taken through the process, language, and notation required for the construction of such models as well as their implementation in Excel. The book examines single-compartment models in contexts such as population growth, personal finance, and body weight and provides an introduction to more advanced, multi-compartment models via applications in many areas, including military combat, infectious disease epidemics, and ranking methods. Models for Life: An Introduction to Discrete Mathematical Modeling with Microsoft® Office Excel® also features: A modular organization that, after the first chapter, allows readers to explore chapters in any order Numerous practical examples and exercises that enable readers to personalize the presented models by using their own data Carefully selected real-world applications that motivate the mathematical material such as predicting blood alcohol concentration, ranking sports teams, and tracking credit card debt References throughout the book to disciplinary research on which the presented models and model parameters are based in order to provide authenticity and resources for further study Relevant Excel concepts with step-by-step guidance, including screenshots to help readers better understand the presented material Both mathematical and graphical techniques for understanding concepts such as equilibrium values, fixed points, disease endemicity, maximum sustainable yield, and a drug’s therapeutic window A companion website that includes the referenced Excel spreadsheets, select solutions to homework problems, and an instructor’s manual with solutions to all homework problems, project ideas, and a test bank

An Introduction to Excel VBA Programming

with Applications in Finance and Insurance

Author: Guojun Gan

Publisher: CRC Press

ISBN: 1315280671

Category: Business & Economics

Page: 300

View: 7377

Excel Visual Basic for Applications (VBA) can be used to automate operations in Excel and is one of the most frequently used software programs for manipulating data and building models in banks and insurance companies. An Introduction to Excel VBA Programming: with Applications in Finance and Insurance introduces readers to the basic fundamentals of VBA Programming while demonstrating applications of VBA to solve real-world problems in finance and insurance. Assuming no prior programming experience and with reproducible examples using code and data, this text is suitable for advanced undergraduate students, graduate students, actuaries, and financial analysts who wish to learn VBA. Features: Presents the theory behind the algorithms in detail Includes more than 100 exercises with selected solutions Provides VBA code in Excel files and data to reproduce the results in the book Offers a solutions manual for qualified instructors

C++ Design Patterns and Derivatives Pricing

Author: M. S. Joshi

Publisher: Cambridge University Press

ISBN: 0521721628

Category: Business & Economics

Page: 292

View: 767

Explains how to create well-designed, structured, reusable C++ code, particularly for financial applications.

A Course in Derivative Securities

Introduction to Theory and Computation

Author: Kerry Back

Publisher: Springer Science & Business Media

ISBN: 3540279008

Category: Business & Economics

Page: 356

View: 4278

"Deals with pricing and hedging financial derivatives.... Computational methods are introduced and the text contains the Excel VBA routines corresponding to the formulas and procedures described in the book. This is valuable since computer simulation can help readers understand the theory....The book...succeeds in presenting intuitively advanced derivative modelling... it provides a useful bridge between introductory books and the more advanced literature." --MATHEMATICAL REVIEWS

Mastering Financial Mathematics in Microsoft Excel

A practical guide to business calculations

Author: Alastair Day

Publisher: Pearson UK

ISBN: 1292067535

Category: Business & Economics

Page: 392

View: 5508

Fully updated and compliant with Excel 2013, this clearly explains the basic calculations for mathematical finance, backed up with simple templates for further use and development, and a workbook with exercises and solutions at the end of each chapter. The examples used are relevant to both managers and students in the UK and overseas. New to this edition Updated glossary of key terms Functions list in English and Euro languages Continuity check on all formats, layouts and charts More worked examples Additional exercises at the end of each chapter to help build models Templates and models available online.

Financial Modeling in Excel For Dummies

Author: Danielle Stein Fairhurst

Publisher: John Wiley & Sons

ISBN: 111935756X

Category: Business & Economics

Page: 336

View: 7460

Make informed business decisions with the beginner's guide to financial modeling using Microsoft Excel Financial Modeling in Excel For Dummies is your comprehensive guide to learning how to create informative, enlightening financial models today. Not a math whiz or an Excel power-user? No problem! All you need is a basic understanding of Excel to start building simple models with practical hands-on exercises and before you know it, you'll be modeling your way to optimized profits for your business in no time. Excel is powerful, user-friendly, and is most likely already installed on your computer—which is why it has so readily become the most popular financial modeling software. This book shows you how to harness Excel's capabilities to determine profitability, develop budgetary projections, model depreciation, project costs, value assets and more. You'll learn the fundamental best practices and know-how of financial modeling, and how to put them to work for your business and your clients. You'll learn the tools and techniques that bring insight out of the numbers, and make better business decisions based on quantitative evidence. You'll discover that financial modeling is an invaluable resource for your business, and you'll wonder why you've waited this long to learn how! Companies around the world use financial modeling for decision making, to steer strategy, and to develop solutions. This book walks you through the process with clear, expert guidance that assumes little prior knowledge. Learn the six crucial rules to follow when building a successful financial model Discover how to review and edit an inherited financial model and align it with your business and financial strategy Solve client problems, identify market projections, and develop business strategies based on scenario analysis Create valuable customized templates models that can become a source of competitive advantage From multinational corporations to the mom-and-pop corner store, there isn't a business around that wouldn't benefit from financial modeling. No need to buy expensive specialized software—the tools you need are right there in Excel. Financial Modeling in Excel For Dummies gets you up to speed quickly so you can start reaping the benefits today!

Financial Modeling

Author: Simon Benninga,Benjamin Czaczkes

Publisher: MIT Press

ISBN: 0262027283

Category: Business & Economics

Page: 1144

View: 8574

A substantially revised edition of a bestselling text combining explanation and implementation using Excel; for classroom use or as a reference for finance practitioners.

Financial Analysis with Microsoft Excel 2016, 8E

Author: Timothy R. Mayes,Todd M. Shank

Publisher: Cengage Learning

ISBN: 1337515523

Category: Business & Economics

Page: 50

View: 352

Taking your spreadsheet skills to the next level, Mayes/Shank's FINANCIAL ANALYSIS WITH MICROSOFT EXCEL 2016, 8E, equips you with a solid foundation in corporate finance while helping you master the tools professionals use every day. It delivers thorough coverage of financial statements, cash budgets, time series forecasting, the Security Market Security Line, pro forma financial statements, cost of capital, VBA programming, Pivot Tables, and Get & Transform tools (formerly known as Power Query). With its unique self-directed learning approach, this reader-friendly book is an ideal resource for independent learning and a valuable reference tool. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Using Excel for Business Analysis

A Guide to Financial Modelling Fundamentals

Author: Danielle Stein Fairhurst

Publisher: John Wiley & Sons

ISBN: 1119062462

Category: Business & Economics

Page: 464

View: 9196

While there are many hundreds of tools, features and functions in Excel, this book focusses only on the ones it is critical for the Finance Business user to know. It covers these features in detail from a practical perspective, but also puts them in context by applying them to practical examples in the real world. It is invaluable for anyone using Excel for Finance, as it helps them to do their jobs faster, more efficiently and with fewer errors. The book is organized into twelve chapters, arranged in order based on different aspects of Excel modelling. This book includes: -step-by-step instructions for how to use each feature that are detailed in a practical example -live models for readers to build it on their own accompanying excel worksheets downloadable via the website

Business Math Using Excel

Author: Sharon Burton,Nelda Shelton

Publisher: Cengage Learning

ISBN: 0538731192

Category: Business & Economics

Page: 640

View: 3270

Prepare your students to meet the demands of today’s business world with the proven, practical dual approach in Burton/Shelton’s BUSINESS MATH USING EXCEL, 2nd Edition. This book equips readers to master the math concepts most useful in contemporary business by first teaching students the traditional methods of calculating. The authors then emphasize a second approach that teaches the same math concepts using the functions of Microsoft Excel. This edition of BUSINESS MATH USING EXCEL prepares students to use the latest version of Excel 2010. Your future business professionals learn to create formulas and master the functions of Excel while developing high level math skills and refining other skills that will prepare them to succeed in the workplace. This edition’s new, full-color design presents concepts in manageable sections to help build confidence for students at all levels of math proficiency. New profiles and new personal finance features emphasize the practicality of the book’s content as they demonstrate how professionals use math daily and highlight common consumer issues. A new CourseMaster outcomes-based learning solution with homework tools and automatic grading saves you time while helping students focus on the concepts most important for business math success. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Applied mathematics with Microsoft Excel

Author: Chester Piascik

Publisher: Brooks/Cole Pub Co

ISBN: N.A

Category: Computers

Page: 257

View: 9262

Designed as a supplement to any combined Finite Mathematics/Applied Calculus text when the instructor wants to use Excel in the course, Piascik's useful manual illustrates key topics, through the use of Microsoft Excel. Explanations of Excel instructions and formulas reinforce the underlying mathematical concepts. The author encourages students to be active learners, asking them to verbalize and verify the mathematical concepts behind spreadsheet results.

Financial Modeling Using Excel and VBA

Author: Chandan Sengupta

Publisher: John Wiley & Sons

ISBN: 9780471267683

Category: Business & Economics

Page: 857

View: 4269

"Reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial models" - cover.

Advanced Modelling in Finance using Excel and VBA

Author: Mary Jackson,Mike Staunton

Publisher: John Wiley & Sons

ISBN: 0470061669

Category: Business & Economics

Page: 276

View: 7556

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.

A Spiral Approach to Financial Mathematics

Author: Nathan Tintle,Nathan Schelhaas,Todd Swanson

Publisher: Academic Press

ISBN: 0128017597

Category: Business & Economics

Page: 612

View: 4990

A Spiral Approach to Financial Mathematics lays a foundation of intuitive analysis of financial concepts early in the course, followed by a more detailed and nuanced treatment in later chapters. It introduces major financial concepts through real situations, integrates active learning, student focused explorations and examples with Excel spreadsheets and straightforward financial calculations. It is organized so sections can be read independently or through in-class guided-discovery activities and/or interactive lectures. Focusing on conceptual understanding to maximize comprehension and retention, using modern financial analysis tools and utilizing active learning, the book offers a modern approach that eliminates tedious and time-consuming calculations initially without underestimating the ability of readers. Covers FM Exam topics Includes Excel spreadsheets that enable the execution of financial transactions Presents a spiral, active learning pedagogical strategy that accentuates key concepts and reinforces intuitive learning

Quantitative Finance

A Simulation-Based Introduction Using Excel

Author: Matt Davison

Publisher: CRC Press

ISBN: 1498782663

Category: Business & Economics

Page: 532

View: 6144

Teach Your Students How to Become Successful Working Quants Quantitative Finance: A Simulation-Based Introduction Using Excel provides an introduction to financial mathematics for students in applied mathematics, financial engineering, actuarial science, and business administration. The text not only enables students to practice with the basic techniques of financial mathematics, but it also helps them gain significant intuition about what the techniques mean, how they work, and what happens when they stop working. After introducing risk, return, decision making under uncertainty, and traditional discounted cash flow project analysis, the book covers mortgages, bonds, and annuities using a blend of Excel simulation and difference equation or algebraic formalism. It then looks at how interest rate markets work and how to model bond prices before addressing mean variance portfolio optimization, the capital asset pricing model, options, and value at risk (VaR). The author next focuses on binomial model tools for pricing options and the analysis of discrete random walks. He also introduces stochastic calculus in a nonrigorous way and explains how to simulate geometric Brownian motion. The text proceeds to thoroughly discuss options pricing, mostly in continuous time. It concludes with chapters on stochastic models of the yield curve and incomplete markets using simple discrete models. Accessible to students with a relatively modest level of mathematical background, this book will guide your students in becoming successful quants. It uses both hand calculations and Excel spreadsheets to analyze plenty of examples from simple bond portfolios. The spreadsheets are available on the book’s CRC Press web page.

Financial Modeling

An Introductory Guide to Excel and VBA Applications in Finance

Author: Joachim Häcker,Dietmar Ernst

Publisher: Springer

ISBN: 1137426586

Category: Business & Economics

Page: 956

View: 4122

This book provides a comprehensive introduction to modern financial modeling using Excel, VBA, standards of financial modeling and model review. It offers guidance on essential modeling concepts around the four core financial activities in the modern financial industry today: financial management; corporate finance; portfolio management and financial derivatives. Written in a highly practical, market focused manner, it gives step-by-step guidance on modeling practical problems in a structured manner. Quick and interactive learning is assured due to the structure as a training course which includes applied examples that are easy to follow. All applied examples contained in the book can be reproduced step by step with the help of the Excel files. The content of this book serves as the foundation for the training course Certified Financial Modeler. In an industry that is becoming increasingly complex, financial modeling is a key skill for practitioners across all key sectors of finance and banking, where complicated problems often need to be solved quickly and clearly. This book will equip readers with the basic modeling skills required across the industry today.

Professional Financial Computing Using Excel and VBA

Author: Donny C. F. Lai,Humphrey K. K. Tung,Michael C. S. Wong

Publisher: John Wiley & Sons

ISBN: 1118179080

Category: Business & Economics

Page: 350

View: 4908

"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

Engineering Computations

An Introduction Using MATLAB and Excel

Author: Joseph C. Musto,William E. Howard,Richard R. Williams

Publisher: N.A

ISBN: 9780071263573

Category: Engineering

Page: 330

View: 4587

The strength of Engineering Computation is its combination of the two most important computational programs in the engineering marketplace today, MATLAB® and Excel®. Engineering students will need to know how to use both programs to solve problems. The focus of this text is on the fundamentals of engineering computing: algorithm development, selection of appropriate tools, documentation of solutions, and verification and interpretation of results. To enhance instruction, the companion website includes a detailed set of PowerPoint slides that illustrate important points reinforcing them for students and making class preparation easier.

Find eBook