Financial Modeling and Valuation - (Wiley Finance) 2nd Edition by Paul Pignataro (Hardcover) (2024)

About the Book

"The markets are vast and complex not only in the U.S. but globally. Everyone wants to make money. Yet, throughout the past years we have faced tremendous market swings rendering investors (and their money) in a sea of lost hopes, and few investors with a plethora of wealth. Many of these market anomalies and swings are dependent, and in a sense dictated, by the investor -- you. The investor sets the current stock price. The reaction of the investor determines the success of an IPO, an equity offering. Yes, the collective psychology of the market as a whole plays a major role, but if the everyday investor was better equipped with the proper tools to understand the underlying fundamentals of a rational investment, smarter investment decisions would be made, more rational investments will be made, and the markets would be a more efficient environment. This book sets to give any investor the fundamental tools to help determine if a stock investment is a rational one. The new edition of "Financial Modeling and Valuation" will be updated for 2020 and will be based on the new retail leader Amazon as opposed to Wal-Mart. A great introductory "thesis" to best transition from the old version to the new version will be based on the shift of the entire retail industry. There's a connection from old "mom and pop" produce companies of the early 1800s to the Great Atlantic and Pacific Company (A&P) to Wal-Mart, and now to Amazon in the progression of a "Retail Wheel". This is a great segway into the new book and can end with a though piece on where we will go next. Of course the focus of the book is technical but a couple of pages as an intro can give great context to the book. This book will give you the ability to build a financial model soup to nuts. You will not only build the core three statements - income statement, cash flow statement, balance sheet - but the three major supporting schedule necessary for full company valuation and analysis. A core explanation of each line item is included in addition to tips and techniques to use each line item as a tool to value and manage a business. Finally, applications are learned to fully understand a model's use including pricing a stock, raising debt, and raising equity"--

Book Synopsis

The fully revised new edition of the best-selling guide to using financial models to determine if a stock is over or undervalued

Written by the founder and CEO of the world-renowned New York School of Finance, Financial Modeling and Valuation provides clear and systematic guidance on accurately evaluating the soundness of a stock investment. This invaluable handbook equips investors with the tools necessary for understanding the underlying fundamentals of a rational investment and for making smarter investment decisions in any market environment.

Built around an in-depth case study of global retail leader Amazon, this fully updated Second Edition shows you how to analyze the financial standing of a company using the methods of Wall Street professionals. Step-by-step, you will learn to build the core three statements--income statement, cash flow statement, and balance sheet--as well as the three major supporting schedules required for complete company valuation and analysis. All line items are explained in clear language and include real-world tips and techniques for using them as tools for valuing and managing a business. This must-have guide:

  • Features new and in-depth case studies based on Amazon that simulate real-world modelling and valuation
  • Explains valuation techniques such as illustrative comparable company analysis, precedent transactions analysis, and discounted cash flow analysis
  • Covers all essential applications of a model, including pricing a stock, raising debt, and raising equity
  • Includes an introductory section describing the recent and dramatic shift of the entire retail industry
  • Provides end-of-chapter questions, downloadable practice models, additional case studies, and common interview questions via a companion website

Financial Modeling and Valuation: A Practical Guide to Investment Banking and Private Equity, Second Edition is essential reading for finance professionals, venture capitalists, individual investors, and students in investment banking and related degree programs in finance.

From the Back Cover

FINANCIAL MODELING AND VALUATION

A one-stop roadmap to building and using a financial model

Financial Modeling and Valuation is featured in over 600 universities and libraries throughout the world and has been translated to simplified Chinese.

The Second Edition of Financial Modeling and Valuation offers readers an authoritative and accessible guide to accurately modeling and valuing a company's stock based on its underlying fundamentals. The book provides a fulsome basis for the development of a complete financial model.

You'll learn to build the three core financial statements--the income statement, the statement of cash flows, and the balance sheet--as well as the three major supporting schedules necessary for a complete company valuation and analysis. You'll discover what each line item means and how to use them as tools to value and manage a business.

Ideal for retail investors, venture capitalists, and finance professionals, this latest edition of Financial Modeling and Valuation will prove to be an invaluable resource for students of business, finance, and investment banking at the undergraduate and graduate levels.

About the Author

PAUL PIGNATARO is Founder of the New York School of Finance, a world leader in providing finance education to banks, firms, and universities throughout the world. He is also Managing Partner of Caterson Consulting, a consulting firm providing merger, acquisition, and private equity services. He is the author of the Investment Banking and Private Equity in Practice series of books. Previously, Paul worked at TH Lee Putnam Ventures, a $1 billion private equity firm affiliated with buyout giant Thomas H. Lee Partners, and at Morgan Stanley, where he worked on various transactions in the technology, energy, transportation, and business services industries.

Financial Modeling and Valuation - (Wiley Finance) 2nd Edition by  Paul Pignataro (Hardcover) (2024)

FAQs

What is the best way to learn financial modeling and valuation? ›

Below are the commonly followed steps to build a financial model:
  1. Past Financial Data and Assumptions: ...
  2. Start With the Income Statement: ...
  3. The Balance Sheet: ...
  4. Develop the Supporting Schedules: ...
  5. Complete the Balance Sheet and Income Statement: ...
  6. Cash Flow Statement: ...
  7. DCF Analysis: ...
  8. Sensitivity Analysis and Scenario:
May 5, 2024

Is learning financial Modelling worth it? ›

