How can I get the the goodwill impairment loss=42,000 in the end?

S HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Cut Arial -10 E Copy- -AA &-A Format Painter BIU. FILE Paste Clipboard Font E24 1 X fx =C6-E22 A 1 INTERMEDIATE ACCOUNTING 2 CHAPTER 11 GOODWILL 3 4 GIVEN: 5 6 ABC PURCHASED 100% OF TNT CORP ASSETS & LIAB 7 8 TNT BALANCE SHEET PRIOR TO PURCHASE 9 10 11 12 ABC'S REVIEW HAS FOUND THE FOLLOWING INFO: 13 14 TNT LICENSE (UNRECORED) 15 PP&E FAIR VALUE 16 17 REQUIRED: PREPARE AN ANALYSIS OF 18 TNT'S NET ASSETS 19 20 21 22 23 24 25 26 REQUIRED: PREPARE ABC'S JOURNAL ENTRY 27 28 29 30 31 32 33 READY === 2. Wrap Text === **Merge & Center. Alignment D FOR THE PURCHASE OF TNT'S ASSETS & LIAB: Sheet1 Sheet2 Sheet3 Type here to search B E 50,000 22,000 240,000 312,000 50,000 22,000 75,000 300,000 (34,000) 413,000 59,000 50,000 22,000 75,000 300,000 59,000 CASH 506,000 O . 472,000 $ CASH AR PP&E CASH AR LICENSE PP&E AP NET ASSETS IMPLIED GOODWILL CASH AR LICENSE PP&E GOODWILL AP Chapter11Goodwill [Compatibility Mode] - Excel Accounting P Normal $%+Conditional Format as Neutral Formatting Table Number F G H I J K 34,000 100,000 178,000 312,000 75,000 300,000 LIAB CS RE 34,000 472,000 506,000 Page Bad Calculation Styles L E x] 22 M > of 24 Good Check Cell N 0 O XxX F Insert Delete Format Cells P Q ZOOM AutoSum Fill Clear- R 13- Arhous@cox.net AT M Sort & Find & Filter Select Editing i S 12:23 PM 5/24/2020 T D S FILE HOME X Cut Copy Paste 171 A INSERT Format Painter Clipboard Chapter11Goodwill2 [Compatibility Mode] - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW Arial -A A *- Wrap Text - -10 BIU---A- =====Merge & Center 12 Normal *Conditional Format as Neutral Formatting Table - Font 1 Alignment S fix A E G H J K 70 71 CARRYING VALUE FAIR VALUE 72 73 74 YEAR 5 REPORTING UNIT DATA 25,000 25,000 CASH AR 75 9,000 9,000 76 21,000 27,000 77 LICENSE PP&E GOODWILL 262.000 266,000 78 155,000 79 AP (60,000) (60,000) 80 412,000 267,000 (IDENTIFIABLE NET ASSETS) 81 82 YEAR 5 REPORTING UNIT FV 380,000 83 84 REQUIRED: CALCULATE GOODWILL IMPAIRMENT FOR 85 BOTH PRE AND POST DECEMBER 15, 2019 ACCOUNTING PERIODS 86 87 88 REQUIRED: DETERMINE IF GOODWILL IMPAIRMENT EXISTS 380,000 FAIR VALUE CARRYING VALUE 89 412,000 90 DIFFERENCE (32,000) IMPAIRMENT EXISTS 91 92 REQUIRED: CALCULATE GOODWILL IMPAIRMENT FAIR VALUE 380,000 93 FAIR VALUE IMPLIED GOODWILL (267,000) IDENTIFIABLE NET ASSETS 113,000 94 95 96 IMPAIRMENT 42,000 97 98 NOTE: REVISED IMPAIRMENT RULES FOR PUBLIC SEC FILERS FOR ACOUNTING PERIODS BEGINNING AFTER DECEMBER 15TH, 2019 99 100 FAIR VALUE CARRYING VALUE IMPAIRMENT 380,000 412,000 101 102 32,000 GW IMPAIRMENT IS LESS GIVEN INCREASE IN LICENSE & PP&E FAIR VALUES Sheet1 Sheet2 Sheet3 + READY P x Type here to search B Oe D General $ % Page Bad Calculation Styles L Number F 24 of 24 O XX PA Insert Delete Format Cells ZOOM ? 15- Arvhous@cox.net AT M Sort & Find & Filter - Select - T AutoSum Good Check Cell Fill Clear M N 0 P Q R S NOTE: UNRELATED TO PREVIOUS SCREEN # (?) ^ 49 Editing 1:37 PM 12/4/2020