Modeling Structured Finance Cash Flows With Microsoft Excel + Website: A Step-By-Step Guide 9780470042908 pdf mobi txt 2024 电子版 下载

　　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 CD-ROM features all of the

modeling exercises, as well as a final version of the model that is

created in the text.

Note: CD-ROM/DVD and other supplementary materials are not

included as part of eBook file

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

. Dates and Timing. Time Progression. Dates and Timing on the

Inputs Sheet. Day-Count Systems:

0/360 versus Actual/360 versus Actual/365. Model Builder

.1: Inputs Sheet-Dates and Timing. Dates and Timing on the Cash

Flow Sheet. Model Builder

.2: Cash Flow Sheet-Dates and Timing. Toolbox. Naming Cells and

Ranges. Data Validation Lists. EDATE. CHAPTER

. Asset Cash Flow Generation. Loan Level versus Representative Line

Amortization. How Asset Generation Is Demonstrated in Model

Builder. Asset Generation on the Inputs Sheet. Fixed Rate

Amortization Inputs. Floating Rate Amortization Inputs. Model

Builder

.1: Inputs Sheet Asset Assumptions and the Vectors Sheet. Asset

Generation on the Cash Flow Sheet. Model Builder

.2: Notional Asset Amortization on the Cash Flow Sheet. Toolbox.

OFFSET. MATCH. MOD. PMT. CHAPTER

. Prepayments. How Prepayments Are Tracked. SMM: Single Monthly

Mortality. CPR: Conditional Prepayment Rate. PSA: Public Securities

Association. ABS: Absolute Prepayment Speed. Historical Prepayment

Data Formats. Building Prepayment Curves. Prepayment Curves in

Project Model Builder. The Effect of Prepayments on Structured

Transactions. Model Builder

.1: Historical Prepayment Analysis and Creating a Projected

Prepayment Curve. Model Builder

.2: Integrating Projected Prepayments in Asset Amortization.

Toolbox. Weighted Averages Using SUMPRODUCT and SUM. CHAPTER

. Delinquency, Default, and Loss Analysis. Delinquencies versus

Defaults versus Loss. The Importance of Analyzing Delinquency.

Model Builder

.1: Building Historical Delinquency Curves. Deriving Historical

Loss Curves. Model Builder

.2: Building Historical and Projected Loss Curves. Analyzing

Historical Loss Curves. Model Builder

.2 Continued. Projecting Loss Curves. Model Builder

.2 Continued. Integrating Loss Projections. The Effects of

Seasoning and Default Timing. Model Builder

.3: Integrating Defaults in Asset Amortization. CHAPTER

. Recoveries. Model Builder

.1: Historical Recovery Analysis. Projecting Recoveries in a Cash

Flow Model. Model Builder

.2: Integrating Recoveries into Project Model Builder. Final Points

Regarding Recoveries. CHAPTER

. Liabilities and the Cash Flow Waterfall. Priority of Payments and

the Cash Flow Waterfall. The Movement of Cash for an Individual

Liability. Types of Liabilities. Fees. Model Builder

.1: Calculating Fees in the Waterfall. Interest. Model

Builder

.2: Calculating Interest in the Waterfall. Principal. Model

Builder

.3: Calculating Principal in the Waterfall. Understanding Basic

Asset and Liability Interactions. CHAPTER

. Advanced Liability Structures: Triggers, Interest Rate Swaps, and

Reserve Accounts. Triggers and Their Affect on the Liability

Structure. Model Builder

.1: Incorporating Triggers. Swaps. Model Builder

.2: Incorporating a Basic Interest Rate Swap. Final Notes on Swaps.

Reserve Accounts. Model Builder

.3: Incorporating a Cash-Funded Reserve Account. Conclusion of the

Cash Flow Waterfall. Toolbox. AND and OR. CHAPTER

. Analytics and Output Reporting. Internal Testing. Cash In versus

Cash Out. Model Builder

.1: Cash In versus Cash Out Test. Balances at Maturity. Model

Builder

.2: Balances at Maturity Tests. Asset Principal Check. Model

Builder

.3: Asset Principal Check Test. Performance Analytics. Monthly

Yield. Model Builder

.4: Calculating Monthly Yield. Calculating the Monthly Yield.

Bond-Equivalent Yield. Model Builder

.5: Calculating Bond-Equivalent Yield. Modified Duration. Model

Builder

.6: Calculating Modified Duration. Output Reporting. Model

Builder

.7: Creating the Output Report. The Importance of Testing and

Output. Toolbox. Conditional Formatting. Goal Seek. Array Formulas.

CHAPTER

. Understanding the Model. The Complete Model in Review.

Understanding the Effects of Increased Loss. Varying Principal

