You have no items in your shopping cart.

Financial Simulation Modeling in Excel: A Step-by-Step Guide

Financial Simulation Modeling in Excel A Step-by-Step Guide

  • Author:
  • Publisher: John Wiley & Sons
  • ISBN: 9780470931226
  • Published In: September 2011
  • Format: Paperback , 216 pages
  • Jurisdiction: International ? Disclaimer:
    Countri(es) stated herein are used as reference only

List Price: HKD 1,100.00

HKD 1,067.00 Save HKD 33.00 (3%)

Delivery Time: around 1-2 weeks
Extra 2-10 working days working days if shipping address outside Hong Kong
Free delivery Hong Kong?
Hong Kong: free delivery (order over HKD 1000)
OR
  • Description 
  • Contents 
  • Author 
  • Details

    "I've worked with simulation in business for over 20 years, and Allman really nails it with this book. I admit that I own his previous book on structured finance cash flows, but I was surprised by what I found in here. He addresses the fundamental questions of how decision makers react to simulations and his read was very much in accordance with what I've experienced myself. When it came to the nuts and bolts of describing the different types of simulation analysis the book becomes incredibly detailed. There is working code and models for a fantastic array of the most common simulation problems. If you're so inclined, the book very carefully steps through the tricky math needed to really understand the theory behind stochastic modeling in finance. If you're preparing models that include any kind of randomization or stochastic modeling component, this book is a must-read, a tremendous value and time-saver." — David Brode of The Brode Group

    A practical guide to understanding and implementing financial simulation modeling

    As simulation techniques become more popular among the financial community and a variety of sub-industries, a thorough understanding of theory and implementation is critical for practitioners involved in portfolio management, risk management, pricing, and capital budgeting. Financial Simulation Modeling in Excel contains the information you need to make the most informed decisions possible in your professional endeavors.

    Financial Simulation Modeling in Excel contains a practical, hands-on approach to learning complex financial simulation methodologies using Excel and VBA as a medium. Crafted in an easy to understand format, this book is suitable for anyone with a basic understanding of finance and Excel. Filled with in-depth insights and expert advice, each chapter takes you through the theory behind a simulation topic and the implementation of that same topic in Excel/VBA in a step-by-step manner.

    • Organized in an easy-to-follow fashion, this guide effectively walks you through the process of creating and implementing risk models in Excel
    • A companion website contains all the Excel models risk experts and quantitative analysts need to practice and confirm their results as they progress
    • Keith Allman is the author of other successful modeling books, including Corporate Valuation Modeling and Modeling Structured Finance Cash Flows with Microsoft Excel

    Created for those with some background in finance and experience in Excel, this reliable resource shows you how to effectively perform sound financial simulation modeling, even if you've yet to do extensive modeling up to this point in your professional or academic career.

  • Preface.

    Acknowledgments.

    About the Authors.

    Chapters 1: Introduction.

    Chapters 2: Random Numbers, Distributions, and Basic Simulation Set Up.

    Chapters 3: Correlation.

    Chapters 4: Option Pricing.

    Chapters 5: Corporate Default Simulation.

    Chapters 6: Simulating Pools of Assets.

    Chapters 7: Dealing with Data Deficiencies and Other Issues.

    Chapters 8: Advanced Topics and Further Reading.

    Appendix I: Partial Differential Equation.

    Appendix II: Newton-Raphson Method.

    List of Model Builder Files Available on Website.

    References.

    Index.

  • Keith A. Allman is an investment manager at Bamboo Finance, a private equity fund that invests in for-profit, commercially viable companies that provide a good or service that beneficially impacts the lives of low-income individuals. Previously, he was the director of analytics and modeling at Pearl Street Capital Group. Allman also founded Enstruct, which services clients worldwide in capital markets and equity valuation, distressed valuation, and quantitative-based training. He is the author of the Wiley titles Corporate Valuation Modeling, Modeling Structured Finance Cash Flows with Microsoft® Excel®, and Reverse Engineering Deals on Wall Street with Microsoft® Excel®. Allman holds bachelor degrees from UCLA and a master's degree from Columbia University.

    Josh Laurito, CFA, is a co-founder and Principal of Lumesis, a leading provider of credit analysis software and solutions to the municipal finance market. In addition, he directs corporate modeling for Hexagon Securities, a boutique merchant bank that advises and invests in banks and specialty finance companies.

    MichaelL Loh currently works for Tech-X Corporation where he is actively engaged in complex data management and high-performance computing using accelerated hardware. Prior to Tech-X, Loh developed and implemented financial models at RangeMark Financial Services

