Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide (Wiley Finance)

Automating Print Procedures Model Builder Using This Book with Excel Index Author Information Keith Allman is currently the principal trainer and founder of Enstruct, a structured finance analytics training company. He has built and reviewed hundreds of models from many different sectors. Allman received his master's degree in international affairs from Columbia University.

Corporate Governance Best Practices: Financial Accounting as a Second Language. Simplified Design of Concrete Structures, 8th Edition. Process, Strategies, and Contracts, 2nd Edition. Anatomy and Physiology for the Manual Therapies. The Effects of Seasoning and Default Timing. Integrating Defaults in Asset Amortization. Projecting Recoveries in a Cash Flow Model.

• Modeling structured finance cash flows with Microsoft Excel : a step-by-step guide - JH Libraries;
• Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide;
• The Killings.
• Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide.

Integrating Recoveries into Project Model Builder. Final Points Regarding Recoveries.

Join Kobo & start eReading today

Liabilities and the Cash Flow Waterfall. Priority of Payments and the Cash Flow Waterfall. The Movement of Cash for an Individual Liability. Calculating Fees in the Waterfall. Calculating Interest in the Waterfall. Calculating Principal in the Waterfall. Understanding Basic Asset and Liability Interactions. Triggers and Their Affect on the Liability Structure.

Incorporating a Basic Interest Rate Swap. Final Notes on Swaps. Incorporating a Cash-Funded Reserve Account. Conclusion of the Cash Flow Waterfall. Analytics and Output Reporting. Cash In versus Cash Out. Cash In versus Cash Out Test.

Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide | Souq - UAE

Balances at Maturity Tests. Asset Principal Check Test. Calculating the Monthly Yield.

Creating the Output Report. The Importance of Testing and Output. The Complete Model in Review. Understanding the Effects of Increased Loss. Varying Principal Allocation Methodologies. Varying Recovery Rate and Lag. The Value of a Swap.

Conventions of This Chapter. The Visual Basic Editor. The Project Explorer and the Properties Window. Simple Automation for Printing and Goal Seek. Understanding Looping to Automate the Analytics Sheet. Creating a Transaction Scenario Generator. Working with Macros in Excel. The site itself redirected to a Wiley knock-off site with a. Be careful and don't use this link.

However, as he did for other users here, I contacted the author and he sent over the correct materials very promptly. The book itself is a good intro, and the longer book by his former coworker W. Preinitz is a lengthier look at the same concepts.

I think Keith's approach to this is excellent. I have been involved in creating Structured Finance models for over 20 years and Keith has managed to simplify the explanation into a very readable yet explicit set of rules and objectives and provides templates that show very simply "how to do it". It will take a little while to implement for the average reader's pet project but the disciplines and results will be worth the effort.

What is Kobo Super Points?

Best book on the subject yet - Excellent. This is a great book.

What this book does is give you the how-to of working a model in excel, step by step, formula by formula. Personally, I think it serves its purpose, helping you discover new ways of doing things in Excel, and once you master those ways, you can apply them to new financial structures or projects. Also, Keith Allman, the author, has a serious compromise and has responded to emails about doubts in the past, very quickly.

If you want to get a real starter and intermediate training in structured finance, this is the book for you. We will send you an SMS containing a verification code.