05335nam 2200637 450 991081157910332120230725031253.01-119-19984-00-470-92875-10-470-92878-6(CKB)2670000000087352(EBL)644815(SSID)ssj0000559163(PQKBManifestationID)12198094(PQKBTitleCode)TC0000559163(PQKBWorkID)10566703(PQKB)10186800(MiAaPQ)EBC644815(OCoLC)752384925(EXLCZ)99267000000008735220160812h20112011 uy 0engur|n|---|||||txtccrIntermediate structured finance modeling everaging excel, VBA, access, and powerpoint /William Preinitz with Matthew NiedermaierHoboken, New Jersey :John Wiley & Sons, Inc.,2011.©20111 online resource (1984 p.)Wiley FinanceIncludes indexes.0-470-56239-0 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 ORGANIZATIONACCOMPANYING 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 SEGREGATIONON 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; DELIVERABLESUNDER 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 PROCESSIMPROVING 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 FILESINITIAL DATA SCREENINGThis 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 aWiley finance series.FinanceComputer simulationFinanceMathematical modelsFinanceComputer simulation.FinanceMathematical models.332.015195332.0285/5133Preinitz William1950-1648976Niedermaier Matthew1981-MiAaPQMiAaPQMiAaPQBOOK9910811579103321Intermediate structured finance modeling4064612UNINA