Practical Financial Modelling

Practical Financial Modelling

Author: Jonathan Swan

Publisher: Butterworth-Heinemann

ISBN: 0080570119

Category: Business & Economics

Page: 304

View: 540

This second edition of Practical Financial Modelling is vital tool for all finance and management professionals whose work involves the production and development of complex spreadsheets and financial models. The author bridges the gap between the Excel manual and financial literature with a wealth of practical advise and useful tips. The book identifies good practice and highlights those areas which are prone to error and inconsistency resulting in a refreshingly simple approach to building and using financial models suitable for novice and experienced modellers. By using practical worked examples the most effective ways in which problems can be solved are explored. Key themes include: model structure, audit formulae and functions and model use. New to the second edition: Instructive information on Excel 2007 and its enhanced modelling functions and feature; Risk controls in developing and using financial models; Test-yourself modelling problems and applied examples in every chapter; Substantial information related to reporting and charting techniques and an appendix devoted to parallel comparison of how-to in Excel 2003 and 2007. • Instructive information on Excel 2007 and its enhanced modelling functions and features • Risk controls in developing and using financial models • Test-yourself modelling problems and applied examples in every chapter • Substantial information relating to reporting and charting techniques • An appendix devoted to a parallel comparison of how-to in Excel 2003 and Excel 2007

Financial Modeling

Financial Modeling

Author: Joachim Häcker

Publisher: Springer

ISBN: 9781137426581

Category: Business & Economics

Page: 956

View: 886

This book provides a comprehensive introduction to modern financial modeling using Excel, VBA, standards of financial modeling and model review. It offers guidance on essential modeling concepts around the four core financial activities in the modern financial industry today: financial management; corporate finance; portfolio management and financial derivatives. Written in a highly practical, market focused manner, it gives step-by-step guidance on modeling practical problems in a structured manner. Quick and interactive learning is assured due to the structure as a training course which includes applied examples that are easy to follow. All applied examples contained in the book can be reproduced step by step with the help of the Excel files. The content of this book serves as the foundation for the training course Certified Financial Modeler. In an industry that is becoming increasingly complex, financial modeling is a key skill for practitioners across all key sectors of finance and banking, where complicated problems often need to be solved quickly and clearly. This book will equip readers with the basic modeling skills required across the industry today.

Financial Modeling and Valuation

Financial Modeling and Valuation

Author: Paul Pignataro

Publisher: John Wiley & Sons

ISBN: 9781118558690

Category: Business & Economics

Page: 432

View: 707

Written by the Founder and CEO of the prestigious New YorkSchool of Finance, this book schools you in the fundamental toolsfor accurately assessing the soundness of a stock investment. Builtaround a full-length case study of Wal-Mart, it shows you how toperform an in-depth analysis of that company's financial standing,walking you through all the steps of developing a sophisticatedfinancial model as done by professional Wall Street analysts. Youwill construct a full scale financial model and valuationstep-by-step as you page through the book. When we ran this analysis in January of 2012, we estimated thestock was undervalued. Since the first run of the analysis, thestock has increased 35 percent. Re-evaluating Wal-Mart9months later, we will step through the techniques utilized by WallStreet analysts to build models on and properly value businessentities. Step-by-step financial modeling - taught using downloadableWall Street models, you will construct the model step by step asyou page through the book. Hot keys and explicit Excel instructions aid even the noviceexcel modeler. Model built complete with Income Statement, Cash FlowStatement, Balance Sheet, Balance Sheet Balancing Techniques,Depreciation Schedule (complete with accelerating depreciation anddeferring taxes), working capital schedule, debt schedule, handlingcircular references, and automatic debt pay downs. Illustrative concepts including detailing model flows help aidin conceptual understanding. Concepts are reiterated and honed, perfect for a novice yetdetailed enough for a professional. Model built direct from Wal-Mart public filings, searchingthrough notes, performing research, and illustrating techniques toformulate projections. Includes in-depth coverage of valuation techniques commonlyused by Wall Street professionals. Illustrative comparable company analyses - built the right way,direct from historical financials, calculating LTM (Last TwelveMonth) data, calendarization, and properly smoothing EBITDA and NetIncome. Precedent transactions analysis - detailing how to extractproper metrics from relevant proxy statements Discounted cash flow analysis - simplifying and illustratinghow a DCF is utilized, how unlevered free cash flow is derived, andthe meaning of weighted average cost of capital (WACC) Step-by-step we will come up with a valuation on Wal-Mart Chapter end questions, practice models, additional case studiesand common interview questions (found in the companion website)help solidify the techniques honed in the book; ideal foruniversities or business students looking to break into theinvestment banking field.

