LEADER 05335nam 2200637 450 001 9910811579103321 005 20230725031253.0 010 $a1-119-19984-0 010 $a0-470-92875-1 010 $a0-470-92878-6 035 $a(CKB)2670000000087352 035 $a(EBL)644815 035 $a(SSID)ssj0000559163 035 $a(PQKBManifestationID)12198094 035 $a(PQKBTitleCode)TC0000559163 035 $a(PQKBWorkID)10566703 035 $a(PQKB)10186800 035 $a(MiAaPQ)EBC644815 035 $a(OCoLC)752384925 035 $a(EXLCZ)992670000000087352 100 $a20160812h20112011 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aIntermediate structured finance modeling $eeveraging excel, VBA, access, and powerpoint /$fWilliam Preinitz with Matthew Niedermaier 210 1$aHoboken, New Jersey :$cJohn Wiley & Sons, Inc.,$d2011. 210 4$dİ2011 215 $a1 online resource (1984 p.) 225 1 $aWiley Finance 300 $aIncludes indexes. 311 $a0-470-56239-0 327 $aCover; 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 327 $aACCOMPANYING 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 327 $aON 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 327 $aUNDER 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 327 $aIMPROVING 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 327 $aINITIAL DATA SCREENING 330 $aThis 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 410 0$aWiley finance series. 606 $aFinance$xComputer simulation 606 $aFinance$xMathematical models 615 0$aFinance$xComputer simulation. 615 0$aFinance$xMathematical models. 676 $a332.015195 676 $a332.0285/5133 700 $aPreinitz$b William$f1950-$01648976 702 $aNiedermaier$b Matthew$f1981- 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910811579103321 996 $aIntermediate structured finance modeling$94064612 997 $aUNINA