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

3.88 avg rating
( 17 ratings by Goodreads )
 
9780470042908: Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide

A practical guide to building fully operational financial cash flow models for structured finance transactions

Structured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to learn as they go. Modeling Structured Finance Cash Flows with Microsoft Excel provides readers with the information they need to build a cash flow model for structured finance and securitization deals. Financial professional Keith Allman explains individual functions and formulas, while also explaining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called "Model Builder," in which Allman translates the theory into functions and formulas.


"synopsis" may belong to another edition of this title.

From the Back Cover:

Praise for Modeling Structured Finance Cash Flows with Microsoft® Excel®

"You can roll up your sleeves, dive into this book, and shortly thereafter, you have a full-blown honest-to- goodness working model of a transaction. This sure beats the old method of slaving at the feet of gurus for years in the hopes that they'll throw you a scrap. It almost feels as though Allman has given away a shortcut through the 'hazing' period of learning, but then I am grateful I have a resource with which to train new analysts or remind myself how some things work."
—Omar Haneef, Global Securitized Markets, Citigroup

"Allman has written a book that reveals to the reader/user a robust framework for using Excel to model structured finance transactions. Both seasoned cash flow modelers and those new to, or curious about, how structured finance transactions are analyzed can benefit from this book."
—Henry Wilson, Bond Insurance Company Analyst

"A powerful, concise, and tiered approach. It's a bedrock foundation to build on for both the art and science of structured finance modeling. An excellent platform from which to leverage your financial knowledge and personal capital."
—William Preinitz, Managing Director, Citigroup

"An essential tool for any credit officer wishing to gain a general or in-depth understanding of cash flow modeling for new or existing deals."
—Joseph B. Keener, Structured Portfolio Management, Citigroup London

Written by industry expert Keith Allman, this well-rounded resource provides detailed guidance on constructing one of today's most adaptable models—the cash flow model. Filled with in-depth insight, expert advice, and illustrative examples, Modeling Structured Finance Cash Flows with Microsoft Excel explains individual functions and formulas, while also examining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called "Model Builder," in which Allman translates the theory into functions and formulas.

By combining specific application instruction with theory, Modeling Structured Finance Cash Flows with Microsoft Excel will teach you skills that can be instantly applied to professional-level modeling.

About the Author:

Keith Allman is currently the principal trainer and founder of Enstruct, a structured finance analytics training company. Previously he was a Vice President at Citigroup in their Global Fixed Income, Structured Finance Division. He has built and reviewed hundreds of models from many different sectors. Allman received his master's degree in international affairs from Columbia University.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Allman, Keith A.
Published by John Wiley and#38; Sons (2007)
ISBN 10: 0470042907 ISBN 13: 9780470042908
New Quantity Available: > 20
Print on Demand
Seller:
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description John Wiley and#38; Sons, 2007. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # IQ-9780470042908

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 63.77
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

2.

Allman, Keith A.
Published by Wiley (2017)
ISBN 10: 0470042907 ISBN 13: 9780470042908
New Paperback Quantity Available: 16
Print on Demand
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Wiley, 2017. Paperback. Book Condition: New. Never used! This item is printed on demand. Bookseller Inventory # 0470042907

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 72.86
Convert Currency

Add to Basket

Shipping: US$ 1.99
Within U.S.A.
Destination, Rates & Speeds

3.

Keith A. Allman
ISBN 10: 0470042907 ISBN 13: 9780470042908
New Quantity Available: 5
Seller:
ReadWhiz
(Portland, OR, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Bookseller Inventory # ria9780470042908_ing

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 75.00
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

4.

Keith A. Allman
Published by John Wiley and Sons Ltd, United Kingdom (2007)
ISBN 10: 0470042907 ISBN 13: 9780470042908
New First Edition Quantity Available: 10
Seller:
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description John Wiley and Sons Ltd, United Kingdom, 2007. CD-ROM. Book Condition: New. 1. Auflage. Language: English . Brand New. A practical guide to building fully operational financial cash flow models for structured finance transactions Structured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to learn as they go. Modeling Structured Finance Cash Flows with Microsoft Excel provides readers with the information they need to build a cash flow model for structured finance and securitization deals. Financial professional Keith Allman explains individual functions and formulas, while also explaining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called Model Builder, in which Allman translates the theory into functions and formulas. In addition, the companion CD-ROM features all of the modeling exercises, as well as a final version of the model that is created in the text. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file. Bookseller Inventory # AAV9780470042908

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 78.65
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

5.

Allman, Keith A.
Published by John Wiley and#38; Sons (2007)
ISBN 10: 0470042907 ISBN 13: 9780470042908
New Quantity Available: > 20
Print on Demand
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description John Wiley and#38; Sons, 2007. PAP. Book Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # IQ-9780470042908

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 66.88
Convert Currency

Add to Basket

Shipping: US$ 12.00
From United Kingdom to U.S.A.
Destination, Rates & Speeds

6.

Allman, Keith A.
Published by Wiley (2007)
ISBN 10: 0470042907 ISBN 13: 9780470042908
New Paperback Quantity Available: 10
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Wiley, 2007. Paperback. Book Condition: New. Bookseller Inventory # INGM9780470042908

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 74.50
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds

7.

Allman, Keith A.
Published by John Wiley & Sons (2016)
ISBN 10: 0470042907 ISBN 13: 9780470042908
New Paperback Quantity Available: 1
Print on Demand
Seller:
Ria Christie Collections
(Uxbridge, United Kingdom)
Rating
[?]

Book Description John Wiley & Sons, 2016. Paperback. Book Condition: New. PRINT ON DEMAND Book; New; Publication Year 2016; Not Signed; Fast Shipping from the UK. No. book. Bookseller Inventory # ria9780470042908_lsuk

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 77.71
Convert Currency

Add to Basket

Shipping: US$ 5.17
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

Keith Allman
Published by John Wiley & Sons
ISBN 10: 0470042907 ISBN 13: 9780470042908
New Paperback Quantity Available: > 20
Seller:
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description John Wiley & Sons. Paperback. Book Condition: New. 224 pages. Dimensions: 9.3in. x 7.5in. x 0.5in.A practical guide to building fully operational financial cash flow models for structured finance transactions Structured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to learn as they go. Modeling Structured Finance Cash Flows with Microsoft Excel provides readers with the information they need to build a cash flow model for structured finance and securitization deals. Financial professional Keith Allman explains individual functions and formulas, while also explaining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called Model Builder, in which Allman translates the theory into functions and formulas. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Bookseller Inventory # 9780470042908

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 83.67
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

9.

Allman, Keith A.
Published by John Wiley and#38; Sons (2007)
ISBN 10: 0470042907 ISBN 13: 9780470042908
New Quantity Available: 4
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description John Wiley and#38; Sons, 2007. PAP. Book Condition: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Bookseller Inventory # FW-9780470042908

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 76.56
Convert Currency

Add to Basket

Shipping: US$ 12.00
From United Kingdom to U.S.A.
Destination, Rates & Speeds

10.

Allman, Keith A.
Published by Wiley
ISBN 10: 0470042907 ISBN 13: 9780470042908
New PAPERBACK Quantity Available: 1
Seller:
Cloud 9 Books
(Wellington, FL, U.S.A.)
Rating
[?]

Book Description Wiley. PAPERBACK. Book Condition: New. 0470042907 New Condition. Bookseller Inventory # NEW7.0175098

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 87.50
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book