› › Intermediate Structured Finance Modeling

Intermediate Structured Finance Modeling

Author : William Preinitz

Publisher : John Wiley & Sons

Page : 1032 pages

File Size : 20,87 MB

Release : 2010-12-28

Category : Business & Economics

ISBN : 0470928786

Get eBook

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.



Structured Finance Modeling with Object-Oriented VBA

Author : Evan Tick

Publisher : John Wiley & Sons

Page : 278 pages

File Size : 47,3 MB

Release : 2011-07-28

Category : Business & Economics

ISBN : 1118160665

Get eBook

Book Description

A detailed look at how object-oriented VBA should be used to model complex financial structures This guide helps readers overcome the difficult task of modeling complex financial structures and bridges the gap between professional C++/Java programmers writing production models and front-office analysts building Excel spreadsheet models. It reveals how to model financial structures using object-oriented VBA in an Excel environment, allowing desk-based analysts to quickly produce flexible and robust models. Filled with in-depth insight and expert advice, it skillfully illustrates the art of object-oriented programming for the explicit purpose of modeling structured products. Residential mortgage securitization is used as a unifying example throughout the text.



Modeling Structured Finance Cash Flows with Microsoft Excel

Author : Keith A. Allman

Publisher : John Wiley & Sons

Page : 230 pages

File Size : 32,90 MB

Release : 2010-12-28

Category : Business & Economics

ISBN : 1118044665

Get eBook

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.



Financial Modelling in Practice

Author : Michael Rees

Publisher :

Page : 270 pages

File Size : 11,7 MB

Release : 2008

Category : Corporations

ISBN : 9781118374658

Get eBook

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.



Financial Modelling in Practice

Author : Michael Rees

Publisher : John Wiley & Sons

Page : 304 pages

File Size : 16,23 MB

Release : 2011-11-09

Category : Business & Economics

ISBN : 1119995205

Get eBook

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. Based on the authors extensive experience of building models in business and finance, and of training others how to do so this book starts with a review of Excel functions that are generally most relevant for building intermediate and advanced level models (such as Lookup functions, database and statistical functions and so on). It then discusses the principles involved in designing, structuring and building relevant, accurate and readily understandable models (including the use of sensitivity analysis techniques) before covering key application areas, such as the modelling of financial statements, of cash flow valuation, risk analysis, options and real options. Finally, the topic of financial modelling using VBA is treated. Practical examples are used throughout and model examples are included in the attached CD-ROM. Aimed at intermediate and advanced level modellers in Excel who wish to extend and consolidate their knowledge, this book is focused, practical, and application-driven, facilitating knowledge to build or audit a much wider range of financial models. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.



Corporate and Project Finance Modeling

Author : Edward Bodmer

Publisher : John Wiley & Sons

Page : 628 pages

File Size : 35,82 MB

Release : 2014-11-10

Category : Business & Economics

ISBN : 1118854365

Get eBook

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.



Modeling Structured Finance Cash Flows with Microsoft Excel

Author : Keith A. Allman

Publisher : John Wiley & Sons

Page : 230 pages

File Size : 34,91 MB

Release : 2010-12-28

Category : Business & Economics

ISBN : 1118044665

Get eBook

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.



Elements of Structured Finance

Author : Ann Rutledge

Publisher : Oxford University Press

Page : 689 pages

File Size : 37,89 MB

Release : 2010-06-14

Category : Biography & Autobiography

ISBN : 0195179986

Get eBook

Book Description

For all but the most credit-worthy companies, it is more efficient to finance large pools of assets that have predictable behavioral characteristics through non-standard arrangements. These off-balance sheet structures allow credit exposures to be tailored to investor risk, asset class, and an ever-increasing diversity of idiosyncratic needs on the part of issuers and investors. The discipline that addresses these structures, which is called structured finance or securitization, is almost twenty years old, and has become a ubiquitous element of modern financial management. Yet, it has not been systematically covered in a textbook designed for both the school and workplace contexts.Elements of Structured Finance, the text version of a program of instruction in structured finance that the authors have offered at universities, private training programs, and consultancies, fills this void spectacularly. Raynes and Rutledge, two very highly regarded teachers and consultants in the field, bring clarity and logic to an inherently complex and frightening area of finance, using their extensive experience working with many of the top Wall Street securities houses. The book will start with the relatively simple concepts of static valuation models and the benchmark pool, and take the reader through the more esoteric features of dynamic risk analysis, thus serving as both an excellent introduction for the beginner and an essential reference for the professional. In addition to participants in structured finance programs, this book will appeal to structured finance analysts and managers at banks, asset management companies, insurance companies, and a wide variety of other corporations.



