Intermediate structured finance modeling : everaging excel, VBA, access, and powerpoint / / William Preinitz with Matthew Niedermaier |
Autore | Preinitz William <1950-> |
Pubbl/distr/stampa | Hoboken, New Jersey : , : John Wiley & Sons, Inc., , 2011 |
Descrizione fisica | 1 online resource (1984 p.) |
Disciplina |
332.015195
332.0285/5133 |
Collana | Wiley Finance |
Soggetto topico |
Finance - Computer simulation
Finance - Mathematical models |
ISBN |
1-119-19984-0
0-470-92875-1 0-470-92878-6 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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 |
Record Nr. | UNINA-9910141138203321 |
Preinitz William <1950-> | ||
Hoboken, New Jersey : , : John Wiley & Sons, Inc., , 2011 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Intermediate structured finance modeling : everaging excel, VBA, access, and powerpoint / / William Preinitz with Matthew Niedermaier |
Autore | Preinitz William <1950-> |
Pubbl/distr/stampa | Hoboken, New Jersey : , : John Wiley & Sons, Inc., , 2011 |
Descrizione fisica | 1 online resource (1984 p.) |
Disciplina |
332.015195
332.0285/5133 |
Collana | Wiley Finance |
Soggetto topico |
Finance - Computer simulation
Finance - Mathematical models |
ISBN |
1-119-19984-0
0-470-92875-1 0-470-92878-6 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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 |
Record Nr. | UNINA-9910811579103321 |
Preinitz William <1950-> | ||
Hoboken, New Jersey : , : John Wiley & Sons, Inc., , 2011 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|