A Fast Track to Structured Finance Modeling, Monitoring, and Valuation

Jump Start VBA

DOWNLOAD NOW »

Author: William Preinitz

Publisher: John Wiley & Sons

ISBN: 9780470446065

Category: Business & Economics

Page: 560

View: 4550

This book is designed to start with simple examples that progressively develop the reader's confidence to take on more complex tasks. There is very little theoretical discussion about computer science, operations research algorithms, mathematics, or finance. The thrust of the book is to teach the reader to break complex tasks down into simple tasks. It then looks to implement those simple tasks into VBA code using a critical subset of the features of the language. The tentative contents is: (1) Why? What? Who? Where? and How? (2) Common Sense (3) Securitizing A Loan Portfolio (4) Understanding the Excel Waterfall (5) Designing the VBA Model (6) Laying the Model Groundwork (7) Recorded Macros: A First Look at the VBA Language (8) Writing Menus: An Introduction to Data, Ranges, Arrays, and Objects (9) Controlling the Flow of the Model (10) Building Messaging Capabilities (11) Designing the Model’s Reports (12) Main Program and Menus (13) Writing the Collateral Selection Code (14) Calculating the Cash Flows (15) Running the Waterfall: Producing Initial Results (16) Debugging the Model (17) Validating the Model (18) Running the Model (19) Building Additional Capabilities (20) Documentation of the Model (21) Managing the Growth of the Model (22) Building Portfolio Monitoring Model (23) Valuation Techniques: How do we Determine Price? (24) Challenging Times For the Deal (25) Parting Admonitions

Intermediate Structured Finance Modeling

Leveraging Excel, VBA, Access, and Powerpoint

DOWNLOAD NOW »

Author: William Preinitz,Matthew Niedermaier

Publisher: John Wiley & Sons

ISBN: 0470928786

Category: Business & Economics

Page: 1032

View: 3384

This book provides a pragmatic, hands-on approach to reaching an intermediate level of sophistication as a financial modeler. Expanding on the first book, A Fast Tract to Structured Finance Modeling, Monitoring, and Valuation, the book will guide you step-by-step through using learned principals in new and more powerful applications. These applications will build on the knowledge of Excel and VBA gained, expand the use of Access for data management tasks, as well as PowerPoint and Outlook for reporting and presentation tasks.

Securitization and Structured Finance Post Credit Crunch

A Best Practice Deal Lifecycle Guide

DOWNLOAD NOW »

Author: Markus Krebsz

Publisher: John Wiley & Sons

ISBN: 9780470662120

Category: Business & Economics

Page: 476

View: 3422

In this book, you will be introduced to generic best practice principles for a post credit crunch market. First, the book takes a closer look at the reasons why the market froze during the 2007 to 2009 credit crisis. Then you will learn how to use the principles explained here in your generic deal's typical life cycle stages. Throughout, each stage is discussed in detail, from strategy and feasibility, pre-close, at close, and post close. The final section of the book contains a toolbox of references, tables, dictionaries, and resources.

QFinance

The Ultimate Resource

DOWNLOAD NOW »

Author: Various Authors

Publisher: Bloomsbury USA

ISBN: 9781849300001

Category: Business & Economics

Page: 2200

View: 8290

Compiled by more than 300 of the world's leading professionals, visionaries, writers and educators, this is THE first-stop reference resource and knowledge base for finance. QFINANCE covers an extensive range of finance topics with unique insight, authoritative information, practical guidance and thought-provoking widsom. Unmatched for in-depth content, QFINANCE contains more than 2 million words of text, data analysis, critical summaries and bonus online content. Created by Bloomsbury Publishing in association with the Qatar Financial Centre (QFC) Authority, QFINANCE is the expert reference resource for finance professionals, academics, students, journalists and writers. QFINANCE: The Ultimate Resource Special Features: Best Practice and Viewpoint Essays – Finance leaders, experts and educators address how to resolve the most crucial issues and challenges facing business today. Finance Checklists – Step-by-step guides offer problem-solving solutions including hedging interest-rate risk, governance practices, project appraisal, estimating enterprise value and managing credit ratings. Calculations and Ratios – Essential mathematical tools include how to calculate return on investment, return on shareholders’ equity, working capital productivity, EVA, risk-adjusted rate of return, CAPM, etc. Finance Thinkers and Leaders – Illuminating biographies of 50 of the leading figures in modern finance including Joseph De La Vega, Louis Bachelier, Franco Modigliani, Paul Samuelson, and Myron Scholes Finance Library digests –Summaries of more than 130 key works ranging from “Against the Gods” to “Portfolio Theory & Capital Markets” and “The Great Crash”. Country and Sector Profiles – In-depth analysis of 102 countries and 26 sectors providing essential primary research resource for direct or indirect investment. Finance Information Sources – A select list of the best resources for further information on finance and accounting worldwide, both in print and online, including books, journal articles, magazines, internet, and organizations Finance Dictionary – A comprehensive jargon-free, easy-to-use dictionary of more than 9,000 finance and banking terms used globally. Quotations – More than 2,000 business relevant quotations. Free access to QFinance Online Resources (www.qfinance.com): Get daily content updates, podcasts, online events and use our fully searchable database.

Intermediate Structured Finance Modeling, with Website

Leveraging Excel, VBA, Access, and Powerpoint

DOWNLOAD NOW »

Author: William Preinitz,Matthew Niedermaier

Publisher: John Wiley and Sons

ISBN: 0470562390

Category: Business & Economics

Page: 1032

View: 6643

Designed as a hands-on guide to help financial analysts with fundamental Excel/VBA knowledge to develop greater skills. Demonstrates how Access, PowerPoint, and Outlook can be integrated into a modelling environment, and focuses on the design and execution of an Excel/VBA user interface. Uses a structured finance model case study to demonstrate product integration. Includes examples of Access and VBA code, Excel menus, UserForms, financial calculation algorithms, and reports. NOTE: Available as an Ebook.