Book Description
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.
Customer Reviews:
Good Intro to Cash Flow Modeling.......2007-09-20
Anyone needing to learn how structured finance cash flow models work will benefit from going through this book and building the spreadsheet-based model it describes. It will be faster if you are already good at using Excel for complex modeling or pricing, but there is a fair amount of Excel advice for those who need it. The book models a single pool of mortgages that can be described by weighted average statistics incorporating both prepayment and default scenarios. Great care is taken to make the model flexible in terms of the kinds of mortgages in the pool. On the liability side the model allows for the creation of a single senior class and a sub class with an interest rate swap and a reserve. While very good for learning the cash flow consequences of sequential and pro rata payment waterfalls, this model cannot describe the structures actually issued in the market. The skills learned, however, should allow the reader to build models capable of modeling issued structures.
The writing is clear and the examples are explained well. The flow of cash into and out of the structure is emphasized by clear inputs, cash flow modeling and summary outputs.
Excellent introduction to MBS modeling.......2007-08-13
Keith's book saved me hours of trial-and-error effort with Excel for modeling structured transactions. This book takes a simple, step-by-step approach to help the reader understand the mechanics of building the cash flow model for Mortgage Backed Securities (MBS).
Once you understand the basics of model creation and cash flow, then it is a matter of refining your skills by revere-engineering more MBS transactions out there. You will find all the basic tools to become proficient in that task by following this book.
Excellent Hands-On Introduction to Structured Finance.......2007-06-03
In structured finance, there is a tremendous discrepancy between academic literature and practice. In purporting a generalizable, scientific approach, many textbooks avoid explaining the intracacies of actual structured finance deals. The fundamental issue is that the implicit value of deal transparency required for issuer and investor tends to be overlooked by authors approaching the field from an academic background. Technical pyrotechnics that suit liquid markets fail when fees, interest rates, and other deal specifics are malleable constructs negotiated among a handful of parties. At the same time, basic bond math on an unsegregated pool of loans cannot accurately describe how assets generate cash flows and the risks faced by investors.
MFSC is the *only* book (afaik) that demonstrates how real structured finance pros bridge the void between these 2 common pitfalls made by other structured finance books. For one, the calculations that belie each component of a structured finance deal is integrated into a single model rather than considered separately. Other books may describe how cash flows pay out in a senior-sub structure, but they won't, for example, take the time to step through how funding costs and triggers affect the cash flows. The primary model also gives the user flexibility to stress the model and enables the user to treat the model as a base for all structured finance deals. Through a neatly organized inputs sheet, each component in the primary model described painstakingly anticipates the gamut of variations common to these types of deals.
All this in a book that's easy to follow and a delight to read. Five stars.
Modeling of CMBS.......2007-06-03
Keith's book does an excellent job at helping both new analysts to MD's in understanding modeling of complex master tapes (models). If you need to know how to structure a fixed or floating rate transaction this book will give you key tools to understand, build and read strats, term sheets, and OC data. Many of the functions and formulas that are explained are used in real working models but in additon to that this book explains key concepts in the structured finance world. Unlike other books this book has a much more active learning style and really gets you involved.
I look forward to the day when Keith writes a book focusing on CMBS, I will defintely buy that one also.
TM
CIB
CMBS
Very Good for Professionals.......2007-05-07
The book explains very well the building and works of a very huge excell worsheet, for professionals it will be a great and interesting reading, and sometimes it will be like a great novel, when you can't stop reading
and always want to go to the next chapter before leaving it.
For begineers it will be a little hard to understand the concepts and the meanings of each chapter, but it will help too.
Customer Reviews:
Justin London did it again.......2007-07-19
I highlight two points:
1. The inclusion of Matlab and Excel code in almost all topics of the book.
2. All the content is new and more advanced, there is no recovered topics of his previous book.
Offers prebuilt code for immediate use.......2007-06-29
This book offers prebuilt, modifiable code that you can use for energy, power, weather and many other derivatives applications. The download process is fast and easy. For those who use Matlab, C++, or Excel, there is no competition. A great book with unique content and code.
Excellent resource for coding derivatives.......2007-06-16
This book was my ultimate go-to resource on several financial engineering projects (on the buy side). It covers many different derivatives and provides example MatLab and C++ code that is easy to modify and extend.
The instructions for setup and downloading the code could be more clear, perhaps on a CD.
State of the art derivative modeling book.......2007-04-10
Great book. But the code downloading process is a bit weird. Don't know why they just attach a CD.
Describes the Modelling Procedure and Gives the Code.......2007-02-08
Derivatives are not simple things. It almost seems that complexity was a design goal when they were being set up. In order to determine their real value either today or in the future you almost have to model them on a computer.
This book covers dozens of different types of derivatives, including the common ones and some of the new even more esoteric ones. It talks about the structure of the derivative, and then presents models of them. The models are presented in the most common modelling 'languages' in use today. There is a lot of code involved, but there is not a CD included with the book. Instead, an access code providing a one time download for the code. Note, a one time download. Be sure and save the code quickly and on several media. This procedure allows the models to be updated as needed without regard to the time it takes for the book to move from being written to being published, but if you have a disk crash....
The biggest things this book provides are: first, you get to see what an expert in the field has done, and second, you get the code to run his models on your system, and of course you can modify them if you find some other aspect suits your needs better.
This is a new book, first printed in December 2006, so it is current with the derivatives being marketing at that time.
Average customer rating:
- Excelent book
- I thought I did a review for this book immediately when I received it! It was really good! It's like the best textbook!
- Strongly recommended to practitioner
- Good Cookbook
- Excellent book
|
Financial Modeling - 2nd Edition: Includes CD
Simon Benninga
Manufacturer: The MIT Press
ProductGroup: Book
Binding: Hardcover
 General