The Essentials of Financial Modeling in Excel

Author : Michael Rees

Publisher : John Wiley & Sons

Page : 342 pages

File Size : 23,41 MB

Release : 2023-02-06

Category : Business & Economics

ISBN : 1394157789

Get eBook

Book Description

A concise and practical guide to financial modeling in Excel In The Essentials of Financial Modeling in Excel: A Concise Guide to Concepts and Methods, veteran quantitative modeling and business analysis expert Dr. Michael Rees delivers a practical and hands-on introduction to financial modeling in Excel. The author offers readers a well-structured and strategic toolkit to learn modeling from scratch, focusing on the core economic concepts and the structures commonly required within Excel models. Divided into six parts, the book discusses the use of models and the factors to consider when designing and building models so that they can be as powerful as possible, yet simple. . Readers will also find: The foundational structures and calculations most frequently used in modeling, including growth- and ratio-based methods, corkscrews, and waterfall analysis Walkthroughs of economic modeling, measurement, and evaluation, and the linking of these to the decision criteria. These include breakeven and payback analysis, compounding, discounting, calculation of returns, loan calculations, and others Structured approaches for modeling in corporate finance, including financial statement modeling, cash flow valuation, cost of capital, and ratio analysis Techniques to implement sensitivity and scenario analysis Core aspects of statistical analysis, including data preparation, manipulation, and integration The use of approximately 100 Excel functions within example modeling contexts Further Topics Sections, which introduce advanced aspects of many areas, in order to provide further benefit to more advance readers, whilst presenting the truly essential topics separately. Examples of these include introductions to PowerQuery and PowerPivot, as well as advanced waterfall structures An invaluable, all-in-one blueprint for learning financial modeling in Excel, this book is ideal for beginning and intermediate financial professionals and students seeking to build and reinforce essential topics in financial modeling.



Principles of Financial Modelling

Author : Michael Rees

Publisher : John Wiley & Sons

Page : 546 pages

File Size : 17,94 MB

Release : 2018-03-19

Category : Business & Economics

ISBN : 1118904001

Get eBook

Book Description

The comprehensive, broadly-applicable, real-world guide to financial modelling Principles of Financial Modelling – Model Design and Best Practices Using Excel and VBAcovers the full spectrum of financial modelling tools and techniques in order to provide practical skills that are grounded in real-world applications. Based on rigorously-tested materials created for consulting projects and for training courses, this book demonstrates how to plan, design and build financial models that are flexible, robust, transparent, and highly applicable to a wide range of planning, forecasting and decision-support contexts. This book integrates theory and practice to provide a high-value resource for anyone wanting to gain a practical understanding of this complex and nuanced topic. Highlights of its content include extensive coverage of: Model design and best practices, including the optimisation of data structures and layout, maximising transparency, balancing complexity with flexibility, dealing with circularity, model audit and error-checking Sensitivity and scenario analysis, simulation, and optimisation Data manipulation and analysis The use and choice of Excel functions and functionality, including advanced functions and those from all categories, as well as of VBA and its key areas of application within financial modelling The companion website provides approximately 235 Excel files (screen-clips of most of which are shown in the text), which demonstrate key principles in modelling, as well as providing many examples of the use of Excel functions and VBA macros. These facilitate learning and have a strong emphasis on practical solutions and direct real-world application. For practical instruction, robust technique and clear presentation, Principles of Financial Modelling is the premier guide to real-world financial modelling from the ground up. It provides clear instruction applicable across sectors, settings and countries, and is presented in a well-structured and highly-developed format that is accessible to people with different backgrounds.