Multiple scenarios for a pool of loans
 

I need to put together a spreadsheet that takes into account different
scenarios for a pool of hundreds of loans. These scenarios include figuring
out what happens to a loan when it defaults, when the borrower refinances, or
when the loan is paid off. Since there are literally hundreds of loans
involved, does anyone have a suggestion on how to manage this data? It seems
to me that there would literally be hundreds of permutations and I'm not sure
what the best way is to calculate this large amount of data. Would a macro
be the best? if so, how do I create a macro?

Thanks-
Courtney