Financial Modeling and Valuation: A Practical Guide to Investment Banking and Pr-经管之家官网！

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.
Editorial ReviewsReview"Paul Pignataro has written a book that even "dummies" can understand. In Financial Modeling and Valuation: A Practical Guide to Investment Banking and Private Equity (Wiley, 2013), he takes Wal-Mart (WMT) as a case study and walks the reader step by step through its financials as well as the Excel key strokes required to hardcode them....."
- Brenda Jubin - Seeking Alpha
Remaining article found at seekingalpha.com/article/1567402-paul-pignataros-financial-modeling-and-valuation
From the Inside FlapAs 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 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.
Product Details

• Hardcover: 432 pages
• Publisher: Wiley; 1 edition (July 10, 2013)
• Language: English
• ISBN-10: 1118558766
• ISBN-13: 978-1118558768
  

「经管之家」APP：经管人学习、答疑、交友，就上经管之家！
免流量费下载资料----在经管之家app可以下载论坛上的所有资源，并且不额外收取下载高峰期的论坛币。
涵盖所有经管领域的优秀内容----覆盖经济、管理、金融投资、计量统计、数据分析、国贸、财会等专业的学习宝库，各类资料应有尽有。
来自五湖四海的经管达人----已经有上千万的经管人来到这里，你可以找到任何学科方向、有共同话题的朋友。
经管之家（原人大经济论坛），跨越高校的围墙，带你走进经管知识的新世界。
扫描下方二维码下载并注册APP