Modeling Structured Finance Cash Flows with Microsoft Excel
180 USING THIS BOOK WITH EXCEL 2007 Overall, the difference between Excel 2007 and earlier versions will have no impact on the f ...
Using This Book with Excel 2007 181 FIGURE A.2 Location of Data Validation on the Data tab. 3.On the Settings tab and under Vali ...
182 USING THIS BOOK WITH EXCEL 2007 FIGURE A.4 Click Conditional Formatting button to access option menus. Excel 2007 has greatl ...
Using This Book with Excel 2007 183 FIGURE A.5 The New Formatting Rule dialog box allows you to create custom conditional cell f ...
184 USING THIS BOOK WITH EXCEL 2007 FIGURE A.6 The Defined Names group controls on the Formula tab. Adding Worksheets Excel 2007 ...
Using This Book with Excel 2007 185 Goal Seek Tool To use the Goal Seek function in Excel 2007, click the Data tab and then clic ...
186 USING THIS BOOK WITH EXCEL 2007 FIGURE A.9 Excel Options dialog box allows you access to Excel Add-Ins and other Excel appli ...
Using This Book with Excel 2007 187 FIGURE A.11 Click in the Show Developer tab in the Ribbon checkbox select this option and ac ...
...
About the CD-ROM INTRODUCTION This appendix provides you with information on the contents of the CD that accompanies this book. ...
190 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL USING THE CD WITH WINDOWS To install the items from the CD to yo ...
About the CD-ROM 191 call (317) 572 – 3994. You can also contact Wiley Product Technical Support at http://support.wiley.com. Jo ...
...
Index Absolute prepayment speed (ABS), 45 Action buttons, 6 Actual/actual day-count system, 11 – 12 Actual/360 day-count system, ...
194 INDEX Cash Flow sheet cash flow waterfall, 90, 94, 96 – 99 characteristics of, 6 dates and timing, 14 – 18 interest rate swa ...
Index 195 EDATE, 14, 16, 21 Eligibility criteria, 26 – 27 Emerging market remittances, 1 Ending balance, loss curves, 82 Ending ...
196 INDEX Interest rate swap characteristics of, 113 – 114, 153 incorporating, 114 – 117 Internal testing asset principal tests, ...
Index 197 New loans, loss curves and, 75 – 76 90-day delinquency, 60 Nonperforming loan (NPL) groups, 88 Notional amortization, ...
198 INDEX Recovery rate, 6, 83, 86 – 87, 152 – 153 Refinancing, 24, 26, 43 Reimbursement, reserve accounts, 4, 118, 120 – 121 Re ...
Index 199 weighted average using SUMPRODUCT and SUM, 5 – 57 Total returns, 48 Tranches, 89, 100.See also specific types of tranc ...
«
3
4
5
6
7
8
9
10
11
12
»
Free download pdf