Intermediate Structured Finance Modeling

Intermediate Structured Finance Modeling PDF Author: William Preinitz
Publisher: John Wiley & Sons
ISBN: 0470928786
Category : Business & Economics
Languages : en
Pages : 1032

Get Book

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

Intermediate Structured Finance Modeling

Intermediate Structured Finance Modeling PDF Author: William Preinitz
Publisher: John Wiley & Sons
ISBN: 0470928786
Category : Business & Economics
Languages : en
Pages : 1032

Get Book

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

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

A Fast Track to Structured Finance Modeling, Monitoring, and Valuation PDF Author: William Preinitz
Publisher: John Wiley & Sons
ISBN: 0470446064
Category : Business & Economics
Languages : en
Pages : 810

Get Book

Book Description
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

Modeling Structured Finance Cash Flows with Microsoft Excel

Modeling Structured Finance Cash Flows with Microsoft Excel PDF Author: Keith A. Allman
Publisher: John Wiley & Sons
ISBN: 1118044665
Category : Business & Economics
Languages : en
Pages : 230

Get Book

Book Description
A practical guide to building fully operational financial cash flow models for structured finance transactions Structured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to learn as they go. Modeling Structured Finance Cash Flows with Microsoft Excel provides readers with the information they need to build a cash flow model for structured finance and securitization deals. Financial professional Keith Allman explains individual functions and formulas, while also explaining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called "Model Builder," in which Allman translates the theory into functions and formulas. In addition, the companion website features all of the modeling exercises, as well as a final version of the model that is created in the text. Note: Companion website and other supplementary materials are not included as part of eBook file.

Corporate and Project Finance Modeling

Corporate and Project Finance Modeling PDF Author: Edward Bodmer
Publisher: John Wiley & Sons
ISBN: 1118854365
Category : Business & Economics
Languages : en
Pages : 628

Get Book

Book Description
A clear and comprehensive guide to financial modeling and valuation with extensive case studies and practice exercises Corporate and Project Finance Modeling takes a clear, coherent approach to a complex and technical topic. Written by a globally-recognized financial and economic consultant, this book provides a thorough explanation of financial modeling and analysis while describing the practical application of newly-developed techniques. Theoretical discussion, case studies and step-by-step guides allow readers to master many difficult modeling problems and also explain how to build highly structured models from the ground up. The companion website includes downloadable examples, templates, and hundreds of exercises that allow readers to immediately apply the complex ideas discussed. Financial valuation is an in-depth process, involving both objective and subjective parameters. Precise modeling is critical, and thorough, accurate analysis is what bridges the gap from model to value. This book allows readers to gain a true mastery of the principles underlying financial modeling and valuation by helping them to: Develop flexible and accurate valuation analysis incorporating cash flow waterfalls, depreciation and retirements, updates for new historic periods, and dynamic presentation of scenario and sensitivity analysis; Build customized spreadsheet functions that solve circular logic arising in project and corporate valuation without cumbersome copy and paste macros; Derive accurate measures of normalized cash flow and implied valuation multiples that account for asset life, changing growth, taxes, varying returns and cost of capital; Incorporate stochastic analysis with alternative time series equations and Monte Carlo simulation without add-ins; Understand valuation effects of debt sizing, sculpting, project funding, re-financing, holding periods and credit enhancements. Corporate and Project Finance Modeling provides comprehensive guidance and extensive explanation, making it essential reading for anyone in the field.

Elements of Structured Finance

Elements of Structured Finance PDF Author: Ann Rutledge
Publisher: Oxford University Press
ISBN: 0195179986
Category : Biography & Autobiography
Languages : en
Pages : 689

Get Book

Book Description
Both are co-authors of The Analysis of Structured Securities, published by Oxford University Press in 2003. They are founding principals of the New York-based structured credit metrics boutique R&R Consulting. Their clients include rating agencies, governments, universities, and global banks. --Book Jacket.

Financial Modelling in Practice

Financial Modelling in Practice PDF Author: Michael Rees
Publisher:
ISBN: 9781118374658
Category : Corporations
Languages : en
Pages : 270

Get Book

Book Description
Financial Modelling in Practice: A Concise Guide for Intermediate and Advanced Level is a practical, comprehensive and in-depth guide to financial modelling designed to cover the modelling issues that are relevant to facilitate the construction of robust and readily understandable models. --From publisher's description.