You may also be interested in these books:

KPMG's Insights into IFRS 2018/2019
KPMG's Insights into IFRS 2018/2019

List Price: HKD 1,920.00

HKD 1,862.40 Save HKD 57.60 (3%)

Compliance and Company Secretarial Practice of Hong Kong Listed Companies
Compliance and Company Secretarial Practice of Hong Kong Listed Companies

List Price: HKD 1,270.00

HKD 1,231.90 Save HKD 38.10 (3%)

Hong Kong Company Secretary's Practice Manual (4th Edition)
Hong Kong Company Secretary's Practice Manual (4th Edition)

List Price: HKD 999.00

HKD 969.03 Save HKD 29.97 (3%)

Hong Kong Master Tax Guide 2018-2019 (27th Edition)
Hong Kong Master Tax Guide 2018-2019 (27th Edition)

List Price: HKD 980.00

HKD 392.00 Save HKD 588.00 (60%)

Ernst & Young's International GAAP 2018
Ernst & Young's International GAAP 2018
HKD 2,250.00
PwC Manual of Accounting IFRS 2018 Set
PwC Manual of Accounting IFRS 2018 Set

List Price: HKD 1,860.00

HKD 1,804.20 Save HKD 55.80 (3%)

Deloitte iGAAP 2018: International IFRS Pack
Deloitte iGAAP 2018: International IFRS Pack

List Price: HKD 2,430.00

HKD 880.00 Save HKD 1,550.00 (64%)

Individual Income Tax Planning for Expatriates in China, 6th Edition
Individual Income Tax Planning for Expatriates in China, 6th Edition

List Price: HKD 1,280.00

HKD 1,241.60 Save HKD 38.40 (3%)

Hong Kong Company Secretary Checklist
Hong Kong Company Secretary Checklist

List Price: HKD 788.00

HKD 764.36 Save HKD 23.64 (3%)

China Master Tax Guide 2016/17 (13th Edition)
China Master Tax Guide 2016/17 (13th Edition)

List Price: HKD 980.00

HKD 950.60 Save HKD 29.40 (3%)

A Practical Guide to Tax Audit and Investigation in Hong Kong
A Practical Guide to Tax Audit and Investigation in Hong Kong

List Price: HKD 750.00

HKD 375.00 Save HKD 375.00 (50%)

The Hong Kong Company Secretary's Handbook: Practice and Procedure (10th Edition)
The Hong Kong Company Secretary's Handbook: Practice and Procedure (10th Edition)

List Price: HKD 453.00

HKD 439.41 Save HKD 13.59 (3%)

Financial Reporting in Hong Kong 2015/16 (SME Edition)
Financial Reporting in Hong Kong 2015/16 (SME Edition)

List Price: HKD 1,250.00

HKD 1,212.50 Save HKD 37.50 (3%)

International Taxation: Law and Practice in Hong Kong and China
International Taxation: Law and Practice in Hong Kong and China

List Price: HKD 980.00

HKD 950.60 Save HKD 29.40 (3%)

Concise Guide: Compliance and Company Secretarial Practice of Hong Kong Private Companies
Concise Guide: Compliance and Company Secretarial Practice of Hong Kong Private Companies

List Price: HKD 2,388.00

HKD 2,316.36 Save HKD 71.64 (3%)

Hong Kong Master GAAP Guide (15th Edition)
Hong Kong Master GAAP Guide (15th Edition)

List Price: HKD 1,500.00

HKD 1,455.00 Save HKD 45.00 (3%)