| Popular Economics
| Business & Investing
| Subjects
| Books
Public Finance
| Economics
| Business & Investing
| Subjects
| Books
Corporate Finance
| Finance
| Business & Investing
| Subjects
| Books
General
| Business & Investing
| Subjects
| Books
General
| Accounting
| Industries & Professions
| Business & Investing
| Subjects
| Books
General
| Personal Finance
| Software
| Computers & Internet
| Subjects
| Books
General
| Accounting
| Business
| Software
| Computers & Internet
| Subjects
| Books
Excel
| Applications
| Microsoft
| Computers & Internet
| Subjects
| Books
General
| Accounting
| Accounting & Finance
| Professional & Technical
| Subjects
| Books
General
| Finance
| Accounting & Finance
| Professional & Technical
| Subjects
| Books
Software
| Information Systems
| Computer Science & Information Systems
| New & Used Textbooks
| Stores
| Books
General
| Accounting
| Business & Finance
| New & Used Textbooks
| Stores
| Books
General
| Business & Finance
| New & Used Textbooks
| Stores
| Books
Corporate
| Finance
| Business & Finance
| New & Used Textbooks
| Stores
| Books
All Titles
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Business & Investing
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Computers & Internet
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Professional
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Similar Items:
-
Principles of Finance with Excel: Includes CD
-
Advanced modelling in finance using Excel and VBA
-
Investment Valuation: Tools and Techniques for Determining the Value of Any Asset, Second Edition
-
Building Financial Models with Microsoft Excel: A Guide for Business Professionals
-
Valuation: Measuring and Managing the Value of Companies, Fourth Edition
ASIN: 0262024829 |
Book Description
Too often, finance courses stop short of making a connection between textbook finance and the problems of real-world business. Financial Modeling bridges this gap between theory and practice by providing a nuts-and-bolts guide to solving common financial models with spreadsheets. Simon Benninga takes the reader step by step through each model, showing how it can be solved using Microsoft Excel®. In this sense, this is a finance "cookbook," providing recipes with lists of ingredients and instructions.
Areas covered include computation of corporate finance problems, standard portfolio problems, option pricing and applications, and duration and immunization. The second edition contains six new chapters covering financial calculations, cost of capital, value at risk (VaR), real options, early exercise boundaries, and term structure modeling. A new technical chapter contains a potpourri of tips for using Excel®.
Although the reader should know enough about Excel™ to set up a simple spreadsheet, the author explains advanced Excel® techniques used in the book. The book includes chapters dealing with random number generation, data tables, matrix manipulation, and VBA programming. It also comes with a CD-ROM containing Excel® worksheets and solutions to end-of-chapter exercises.
Customer Reviews:
Excelent book.......2007-09-24
Is an excelent book to learn and undertand how to creat financial models in excel.
I strongly recomend it.
Romer iragorri
I thought I did a review for this book immediately when I received it! It was really good! It's like the best textbook!.......2007-09-16
Beninnga states things very clearly.
And the sophistication is great.
No matter what level you are in, it's good for you.
And these knowledge are really useful in real world!
I mean,I'm really gonna keep this book for myself after I finish the degree.
Strongly recommended to practitioner.......2007-09-03
The book has great practical value. It also applies to those who wish to implement financial models in other computing environment than Excel.
Good Cookbook.......2007-08-23
Very good on giving an introduction on many modeling techniques.
Exceptionally recommended for the new babe.
Excellent book.......2007-07-19
All students of finance must have one, It's great, If I'd have had it when I was student oh, I'd save a lot of time, now I'm teacher of finance and I recomend all my students to buy it.
Book Description
This book teaches readers how to build financial models with step-by-step instructions in Excel.
Progressing from simple examples to practical, real-world applications, this book covers the time value of money, valuation, capital budgeting, financial planning, and options and corporate finance.
For financial planners and analysts.
Customer Reviews:
excel modeling.......2006-02-22
I have returned this book more than 2 weeks ago but I have not seen credit on my credit card yet and sent an email while ago, and ask when I will get refunded but nobody really gave me any clear answer.
Missing files.......2005-06-02
The "Live In-class Problems" that are halfway done are only available to instructors. This book can be fully utilized if it is used by a instructor in the class, otherwise, a self learner would not have an access to the required files needed to do the end of chapter exercises.
2nd Edition of Spreadsheet Modeling in Corp Finance.......2004-11-16
This is the 2nd edition of the "Spreadsheet Modeling in Corp Finance" -learn from my mistake and don't buy the old version.
Book Description
It teaches the reader how to build financial models—not templates—with step-by-step instructions in Excel.
Progressing from simple examples to practical, real-world applications, this book covers the time value of money, valuation, capital budgeting, financial planning, and options and corporate finance.
For financial planners and analysts.
Customer Reviews:
Good book.......2005-07-07
Hi,
I just finished the book. It is worth every dollar spent on it. If you are buying, get the second edition because the first is packed with typos.
This book serves two purposes:
1. It teaches you how to use Excel
2. It is a great practical review of corporate finance
and it does a great job in both aspects
The Second Edition is Better.......2004-07-06
Hi, I am Craig W. Holden, author of "Spreadsheet Modeling in Corporate Finance" (the first edition). I just want to let you know that the second edition of this book is now available. It has been retitled as "Excel Modeling in Corporate Finance Book and CD-ROM (2nd Edition)." It includes everything that was in the first edition plus some new content. All of the examples and data have been updated to the present and all known typos have been corrected. The second edition strictly dominates the first edition and I strongly recommend it. Click on my name at the top of the page to locate it. Thanks for your consideration.
Recommended by my Qualitative Methods teacher at NYU.......2003-09-30
Basic use of Excel for accounting methods. 5 stars only because I had to select something.
Excellent learning tool.......2002-07-05
Although intended as a supplement for textbooks used in college level business courses, this book is also valuable to working professionals who deal with financial modeling. Because I am a consultant and project manager I'm going to slant this review towards how my peers will benefit from the book. It's value outside of my narrow scope should be apparent.
First, unlike other books that teach spreadsheet modeling, the spreadsheets that come on the CD ROM are not finished products. Instead the author has chosen spreadsheets that use dynamic charts to illustrate concepts in an interactive manner (drag a control to change the parameters and the chart changes - this is a powerful teaching tool in or out of the classroom).
Second, the book needs to be read in sequence because spreadsheets you build in one chapter are the basis for refinements and added complexity in later chapters. This leads to highly complex spreadsheets, such as the model in chapter 16 (Life-Cycle Financial Planning), which incorporates tax parameters (federal and state levels), benefits analysis and other factors.
In all there are 53 spreadsheets presented in this book, and you build them. The author calls this "active learning" (as opposed to passive learning where you are provided templates), and it is effective because you are the one who builds the models and tools while following the book. Note that this book does NOT purport to teach Excel programming, but how to build models using Excel's basic features and functions.
As a consultant and project manager the parts of this book that were immediately useful to me were: Parts I (Time Value of Money), III (Capital Budgeting) and IV (Financial Planning). In particular, project management requires a thorough understanding of time value of money and capital budgeting, and the chapters in these sections should be read by anyone who is assigned as a project manager. Financial planning, especially from the perspective of IT asset management, is another knowledge area in which IT consultants should be well versed.
The other parts of the book (II Valuation and V Options and Corporate Finance) will be more useful to finance professionals and general business managers. There is a collection of supporting material on the author's web site that augment this book, including spreadsheets that can be downloaded. Another plus for the working professional is the book is fast-paced and, dare I say, engrossing.
Average customer rating:
|
Spreadsheet Modeling in the Fundamentals of Corporate Finance (With CD-ROM)
Craig W. Holden
Manufacturer: Prentice Hall
ProductGroup: Book
Binding: Paperback
Corporate Finance
| Finance
| Business & Investing
| Subjects
| Books
General
| Business & Investing
| Subjects
| Books
General
| Accounting
| Industries & Professions
| Business & Investing
| Subjects
| Books
General
| Accounting
| Accounting & Finance
| Professional & Technical
| Subjects
| Books
General
| Finance
| Accounting & Finance
| Professional & Technical
| Subjects
| Books
ASIN: 0130879495 |
Average customer rating:
|
Financial Modeling Using Lotus 1-2-3: Structured Macro Programming for Business/Book and Disk (Financial Modeling Using Lotus 1-2-3)
Elbert B. Greynolds
Manufacturer: Wordware
ProductGroup: Book
Binding: Hardcover
Corporate Finance
| Finance
| Business & Investing
| Subjects
| Books
General
| Business & Investing
| Subjects
| Books
Management & Leadership
| Business & Investing
| Subjects
| Books
| Business Ethics
| Consolidation & Merger
| Decision-Making & Problem Solving
| Distribution & Warehouse Management
| Industrial
| Information Management
| Leadership
| Management
| Management Science
| Motivational
| Negotiating
| Operations Research
| Planning & Forecasting
| Pricing
| Production & Operations
| Project Management
| Quality Control
| Risk Assessment
| Statistics
| Strategy & Competition
| Systems & Planning
| Systems Analysis
| Teams
| Total Quality Management
| Training
General
| Spreadsheets
| Software
| Computers & Internet
| Subjects
| Books
General
| Software
| Computers & Internet
| Subjects
| Books
ASIN: 1556222432 |
Books:
- Monte Carlo Methods in Financial Engineering (Stochastic Modelling and Applied Probability)
- MP Principles of Auditing and Other Assurance Services with Updated Chapters 5, 6 & 7
- Nothing Down for Women: The Smart Woman's Quick-Start Guide to Real Estate Investing
- Office 2007 All-in-One Desk Reference For Dummies (For Dummies (Computer/Tech))
- Our Sexuality (with CD-ROM, InfoTrac Workbook, and InfoTrac )
- Prentice Hall's Federal Taxation 2007: Individuals (20th Edition) (Prentice Hall's Federal Taxation Individuals)
- Prentice Hall's Federal Taxation 2007: Individuals (20th Edition) (Prentice Hall's Federal Taxation Individuals)
- Pricing and Revenue Optimization
- Principles of Corporate Finance + Student CD + Ethics in Finance PowerWeb + Standard and Poor's (McGraw-Hill/Irwin Series in Finance, Insurance, and Real Est)
- Principles of Corporate Finance + Student CD + Ethics in Finance PowerWeb + Standard and Poor's (McGraw-Hill/Irwin Series in Finance, Insurance, and Real Est)
Books Index
Books Home
Recommended Books
- Bridges Out of Poverty: Strategies for Professionals and Communities
- The Oxford Illustrated History of the Crusades
- Motivation, Agency, and Public Policy: Of Knights and Knaves, Pawns and Queens
- The Are You Being Served
- The Box: How the Shipping Container Made the World Smaller and the World Economy Bigger
- The Other End of the Leash
- The Impact of Innovation and Technology in the Global Marketplace
- Wkg Papers 1/2-Principles of Accounting
- Spectres of Capitalism: A Critique of Current Intellectual Fashions
- The Big Silence: An Abe Lieberman Mystery
Structured Finance Modeling with Object-Oriented VBA (Wiley Finance)
Introduction to Structured Finance (Frank J. Fabozzi Series)
Credit Risk Modeling using Excel and VBA (The Wiley Finance Series)
Collateralized Debt Obligations: Structures and Analysis, 2nd Edition (Wiley Finance)
The Structured Credit Handbook (Wiley Finance)
