WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Accounting Tutorials » Assets Tutorials » Goodwill Formula

Goodwill Formula

Goodwill formula calculates the value of the goodwill by subtracting the fair value of net identifiable assets of the company to be purchased from the total purchase price; fair value of net identifiable assets is calculated by deducting the fair value of the net liabilities from the sum of the fair value of all the assets.

What is Goodwill Formula?

The term “goodwill” refers to that intangible asset that comes into play only when a company is planning to acquire another company and is willing to pay a price that is significantly higher than the fair market value of the net assets of the company. In short, the goodwill can be seen as the difference between the purchase price and the fair market value of a company’s identifiable assets and liabilities.

The calculation of the goodwill equation is done by adding the consideration paid, the fair value of non-controlling interests, and the fair value of previous equity interests and then deducting the fair value of net assets of the company.

The goodwill calculation method is represented as,

Goodwill Formula = Consideration paid + Fair value of non-controlling interests + Fair value of equity previous interests – Fair value of net assets recognized.
Goodwill Formula

Steps / Method to Calculate Goodwill

The goodwill can be calculated by using the following five simple steps:

Step 1: Firstly, determine the consideration paid by the acquirer to the seller, and it will be available as part of the deal contract. The consideration is valued either by a fair valuation method or the share-based payment method. The consideration may be paid in the form of stocks, cash, or cash-in-kind.

Step 2: Next, determine the fair value of the non-controlling interest in the acquired company. It is the portion of equity ownership in a subsidiary that is not attributable to the parent company.

Step 3: Next, determine the fair value of equity in previous interests.

Step 4: Next, figure out the fair value of the net assets recognized in the acquired company. It is basically the net of the fair value of assets and the fair value of liabilities. It is easily available in the balance sheet.

Step 5: Finally, the goodwill equation is calculated by adding the consideration paid (step 1), non-controlling interests (step 2), and the fair value of previous equity interests (step 3) and then deducting the net assets of the company (step 4) as shown below.

Goodwill Formula = Consideration paid + Fair value of non-controlling interests + Fair value of equity previous interests – Fair value of net assets recognized

Examples of Goodwill Calculation Method (with Excel Template)

Let us look at some simple to advance examples of Goodwill Formula and calculation to understand it better.

You can download this Goodwill Formula Excel Template here – Goodwill Formula Excel Template

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Goodwill Calculation – Example#1

Let us take the example of company ABC Ltd which has agreed to acquire company XYZ Ltd. The purchase consideration is $100 million in order to obtain a 95% stake in XYZ Ltd. As per an esteemed valuation company, the fair value of the non-controlling interest is $12 million. It is also estimated that the fair value of identifiable assets and liabilities to be acquired is $200 million and $90 million, respectively. There are no equity interests. Calculate the goodwill based on the given information.

Given,

  • Consideration paid = $100 million
  • Fair value of non-controlling interests = $12 million
  • The fair value of equity previous interests = $0

Below is given data for calculation of goodwill of company ABC Ltd

Goodwill Formula Eg1

First, we need to calculate Net identifiable assets of company ABC Ltd

Therefore, Net identifiable assets = Fair value of identifiable assets – Fair value of identifiable liabilities

= $200 million – $90 million

Goodwill Formula Eg1.1png

Net Identifiable Assets = $110 million

Therefore, the method to calculate goodwill will be as follows,

Goodwill Equation = Consideration paid + Fair value of non-controlling interests + Fair value of equity previous interests – Fair value of net assets recognized

Goodwill Formula Eg1.3png

Goodwill formula = $100 million + $12 million + $0 – $110 million

= $2 million

Goodwill Formula Eg1.4png

Therefore, the goodwill generated in the transaction is $2 million.

Goodwill Calculation – Example#2

Let us take another example of Company A, which is planning to acquire Company B. The acquisition consideration is agreed at $90,000. The following information is available with respect to the Company.

Given,

  • Consideration paid = $90,000
  • Fair value of non-controlling interests = $0
  • The fair value of equity previous interests = $0

Below given table shows data for calculation of goodwill of Company A

Goodwill Formula Eg2

Therefore, Net Identifiable Assets of Company A can be calculated as,

Net Identifiable Assets = Fair value of identifiable assets – Fair value of identifiable liabilities

= $300,000 – $220,000

Goodwill Formula Eg2.1png

Net Identifiable Assets = $80,000

Therefore, the calculation of Goodwill will be as follows,

Goodwill = Consideration paid + Fair value of non-controlling interests + Fair value of equity previous interests – Fair value of net assets recognized

Goodwill Formula Eg2.1png

Goodwill calculation = $90,000 + $0 + $0 – $80,000

= $10,000

Goodwill Formula Eg2.2png

Therefore, the goodwill generated in the transaction is $10,000

Goodwill Formula Calculator

You can use this Goodwill Formula Calculator

Consideration Paid
Fair Value of Non-controlling Interests
Fair Value of Equity Previous Interests
Fair Value of Net Assets Recognized
Goodwill Formula =
 

Goodwill Formula = Consideration Paid + Fair Value of Non-controlling Interests + Fair Value of Equity Previous Interests − Fair Value of Net Assets Recognized
0 + 0 + 0 − 0 = 0

Relevance and Uses of Goodwill Formula

It is very important to understand the concept of goodwill because it is the metric that encapsulates the value of the reputation of a company built over a significant period of time. The different factors aiding the goodwill include (not exhaustive) company’s brand name, extensive customer base, good customer relations, any proprietary patents or technology, and excellent employee relations.

This brand value ensures that future profits can be expected to be over and above normal profits. Nevertheless, goodwill is an intangible asset that can neither be seen nor be felt, although it exists in reality and can be purchased and sold. In case of a distress sale i.e., when a company is acquired for less than its tangible net worth, then the target company is said to have ‘negative goodwill.’ The appropriate pricing for goodwill is extremely difficult, but it does make a commercial enterprise more valuable.

Under IFRS and US GAAP standards, goodwill is considered as an intangible asset with an indefinite life, and as such, there is no requirement to amortize the value. However, it should be evaluated every year for impairment loss. Most of the companies prefer to amortize goodwill over the period of 10 years.

Recommended Articles

This article has been a guide to Goodwill Formula. Here we discuss the Goodwill Calculation Method using practical examples along with downloadable excel templates. You may learn more about Financial Analysis from the following articles –

  • Net Asset Formula
  • Intangible Assets Examples
  • Goodwill Valuation
  • Negative Goodwill
9 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download Goodwill Formula Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More