Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint

0 valoración promedio
( 0 valoraciones por Goodreads )
 
9780470562390: Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint

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 area of financial expertise, this book serves as an essential guide to mastering leveraging the effects of Microsoft products in whatever applications you choose to build.

The focus of the book is a case study containing a structured finance model.  The case study model was originally designed for the securitization of a portfolio of commercial small business loans.  This model now needs to be expanded to securitize a much larger portfolio of residential mortgages. 

The Original Structuring model will be bifurcated into a Sources of Funds model, the assets of the collateral pool, and a Uses of Funds model, the liabilities waterfall model.  This will give the reader experience working with an existing model as a base departure point of development rather than the less common “start from scratch” approach.  Once the Base Asset Model (BAM) and the Base Liabilities Models (BLM) are complete, each model will serve as the platform for future development.  From the BAM and BLM a pair of much more robust models, the Collateral Cash Flow Generator (CCFG) and the Liabilities Waterfall Model (LWM), respectively, are created.  The CCFG is designed to process a significantly greater quantity, variety, and complexity of collateral types.  It also introduces the analyst to Geographic based prepayment methods as well as those using Financial/Demographic factor approaches. The LWM, operating independently of the CCFG, reads the collateral cash flow scenarios and applies them across a two tiered, six tranche bond structure.  The liabilities waterfall contains provision for an interest rate swap, performance triggers and a variety of other credit enhancement features.

With the CCFG and LWM now complete Access is introduced.  Access will replace various Excel/VBA code modules in the CCFG such as the collateral data management, data scrubbing and reporting, data sufficiency testing, and eligibility screening.  Access is also employed to export and the various collateral cash flows.   In the LWM Access is used to import the cash flows, store the liability structure specifications, and export/save the resultant structure performance.  PowerPoint is then introduced in the CCFG to allow for the fully automated production of presentation report packages.  Last Outlook is added to the models to inform the analyst of model performance and to automatically distribute the various report packages to pre-designated mailing lists.

The book contains over 750 exhibits of reports, menus, calculation, and algorithmic examples and most of all code.  The complete Excel, VBA, Access, PowerPoint, and Outlook code for all of the models is included on the Web site.  The Web site also includes Web chapters containing detailed instructions on how to create and populate a directory environment to store this code, run the models, and organize the results.  Lastly there are other Web chapters containing supplemental information explaining the structure and function of the original model, bond and mortgage math (with calculation examples), representative line generator programs, and a tutorial on the construction and integration of UserForms.

This book is the intermediate level companion volume to A Fast-Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA; Preinitz; Wiley 2009, an introductory work on the subject.

"Sinopsis" puede pertenecer a otra edición de este libro.

From the Inside Flap:

Regardless of your financial specialization, this book is an essential learning tool in leveraging Microsoft products in whatever modeling applications you choose to build. The principles outlined here can be readily employed across all fields of financial and non-financial modeling.

This book is written for financial analysts who have a working knowledge of Excel and VBA and who wish to enhance their productivity and marketability by improving their modeling expertise. The goal of the book is to broaden the reader's Excel/VBA skills and to demonstrate the progressive integration of Access, PowerPoint, and Outlook into a modeling environment. Significant attention is also directed to the design and execution of an Excel/VBA user interface employing complex UserForms.

The focus of the book is a case study containing a structured finance model. An exisiting Excel/VBA model is segregated into separate Asset and Liability Models. These two models are then extensively developed by creating sophisticated UserForm interfaces, expanding computational subroutines, and implementing more elaborate and detailed report packages. Access databases are then incorporated to manage sets of model inputs and results. The capability to automatically produce a ready-to-use PowerPoint presentation is also added. Finally, Outlook is integrated to automate status reporting and distribution of model report packages.

The book contains over 750 exhibits of VBA and Access code, Excel menus and UserForms, as well as financial calculation algorithms and reports. Complete working versions of all models, their input files, and report results are included on the Web site. Other web chapters contain detailed instructions on how to create a directory environment to download and run the models, supplemental bond and mortgage math primers, a discussion of representative line generator programs, and a tutorial on Excel UserForms.

This book is the intermediate-level companion volume to A Fast-Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA, an introductory work on the subject.

From the Back Cover:

A pragmatic, hands-on approach to reaching an intermediate level of sophistication as a financial modeler

