登入帳戶  | 訂單查詢  | 購物車/收銀台(0) | 在線留言板  | 付款方式  | 聯絡我們  | 運費計算  | 幫助中心 |  加入書簽
會員登入 新註冊 | 新用戶登記
HOME新書上架暢銷書架好書推介特價區會員書架精選月讀2023年度TOP分類閱讀雜誌 香港/國際用戶
最新/最熱/最齊全的簡體書網 品種:超過100萬種書,正品正价,放心網購,悭钱省心 送貨:速遞 / EMS,時效:出貨後2-3日

2024年10月出版新書

2024年09月出版新書

2024年08月出版新書

2024年07月出版新書

2024年06月出版新書

2024年05月出版新書

2024年04月出版新書

2024年03月出版新書

2024年02月出版新書

2024年01月出版新書

2023年12月出版新書

2023年11月出版新書

2023年10月出版新書

2023年09月出版新書

『英文書』Modeling Structured Finance Cash Flows With Microsoft Excel + Website: A Step-By-Step Guide 9780470042908

書城自編碼: 2090016
分類: 簡體書→原版英文書
作者: Keith
國際書號(ISBN): 9780470042908
出版社: Wiley
出版日期: 2007-02-01
版次: 1 印次: 1
頁數/字數: 109/
書度/開本: 大16开 釘裝: 平装

售價:NT$ 4008

我要買

share:

** 我創建的書架 **
未登入.



新書推薦:
天下的当代性:世界秩序的实践与想象(新版)
《 天下的当代性:世界秩序的实践与想象(新版) 》

售價:NT$ 352.0
德国天才4:断裂与承续
《 德国天才4:断裂与承续 》

售價:NT$ 500.0
妈妈的情绪,决定孩子的未来
《 妈妈的情绪,决定孩子的未来 》

售價:NT$ 194.0
推拿纲目
《 推拿纲目 》

售價:NT$ 1836.0
精致考古--山东大学实验室考古项目论文集(一)
《 精致考古--山东大学实验室考古项目论文集(一) 》

售價:NT$ 1112.0
从天下到世界——国际法与晚清中国的主权意识
《 从天下到世界——国际法与晚清中国的主权意识 》

售價:NT$ 347.0
血色帝国:近代英国社会与美洲移民
《 血色帝国:近代英国社会与美洲移民 》

售價:NT$ 265.0
海外中国研究·王羲之:六朝贵族的世界(艺术系列)
《 海外中国研究·王羲之:六朝贵族的世界(艺术系列) 》

售價:NT$ 811.0

內容簡介:
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-ROMDVD and other supplementary materials are not
included as part of eBook file
關於作者:
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.
目錄
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:
0360 versus Actual360 versus Actual365. 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.

 

 

書城介紹  | 合作申請 | 索要書目  | 新手入門 | 聯絡方式  | 幫助中心 | 找書說明  | 送貨方式 | 付款方式 香港用户  | 台灣用户 | 海外用户
megBook.com.tw
Copyright (C) 2013 - 2024 (香港)大書城有限公司 All Rights Reserved.