Reverse Engineering Deals on Wall Street with Microsoft Excel: A Step-by-Step Guide
()
Currently unavailable
Currently unavailable
About this ebook
It’s clear from the current turbulence on Wall Street that the inner workings of its most complex transactions are poorly understood. Wall Street deals parse risk using intricate legal terminology that is difficult to translate into an analytical model. Reverse Engineering Deals on Wall Street: A Step-By-Step Guide takes readers through a detailed methodology of deconstructing the public deal documentation of a modern Wall Street transaction and applying the deconstructed elements to create a fully dynamic model that can be used for risk and investment analysis.
Appropriate for the current market climate, an actual residential mortgage backed security (RMBS) transaction is taken from prospectus to model by the end of the book. Step by step, Allman walks the reader through the reversing process with textual excerpts from the prospectus and discussions on how it directly transfers to a model. Each chapter begins with a discussion of concepts with exact references to an example prospectus, followed by a section called "Model Builder," in which Allman translates the theory into a fully functioning model for the example deal. Also included is valuable VBA code and detailed explanation that shows proper valuation methods including loan level amortization and full trigger modeling.
Aside from investment analysis this text can help anyone who wants to keep track of the competition, learn from others public transactions, or set up a system to audit one’s own models.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Related to Reverse Engineering Deals on Wall Street with Microsoft Excel
Titles in the series (100)
Business Exit Planning: Options, Value Enhancement, and Transaction Management for Business Owners Rating: 5 out of 5 stars5/5Investment Guarantees: Modeling and Risk Management for Equity-Linked Life Insurance Rating: 3 out of 5 stars3/5Mergers: What Can Go Wrong and How to Prevent It Rating: 0 out of 5 stars0 ratingsEquity Derivatives: Theory and Applications Rating: 0 out of 5 stars0 ratingsAsian Financial Statement Analysis: Detecting Financial Irregularities Rating: 0 out of 5 stars0 ratingsPrivate Equity: History, Governance, and Operations Rating: 0 out of 5 stars0 ratingsManaging Global Financial and Foreign Exchange Rate Risk Rating: 0 out of 5 stars0 ratingsFinancial Modeling Using Excel and VBA Rating: 0 out of 5 stars0 ratingsThe Risk Management Process: Business Strategy and Tactics Rating: 4 out of 5 stars4/5Middle Market M & A: Handbook for Investment Banking and Business Consulting Rating: 4 out of 5 stars4/5Financial Simulation Modeling in Excel: A Step-by-Step Guide Rating: 3 out of 5 stars3/5The Business of Options: Time-Tested Principles and Practices Rating: 0 out of 5 stars0 ratingsQuantitative Methods in Derivatives Pricing: An Introduction to Computational Finance Rating: 2 out of 5 stars2/5Risk Budgeting: Portfolio Problem Solving with Value-at-Risk Rating: 0 out of 5 stars0 ratingsSalomon Smith Barney Guide to Mortgage-Backed and Asset-Backed Securities Rating: 0 out of 5 stars0 ratingsThe Securitization Markets Handbook: Structures and Dynamics of Mortgage- and Asset-backed Securities Rating: 0 out of 5 stars0 ratingsStrategic Corporate Tax Planning Rating: 0 out of 5 stars0 ratingsCredit Risk Measurement: New Approaches to Value at Risk and Other Paradigms Rating: 0 out of 5 stars0 ratingsInvestor's Guide to Loss Recovery: Rights, Mediation, Arbitration, and other Strategies Rating: 0 out of 5 stars0 ratingsReal Estate Market Valuation and Analysis Rating: 0 out of 5 stars0 ratingsPrivate Equity: Transforming Public Stock to Create Value Rating: 0 out of 5 stars0 ratingsInvestment Leadership: Building a Winning Culture for Long-Term Success Rating: 0 out of 5 stars0 ratingsCorporate Governance and Risk: A Systems Approach Rating: 0 out of 5 stars0 ratingsHow to Create and Manage a Hedge Fund: A Professional's Guide Rating: 4 out of 5 stars4/5Absolute Returns: The Risk and Opportunities of Hedge Fund Investing Rating: 4 out of 5 stars4/5Using Economic Indicators to Improve Investment Analysis Rating: 4 out of 5 stars4/5The Portable Financial Analyst: What Practitioners Need to Know Rating: 0 out of 5 stars0 ratingsConvertible Arbitrage: Insights and Techniques for Successful Hedging Rating: 4 out of 5 stars4/5Damodaran on Valuation: Security Analysis for Investment and Corporate Finance Rating: 0 out of 5 stars0 ratingsRisk Transfer: Derivatives in Theory and Practice Rating: 0 out of 5 stars0 ratings
Finance & Money Management For You
Set for Life: An All-Out Approach to Early Financial Freedom Rating: 4 out of 5 stars4/5Good to Great: Why Some Companies Make the Leap...And Others Don't Rating: 4 out of 5 stars4/5The Psychology of Money: Timeless lessons on wealth, greed, and happiness Rating: 5 out of 5 stars5/5The Intelligent Investor, Rev. Ed: The Definitive Book on Value Investing Rating: 4 out of 5 stars4/5The Great Reset: And the War for the World Rating: 4 out of 5 stars4/5Capitalism and Freedom Rating: 4 out of 5 stars4/5Buy, Rehab, Rent, Refinance, Repeat: The BRRRR Rental Property Investment Strategy Made Simple Rating: 5 out of 5 stars5/5Financial Words You Should Know: Over 1,000 Essential Investment, Accounting, Real Estate, and Tax Words Rating: 4 out of 5 stars4/5Principles: Life and Work Rating: 4 out of 5 stars4/5The Richest Man in Babylon Rating: 4 out of 5 stars4/5The Great Awakening: Defeating the Globalists and Launching the Next Great Renaissance Rating: 4 out of 5 stars4/5Just Keep Buying: Proven ways to save money and build your wealth Rating: 5 out of 5 stars5/5Built to Last: Successful Habits of Visionary Companies Rating: 4 out of 5 stars4/5The Book on Advanced Tax Strategies: Cracking the Code for Savvy Real Estate Investors Rating: 4 out of 5 stars4/5The Total Money Makeover by Dave Ramsey: Summary and Analysis Rating: 4 out of 5 stars4/5Wealthology: The Science of Smashing Money Blocks Rating: 3 out of 5 stars3/5The 7 Habits of Highly Effective People: 15th Anniversary Infographics Edition Rating: 5 out of 5 stars5/5The Freedom Shortcut: How Anyone Can Generate True Passive Income Online, Escape the 9-5, and Live Anywhere Rating: 5 out of 5 stars5/5The Tax and Legal Playbook: Game-Changing Solutions To Your Small Business Questions Rating: 3 out of 5 stars3/5Capitalism: A Ghost Story Rating: 4 out of 5 stars4/5How to Make Money in Stocks: A Winning System in Good Times and Bad, Fourth Edition Rating: 5 out of 5 stars5/5All Your Worth: The Ultimate Lifetime Money Plan Rating: 5 out of 5 stars5/5
Reviews for Reverse Engineering Deals on Wall Street with Microsoft Excel
0 ratings0 reviews