Intermediate Structured Finance Modeling: Leveraging Excel, VBA, Access, and PowerPoint

Valutazione media 0
( su 0 valutazioni fornite da GoodReads )
 
9780470562390: Intermediate Structured Finance Modeling: 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.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

I migliori risultati di ricerca su AbeBooks

1.

William Preinitz
Editore: Wiley 2011-02-08 (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuovi Rilegato Quantità: 1
Da
Lost Books
(AUSTIN, TX, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Wiley 2011-02-08, 2011. Hardcover. Condizione libro: New. 1. 0470562390. Codice libro della libreria 685410

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 67,28
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,69
In U.S.A.
Destinazione, tempi e costi

2.

Preinitz, William, Niedermaier, Matthew
Editore: Wiley (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuovi Rilegato Quantità: 3
Da
Murray Media
(North Miami Beach, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Wiley, 2011. Hardcover. Condizione libro: New. Codice libro della libreria P110470562390

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 87,78
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 2,77
In U.S.A.
Destinazione, tempi e costi

3.

William Preinitz; Matthew Niedermaier
Editore: John Wiley and Sons
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuovi Quantità: > 20
Da
INDOO
(Avenel, NJ, U.S.A.)
Valutazione libreria
[?]

Descrizione libro John Wiley and Sons. Condizione libro: New. Brand New. Codice libro della libreria 0470562390

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 94,98
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,24
In U.S.A.
Destinazione, tempi e costi

4.

William Preinitz, Matthew Niedermaier
Editore: Wiley (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuovi Rilegato Quantità: 1
Da
Ergodebooks
(RICHMOND, TX, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Wiley, 2011. Hardcover. Condizione libro: New. 1. Codice libro della libreria DADAX0470562390

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 129,15
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,69
In U.S.A.
Destinazione, tempi e costi

5.

Preinitz, William; Niedermaier, Matthew
Editore: Wiley (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuovi Rilegato Quantità: 1
Da
Irish Booksellers
(Rumford, ME, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Wiley, 2011. Hardcover. Condizione libro: New. book. Codice libro della libreria 0470562390

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 137,38
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
In U.S.A.
Destinazione, tempi e costi

6.

William Preinitz, Matthew Niedermaier
Editore: John Wiley and Sons Ltd, United Kingdom (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuovi Prima edizione Quantità: 1
Da
The Book Depository US
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro John Wiley and Sons Ltd, United Kingdom, 2011. Mixed media product. Condizione libro: New. 1. Auflage. 254 x 188 mm. 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. Codice libro della libreria LIB9780470562390

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 138,29
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

7.

William Preinitz, Matthew Niedermaier
Editore: John Wiley and Sons Ltd, United Kingdom (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuovi Prima edizione Quantità: 1
Da
The Book Depository
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro John Wiley and Sons Ltd, United Kingdom, 2011. Mixed media product. Condizione libro: New. 1. Auflage. 254 x 188 mm. 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. Codice libro della libreria LIB9780470562390

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 144,28
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

8.

William Preinitz,Matthew Niedermaier
Editore: John Wiley & Sons 2011-02-08 (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuovi Quantità: 5
Da
Chiron Media
(Wallingford, Regno Unito)
Valutazione libreria
[?]

Descrizione libro John Wiley & Sons 2011-02-08, 2011. Condizione libro: New. Brand new book, sourced directly from publisher. Dispatch time is 24-48 hours from our warehouse. Book will be sent in robust, secure packaging to ensure it reaches you securely. Codice libro della libreria NU-LBR-00889632

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 145,06
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 3,45
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

9.

William Preinitz, Matthew Niedermaier
Editore: John Wiley and Sons Ltd 2011-02-08, Chichester (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuovi Rilegato Quantità: 1
Da
Blackwell's
(Oxford, OX, Regno Unito)
Valutazione libreria
[?]

Descrizione libro John Wiley and Sons Ltd 2011-02-08, Chichester, 2011. hardback. Condizione libro: New. Codice libro della libreria 9780470562390

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 148,03
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 5,19
Da: Regno Unito a: U.S.A.
Destinazione, tempi e costi

10.

William Preinitz
Editore: Wiley John & Sons Mrz 2011 (2011)
ISBN 10: 0470562390 ISBN 13: 9780470562390
Nuovi Quantità: 1
Valutazione libreria
[?]

Descrizione libro Wiley John & Sons Mrz 2011, 2011. Buch. Condizione libro: Neu. 261x192x63 mm. Neuware - 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. 996 pp. Englisch. Codice libro della libreria 9780470562390

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 148,99
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 12,00
Da: Germania a: U.S.A.
Destinazione, tempi e costi

Vedi altre copie di questo libro

Vedi tutti i risultati per questo libro