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


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




Intermediate Structured Finance Modeling


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.




QFINANCE: The Ultimate Resource, 4th edition


Book Description

QFINANCE: The Ultimate Resource (4th edition) offers both practical and thought-provoking articles for the finance practitioner, written by leading experts from the markets and academia. The coverage is expansive and in-depth, with key themes which include balance sheets and cash flow, regulation, investment, governance, reputation management, and Islamic finance encompassed in over 250 best practice and thought leadership articles. This edition will also comprise key perspectives on environmental, social, and governance (ESG) factors -- essential for understanding the long-term sustainability of a company, whether you are an investor or a corporate strategist. Also included: Checklists: more than 250 practical guides and solutions to daily financial challenges; Finance Information Sources: 200+ pages spanning 65 finance areas; International Financial Information: up-to-date country and industry data; Management Library: over 130 summaries of the most popular finance titles; Finance Thinkers: 50 biographies covering their work and life; Quotations and Dictionary.




QFINANCE


Book Description

QFINANCE: The Ultimate Resource (5th edition) is the first-step reference for the finance professional or student of finance. Its coverage and author quality reflect a fine blend of practitioner and academic expertise, whilst providing the reader with a thorough education in the may facets of finance.




QFinance


Book Description

Compiled by more than 300 of the world's leading professionals, visionaries, writers and educators, this is THE first-stop reference resource and knowledge base for finance. QFINANCE covers an extensive range of finance topics with unique insight, authoritative information, practical guidance and thought-provoking widsom. Unmatched for in-depth content, QFINANCE contains more than 2 million words of text, data analysis, critical summaries and bonus online content. Created by Bloomsbury Publishing in association with the Qatar Financial Centre (QFC) Authority, QFINANCE is the expert reference resource for finance professionals, academics, students, journalists and writers. QFINANCE: The Ultimate Resource Special Features: Best Practice and Viewpoint Essays – Finance leaders, experts and educators address how to resolve the most crucial issues and challenges facing business today. Finance Checklists – Step-by-step guides offer problem-solving solutions including hedging interest-rate risk, governance practices, project appraisal, estimating enterprise value and managing credit ratings. Calculations and Ratios – Essential mathematical tools include how to calculate return on investment, return on shareholders’ equity, working capital productivity, EVA, risk-adjusted rate of return, CAPM, etc. Finance Thinkers and Leaders – Illuminating biographies of 50 of the leading figures in modern finance including Joseph De La Vega, Louis Bachelier, Franco Modigliani, Paul Samuelson, and Myron Scholes Finance Library digests –Summaries of more than 130 key works ranging from “Against the Gods” to “Portfolio Theory & Capital Markets” and “The Great Crash”. Country and Sector Profiles – In-depth analysis of 102 countries and 26 sectors providing essential primary research resource for direct or indirect investment. Finance Information Sources – A select list of the best resources for further information on finance and accounting worldwide, both in print and online, including books, journal articles, magazines, internet, and organizations Finance Dictionary – A comprehensive jargon-free, easy-to-use dictionary of more than 9,000 finance and banking terms used globally. Quotations – More than 2,000 business relevant quotations. Free access to QFinance Online Resources (www.qfinance.com): Get daily content updates, podcasts, online events and use our fully searchable database.







Public Private Partnerships


Book Description

This timely new book provides an international perspective on Public Private Partnerships. Through 21 case studies, it investigates the existing and fast developing body of principles and practices from a wide range of countries and is the first book to bring together leading international academics and practitioners under a common framework that enables convenient cross-country comparisons. The authors focus on the impact of the financial crisis has had on how governments have reviewed and overhauled their PPP policies as they have examined or tested new ways of partnering more effectively, efficiently and sustainably with the private sector. Readers will be able to gauge the level of maturity of PPP development in the book’s case studies, understand similarities and differences in their practices, and gain useful insights into the regulatory framework and institutional infrastructure in place to support implementation of PPP. Finally, the book offers insights into the future challenges and opportunities that PPP offers stakeholders.




The Income Approach to Property Valuation


Book Description

The second edition of this comprehensive textbook is intended for both students and practitioners. It covers the changes in rating law, valuation and how the principles apply in practice. Throughout the book there are many examples illustrating valuation methods for the different types of property a practitioner is likely to deal with. Updates will include: Chapter on Exemptions and Reliefs to reflect the recent/forthcoming changes in legislation Chapter on Council Tax to reflect recent/forthcoming changes in legislation and the proposals for a revaluation of CT in England and Wales in 2006/2007 Chapter on Practice and procedure (appeals regulations, transition etc) New section on the Rating of Utilities New examples on rental analysis and valuation Complete updating of the book to ensure it is current and has regards to changes in approach, values etc. for 2005 Inclusion of even more summaries and key features at the end of each chapter.




Planning and Monitoring Design Work


Book Description

With the rise of "design and build" many more organisations are having to undertake design work; new project organisational structures are developing and many people are migrating into new roles. As a result of these changing times it is more important than ever that we understand that design work needs managed in a different way to many other construction operations. Planning and Monitoring of Design Work describes how to plan and control the progress of design work in the construction industry. It considers how the input of different design specialists should be integrated, from inception to site operations, to meet cost, time and quality objectives. The book provides a practical guide to the methodologies for the better planning of construction projects, and explains how planning and monitoring can help a construction organisation obtain good quality design information for tendering and construction purposes.




Structured Finance Modeling with Object-Oriented VBA


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.