Securitization and Structured Finance Post Credit Crunch

Securitization and Structured Finance Post Credit Crunch

Author: Markus Krebsz

Publisher: John Wiley & Sons

ISBN: 0470662123

Category: Business & Economics

Page: 476

View: 284

In this book, you will be introduced to generic best practice principles for a post credit crunch market. First, the book takes a closer look at the reasons why the market froze during the 2007 to 2009 credit crisis. Then you will learn how to use the principles explained here in your generic deal's typical life cycle stages. Throughout, each stage is discussed in detail, from strategy and feasibility, pre-close, at close, and post close. The final section of the book contains a toolbox of references, tables, dictionaries, and resources.

Financial Modeling, fourth edition

Financial Modeling, fourth edition

Author: Simon Benninga

Publisher: MIT Press

ISBN: 9780262027281

Category: Business & Economics

Page: 1144

View: 108

A substantially revised edition of a bestselling text combining explanation and implementation using Excel; for classroom use or as a reference for finance practitioners. Financial Modeling is now the standard text for explaining the implementation of financial models in Excel. This long-awaited fourth edition maintains the “cookbook” features and Excel dependence that have made the previous editions so popular. As in previous editions, basic and advanced models in the areas of corporate finance, portfolio management, options, and bonds are explained with detailed Excel spreadsheets. Sections on technical aspects of Excel and on the use of Visual Basic for Applications (VBA) round out the book to make Financial Modeling a complete guide for the financial modeler. The new edition of Financial Modeling includes a number of innovations. A new section explains the principles of Monte Carlo methods and their application to portfolio management and exotic option valuation. A new chapter discusses term structure modeling, with special emphasis on the Nelson-Siegel model. The discussion of corporate valuation using pro forma models has been rounded out with the introduction of a new, simple model for corporate valuation based on accounting data and a minimal number of valuation parameters. New print copies of this book include a card affixed to the inside back cover with a unique access code. Access codes are required to download Excel worksheets and solutions to end-of-chapter exercises. If you have a used copy of this book, you may purchase a digitally-delivered access code separately via the Supplemental Material link on this page. If you purchased an e-book, you may obtain a unique access code by emailing [email protected] or calling 617-253-2889 or 800-207-8354 (toll-free in the U.S. and Canada). Praise for earlier editions “Financial Modeling belongs on the desk of every finance professional. Its no-nonsense, hands-on approach makes it an indispensable tool.” —Hal R. Varian, Dean, School of Information Management and Systems, University of California, Berkeley “Financial Modeling is highly recommended to readers who are interested in an introduction to basic, traditional approaches to financial modeling and analysis, as well as to those who want to learn more about applying spreadsheet software to financial analysis." —Edward Weiss, Journal of Computational Intelligence in Finance “Benninga has a clear writing style and uses numerous illustrations, which make this book one of the best texts on using Excel for finance that I've seen.” —Ed McCarthy, Ticker Magazine

Mergers, Acquisitions, Divestitures, and Other Restructurings, + Website

Mergers, Acquisitions, Divestitures, and Other Restructurings, + Website

Author: Paul Pignataro

Publisher: John Wiley & Sons

ISBN: 9781118908716

Category: Business & Economics

Page: 368

View: 380