Building Financial Models with Microsoft Excel

Building Financial Models with Microsoft Excel PDF Author: K. Scott Proctor
Publisher: John Wiley and Sons
ISBN: 0470561459
Category : Business & Economics
Languages : en
Pages : 530

Get Book

Book Description
A proven guide to building financial models from scratch The Second Edition of Building Financial Models with Microsoft Excel + CD-ROM provides beginning and intermediate level computer users with step-by-step instructions on building financial models using Microsoft Excel 2007-the most popular spreadsheet program available. The accompanying CD-ROM contains Excel worksheets that track the course of the book and allow you to build your own financial models. This comprehensive resource also covers important topics such as the concepts of valuation, sensitivity analysis, and contribution margin. Offers accessible guidance on building financial models using Excel 2007 Illustrates how to integrate financial statements such as the balance sheet, income statement, and statement of cash flows Covers the basics of building and using a Capitalization Table Discusses how to best present a financial model Incorporating financial models into business decisions has become an essential element of good business practice, and this book will show you how to excel at this endeavor.

Intermediate Financial Theory

Intermediate Financial Theory PDF Author: Jean-Pierre Danthine
Publisher: Elsevier
ISBN: 0080509029
Category : Business & Economics
Languages : en
Pages : 392

Get Book

Book Description
The second edition of this authoritative textbook continues the tradition of providing clear and concise descriptions of the new and classic concepts in financial theory. The authors keep the theory accessible by requiring very little mathematical background. First edition published by Prentice-Hall in 2001- ISBN 0130174467. The second edition includes new structure emphasizing the distinction between the equilibrium and the arbitrage perspectives on valuation and pricing, as well as a new chapter on asset management for the long term investor. "This book does admirably what it sets out to do - provide a bridge between MBA-level finance texts and PhD-level texts.... many books claim to require little prior mathematical training, but this one actually does so. This book may be a good one for Ph.D students outside finance who need some basic training in financial theory or for those looking for a more user-friendly introduction to advanced theory. The exercises are very good." --Ian Gow, Student, Graduate School of Business, Stanford University Completely updated edition of classic textbook that fills a gap between MBA level texts and PHD level texts Focuses on clear explanations of key concepts and requires limited mathematical prerequisites Updates includes new structure emphasizing the distinction between the equilibrium and the arbitrage perspectives on valuation and pricing, as well as a new chapter on asset management for the long term investor

Structured Finance

Structured Finance PDF Author: Charles-Henri Larreur
Publisher: John Wiley & Sons
ISBN: 1119371104
Category : Business & Economics
Languages : en
Pages : 400

Get Book

Book Description
Comprehensive coverage of all major structured finance transactions Structured Finance is a comprehensive introduction to non-recourse financing techniques and asset-based lending. It provides a detailed overview of leveraged buyouts, project finance, asset finance and securitisation. Through thirteen case studies and more than 500 examples of companies, the book offers an in-depth analysis of the topic. It also provides a historical perspective of these structures, revealing how and why they were initially created. Instruments within each type of transaction are examined in detail, including Credit Default Swaps and Credit Linked Notes. A presentation of the Basel Accords offers the necessary background to understand the regulatory context in which these financings operate. With this book, readers will be able to: Delve into the main structured finance techniques to understand their components, mechanisms and how they compare Understand how structured finance came to be, and why it continues to be successful in the modern markets Learn the characteristics of financial instruments found in various structured transactions Explore the global context of structured finance, including the regulatory framework under which it operates Structured Finance provides foundational knowledge and global perspective to facilitate a comprehensive understanding of this critical aspect of modern finance. It is a must-read for undergraduate and MBA students and finance professionals alike.

Building Financial Models

Building Financial Models PDF Author: John S. Tjia
Publisher: McGraw Hill Professional
ISBN: 0071442820
Category : Business & Economics
Languages : en
Pages : 354

Get Book

Book Description
Financial modeling is essential for determining a company's current value and projecting its future performance, yet few books explain how to build models for accurately interpreting financial statements. Building Financial Models is the first book to correct this oversight, unveiling a step-by-step process for creating a core model and then customizing it for companies in virtually any industry. Covering every aspect of building a financial model, it provides a broad understanding of the actual mechanics of models, as well as their foundational accounting and finance concepts.