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 through the Founder and CEO of the distinguished ny university of Finance, this publication colleges you within the basic instruments for competently assessing the stability of a inventory funding. equipped round a full-length case examine of Wal-Mart, it exhibits you the way to accomplish an in-depth research of that company's monetary status, strolling you thru all of the steps of constructing a cosmopolitan monetary version as performed by means of specialist Wall highway analysts. you are going to build a whole 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 envisioned the inventory was once undervalued. because the first run of the research, the inventory has elevated 35 percent.  Re-evaluating Wal-Mart 9months later, we are going to step during the innovations used by Wall road analysts to construct types on and correctly worth enterprise entities.

  • Step-by-step monetary modeling - taught utilizing downloadable Wall highway types, you are going to build the version step-by-step as you web page in the course of the booklet.
    • Hot keys and specific Excel directions relief even the amateur excel modeler.
    • Model outfitted whole with source of revenue assertion, money circulate assertion, stability Sheet, stability Sheet Balancing ideas, Depreciation time table (complete with accelerating depreciation and deferring taxes), operating capital agenda, debt time table, dealing with round references, and automated debt pay downs.
    • Illustrative ideas together with detailing version flows aid reduction in conceptual understanding.
    • Concepts are reiterated and honed, ideal for a beginner but specific sufficient for a professional.
    • Model outfitted direct from Wal-Mart public filings, looking through notes, acting learn, and illustrating suggestions to formulate projections.
  • Includes in-depth insurance of valuation ideas favourite through Wall road execs.
    • Illustrative related corporation analyses - equipped the ideal method, direct from historic financials, calculating LTM (Last Twelve Month) info, calendarization, and correctly smoothing EBITDA and internet Income.
    • Precedent transactions research - detailing how you can extract right metrics from correct proxy statements
    • Discounted money movement research - simplifying and illustrating how a DCF is applied, how unlevered loose money movement is derived, and the that means of weighted standard rate of capital (WACC)
    • Step-by-step we'll get a hold of a valuation on Wal-Mart
  • Chapter finish questions, perform types, extra case reports and customary interview questions (found within the spouse site) support solidify the innovations honed within the ebook; perfect for universities or enterprise scholars seeking to holiday into the funding banking field.

Show sample text content

Download sample