Financial Modeling and Valuation: A Practical Guide to Investment Banking and Private Equity

Financial Modeling and Valuation: A Practical Guide to Investment Banking and Private Equity

Paul Pignataro


Written by way of the Founder and CEO of the distinguished manhattan institution of Finance, this e-book colleges you within the primary instruments for competently assessing the steadiness of a inventory funding. outfitted round a full-length case research of Wal-Mart, it indicates you ways to accomplish an in-depth research of that company's monetary status, strolling you thru the entire steps of constructing a cosmopolitan monetary version as performed via specialist Wall highway analysts. you are going to build an entire scale monetary version and valuation step by step as you web page throughout the book.

after we ran this research in January of 2012, we predicted the inventory used to be undervalued. because the first run of the research, the inventory has elevated 35 percent.  Re-evaluating Wal-Mart 9months later, we'll step throughout the recommendations used by Wall road analysts to construct versions on and correctly price enterprise entities.

  • Step-by-step monetary modeling - taught utilizing downloadable Wall road types, you are going to build the version step-by-step as you web page throughout the booklet.
    • Hot keys and specific Excel directions reduction even the amateur excel modeler.
    • Model outfitted entire with source of revenue assertion, money circulation assertion, stability Sheet, stability Sheet Balancing ideas, Depreciation agenda (complete with accelerating depreciation and deferring taxes), operating capital agenda, debt time table, dealing with round references, and automated debt pay downs.
    • Illustrative strategies together with detailing version flows support reduction in conceptual understanding.
    • Concepts are reiterated and honed, excellent for a beginner but specific sufficient for a professional.
    • Model equipped direct from Wal-Mart public filings, looking through notes, acting learn, and illustrating recommendations to formulate projections.
  • Includes in-depth assurance of valuation recommendations favourite by way of Wall road pros.
    • Illustrative similar corporation analyses - outfitted the perfect manner, direct from historic financials, calculating LTM (Last Twelve Month) facts, calendarization, and correctly smoothing EBITDA and web Income.
    • Precedent transactions research - detailing tips to extract right metrics from proper proxy statements
    • Discounted money circulate research - simplifying and illustrating how a DCF is applied, how unlevered loose funds stream is derived, and the which means of weighted ordinary rate of capital (WACC)
    • Step-by-step we are going to get a hold of a valuation on Wal-Mart
  • Chapter finish questions, perform types, extra case stories and customary interview questions (found within the significant other site) aid solidify the options honed within the ebook; perfect for universities or company scholars trying to holiday into the funding banking field.

Show sample text content

Download sample