Modeling Structured Finance Cash Flows With Microsoft Excel

During my first analytics position after graduate school, I asked a vice president at our company what the best way was to learn how his group modelled transactions. He answered with a grin: ‘‘Trial by fire.’’ From that point on, I could not have counted the gray hairs that I developed trying to figure out the most precise and efficient method of modelling a transaction.