Yes, financial modelling certification can enhance job prospects for fresh graduates by making them more competitive, showcasing practical skills, and opening doors to roles in investment banking, equity research, and corporate finance.

What is the difference between valuation and financial modeling? ›

Financial modelling refers to the process of creating mathematical representations of a company's financial situation. Valuation, on the other hand, involves determining the worth of a company, its assets, or its securities.

What does financial modelling include? ›

Financial modeling is the process of creating a summary of a company's expenses and earnings in the form of a spreadsheet that can be used to calculate the impact of a future event or decision.

Is financial modeling a hard class? ›

Learning financial modeling is challenging due to the complex formula logic and hidden assumptions involved. It requires technical and mathematical skills, as well as problem-solving and decision-making abilities. Financial modeling is more challenging to learn than accounting and investing.

How difficult is financial modelling? ›

You normally need to gain advanced Excel proficiency abilities, have an understanding of accounting and business, and be able to design simple models if you want to become proficient at financial Modeling. Compared to taking a course, learning financial Modeling on your own involves more work.

Which is better CFA or financial modelling? ›

Financial Modeling is like a sidekick to CFA—it's essential on its own. It's a practical program where you play with Excel, check out reports, and study how companies do their money stuff. While CFA teaches you big concepts, Financial Modeling gives you hands-on skills for real finance jobs.

Can I learn financial modeling on my own? ›

To become skilled at financial modeling, you typically need to develop advanced Excel proficiency skills, have accounting and business knowledge, and know how to create simple models. Learning financial modeling on your own requires more legwork than taking a course.

How many hours does it take to learn financial modelling? ›

It depends on person to person how fast their learning and grasping power is. However, the minimum time required to learn the fundamentals of Financial Modeling is 30 to 40 days on average. Financial modeling training is required to understand the drivers and consequences of organizational decisions.

What is the difference between valuation and finance? ›

The reason there is a difference is relatively simple; financial statements are not intended to place value on a business, but rather capture the historical transactions that the company has engaged in. A valuation report does what its name implies; it values the business based on future potential and opportunity.

What is financial modeling vs forecasting? ›

Forecasting helps a company's executive management determine where the company is headed. Calculating the financial impact of those forecasts is where financial modeling comes into play.

What are the 3 valuation of financial assets models? ›

The three widely used valuation methods used in business valuation include the Asset Approach, the Market Approach, and the Income Approach.

What software is best for financial modeling? ›

Oracle BI – This software is created by Oracle; it offers end-to-end financial supply chain solutions. Quantrix – This software is used by experts for developing future estimates, budgets, and plans. Business Objects– This Software is developed by the SAP; it helps in the data analysis of Business Intelligence.

How much do financial modelers make? ›

Financial Modeling Analyst Salary. $70,000 is the 25th percentile. Salaries below this are outliers. $116,500 is the 90th percentile.

What is ROI in financial modeling? ›

Return on investment (ROI) is an approximate measure of an investment's profitability. ROI is calculated by subtracting the initial cost of the investment from its final value, then dividing this new number by the cost of the investment, and finally, multiplying it by 100. ROI has a wide range of uses.

How to start learning financial modeling? ›

  1. STEP 1 : KNOW YOUR COMPANY. ...
  2. STEP 2 : UNDERSTAND THE INDUSTRY DYNAMICS. ...
  3. STEP 3 : START WITH THE AUDITED NUMBERS. ...
  4. STEP 5 : FORECAST THE INCOME STATEMENT. ...
  5. STEP 6 : PREPARE THE SUPPORTING SCHEDULES. ...
  6. STEP 7 : COMPLETE STATEMENT OF PROFIT & LOSS (P&L) AND BALANCE SHEET. ...
  7. STEP 8 : COMPLETE THE CASH FLOW STATEMENT:
May 20, 2023

Can you teach yourself financial modeling? ›

To become skilled at financial modeling, you typically need to develop advanced Excel proficiency skills, have accounting and business knowledge, and know how to create simple models. Learning financial modeling on your own requires more legwork than taking a course.

How to learn financial valuation? ›

Top Valuation Courses
  1. Audit a Financial Model With Macabacus. Level 3. ...
  2. Build a Presentation with Macabacus. Level 2. ...
  3. Corporate Finance Fundamentals. Level 2. ...
  4. Comparable Valuation Analysis. Level 5. ...
  5. Math for Finance Professionals. Level 2. ...
  6. DCF Valuation Modeling. ...
  7. Real Estate Financial Modeling. ...
  8. Introduction to Business Valuation.

How do I learn financial modelling skills? ›

The best way to learn financial modeling is to practice. It takes years of experience to become an expert at building financial models, and you really have to learn by doing. Reading equity research reports can be helpful, as they give you something to compare your results to.

Top Articles
Latest Posts
Article information

Author: Velia Krajcik

Last Updated:

Views: 6370

Rating: 4.3 / 5 (54 voted)

Reviews: 93% of readers found this page helpful

Author information

Name: Velia Krajcik

Birthday: 1996-07-27

Address: 520 Balistreri Mount, South Armand, OR 60528

Phone: +466880739437

Job: Future Retail Associate

Hobby: Polo, Scouting, Worldbuilding, Cosplaying, Photography, Rowing, Nordic skating

Introduction: My name is Velia Krajcik, I am a handsome, clean, lucky, gleaming, magnificent, proud, glorious person who loves writing and wants to share my knowledge and understanding with you.