| |
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
|
|
Soggetti |
|
Finance - Computer simulation |
Finance - Mathematical models |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
| |