Please help me with this assignment.

The original file is excel. you have to put the numbers in excel file according to book pics.

Also some pages require journal entry.

Proli Footwear AJE Control - Intangible Assets December 31, 2014 AJE Number Reference Accounts/Description x= account has impact on income before taxes impact on income before taxes amount = Account Number Debit DR/CR Credit Proli Footwear Amortization Policy December 31, 2014 Method Useful Life Salvage Value Trademarks Straight-line 40 years 0 Patents Straight-line 20 years 0 Goodwill: Sportech Co. Softshoe, Inc. Woodland Corporation Straight-line Straight-line Straight-line 40 years 5 years 40 years N/A N/A N/A Account Title Note 1: Per the client's policy and procedures manual, in the year of acquisition and disposal, 1/2 year amortization is taken. RP Note 2: Book and tax bases are the same for all buildings, leased buildings, and equipment (i.e. book depreciation = tax depreciation). acquired before 8/11/93 is still not deductible for tax purposes. RP Proli Footwear Amortization Schedule - Goodwill (Indefinite Life Intangible December 31, 2014 Description Goodwill: PER BOOKS Purchase of Dapper Manufacturing Co. Purchase of Softshoe, Inc. Purchase of Woodland Subtotal Goodwill Description Goodwill: PER AUDITORS Purchase of Dapper Manufacturing Co. Purchase of Softshoe, Inc. Purchase of Woodland Subtotal Goodwill Year Acquired Cost 2001 2012 2013 2,438,000 3,728,000 2,101,700 8,267,700 761,875 1,118,400 26,271 1,906,546 Adjusted Net Identifiable Carrying Value Assets, Excluding 1/1/2014 Goodwill Year Acquired 2001 2012 2013 Accumulated Amortization 12/31/2013 M M M 1,676,125 2,609,600 2,075,429 6,343,200 9,002,700 5,172,000 6,361,154 20,517,900 Note: The amortization method used by the client for goodwill is is straight-line over 4 straight-line over 5 years for Softshoe.. Goodwill is also subject to the impairment test using a two-step process. The fair value and then to the goodwill. Therefore, the amortization expense for 2014 needs to be rev (i.e. book value) of the goodwill as of January 1, 2014. RP AJE 6B-3 Accumulated Amortization859,093 Amortization Expense 859,093 M = Traced the authorization to purchase the company and the purchase price to the Bo roli Footwear Goodwill (Indefinite Life Intangibles) ember 31, 2014 Carrying Value 12/31/2013 1,676,125 2,609,600 2,075,429 6,361,154 Expense 2014 60,950 745,600 52,543 859,093 >>> Net Assets Including Fair Goodwill Value Accumulated Amortization 12/31/2014 822,825 1,864,000 78,814 2,765,639 Carrying Value 12/31/2014 1,615,175 1,864,000 2,022,886 5,502,061 Fair Value Test of Goodwill Impairment Implied Loss Fair Value Yes/No of Goodwill Calculated Impairment Loss Amount ill is is straight-line over 40 years for Dapper and Woodland and tep process. The fair value test is applied first to the reporting unit se for 2014 needs to be reversed to properly show the carrying value he purchase price to the Board of Directors' minutes. Proli Footwear Amortization Schedule - Patents (Limited Life Intangibles) December 31, 2014 Description Patents: PER BOOKS Patent #2698 Patent #6974 Patent #9767 Subtotal Patents Year Acquired 1950 1999 2010 Cost M M M Year Description Acquired Patents: PER AUDITORS Patent #2698 1950 M Patent #6974 1999 M Patent #9767 2010 M Subtotal Patents 381,280 609,500 337,620 1,328,400 Accumulated Amortization 12/31/2013 381,280 441,888 59,084 882,252 Carrying Value 12/31/2013 0 167,612 278,536 446,148 >>>> Impairment Adjusted Carrying Expected Future Cash Loss Value 1/1/2014 Flow Undiscounted Yes/No 0 167,612 278,536 357,260 119,460 Note: The amortization method used by the client for patents is straight-line over 20 year Patents are considered limited life intangibles that require the use of both the recoverabil value test. Therefore, the amortization expense for 2014 needs to be reversed to properly value (i.e. book value) of the patents as of January 1, 2014. In addition, the client has calc undiscounted expected future cash flow for the two patents that are still under patent pro AJE 6B-2 Accumulated Amortization 47,356 Amortization Expense 47,356 M = Traced the authorization to purchase the patent and the purchase price to the Board o fe Intangibles) Expense 2014 0 30,475 16,881 47,356 Fair Value Test Fair Value Accumulated Amortization 12/31/2014 381,280 472,363 75,965 929,608 Carrying Value 12/31/2014 0 137,137 261,655 398,792 Calculated Impairment Loss Amount ight-line over 20 years. of both the recoverability test and the fair e reversed to properly show the carrying on, the client has calculated the still under patent protection. RP se price to the Board of Directors' minutes. Proli Footwear Amortization Schedule - Trademarks (Indefinite Life Intangibles - Other Than Goodwill) December 31, 2014 Accumulated Carrying Accumulated Year Amortization Value Expense Amortization Description Acquired Cost 12/31/2013 12/31/2013 2014 12/31/2014 Trademarks: PER BOOKS Dapper 2010 2,252,700 197,111 2,055,589 56,318 253,429 Leatherworker 1945 3,000 3,000 0 0 3,000 Litetech 1980 5,000 4,188 812 125 4,313 Mudhoppers 2012 2,641,800 99,068 2,542,732 66,045 165,113 Proli 1941 2,500 2,500 0 0 2,500 Sportech 2001 2,795,800 873,688 1,922,112 69,895 943,583 Woodland 2013 2,429,000 30,363 2,398,637 60,725 91,088 Subtotal Trademarks 10,129,800 1,209,918 8,919,882 253,108 1,463,026 >>> Adjusted Fair Year Carrying Value Value Description Acquired 1/1/2014 12/31/2014 Trademarks: PER AUDITORS 2010 M 2,055,589 Dapper 0 Leatherworker 1945 D 1980 M 812 Litetech Mudhoppers 2012 M 2,542,732 1941 D 0 Proli 2001 M 1,922,112 Sportech 2013 M 2,398,637 Woodland Subtotal Trademarks Impairment Calculated Loss Impairment Yes/No Loss Amount Note: The amortization method used by the client for trademarks is straight-line over 40 y The following trademarks were internally generated: Leatherworker and Proli; all other trademarks were acquired when Proli purchased other companies. Trademarks are classified as indefinite-life intangibles and require an annual fair value test to determine the lack or presence of impairment. Therefore, the amortization expense for 2014 needs to be reversed to properly show the carrying value (i.e. book value) of the trademarks as of January 1, 2014. RP AJE 6B-1 Accumulated Amortiz 253,108 Amortization Expe 253,108 M= Traced the authorization to purchase the company and the purchase price to the Board of Directors' minutes. D = Traced registration and legal fees to the cash disbursements journal. n Goodwill) Carrying Value 12/31/2014 1,999,271 0 687 2,476,687 0 1,852,217 2,337,912 8,666,774 traight-line over 40 years. DB-6 nd Proli; all other demarks are e test to ation expense for ook value) of the ase price to the Account Number Account Title Proli Footwear Lead Schedule - Intangible Assets December 31, 2014 Balance per T/B - - - - Adjustments - - - Debit Credit Debit Credit 1540 Trademarks 10,129,800 1542 Patents 1,328,400 1545 Goodwill 8,267,700 Accumulated Amortization: 1550 Trademarks 1552 Patents 1555 Goodwill 1,463,026 929,608 2,765,639 Amortization Expense: 7230 Trademarks 253,108 7232 Patents 47,356 7235 Goodwill 859,093 Other Accounts: 7900 Impairment Loss 0 Balance per Audit Debit Impact of AJEs for this assignment on client's net income before income taxes = DR/CR Proli Footwear Schedule - Intangible Assets December 31, 2014 Balance per Audit Credit