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

Overview

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 ...

See more details below
Other sellers (Hardcover)
  • All (11) from $59.98   
  • New (8) from $59.98   
  • Used (3) from $77.12   
Intermediate Structured Finance Modeling: Leveraging Excel, VBA, Access, and Powerpoint

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$99.99
BN.com price
(Save 42%)$175.00 List Price

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780470562390
  • Publisher: Wiley
  • Publication date: 2/8/2011
  • Series: Wiley Finance Series , #573
  • Edition number: 1
  • Pages: 995
  • Product dimensions: 7.50 (w) x 10.00 (h) x 2.30 (d)

Meet the Author

WILLIAM PREINITZ has thirty years' experience in investment banking and structured finance analytics. A former managing director at Citigroup, highlights of his career include the creation and marketing of securitizations backed by 12b-1 mutual fund fees. With a team of ten people over a fifteen-year period, his group concurrently provided analytical structuring support for the over 100 different asset classes contained in the ABCP program of the bank. These included such varied items as movie revenues, fast-food franchise financing, and communication satellite leasing. In conjunction with the bank's corporate training program, he taught Excel/VBA modeling classes to over 300 people ranging from associates to managing directors.

MATTHEW NIEDERMAIER is currently a vice president in the Structured Finance Group at Markit, where he is a member of a pricing and valuation group focused on agency mortgages and CMOs. Within Markit he has also taught courses in Excel/VBA globally. Prior to Markit he modeled U.S. and Latin American ABS deals at Citigroup, including auto loans, credit cards, and timeshares.

Read More Show Less

Table of Contents

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.

Acknowledgments.

PART ONE. First Steps.

CHAPTER 1. Introduction.

CHAPTER 2. The Existing Model.

CHAPTER 3. Conventions and Advice.

CHAPTER 4. Segregation of the Existing Model’s Functionality.

CHAPTER 5. Creating the Base Asset Model.

CHAPTER 6. Building the Base Liabilities Model.

CHAPTER 7. Establishing the Model Environment.

PART TWO. Building the New Assets Model.

CHAPTER 8. Designing the New Collateral Cash Flow Generator.

CHAPTER 9. Writing the CCFG Menus and Data Sheets.

CHAPTER 10. Writing the Collateral Data Handling Code.

CHAPTER 11. Writing the Collateral Selection Code.

CHAPTER 12. Writing the Collateral Cash Flow Amortization Code.

CHAPTER 13. Writing the CCFG Reporting Capability.

PART THREE. Building the New Liabilities Model.

CHAPTER 14. Designing the Liabilities Waterfall Model.

CHAPTER 15. Writing the Liabilities Waterfall Model Spreadsheet.

CHAPTER 16. Writing the LWM VBA Code.

PART FOUR. Access, PowerPoint, and Outlook.

CHAPTER 17. Access: An Introduction.

CHAPTER 18. Implementing Access in the CCFG and LWM.

CHAPTER 19. Implementing PowerPoint and Outlook in the CCFG.

PART FIVE. Running the CCFG and the LWM.

CHAPTER 20. Running the Models.

Afterword.

Exhibits Index.

Subject Index.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)