Terug Terug

Fast Track To Structured Finance Modeling, Monitoring And Va Jump Start VBA

Name: Fast Track To Structured Finance Modeling, Monitoring And Va
Author: William Preinitz

Auteur: William Preinitz

Taal: Engels

Afbeeldingen

Artikel vergelijken

Vergelijk met andere artikelen

Bekijk nu

Auteur: William Preinitz

Engels
Hardcover
9780470398128
10 maart 2009
744 pagina's

Alle productspecificaties

Samenvatting

An introductory work to structured modeling in Visual Basic Application (VBA), A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA provides you with a concise, immediate, and practical guide to developing a meaningful level of modeling expertise on problems in structured finance. Designed to allow you to cross from the pure Excel world to the much more powerful and flexible world of VBA/Excel, this straightforward book is built around a structured finance case study in asset based securitization.

Starting with basic examples that progressively develop your confidence to take on more complicated tasks, this book teaches you how to break complex tasks down into simple tasks and then implement them into VBA code using a critical subset of the features of the language. This hands on, step by step guide features coverage of:

General modeling concepts
The Cash Flow Waterfall in Excel code
Organizing and creating VBA modules to hold your model code
Generating VBA code from recorded macros, and how to simplify and extract it for use in your model
Efficiently using VBA statements to control the flow of the model
How to use template files for efficient and flexible report writing
Writing a collateral selection and reporting capability into your model
How to generate collateral cash flows on a loan by loan, period by period basis
Calculation optimization applied to collateral cash flow amortization
How to use the VBA debugger to detect and correct different types of errors
How to use the completed model to structure and size a finance deal
Modifying the model to allow multiple scenario runs
Protecting and evolving the model so it continues to create value for the business unit
How to add additional reporting and analytical features to the existing model
How to convert the structuring model into a monitoring and valuation model
Allowing for the use of monthly empirical performance information
Use of the monitoring and valuation model to track the performance of the deal
Valuing the deal based on its performance, market conditions, and rating criteria

Accompanied by an online resource containing a complete working model and all the data and files professionals need to run it, A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA is the only book written for the complete novice, enhancing your ability to break complex, seemingly insoluble problems down into a set of manageable tasks, through the use of VBA.

Productspecificaties

Inhoud

Taal: en
Bindwijze: Hardcover
Oorspronkelijke releasedatum: 10 maart 2009
Aantal pagina's: 744
Illustraties: Nee

Betrokkenen

Hoofdauteur: William Preinitz
Hoofduitgeverij: Onbekend

Overige kenmerken

Extra groot lettertype: Nee
Product breedte: 184 mm
Product hoogte: 57 mm
Product lengte: 254 mm
Studieboek: Nee
Verpakking breedte: 180 mm
Verpakking hoogte: 254 mm
Verpakking lengte: 58 mm
Verpakkingsgewicht: 1474 g

EAN

EAN: 9780470398128

Je vindt dit artikel in

Categorieën: Economie & Financiën

Financien & Boekhouding

Accounting

Financien

Boeken
Taal: Engels
Studieboek of algemeen: Algemene boeken
Boek, ebook of luisterboek?: Boek
Beschikbaarheid: Leverbaar

Reviews

Nog geen reviews

Hoe controleren en plaatsen wij reviews? Hoe controleren en plaatsen wij reviews?

Negatief, positief, neutraal: we zetten een review altijd online. We controleren wel eerst of ’ie voldoet aan onze reviewvoorwaarden en niet nep is. We controleren ook of ’ie is geschreven door iemand die het artikel heeft gekocht via bol.com en zetten dit er dan bij. De controles gebeuren automatisch, al kijken er soms mensen mee. Bol.com betaalt niet voor reviews. Als een reviewer door een andere partij is vergoed, staat dit in de review zelf.