Modeling Structured Finance Cash Flows with Microsoft® Excel®: A Step-by-Step Guide

About the Author

Keith Allman is currently a vice president in the Global Special Situations Group at Citigroup, where he focuses on emerging market analysis. He has created, audited, and used hundreds of cash flow models for mortgages, autos, equipment leases, credit cards, project finance, and multiple esoterics. Prior to his current role, he worked in the Structured Finance group at Citigroup modeling transactions for their conduits. Mr. Allman began his career in finance at MBIA, Inc., a leading financial guarantor, where he was a senior analyst in its quantitative analytics group. Outside of corporate work, Mr. Allman has written computer curriculum and provides instruction for low-income individuals through Streetwise Partners. His education includes a master’s degree in international affairs with a concentration in finance and banking from Columbia University and bachelor degrees in political science and psychology from UCLA.