Modeling Structured Finance Cash Flows with Microsoft Excel
  • Author : Keith A. Allman
  • Release Date : 28 December 2010
  • Publisher : John Wiley & Sons
  • Genre : Business & Economics
  • Pages : 199
  • ISBN 13 : 1118044665
Ratings: 4
From 1 Voters
Get This Book

Modeling Structured Finance Cash Flows with Microsoft Excel Book Summary

A practical guide to building fully operational financial cash flow models for structured finance transactions Structured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to learn as they go. Modeling Structured Finance Cash Flows with Microsoft Excel provides readers with the information they need to build a cash flow model for structured finance and securitization deals. Financial professional Keith Allman explains individual functions and formulas, while also explaining 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 website features all of the modeling exercises, as well as a final version of the model that is created in the text. Note: Companion website and other supplementary materials are not included as part of eBook file.

Modeling Structured Finance Cash Flows with Microsoft Excel

Modeling Structured Finance Cash Flows with Microsoft Excel

Author : Keith A. Allman
Publisher : John Wiley & Sons
Genre : Business & Economics
Total View : 1255 Views
File Size : 51,9 Mb
Get Book

A practical guide to building fully operational financial cash flow models for structured finance transactions Structured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to ...

Intermediate Structured Finance Modeling

Intermediate Structured Finance Modeling

Author : William Preinitz,Matthew Niedermaier
Publisher : John Wiley & Sons
Genre : Business & Economics
Total View : 3868 Views
File Size : 45,9 Mb
Get Book

This book provides a pragmatic, hands-on approach to reaching an intermediate level of sophistication as a financial modeler. Expanding on the first book, A Fast Tract to Structured Finance Modeling, Monitoring, and Valuation, the book will guide you step-by-step through using learned principals in new and more powerful applications. These ...

Structured Finance Modeling with Object Oriented VBA

Structured Finance Modeling with Object Oriented VBA

Author : Evan Tick
Publisher : John Wiley & Sons
Genre : Business & Economics
Total View : 5951 Views
File Size : 46,8 Mb
Get Book

A detailed look at how object-oriented VBA should be used to model complex financial structures This guide helps readers overcome the difficult task of modeling complex financial structures and bridges the gap between professional C++/Java programmers writing production models and front-office analysts building Excel spreadsheet models. It reveals how ...

Financial Simulation Modeling in Excel

Financial Simulation Modeling in Excel

Author : Keith A. Allman,Josh Laurito,Michael Loh
Publisher : John Wiley & Sons
Genre : Business & Economics
Total View : 6886 Views
File Size : 47,6 Mb
Get Book

"I've worked with simulation in business for over 20 years, andAllman really nails it with this book. I admit that I own hisprevious book on structured finance cash flows, but I was surprisedby what I found in here. He addresses the fundamental questions ofhow decision makers react to simulations and his ...

Reverse Engineering Deals on Wall Street with Microsoft Excel

Reverse Engineering Deals on Wall Street with Microsoft Excel

Author : Keith A. Allman
Publisher : John Wiley & Sons
Genre : Business & Economics
Total View : 3280 Views
File Size : 52,8 Mb
Get Book

A serious source of information for those looking to reverse engineer business deals 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 ...

A Fast Track to Structured Finance Modeling  Monitoring  and Valuation

A Fast Track to Structured Finance Modeling Monitoring and Valuation

Author : William Preinitz
Publisher : John Wiley & Sons
Genre : Business & Economics
Total View : 219 Views
File Size : 49,6 Mb
Get Book

This book is designed to start with simple examples that progressively develop the reader's confidence to take on more complex tasks. There is very little theoretical discussion about computer science, operations research algorithms, mathematics, or finance. The thrust of the book is to teach the reader to break complex tasks ...

Hands On Financial Modeling with Microsoft Excel 2019

Hands On Financial Modeling with Microsoft Excel 2019

Author : Shmuel Oluwa
Publisher : Packt Publishing Ltd
Genre : Computers
Total View : 1899 Views
File Size : 52,9 Mb
Get Book

Explore the aspects of financial modeling with the help of clear and easy-to-follow instructions and a variety of Excel features, functions, and productivity tips Key FeaturesA non data professionals guide to exploring Excel's financial functions and pivot tablesLearn to prepare various models for income and cash flow statements, and balance ...

Financial Modeling in Excel For Dummies

Financial Modeling in Excel For Dummies

Author : Danielle Stein Fairhurst
Publisher : John Wiley & Sons
Genre : Computers
Total View : 6385 Views
File Size : 51,5 Mb
Get Book

Turn your financial data into insightful decisions with this straightforward guide to financial modeling with Excel Interested in learning how to build practical financial models and forecasts but concerned that you don’t have the math skills or technical know-how? We’ve got you covered! Financial decision-making has never been ...