Modeling Structured Finance Cash Flows with Microsoft Excel
A Step-by-Step Guide
KEITH A. ALLMAN
The basic idea behind any financial model is to bring order and understanding to the numerous variables and complex information that financial transactions present. Learning to build one from a blank spreadsheet is often a daunting task to newcomers because of the sheer amount of information and nearly infinite methods of manipulating data. This book seeks to bring a systematic, well-explained method to constructing a particularly popular and adaptable type of model—the cash flow model. Through the use of thorough explanation, graphical examples, and the simultaneous application of learned methods featured in the Model Builderexercises, anyone with a background in finance and basic spreadsheet understanding can develop and understand a fully functioning financial model.