Bücher Wenner
Wer wird Cosplay Millionär?
29.11.2024 um 19:30 Uhr
Modeling Structured Finance Cash Flows with Microsoft Excel
A Step-By-Step Guide
von Keith A Allman
Verlag: Wiley
Hardcover
ISBN: 978-0-470-04290-8
Erschienen am 01.02.2007
Sprache: Englisch
Format: 235 mm [H] x 191 mm [B] x 12 mm [T]
Gewicht: 417 Gramm
Umfang: 224 Seiten

Preis: 94,00 €
keine Versandkosten (Inland)


Jetzt bestellen und voraussichtlich ab dem 19. Oktober in der Buchhandlung abholen.

Der Versand innerhalb der Stadt erfolgt in Regel am gleichen Tag.
Der Versand nach außerhalb dauert mit Post/DHL meistens 1-2 Tage.

klimaneutral
Der Verlag produziert nach eigener Angabe noch nicht klimaneutral bzw. kompensiert die CO2-Emissionen aus der Produktion nicht. Daher übernehmen wir diese Kompensation durch finanzielle Förderung entsprechender Projekte. Mehr Details finden Sie in unserer Klimabilanz.
Biografische Anmerkung
Klappentext
Inhaltsverzeichnis

Keith Allman is currently the principal trainer and founder of Enstruct, a structured finance analytics training company. Previously he was a Vice President at Citigroup in their Global Fixed Income, Structured Finance Division. He has built and reviewed hundreds of models from many different sectors. Allman received his master's degree in international affairs from Columbia University.



Praise for Modeling Structured Finance Cash Flows with Microsoft(r) Excel(r)
"You can roll up your sleeves, dive into this book, and shortly thereafter, you have a full-blown honest-to- goodness working model of a transaction. This sure beats the old method of slaving at the feet of gurus for years in the hopes that they'll throw you a scrap. It almost feels as though Allman has given away a shortcut through the 'hazing' period of learning, but then I am grateful I have a resource with which to train new analysts or remind myself how some things work."
-Omar Haneef, Global Securitized Markets, Citigroup
"Allman has written a book that reveals to the reader/user a robust framework for using Excel to model structured finance transactions. Both seasoned cash flow modelers and those new to, or curious about, how structured finance transactions are analyzed can benefit from this book."
-Henry Wilson, Bond Insurance Company Analyst
"A powerful, concise, and tiered approach. It's a bedrock foundation to build on for both the art and science of structured finance modeling. An excellent platform from which to leverage your financial knowledge and personal capital."
-William Preinitz, Managing Director, Citigroup
"An essential tool for any credit officer wishing to gain a general or in-depth understanding of cash flow modeling for new or existing deals."
-Joseph B. Keener, Structured Portfolio Management, Citigroup London
Written by industry expert Keith Allman, this well-rounded resource provides detailed guidance on constructing one of today's most adaptable models-the cash flow model. Filled with in-depth insight, expert advice, and illustrative examples, Modeling Structured Finance Cash Flows with Microsoft Excel explains individual functions and formulas, while also examining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called "Model Builder," in which Allman translates the theory into functions and formulas. In addition, the companion CD-ROM features all of the modeling exercises, as well as a final version of the model that is created in the text.
By combining specific application instruction with theory, Modeling Structured Finance Cash Flows with Microsoft Excel will teach you skills that can be instantly applied to professional-level modeling.



Preface.
Acknowledgments.
About the Author.
Introduction.
The Three Basic Elements of a Cash Flow Model.
Inputs.
Cash Flow Structure.
Outputs.
The Process of Building a Cash Flow Model.
Plan and Design.
Obtain All Necessary Information.
Construct Basic Framework.
Develop Advanced Structure.
Validate Assumptions.
Test Model.
How This Book Is Designed.
CHAPTER 1. Dates and Timing.
CHAPTER 2. Asset Cash Flow Generation.
CHAPTER 3. Prepayments.
CHAPTER 4. Delinquency, Default, and Loss Analysis.
CHAPTER 5. Recoveries.
CHAPTER 6. Liabilities and the Cash Flow Waterfall.
CHAPTER 7. Advanced Liability Structures: Triggers, Interest Rate Swaps, and Reserve Accounts.
CHAPTER 8. Analytics and Output Reporting.
CHAPTER 9. Understanding the Model.
CHAPTER 10. Automation Using Visual Basic Applications (VBA).
CHAPTER 11. Conclusion.
Appendix: Using This Book with Excel 2007.
About the CD-ROM.
Index.


andere Formate