Shopping Cart

Time Savings Sheets

Easy to Use & Implement

Instant Download


Need custom solutions?

  • USD
  • EUR
  • GBP

Work smart, not hard - use our Dashboards!

Remember, you can use our products to run your business, but you can’t resell them!

*NEW* Goodwill Impairment test

USD$ 19,00

(3 customer reviews)

Looking for a Goodwill Impairment test Excel Template? Check your Fair Value and Carrying amount with our ready-to-use template. Test Goodwill impairment now!

Compatible: Excel 2013, 2016, 2019, 365, Google Sheets

  • USD
  • EUR
  • GBP

30-Days Return

Secure Checkout

Instant Download

Work smart, not hard - use our Dashboards!

Goodwill Impairment test Excel Template

You’re probably looking for a ready-made template for Goodwill Impairment Test, but all you find is advice or complex rules US GAAP, IFRS, etc. However, there’s no working example or template to fill with your data.

Our Goodwill Impairment Test Excel template will check if Goodwill has been impaired in your company. Moreover, the template will show you whether you should do a test this year, and also what you should pay attention to. The template is simple and accessible, it has 2 types of test.


simple impairment test Excel



  • Test of indication of impairment
  • 2 tests of goodwill impairment in one file
  • “How to” sheet
  • Macro free Dashboard (Without VBA)!
  • Easy to use the model
  • Printable
  • Best for private companies
  • Modern design
  • Light and efficient
  • Ready-to-use template

What Is Goodwill?

In general, Goodwill is an intangible asset associated with the purchase of one company by another. Recorded when the purchase price is higher than the sum of the fair value of all assets purchased in the acquisition and the liabilities assumed in the process. It could the value of a company’s brand name, customer base, employee relations, customer relations, and other added value.

What is Impairment?

Impairment describes a permanent reduction in the value of a company’s asset, normally a fixed asset. When testing for impairment, the profit generated by a specific asset is periodically or annually compared with that same asset’s book value. There’s impairment when the book value of the asset exceeds the cash flow or benefit of the asset. Therefore the difference is written off and the value of the asset declines on the company’s balance sheet. The template will support you to answer your questions about the frequency of the goodwill impairment test or what is the discount rate and carrying value.

How about financial reporting standards?

It should be noted that the product is not a financial report template. However, the template was created on the basis of US GAAP (two steps) and IFRS (IAS 36 survey questionnaires) in order to simplify, fast verification, and calculate if there was an impairment of goodwill.

Do you know how to identify a company’s assets?

Check Financial Statement Analysis and take your finances in your hands and analyze your Cash Flow, EBIT, and more indicators!

How to use it?

The use of the product is very easy! You have 2 possible tests to perform:

  • Simple – when you know Fair Value
  • Extended – when you don’t know Fair Value and need to calculate it

current goodwill impairment test gaap

In each test, you must enter the values from the balance sheet, i.e. the values for Assets (including Goodwill value) and Liabilities. For the Extended test, you should provide also Cash Income & Outcome for the current year in order to get Fair Value.

discount rate for goodwill impairment test

And that’s it!
This is the basis to perform a calculation to check if there’s an impairment and how much loss is there in goodwill.

Percentage for goodwill impairment test calculation steps


  • Excel file (2007+)
  • Info with discount code
  • Link to Google Sheets

3 reviews for *NEW* Goodwill Impairment test

  1. Me me and me

    Great communication with the store. Quick service and high-quality work. Would recommend.

  2. South

    Happy to use that goodwill calculator

  3. Mia

    Nice! Cheap & nice tool

Add a review

Your email address will not be published. Required fields are marked *

No time to learn Excel? No problem.

Consider Premium version

Would you like to get a high-end custom Dashboard?

You may also like

Instant Download

A few seconds and the dashboard is yours

Friendly Refund Policy

30 days money back guarantee

High Quality Spreadsheet

Automate your work like never before

100% Secure Checkout

PayPal / MasterCard / Visa

Free excel templates download now

Instant download

The link will be sent to your email

Check your license





Commercial use:
Remember, you can use our products to run your business, but you can't resell them!

Reseller license:
To request products and rights for reselling, please contact

  • *Editable: Modifiable/Professional/Business: Sheets are protected due to unexpected formula modification. You can unprotect sheets. No password is required
  • *VBA code: Templates using the VBA code are marked with the appropriate information in the description
  • *Support: We help in the implementation of the file and in small modifications of the template
  • *Users: If you intend to have more than 5 users or copies of the template, then you must choose the Business license.
  • *Apps: VBA supported templates are available only on MS Excel.

Take 15% off

Your First Order


Analytics by Conversios