Intermediate Structured Finance Modeling is packed with insight and tips to teach you step by step to expand your current level of organizational, coding, modeling, and financial skills to enhance and develop new and more powerful applications. It expertly employs a code-intensive approach to improve your VBA and Excel skills and demonstrates how to integrate them with a real-life application.

Providing you with a set of immediately applicable modeling approaches, techniques, skills, and examples with a focus on large model development, you will learn how to:

  • Organize and build a set of directories to contain the model system you will develop
  • Separate an existing basic structured finance model into two special-purpose models, an Asset (collateral) model and a Liabilities Structure (bonds) model
  • Expand the computational, data management, and reporting capabilities of both new models
  • Employ Excel UserForms to build a sophisticated model interfaces
  • Introduce Access databases and code to manage model data requirements and outputs
  • Dramatically expand existing reporting packages, producing more sophisticated analytical results
  • Automate the production of ready-to-use PowerPoint presentations
  • Improve your model's ability to distribute its results by integrating Outlook mailing lists

If you have some modeling experience and are confident in your mastery of the fundamental features of VBA and Excel, Intermediate Structured Finance Modeling is the book for you. With working solutions to the challenges of developing larger scale models, you will learn successful intermediate modeling techniques that can be applied to any real-world situation and activity.

This book is the intermediate-level companion volume to A Fast-Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA, an introductory work on the subject.

"Sobre este título" puede pertenecer a otra edición de este libro.

Los mejores resultados en AbeBooks

1.

William Preinitz; Matthew Niedermaier
Editorial: John Wiley and Sons
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuevos Cantidad: > 20
Librería
INDOO
(Avenel, NJ, Estados Unidos de America)
Valoración
[?]

Descripción John Wiley and Sons. Estado de conservación: New. Brand New. Nº de ref. de la librería 0470562390

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 87,44
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 2,98
A Estados Unidos de America
Destinos, gastos y plazos de envío

2.