Allocation Methodologies. Varying Prepayment Rates. Varying Loss

Timing. Varying Recovery Rate and Lag. The Value of a Swap.

Additional Testing. CHAPTER

0. Automation Using Visual Basic Applications (VBA). Conventions of

This Chapter. The Visual Basic Editor. The Menu Bar. The Project

Explorer and the Properties Window. VBA Code. Simple Automation for

Printing and Goal Seek. Model Builder

0.1: Automating Print Procedures. Model Builder

0.2: Automating Goal Seek to Optimize Advance Rates. Understanding

Looping to Automate the Analytics Sheet. Model Builder

0.3: Automating Goal Seek to Perform Transaction Analytics.

Automated Scenario Generation. Model Builder

0.4: Creating a Transaction Scenario Generator. Working with Macros

in Excel. CHAPTER

1. Conclusion. The Investment Banker's Perspective. The Investor's

Perspective. The Issuer's Perspective. The Financial Guarantor's

Perspective. The Big Picture Perspective. Appendix: Using This Book

with Excel

007. About the CD-ROM. Index.

　　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.

暂无出版社相关信息，正在全力查找中！

暂无相关书籍摘录，正在全力查找中！

在线阅读地址：Modeling Structured Finance Cash Flows With Microsoft Excel + Website: A Step-By-Step Guide 9780470042908在线阅读

在线听书地址：Modeling Structured Finance Cash Flows With Microsoft Excel + Website: A Step-By-Step Guide 9780470042908在线收听

在线购买地址：Modeling Structured Finance Cash Flows With Microsoft Excel + Website: A Step-By-Step Guide 9780470042908在线购买

暂无原文赏析，正在全力查找中！

暂无其它内容！

• 作者：Aug 发布时间：2022-10-26 09:26:46

  一本短篇集，比较散，还有很多重复的文章，虽然放在不同主题下，可能是作者集合了一下他写过的单篇文章出版的，从一个食品从业者的角度谈论食品工业，有两个比较突出的特点，不谈食品添加剂色变，而是跟添加剂含量有关；从科学的角度看天然食品，并不是天然就是好的，加工食品就是不营养安全的

• 作者：Abby贝安 发布时间：2022-11-13 19:37:47

  看不懂

• 作者：欣欣 ♥ 虫子 发布时间：2022-06-05 11:40:05

  从初出茅庐开始讲起，对比意甲、英超、法甲、西甲四支球队的经历，带有对带队思路、战术理念的分享。战术性极强，尤其是最后10场经典比赛的分享。

• 作者：笑面鬼 发布时间：2021-01-20 17:48:45

  这是一本安慰之书，对没有走出社会或者对社会体会不深的人是有用的，收获一点平静，减少一些迷茫，感觉更像是这个时代的快餐产物，它抓住了一部分人的心里，如同鸡汤文一直有市场。

• 作者：小 明 子 发布时间：2011-08-04 00:18:06

  广告太多了，不过启发还是蛮大的

• 作者：renard dit 发布时间：2023-05-20 09:32:53

  有教材的即视感，很细也努力在理出线条，但看过的中国美术史几本都按朝代整理，下设书画，工艺等主题，想再找找看有没有其他可能。话说近期这类主题的书多了很多啊

• 读慕尔如星的一些感受

  作者：隆美尔 发布时间：2023-09-29 11:29:09

  当你无条件的对一个觉得亏欠的人付出的时候，对方有时不会因此而感动反而会更加瞧不上你。如果感动的话他早就原谅你了，这个过程不会持续很长时间。而陆年到最后都没有原谅岁岁，像这种情况岁岁就应该放弃了。

  这个故事表面是讲男生女生的青春心事，实则是告诉我们有些事情即使付出的再多也是无法弥补的。

  原生态家庭对于一个人性格的影响很大。岁岁从小受父母宠爱，在一个充满爱的家庭长大，当她失去双亲的时候一直社会中寻找爱感受爱接受爱，她待人充满爱，也希望能得到爱。而陆年从小性情冷淡，与他单亲家庭不无关系，这点从他与继父的对话中也能看出。当他失去母亲的时候内心并没有太大的波动。

  岁岁待人真诚，也希望对方能真诚待她。而陆年不想与人亲近，也不希望被人打扰。这样的两个人相处性格是完全合不来的，双方在一起都会感到痛苦与疲惫，所以发生这些事情也合情合理。如果两个人真走到一起，岁岁需要做出很大的牺牲。

• 记得02年的时候国内也出过一本正版

  作者：二力 发布时间：2008-10-01 22:19:59

  RBT SD的原画集 当时有正式授权 还有对井上的采访

  但是书外还有一个盒子包装

  有没有人知道 这本和以前的那本有什么区别？