1.

Record Nr.

UNINA9910141138203321

Autore

Preinitz William <1950->

Titolo

Intermediate structured finance modeling : everaging excel, VBA, access, and powerpoint / / William Preinitz with Matthew Niedermaier

Pubbl/distr/stampa

Hoboken, New Jersey : , : John Wiley & Sons, Inc., , 2011

©2011

ISBN

1-119-19984-0

0-470-92875-1

0-470-92878-6

Descrizione fisica

1 online resource (1984 p.)

Collana

Wiley Finance

Disciplina

332.015195

332.0285/5133

Soggetti

Finance - Computer simulation

Finance - Mathematical models

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Includes indexes.

Nota di contenuto

Cover; Series; Title Page; Copyright; Dedication; Preface; GOALS OF THE BOOK; WHAT YOU SHOULD KNOW; SETTING THE CONTEXT FOR LEARNING; THE STRUCTURE OF THE BOOK; A FISH STORY; A PERSPECTIVE ON MODELING; APPROACHING THIS MATERIAL; STYLE; A PARTING REMARK; On the Web Site; OVERVIEW; Acknowledgments; Part One: First Steps; Chapter 1: Introduction; OVERVIEW; WHY WAS THIS BOOK WRITTEN?; WHO IS THE TARGET AUDIENCE?; WHAT IS THE PURPOSE OF THE BOOK?; EXPANDING YOUR SOFTWARE SKILLS; EXPANDING YOUR MODEL DESIGN SKILLS; EXPANDING YOUR FINANCE KNOWLEDGE; ORGANIZED TO TEACH; CHAPTER ORGANIZATION

ACCOMPANYING WEB SITELEARNING THE "HARD" WAY; NOTE; Chapter 2: The Existing Model; OVERVIEW; DELIVERABLES; UNDER CONSTRUCTION; CRISIS DU JOUR; OVERVIEW OF THE CURRENT MODEL; CURRENT MODEL ENVIRONMENT; ON THE WEB SITE; Chapter 3: Conventions and Advice; OVERVIEW; DELIVERABLES; VBA CONVENTIONS; COMMON SENSE; ON THE WEB SITE; Chapter 4: Segregation of the Existing Model's Functionality; OVERVIEW; DELIVERABLES; UNDER CONSTRUCTION; DELIVERABLES CHECKLIST; BREAKING UP IS HARD TO



DO; ACCOMMODATING OUR DESIGN NEEDS; ADVANTAGES OF FUNCTIONAL SEGREGATION; DISADVANTAGES OF FUNCTIONAL SEGREGATION

ON THE WEB SITEChapter 5: Creating the Base Asset Model; OVERVIEW; DELIVERABLES; UNDER CONSTRUCTION; THE BIG PICTURE: "JUST THE ASSETS, MA'AM"; STEPPING THROUGH THE MODEL; TESTING THE COMPLETED BASE ASSET MODEL; ON THE WEB SITE; Chapter 6: Building the Base Liabilities Model; OVERVIEW; DELIVERABLES; UNDER CONSTRUCTION; LIABILITIES SIDE OF THE MODEL; WHAT TO LEAVE IN; STEPPING THROUGH THE MODEL; READING THE CASH FLOWS AND ASSUMPTIONS FROM A FILE; TESTING THE COMPLETED BASE LIABILITIES MODEL; ON THE WEB SITE; Chapter 7: Establishing the Model Environment; OVERVIEW; DELIVERABLES

UNDER CONSTRUCTIONIMPORTANCE OF A STANDARDIZED DIRECTORY STRUCTURE; CREATING DIRECTORIES AND DEFINING THEIR FUNCTIONS; OPERATING DIRECTORIES; ADMINISTRATIVE DIRECTORIES; CREATING NEW DIRECTORIES FOR THE MODEL AS WE NEED THEM; ON THE WEB SITE; Part Two: Building the New Assets Model; Chapter 8: Designing the New Collateral Cash Flow Generator; OVERVIEW; DELIVERABLES; UNDER CONSTRUCTION; IMPROVING THE CCFG MENUS: CONVERSION TO USERFORMS; IMPROVING THE CCFG DATA-HANDLING CAPABILITIES; IMPROVING THE CCFG COLLATERAL SELECTION PROCESS; IMPROVING THE CCFG CASH FLOW GENERATION PROCESS

IMPROVING THE CCFG REPORT GENERATION PROCESSIMPROVING THE CCFG MESSAGING PROCESS; ON THE WEB SITE; Chapter 9: Writing the CCFG Menus and Data Sheets; OVERVIEW; DELIVERABLES; UNDER CONSTRUCTION; MENUS AND USERFORMS; MENUS OF THE CCFG; MAIN MENU; RUN OPTIONS MENU; COLLATERAL POOL MENU; COLLATERAL GEOGRAPHIC SELECTION CRITERIA MENU; FINANCIAL SELECTION CRITERIA MENU; CASH FLOW AMORTIZATION PARAMETERS MENU; COLLATERAL REPORTS MENU; ON THE WEB SITE; Chapter 10: Writing the Collateral Data Handling Code; OVERVIEW; DELIVERABLES; UNDER CONSTRUCTION; MANAGING MULTIPLE PORTFOLIO FILES

INITIAL DATA SCREENING

Sommario/riassunto

This book is written for financial analysts who have a working knowledge of Excel and VBA and who wish to enhance their marketability by improving their modeling expertise.  The goal of the book is to broaden the reader's VBA skills and at the same time to progressively integrate Access, PowerPoint, and Outlook into an existing model.  Significant attention is also directed to the design and execution of an Excel/VBA interface employing detailed UserForms.  In addition, the construction of various reports, first in Excel, then Access, and finally PowerPoint is undertaken.  Regardless of your a