Modeling Structured Finance Cash Flows with Microsoft Excel

160 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL FIGURE 10.5 The Button function on the Form Toolbar is often use ...

Automation Using Visual Basic Applications (VBA) 161 ActiveWindow.SelectedSheets.PrintOut Copies: = 1, Collate: = True Sheets("I ...

162 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL becomes clear when the range names on the Excel sheet are change ...

Automation Using Visual Basic Applications (VBA) 163 FIGURE 10.7 Assigning values is an important partof coding for financial ap ...

164 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL all of the calculations in the model, and finally the model shou ...

Automation Using Visual Basic Applications (VBA) 165 and liabilities. This was done using a goal seek on row 6 of the Analytics ...

166 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL flows for the assets and two tranches of debt, so three loops ar ...

Automation Using Visual Basic Applications (VBA) 167 Model Builder 10.3 Final Code: Sub SolveYield() Application.StatusBar="Solv ...

168 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL Scenario. Cells C36 through E36 are the labels for assumptions t ...

Automation Using Visual Basic Applications (VBA) 169 Similar loops must be created to get parts of an array out of VBA and onto ...

170 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL Call SolveAdvance The Call command runs the subroutine that foll ...

Automation Using Visual Basic Applications (VBA) 171 Application.ScreenUpdating = True Application.StatusBar = False End Sub Ins ...

172 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL Dim Scen1Option As String, Scen2Option As String, Scen3Option As ...

Automation Using Visual Basic Applications (VBA) 173 If Left(VBAwksht.Name, 11) = "Scen Output" Then VBAwksht.Delete End If Next ...

...

CHAPTER 11 Conclusion T he best financial modelers understand both technical methodologies and business concepts. One without th ...

176 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL securities. A bank selling a transaction intothe capital markets ...

Conclusion 177 The Financial Guarantor’s Perspective A market participant that is also concerned with structured finance modelin ...

...

APPENDIX Using This Book with Excel 2007 The upcoming release of Microsoft Excel 2007 has a number of improvements that make fin ...