Financial Modeling and Valuation: A Practical Guide to Investment Banking and Private Equity
Written by the Founder and CEO of the prestigious New York School of Finance, this book schools you in the fundamental tools for accurately assessing the soundness of a stock investment. Built around a full-length case study of Wal-Mart, it shows you how to perform an in-depth analysis of that company's financial standing, walking you through all the steps of developing a sophisticated financial model as done by professional Wall Street analysts. You will construct a full scale financial model and valuation step-by-step as you page through the book. When we ran this analysis in January of 2012, we estimated the stock was undervalued. Since the first run of the analysis, the stock has increased 35 percent. Re-evaluating Wal-Mart 9months later, we will step through the techniques utilized by Wall Street analysts to build models on and properly value business entities. Step-by-step financial modeling - taught using downloadable Wall Street models, you will construct the model step by step as you page through the book. Hot keys and explicit Excel instructions aid even the novice excel modeler. Model built complete with Income Statement, Cash Flow Statement, Balance Sheet, Balance Sheet Balancing Techniques, Depreciation Schedule (complete with accelerating depreciation and deferring taxes), working capital schedule, debt schedule, handling circular references, and automatic debt pay downs. Illustrative concepts including detailing model flows help aid in conceptual understanding. Concepts are reiterated and honed, perfect for a novice yet detailed enough for a professional. Model built direct from Wal-Mart public filings, searching through notes, performing research, and illustrating techniques to formulate projections. Includes in-depth coverage of valuation techniques commonly used by Wall Street professionals. Illustrative comparable company analyses - built the right way, direct from historical financials, calculating LTM (Last Twelve Month) data, calendarization, and properly smoothing EBITDA and Net Income. Precedent transactions analysis - detailing how to extract proper metrics from relevant proxy statements Discounted cash flow analysis - simplifying and illustrating how a DCF is utilized, how unlevered free cash flow is derived, and the 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 studies and common interview questions (found in the companion website) help solidify the techniques honed in the book; ideal for universities or business students looking to break into the investment banking field.
From the Back Cover Praise for Financial Modeling and Valuation In Financial Modeling and Valuation , Paul Pignataro provides individual investors with an easy-to-use, step-by-step method for analyzing companies and their securities using the same financial modeling techniques used by professionals. By using Walmart, an American icon that is familiar to all, as a case study, Paul makes financial modeling come alive. Paul trained our staff in Beijing and is exceptionally well qualified to write this book. --Jack Perkowski, Wall Street veteran; Author; and Founder and Managing Partner of JFP Holdings Ltd.; former CEO and Chairman, ASIMCO Technologies, one of the largest producers of automotive components in China Paul Pignataro's book is a treasure. He combines in one place a presentation of the concepts used in accounting and finance with the practical Excel ways to put them in action. This manual presents everything a student or a professional would like to understand about financial statements and valuation methods used in mergers and acquisitions. It is written in simple language, and the clarity of the exposé makes it a perfect companion for those who are involved in financial matters. --Georges Ugeux, Chairman and CEO, Galileo Global Advisors; Adjunct Professor, Columbia Law School; former Group Executive Vice President, New York Stock Exchange Financial Modeling and Valuation is a key handbook for investment banking professionals and business students looking to get into the field. As a founder of a leading investment banking, private equity and hedge fund recruiting business, and as the former head of the analyst program at Morgan Stanley, I know the importance of demonstrated proficiency in financial modeling and valuation both during the hiring process and on the job. Finally, there exists a book that actually goes through the model building and valuation process in complete detail with methodologies critical to both budding analysts and experienced professionals. --Eleni Henkel, Founder and Partner at Henkel Search Partners; former Managing Director and Global Head of Morgan Stanley's Analyst and Associate Programs Financial Modeling and Valuation offers an extensive overview of key fundamentals of investment banking, private equity, and M&A analysis. It will be of interest to students and discerning investors alike. --Professor Charles H. McGill, NYU Stern School of Business; Advisor with several leading private equity firms I thoroughly endorse this financial 'model' work of art! Financial modeling and valuation methods are an art form of comparable analysis with a wide range of variables that can be considered quite subjective in terms of which method should be utilized. To become and stay informed, these mentioned models or tools can identify the proper program of analysis for 'rationalizing' a potential investment. --Henry W. McCusker, Analyst, Journalist, and Publisher; Founder and Director of Research, Scimitar Equity This book contains all the basic concepts required to successfully apply for, and get a head start on, a career on Wall Street, whether as a sell-side analyst, an investment banker, or a private equity specialist. I especially value the focus on Walmart, because this company touches on so many sectors and trends in today's business world, from retailing to logistics to real estate. --Julio Marquez, Partner, Wyndham Global Partners
From the front Cover As underwriters for companies issuing securities, investment bankers put a lot on the line every day. That's why, before committing to a particular business, they go to great lengths to develop as clear and detailed a picture as possible of that company's current financial standing--and generate an accurate projection of its future performance. Likewise, as facilitators of mergers and acquisitions, investment bankers are tasked with finding answers to crucial questions such as, How much is the company really worth? Is its stock overvalued or undervalued, and, if so, what is the most correct stock price? But when it comes right down to it, investment bankers aren't all that different from you or any investor looking to make money in the stock market. Unlike you, though, the big banks employ armies of analysts trained in the most sophisticated financial modeling techniques. Designed to balance the scales and give individual investors like you the same competitive edge as today's most prestigious investment banks, Financial Modeling and Valuation arms you with many of the same analytical tools and techniques used by the likes of Goldman Sachs, JPMorgan Chase, and Bank of America Merrill Lynch. Written for complete novices and experienced professionals alike, Financial Modeling and Valuation is a highly accessible, step-by-step guide to understanding and performing fundamental analysis and stock valuation. Author Paul Pignataro, founder and CEO of the world-renowned New York School of Finance, takes a unique approach to educating you in the fundamental tools for assessing the soundness of a stock investment. Building on a book-length case study of Walmart, he shows you how to perform a deep-dive analysis of that company's financial standing, walking you through all the steps of developing a sophisticated financial model using a downloadable Excel template. While the first part of the book is devoted to building a complete financial model of past and future performance, the second part focuses on stock valuation. Once again taking Walmart as the example, Pignataro clearly and methodically shows you how to use the three analytical methods used by Wall Street analysts to determine whether a stock is overvalued, undervalued, or valued appropriately: comparable company analysis, discounted cash flow analysis, and precedent transaction analysis. As an added bonus, the Financial Modeling and Valuation companion website features a downloadable version of the Walmart model template, along with additional case studies, exercises, test questions, and a practice model and solution to let you test and fine-tune your analytical skills. Schooling you in time-tested financial modeling and stock valuation techniques used by analysts at the world's top investment banks, Financial Modeling and Valuation will help you make smarter, more rational investment decisions.