William Preinitz, Matthew Niedermaier
Editorial: Wiley (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuevos Tapa dura Cantidad: 1
Librería
Ergodebooks
(RICHMOND, TX, Estados Unidos de America)
Valoración
[?]

Descripción Wiley, 2011. Hardcover. Estado de conservación: New. 1. Nº de ref. de la librería DADAX0470562390

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 112,77
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 4,25
A Estados Unidos de America
Destinos, gastos y plazos de envío

3.

William Preinitz
Editorial: Wiley 2011-02-08 (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuevos Tapa dura Cantidad: 1
Librería
Lost Books
(AUSTIN, TX, Estados Unidos de America)
Valoración
[?]

Descripción Wiley 2011-02-08, 2011. Hardcover. Estado de conservación: New. 1. 0470562390. Nº de ref. de la librería 685410

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 121,81
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,40
A Estados Unidos de America
Destinos, gastos y plazos de envío

4.

William Preinitz; Matthew Niedermaier
Editorial: Wiley (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuevos Tapa dura Primera edición Cantidad: 1
Librería
Irish Booksellers
(Rumford, ME, Estados Unidos de America)
Valoración
[?]

Descripción Wiley, 2011. Hardcover. Estado de conservación: New. book. Nº de ref. de la librería M0470562390

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 129,67
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

5.

William Preinitz, Matthew Niedermaier
Editorial: John Wiley and Sons Ltd, United Kingdom (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuevos Primera edición Cantidad: 10
Librería
The Book Depository US
(London, Reino Unido)
Valoración
[?]

Descripción John Wiley and Sons Ltd, United Kingdom, 2011. Mixed media product. Estado de conservación: New. 1. Auflage. Language: English . Brand New Book. 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 area of financial expertise, this book serves as an essential guide to mastering leveraging the effects of Microsoft products in whatever applications you choose to build. The focus of the book is a case study containing a structured finance model. The case study model was originally designed for the securitization of a portfolio of commercial small business loans. This model now needs to be expanded to securitize a much larger portfolio of residential mortgages. The Original Structuring model will be bifurcated into a Sources of Funds model, the assets of the collateral pool, and a Uses of Funds model, the liabilities waterfall model. This will give the reader experience working with an existing model as a base departure point of development rather than the less common start from scratch approach. Once the Base Asset Model (BAM) and the Base Liabilities Models (BLM) are complete, each model will serve as the platform for future development. From the BAM and BLM a pair of much more robust models, the Collateral Cash Flow Generator (CCFG) and the Liabilities Waterfall Model (LWM), respectively, are created. The CCFG is designed to process a significantly greater quantity, variety, and complexity of collateral types. It also introduces the analyst to Geographic based prepayment methods as well as those using Financial/Demographic factor approaches. The LWM, operating independently of the CCFG, reads the collateral cash flow scenarios and applies them across a two tiered, six tranche bond structure. The liabilities waterfall contains provision for an interest rate swap, performance triggers and a variety of other credit enhancement features. With the CCFG and LWM now complete Access is introduced. Access will replace various Excel/VBA code modules in the CCFG such as the collateral data management, data scrubbing and reporting, data sufficiency testing, and eligibility screening. Access is also employed to export and the various collateral cash flows. In the LWM Access is used to import the cash flows, store the liability structure specifications, and export/save the resultant structure performance. PowerPoint is then introduced in the CCFG to allow for the fully automated production of presentation report packages. Last Outlook is added to the models to inform the analyst of model performance and to automatically distribute the various report packages to pre-designated mailing lists. The book contains over 750 exhibits of reports, menus, calculation, and algorithmic examples and most of all code. The complete Excel, VBA, Access, PowerPoint, and Outlook code for all of the models is included on the Web site. The Web site also includes Web chapters containing detailed instructions on how to create and populate a directory environment to store this code, run the models, and organize the results. Lastly there are other Web chapters containing supplemental information explaining the structure and function of the original model, bond and mortgage math (with calculation examples), representative line generator programs, and a tutorial on the construction and integration of UserForms. This book is the intermediate level companion volume to A Fast-Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA; Preinitz; Wiley 2009, an introductory work on the subject. Nº de ref. de la librería BZV9780470562390

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 135,52
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

6.

Preinitz, William, Niedermaier, Matthew
Editorial: Wiley (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuevos Tapa dura Cantidad: 2
Librería
Murray Media
(North Miami Beach, FL, Estados Unidos de America)
Valoración
[?]

Descripción Wiley, 2011. Hardcover. Estado de conservación: New. Never used!. Nº de ref. de la librería P110470562390

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 136,10
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 1,70
A Estados Unidos de America
Destinos, gastos y plazos de envío

7.

William Preinitz,Matthew Niedermaier
Editorial: John Wiley & Sons 2011-02-08 (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuevos Cantidad: 5
Librería
Chiron Media
(Wallingford, Reino Unido)
Valoración
[?]

Descripción John Wiley & Sons 2011-02-08, 2011. Gebundene Ausgabe. Estado de conservación: New. Nº de ref. de la librería NU-LBR-00889632

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 137,98
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,37
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

8.

William Preinitz, Matthew Niedermaier
Editorial: John Wiley and Sons Ltd, United Kingdom (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuevos Primera edición Cantidad: 10
Librería
Book Depository hard to find
(London, Reino Unido)
Valoración
[?]

Descripción John Wiley and Sons Ltd, United Kingdom, 2011. Mixed media product. Estado de conservación: New. 1. Auflage. Language: English . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. Brand New Book. 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 area of financial expertise, this book serves as an essential guide to mastering leveraging the effects of Microsoft products in whatever applications you choose to build. The focus of the book is a case study containing a structured finance model. The case study model was originally designed for the securitization of a portfolio of commercial small business loans. This model now needs to be expanded to securitize a much larger portfolio of residential mortgages. The Original Structuring model will be bifurcated into a Sources of Funds model, the assets of the collateral pool, and a Uses of Funds model, the liabilities waterfall model. This will give the reader experience working with an existing model as a base departure point of development rather than the less common start from scratch approach. Once the Base Asset Model (BAM) and the Base Liabilities Models (BLM) are complete, each model will serve as the platform for future development. From the BAM and BLM a pair of much more robust models, the Collateral Cash Flow Generator (CCFG) and the Liabilities Waterfall Model (LWM), respectively, are created. The CCFG is designed to process a significantly greater quantity, variety, and complexity of collateral types. It also introduces the analyst to Geographic based prepayment methods as well as those using Financial/Demographic factor approaches. The LWM, operating independently of the CCFG, reads the collateral cash flow scenarios and applies them across a two tiered, six tranche bond structure. The liabilities waterfall contains provision for an interest rate swap, performance triggers and a variety of other credit enhancement features. With the CCFG and LWM now complete Access is introduced. Access will replace various Excel/VBA code modules in the CCFG such as the collateral data management, data scrubbing and reporting, data sufficiency testing, and eligibility screening. Access is also employed to export and the various collateral cash flows. In the LWM Access is used to import the cash flows, store the liability structure specifications, and export/save the resultant structure performance. PowerPoint is then introduced in the CCFG to allow for the fully automated production of presentation report packages. Last Outlook is added to the models to inform the analyst of model performance and to automatically distribute the various report packages to pre-designated mailing lists. The book contains over 750 exhibits of reports, menus, calculation, and algorithmic examples and most of all code. The complete Excel, VBA, Access, PowerPoint, and Outlook code for all of the models is included on the Web site. The Web site also includes Web chapters containing detailed instructions on how to create and populate a directory environment to store this code, run the models, and organize the results. Lastly there are other Web chapters containing supplemental information explaining the structure and function of the original model, bond and mortgage math (with calculation examples), representative line generator programs, and a tutorial on the construction and integration of UserForms. This book is the intermediate level companion volume to A Fast-Track to Structured Finance Modeling, Monitoring, Nº de ref. de la librería BZV9780470562390

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 142,91
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

9.

William Preinitz, Matthew Niedermaier
Editorial: John Wiley and Sons Ltd, United Kingdom (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuevos Primera edición Cantidad: 1
Librería
The Book Depository
(London, Reino Unido)
Valoración
[?]

Descripción John Wiley and Sons Ltd, United Kingdom, 2011. Mixed media product. Estado de conservación: New. 1. Auflage. Language: English . Brand New Book. 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 area of financial expertise, this book serves as an essential guide to mastering leveraging the effects of Microsoft products in whatever applications you choose to build. The focus of the book is a case study containing a structured finance model. The case study model was originally designed for the securitization of a portfolio of commercial small business loans. This model now needs to be expanded to securitize a much larger portfolio of residential mortgages. The Original Structuring model will be bifurcated into a Sources of Funds model, the assets of the collateral pool, and a Uses of Funds model, the liabilities waterfall model. This will give the reader experience working with an existing model as a base departure point of development rather than the less common start from scratch approach. Once the Base Asset Model (BAM) and the Base Liabilities Models (BLM) are complete, each model will serve as the platform for future development. From the BAM and BLM a pair of much more robust models, the Collateral Cash Flow Generator (CCFG) and the Liabilities Waterfall Model (LWM), respectively, are created. The CCFG is designed to process a significantly greater quantity, variety, and complexity of collateral types. It also introduces the analyst to Geographic based prepayment methods as well as those using Financial/Demographic factor approaches. The LWM, operating independently of the CCFG, reads the collateral cash flow scenarios and applies them across a two tiered, six tranche bond structure. The liabilities waterfall contains provision for an interest rate swap, performance triggers and a variety of other credit enhancement features. With the CCFG and LWM now complete Access is introduced. Access will replace various Excel/VBA code modules in the CCFG such as the collateral data management, data scrubbing and reporting, data sufficiency testing, and eligibility screening. Access is also employed to export and the various collateral cash flows. In the LWM Access is used to import the cash flows, store the liability structure specifications, and export/save the resultant structure performance. PowerPoint is then introduced in the CCFG to allow for the fully automated production of presentation report packages. Last Outlook is added to the models to inform the analyst of model performance and to automatically distribute the various report packages to pre-designated mailing lists. The book contains over 750 exhibits of reports, menus, calculation, and algorithmic examples and most of all code. The complete Excel, VBA, Access, PowerPoint, and Outlook code for all of the models is included on the Web site. The Web site also includes Web chapters containing detailed instructions on how to create and populate a directory environment to store this code, run the models, and organize the results. Lastly there are other Web chapters containing supplemental information explaining the structure and function of the original model, bond and mortgage math (with calculation examples), representative line generator programs, and a tutorial on the construction and integration of UserForms. This book is the intermediate level companion volume to A Fast-Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA; Preinitz; Wiley 2009, an introductory work on the subject. Nº de ref. de la librería LIB9780470562390

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 147,21
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

10.

William Preinitz, Matthew Niedermaier
Editorial: Wiley 2011-02-08, Hoboken, N.J. (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuevos Tapa dura Cantidad: 1
Librería
Blackwell's
(Oxford, OX, Reino Unido)
Valoración
[?]

Descripción Wiley 2011-02-08, Hoboken, N.J., 2011. hardback. Estado de conservación: New. Nº de ref. de la librería 9780470562390

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 147,57
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 6,77
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

Existen otras copia(s) de este libro

Ver todos los resultados de su búsqueda