The authoritative resource for analyzing mergers and acquisitions (M&A) from every angle Paul Pignataro reveals the secrets behind growth through M&A in his new book, Mergers, Acquisitions, Divestitures, and Other Restructurings + Website. Through market shifts and regulatory changes, M&A has served as a solid approach to growth. Creating value through mergers and acquisitions is a highly coveted strategy, and Wall Street has long sought a clear technical understanding of the components of M&A as a key driver of growth. In this book, the author provides that understanding, covering all essential aspects of accounting and modeling for the M&A process. With over a decade of experience aiding billion-dollar restructuring deals, Paul Pignataro is in an excellent position to break down M&A from a finance standpoint. Mergers, Acquisitions, Divestitures, and Other Restructurings covers the financial accounting and modeling behind several M&A structures. Using the merger of Office Depot and Office Max, Mr. Pignataro fully addresses the entire integration, explains EBITDA, and other crucial performance measures. This text is for finance practitioners who want to explore every corner of the M&A process. Learn accounting for asset acquisitions, asset divestitures, and corporate mergers Explore modeling methods including mini-merger modeling and fully consolidated merger modeling Read case studies demonstrating the practical success of theoretical models Understand EBITDA, cash flow, capital structure, and their impact on M&A success and value creation This new text from the CEO and founder of the New York School of Finance is key for understanding how restructuring leads to growth and value creation. The importance of M&A shows no signs of slowing, meaning that finance professionals need to be able to accurately analyze the prospects and impacts of restructuring moves. Mergers, Acquisitions, Divestitures, and Other Restructurings + Website is the authoritative resource for doing just that.

Mergers, Acquisitions, and Other Restructuring Activities

Mergers, Acquisitions, and Other Restructuring Activities

Author: Donald DePamphilis

Publisher: Academic Press

ISBN: 9780323910545

Category: Business & Economics

Page: 608

View: 180

Mergers, Acquisitions, and Other Restructuring Activities: An Integrated Approach to Process, Tools, Cases, and Solutions, Eleventh Edition presents the most current and comprehensive M&A information available. Organized according to the context in which topics normally occur in the M&A process, the book covers M&A environments, M&A processes, M&A valuation and modeling, deal structuring and financing strategies, and alternative business and restructuring strategies. Covering industries worldwide, this new edition illustrates the most germane strategies and tactics in today's marketplace. It includes substantially more ancillary materials than previous editions, including an extensive test bank, chapter summaries, and instructor and student PowerPoint slides. More than 100 new references to relevant academic research published since 2018 make the 11th edition a balanced, comprehensive guide to the complex and dynamically changing world of M&A. Provides a rigorous discussion on the strengths and limitations of financial modeling as applied to M&A Includes more than 270 empirical studies published in leading peer-reviewed journals published 2018-2020, all new since the 10th edition (2019) Presents updated M&A tactics and strategies as well as court cases and new regulations governing business combinations, valuation methodologies, and financing

Private Capital Investing

Private Capital Investing

Author: Roberto Ippolito

Publisher: John Wiley & Sons

ISBN: 9781119526162

Category: Business & Economics

Page: 328

View: 281

A step-by-step, comprehensive approach to private equity and private debt Private Capital Investing: The Handbook of Private Debt and Private Equity is a practical manual on investing in the two of the most common alternative asset classes (private equity and private debt) and provides a unique insight on how principal investors analyze investment opportunities. Unlike other textbooks available in the market, Private Capital Investing covers the various phases that principal investors follow when analyzing a private investment opportunity. The book combines academic rigor with the practical approach used by leading institutional investors. Chapters are filled with practical examples, Excel workbooks (downloadable from the book website), examples of legal clauses and contracts, and Q&A. Cases are referred at the end of every chapter to test the learning of the reader. Instructors will find referrals to both third-party cases or cases written by the author. • Covers analytical tools • Includes the most common methods used to structure a debt facility and a private equity transaction • Looks at the main legal aspects of a transaction • Walks readers through the different phases of a transaction from origination to closing Bridging the gap between academic study and practical application, Private Capital Investing enables the reader to be able to start working in private equity or private debt without the need for any further training. It is intended for undergraduates and MBA students, practitioners in the investment banking, consulting and private equity business with prior academic background in corporate finance and accounting.

Finance

Finance

Author: Zvi Bodie

Publisher:

ISBN: STANFORD:36105025435533

Category: Business enterprises

Page: 522

View: 536

This introduction to finance has a broad scope, placing an emphasis on general principles within the field. It builds its presentation upon the three 'pillars' of finance: optimization over time, asset valuation and risk management.