Modeling Structured Finance Cash Flows with Microsoft Excel

140 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL beginning balances of the assets for the periods used in the sna ...

Analytics and Output Reporting 141 To use conditional formatting, select the desired cell, clickFormaton the menu bar and then c ...

142 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL FIGURE 8.12 Enter the cell references in the Goal Seek dialog bo ...

Analytics and Output Reporting 143 There are two important rules to remember when using an array function. Any arrays referenced ...

...

CHAPTER 9 Understanding the Model E ach individual chapter has focused on explaining one concept of a structured finance model a ...

146 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL FIGURE 9.1 In structured transactions cash is typically created ...

Understanding the Model 147 means that if there is ever an interest shortfall during the transaction or a principal shortfall at ...

148 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL FIGURE 9.2 Change the assumptions to produce a very stressful lo ...

Understanding the Model 149 created by the loss. Also, go to the reserve account section (columns BG through BL) on the Cash Flo ...

150 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL FIGURE 9.4 The Goal Seek tool can be used to find the optimal ad ...

Understanding the Model 151 on the Cash Flow sheet calculates the senior principal due amount as everything that is remaining (A ...

152 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL Varying Loss Timing Project Model Builder was built with five po ...

Understanding the Model 153 The Value of a Swap Project Model Builder was created with a swap in place that fixed the liabilitie ...

...

CHAPTER 10 Automation Using Visual Basic Applications (VBA) A powerful capability of all Microsoft Office applications is the ab ...

156 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL The Visual Basic Editor Coding in VBA is simplified by an interf ...

Automation Using Visual Basic Applications (VBA) 157 FIGURE 10.2 The Standard Toolbar looks similar to other Office Toolbars, bu ...

158 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL the three elements mentioned above will greatly aid a reader in ...

Automation Using Visual Basic Applications (VBA) 159 FIGURE 10.4 The Properties window changes the characteristics of items in t ...