In your table, you may want to hide many of the rows and some of the columns. Do keep columns for period, balance, interest, scheduled principal, cumulative default loss, cumulative default rates, and cash flow. Using the program, find the following:

a. The cumulative default losses and default rates as a proportion of the principal for SDAs of 100, 200, and 300.

b. The cumulative default rates after months 30, 60, 120, and 360 for SDAs of 100, 200, and 300.