32 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL
FIGURE 2.7 The new Vectors sheet should include basic timing and rate
information at this point.
FIGURE 2.8 The Notional Amortization schedule is created on
the Cash Flow sheet.
16.Cell M12 contains the Lifetime Cap, which is the absolute maximum that the
interest rate can increase to. Just as the Periodic Rate Cap/Floor enter100%for
now so it is basically deactivated. Name this cellAssetLifeCap1.
17.Cell N12 contains the Lifetime Floor, which is the absolute maximum that the
interest rate can decrease to. This will be deactivated now by entering0%.
Name this cellAssetLifeFloor1.
18.The last cell of this section, cell O12, contains a numeric value that represents
the frequency that the rate changes or resets. Depending on the type of rate, there
